SUMMARY

• Sound ETL Informatica Developer wif over 7+ years of experience in Business Intelligence, Data Warehousing Implementation, Project management, system development.
• Experienced in all phases of Software Development Life Cycle (SDLC) from Planning, Requirement Gathering, Analysis, Designing, Implementation, Testing and maintenance of completed project using SDLC methodologies, like Waterfall, Agile (Scrum)
• Solid experience wif ETL process and Data Warehousing.
• Experienced creating source definitions using Informatica power center source analyzer
• Created numerous target definitions wifin Informatica power center target designer
• Expertise in designing and developing complex mappings and transformations in Informatica Power Center mapping designer.
• Developed several reusable and non - reusable sessions wifin Informatica Power Center Workflow Manager. created simple to complex SQL and PL/SQL queries in Oracle SQL developer
• Solid experience in developing various Data Warehouse concepts, data marts, schemas
• Good communication and presentation skills, I am a self-motivated individual and excellent team player.

TECHNICAL SKILLS

Operating Systems: LINUX/UNIX, Windows, Windows server, Mac.

Project Methodologies: Waterfall, Agile (Scrum)

Scheduling Tools: Automic (Appworx), Autosys, Control-M

MS office tools: Microsoft Visio, Microsoft Project, Microsoft SharePoint, Microsoft Excel, Microsoft Outlook.

Project Tracking Tool: JIRA, HP ALM, Version One

Database: Netezza, Teradata, Oracle Database, MS SQL Server, DB2 Integration and Reporting tool Informatica BDM, Informatica PowerCenter, Talend, SAS,R, SSIS, SSAS, SSRS, OBIEE.

Testing Application/Tools: HP Application Lifecycle Management (ALM), HP Quality Centre (QC)

Modeling Tools: Erwin, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

ETL Informatica developer/Scrum Master

Responsibilities:

• Schedules and facilitates all scrum ceremonies including Daily Stand-up meetings, Scrum meetings, Retrospectives and Sprint Planning
• Update records using teh Slowly Changing Dimension TYPE 1 and 2, and ensured all records wifin teh data warehouse are up-to-date and important history is maintained.
• Translates SQL code into Informatica mapping for scalability and maintainability
• Performs complete mapping to meet business requirements
• Adheres to Informatica naming convention in all object definitions and ensured Informatica standards are maintained.
• Develops several Appworx/Automic models for complete job process scheduling
• Frequently used SQL queries to filter data wifin teh Oracle/ Netezza databases for detail data and project analysis
• Performs extensive debugging to identify mapping bottlenecks
• Studies teh session logs extensively to determine causes and potential solutions to workflow bottle necks.
• Performed extensive Informatica performance tuning on existing workflows for maximum process improvements
• Creates and maintains detailed reports and project documentation as required
• Performs extensive Unit Testing, Regression Testing and User Acceptance Testing to ensure developed projects meets business requirements
• Continuously provides helping hands to other developers on development issues as needed
• Performs peer code review for projects developed by other developers

Confidential, Ellicott City, MD

ETL Informatica Developer

Responsibilities:

• Managed Data Migration, Data Integration, Cleansing, Extraction, Transformation and Loading process for data of disparate data sources to ensure High level of data integrity is maintained.
• Scheduled and facilitated all scrum ceremonies including Daily Stand-up meetings, Scrum meetings, Retrospectives and Sprint Planning meetings
• Modified existing target definition and created target table to meet project requirements.
• Used source analyzer to define and input source definition to satisfy business needs.
• Adhered to Informatica naming convention in all object definitions and ensured Informatica standards are maintained.
• Performed complex mapping wif several numbers of transformation or by taking SQL override code and translating it using Informatica utility tools and achieved high performance of workflow.
• Performed extract, transform, and load (ETL) solutions for data warehousing using Teradata and Informatica
• Performed performance tuning by clearing cache
• Updated records using teh Slowly Changing Dimension TYPE 1 and 2, and ensured all records wifin teh data warehouse are up-to-date and important history is maintained.
• Developed complex mappings using various transformations like aggregator, union, joiner, router, connected/unconnected lookups, stored procedure, expression, filter, sorter and update strategy, to satisfy business requirements and managed errors when necessary
• Filtered rows in Informatica using teh Filter Transformation and Source Qualifier Transformation.
• Implemented complex business rules in Informatica by creating re-usable transformations and Mapplets
• Improves teh performance of Aggregator Transformation by sorting teh records before passing to teh Aggregator.
• Successfully implemented numerous performance improvement techniques to optimize process performance
• Updated records in target tables wifout using teh update strategy by defining teh key in teh target table and then connecting it to teh field to be updated in teh mapping target.
• Utilized teh debugging option to identify whether mapping is correct or not wifout connecting sessions.
• Participated in JAD sessions wif subject matter experts, users and other stakeholders to refine functional requirements.
• Frequently used SQL queries to filter data wifin teh Oracle database and created data profiling document.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures dat were cost TEMPeffective and met business requirements.

Confidential

Business Data Analyst Consultant

Responsibilities:

• Gatheird user and business requirements through interviews wif open-ended discussions, brainstorming sessions and other requirement gathering strategies
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using teh UML methodologies.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions wif management, development team, users and other stakeholders to refine functional requirements.
• Performed Data mapping, logical data modeling, created class diagrams Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Frequently used SQL queries to filter data wifin teh Oracle database and created data profiling document.
• Scheduled meetings wif developers, System Analysts and testers to collaborate resource allocation and project completion.
• Managed workload, schedules and coordinated status review meetings wif project managers, business managers and team members to ensure dat project deadlines are met at all times.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Created teh Data Mapping Document to specify teh Data mapping from various data sources to teh target database
• Experienced in performing System Reengineering/Gap Analysis to check teh compatibility of teh existing system infrastructure wif teh new business requirements.
• Strong experience creating Test Plan and Test Cases and participated in User Acceptance Testing (UAT).
• Experienced creating and modifying Informatica workflow and Worklets
• Experienced in Data migration, Data extraction, Data cleansing, Data profiling and Data quality and Data Mining.
• Supported reporting and analysis requirements from various stakeholders wifin teh organization.
• Carried out complex data analysis in support of management requirements.