May 2017 – Dec 2022 · 5 yrs 7 mos · Gurugram, Haryana, India

• Data Architect at Aristocrat Technologies

Apr 2015 – May 2017 · 2 yrs 1 mo · Gurugram, Haryana, India

• Senior Consultant Technical Lead

Nov 2013 – Mar 2015 · 1 yr 4 mos · Dallas-Fort Worth Metroplex

• SOUTHWEST AIRLINES is a major U.S. airline and the world's largest low-cost carrier, headquartered in Dallas, Texas. The airline was established in 1967 and adopted their current name in 1971. The airline has more than 44,000 employees as of December 2013 and operates more than 3,400 flights per day. As of June 5, 2011, it carries the most domestic passengers of any U.S. airline. As of November 2014, Southwest Airlines has scheduled service to 93 destinations in 41 states, Puerto Rico, Mexico, Jamaica, Bahamas, etc. Southwest Airlines has solely operated Boeing 737s. As of August 2012, Southwest is the largest operator of the 737s worldwide with over 550 in services, each averaging six flights per day. On May 2, 2011, Southwest Airlines completed the acquisition of AirTran Airlines but full integration of AirTran into Southwest's continued till 2014. On July 1, 2014 Southwest Airlines went international with first flights to Jamaica, Bahamas, etc. On October 13, 2014, the Wright Amendment restrictions at Dallas Love Field were repealed and Southwest expanded service at Love Field to include cities outside of the previous location restrictions.
• This project was about Acquisition of AirTran to Southwest. Contracts for all Southwest Crew Members (Pilots & Flight attendants) were renewed based on new contract rules provided. Reporting is done through Essbase tool.

Oct 2012 – Nov 2013 · 1 yr 1 mo · Washington DC-Baltimore Area

• FANNIE MAE - The Federal National Mortgage Association (FNMA), commonly known as Fannie Mae, was founded in 1938 during the Great Depression as part of the New Deal. It is a government-sponsored enterprise (GSE), though it has been a publicly traded company since 1968. The corporation's purpose is to expand the secondary mortgage market by securitizing mortgages in the form of mortgage-backed securities (MBS), allowing lenders to reinvest their assets into more lending and in effect increasing the number of lenders in the mortgage market by reducing the reliance on thrifts.
• In existing Surveillance Application, 16 reports are created which shows information about the loans that are delinquent, have defaulted or are under foreclosure, etc. In Surveillance Application Redesign and Enhancement Project the existing outdated technology which is SAS and Flex is being replaced with more powerful ETL technologyo and Spotfire.

Aug 2010 – Sep 2012 · 2 yrs 1 mo · Atlanta Metropolitan Area

• THE HOME DEPOT is an American retailer of home improvement and construction products and services. The Home Depot operates 2,193 big-box format stores across the United States, Canada, Mexico and China. The Home Depot is headquartered from the Atlanta Store Support Centre in unincorporated Cobb County, Georgia. In terms of overall revenue reported to the U.S. Securities and Exchange Commission, The Home Depot is the largest home improvement retailer in the United States.
• IFC (Inbound Freight Consolidation) Centres are RDC (Rapid DC) facilities that serve as an intermediate shipping destination for other RDCs, which enable savings on transportation costs. Currently, a paper-based method is used to track the product flowing through the building.
• Roles and Responsibilities:
• Extensively involved in various iterations for designing and developing the code.
• Extensively used Ab Initio (GDE: 1.14 & 1.15) and EME for ETL processing. Ab Initio is used for extracting the data from the flat files, reference SQL Server and DB2 UDB tables, processing the business rules and finally loading and updating the data into Oracle database and sending mainframe files to the downstream system.
• Worked on Continuous graphs that can read from the IBM MQs and write data to Ab Initio Queues and MQs using Subscribe and Publish components.
• Excellent in creating the unix korn shell wrapper scripts for running the deployed graphs scripts.
• Designed and developed the ETL graphs using the Ab Initio that extract the data from various source systems like Teradata, Oracle, DB2, SQL Server and flat file systems and load into the target Teradata and DB2 database.
• Worked on performance tuning and making the existing code more effective, stable and more productive.
• Created unix shell scripts that can clean unnecessary and nonessential serial and multifiles from unix server.
• Created design documents, different unit test cases and wrote the test plan.
• ...

Dec 2006 – Jul 2010 · 3 yrs 7 mos · Jersey City, New Jersey, USA

• A.I.G. is a world leading property-casualty and general insurance organization serving more than 40 million clients in over 160 countries and jurisdictions. With a 90-year history, one of the industry's most extensive ranges of products and services, deep claims expertise and excellent financial strength, A.I.G. enables its commercial and personal insurance clients to manage virtually any risk with confidence.
• RDPS Project handles the reinsurance part of the A.I.G. Reinsurance is a means by which an insurance company can protect itself with other insurance companies against the risk of losses. This project handles the dividing the claimed amount by the insured among the various reinsurance companies. The RDPS batch process runs every night in Production and weekly, monthly and quarterly reports are created in the project that are used by the end users.
• Roles and Responsibilities:
• Extensively involved in various iterations for designing and developing the code.
• Extensively used Ab Initio (GDE: 1.14 & 1.15) and EME for ETL processing. Ab Initio is used for extracting the data from the flat files, reference SQL Server and DB2 UDB tables, processing the business rules and finally loading and updating the data into Oracle database and sending mainframe files to the downstream system.
• Worked closely with client to gather requirements. Worked efficiently and finished all assignment on time. I received many appreciation letters from the client.
• Worked on Continuous graphs that can read from the IBM MQs and write data to Ab Initio Queues and MQs using Subscribe and Publish components.
• Upgraded the Co>op from 2.14 to 2.15
• Excellent in creating the unix korn shell wrapper scripts for running the deployed graphs scripts.
• Worked on converting Stored Procedures into Ab Initio code to increase the performance. I extensively worked with SQL, PL/SQL in Oracle database.
• ...

Aug 2005 – Jul 2010 · 4 yrs 11 mos · Jersey City, New Jersey, USA

• Roles and Responsibilities:
• Hands on experience in end-to-end Data warehousing ETL routines, which include writing custom scripts, stress testing, data mining and data quality processes.
• Took responsibility of creating a new Ab Initio project and environment for this requirement which did not exist earlier.
• Used Ab Initio to extract the data from the tables, create the file extract, zipping of table extract and sftp the zipped extract to the Oceanwide windows server.
• Developed unix korn shell wrappers to run various Ab Initio deployed Scripts.
• Created a generic graph to load the data into the oracle database systems
• Created several generic graphs that is being used by all Ab Initio developers to minimize development hours.
• Performed the tuning of the Ab Initio graphs and the databases to improve efficiency of the applications
• Designed and created the graphs from “non-parameterized” to “parameterized” graphs where ever required.
• Designed the end-to-end ETL applications for the loading of the data into the oracle database systems from the source data files.
• Wrote several complex SQL queries to extensively test the ETL process. I extensively worked with PL/SQL, SQL in Oracle database.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Standardized the Nomenclature used to define the same data by users from different business units.
• Involved in different types of testing including system testing, integration testing, Regression testing, Whit Box testing and Black box testing. Prepared and implemented the data verification and testing methods.
• As a Project lead I am involved in understanding the clients database and identifying the significant fields to extracts and extensively involved in extraction of Production database to different flat files.
• Extensively worked with Multi files system and used Partition Components and Departition components extensively.
• ...