SUMMARY:

• Informatica Developer with 4+ years of experience on Business Requirements Analysis, Application Design, Development, Testing, Implementation and Maintenance of client/server Data Warehouse and DataMart systems in Finance and Pharmaceutical Industries.
• Extensive knowledge on Informatica Developer tool, design and development of mappings and workflows for Data Quality Analysis.
• Extensively used Informatica Analyst to create Business rules based on the end - user requirements.
• Developed various dashboards for financial and clinical trial data visualization using Tableau Desktop.
• Extensively used Data Blending to create Tableau workbooks from multiple data sources.
• Created and developed processes to restrict the data for particular users using Row Level securities.
• Extensively used Cognos and Excel to create regulatory medical reports on quarterly basis.
• Responsible for creating and maintenance of Functional Design and Requirement Specification Documents for all project releases.
• Experienced using Informatica Monitoring Console for monitoring workflows and checking logs.
• Proficiency in using Informatica Power Center tool to design data conversions and ETL procedure to load data from various sources into data warehouse (Repository Manager, Designer, Workflow Manager and Workflow Monitor)
• Good Knowledge of reporting tools like Spotfire, Business Objects and building BO Universe.
• Experienced in performing Unit Testing and UAT, writing complex SQL queries to implement Test Cases manually and documenting the validation Reports.
• In-depth understanding of Data Warehousing concepts, Relational Database Management System and Dimensional Modeling.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using primary and Foreign Keys.
• Ability to solve complex technical problems and have unique ability to understand long-term project development issues at all levels and interpersonal skills with strong desire to achieve specified goals within the given time frame.

TECHNICAL SKILLS:

Informatica Suite: IDQ, IDS, PowerCenter, Analyst, Administrator, Monitoring Version 10.x

Databases: Oracle 10g/11g/12C, SQL Server 2008/2012/2014

Querying Tools: Oracle SQL Developer, SQuirreL SQL, SQL Toad

BI Tools: Tableau, Cognos, Spotfire, SSRS

Programming: C, C++, JAVA, PHP, UNIX shell scripting

Methodologies: AGILE, SDLC

Testing Tools: HP ALM

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Collaborated with Project Managers and Solution Architects in designing the technical architecture for Data Quality Monitoring Solution.
• Identified Critical Data Elements within the database, designed and developed Business Rules to measure data quality for clinical trial analytics data.
• Extensively used Informatica Developer tool for creating mappings and workflows, implementing the Business Rules.
• Analyzed the project requirements to modify the mappings which feeds data to end user reports.
• Created applications for workflows and deployed them to the server on a monthly basis as a part of maintenance cycle.
• Responsible for triggering the workflows using INFACMD commands for loading the data.
• Solved various issues incurred while importing the Physical Data Objects into the Repository.
• Responsible for creating test cases for Unit Testing and Documentation of the validation reports for all the Business Rules.
• Extensively used Oracle SQL Developer to write SQL Queries for implementing test cases.
• Developed complex SQL Queries to trouble shoot the data errors for each business rule in the FACT tables.
• Performed analysis profiling on existing data and identify root causes for data inaccuracies, Impact Analysis and recommendation of Data Quality.
• Designed a Low-level Technical Specification Document to define the dimensions for all the Business Rules.
• Created high level design documents RS and FD, uploaded the requirements into the DOC IT and HP ALM
• Created complex Medical Study Reports in MS Excel using V-lookup, H-lookup for medical dashboards
• Designed and Developed Traceability Matrices for various projects to verify the requirements met in the applications.
• Re-designed the entire data-source feeding into Tableau to improve the dashboard performance, applied user restrictions and data securities to the dashboards.
• Responsible for leading the report triage meetings to address adhoc requests and tracking tickets’ progress.

Informatica ETL Developer

Responsibilities:

• Analyzed the business requirements to develop ETL logic using Informatica Powercenter 9.5
• Based on the source to target mappings document provided by business analysts and analysis of current application, designed ETL transformation to rewrite in Informatica
• Integrated the data from various data sources such as Oracle, DB2 and flat files, applied Slowly Changing Dimensions Type I and Type II on business requirements.
• Fine-tuned ETL processes by considering mapping and session performance issues, responsible for Creating workflows and worklets.
• Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Extensively worked on performance tuning and also in isolating header and footer in single file.
• Developed SQL Queries and stored procedures in support of ongoing work and application support.
• Designing and executing test scripts and test scenarios, reconciling data between multiple data sources and system.
• Project planning and scoping, facilitating meetings for project phases, deliverables, escalations and approval. Ensure adherence to SDLC and project plan.
• Performed What-If Analysis in Excel to try out different scenarios for formulas
• Precisely documented mappings to ETL Technical Specification document for all stages for future reference.

Data Analyst

Responsibilities:

• Precisely documented mappings to ETL Technical Specification document for all stages for future reference.
• Studied in-house requirements for the Data warehouse to be developed.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards for data warehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Extracted data from Database (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Extracted significant, detailed data set using pivot tables in Excel.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation.