SUMMARY:

• Having 10 years of IT experience as Data Management/Integration Architect and in Analysis, Design, developing solutions for Enterprise data warehouse (EDW), Data Quality, Extensive experience as Datastage Developer in 8.x, 9.x and 11.x, Big Data and Data Migration.
• Extensive knowledge of pure retail domain experience and good exposer to Migration projects.
• Extensive Datastage experience at Target in project implementation, life cycle management and support.
• Experience in Design, document and configure the Datastage to support loading, cleansing, matching, merging, and reporting of EDW data.
• Leads highly complex, strategic projects involving high level of coordination among multiple departments and business areas which utilize data to support new business for EDW and for the data analytics and reporting.
• Had short term experience in data quality efforts to ensure the accuracy of data across the enterprise.
• Experience in Analysis, design, development, testing and Implementation of End - to-End Data warehouse and Data Mart for Target Corporation.
• Having good understanding of EDW architectures and business processes of Target.
• Extensive knowledge in loading high volume data, debugging and tuning for Data Warehouses.
• Experience in project life cycles, planning, execution, Monitor & controlling the project. Complete domain and development life cycle knowledge of data warehouse projects.
• Possess a distinguished ability to conduct accurate analysis, solve issues, assess technical capabilities and accompany team members in acquiring great deliverables.
• Good analytical, communication skills and able to adapt to new environment quickly and able to deliver good productivity in fast faced environment.
• Mentors and assists lower level architects, business analysts and developers.
• Expert in designing ETL Architecture and star schema and snow flake dimensional models.
• Partners with business line managers and Center of Excellence leaders, providing technical and system expertise, to synergize IT strategic direction and product concepts.
• Experience using IBM QualityStage and Change Data Capture (CDC) tools

TECHNICAL SKILLS:

Data Warehousing Program Languages: Ascential Data stage 7.5.x, 8.5, 9.5 & 11.x

BigData Hadoop Tools: Hive, HBase, Pig, Kafka

RDBMS: Oracle 10G/9i, DB2, Teradata 14.0, PostgreSQL

Data Modelling: Erwin R9

Software Engineering Methodologies/Tools: MS Visio, WINSCP for Unix

Tech Inf. Services Skills: Citrix MetaFrame Presentation Server

Automation Testing Tools: Query Surge, QTP

Version Control Tools: MSTFS, HPSD, Servicenow, GitHub, Jenkins, Ninjira

Development/Productivity/Scheduling Tools: Control-M EM V9, Mercury Quality Center 9.2, 10, 11,Oozie Co-Ordinator

Scripting Languages: UNIX Shell Script.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Analyze & Understanding new VMM services of Business partner and brand data. The existing ETL code end to end process.
• Create the mapping document and design documents.
• Convert the ETL code to HIVE executable SQL’s and converting the Type-I & Type-II ETL SQL’s to HIVE SQL’s.
• Design & Develop the wrapper scripts, Ooozie xml’s workflows.
• Create the Oozie Co-Ordinator for of the Hadoop code execution and support.
• Implementation & Post Implementation Support of the application.

Confidential

Technical Lead

Responsibilities:

• Analyze & Understanding new VMM services of Business partner and Brand data.
• Creating the high level design document and converting the design document to Hadoop code.
• Design & Development of Business Partner & Brand tables using Hive.
• Exploring tuning opportunities in Hive for better response time and the Query Execution.
• Sqoop the data from Teradata to Hive for the reference and Historical Data lookup.
• Design the Oozie Co-Ordinator flow for Business Partner and Brand flow execution.
• Deployment of code to multiple Bigred Servers using CICD process.
• Lead the 2 member offshore team with development Execution and Implementation activities.

Confidential

Technical Lead

Responsibilities:

• Understanding the existing architecture and flow dependency of Merchant Analytics Application.
• Working on fixing the production issues and defects.
• Exploring tuning opportunities in ETL and database for better response time.

Confidential

Technical Lead

Responsibilities:

• Analysis of existing architecture to bring about new industry standard best practices
• Creation of Detail level design definition and reviews
• Co-ordination with multiple stakeholders for effective SIT/UAT
• Capacity planning for development and production.
• Mentoring a 4 member offshore team

Confidential

Senior Developer

Responsibilities:

• Technical Analysis of existing process flow to identify process bottlenecks
• Resolving Technical issues in Datastage 8.5 and Teradata
• Involved in creating LLD, STM and Control-M jobs.
• Testing and Bug Fixing, Reviewing and resolving Issues.
• Attending daily status calls with onshore team to get the requirements.
• Creation of Implementation Plan, providing walk through with all stake holders before the implementation to get buy-in.
• Supporting and implementation activities, fixing the production issues and post implementation support activities.

Confidential

Senior Developer

Responsibilities:

• Worked in analysis, design and implementation for various modules of Instocks Project.
• Interacting and coordinating with business partners involved in Instocks program located in Minneapolis.
• Providing Technical/functional assistance to offshore team members.
• Involved in writing the test cases for the unit testing and supporting system testing.
• Involved in fixing the bugs raised by the UAT team.
• Involved in analyzing the results produced by the ETL jobs to match the business requirements.

Confidential

Developer

Responsibilities:

• Involved in Extraction, Transformation and Loading (ETL) of data by using Ascential DataStage7.5
• Developed various parallel jobs to populate the Data Mart from flat files.
• According to the business logic applied various transformations to the source data using various stages.
• Prepares project deliverables like STM, HLD, LLD.
• Prepare test data, develop and execute unit test plans.
• Involved in optimizing the jobs for better performance.