SUMMARY

• Confidential has 6+ years of professional career of which about 5+ years of experience in IT - Data ware Housing and Business Intelligence. Part of development team and worked extensively in IBM Info Sphere Data Stage tool and delivered multiple data warehousing projects. Confidential has worked primarily in the domain of Banking and Finance, Services. In the course of his experience Confidential has been interacting with the business group, analyst, and data modelling team & user groups and is aware of the methodology and the practices involved in the same.
• Confidential has expertise in data warehousing concepts, ETL programming using IBM DataStage Enterprise edition, Parallel jobs, Job Sequencers and other data warehouse lifecycle tasks such as data analysis, transforming, debugging/testing, and data loading across target systems. Confidential also has experience in Business Objects, Remedy, Autosys, Informatica, Siperian MDM tools.
• Confidential has also strong interpersonal, problem solving & team skills, quick learner, able to meetdeadlines, ability to interact with people at various levels.
• Confidential has worked on projects for clients such as Confidential, Novo Nordisk, General Motors, Citi Bank In his last assignment.
• Ability to interact with different teams, project execution capabilities.
• Effective task tracking, execution and reporting skills.
• Ability to meet timelines with ease.
• Strong analysis skills to resolve critical issues
• Effective communication skills and good team coordination.
• Qualitative task delivery under stringent timelines and high pressure.
• Good verbal and written skills, Good ability of expression with patience.
• Good knowledge of data warehousing concepts.
• Managing reports, analysis and decision-making for a change request.

PROFESSIONAL EXPERIENCE

Confidential

Environment - Info Sphere Data Stage, Unix, Autosys, Oracle 10g

ETL / Autosys Developer

Roles and Responsibilities:

• Responsible for the assigned tasks and to coordinate with different teams to get the inflow and outflow of data setup
• Single point of contact for the client from the development team.
• Discussions with Business and Functional users to get the details required for the development and enhancement tasks.
• Implement various Business Rules in line with the requirements.
• Implementation planning and successful deployment of the developed code in production environment
• Assign the issue tickets and Tasks to the team members
• Provide post implementation support after go live.
• Create learning plan and mentor new and existing team members
• Attending status meetings with clients

Confidential

Environment - Unix, Info Sphere Info Sphere Data Stage, Autosys

ETL / Autosys Developer

Roles and Responsibilities:

• Responsible for Extracting, Transforming and Loading Data from Flat files and oracle files and placing it into Data warehouse.
• Working on Data stage Designer tools- for Creating Jobs, Shared Containers and Job Sequencer and Compile the Job.
• Studying the Existing Source Databases. Involved in interacting with decision makers or analyzing their business plans.
• Analyzed the Sources, Targets, Transformed the Data, Mapped the Data, and Loading the Data into the Targets using Data stage.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Warehouses.
• Involved in ETL Processes to load data from Flat file, Oracle, RDBMS into target Oracle, RDBMS databases by applying business logic on transformation mapping for inserting and updating records when loaded.

Confidential

Environment - Unix, Siperian MDM, DataStage, Oracle 10g

ETL Developer

Roles and Responsibilities:

• Develop Data Stage jobs using existing framework.
• Develop UNIX shell scripts that would run the above mentioned DataStage jobs.
• Develop and schedule the Autosys jobs to call the UNIX scripts to run in the desired manner.
• Actively participate in thorough unit testing and coordinate with the testing team for System Integration Testing.
• Implementation planning and successful deployment of the developed code in production environment.
• Weekly and monthly status reports to the client.
• Mentor the less experience team members

Confidential

Environment - Unix, Cognos8.2, DataStage 7.5.3, Oracle 9i

ETL Developer

Roles and Responsibilities:

• Monitoring the ReDS application production cycle 24x7 processes.
• Analyze the production issues regularly and bug fixing.
• Resolving the production issues within the time period.
• Simultaneously working on change requests.
• Designing the jobs based on the business requirements
• Developing the jobs.
• Perform unit testing on the designed jobs and functional testing.
• Deploying the jobs in production environment at appropriate time interval.

Confidential

Environment - Unix, Cognos7.3, DataStage 7.5.1A, Oracle 9i

ETL Developer

Roles and Responsibilities:

• Responsible for Extracting, Transforming and Loading Data from Flat files and Oracle files and placing it into Data warehouse.
• Working on Data stage Designer tools- for Creating Jobs, Shared Containers and Job Sequencer and Compile the Job.
• Studying the Existing Source Databases. Involved in interacting with decision makers or analyzing their business plans.
• Analyzed the Sources, Targets, Transformed the Data, Mapped the Data, and Loading the Data into the Targets using Data stage.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Warehouses.
• Involved in ETL Processes to load data from Flat file, Oracle, RDBMS into target Oracle, RDBMS databases by applying business logic on transformation mapping for inserting and updating records when loaded.

Confidential

Environment - Action Request System 6.3, Oracle 9i

Remedy Developer

Roles and Responsibilities:

• Analyzing the business scenario based on the requirement
• Functional & Technical understanding of the requirement
• Installation, Configuration and Implementation of the Remedy Helpdesk Suite
• Creation of various Workflow components like Forms, Active links, Filters, Escalations, Menus
• Unit testing of designed forms
• Manage AR System licenses
• Create AR System reports using Remedy User