SUMMARY

• Architect/Lead with 11+ years of professional experience in designing and developing ETL/Data warehouse solutions.
• Good understanding of Data warehousing methodologies and domain knowledge on Telecom & banking industry.
• Worked extensively on ETL tool Ab Initio (Co>Op: V2 - 14, V3-0,V3.2)
• Strong understanding of Ab Initio EME concepts, Conduct>It, PDL and metaprogramming
• Good Experience on scheduling tools like Autosys
• Experience in UNIX Shell Scripting, AWK and file manipulation techniques.
• Strong skills in SQL development.
• Worked and provided support, solutions and performance tuning for complex warehousing projects.
• Working knowledge of Data Profiler, BRE in Ab Initio.
• Sound knowledge of analytics tool R.
• Strong experience in translating Business Requirements into Functional Specification
• Proficient in handling the complete SDLC entailing requirement analysis, design, development, integration & user acceptance testing, implementation and documentation of data warehousing project.
• Extensive experience in Agile Methodology (SCRUM). Organized and facilitated sprint/Bubble planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
• Team-based management style, excellent interpersonal/communication skills and experience in leading multi-site global delivery team. Efficiently led and managed a team of more than 20.
• Experience in estimation, planning, forecasting and tracking for projects.
• Highly motivated and able to adapt all challenges.

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Working closely with Infrastructure team to setup the Hemisphere application on the new ETL Linux platform.
• Creating generic process to automate source to target loads with minimal transformations.
• Reviewing existing application codes/designs & proposes value added solutions & further implementing those with the team.
• Responsible for migrating the code changes from development environment to SIT, UAT and Production environments.
• Creation of the production support document for hand off to the support team.

Confidential

Senior Ab Initio Developer

Responsibilities:

• Working closely with the business analysts to understand the requirements and converting them into project level technical capabilities.
• Designing Technical specification documents and conducting the walk through meetings with Business Analysts.
• Develop and test ETL Code as per the requirements taking performance of the code into consideration.
• Reviewing existing application codes/designs & proposes value added solutions & further implementing those with the team.
• Troubleshooting any production code issue and providing resolution in quick time.

Confidential

Senior Ab Initio Developer

Responsibilities:

• Worked with various stakeholders to understand business drivers, goals and actionable outcomes using analytics.
• Responsibilities included gathering data and performing sophisticated analytical exercise, understanding different types of statistical models like Decision Tree, Ensemble - boost and implementing the same in R.
• Preparing and delivering presentations detailing results of analytics

Confidential

Senior Ab Initio Developer

Responsibilities:

• Closely interacted with the Business Analysts team in requirement gathering.
• Conducted meetings and sessions with SMEs, business users and stakeholders to understand their business process and elicit requirements.
• Created Business Requirement Document, analysed the business requirements to understand the business needs and produced Functional Requirement Document
• Analysis & creation of Charter & Design Documents. Ensured that the proposed solution met the business requirements
• Acted as a liaison between Business and Technical teams
• Created progress and completion reports, which were submitted to project management on a weekly basis
• Worked with the Project Manager to keep track of the status of project milestones and resource planning.
• Participated in design review to ensure the integration of all requirements
• Mentoring the new resources assigned for this project.

Confidential

Senior Ab Initio Developer

Responsibilities:

• Working closely with the business analysts to understand the requirements and converting them into functional test cases.
• Creating mapping documents.
• Worked with Project managers to divide the project into smaller modules and helping them in defining the time lines based on the development complexities
• Writing SQL queries that validate business requirements and source to target mappings within the data warehouse.
• Constantly verified Requirement Traceability Matrix to determine if each and every Functional requirement is taken care of and a test script is developed and executed for the same.
• Set up test environment and created test data for both positive and negative test cases
• Used agile methodology to ensure the new features meet the customer requirements and acceptable quality assurance standards.
• Interacted with developers to identify and resolve technical issues
• Creating Test Summary documents and Defect Metrics
• Mentoring the new resources assigned for this project.