SUMMARY

• 10+ years of experience in IT Industry involving Software Analysis, Design, Implementation, Coding, Development, Testing and Maintenance with focus on Data warehousing applications using ETL tools and Informatica.
• Expertise in Power BI development with a proven track record in BI, Data Warehouse (DWH) and Data Analytics.
• Expert in Cerner Command Language (CCL) in creating extracts, reports, Pharmacy Labels.
• Extensive experience on Informatica 10.2/10.1/9.6 /9.5/9.1 , PowerCenter, Data Quality (IDQ), Metadata Manager, Master Data Management, Power Connect Enterprise level Architectural Designing, System Configuration, Installation, Administration.
• Utilized Power BI to create various analytical dashboards that depict critical trends along with slicers and dicers enabling end - user to make filters.
• Architected Extracting 6+ millions of records with heavy transformations and successfully loaded them under 2 hours into Target DB.
• Successfully loaded data from 6 different source systems into the OLAP system. Staged over 500+ tables with minimal issues.
• Migration (Deployment, Export/Import) of Objects from lower environment to production.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Created Power BI report to identify bottleneck in process as Lean Champion.
• Experience with developing a shared vision/roadmap of business integration strategy using leading Integration tools from Informatica to Mainframe, SAP & PeopleSoft for business analysis involving SQL Server, Oracle, Teradata and XML Sources.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Skilled in Oracle Database, CCL, SAP Web Intelligence Reports, and Data Warehousing.
• Strong engineering professional with a Master of Science (MS) focused in Computer Software Engineering from Stratford University.
• Excellent understanding of ETL Process and Ware housing Standards focusing on BI.
• Wrote complex SQL queries in extracting, manipulating data and transform into Business Intelligence reports using SAP Business Objects (SAP Web Intelligence 4.x).
• Experience in integration of heterogeneous data sources like Oracle, VSAM and Flat Files (Fixed & delimited) into Staging Area.
• Worked with stakeholders like Clinicians, Physicians in designing and developing Clinical, Financial, and Regulatory Reports.
• Expert in Cerner Command Language (CCL) in creating extracts, reports, Pharmacy Labels.
• Created more than 1000 test cases for Service Request Project using Python thereby saving more than 40 hours of work.
• Maintain Disaster Recovery (DR/BCP) Plans, Coordinate Execution activities related to platform maintenance, Disaster Recovery (DR/BCP) and Software release management.
• L3+ escalation for Platform Issue resolution, troubleshooting and root cause analysis.

TECHNICAL SKILLS

ETL Tools: Informatica 10.2/10.1/9.6 /9.5/9.1 , Data Quality (IDQ), High Availability (HA), Integration Service, Data Analyzer.

Languages: CCL, PL/SQL, SQL, Python, AWK, Perl, Shell.

OS: Unix, Linux, and Windows.

Database: Oracle 12c/11g, SQL Server 2016/2014, Vertica, Teradata 15.10, Elastic Search and MS Access.

Tools: Power BI, Oracle Enterprise Manager, SAP Business Objects (WebI, IDT, UDT).

Project Management: Agile, Lean, Atlassian Jira, Matrix Prj Planning, MS Office, Scrum, Resource Allocation

PROFESSIONAL EXPERIENCE

ETL Informatica Lead/Power BI Lead

Confidential

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 10.2.
• Extensively used ETL Informatica for the Extraction, Transformation and Load of source data which was from Oracle, DB2 and Flat Files containing more than 500 tables.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Using Cerner Command Language (CCL), created csv extracts for third party consumptions.
• Generated ExplorerMenu Reports, DA2 queries/reports and Pharmacy Labels in CCL.
• Manage the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Extensively used various Informatica active and passive transformations like Filter Transformation, Router.
• Informatica System Level Monitoring and Alerting, Capacity Planning (CPU, Memory, Loads (sessions), I/O, etc). using Monitoring tools to proactively increase System Capacity as needed.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in multiple environments.
• Improved session Performance in Informatica by enabling property incremental aggregation to load incremental data into target table.
• Responded to specific BI requests from clinical personnel, creating data cubes with requested information in easily understandable formats.
• Configured on-premises Power BI gateway for different source matching analysis criteria and further modeling for Power Pivot and Power View.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Collaborate with leadership team in improving overall team process to enhance code quality and lower turnaround time using Lean Process.
• Led sprint reviews, daily scrums and planning meetings using Atlassian Jira to realize full team engagement.
• Responsible for Release migration in between different environments.

ENVIRONMENT: Informatica Power Center 10.2/10.1/9.6 , Data Quality (IDQ), Workflow manager, Oracle 12c, SQL, Power BI, Elastic Search, Python, CCL, and SAP Business Objects 4.2.

ETL Developer

Confidential - Dublin, OH

Responsibilities:

• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Reduced TAT in testing from 5 hours to 10 minutes by using MS Access DB for automated data validation.
• Developed team communications and information for daily offshore meetings.
• Worked on Informatica Power Center, Informatica Power Exchange for Metadata Analysis.
• Worked on various sourcing platforms i.e. Oracle, Teradata, SQL Server, DB2 mainframe to design & create SQLs.
• Extensive experience in Oracle, DB2 & Teradata to be able to write complex queries to evaluate data.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations Designing, creating and tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to dimensional models.
• Collaborated with Project Manager in planning and resource allocation using Atlassian Jira.
• Automated unit testing and code reviews using Python to ensure high quality of code delivered.

ENVIRONMENT: Informatica Power Center 9.1/9.5, Oracle 10g, SQL, Python, CCL

Power BI Developer

Confidential

Responsibilities:

• Participated in the assessment of customer requirements, determine technical feasibility and document results.
• Draft technical specifications based functional requirements.
• Developed reporting application based on company design standards.
• Perform tests according to a given test plan and document the results. Assist in the creation and enhancement of design and development standards.
• Developing stored procedures and database triggers and used user exits and PL/SQL interfaces to access foreign functions.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.

ENVIRONMENT: Informatica Power Center 9.1/9.5, Oracle 10g, SQL, Python, CCL