SUMMARY

• 8 years of software development experience in the areas requirement gathering, requirement analysis, coding, testing, deployment and production support activities using Tools like IBM DataStage, Hadoop (Hive), Tableau.
• Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall and Agile/Iteration/Scrum methodologies
• Good experience working with IBM Data Stage 8.5/8.7/9.1/11.3/11.5/11.7
• Good Experience working with IBM DataStage Administrator from Linux and windows.
• Good experience on working with Tableau (Desktop in creation of reports, dashboards)
• Good Knowledge on DataModelling using Erwin.
• Good knowledge in working with production support activities by using Control M Scheduler to schedule the DataStage jobs to run the daily jobs and weekly jobs.
• Validated the current production data, existing data and the programming logic involved.
• Experience in debugging ETL jobs to check in for the errors and warnings associated with each Job run.
• Good working experience on IBM CDC 10.2 and IBM data Replication.
• Good Experience on SQL programming experience including Performance Tuning, Portioning, and Index.
• UNIX Shell scripting experience including Archiving, SFTP,DS Job Run.
• Good knowledge in data warehousing concepts and Hadoop (HDFS, MapReduce)
• Domain experience in Retail Industry (E commerce), Banking (Basel), Insurance, Health care Experience in Enhancements and Migration projects
• Good Knowledge in working with IBM Netezza (WINSQL) and Teradata (SQL assistant)
• Involved in the development process to ensure that quality is built into the product and verify that the system complies with the functional specification.
• Good knowledge on Creation, Review and Execution of Test Plan, Test Strategy, Test Procedures, Test Cases, Closure Summary.
• Ability to learn new technologies with in a minimal time period and Good communication skills.

TECHNICAL SKILLS

Languages: SQL,PL/SQL,UNIX Shell Script, XML

Database: Oracle (9i,10g,11g), DB2,WINSQL(Netezza),Teradata(SQL Assistant)

BI Tools: IBM DataStage 11.x,9.x,8.x,7.5,Tableau.

Big data: HDFS, Hive

Real Time App: IBM CDC/IBM data Replication

ITIL Tools: Service now, ITSM

Scheduling tools: Control M, Zeke.

Utilities: Git hub, Zira.

Operating Systems: Windows XP/2007/Vista

Software / Applications: MS Word, MS Excel, MS Access, Outlook, PowerPoint

Business areas: Automobile, Retail, Banking, Insurance.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Stage Developer

Responsibilities:

• involved in understanding the existing Mainframe COBOL code and prepare the mapping based on the code. involved in Developing DataStage Job based on mapping and Cobol code such that both functionalities remain same. For this we validate the data in DB2. worked on different transformation logics (null handling, typeconversions), join, Lookup, Aggregtor, Sort, XML, DB2.
• Developed complete sequencer with all logics handled for each subject area which includes Execution command, user variable activities, mail notification.
• Involved in reducing the complexity of code by writing the DB2 queries and also done portioning at DataStage job level.
• Tested the job in all environments till the code moves from SIT to UAT.
• After Loading data to warehouse tables prepare reports and dashboard using (Actions, filters, Calculated fields) and deploy to tableau server.
• Deployed the code to production as per the Sprint timelines with all the CRQ approved and documents needed.
• Monitored the Jobs in production using Control M in doing support activities and complete the batch as per the SLA.
• Created the SharePoint folder and maintained all the documents of the project and code.
• Involved in Status reporting on a daily & weekly basis of the project to ensure that all code is running with zero defects. worked in Reusability of the code and Performance Tuning activities of DataStage

Tools: used: DataStage 11.7, Putty, IBM Datastudio 4.1(DB2), Mainframes, Tableau desktop.

Confidential

DataStage developer

Responsibilities:

• involved in understanding the existing Architecture and prepare the mapping based on the code.
• The work involved preparing the LLD mappings based on the Business from HLD on each subject area like Item Master, Inventory, POS (Point of Sales).
• The work involved Design and develop the jobs as per mappings with zero defects and good performance.
• Involved gathering requirement from client, ensuring quality deliverables, and giving technical solutions to the team.
• Worked on different files like XML files, sequential files, datasets as part of DataStage jobs design
• Data validation was done in various systems like WMS, TIPS, and Data stage Jobs. Once data is validated data is sent to downstream applications which is (WMS 2)
• Involved job execution and checking the logs and rectify them Through DataStage Director and ensure code runs with zero warnings and errors.
• Involved in Production support activities by monitoring the jobs From Control M. if any jobs fail then check in Unix script followed with DataStage Job name and fix accordingly.
• Created folder structure and uploaded all the documents in share point to keep track.
• Status reporting on a daily & weekly basis, defect capture, retesting and closure of defects.

Tools: used: DataStage 11.3, Putty, Oracle SQL developer, Control MySQL Assistant (Teradata), tableau Desktop

Confidential

Software developer

Responsibilities:

• Was involved in the project from requirements analysis phase, interacted with customer as needed to get better understanding of requirements and responsible for Planning of test execution based on priority of the requirements for business.
• Involved in taking the back up of .dsx files from production and created all the folders and file systems in development of 9.1 version created the project folder and environmental variables and user defined variables in development environment of 9.1 version. then imported the .dsx file.
• After import compiled all the jobs using Multi jobs compile and ran the jobs by pointing the server to new version 9.1. performed SIT, UAT to ensure data is fine in both environments 8.7 and 9.1 and capture all the test results and documented accordingly.
• Implemented the same export and import of data from development environment of 9.1 to test environment and tested again.
• Finally deployed the code to production environment 9.1 and monitored the jobs using ControlM such that all jobs running fine without any errors and warnings.
• Fix the code accordingly if there are any issues come up while executing the jobs by monitoring the logs in DataStage Director.

Tools: used: DataStage 8.7/9.1, Putty, DB2, CONTROLM.

Confidential

Software developer

Responsibilities:

• Work involved Performance Tuning Techniques at Query level and Data stage job Level to Improve the Execution Time.
• The work involves formulate testing strategy, test planning, identifying test scenarios, test data set up, ensuring quality deliverables, and Design.
• Remodified the existing queries by adding some extra logic to remove unwanted data by filtering at date level so that refined data is loaded to datasets.
• Status reporting on a daily & weekly basis, defect capture, retesting and closure of defects.
• Created folder structure and uploaded all the documents in share point to keep track.
• Used Data Stage Director to identify the logs and rectify them with Zero errors.
• Extensively used data stage to check for logs and Performed Partioning (hash, same) as per required and used Oracle to query database.

Tools: used: DataStage 8.7, Putty, Teradata, Sql plus, CRONTAB.

Confidential

Software developer

Responsibilities:

• Understanding the business functionality & Analysis of business requirements.
• Our responsibility starts from the point where a file from our source system lands in our server and ends when it is loaded to Confidential tables.
• Monitoring jobs and viewing logs for the jobs
• Running and Monitoring the Jobs in Director and performing Clean - up resources if needed.
• Used Plug-in Meta Data to import the source and Confidential table definitions. Used most of the Stages in Data stage, such as the Transformer Stage, SCD Stage, Change Capture, Aggregator Stage, filter stage, job parameters Sequential file Stage.
• Used Lookup Stage efficiently for storing the primary rejected data for reference.
• Involved on Deployments i.e. deploying code from DEV to UAT and UAT to PROD.
• The work involves gathering requirement from client, Preparing Mapping Specifications, formulate testing strategy, test planning, identifying test scenarios, test data set up, ensuring quality deliverables, and Design.
• Effectively interacts with clients
• Status reporting on a daily & weekly basis, defect capture, retesting and closure of defects.
• Created folder structure and uploaded all the documents in share point to keep track.
• Used Data Stage Director to identify the logs and rectify them with Zero errors.
• Coordinating with on-site team and involved in on calls, Project progress reviews.

Tools: used: DataStage 8.7, Unix (Putty), Sql plus, Teradata, Control M.

Confidential

DataStage developer

Responsibilities:

• Understanding the business functionality & Analysis of business requirements
• Designed and developed DataStage ETL Parallel Jobs between Source and Confidential using sequential file stage, dataset, oracle connector, sort, remove duplicates, aggregator, change capture, transformations accordingly.
• Import and export the. DSX from one environment to test for testing purpose. created the jobs using change capture to handle SCD Type 2 dimensions accordingly.
• Involved in promoting the code from DEV to UAT and to support QA team for each query.
• Resolving the defects assigned by the QA and Business team.
• Involved in deploying code to UAT and PROD.
• Involved in UAT & Production support for the earlier releases for Daily loads, pre- verified and Monthly.
• Coordinating with on-site team and involved in on calls, Project progress reviews.

Tools: used: DataStage 8.5, putty, sql plus, DB2, Notepad++, GIT Hub, Control M.