SUMMARY:

• Confidential is a Senior Ab Initio ETL consultant with over 10 years of experience. He has worked through various phases of Software Development Lifecycle (SDLC) in ETL Data Integration and Data Warehousing technologies and tools. He has extensively used ETL methodologies for supporting data extraction, transformations and loading process, in large corporate - wide ETL Solution using Ab Initio.
• Experienced in creating generic psets, generic graphs, plans.
• Experience and well versed with various Ab Initio Transform, Partition, De-partition, Dataset and Database components and experience with Ab Initio Co-Operating System, application tuning, and debugging strategies.
• Experienced writing Unix Shell Scripts including Korn Shell Scripts, CRON, Unix administration and also experienced with Teradata BTEQ scripting and DB2 SQL.
• Handled Ab Initio Migration (version), Ab Initio Server Migration, Ab Initio administration, Unix server Administration while working for ETL Infrastructure Team.
• Experience in managing teams and operating on Onsite-Offshore delivery model, single person project and on Agile projects as well.
• Experience in both real and batch time processing in Ab Initio.
• Extensively used air commands to check in/out, perform dependency analysis and other EME related operations.
• Experienced in ETL process design and documentation like HLD and data mapping documents.
• SQL development experience writing efficient SQL queries, fine tuning queries and wrote several SQL queries for ad hoc reporting.
• Effective in System Development Life Cycle (SDLC) from analysis, design, development, testing and implementation in diverse range of software applications.
• Strong functional knowledge of Ab Initio products Exterprise Meta> Environment(EME), Co>Operating systems, Continuous Flow, Control Center, Express>It before BRE/ACE, Metadata Hub, Data Profiler, Conduct>It, Data Quality Environment, Test Data Management, Data Gateway, TRWI, TRMC & others
• Strong experience in working with scheduling tools like AutoSys, Maestro, CA7, control center.
• Quick learner with excellent people skills and problem solving attitude.
• Keenly interested in implementing value additions to the projects to deliver a product which exceeds expectations.
• Experienced in translating requirements into design both written and verbal.

TECHNICAL SKILLS:

Servers: Unix and Linux servers

Databases: Teradata 13, DB2, Oracle 10g.

Frameworks/Tools: Ab Initio 2.15, 3.1.2, 3.2.4.7 CO-OP, EME, Ab Initio Administration, Power OLAP, Data mining tools, DQE, Metadata hub, Unix server administration, Hive, PIG, Hadoop files systems, CA7, IBM Maestro, AutoSys, etc,Application Life Cycle Management, Control Center, Quality center.

Integrated Development Environments and Tools: Teradata 14.0/13.0/12.0/ V2R6.2/V2R5, Oracle 10g, DB2

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr Ab Initio Developer

Responsibilities:

• Migrate the Ab Initio applications from DIME environment to Atlas Data Lake.
• Plan is to create a data lake from data of different sources.
• Develop the Ab Iinitio graphs using the GDE, perform the unit testing. And promote the tags from Dev to QA.
• Fixing the defects in the QA testing is in progress.
• Ensure the lineage is created for the project properly in the metadata hub portal in QA.
• Upon getting the UAT business sign off, promote the code to the production.
• Provide the warranty support of the applications.
• Perform the cutover of the Dime applications after the one month warranty support of applications.

Environment: Ab Initio 2.1.5, 3.1.2, Unix shell scripting, Metada hub, DQE, CA7 scheduler, Unix servers.

Confidential, Atlanta, GA

Sr Ab Initio/ETL Developer

Responsibilities:

• ETL Store operations team supports Ab Initio Development, Ab Initio application support team and first point of contact for all server related issues.
• Migrating 3.1.2 CO-OP to 3.2.4.7 CO-OP
• Ab Initio Server migration from standalone to HA Veritas cluster servers
• Teradata version upgrade to Teradata 14
• Capacity planning, user account provisioning, and various build activities

Environment: Ab Initio 2.1.5, 3.1.2, Unix shell scripting, Ab Initio administration, Ab Initio application support, Unix servers.

Confidential

Ab Initio Development - EDW Sales

Responsibilities:

• As part of Sales Project we need to bring in sales data from stores.
• This Data will be loaded to Teradata Warehouse and based on this data Micro strategy
• Reports are generated to be available to Business team and Store Managers for reporting purpose.
• The data is historical and can be drilled down to smallest granular level and can be rolled up to very high level as well.
• Highlights: This project brought down the time from 30 mins to 2 mins for sales transactions to reach Teradata DB from stores.

Environment: Ab Initio 2.1.5, 3.1.2, 3.2.4.7, Unix shell scripting, DB2 database and Oracle 10g database.

Confidential

Ab Initio Development - EDW Cashier metrics report

Responsibilities:

• This project is aimed to create consolidated cashier metrics reports to operate over 2000 operational stores of home improvement appliances across US.
• The reports are generated based upon the cashier performance across the registers in the store.
• There are key metrics in the report with which the cashier’s performance is evaluated.
• The report also has sales information rolled up for different hierarchies across the organization.

Environment: Ab Initio 2.1.5, 3.1.2, 3.2.4.7, Unix Shell scripting and DB2 database and oracle database, Unix servers.

Confidential

Ab Initio Development - WCS server upgrade Unix to Linux/ Ab Initio

Responsibilities:

• This project was to migrate the WCS Ab Initio from version . The operating system was also migrated from Unix to Linux.
• WebSphere is the front end tool which populates the product attributes into the homedepot.com portal every day. Homedepot.com is one of the largest online portal selling thousands of home improvement goods. Ab Initio gets the data from the Big hammer; a third party vendor and creates the data for the WebSphere portal. By upgrading the Ab Initio code written in ; it enables the better performance of the code.
• Analyzed business needs of clients, reviewed the business requirement with them and prepared mapping document for the source to target data flow.
• Prepared the data profiling about the final outcome of the project and developed detailed design of the coding and the design document.
• Developed the Ab Initio Graph/Jobs with offshore team co-ordination.
• Debugged and tested this code with QA team and scheduled this code for batch run using Maestro scheduler.
• Deploying the code in production and support the code until it gets stabilized.
• Maintained a good count of offshore team for the deliverables and coordinated with them for all the projects and assignments.
• Expertise in maintainingdata quality, data organization, metadata and data profiling.
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensive experience with development, testing, debugging, implementation, documentation and production support.
• Expert in Dimensional Data Modelling, using Data Modelling, Star-Join Snowflake Schema

Environment: Ab Initio 2.1.5, 3.1.2, 3.2.4.7, Teradata 13 (Teradata, Unix scripting), EME, DB2, HDDTM (scheduling utility), Heats (migration utility), Ab Initio EME.

Confidential

EDW / BI L3 Production Support

Responsibilities:

• This project is aimed for Level 3 support to various data warehousing applications with critical and crucial data. The data is used for generating reports across 2000 operational stores for home improvement appliances across US, Canada and Mexico.
• Complex failure resolution that requires functional knowledge of the data integration code.
• High Level Data Analysis and research
• Root cause analysis
• Break fix and enhancement code / scripts / schedule changes
• SM tickets management (SME’s Direct/Escalated from L2)
• Address leadership requests
• Ensure adherence to defined processes and procedures
• Performance tuning

Environment: Ab Initio 2.1.5, Unix Shell scripting, Ab Initio administration, Ab Initio application support, Unix servers.