SUMMARY:

• 7.8 years of total IT experience on multiple technologies and domain.
• 4+ years of experience in developing software throughout lifecycle, from identifying requirements, Design, Development to QA debugging, Implementation, testing and support. Proven background of completing projects on time and under budget.
• 5+ years of experience in developing software using Ab Initio 2.15/ Ab Initio 3.0 software versions
• 3.8 years of experience as a team lead; skilled in motivating and leading peers, and scheduling project activities.
• 1 year of experience in developing software using Oracle Hyperion Essbase.
• 8 months experience in Tableau 8.3/9 versions in developing dashboards.
• Extensive technical skills in Extraction, Transformation and Loading of the data from multiple sources into Data warehouse using Ab Initio V2.15/ Ab Initio 3.0/ Hyperion Essbase / Oracle/ DB2/ Unix/Linux Operating systems.
• Strong knowledge of Data Modeling methodologies such as Star Schema and Snowflake Schema and tools such as Ab Initio Data Profiler.
• Experience in Configuring and Installation of Talend Open Studio 5.5.1, Talend Enterprise Edition, and JDK 1.7 servers on windows OS.
• Strong Knowledge in Big - data tools like Hadoop, Hive, Hbase, Sqoop, Pig-latin.
• Good exposure to multiple relational databases including Oracle, DB2.
• Good knowledge on Banking and Finance Domain.
• Extensively used EME for version control, Repository manager.
• Experience in scheduling process using job schedulers such as CA7, Autosys.
• Experience in developing wrapper scripts for scheduling Ab Initio Graphs, Informatica Mappings.
• Thorough knowledge of korn shell scripting, SQL, PL/SQL programming.
• Experience in writing SQL query, Procedures, Triggers, and Functions necessary for maintenance of the databases in the data warehouse development lifecycle.
• Superior analytical, time management and problem-solving skills.
• Impressive ability to effectively communicate a broad set of topics, ranging from business terminology to complex technical solutions, to a diverse audience.

TECHNICAL SKILLS:

Operating Systems:  Windows XP/7, Unix (AIX/HPUX), Linux

Languages:  C, SQL/PLSQL

Databases:  DB2, Oracle 10g/11g/9i, SQL Server

Database utilities:  Toad for Oracle, Toad for DB2, DB2 command editor

ETL Tools:  Ab Initio V2.15, Ab Initio 3.0, Control Center, OPS Console, EME, Meta Data Hub

Software Engineering:  SDLC, Agile

Web Languages:  HTML

Scheduling Tool:  CA7, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC 

Mortgage Operational Data Environment (MODE)

Responsibilities:

• Working as an Onsite Solution Design Engineer with clients, Business Analysts, Data Modelers and creating Ab Initio graphs from Scratch.
• Proposing the Solution/Design for upcoming new Projects for each upcoming release projects.
• Worked for Admin activities for Ab initio up to the extent for these upcoming Projects.
• Working in SDLC, involving business requirement discussions & decisions.
• Preparation of High level & Detail level design documents.
• Preparation of Source to Target Mapping documents.
• Reverse Engineering & analysis for Teradata tables back to source files.
• Worked on resolving the data lineage issues by modifying the existing graphs and addressing the dependency analysis errors.
• Involved in code reviews, performance tuning strategies at ab initio and Database level.
• Modified the Ab Initio component parameters, introduced phases, utilized data parallelism and thereby improving the overall performance to fine-tune the execution times.
• Code migration from development to production after unit testing & system testing.
• Stress Performance testing for all production like schedule along with the upcoming new release jobs in Integrated/Stress and Load performance Test Environment.
• Fixed Defects / Bugs reported by the Functional Testing Team.
• Used different EME Air commands in project promotion like air tag create, air save, air lock, air project export etc.
• Involved in project migration from development to QA and QA to UAT and then to PROD.
• Developing the Dashboard in Tableau 8.3/9 for MODE production Support and other teams involved.

Environment: Ab Initio V2.15, Ab Initio 3.0, AUTOSYS, Oracle SQL Developer, Teradata SQL Assistant, Windows XP, UNIX (HP-UX), LINUX

Confidential, Atlanta, GA 

Consumer Banking

Responsibilities:

• In SunTrust account, I was working on a production support project at Atlanta, US. My role is of ETL lead, I have to interact with Client and business users to solve any issues and getting work done from my onshore and offshore team. Along with this, I do code and documentation review, enhancing code for better performance and fixing the issues if required and doing minor development. We have critical month/quarter/year end process. Below is the brief description about the project.
• Production Support Optimization for Confidential is a large complex project involving many Lines of Business and a large number of applications with stringent SLA conditions. The project involves providing the client with round the clock production support and value added services like preventive maintenance and reviewing impacts of new releases. The objective is to maintain the health of the data integration systems and avoid any impact to the downstream LOBs or departments.
• This project also includes following services.
• Application production support comprising of incident, user request and problem tickets. This includes Emergency break fix and associated unit testing.
• Perfective maintenance to avert future foreseeable application issues, in order to improve performance, quality, reliability, efficiency, usability and maintainability of the application.
• Business continuity activities including, disaster recovery planning and support for exercises and events.
• There were 130 applications including monthly and daily. Applications were either loading the data mart or providing files to downstream. Requirement of this project was to make sure that issues were resolved within defined SLA time and with correct data to downstream or Data Mart. Applications were based on Debit card Data, Credit card data and Retail/Commercial Loans. In case of issues with production data, we were required to work in parallel to Business/End Users. There were critical daily and monthly applications which were having direct impact on reports generated for Business Users.
• Knowledge Transition planning and preparing system appreciation documents.
• Business continuity activities including, disaster recovery planning and support for exercises and events.
• Business Impact analysis of system changes and implementing necessary changes in the application.
• Implement perfective maintenance to improve the system health and performance.
• Defect prevention and documenting learning’s.
• Resolve production incidents and document the steps involved in resolution.
• Coordination with Enterprise Testing Organization for maintenance and execution of regression test scripts.
• Capacity planning and co-ordination.

Environment: Ab Initio V2.15, Ab Initio 3.0, CA7, DB2 Command Editor, Windows XP, UNIX (HP-UX), LINUX

Confidential 

Finance Analytics

Senior Software Engineer

Responsibilities:

• Knowledge Transition planning and preparing system appreciation documents.
• Business continuity activities including, disaster recovery planning and support for exercises and events.
• Business Impact analysis of system changes and implementing necessary changes in the application.
• Implement perfective maintenance to improve the system health and performance.
• Defect prevention and documenting learning’s.
• Resolve production incidents and document the steps involved in resolution.
• Coordination with Enterprise Testing Organization for maintenance and execution of regression test scripts.
• Capacity planning and co-ordination.

Environment: Ab Initio V2.15, Ab Initio 3.0, CA7, DB2 Command Editor, Windows XP, UNIX (HP-UX), LINUX

Confidential 

Ab Initio Developer

Responsibilities:

• More than 1500 Informatica workflows were involved.
• More than 650 scheduling jobs were involved.
• More than 650 UNIX Scripts were involved.
• Development of enhancement requests for the Data Quality Items
• Planning and execution of Test Cycles.
• Impact Analysis for the change requests.
• Defect tracking & fixing activities.
• Daily support of the application involving monitoring.
• Leading offshore team.
• Performing process related activities.
• Code migration activities across the test environments.

Environment: Ab initio V2.15, AUTOSYS, Toad for DB2, Toad for Oracle, Windows XP, UNIX (AIX)

Confidential

Senior Software Engineer

Responsibilities:

• Designed and Built Ab Initio Graphs for unloading data from different source systems.
• Worked with DB2 to retrieve the data from source systems for data processing.
• Involved in the migration of the code in QA environment with QA team and completed rigorous unit testing of each graph.
• Extensively used Enterprise Meta Environment (EME) for version control.
• Followed the best design principles, efficiency guidelines and naming standards in designing the graphs.
• Writing the generic .dbc files for the Development, Testing and Production Environments.
• Designed reusable Centralized graphs as a part of this project. These graphs are being used with minimal changes for the Quotes data of other regions.
• Testing the graphs for performance. Performance improvement measures included the use of the Multi file system feature of Abinitio. This brought about a substantial improvement in performance deriving on the inherent parallelism features of Abinitio.

Environment: Ab initio 2.15, DB2, Autosys, Windows XP, UNIX (HP-UX)