SUMMARY:

• 8 + years of experience in IT industry and extensive knowledge and good understanding of data warehousing terminology
• Rich experience using Ab Initio tool in developing strategies for ETL (Extraction, Transformation and Loading) mechanism in complex and high volume Data Warehousing projects.
• Strong development skills includes ability to work through the entire development life ( SDLC) cycle from gathering requirements through implementation, development, production, support and documentation of the complete project.
• Worked extensively in the GDE (Graphical Development Environment), PLAN(Conduct IT), BRE(Business Rule Engine) and EME(Enterprise Meta Environment) configuring, connecting, and testing the components to produce executable flow graphs on Unix environment, Proficient with various Ab Initio Data Cleansing, Parallelism, Transformation and Multi File System techniques.
• Rich and very good hands on experience in Ab Initio Development,Ab Initio Admin,system Admin activities which includes Installation, EME maintenance, Storage capacity, Permission setup, Group creation, File system, Key server maintenance.
• Knowledge in creating the business rules transformation in BRE tool
• Expertise with most of the Ab - Initio components like Database, Datasets, Partition, De-partition, Sort and Transform components.
• Designed scalable architectures addressing parallelism, data integration, ETL, data repositories and analytics, making use of Ab-Initio suite.
• Experience in various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and MFS techniques.
• Experience with application tuning and debugging strategies
• Ability to quickly grasp new concepts and apply software methodologies as per business needs. Excellent interpersonal skills and professional communication skills and have worked extensively in a team oriented environment with a strong desire to achieve specified goals.
• Extensively used Ab Initio EME data store/sandbox for version control, code promotion, and
• Strong experience in Ab Initio GDE, Co>Operating System, Conduct>It and Enterprise Meta Environment ( Web EME),Informatica,Talend open source for data integration
• Strong development Experience in Meta programming
• Experience in Big data mapreduce,Hive query,Pig scripts,Corner Stone 3.0
• Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading
• Good Experience with Heterogeneous Source Systems like Oracle, Sql Server, Mainframe and Flat Files.
• Exposure on Reporting Tools such as Business Objects
• Provided the 24x7 support for production and testing daily, monthly and weekly data refresh and worked with fixing complex/critical production problem.
• Designed, developed, implemented and supporting projects in both independently and as a team
• Proficient using Oracle, SQL Server,Teradata, PL/SQL, SQL *PLUS, SQL Developer and TOAD .
• Good knowledge in Development,Testing,Production Support

TECHNICAL SKILLS:

ETL Tool: AB-initio 3.3.2, BRE, Web EME,Conduct>It, Express>IT,Informatica,Talend

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT, Dimension Tables.

Reporting Tools: Business Objects XI 3.1, O2ms

Languages: SQL, and PL/SQL, UNIX Shell Scripting, HTML.

Operating Systems: Sun Solaris,IBM AIX,Linux

Databases: Oracle 9i and 10g, Teradata,Sql server 2008 R2

Scheduling job: CA Autosys Workload,Control M

Defect Reporting: HP Quality Center 10.0, Team Track, HPSM

Other Tools: Putty, WinSCP, MS-Office, TOAD 7.1, 9.0, Service now

PROFESSIONAL EXPERIENCE:

Confidential, TN

Lead Abinitio Developer and Admin

Tools: Ab Initio GDE 3.3.1, Co>Operating System 3.3.2.2, Web EMEOracle 11.0, One automation, Ab Initio transcode, TRMC,EXPRESS>IT,CONDUCT>IT

Responsibilities:

• Requirement gathering from client and SME for the reporting data warehouse.
• Performing Data modeling for history tables for mainframe to oracle environment
• Estimate the sizing for the effort.
• Involved in unit testing and SIT and providing warranty support.
• Creating plans and graphs for history tables.
• Creating generic graphs for reusable tasks.
• Creating scripts to execute the continuous graphs which run continuously in background.
• Creating Graphs to load the historical data into history tables
• Estimation of the server storage and capacity for all levels from Development to Production
• Building up the server which includes setting up proper permission, creating file system for required directory, group and user account creation in Unix.
• Installation of abinitio software, upgrade the cooperating system, install key file and key bundle, Setting up the help server.
• Creating EME and provide proper permission to all levels.
• Creating private and public sandbox, build multifile system and project directories for all the sandboxes.
• Creating scripts for code migration between the environments.
• Code migration through TRMC tool.
• Setting up the proper guidelines for code promotion activity.
• Setting up the complete environment for all levels for environment.

Abinitio Technical Lead and Admin

Tools: Ab Initio GDE 3.1, Co>Operating System, Web EME, Control M, Db2, Service now

Responsibilities:

• Analysis and gathering of requirements for new implementations in Amex DTU-SQP TSYS projects
• Estimation of effort required for completing the activity
• Development of new programs and enhancement of existing projects
• Designing of TSYS conversion projects
• Coding to change the existing logic to accept the new layout
• Coordinating with testing team to make sure all the scenario’s covered
• Participating in business meetings and handling Tech review meetings for all ongoing installations and projects
• Providing 24/7 post implementation support after the project roll out into production environment for the entire warranty period.
• Coordinating with offshore team and providing the onsite updates on a daily basis
• Involved in database decommission project- identifying all the existing graphs loading into the database
• Graphs are modified to point the other database in order to secure all the existing functionality
• Modifying all the common dml’s which is not impacting other applications.
• Analyzing production code, verifying dependency analysis on jobs involved in production run mainly in AbInitio/Unix Scripts
• Analyzing the current latency between corner stone and GDR and provide the resolution
• Implementing the changes in GDR post load config file to send the data to CS
• Modify the existing code to leverage create data files to CS
• Involved in Regression testing and monitoring
• Estimation of the effort
• Validating the files in Corner stone and verifying the counts between GDR and Corner stone.

System Analyst

Tools: Ab Initio GDE 3.1, Co>Operating System, Oracle 11g, Web EME, Contol M,Teradata,Sql server 2008 R2

Responsibilities:

• Developed Ab Initio Graphs based on business requirements using various Ab Initio Components.
• Developed Plans with various tasks and methods based on the requirement.
• Implementing the code and Scheduling changes precisely in production to avoid future failure.
• Involved in preparing Technical design document, TOSSG, Control M process, UNIX migration form, scheduling and providing KT to IPS
• Working with the business owners and Data steward team to resolve the Data quality issues.
• Actively participating the design review meeting and provide suggestion to enhance the system properly.
• Working on the release management and coordinating with the change management team to implement the production changes.
• Co-ordinate with offshore team to provide proper hands on.
• Co-ordinate with the UAT team for the post production validation.

System Analyst

Tools: Ab Initio GDE 1.15, Co>Operating System, Oracle 11g, Autosys R11.3,AIX,Weblogic

Responsibilities:

• Build various Sandboxes in order to create Adhoc & Regular applications in Ab Initio.
• Participated in Data modelling meetings, helped to identify the relationship between tables according to the requirements
• Participated in business, detail design and technical documentation for ETL standards, procedures and naming conventions, worked under the ETL process.
• Redesigned the existing graphs and documented all the new and enhancement requests.
• Coordinated with downstream team to analyze the downstream data flow from the ODS into other applications
• Develop UNIX shell scripts (wrapper) for Automating ETL process.
• Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the AB Initio partition components to segment data.
• Performed data validation before moving the data into staging areas using in built functions like is valid, first defined, is blank, is defined, string length, and string index
• Developed the complex graphs using various Ab Inito components like Join, Reformat, Rollup, Sort, Partition by key, Merge, Gather etc
• Scheduled the jobs in autosys and supported them in production.
• Tuning of AB Initio Graphs for better performance.
• Migrating packages and java codes into Testing and Development environment for SIT
• Setting up various private and public sandbox
• Perform Unit testing before moving the UAT team

Confidential

Associate engineer

Tools: MySQL

Responsibilities:

• Design the test cases
• Performed the test execution and verification of data in database
• Defect reporting - Logging of defects and track it till closure
• Involved in Re-testing of defects and rerunning of test cases.
• Preparation of reports for test execution status and defect status.
• Preparing Lesson Learnt documents from the previous release experience
• Communication with the Test Lead / Test Manager.
• Performed the reconciliation validation