EXPERIENCE SUMMARY

• Has 9 years of IT experience and with ample noledge in Banking/Insurance, Retail and HealthCare domain.
• 9 years of experience in Data modelling, Datawarehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM WebSphere DataStage11.5/11.3/8.7/7.x,Quality Stage, Shell Scripts.
• Experience in analyzing teh data generated by teh business process, defining teh granularity, source to target mapping of teh data elements, creating Indexes and Aggregate tables for teh data warehouse design and development.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver. 11.5/ 11.3/8.5/8.1/7.5), designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Administrator.
• Expertise in Datastage server, MPP clustered platform and parallel jobs.
• Expert in server jobs development, handling hash files and inter process stages.
• Created a Control - M setup dedicatedly for many server jobs applications in current project as part of development.
• Handled main frame source system files (VSAM, QSAM and SAM- using complex flat file stage) in banking project and performed ETL process after extraction.
• Expert in using stages, Standardization, Scrubbing, Matching and Survivorship rules using IBMQualityStage.
• Has done a POC on Hadoop File Systems to integrate teh Merchandise, Item location details using Big Data File Stage in Datastage 11.5 version. Also, analysed teh feasibility moving teh data through Hive connector stage to load it into Netezza DB, as part PPA assignment in Michaels.
• Efficient in all phases of teh development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Efficient in incorporation of various data sources such as Oracle11g/10g/9i/8i, PL/SQL, MS SQL Server 2000/2005/2008/2008 R2, DB2 9.5 & 10.1, XML (parsers) and Flat files into teh staging area.
• Experience in Mapping Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts and addressing performance issues and enhancements.
• Exposure to design and support of mainframe applications using JCL, DB2 and IBM Mainframe tools and utilities.
• Expertise and worked in Service Oriented Architecture- SOA as part Target Corporation.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies and relational database design.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in Scheduling tools like Control-M, Autosys for automating and scheduling jobs run.
• Worked on MDM in Target to merge teh critical supplier information details with respect to geography and created one master data file for ease of access
• Expertise in Master data management - MDM tool can be used to support master data management by removing duplicates, standardizing data (mass maintaining), and incorporating rules to eliminate incorrect data from entering teh system. Teh merged supplier master data would be efficient for business enhancement.
• Experience in UNIX Shell scripting, complex SQL queries, PL/SQL, Stored Procedures and Database Triggers.
• Excellent noledge of operating systems Windows, UNIX and databases including Teradata, Oracle, Netezza, Greenplum, SQL Server and DB2.
• Has undergone Informatica ETL tool training.
• Undergo Talend Data Integration using Big Data tool training and certification.
• Experience in implementing Quality Processes like ISO 9001:2000/Audits.
• Provided 24X7support to users and having good experience in resolving high priority production issues within teh time.
• Good Interpersonal skills, leadership skills, team player, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
• Designed teh Control-M Visio based on teh business needs for scheduling teh DataStage jobs in control-M scheduler.

TECHNICAL SKILLS

Technologies/Languages: Data warehousing (ETL), Shell Scripts and Message Queue

Databases: Teradata, Bteq scripts, SQL, MQ, Oracle, DB2, Netezza,Microsoft Access, SAP

Operating Systems: Windows& DOS, UNIX/LINUX/AIX and Solaris, MDM tool

BI Tool: Cognos

Data Modeling: Erwin and Microsoft Visio

Configuration Management: Microsoft Team Foundation Server (MSTFS)

Programming Languages: SQL, PL/SQL, UNIX commands and Shell Scripting

Domains worked: Banking, Retail, Insurance and Healthcare

Scheduling Tools: Control-M, & Autosys.

Tools used: DataStage 7.5,8.1,8.5,9.1,11, 3( Server and Parallel jobs), Quality Stage

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities:

• Support teh implementation of teh Datastage by performing all roles associated with architecture, design and development of teh solution.
• Create program specifications and Project plan.
• Build teh new datastage parallel jobs based on teh business requirement as part of various project release
• Develop Control-M and Unix scripts setup for teh applications that we develop
• Implement testing, transition and support activities.
• Support unit, automated regression, and UAT testing for all new enhancements
• Support teh production Datastage jobs by monitoring and resolving any issues
• Contribute to teh project planning process by estimating Data Architecture, Modelling, Reporting tasks and Deliverables
• Perform qualitative and quantitative analysis on data from various sources including database for log files to identify new business metrics patterns that will enhance teh Customer's data quality and value
• Performance tunes teh Datstage jobs as part of teh continual process enhancement.
• Analyze test results and track teh progress of teh deliverables

Confidential

Technical Lead

Responsibilities:

• Support teh implementation of teh Datastage by performing all roles associated with Architecture, design and development of teh solution
• Perform weekly, monthly release data refresh activities in UAT environment
• Develop new datastage server and parallel jobs based on teh business requirement as part of monthly release
• Troubleshoot and handle issues pertaining to datastage server jobs application which are running in legacy systems
• Handle mainframe source system files( QSAM, VSAM) from MDSS server and extract them for ETL process
• Develop Control-M setup for teh application that we develop
• Work closely with internal and external clients to determine reporting requirements, data architecture and design solutions
• Contribute to teh project planning process by estimating Data Architecture, Modeling, Reporting tasks and Deliverables
• Performance tune teh Datastage jobs to extract information from teh data warehouse
• Support teh production Datastage jobs by monitoring and resolving any issues
• Support unit, automated regression, and UAT testing for all new enhancements
• Perform qualitative and quantitative analysis on data from various sources including database for log files to identify new business metrics patterns that will enhance teh Customer's data quality and value

Confidential

Technical Lead

Responsibilities:

• Designing teh Functional specification documents
• Designing teh functional test cases to identify teh bugs in teh code
• Development of control table for file management and data processing
• Developing project development process flows for standardization across Lines of business
• Adding suggestions to business needs to enhance teh efficiency of teh existing system
• Performing high level data validation and provide remediation of source system data

Confidential

Technical Lead

Responsibilities:

• Prepare teh HLD document by coordinating with business team and technical architect.
• Gathering current requirements from core business team through scrum meetings to make/add teh changes in HLD.
• Adding suggestions to business needs to enhance teh efficiency of teh existing system
• Making key code changes in Datastage and Teradata codes during teh development phase.
• Presenting daily status report to teh clients.

Confidential

Technical Lead

Responsibilities:

• Leading Target.com & Marketing portfolios in NPE.
• Managing project related activities and handling client escalations.
• Preparing teh project monthly metrics for client presentation.
• Guiding teh team with teh process improvements and automations.
• Help teh project teams with teh value ads and performance tunings.
• Presenting teh weekly status report to teh clients.
• Logging teh lessons learnt and best practices in TCS portal.

Confidential

L2 support engineer

Responsibilities:

• Resolving Datastage issues pertaining to Non Prod Environments with appropriate solutions.
• Coordinating with other environment support teams in resolving teh issues in related to Database unavailability and job scheduling tools etc...
• Working on work requests and defects raised by business users, adhering to teh predefined SLA’s and updating teh work logs with teh solution accordingly.
• Performing Data refresh to sync up teh Non Prod Environments with production environment data and writing data refresh scripts to perform teh same in Datastage.
• Prepared teh Gap Analysis Document for all teh T.COM and Marketing applications that compares teh environment details of teh Non Production Environments.

Confidential

Senior ETL developer

Responsibilities:

• Assigning teh test requirements to releases based on teh specifications in teh Functional Specification document
• Determining teh number of fixed and open defects at a release or a cycle level
• Enhancing teh reporting granularity for teh test set folders
• Identifying teh bugs and report teh same through incidents to teh corresponding development teams on priority
• Modified teh Datastage jobs that has got logic issues and changing teh code based on teh client requirements.

Confidential

Module Lead

Responsibilities:

• As part of teh production support team, we provide round teh clock support in monitoring and maintaining teh functioning Datastage applications
• To send emails in case of any failures or any Adhoc requests from teh clients regarding issues that are pending and if teh client needs an update regarding teh same
• As and when issues rise, incidents are raised based on teh priority and closed with appropriate solution which includes data fix and data correction through DBA instructions
• Problem tickets are raised for reoccurring issues and a permanent fix is given by making teh appropriate changes at teh job level and testing those jobs in teh PRT environment to ensure that teh data load is correctly implemented through teh changes made
• Modify teh Datastage jobs that has got logic issue

Confidential

ETL Developer

Responsibilities:

• Development of ETL mappings as per requirement
• Reviewing teh ETL mappings and testing them
• Implementation of teh transformations
• Scheduling teh session through Autosys
• Developing teh Autosys environments for running teh jobs in Datastage and editing teh scripts in UNIX
• Testing teh jobs in SIT and PRT environment
• Prepare teh corresponding documents and test cases

Confidential

ETL Developer

Responsibilities:

• Collecting teh project details from teh existing production system
• Exporting teh project from teh DataStage 8.0 version and importing it in teh new Datastage 8.1 environment and compiling teh jobs
• Setup teh UNIX environment for teh projects and giving permissions to teh users
• Developing teh Autosys environment for running teh jobs and editing teh scripts in UNIX
• Scheduling teh job through Autosys
• Involved in various phases of testing like environment testing, SIT and PRT
• Test all teh components in teh development environment, fix new errors / warnings and make necessary changes in order to make all teh components function as in teh existing environment
• Preparing teh documents for teh environment setup request in teh new production system
• Preparing teh production package with all teh required documents like test case and migration documents, .dsx files and Unix scripts