SUMMARY

• 9 Years and 4 months of IT experience in teh Design, Analysis, Development, Implementation, Application Support and Admin in various Data Warehousing applications.
• Involved in all stages of Software Development Life Cycle (SDLC) right from requirements gathering till teh Project go LIVE.
• Strong experience in Extraction, Transformation and Loading (ETL) mechanism using AB Initio, and noledge of full life cycle development for building a Data Warehousing.
• Good experience on Data warehousing Concepts, Dimensional modeling like Star and Snow flaks Schema.
• Good experiences in shell scripting and UNIX / LINUX commands usage.
• Having good experience in ticketing tools like HP Service manager - 7 and Service Now.
• Strong experience in Development, L3,L2, L1 Analyst and Admin Activities.
• Having Good Experience on Banking and Finance domain.
• Strong analytical & Ability to co-ordinate effectively with development teams, business partners, end users and management.
• Having Good noledge on Hadoop Eco Systems and worked on POC.
• Experience in interacting with Business users to analyze teh Business requirements.
• Interacted with Business and management to evaluate teh business requirement and its implementation.
• By Using FDD, HLD Documents have prepared LLD Documents for teh all teh modules required for development.
• Worked with Admin team to setup sandboxes and other environment for new projects.
• Developed and delivered teh code as per teh business requirements.
• Involved in Coding, Client Side Validations, Database tables, views creation and testing.
• Deployed code with respective environments( DEV, SIT, UAT, OAT)and to PROD environment with teh help of users sign off.
• Extensively used AbInitio-EME data store/sandbox for version control, code promotion, and impact analysis.
• Support QA and UAT by preparing teh environments, providing execution instructions, troubleshooting issues, and resolving them and pre-production activities.
• Extensively used AIR commands to check in/check-out, perform dependency analysis and other EME related operations.
• Prepared Implementation Plans, Migration of changes in UAT, OAT and Production Environments.
• Very good understanding ofTeradataRDBMS architecture such as Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc.
• Experience usingTeradataSQL Assistant, data load/export utilities like BTEQ, FastLoad, Multi Load, Fast Export using UNIX.
• Extensively worked on Viewpoint forTeradatato look at performance Monitoring and performance tuning.
• Experience in configuring and monitoring jobs in IBM Tivoli scheduler
• Supported tactical and strategic goals of teh IT Production Support Team.
• Expertise working experience on improving Performance and Troubleshooting of teh Abinitio graphs, Unix and monitoring AbInitio run time statistics.
• Worked on all teh Abinitio changes from 2.15 to 3.0.
• Performed bulk data load from multiple data sources (Flat Files, Mainframes, SAP) to Teradata.
• Provided in-depth analysis to resolve production and application issues.
• By Using Shell Script, Abinito and Tivoli Automated batch monitoring process and auto email were sent to teh business users and downstream applications.
• Experience in interacting with Business users to analyze teh Business Process requirements.
• Expert noledge in using various Ab Initio components such as Join, Reformat, Scan, Rollup, Normalize, De-normalize, Partitioning and De-partitioning components.
• Well versed with various AB Initio parallelism techniques and implemented Ab Initio Graphs.
• Experience in using EME for version controls, impact analysis and dependency analysis.
• Designed and developedAbInitiographs, created psets and user defined functions using GDE as per teh client requirement.
• Co-ordinate with various teams during system outages and maintenance activities.
• Check Alerts, Notification emails and any tickets in teh queue and resolved as per their priority.
• Vice versa of teh shift reports and complete teh task as part them.
• Worked with SLM's for setting up with new application and update of existing application SLA's.
• Coordinated with various cross functional and source teams to help diagnose and resolve teh technical issues as per teh agreed SLA's.
• Following teh ITIL process and implemented teh concepts as per teh projects.
• Ensured timely and accurate communications with regards to status reports for projects and management.
• Monitored all teh Informatica work flows for successful execution.
• Experienced in ETL process using Informatica Power Center (9.0).
• Monitoring daily scheduled jobs to perform data load, handled teh incidents and problem record resolution as per teh application agreed SLA's.
• Worked closely with various support groups for Production environments issues.
• Respond to and resolving production issues and incidents in a timely manner, through effective RCA.
• Responsible for troubleshooting all teh issues raised by application team and if needed, work with Abinitio vendor to get teh fix for any non/unnon bug in software, in order to remediation teh issue.
• Responsible for coordinating with all distributed systems and application stakeholder for applying patches, upgrades, downtime.
• Worked with Confidential 's architects to review and prepare build documents for new Ab Initio servers (DEV, SIT, UAT, OAT and PROD & DR).
• Troubleshooting Access Related issues with GDE, EME and Co>Op
• Maintain teh Key bundle management.

TECHNICAL SKILLS

ETL Tools: Ab Initio, Informatica.

Database: Teradata and Oracle.

Programming Language: UNIX Shell Scripting,SQL,HTML.

Operating Systems: UNIX (IBM AIX), Linux, Windows Family.

Job Schedulers: IBM Tivoli, Control-M.

Ticketing Tool: Service Now, HP Service manager.

PROFESSIONAL EXPERIENCE

Ab Initio Developer

Confidential, Brooklyn, NY

Responsibilities:

• Prepared documents like LDD, Detailed Design Document for teh all teh modules required for development, security interaction and test case document etc.
• Reviewed Mapping documents provided by Business Team, implemented business logic embedded in mapping documents into Ab Initio Graphs and loading tables needed for Data Validation.
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like Check In and Check Out were used for dis purpose.
• Involved in Designing teh ETL process to Extract, transform, write data into flat files and load into Data Warehouse tables.
• Worked appropriate unit-level testing, log defects in QC and teh management of teh review process for teh Ab Initio deliverables.
• Involved in loading of data intoTeradatafrom legacy systems and flat files using complex MultiLoad and FastLoad Utilities using Abinitio.
• Used MLOAD Components to load data from Load Ready Files into TeradataWarehouse.
• Involved heavily in writing complex SQL queries to pull teh required information from Database usingTeradataSQL Assistance.
• Identified and Implemented performance improvement related tasks like, having correct statistics on tables, Indexes to improve performance of teh report queries using large tables.
• Fine-tuned teh existing graphs and achieved increased performance and reduced load times for faster user query performance.
• DevelopedTeradataTPT utility scripts to move teh data from PRD environment to teh lower environments for teh purpose of testing.
• Prepared Job scheduling docs and Job Inventory List (JIL) for code migration to production.
• UsedTeradataexternal loading utilities like Multi Load, TPUMP, Fast Load and Fast Export to extract from and load effectively intoTeradatadatabase
• Documentation of complete Ab Initio Graphs.

Environment: Abinitio 3.1, IBM Tivoli Job Scheduler 8.6, Teradata 14, UNIX 5.5, 6.0/Linux, Windows 7.

AbInitio Developer

Confidential, Wilmington, DE

Responsibilities:

• Responsible for designing and Analyzing teh requirement and development of graphs and scripts to get appropriate results.
• Involved in Amendments of Graphs, code review, performance tuning and optimization of graphs.
• Extensively used EME for Version Control and Code Promotion.
• Done appropriate unit-level testing of work products and teh management of teh review process for teh AbInitio deliverables.
• Testing of teh graphs and application.
• Tracks and reports on issues and risks, escalating as needed.
• Responsible for application releases, Hot Fixes from development, testing through making a general available product.
• UsedTeradataexternal loading utilities like Multi Load, TPUMP, Fast Load and Fast Export to extract from and load effectively intoTeradatadatabase.
• Used variousTeradataIndex techniques to improve teh query performance.
• Implementing a solution for teh impacted to applications in production as per defined business rules using Abinitio andTeradatautilities.
• Supported other ongoing projects: Software Upgrade project fromTeradataTD13 to TD14
• Scheduling tool Tivoli to create teh jobs and schedules, also used teh same for setting up teh jobs for execution.

Environment: Abinitio 2.15, 3.0, Teradata 13, 14 UNIX AIX 5.5, Tivoli 8.4, Service Now, HP Service Manager

L3 Analyst

Confidential

Responsibilities:

• Involved in Designing teh ETL process to Extract and load data from SAP BW, SAP FI, Mainframe files, flat files to Teradata data warehouse.
• Reviewed Mapping documents provided by Business Team, implemented business logic embedded in mapping documents into Ab Initio Graphs and loading tables needed for Data Validation.
• Prepared teh Detailed Design Document for teh all teh modules required for development.
• Responsible for analyzing source and target data models and making necessary changes to teh mapping document if required.
• ReducedTeradataspace used by optimizing tables - adding compression where appropriate and ensuring optimum column definitions.
• Populate or refreshTeradatatables using Fast load, Multi load utilities for user acceptance testing and loading history data intoTeradata
• Involved in providing KT for application support team whenever a new code/application is rolled out into Production environment.
• Batch Job Execution and monitoring using Tivoli scheduling tool.
• Used variousTeradataIndex techniques to improve teh query performance.
• Managed teh Offshore model and was responsible for interacting with teh offshore team.
• Worked on Production Incidents, Problem Records and Change Records.
• Identifying teh existing performance issues and tuning theInformaticawork flows for optimal performance.
• Analysis of performance bottle necks and improve teh performance atInformaticaand data base.
• Automated teh jobs by considering their internal dependencies and based on upstreams using Tivoli as scheduling tool.
• Closely working with Business users during teh month-end, quarter end and year end support activates and provides timely updates for financial closure which are critical to teh Business for reporting purpose.
• Worked on Abinitio Admin Activities.

Environment: Abinitio 2.15, 3.0, Informatica 9.0, Teradata 12, 13, UNIX 5.0, 5.3 Linux, Tivoli 8.4, HP Service Manger and Service Now.

Software Engineer

Confidential

Responsibilities:

• Monitor, Respond to and resolving production Incidents with in SLA's through effective root cause analysis and solution identification.
• Production Support to customer interact via Phone, Web Ex/GotToMeeting to resolve critical problems.
• Operational batch jobs monitoring which includes incoming files monitoring, base data loads, validate and publish of teh data, reporting data loads, performing data integrity checks after processing, housekeeping at Abinitio, UNIX and Database level both etc.
• Perform analysis & take appropriate action on failed/hung/slow-performing jobs.
• To share daily/weekly/monthly reports to senior finance stake holders with minute details related to teh critical graphs and UNIX environment and databases.
• Provide Root Cause Analysis (RCA) for high priority issues (Tier 1’s and service impacting Tier 2).
• Closely monitoring of Services to accept incidents within teh SLA and providing appropriate updates and after resolution service Restore/close teh case as per guidelines.
• Investigation of data integrity queries from customers.
• I have responsibility of both incident and problem manager to keep teh incident count lower and to support our team to keep teh incident count in control. Also, to manage teh problem records.
• Closely working with Business users during teh month-end, quarter end and year end support activates and provides timely updates for financial closure which are critical to teh Business for reporting purpose.
• I am teh owner to prepare and share teh weekly and monthly application health status report and incident/problem/change report to senior stake holders.
• Provide Knowledge transition sessions in both business and technical areas for fellow on site / offshore team members.
• Worked on Abinitio Admin Activities.

Environment: Abinitio 1.15, 2.15, Oracle 10g, UNIX 4.3, Windows, Control-M.