SUMMARY

• Have 11 years of programming experience in the IT industry with 7 years of data warehousing (ETL) and software application development experience using Informatica & UNIX.
• Hands - on experience spanning solution architecture, System Design (HLD and LLD), Software development &, Enhancement, Maintenance, Testing and Support on Mainframe platform.
• ETL/Informatica Developer (using Informatica power center 9.1.0/ Informatica PowerCenter 9.6.1) with extensive experience in Data Modeling, Design & Development in Data warehousing and strong knowledge of data warehousing, including Extract, Transform, and Load Processes.
• Experience in developing Data warehouse & Data Marts
• Experience in DB2 LUW to Oracle 11g migration.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked with the Business Analysts on IDQ - Data Profiling, Data Validation, Standardization and Data Cleansing for the Oracle 12c data migration to rebuild and enhance the business rules.
• Also worked with Business Analysts to modify/enhance rules for physical/mailing addresses using IDQ -Address Validator.
• Worked with Business Analysts to maintain the Reference Tables used for standardization.
• Worked with the System DBAs for the Data Analysis and Dimensional Modeling for DB2 v8 and Oracle 12c migration.
• Excellent Project Management skills like Estimation, Planning, Execution, Control and Delivery (SDLC) and was responsible for all deliverables and worked on providing cost-effective solutions with help from Project Managers and in managing the life cycle of the work assignments (Capacity planning, Project Estimation, Project Initiation and Allocation through closure)
• Experience in Agile Methodology
• Experience in OLTP/OLAP System Study, Analysis E-R modeling and in Dimensional Data Modeling like star schema, snow flake schema, Fact and Dimension tables.
• Experience in using Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Good experience with Unix shell scripting and job scheduling using Cron
• Database experience using Oracle 12c/11g, DB2 8/10 and DB2 UDB v8 and knowledge in creating and managing Conceptual, Logical and Physical Data Models for DB2 for z/OS and DB2 UDB for UNIX.
• Created PL/SQL stored procedures, functions and triggers for editing and moving the data from staging area to data mart.
• Experience in Informatica Performance tuning and Database Performance tuning
• Worked on the multiple projects involving the cross-platform development and testing (Mainframe, Unix, Informatica, Java and .Net), SQL, PL/SQL, DB2 UDB, DB2 LUW and Oracle 11g/12c.
• Effective in communicating technical concepts, finding the simplicity in complex business structures and integrating end user needs into system requirements.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center Client 9.1 and 9.6 DesignerWorkflow Manager, Workflow Monitor, Repository Manager Informatica IDQ 9.1

Languages: SQL, Shell Scripting, COBOL, JCL

Operating System: UNIX, Linux, zO/S

Databases: Oracle 12/c11g, DB2 v8/10, DB2 UDB v8

Tools: & Miscellaneous: CA-PLATINUM, FILE-AID, INSYNC, SPUFI, QMF, DUMP MASTER, RDz, INTERTEST, ChangeMan, SUPERCE, SDSF, CA-View (Production Deallocations) and XPEDITER/TSO, Insync, RMS, SYNCSORT for z/OS, FTP, SAVR$, Control-D, Control-M, STRUCISS, RDz, RMS, Endevor, ChangeMan, Cron, JobTrac, Control-M, Visio, ER Studio

Change/Incident Management: Remedy, HP Service Manager and Peregrine

Project Management: SDLC models, Agile, MS Project, Project SchedulingCost and Time Estimation, Requirement and Business AnalysisQuality Assurance

Project Management Tools: Rally

PROFESSIONAL EXPERIENCE

Confidential, Moline, IL

IT Analyst

Responsibilities:

• Involved in the process design documentation of the Data Warehouse Dimensional Modeling
• Designed and developed complicate ETL mappings using Informatica PowerCenter 9.1.0 and IDQ.
• Implemented the Agile Methodology for all the work efforts and document sprint-associated deliverables.
• Acted as Scrum Master for the team.
• Analyzed business requirements to identify business rules and develop technical specifications
• Collaborated with the business analysts to develop and implement technology solutions
• Involved in Data Analysis and Dimensional Modeling
• Worked on DB2 LUW to Oracle 12c migration - worked on Data Modelling, Application Redesign and Performance improvement.
• Worked on Data Quality to ensure same semantic is applied on incoming data and used across all the data marts in the Enterprise-wide Data Warehouse.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Conducted performance testing on the ETL code.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Supported and involved in detecting the nature of the failure in question, isolating the cause of the failure and determining options for fixing it
• Actively involved in communicating with the Business Systems analysts to ensure that changes made to the code where applied in a manner consistent with the needs of the business that we intended to support
• Monitored performance reports from database and ETL tools server log to further consider process enhancements and tunings.
• Support the development team in code reviews and defect tracking

Confidential, Moline, IL

IT Analyst

Responsibilities:

• As a functional expert, involved in requirements gathering with Functional Owners, Downstream application teams and external service providers.
• Involved in the process design documentation of the Data Warehouse Dimensional Modeling
• Designed and developed complicate ETL mappings using Informatica PowerCenter 9.1
• Implemented the Agile Methodology for all the work efforts and document sprint-associated deliverables.
• Acted as Scrum Master for the team.
• Analyzed business requirements to identify business rules and develop technical specifications
• Collaborated with the business analysts to develop and implement technology solutions
• Involved in Data Analysis and Dimensional Modeling
• Implemented Type 1, Type 2 Slowly Changing Dimensions.
• Worked on Data Quality to ensure same semantic is applied on incoming data and used across all the data marts in the Enterprise-wide Data Warehouse.
• Conducted performance testing on the ETL code.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Supported and involved in detecting the nature of the failure in question, isolating the cause of the failure and determining options for fixing it
• Actively involved in communicating with the Business Systems analysts to ensure that changes made to the code where applied in a manner consistent with the needs of the business that we intended to support
• Monitored performance reports from database and ETL tools server log to further consider process enhancements and tunings.
• Support the development team in code reviews and defect tracking

Confidential, Bloomington, IL

Senior Informatica Developer and Team Lead

Responsibilities:

• As a functional expert, involved in requirements gathering with Functional Owners, Downstream application teams and external service providers.
• Designed and developed complicated ETL mappings using Informatica PowerCenter 9.1.0 and 9.6.1
• Implemented the Agile Methodology for all the work efforts and document sprint-associated deliverables.
• Acted as Scrum Master for the team.
• Work Order (non-Projects) life cycles: Initiation to Closure and implemented SDLC phases for certain projects and documented phase-associated deliverables.
• Analyzed business requirements to identify business rules and develop technical specifications
• Collaborated with the business analysts to develop and implement technology solutions
• Involved in Data Analysis and Dimensional Modeling
• Worked on Data Quality to ensure same semantic is applied on incoming data and used across all the data marts in the Enterprise-wide Data Warehouse.
• Worked on Informatica 9.1.0 to Informatica 9.6.1 migration.
• Worked on DB2 v8 to Oracle 12c migration - worked on Data Modelling, Application Redesign and Performance improvement.
• Performed the Data Profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked with the Business Analysts on Data Validation, Standardization and Data Cleansing for the Oracle 12c data migration to rebuild and enhance the business rules.
• Worked with the System DBAs for the Data Analysis and Dimensional Modeling for DB2 v8 and Oracle 12c migration.
• Conducted performance testing on the ETL code.
• Worked with PL/SQL stored procedures, functions and triggers for editing and moving the data from staging area to data mart.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Supported and involved in detecting the nature of the failure in question, isolating the cause of the failure and determining options for fixing it
• Actively involved in communicating with the Business Systems analysts to ensure that changes made to the code where applied in a manner consistent with the needs of the business that we intended to support
• Monitored performance reports from database and ETL tools server log to further consider process enhancements and tunings.
• Worked on the multiple projects involving the cross-platform development and testing (Mainframe, Informatica, Java, DB2)
• Third Party Relationship Oversight (bridge between team, Client and third party vendors) and External Network Connectivity (for data transfer)
• Support the development team in code reviews and defect tracking
• Maintenance and Support for the project.
• Remodeled legislative processes to fine-tune performance and accurately report financial data

Confidential, Schaumburg, IL

Senior Informatica Developer and Project Lead

Responsibilities:

• Managed a team of 18 people and 11 applications.
• Work Monitoring for the resources, resource management, planning and allocation and Co-ordination between Offshore, Onshore and Competitors
• Analyzed and reengineered the legislative submissions for Risk Management Reporting resulting in significant performance improvement (CPU, storage and code reuse) and financial savings.
• Remodeled the UNIX database and ETL architecture to efficiently load the databases using the system and user-defined functions
• Designed and developed ETL mappings as per the requirements
• Involved in maintaining and supporting DWH Downstream Systems
• Developed and maintained downstream data mart.
• Developed reusable ETL transformations and Mapplets
• Involved in Data Modeling the staging, intermediate and target models of Downstream Systems
• Designed facts and dimensions to implement SCDs
• Performed Query Tuning and ETL Mapping tuning to increase performance
• Involved in writing shell scripts on Unix for Informatica ETL tool and data validation
• Maintained and supported both Staging (Mainframe and UNIX) and Production (UNIX) environments.
• Used cron and Jobtrac to schedule the Informatica workflows.
• Used SQL queries to perform backend testing on the database
• Embedded SQL queries within the ETL processes to facilitate easy transfer of data
• Written backend sql scripts to automate the data testing after the loads
• Involved in Production support for the downstream application loads, Monitored the loads using PowerCenter Workflow Monitor
• Created parameters and variables for the reusable sessions. Created Email task, Decision task
• Conducted Informatica Knowledge Sharing sessions with other team members
• Created Test plans and Test cases in all phases such as Unit, System, Integration and User Acceptance
• Worked are a cost-effective solution architect in determining the modification/impacts to the system infrastructure/framework and solutions to the business requirements.
• Worked with Business users and analysts to determine business and technical requirements and translating them to design (high and low level) and work with Project Managers for cost-estimation Technical Design (HLD and LLD) of the Mainframe components of the project (especially Cobol, JCL, DB2 and CICS specifications)
• Extensively used Syncsort for z/OS for efficient data processing (sort/merge/join) for the Mainframe files from upstream systems and external vendors
• Restructured job schedules and redesigned code for significant performance gains.
• Third Party Relationship Oversight (bridge between team, Client and third party vendors)
• External Network Connectivity (for data transfer)

Confidential

Software Engineer

Responsibilities:

• Development and analysis of the specifications provided by the clients.
• Analysis of requirements provided by the clients
• Was responsible for production monitoring and fixing abends.
• Coding and Testing of modules related to my application.
• Maintenance and Support for the project.
• Designed and worked on Cobol modules
• Modified CICS online screens and then implement the screens, new business rules in mainframes
• Worked on creation of new PROC's & JCL's
• Performed extensive system testing and migration into production
• Preparation of Test Plans and Test Cases.
• Conducted walk through on all proposed changes, interviews with users concerning all modifications and impact analysis.
• Ran LOAD utilities to refresh test database data from production region.
• Debugging and troubleshooting any technical issues while implementing the applications
• Communicate progress, test results to the stakeholders. Status reports preparation and coordination.
• Knowledge transfer to new entrants and updated application documentation