PROFILE:

• Currently working as ETL Lead and Developer with close to 8 years experience in the IT Industry.
• Extensive work experience on Extraction, Transformation and Loading using AbInitio.
• Proficiency in Oracle SQL & PL/SQL and SQL Server with backend as UNIX, Linux.
• Good knowledge on Reporting tools, Business Objects XI 4 and Cognos 10.
• Strong understanding of Software Development Life Cycle (SDLC) and QA Processes.
• Extensive knowledge in Data warehousing concepts - OLTP, Star schemas, Dimensional, Transactional tables, Business Intelligence, Data Modeling, normalization & generating schema, understanding of the data structures & data dictionary and ETL load process.
• Gained significant expertise in Banking & Health domains.
• Experience in working with business analysts to identify, study and understand requirements and translate them into ETL implementations.
• Hands on experience with Unix shell scripting and knowledge on Perl scripting.
• Involved in installing and upgrading Metadata Management tool. Also worked on enhancements and customizations of the product.
• Working knowledge with application servers like BEA Web logic 10.3, IBM Web sphere 8.5.5 and web servers like Apache Tomcat.
• Effectively used version-controlling systems - VSS, RCS, CVS, and SVN.
• Well versed with bug tracking tools like HP-QC, Jira and Mantis Bug Tracker.
• Gained good domain knowledge in every project I worked, which in turn helped me in understanding the business/technical metadata.
• Experience leading and managing a large team spread across Onsite, In-house and Offshore development facilities.
• Excellent problem solving capabilities, interpersonal skills, self motivated with natural leadership qualities and good communication skills, ability to work as an integrated team and independently.

TECHNICAL SKILLS:

Languages: C, C++, .net, Unix Shell Scripting

Tools: AbInitio 3.2.2, Business Objects XI, Cognos 10

Web Technologies: HTML, JavaScript, CSS, JSON, XML

Operating Systems: Windows, Mac-OSX, iOS, Unix, Linux

Application Servers: Web logic 10.3, Web sphere 8.5.5

Databases: Oracle, MS SQL Server

Domains: Banking and Financial, Health Care

Version Controlling Tools: SVN, VSS, RCS, CVS

Bug Tracking Tools: Jira, HP-QC, Mantis Bug Tracker

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Environment: Abinitio 3.2, Unix, Oracle 11g, Web Sphere, XML

Lead - ETL Developer/Analyst

Responsibilities:

• Requirements gathering, analyze the workflow, design documents and implement.
• Building ETL strategy and ensure Business rules have been applied as per customer requirements.
• Identify areas of potential impact and associated risks in order to ensure maximum quality product.
• Conducted Knowledge transfer sessions with offshore team to socialize the customer requirements and development strategy.
• Developed various medium and complex mappings for Loading Data in to Target tables.
• Implemented Complex logic, Error Handling logic.
• Conducted code review, which is been developed by the team. Communicate test progress, test results, and other relevant information to project stakeholders.
• Demonstration of the functionality tested in each of the module to the Business Analyst & Users.
• Involved in importing the metadata from different sources and created reports using the built in mechanisms.

Confidential, Warren, NJ

Environment: Abinitio 3.1.6.8, Linux, Oracle 11g, Web Logic, Java, Autosys R11.3

Senior ETL Developer

Responsibilities:

• Developed complex ETL graphs using Abinitio components like join, sort, reformat, and filter by expression.
• Testing - Involved in Unit and System Testing, reviewing the mappings to check the data consistency.
• Designed various reusable modules which would improve efficiency and over all performance of the application.
• Involved in writing the shell scripts and created autosys scripts for scheduling jobs.
• Worked on SQL Queries to extract the data and wrote Stored Procedures, Functions.
• Documented & maintained the project related documents in SharePoint web portal.
• Involved in Application migration and performed sanity checkouts extensively.
• Conducted WebEx sessions for Knowledge transfer and status calls on weekly basis.

Confidential, Deerfield, IL

Environment: C/C++, UNIX, Pro C, ORACLE 10g, Visual Studio, XML, HTML, Visual Source Safe, HP-QC, Tuxedo.

Systems Engineer

Responsibilities:

• Involved in analysis of the requirements.
• Created test scripts for Unit Testing, System Testing and Integration testing.
• Prepared High Level Business Requirement Document, Technical Design Document.
• Developed Unix scripts to print the controlled and non-controlled prescriptions with the barcode.
• Created Daemons to make best utilization of CPU.
• Handled the task of identifying and fixing bugs that are reported by the users.
• Wrote multiple scripts to automate test, build and release procedures.

Confidential, Santa Clara, CA

Environment: Business Objects Universe designer, Web intelligence Tool, Oracle 10g, Cognos Framework Manager and Reporting tools.

ETL Developer

Responsibilities:

• Creating the underlying tables, schemas.
• Installed Cognos Framework manager and Cognos content store.
• Created the Framework model using the Business Objects Universe as .
• Generated the mappings and published the projects to be viewed on the content store.
• Created simple linear, complex cross tab and chart graphs.
• Extracted the graphs in pdf and xml formats.

Confidential

Environment: Unix, SQL, MS Excel, Power point, Visio, Mantis Bug tracker.

Unix Admin

Responsibilities:

• Maintaining the entire production environment. Activities included adding new users, creating home directories, resetting passwords.
• Managed the file structure and cleaned up the unwanted old logs to increase space.
• Created support tickets using Mantis Bug Tracker and follow-up on the pending issues.
• Involved in team meetings and created power point presentations, Visio diagrams and flow charts.
• Helped co-workers to get to the speed and worked as a good team player.
• Attended s to enhance my inter-personal skills and get technical exposure.
• Coordinated with onshore business users and gained knowledge on onsite work culture.
• Gathered information from all the project resources and prepared documents, which will guide new users to understand the details of the project.