Have 8.5 years of experience in creating and maintaining data model, ETL, data warehouse, database, BI solution and database programming for major multi-national companies.
Excellent exposure to the entire Software development life cycle (SDLC) and quality management system (QMS) processes.
Have lead BI project from planning to project closure, which includes requirements gathering, creating WBS/work packages, facilitated quality team, identifying project risk, identifying change requests whenever there is a deviation from the plan.
Expertise in developing applications using Informatica, Oracle warehouse builder, Oracle APEX, Pervasive, Automate, Erwin Platinum
Expertise with databases including Oracle 9i, PL/SQL and MySql
Have diverse exposure by worked directly with clients across the globe at various client locations as BI consultant and project lead.
Strong analytical skills with ability to quickly understand client’s business needs.
ETL , Data warehousing, Oracle developer
Data Warehousing tools
Informatica, Oracle warehouse builder, Oracle APEX, Pervasive, Automate, Erwin Platinum
DB Visualizer, Toad, SQL developer
Feb 2010 - Till Date ‘Project Lead’ at CGI (Formally called as ‘Logica’)
Pvt. Ltd, Chennai
Sep 2007 - Jan 2010 ‘Senior Software Engineer’ at Hexaware Technologies
Pvt. Ltd, Chennai
Mar 2006 - Sep 2007 ‘Software Engineer’ at Bahwan Cybertek
Pvt. Ltd, Chennai
Feb ’10 - till Date
Project Lead in CGI (Formally called as ‘Logica’), Chennai
Project: SJ (Data warehousing)
SJ is a government-owned passenger train operator in Sweden. Swedish Railway Business intelligence project deals with the enhancement, maintenance and support of various systems such as ESS, AFFSTAT, PoF, RPS, OC and QREP
The purpose of designing and integrating the Budget and prognosis with ESS system is to enable top management to take crucial investment decisions based on reports generated using this system.
Participate in the full lifecycle of ETL software development - analysis, design, build, documentation and testing.
Motivated and guided the team to attain project objectives and thereby achieving milestones.
Develop technical designs, build Informatica/OWB workflows and create mappings, stored procedures, functions, materialized views, triggers and clearly document the process.
Experience in Performance Tuning ETL processes with ability to maximize data flow and minimize time and hardware resources.
Experience in database design, entity-relationship modeling and dimensional modeling.
Develop and deploy ETL workflows and mappings with reliable error/exception handling and rollback framework
Create and execute unit tests on all solutions, work with Data analysts and QA engineers to ensure product and integrations tests are complete.
Work with both the project and support teams to understand existing systems and to help troubleshoot, optimize, and tune ETL processes as needed.
Guide and mentor the team in technical areas, so as to help them in designing complex queries.
Carry out and review important technical documents, designs, technical reviews of code and test plans created by team members.
Worked with client to create technical design document and assisted them to get approval.
Assist in UAT and production implementation.
Share technical knowledge among the team and across the Business unit in the organization.
Build strong relationships with the peers, analysts, technical and business leads through delivery, communication and development of domain knowledge
Perform unit testing, system integration testing and assist the business analysts with user acceptance testing.
Develop and incorporate ETL best practices and standards
Take responsibility and ownership for the analysis, design, coding, testing and status reporting of a work product.
Provide input on technical effort estimation to arrive at resourcing plans.
Engage in peer reviews during design, coding and testing.
Prepare implementation plans, delivery report and deployment checklist when moving code to production.
Prepare defect correction plan by performing the defect causal analysis for every release, which has helped the team to deliver future releases with reduced defects.
Prepare and track monthly metrics for BI team.
Create various service improvement plan (SIP’s) which in turn generate additional revenue to the organization.
Propose new areas for effective business which results in major CR’s thereby increasing team size.
Environment: Java Informatica, Toad, Oracle PL/SQL and Oracle APEX
Jul '08 – Jan ’10
Module Lead / ETL Developer in Hexaware Technologies, Chennai
Project: DL (Data warehousing)
Deutsche Leasing has implemented a new consolidated data warehouse system with the objective to connect all operative source systems. The Cetelem system also has to be integrated with the existing system. The interface is to deliver contract data of "Auto-Kredit Händlergeschäft" of Deutsche Leasing Finance.
Understood the existing DW process implemented for UCS and analyzed the sources data to created requirement document to perform ETL.
Understood the business functionality of contracts module based on the functional specification document and explained the same to the team members.
Involved in workshop for understanding the Full load and Partial load concepts for the existing UCS system.
Have proposed changes to the existing design, identified the gaps in the existing system and provided relevant documentation to convince the design team to follow a simpler approach and a result oriented one.
Created Mappings and process flows using Oracle Warehouse Builder (OWB) for loading the data into the staging area and perform cleansing of the data for further processing. Applied business logic for transformation of data.
Was responsible for contracts and commission module which covers 80% of the complex business logic involved in CETELEM.
Extensively involved during System Integration Testing (SIT).
Created vigorous unit test cases to cover all the functionality involved in these two modules and ensured a successful UAT with 0 prior one defect.
Involved in technical documenting of the entire process along with analysis and design of the functional specification documents.
Was engaged in peer reviews during design, coding and testing.
Environment: Oracle Warehouse Builder, SQL developer and Oracle PL/SQL.
Sep '07 – Jul ’08
PL/SQL Developer in Hexaware Technologies, Chennai
Project: DL (Data Migration)
Deutsche Leasing AG (DL) is one of Germany's largest and most successful leasing finance companies. The company provides a comprehensive range of leasing services and insurance packages for information and communications technology assets, vehicles, machinery, industrial equipment, medical technology equipment and energy products on behalf of thousands of business customers throughout Europe
Was involved in analysis of the source systems and proposing formats for source data.
Developed PL/SQL procedures based on complex business logic for Data Migration.
Extensively involved during System Integration Testing (SIT) and User Acceptance Testing (UAT) execution.
Involved in Analyzing Defects and provided data correction Scripts if necessary.
Did performance tuning by using cost based SQL tuning, dropped indexes and re-created them after loading data to targets and re-wrote several codes to use PL/SQL collections.
Involved in Technical documentation of the entire process.
Was responsible for creating the execution check list for major modules.
Analysis and Design of the Functional Specification Documents.
Was responsible for setting up test environment and facilitating testing team for every build release.
Worked closely with the client and resolved the queries raised by offshore team.
Involved in the successful implementation of the entire data migration at the Client place.
Provided direction to offshore team for post go live support.
Coordinated with various vendors and execution managers during the go-live phase.
Environment: Java Oracle PL/SQL.
Customer Portfolios, USA
Mar '07 – Sep ’07
ETL Developer in Bahwan Cybertek Pvt. Ltd, Chennai
Project: Marketing Data Mart
Customer Portfolios(CP) score business lies in enabling to do measurable and intelligent marketing through CP Data mart.
CP provides marketing services for improving customer loyalty and for acquiring new customers by designing and running loyalty programs and campaigns. Marketing Data Mart is done using ETL (Extraction Transformation and Loading) in which we get the data from different sources and different formats. We massage the data, apply cleansing and present the data in a logical manner and load it in Data marts.
Scheduled jobs in Automate tool to get the file from FTP and load them into appropriate servers.
Did mapping and populated data into staging, ODS and data marts using Pervasive tool.
Created stored procedures, functions, packages and triggers to populate data into CDR.
Prepared unit test cases to test mapping with complex business functionality.
Configured runtime assistant manager to organize maps into appropriate modules and to run them parallel and sequentially based in business requirement.
Used the transformations like lookup, filter, aggregator, joiner, de-duplicator, splitter, merger, set operator, pre-map process, post-map process and expressions in the development of data stage jobs.
Used runtime assistant manager for running, monitoring and scheduling the jobs.
Performed troubleshooting and debugging of new and existing ETL solutions.
Did analysis, design, and implementation of new subject areas into the project environment.
Complied with the development standards while performing complex system analysis and design.
Created, reviewed, maintained and tested ETLs based on design document.
Created effective error handling mechanism.
Consistently delivered build without any schedule slippage.
Environment: Automate, Pervasive, Toad and Oracle PL/SQL
Thomas Cook Al Rostamani Exchange Co LLC, UAE
Mar '06 – Mar ’07
Data Modeler also involved in DBA activities in Bahwan Cybertek Pvt. Ltd, Chennai
Project: Foreign Exchange and Currency Transfer System- iFACTS
iFACTS is a web based business solution to handle the end to end operations of Thomas Cook Al Rostamani Exchange Co LLC, which covers Front Office operations, Back Office operations, Fund Transfer Department operations, Dealing Room operations, Head Office operations and Helpdesk.
The solution facilitates inward, outward remittances, foreign currency exchange, travelers cheque buy & sell, prepaid cards to mention a few and helps in streamlining the business processes by establishing a work flow between the departments.
Coordinated with the Business Analyst team and understand the application’s business requirement
Created ER Model for various flows of the application using Erwin Platinum.
Created Subject area to group the ER modal based on functionality.
Did forward and reverse engineering to create schema for Oracle 10g database
Created various environments for development and testing team.
Created macro in ER tool for maintaining the naming conventions, which was applied at the time of Forward Engineering process.
Created Traceability Matrix to find whether the requirements were met.
Facilitated the testing team with database issue for every build release.
Created complex views, synonyms, sequence, stored procedure, functions and triggers based on business need.
Designed audit tables for effective logging and capturing crucial change in data.
Environment: Erwin Platinum and Oracle PL/SQL
Bachelor in Information Technology from Sree Sastha College of Engineering, Anna University, April 2005.
State Board Examination XII from St. Mary’s Matriculation Boys Higher secondary School, April 2001.
Matriculation Board Examination X from St .Mary’s Matriculation Boys Higher secondary School, April 1999.
Have been awarded as Employee of the month in Hexaware Technologies
Have received Apex and Diamond award in CGI (formerly called as ‘Logica’).