SUMMARY:

• Total 7 years of IT experience.
• Currently working as Technical lead for Confidential Consulting.
• Total 7 years of working experience with client Confidential (Amex)
• Currently working on Application migration project from ETL data stage - Netezza to BIG data for Amex
• Primary Core competency- Experience in IBM Datastage V8.0.1 & V8.1, Netezza SQL, Unix Shell scripting with System Analysis and Design, Business Process Analysis, system design(Datastage Job design), database design, coding, testing, debugging, implementation, training, and maintenance.
• Hands on experience on PIG, Hive and has basic knowledge of kognitio, Platfora, Sqoop.
• Experience in performance tuning on datastage jobs as well as Netezza, Pig, hive scripts
• Knowledgeable on Dimension Modeling, Star and Snowflake schema
• Strong Understanding of DW and DM systems which includes physical and logical Data models
• Knowledge of Scheduling Tool CONTROL M
• A strong foundation in Software Development Life Cycle (SDLC), very good understanding of Data stage, Netezza SQL
• Passionate for teamwork and excellence. Leading the team of around 8 and successfully implemented high volume projects
• Sizing and estimation of small and medium size projects
• Strong analytical skills and proficient in efficient development
• A quick on the job learner with an ability to work in team as well as independent
• Helped team to develop & execute the large scale project plans
• Well acquainted with domain knowledge, AMEX processes, SDLC water fall and Agile methodology

TECHNICAL SKILLS:

Programming platform: Big data(PIG, HIVE, kognitio, Plafora), Unix AIX, Mainframe

Database Management: DB2 V9.0, Netezza

Scheduling platform: Control-M

Tools: IBM Data stage V8.0.1 & V 8.1, IBM Data stage Administrator V8.0.1, Microstratergy, Rally

PROFESSIONAL EXPERIENCE:

Project Lead

Confidential, Phoenix, Arizona

Skills Used: Pig, Hive, Unix,Kognitio,Platfora, Sqoop

Environment: The Application is being migrated from ETL Env to BIG data wherein sourcing of raw data and aggregation is done using Unix, Python, Pig and hive

Responsibilities:

• Understanding requirements from Amex technology and Business team as this was tech initiated pure platform migration project.
• Was involved in architecture design and decision making on correct technology to be used to migrate different processes from existing ETL application to Hadoop system by doing benchmarking through different POC’s
• As a Tech Lead, guiding the team members for allocated task and reviewing the task done by the team.
• To deliver quality product to the customer.
• Performance tuning of new Env

Confidential

Technical Lead

Skills Used- IBM Datastage V8.0.1, Netezza, Unix Scripting on AIX box

Responsibilities:

• Preparation of Design Documents after analyzing the requirements and the systems Analyze the business requirement
• Application SME: - Supporting Confidential platform from onshore, answering all business as well as other application team’s queries related to Confidential application
• Confidential Application support: Monitoring Confidential loads end to end to make sure business does not impact in case of any issues from upstream schedule, database and infrastructure issues and other data issues
• Data Quality support: Have taken care of all issues/concerns raised by business through JIRA on Confidential data and gave justification/issue resolution whenever required. Number of issues raised related to Confidential applications were reduced significantly as compared to previous quarter
• Confidential Enhancements: - Have worked on couple of major Confidential enhancements. Was involved in analysis of business logic change required and provided solution
• Handled this project end to end from onshore
• Guided offshore team on implementing the solution and reviewed their work
• Have worked with business for UAT validations, implementation activities and post implementation validations
• Other SQP projects:- Driving Confidential impacts of end to end projects which includes DOE releases, Decommission of strata, IMP, New framework build for duplicate ROC identification, IDOE, Merchant recommendation reporting etc
• Confidential optimization: have worked on a project for optimization of end to end Confidential process
• Was involved in identifying/analysis of time consuming process and volume being processed in each process and expected volume to be processed in future
• Worked on finding out technical solutions to optimize different processes based on analysis and achieved considerable performance gain
• This tech initiative was much appreciated by tech as well as business client team

Confidential

Technical Lead

Skills Used- IBM Datastage V8.0.1, Netezza Scripting

Responsibilities:

• Comprehend the requirements of the customer.
• Involved in estimation of total efforts & provided sizing of the team.
• Prepared k245 and Design Documents as per the requirement & provided the solution.
• Designed the jobs/scripts and created test data for unit testing.
• Execute Unit testing and documented all the test results.
• Performed SIT & UAT, received business sign off
• Delivered quality product to the customer.

Confidential

Developer

Skills Used- Datastage, Metadata workbench, Business glossary, UNIX, Mainframe

Responsibilities:

• Analyzed existing process to understand the flow from MF application to DM tables /Reports getting loaded through datastage, for streams under scope.
• Checked the code for all code changes as per lineage perspective.
• Get the design docs done as per requirement and reviewed it.
• 4) Migrated code from SP to Datastage for 1 stream as a part of Req.
• Involved in build activities and created UAT plan as well as approach for testing. Reviewed test results
• Performed SIT & UAT and resolved /gave justification for all issues/concerns raised during UAT.
• Received sign off & involved in Implementation activities.
• Performed R&D on tool to understand the functionality of the tool during Build and solving UAT issues. Also imparted the knowledge to other team members.
• Also done distribution of tasks among team members. Making them understand tasks and reviewed their work

Confidential

Developer

Skills Used- Datastage,Db2,UNIX,.net

Responsibilities:

• Analyzed existing process to load Target table.
• Find out the impacted jobs and source for the new attributes in
• DW table/MF source files to DW process.
• Created all design documents as per the K245 provided.
• Designed jobs in Data stage Designer 8.0.1.and debug code using Director 8.0.1.
• Did Data set up and Perform end to end testing(jobs level and sequence level)
• Performed SIT & UAT.
• Received sign off & implemented the project

Confidential

Developer

Skills Used- Microstrategy, DB2

Responsibilities:

• Analyzed existing process and Data under scope.
• Created some sample reports
• Involved in End to End testing of these reports and documentation.
• Have suggested some creative ideas to show better data understanding can be achieved using MSTR features.
• Performed R&D on tool and imparted the knowledge to other team members