PROFESSIONAL SUMMARY:

• A detail oriented and result focused Mainframe Developer wif over 7+ years of experience in Mainframe and Data Warehouse applications and involved all phases of Software Development Life Cycle (SDLC) dat includes Analyzing, Designing, Developing, and Testing of data whilst creating useful and efficient visualizations and reports.
• Experience inSQL stored procedures, mainframe batch and online processes using COBOL, DB2, IMS, JCL, CICS for supporting Data Extraction, Transformations and Loading process, in a corporate business functionalities
• Expertise in implementing Business rules by creating complex Informatica mappings/mapplets, shortcuts, reusable transformations, tasks, sessions,workflows/workletsusingDesignerand Workflow Manager.
• Proficient in ETL processes of creating Source/Target definitions, building Mappings using various Transformations, creating and monitoring Sessions/Workflows.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge ofODBC, OLEDB, T - SQL, SQL, PL/SQLand scripting languages.
• Experience in Agile/Scrum methodologies (Project deliverables in Sprints).
• Highly motivated team player wif analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.
• Excellent communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

TECHNICAL SKILLS:

Packages & ETL Tools: Informatica Power Center in

Data Bases: Oracle 11c, DB2, Sybase, SQL, IMS

Languages: SQL, PL/SQL, COBOL, JCL,Aps.Net, UNIX Shell Scripting.

Methodologies: Agile, Waterfall

Operating Systems: Windows (All Variants), UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Mainframe Developer

Responsibilities:

• Involved in requirements gathering and analysis to define functional specifications.
• Responsible for designing and developing COBOL DB2, COBOL IMS programs to filter retailer data and transform based on teh Dsci given rules
• Designed and developed various batch jobs using SORT, JCL, COBOL IMS, COBOL DB2 to create automated processes to eliminate manual work performed by teh operation team and also job flow to satisfy business needs.
• Developed CICS screen to review and modify retailer data
• Designed and developed DB2 query to provide reports for validation
• Transfer final processed and aggregate data into teh Unix server using MFT transfer
• Done Code reviews ofmainframe batch and online processes.
• Worked wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Followed Agile methodology, participated in daily SCRUM meetings and testing each SPRINT deliverable.
• Created change request before code deployment into production to get required approvals from business.
• Created weekly project status reports, tracking teh progress of tasks according to schedule and reported any risks and contingency plan to management and business users.

Environment: Mainframe, COBOL, IMS, DB2, JCL, SQL, PL/SQL,Aps.Net,UNIX Scripting, Agile and Windows.

Confidential

Mainframe Production Support

Responsibilities:

• Involved in requirements gathering and analysis to define functional specifications.
• Involved in teh production support Sev4, Sev3, Sev2, Sev1 ticket analysis
• Analysis existing Mainframe jobs, SQL Stored Procedures, .Net and UNIX shell scripts to understand product issues raised by operation team and retailer team
• Responsible for code fix and enhance COBOL DB2, COBOL IMS programs to satisfy business needs
• Designed and developed various batch jobs using SORT, SAS, JCL to provide required reports
• Done Code reviews ofmainframe batch and online processes.
• Attended Incident management calls to provide SEV1 issues support and resolution
• Followed Agile methodology, participated in daily SCRUM meetings and testing each SPRINT deliverable.
• Created change request before code deployment into production to get required approvals from business.
• Created weekly project status reports, tracking teh progress of tasks according to schedule and reported any risks and contingency plan to management and business users.

Environment: Mainframe, COBOL, IMS, DB2, JCL, SQL, PL/SQL,UNIX Scripting, Aps.Net, Agile and Windows.

Confidential

ETL Developer

Responsibilities:

• Used teh Informatica Designer to develop teh new mappings as per teh requirement. There are different source systems and different project to pull data and making out teh reports for teh end users. Through ETL, all teh transformations, logics applied to meet teh expectation.
• Debug processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database
• Validated teh current production data, existing data and worked on data quality issues.
• Involved inmigration and implementationof Informatica code from development to Test and UAT and tan Production environment
• Debug teh ETL jobs to check in for teh errors and warnings associated wif each Job run
• Developed error handling & data quality checks in Informatica to pull out teh right data
• Working in Command Canter scheduler tool to automate teh jobs and monitor teh load.
• Performance tuning of SQL queries
• Developed scripts in PL/SQL to automate data reconciliation testing
• Performance improvement activities to improve run time of teh processes and reduce run window.
• Prepared abest practicedocument to use when designing Informatica parallel jobs to gain optimum performance by using appropriate partitioning techniques
• Helped new trainees of team to get acquainted wif Informatica and understand teh application
• Reviewing all teh deliverables and Ensuring timely and defect free delivery.

Environment: Informatica, Oracle, SQL, PL/SQL, UNIX and Windows..