PROFESSIONAL SUMMARY

• An ETL Developer/Lead/Data Analyst with 5.6 years of experience. Very strong professional background in Data warehouse and IT experience in the software engineering and processes and methodologies of SDLC.Extensive professional experience in data profiling, data analysing, Creating analysis reports,project planning, designing, development, and test of applications using ABINITIO ETL Tool, worked closely with business, gathering Business requirements for Enterprise Business Intelligence Team, understanding client issues and translating into functional requirements. Worked on latest Data Vault modeling technique. Experience working on Agile/Scrum methodology projects.
• Familiar with tools like QRM TDM tools and Abinitio Meta data HUB.Experience in developing abinitio code from complex mappings, with help of components like, PDL, XML, call web service, Rollup, Normalize, Partitioning components, reformat, lookup, Filter By expression, Sort, Dedup, Input/Output/Update Table, air commands and other utility commands e.g. m db, m dump etc., worked on database like Netezza, DB2
• Skilled in Planning, Analysis, Designing, developing and deploying Data warehouses.
• Involved in ETL Migration strategy, Data Lineage and defining the data granularity.
• Good hands - on experience in creating technical design document, ETL Process design, ETL logic conversion, Deployment, Production Data volume estimation.
• Experience in UNIX Shell scripting to provide effective solutions, creating Parameter files, Process Log files, Automated Archival of log files, Scheduling ETL jobs
• Performed Advanced level Data warehouse testing, which verifies and validates the ETL Mappings, table loads.Experience in building QA/UAT test cases and defect tracking using Quality Center (defect tracking system).
• Good Team player possessing good inter-personal, strong analytical and problem solving skills, communication skills, presentation skills, proven leadership qualities, mentored a team of developers with industry best practices.

TECHNICAL SKILLS

ETL: Abinitio ETL Tool (Co>operating System 3.0.4.3, GDE version 3.0.2)

Operating Systems: Windows, UNIXProgramming Languages C/C++, UNIX shell scripting, SQL, JAVA (Basic)

Data base: DB2, Netezza, Oracle SQL server.

Applications: MS Office Suite (Word, Visio, Excel, PowerPoint, Outlook

Other tools: Tivoli scheduler, QRM TDM, Meta data hub,Version One.

PROFESSIONAL EXPERIENCE

Confidential, VA

Calculating Liquidity Coverage

Responsibilities:

• Data profiling, data analysis of all line of business source to check existing data related to Confidential .
• Writing queries for data analysis.
• Data volume, data quality checks for existing data for Confidential reporting.
• Meetings with business as well as Business analyst to gather source data as well as source business knowledge. Creating Source to Target mapping tracker. Creating Analysis reports.
• Gathering requirement for ETL development scope in the calculating Confidential .
• Active participation in Design,Analysis and project planning meeting to finalize design, implementation approach.
• Creating in detail design document from gathered requirement.
• Developing Abinitio code based on requirement, guiding offshore team for code optimization.
• Code review, Unit Testing, Design review, Production Implementation of code.

Oracle SQL Developer

Confidential

Responsibilities:

• Analyzed around 400 interfaces to identified Agent number field in the interfaces.
• Run the Abinitio interfaces with new alphanumeric agent number.
• Test the transformation function results to convert the string to Hex data type.
• Validate the interface output file before and after change.
• Coordinate with QC team for the QA testing.
• Daily status reporting with the updates to client.
• Writing wrappers scripts in UNIX to run the Jobs.
• Use Tivoli scheduler to schedule jobs by raising the appropriate job scheduling requests.
• Migrate the updated interfaces to production.
• Handled Post production implementation issues.

Environment: Abinitio (version: 2.5)

Oracle SQL Developer

Confidential

Responsibilities:

• Identified all the landing zone, prerun locations, interfaces, scripts and Abinitio related objects path to convert the old server location to new server location for the execution.
• All database changes for the new server.
• Project level parameters changes for new servers.
• Coordinate with upstream team of all applications to update the changes with landing zone and prerun locations.
• Coordinate with UNIX admin to form the MFS and folders on the new UNIX servers.
• Migrate the all interfaces from old server to new server.
• Test the interface running successfully on new server.

Environment: Abinitio (version: 2.5)

Oracle SQL Developer

Confidential

Responsibilities:

• Analyze all Abinito interfaces to filter out the agents apart from Allstate agents.
• Run the interface with filter condition and test the interface output after changes.
• Unit and system testing and creation of test results.
• Writing wrappers scripts in UNIX to run the Jobs.
• We use Tivoli scheduler to schedule jobs by raising the appropriate job scheduling requests.
• Production migration of the impacted interfaces.
• Post production implementation issues.

Environment: Abinitio (version: 2.5)

Oracle SQL Developer

Confidential

Responsibilities:

• Analysis, Testing, Documentation, Maintenance, application Support.
• Production support (Application monitoring, monitoring job Abends, and fixing production issues).

Environment: IBM CM content management tool