SUMMARY

• Over 11 years of IT experience in Analysis, Design, Development, Testing and Implementation of various data warehouse applications using Ab initio 3.X,DQE, Express IT, Oracle 11g, Teradata 14, UNIX
• Good knowledge on Ab initio DQE and Express>IT (BRE and ACE).
• Expertise in creating complex DQE rules and creating appconf as per KDEs.
• Excellent Knowledge in handling complex ETL processes.
• Hands on experience in handling data from various source systems such as Flat Files, XML Source, Oracle, MS SQL Server, IBM DB2, Teradata and Excel Files
• Well versed with various Ab initio parallelism techniques and implemented several ab initio Graphs using Data parallelism and MFS techniques.
• Very good knowledge on Stress and load performance testing for Ab initio jobs.
• Expertise and well versed with various Ab Initio Transform, Partition, Departition, Dataset Database components, sort, validate and compress
• Expert in writing UNIX Shell Scripts including Korn Shell Scripts.
• Very good experience with Oracle Database and Teradata Database.
• Excellent analytical & problem solving and business interaction skills.
• Experience in all the phases of SDLC for Data Warehousing ETL projects.
• Created Sandbox and edited Sandbox parameters according to repository Extensive exposure to EME.
• Around 3 Years progressive experience in Business Analysis, Reporting and preparing dashboards for enterprise wide applications using Tableau 8.X, Tableau 9.X and Tableau 10.X
• Excellent communication skills and experience in client interaction while providing technical support and knowledge transfer.
• Good knowledge on Bigdata echo system, Name Node, Data Node, Hadoop, Spark, Scala, Hive and Sqoop
• Teradata 12 certified professional.
• ITIL Foundation in IT Service Management certified professional.

TECHNICAL SKILLS

Technologies: Ab initio GDE 3.X, DQE, TRMC, ACE, BRE and Control Center, HDFS, Scala, Spark, Big data, Hive, Sqoop

Databases: Oracle 11g/10g, Teradata V12, 14, MS SQL Server

Database Tools: TOAD, SQL Developer for Oracle, Teradata SQL Assistant V12.0 and Teradata SQL Assistant V14.1, Visual Studio

Reporting Tool: Tableau 9.X, Tableau 10.X

Environment: UNIX AIX 7.1, Sun Solaris

Tools: Remedy 7.1, Putty

PROFESSIONAL EXPERIENCE

Senior Ab Initio Developer

Confidential

Environment: - Ab Initio 3.2.7.2, AWS, Oracle, UNIX and Automic

Responsibilities:

• Responsible for managing the delivery from onshore by attending all project related meetings to understand scope of work, analyze business, engineering, user requirements, data processing applications and propose new design solutions.
• Involve complex anti money laundering (AML), currency transaction reporting (CTR) and suspicious activity reporting (SAR) projects design, development and rollout to production environment.
• Responsible for creating the AML, CTR and SAR data with Ab initio, Bigdata, AWS tools and providing them to the investigation team for their review before sharing the data with U.S regulatory authority FinCEN.
• Responsible for attending all AML, CTR and SAR Ab Initio and Bigdata project related audits and providing essential details(evidence) to auditors.
• Responsible for working with OCC ETL Audit requests.
• Provide L3 Support for all the AML Ab initio jobs and load the data into stage tables without any issues so Actimize consumes the data.
• Responsible for working with the Source team to get the data and process them on time as AML have very critical SLA.
• Work Closely with Dev and AML Investigators to provide the RCA and code fix details.
• Share the sensitive data and reports with investigators for case investigations in encryption formats.
• Track all incidents that were shared by investigators and complete the RCA to fix the issues asap.
• Responsible for providing the temp solutions like reports or sharing the transactional information to investigators before deploying the code fix.
• Identify manual and repetitive work and develop solutions to automate and reduce manual work.
• Facilitates design review, code walkthrough and test results review with business, upstream and downstream stakeholders.
• Prepares new documentation, departmental technical procedures and user guides.
• Propose creative solutions to meet technical and business priorities.
• Participate in cross application efforts to share knowledge and bring new developments to the team.
• Track code merge and branching process for releases and review release code and changes for production.
• Participates in all the agile ceremonies (Daily stand ups, Sprint Planning/Grooming, Sprint Retrospective and Sprint Demo meeting) conducive to the smooth execution of the project.
• Gained experience in AML, CTR project audits and Banking and Finance domain.

Senior Ab Initio Developer

Confidential

Environment: - Ab Initio 3.2.7.2, DQE, BRE, Control Center, MS SQL Server 2014, UNIX and Autosys

Responsibilities:

• Performed Analysis, designing and preparing the functional, technical design document, and code specifications.
• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provided technical support and hands-on mentoring in the use of Ab Initio.
• Extensively used Database and Dataset components like Input file, Input table, and Output table and Transform components like Join, Rollup, Scan, Filter by expression, Reformat and other components like Merge, Lookup, Input/output table and Sort.
• Developed a number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, reformat, and rollup, join, scan, normalize, gather, merge etc.
• Worked on improving the performance of Ab Initio graphs by using various Ab Initio performance technique's like using looks instead of Join's etc.
• Implemented Lookup, lookup local, in-Memory Joins and rollup to speed up various Ab Initio Graphs.
• Developed DQE Application configuration based on the business requirement.
• Created Dataset and lookup App conf based on client requirement
• Loaded all the data profile results into the Metadata hub.
• Loaded all the results(issue counts/Scores/issue fields) into Audit Database tables
• Ran all the App Conf through Ab initio plans
• Scheduled all the AI, DQE, Dataset and Lookup app conf through Autosys.
• Entered different complex rules in Rules view and Sheet View.
• Worked on improving performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups, in memory joins and rollups to speed up various Ab Initio graphs. Designed and developed parameterized generic graphs.

Senior Ab Initio Developer

Confidential

Environment: - Ab Initio 3.2.7.2, DQE, BRE, Control Center, Oracle 11g, UNIX and Autosys

Responsibilities:

• Performed Analysis, designing and preparing the functional, technical design document, and code specifications.
• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provide technical support and hands-on mentoring in the use of Ab Initio.
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources
• Involved in developing UNIX Korn Shell wrappers to run various Ab Initio Scripts.
• Design Documentation for the developed graphs.
• Performed Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Used components like run program and run sql components to run UNIX and SQL commands in AB Initio. Also used the components like filter by expression, partition by expression, replicate, partition by key and sort Components.
• Working with Departition Components like Gather, Interleave in order to departition and Repartition the data from Multi File accordingly.
• Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by- Expression.
• Created UNIX shell scripts to automate and schedule the jobs.
• Provide overview of DQE to new partners
• As a platform support engineer for MODE team, did POC on Ab initio DQE, implemented DQE in MODE platform.
• As per business requirement implanted many validation rules using different data sources.

Senior Ab Initio Developer

Confidential

Environment: - Ab Initio 3.1.5, TRMC, Teradata 12, Teradata 14, Control Center and UNIX

Responsibilities:

• Analyze requirements and estimate project timeline for build, test and prod implementation
• Gathered Business requirements and Mapping documents.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Responsible for the detailed design and documentation. Provided technical solutions for the Process requests raised by Data team to fix the issues in the existing system.
• Designed, developed and Unit tested Ab Initio graphs using GDE for Extraction, Transformation and Loading of data from source to target.
• Created and modified various graphs based on the business rule enhancements.
• Involved in writing test cases to validate the code changes.
• Extensively used Database and Dataset components like Input file, Input table, and Output table and Transform components like Join, Rollup, Scan, Filter by expression, Reformat and other components like Merge, Lookup, Input/output table and Sort.
• Used Partition components like partition by expression, partition by key, etc., to run the middle layer processing parallel.
• Extensively used various inbuilt transform functions like string substring, string lpad, string index, lookup functions, date functions, error functions.
• Worked on improving performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups, in memory joins and rollups to speed up various Ab Initio graphs. Designed and developed parameterized generic graphs.
• Closely monitored the Autosys batch jobs in ETL batch run during System, Integration and Acceptance test runs.
• Worked closely with migration team to migrate the ETL code changes from development environment to System, Integration and Production environments.
• Extensively worked in the UNIX environment using Shell Scripts. Created test cases and performed unit testing for the Ab Initio graphs. Documented Unit testing. Logged and resolved defects in the roll out phase. Responsible for supporting the functional team and troubleshooting any production issues

Ab Initio Developer

Confidential

Environment: - Abinitio 3.0.2, Taratata 12, Toad, Teradata SQL Assistant V12.0, Putty

Responsibilities:

• Worked closely with Client’s for collecting the requirements
• Created 10 private sandboxes and 3 public sandboxes
• Responsible for Connectivity of Ab initio and Data stage with Teradata 12
• Upgraded all Ab initio jobs Abinitio 3.0.2 successfully.
• Worked with testing team to complete the integration testing.
• Maintained code in EME (Enterprise Meta Environment), creates tag, and save files for migrating code from one environment to other environment.
• Deploy the code into production and providing the warranty support.
• Coordinate with onsite team member for smoother delivery and in moving the applications to the Production Environment.
• Prepared Transition handbooks as part production support knowledge transfer from other teams

IT Infrastructure Intern

Confidential

Responsibilities:

• Installed and configured computer hardware operating systems and applications
• Monitored and maintained the computer systems and networks
• Troubleshoot system, network connectivity, hardware and software issues
• Developed procedural documentation and relevant reports that include How-to guides and daily logs