SUMMARY

• Possess 8 Years 6 Months of extensive hands on IT industry experience in Application Development, Maintenance, Testing and Production Support projects involving end - to-end Project Life Cycle, complete Software Development Life Cycle (SDLC), Waterfall, AGILE.
• Widespread experience in handling Requirement Gathering, Analysis, Core Application Design, Code Development, Implementation, Testing, Integration, Deployment, Documentation and Maintenance/Production Support of ETL, Unix, PL/SQL, IBM Mainframe applications.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Teradata, Flat Files, Mainframes, XML files into Data Warehouse using Informatica PowerCenter tools and SSIS.
• Having hands on experience in writing queries in Databases like Oracle, DB2, SQL Server, Teradata.
• Having experience in gathering user requirement and writing Native SQLs for the BI reporting tools like, COGNOS.
• Experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes.
• Having Past experience as a Mainframe developer, having hands-on experience in developing COBOL, JCL components and DB2 stored procedures.
• Experience in using UC4, ESP, CA7, CA-DE scheduling tools to organize and schedule jobs.
• Possess the ability to multi-task work across different applications. Diverse work experience with different functionalities of the application, with Development and Production Support projects
• Significant experience working in agile development projects with acquaintance of working on ServiceNow, Quality center, SharePoint, JIRA. Involved in estimate planning, design discussions and scrum meetings for the project
• Experience in using HP Quality center to track defects and document test cases for functional testing and System Integration Testing.
• Experience in project management, estimations, and resource management activities.
• Driven Idea campaigns within teams to bring forth ideas on to the table for business improvement.

TECHNICAL SKILLS

Primary Skills: Data warehousing, ETL, Data modeling, SQL

ETL tools: Informatica, SSIS

BI Reporting tools: COGNOS

Languages: SQL, PL/SQL, Unix Shell Scripting, COBOL, JCL

Platforms: IBM Mainframe Z/OS, Unix, Windows

Databases: Teradata, Oracle, SQL server, VSAM, DB2

Software: SQL developer, Oracle Toad, SQL Server studio, Teradata SQL assistant, IBM Data Studio, WinScp, FileZilla, Putty, FILE-AID, CA-7, ESP, UC4, CA-DE Scheduling, Clearcase, ERWin, Visio, ServiceNow, Sharepoint, MS Office, HP Quality Center, JIRA

Domains Worked: Retail, Supply chain

PROFESSIONAL EXPERIENCE

Confidential

BI ETL Lead - Informatica/Teradata/COGNOS

Responsibilities:

• Designated owner and accountable for major issues and took responsibility for actions and outcomes to ensure timely and cost-effective results for our team.
• Coach new team members on technical tools such as Informatica Designer, Workflow Manager, Workflow Monitor and Power Exchange.
• Set and follow Informatica best practices, such as creating shared objects in shared for reusability and standard naming convention of ETL objects, design complex Informatica transformations, mapplets, mappings, reusable sessions, worklets and workflows.
• Gathered user requirement and writing Native SQLs in databases like Oracle, DB2, Teradata for the BI reporting tools like, COGNOS.
• Evaluate business requirements to come up with Informatica mapping design that adheres to Informatica standards.
• Implement performance tuning on a variety of Informatica maps to improve their throughput.
• Work with peers from various functional areas to define IT wide processes like code reviews, unit test documentation and knowledge sharing sessions.
• Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.
• Conduct weekly team conference call with all onsite and offshore resources to review project status, discuss issues, share information, and promote teamwork.
• Analyze data and identify gaps in the Applications, make recommendations for resolving gaps and Provide Service improvement to minimize the human effort.
• Automate the process by writing Unix shell scripts and PL/SQL scripts.
• Review the deliverables and present it to clients.
• Provided estimates for all projects.,
• Involved in Resource management activities.

Confidential

ETL/SQL developer - SSIS, SQL Server

Responsibilities:

• Design, develop and maintain effective solutions to support data migration.
• Managed end-to-end complex data migration, conversion and data modeling.
• Created DTS packages for transforming data from various data sources.
• Discussed DB requirements and mapped data as per the need and created data models and Tables accordingly.
• Designed and executed Data Migration plans with Integrity and Data quality.
• Planning and delivering of complex data migration from Legacy systems to SQL server using SSIS packages and SQL commands.
• Developed SSIS packages to transfer data from OLTP to OLAP Databases with different types of control flow tasks, data flow transformations and deploying the packages to Production server.
• Worked on ETL processes capable of Data loading, Data cleansing, Data Validation.
• Developed data models in SQL server environment, corresponding to VSAM/Cobol files received from mainframe systems.
• Tuned SQL queries using execution plans for better performance.
• Scheduling the ETL jobs using scheduling tools UC4, CA-DE.
• Monitoring, debugging and tuning ETL jobs and workflows.
• Write Maintain technical and user documentation related to the project.
• Serve as back-up for business system support as needed
• Maintains and protects confidential data with utmost scrutiny, judgment, and care. All confidential data files were tokenized and handled with care.
• Co-ordinate with Testing team and Users for System integration testing, User Assurance testing.

Confidential

ETL/SQL developer - Informatica, SQL

Responsibilities:

• Extracted data from Oracle, SQL Server, DB2, cobol, VSAM files using Informatica to load it into a single data warehouse repository.
• Worked on Informatica power center client tools like Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Worked on Informatica power exchange to create Data mapping
• Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Performance tuning by session partitions, dynamic cache memory, and index cache.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Extensively worked on various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Created entity relationship diagrams and multidimensional data models using ERWin.
• Developed complex SQL queries, and perform execution validation for remediation and Analysis.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed workflow tasks like Email, Event wait, Event Raise, Timer, Command and Decision.
• Involved in scheduling the workflows through ESP Job scheduler using Mainframe Procs.

Confidential

Mainframe Developer

Responsibilities:

• Analysis and Understanding the requirements & functional specifications.
• Preparation of TS (Technical Specifications) based on the existing functionality and requirements. Prepared Functional Specification Documents (HLD, LLD)
• Prepared Business Flow Diagrams (VISIO)
• Developed new JCL jobs and procedures and execute them in newly created job streams with the COBOL batch programs developed in order to test customer’s production data
• Developed JCL jobs to execute most of the routine IBM utilities like IEFBR14, IEBGENER, IDCAMS, IEBCOPY, IKJEFT01, SORT, ICETOOL, etc.,
• Monitor job execution and analyze output of jobs through SDSF to identify the job flow and the reason for the abend
• Developed new DB2 Stored Procedures which get called directly from Front End Java application and passes business user’s application data back to the GUI work experience on large scale Mainframe applications interacting with Distributed Systems via, Integrated Architecture with middleware Messaging Queue (MQ’s) and UNIX.
• Debugging and implementing the system using IBM Debug tools.
• Involved in preparing test plans for Independent Unit testing and System testing.
• Responsible for correct versioning of code by creating and moving the requests using Endevor.
• Extensive experience working as an onsite lead, managing projects by working closely with the clients, end users to gather requirements, prepare High Level Design (HLD), Low Level Design (LLD), and transition the design and requirements to offshore team to deliver highly successful projects on time based on the onshore-offshore global delivery model