EXPERIENCE SUMMARY

• 11+ years of professional IT experience, predominantly in ETL, Data warehousing and Reporting in industrial domains like Banking, Finance, Pharmaceutical e - Retail and Automotive campaign marketing.
• 3+ years of US work experience, working onsite with client, vendors and technology partners to procure, process, cleanse, load and analyze data using ETL tools and build reporting dashboards for Business to facilitate decision making.
• 1 year of UK work experience, deputed to Barclay’s Radbroke office through Confidential (India), to work on inception of new project which involved end-to-end exposure from requirement gathering, translating those to technical requirements, data modeling, ETL architecture, solution design, build, testing (CIT, SIT, OAT & UAT), prod deployment and support handover.
• Donned multiple hats: Senior System Analyst - Data Warehouse, Technical Team Lead, Data Specialist, ETL designer, ETL Developer and Production Support analyst.
• Rich experience with ETL tools like Ab Initio, Informatica and DataStage.
• Extensive experience with UNIX and LINUX. Expertise with file system and shell scripting.
• Strong SQL and database skills. Widely used DB2/UDB, Oracle, Teradata, PostgreSQL and GreenPlum in various assignments.
• Experience in working on Waterfall and Agile methodologies of software development. I have worked as scrum master for Kanban process/board on an agile project.
• Comprehensive experience of building dashboards and reports for stakeholders, using reporting tools like QlikSense and QlikView.
• Have worked on automation of reporting dashboards by creating and scheduling Windows batch job to copy data files from local machine to Qlik Servers.
• Have knowledge of Hadoop eco-system, HDFS shell commands, HIVE and Python (Internal trainings).
• Experience of working in hybrid team scattered across the globe - Team of size 10-12, involved multiple vendors and was scattered across India (Pune and Hyderabad), Singapore, UK and Lithuania.
• Team player, good communication skills, interpersonal skills, self-motivated and quick learner.

TECHNICAL SKILLS

ETL Tool Ab Initio, Confidential Info-Sphere DataStage and Informatica Power-center: RDBMS: DB2/UDB, Oracle, Teradata, PostgreSQL, GreenPlum and MySQL

Reporting Tool Qlik Sense and Qlik View: Operating System: UNIX, Linux and Windows

Job Scheduling Tool Confidential Tivoli Job Scheduler, Autosys and Enterprise Scheduler Protocol: Programming Languages: PHP, C, C++, Java and Ruby on Rails (RoR), Python

Project Tracking Tools JIRA, Pivotal Tracker, Drive IT, Service Now (SNOW), Service Manager 7 (SM7), BMC Remedy ITSM, HP Quality Center, EME, SVN, Trac and BugZilla: Functional domain: Banking/Finance, E-commerce/Retail and Automotive campaign management.

PROFESSIONAL EXPERIENCE

Confidential

Senior System Analyst

Responsibilities:

• Act as the primary point of contact for day-to-day execution of CMS processes.
• Work with Business, vendors and internal/external teams to gather, assess and document requirements for new and existing initiatives.
• Undertake impact assessment and provide efforts and estimates to Business.
• Work on design and build of ETL solution using DataStage, UNIX, DB2 and SQL. Under take unit testing post build completion and document the results.
• Undertake UAT with Business and support all activities till production deployment.
• Assess data requirements, data discrepancies using SQL or UNIX commands and scripts to identify data anomalies, report root cause analysis and rectify data.
• Build QlikSense/QlikView dashboards to present holistic view of CMS data to Business for ease of decision making. Schedule batch jobs (.bat) and QS tasks through QMC to automate reporting.
• Verify data loaded in Data Warehouse (GreenPlum) DB by firing SQL queries and validate values for various KPIs.

Environment: DataStage 11.3, DB2/UDB, SQL, UNIX, PostgreSQL, GreenPlum, QlikSense and Qlik View.

Confidential

ETL Team Lead

Responsibilities:

• Worked as ETL team lead, responsible for end-to-end delivery of various activities involved in loading data in ODS.
• Worked closely with Business, Data Modeler, SMEs, various upstream and downstream teams to analyze the requirements and to document BRD, design source to target mapping, ETL solution and technical documents.
• Work on build of ETL solution using Ab Initio 3.3, UNIX, Oracle and SQL. Undertake unit testing.
• Work with the off-shore team of developers to address technical issues confronting the team and ensure optimal and apt solution is implemented.
• Support UAT and guide Business users through UAT testing. Support all production deployment related activities.
• Provide L3 support to live batch on weekends and public holidays when off-shore support tem is unavailable.

Environment: Ab Initio 3.2.2, UNIX, SunOS, Oracle, Informatica 10.0 and Linux.

Confidential

Data Specialist/Technical Lead

Responsibilities:

• Worked as Technical Team Lead for end-to-end delivery of Mass Pay project, which had to be encapsulated in to existing AML program. Worked with Business, multiple source teams and SMEs to analyze the requirements and source systems to document BRD, design source to target mapping, ETL solution and technical documents.
• Worked as Scrum master to manage, Plan and document various delivery phases, live implementation and support hand over. Wrote user stories and user acceptance criteria for Kanban board. Managed the backlog and worked on process improvement.
• Worked with rest of the team to build the solution as per design using Ab Initio, Informatica, Teradata, UNIX and LINUX.
• Worked with testing team and Business to finalize the test cases, acceptance criteria and test coverage.
• Also worked as a Teach lead responsible for Analysis, design, development, testing and implementation of AML solutions for new implementations and upgrades for AML Program as part of the BTB team.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in ETL tools and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Key projects handled so far include AMLR and AMLC Mass pay Integration, JPMC Exit, UKBA Sec code expansion, Inclusion of Hong-Kong and Shanghai data in AMLC.

Environment: Ab Initio 3.0, UNIX, Teradata, Oracle, Informatica 10.0, Linux and Confidential Tivoli.

Confidential

Consultant (7A)

Responsibilities:

• Worked as team lead, liaising with Business, Business Analysts and SMEs to gather, translate and document business requirements into technical requirements.
• Lead the analysis sessions reviewing all the project documents (BRD, HLD, DLE, Mapping) provided by BA and SME and get all questions and concerns addressed.
• Undertake impact assessment on existing jobs and processes due to proposed solution and provide estimates and timelines to Business.
• Represent the new solution design and architecture to DA, DBA and client and get it approved.
• Work on build using Ab Initio, UNIX, Shell Scripting, Teradata, SQL and finally Confidential Tivoli.
• Undertake unit testing (CIT) on all the build/modified components and document the results.
• Work with SIT and UAT teams to create test cases and scenarios. Provide support to these teams through testing. Address any issues/defects logged by them in HP Quality Center.
• Communicate any changes or impacts to downstream teams.
• Work on all post build support activities like creating production deployment plan, submitting change tracking and ensure apt communication with Business and all the involved parties.
• Provide warranty support post live deployment and handover to the run team.

Environment: Ab Initio, UNIX, Shell scripting, Teradata, SQL, Confidential Tivoli and HP Quality Center.

Confidential

Programmer

Responsibilities:

• Understand the requirements shared by Business and Solution architects and work on build using Ab Initio, Shell scripting and Teradata.
• Undertake unit testing (CIT) on developed components and jobs and document the results.
• Work with QA to create test cases and scenarios for end to end testing as per the BRD.
• Support testing phases on various pre-prod environments.
• Support rest of the SDLC phases till live implementation.
• Provide warranty support after go live for agreed period.
• Under take assessment for any new initiatives to provide impact assessment and effort estimates.

Environment: Ab Initio, UNIX, SQL, Shell scripting, Teradata, Mainframe and Confidential Tivoli.

Confidential

Software Developer

Responsibilities:

• Assess requirement documents shared by the BA and get clarifications on any of the open points or questions.
• Submit user stories for each ask and plan deliverables for each sprint.
• Work on building frontend functionality in PHP, Ruby and Java Scripting using ROR Framework. Create/amend backend in MySQL DB.
• If web page clutters during build, enhance the HTML and CSS web page design provided by the designers.
• Thoroughly test the website and features to ensure it meets the BRD. Undertake compatibility testing on varied browsers and devices. Test performance on concurrent usage.
• Deploy changes to test environment and undertake UAT by providing demo to the client.
• Deployment of the project in Live.