Home

Amit Kumar - ETL Developer

[email protected]

Location: Cleveland, Ohio, USA

Relocation:

Visa:

Amit Kumar [email protected] PROFESSIONAL SUMMARY A highly motivated, analytical, and dedicated Lead Software Developer who holds a Bachelor’s in Computer Science with 11+ years of experience business intelligence and data warehousing spanned across the banking and financial domain. Develops and maintains regulatory reports such as FFIEC101, HCR-RCR, GL reconciliation, and balance sheet reports. Expertise in developing tableau visualizations, building customized interactive reports, and report scheduling using tableau desktop and server expertise. Possesses in depth technical knowledge of ETL application development, including Informatica, throughout the design phases. CORE COMPETENCIES ● Computer Science ● Software Development ● Data Collection & Analysis ● Data Modeling ● Data Warehousing ● BI Report Development ● Dashboard Development ● Fact & Dimension Tables ● Agile & Waterfall Methodologies TECHNICAL SKILLS  OLAP Tools/Business Intelligence Software: OBIEE 12c/11g/10g, (Certified), BI Publisher 12c/11g/10g, Tableau  ETL Tools: Informatica Power Center 10.4,10.2, 9.6  Database: Oracle (12c, 11g, 10g), SQL Server, My SQL, Teradata  Data Modeling Tools: SQL Developer, Toad  Scripting Languages: PL/SQL, Unix Shell Scripting  Deployment: uDeploy, GIT, Artifactory  Other Tools: Putty, WinSCP, Service Now, Jira WORK/PROJECT EXPERIENCE TCS - PNC Financial Services Group | Cleveland, OH Nov 2016 - Present Informatica, OBIEE, & Tableau Lead Developer Project: Risk Portfolio - Regulatory Reporting  Responsible for ETL application development using Informatica Power Centre  Oversee the development of Tableau visualizations, building and publishing customized interactive reports, and the development report scheduling using Tableau desktop and server  Accomplish all tasks related to advance analysis, actions, calculations, parameters, maps, trend lines, and statistics  Create groups, hierarchies, and data sets to develop summary level and detailed reports  Employ Tableau best practices formulating reports, developing SQL queries and creating advanced Tableau dashboards  Perform code review of all the ETLs, unit test case documents, design, IQA, and EQA documents completed by team with proper review checklist  Ensure defect prevention and causal analysis activities  Support project management duties including requirement gathering and analysis for new source system and change in existing with data analyst and data modular with Agile (Scrum) methodology  Create action filters, parameters, LOD, sets, groups, and calculated sets for preparing Tableau dashboards and worksheets  Work across development/testing, deployment, and project teams to ensure continuous operation of build and test systems  Conduct the automation of Deployment of Informatica and OBIEE components using GitHub and IBM uDeploy  Responsible for the design, implementation and quality management of reports created using OBIEE and Tableau for multiple LOBs and their data warehouse  Responsible for designing OBIEE 12c RPD as per the business model  Perform data validation of OBIEE reports building, publishing customized interactive reports and dashboards, report scheduling using Tableau server  Setup user level security by assigning application roles and setting up group level security via enterprise manager  Work on hierarchies, drill down reports, drill through reports and navigation using ‘Action Links’  Collaborate with cross functional and leadership on setting and maintaining development and documentation standards which includes writing or updating code documentation, implementation instructions and integration tests for applications  Responsible for validating change requests and coordinating with respective teams in production  Perform PRE-PROD and PROD implementation reviews of deliverables and provide sign off  Develop complex mapping using unconnected lookup, aggregator, and update strategy transformation in informatica power center designer TCS - PNC Financial Services Group | Pune, India Oct 2011 - Oct 2016 Informatica & OBIEE Developer Project: Counterparty Credit Risk Reporting  Responsible for ETL application development using Informatica Power Centre  Conducted performance tuning of long running queries of existing applications  Provided project support by being involved in data analysis and defect prevention activities  Designed the OBIEE 12c RPD as per the business model as well as reviewed OBIEE RPD, reports, and dashboards  Built repository at all 3 layers including for physical, BMM, and presentation layer  Performed data validation of OBIEE Reports and interacted with business users to analyze the requirements  Built repository at all 3 layers including physical, BMM, and presentation layer  Responsible for creating Unix Shell Scripts  Involved in peer review of ETL components and test results prepared by other team members  Performed PRE-PROD and PROD implementation reviews of deliverables and provide sign off  Validate the change requests and coordinated with respective teams in production deployments  Demonstrated knowledge of warehouse concepts and principles including IBM Basel-II, Star Schema, and Snowflake along with SCD concept EDUCATION S‘O’A University | Orissa, India Graduated: 2011 Bachelor of Technology Specialized in Computer Science CERTIFICATIONS  Oracle Certified OBIEE Developer - OBIEE 11g  Tableau Desktop Specialist  Tableau Certified Associate  Tableau Data Analyst  AWS Certified Cloud Practitioner  AWS Certified Solutions Architect - Associate Keywords: business intelligence