SUMMARY

• Over 9 years of IT experience in the Design, Analysis, Development, Modeling, Implementation and testing of various applications, Decision Support Systems & Data Warehousing applications.
• Over 6 plus years of solid experience in Extraction, Transformation and Loading (ETL) mechanism using Ab Initio and Informatica. Knowledge of full life cycle development for building a data warehouse.
• Sound knowledge ofHealth CareInsurance Domain. Also worked on FS Banking projects. Extensive experience asLead Ab Initio Developerand Designer
• Experience with Ab Initio Co>Operating System, application tuning and debugging strategies Proficient with various AB INITIO Parallelism and Multi File System technique
• Experience with various Ab Initio products like Plans, EME, Express > It, Query > IT, Data Quality Engineering (DQE), ACE/BRE
• Strong Data Warehousing ETL experience of using Informatica 9.6/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, Development, System testing, Implementation and production support.
• Experience in data management and implementation of Big Data applications usingHadoop frameworks.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.
• Good understanding of Map Reduce and the Hadoop Infrastructure
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/ 5.1 Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005,Netezza striper, Twin-fin Servers
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, Netezza and Flat Files into the staging area, ODS, Data Warehouse and Data Mart. Experience in using Automation Scheduling tools like Dollar Universe
• Designed Parallel Partition Ab Initio Graphs for a high volume data warehouse
• Implemented the Parallel application by replicating the components and processing modules into number of partitions
• Involved in Ab Initio Graph Design and Performance tuning to Load graph process
• Experience in creating custom schema from Ab Initio EME base schema and creating EME custom views.
• Developed and automated control validations for the ETL process to appropriately tie the source and target data.
• Developing and testing wrapper scripts for jobs on PERL based automation system, Autosys.
• Tuned the Graphs by removing unnecessary Sorts, used Lookup files, to enhance the performance.
• Experience in designing and implementing Ab Initio EME Metadata projects
• Responsible for writing shell scripts (wrapper) to schedule the jobs in the development environment
• Responsible for fully understanding the source systems, documenting issues, following up on issues and seeking resolutions
• Strong knowledge in Dimensional modeling like Star Schema and Snowflake Schema.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Ab Initio.
• Experience in UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts.
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server, and MS Access.
• Experienced in writing SQL query and PL/SQL Procedures, Triggers, and Functions necessary for maintenance of the databases in the data warehouse development lifecycle.
• Good exposure to SQL, PL/SQL stored procedures, Triggers and Packages.
• Good Understanding of DDL, DML and ILM concepts
• Good Knowledge on different kinds of data bases (DB2, Oracle, IMS, TeraData, MS SQL)
• Working knowledge of multiple databases and test data management solutions likeIBMOPTIM.
• Experience in installing IBM InfoSphere Discovery 4.6 & Optim 11.3 Tool and Optim TDM, Optim Designer.
• Exposure and involvement in execution of end-to end data archival/masking projects.
• Experience in masking of data in DB2, VSAM, Oracle, SQL etc. using InfoSphere Optim
• Experience in handling masking of flat files
• Extract the data using Test Data Management component and perform the data obfuscation
• Assist in design and development of InfoSphere Discovery & InfoSphere Optim solution design.
• Knowledge of writing Optim exits
• Expertise in TDM concepts including Data sub-setting, Data Masking and Data profiling.
• Ability to co-ordinate effectively with development team, business partners, end users and management
• Deep understanding and capability in troubleshooting of the common issues faced during the development lifecycle including coding, debugging, testing and final roll-out
• Set up development, QA & Production environments
• Expert in problem solving skills with the ability to think creatively and strategically about alternative solutions and opportunities.
• Experience in working on multiple Projects at one time
• Vast experience in work environment with a mix of onsite-offshore Global Delivery model.
• Experience in reviewing and monitoring project progress, planning & managing dependencies and risks, Resource Planning, Project Budget Tracking and Forecasting.
• Self motivated, excellent written and oral communication skills
• Strong analytical & problem solving skills.

TECHNICAL SKILLS

ETL Tools: Ab Initio GDE 3.3/2.x, CO>OP 3.3/2.x/1.xInformatica Power Center 9.6/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server); IBM Optim 11.3/13, IBM InfoSphere Discovery 4.6

Tools: AutoSys (IXP 11.3.5), Tivoli, SQL Loader, WinSQL 5.0, TOAD, Siebel Tools 7.5, BMC Control M V8, BMG Remedy (Pac2000), Microsoft Visio 2000

OS: UNIX AIX 5.3, Linux, Sun Solaris 5.8, OS/390 z/OS 1.6, Windows 95/98/NT/ME/00/XP, UNIX, MS-DOS

Databases: Oracle 11g, MS SQL Server 2008, Teradata V15/V14.00, DB2 UDB (8.0), MySQL 5.6.17

Languages: Visual Basic 6.0/5.0, SQL, PL/SQL, and Transact-SQL

Packages: SQL* PLUS, Toad 7.x, SQL Loader

Scripting: UNIX Shell (Ksh/Csh), JavaScript.

Web: HTML, DHTML, XML, ASP 2.0/3.0

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Ab Initio Technical Lead

Responsibilities:

• Worked with Business Enablers in creating a roadmap and data lineage for data from source to target database
• Worked on developing generic graphs with multiple data sources particularly mainframe files and data extracts from different databases like Oracle, Teradata and SQL Server
• Worked on a migration project to migrate Ab Initio graphs from Solaris to Linux environment.
• Worked on unix shell scripts to divide the already existing script and enabling better handling in the new Linux environment
• Made sure the dependencies are properly set when splitting unix script into parts to have each split be called by an individual job under a box within Autosys scheduler.
• Created plans and updated legacy graphs to better handle the data.
• Worked on improving the graph performance by updating and modifying the graphs as needed.
• Created new parameters within the graphs so as to remove any redundancies
• Worked with L2 support team to debug any production issues after the first Linux run and mentoring onsite/offshore teams as needed
• Worked on Change Request documentation apart from development because of the clarity and better understanding of the changes made.
• Worked with Release Management team to provide all the necessary documentation for moving forward with code promotion to higher environments
• Worked closely with Quality Assurance team to debug the issues identified during the job runs

Environment: Ab Initio GDE 3.3.1 Co>Op 3.2.4, EME, Express > It, Query > IT, Oracle 11g, Linux, Teradata V15.10, Autosys r11.3, BMG Remedy (Pac2000), IBM uDeploy, IBM Anthill Pro.

Confidential, Dallas, TX

Sr Ab Initio/Informatica Developer

Responsibilities:

• Gathered requirements from the Business user community and suggested on very high level ETL processing
• Created high level and low level detailed technical design documents for the project
• Worked on developing Ab Initio generic graphs and psets to accommodate SOR processing
• Used Hadoop File System (HDFS) to ingest data and process within HDFS
• Managed and reviewedHadooplog files.
• Created Hive queries to help business users to analysts spot emerging trends by comparing fresh data with historical metrics.
• Worked on some custom Ab Initio components which are being used for Hadoop in specific
• Handle support, maintenance, configuration and performance tuning activities for hadoop clusters.
• Setup hands on experience with Ab Initio on Hadoop integration, HDMFS, Yarn on big data clusters running Cloudera services.
• Worked on enhancing the Ab Initio graphs and tuning them so that the jobs run faster and complete way before SLA
• Worked on building complex Ab Initio graphs and used PDLs within the graphs.
• Worked with Ab Initio corporation resources on the team to get understanding of new data integration process that was being built.
• Extensively used Express > It and Query >IT to understand and retrieve results of various business logic.
• Worked on Express > It for object level promotion from lower environment to higher
• Worked on Control M schedules build process and analyze the dependencies of the jobs.
• Worked with the project team to analyze and debug data issues in the Teradata (ICDW) and Oracle environments.
• Worked with various Active & Passive transformations and created Reusable Transformations and Mappings using Designer Tool set of Informatica.
• Developed mappings for initial load and daily updates.
• Extensively used Mapping variables, Mapping Parameters and parameter files.
• Created Reusable transformations and Mapplets to use in multiple mappings.
• Created sessions to update the target data using Workflow Manager of Informatica.
• Analysis of Data model to check table constraints and columns in Data mart
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders.
• Was the single point of contact to co-ordinate and communicate the progress from offshore to the client
• Worked with Release Management team to provide all the necessary documentation for moving forward with code promotion to higher environments
• Worked closely with Quality Assurance team to debug the issues identified during the job runs
• Provided warranty support for a month after the project went into Production.

Environment: Ab Initio GDE 3.2.2 Co>Op 3.2.4, EME, Express > It, Query > IT, Informatica Power Center 9.6, Oracle 11g, TOAD, Linux, Teradata V14, BMC Control M, HP Service Manager

Confidential, Chandler, AZ

Sr Ab Initio Developer/Data Analyst

Responsibilities:

• Worked on end-to-end processing of the data flow from source to EDW
• Participated in design of data flow from external sources until sending out the feeds to downstream environments and bobj reporting structures
• Created high level and low level detailed technical design documents for the project
• Involved in creating Ab Initio generic graphs to extract/load data and processing graphs to apply the transformations on the data to apply business rules on the data
• Was responsible for maintenance of the prod/non-prod environments at times looking for any failures and applying quick fixes
• Participated in designing the scheduling process for the module and made sure all the jobs run without any contention.
• Was a mentor to the new members of the team and helped them get onto speed in the project
• Was responsible and took complete ownership of the tasks and kept the client with updated status.
• Worked with the migration teams and DBA teams during major release.
• Was a data analyst and was assigned tasks related to analysis of data
• Participated in major decision making team meetings and shared the information with the team
• Participated in providing support to the releases until the system became stable

Environment: Ab Initio GDE 3.2.2 Co>Op 3.2.4, Oracle 11g, EME, Linux, Teradata V14, MS Visio, AutoSys (IXP 11.3.5), MySQL 5.6.17

Confidential, Jacksonville, FL

ETL Technical Lead

Responsibilities:

• Met with business/user groups to understand the business process and gather requirements.
• Extracted and analyzed the sample data from operational systems (OLTP system) to validate the user requirements and created high level design documents.
• Improved 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.
• Prepared High Level Design of Source Data Analysis, ETL Process flows, Error Handling Re-startability and Extendibility.
• Work with other developers/BA to create a Best in class ETL solution
• Work with the source system team (product processors) to understand/Standardize the data layout.
• Worked on BRE (Express >IT) while meeting with user community to get the desired outcome by modifying the business logic of the Ab Initio code.
• Developed highly generic graphs to serve the instant requests from the business
• Worked with Infrastructure team to write some custom shell scripts to serve the daily needs like collecting logs and cleaning up data
• Involved in writing wrapper scripts to run the graphs, to load into Data Warehouse and to verify the counts while loading
• Involved in designing and developing the Informatica mappings and workflows for Data Conversion mechanism.
• Worked with various Active & Passive transformations and created Reusable Transformations and Mappings using Designer Tool set of Informatica.
• Developed mappings for initial load and daily updates.
• Created sessions to update the target data using Workflow Manager of Informatica.
• Involved in Unit Test case preparation and did the unit testing. Conduct project post mortems and create a recommendations report in order to identify successful and unsuccessful project elements.
• Create mapping for all the fields to be migrated from one system to another with business rule of transformation mentioned with the same.
• Gathering the knowledge of existing operational sources for future enhancements and performance optimization of graphs
• Worked on documenting and creating Visio diagrams for the legacy systems for which documents did not exist.

Environment: Ab Initio GDE 3.1.3, Informatica Powercenter 8.6.1 (Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Transformations), Oracle 11g, EME, AbI Express> It, Unix AIX, Linux, Teradata, MS Visio, Control-M, IBM DB2.

Confidential, Plano, TX

Technical Lead

Responsibilities:

• Worked in the Data Management Team on Data Extraction, Fictionalization, Subset, Data Cleansing and Data Validation.
• Have In-depth understanding and hands-on experience onIBM OPTIM
• Worked on installing and configuring Optim and IBM Infosphere Discovery.
• Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users
• Responsible for the detailed design and documentation.
• Designed, developed and unit tested Optim Services for the CO Auto Finance project
• Improved performance of Extract, Convert Services by using various Optim performance techniques like relationships.
• Worked on defining convert process in Infosphere Optim
• Involved in execution of data archival and masking tasks
• Worked on Data Subsetting, Data Profiling and Data Masking
• Used the extract, convert and load services to scrub/mask the Production NPI data and load the scrubbed data into non-prod environment.
• Worked on setting up the DB Aliases for different environments for Optim usage.
• Participated Agile Iterative sessions to develop Extended Logical Models and Physical Models
• Created mapping document and ETL design document
• Carried the performance tuning on the Optim Services to reduce the process time.
• Worked in Scrum & Agile Methodology Environment

Environment: IBM Optim, Ab Initio GDE 3.1.3, Oracle 11g, EME, Unix AIX, Linux, Tivoli, SQL Server 2008, Teradata.

Confidential, Dallas, TX

Ab Initio Technical Lead/Developer

Responsibilities:

• Created Ab Initio graphs that transfer data from various sources like Oracle, flat files and CSV files to the Teradata database and flat files.
• Worked on Multi file systems with extensive parallel processing.
• Implemented Lookups instead of joins, in-memory sorts to minimize the execution times while dealing with huge volumes of data.
• Extensively used Partitioning Components: Broad Cast, partition by key, partition by Range, partition by round robin and De-partition components like Concatenate, Gather and Merge in Ab Initio.
• Implemented Transform Components such as Aggregate, Dedup Sorted, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components and created appropriate XFRs and DMLs.
• Used Lookup Transformation in validating the warehouse customer data.
• Performed bulk data load from multiple data source (ORACLE 10g, legacy systems) to Teradata RDBMS.
• Used Teradata SQL Assistant front-end tool to issue SQL commands matching the business requirements to Teradata RDBMS
• Coded and Unit tested Ab Initio graphs to extract the data from Oracle tables and MVS files.
• Produced mapping document and ETL design document.
• Worked closely with the end users in writing the functional specifications based on the business needs.
• Participated in project review meetings.
• Provided maintenance and support to most of the applications.

Environment: Ab Initio GDE 3.1.1, Oracle 11g, EME, Solaris, Unix AIX, Linux, Tivoli, Teradata 13.1, BMC Remedy.

Confidential, Lincolnshire, IL

Ab Initio/Informatica Lead

Responsibilities:

• Involved in creating the high level and low level technical design documents
• Developed complex Ab Initio graphs applying various business rules and requirements from the Users
• Responsible for giving Production support, working in flexible timings.
• Worked on fine-tuning the existing Ab Initio graphs in order to have optimum performance.
• Created perl scripts in order to execute the jobs through driver
• Involved in working and analyzing on complex database structure
• Closely worked with the client and the users in order to meet the requirements
• Worked closely with the database admin team in order to come up with an optimum solution for critical business requirements
• Responsible for creating test cases to test the production ready graph for integrability, operability.

Environment: Ab Initio GDE 3.0.2, Oracle 10g, Teradata, EME, Solaris, Unix AIX

Confidential, Irving, Tx

Ab Initio Tech Lead

Responsibilities:

• Involved in gathering the requirements and creating the high level and technical design document.
• Developed complex Ab Initio graphs applying various business rules on the data and loading the data into the ODS tables
• Worked with the Business Users during the entire project in order to make sure that the expectations of the business is met
• Worked with the Users during the User Acceptance Testing Phase and made sure their queries are answered and the business requirements are met
• Coordinated with the Production support team, transferring the required knowledge to them in order to handle well when the project went live.
• Created all the supportive documents and followed the SDLC to give out a proper end product.

Environment: Ab Initio GDE 3.0.5, TeraData 13.10, EME, Linux

Confidential, Lincolnshire, IL

Ab Initio Developer

Responsibilities:

• Involved in the design and development of many complex graphs for the LP application
• Responsible for Development of Graphs and Unit Testing
• Responsible for designing and implementing data mobilization job streams that in corporate data hygiene, merge/purge, and transformation processes
• Had supported implementation of business intelligence and marketing automation solutions
• Responsible for creating test cases to test the production ready graph for integrability, operability, and to make sure the data originating from source is making into target properly in the right format
• Responsible for interpreting the transformation rules for all target data objects and develop the software components to support the transformation. Coded and tested complex Ab Initio ETL routines
• Had participated in software development projects to develop logical and physical data models and to capture application specific ETL metadata and work flows
• Used most of the Ab Initio Components.
• Developed shell scripts to customize the ETL Ab Initio Graphs at runtime.
• Used Check in/Check out for the CVS version control system.
• Extensively used Partition and Departition components on multi file system.
• Extensively used Sort and Transform components such as Join, Filter by Expression, Dedup Sorted, and Re format within the graph for business query.
• Developing Shell Scripts to automate file manipulation and data loading procedures
• Performed complex queries involving large data volumes
• Validating the output data of the graph with various Validate components such as Compute Checksum, Validate Records.
• Responsible for the automation of Ab Initio Graphs using Korn shell scripts
• Creating summary reports of the output of graphs using Aggregate, Rollup, Scan components.
• Developed Graphs common data validation for the different sources.
• Had Prepared/implemented data verification and testing methods for the Data Warehouse.
• Had done performance and tuning of Ab Initio ETL graphs, processes and load routines and provided mentoring in Ab Initio
• Analyzed and reviewed the Detailed Design schema with the Designers so as to have proper understanding of the requirements
• Used Ab Initio Business Rules Engine (BRE) to check the outcome of different changes in the business logic
• Responsible for interacting with the business analyst and client representatives to develop technical specifications that meet documented business requirements
• Responsible for providing requirements to improve re-usability of components and development of cutting edge coding standards and provide feedback related to product integration, internally developed infrastructure components, and application templates based on project experience

Environment: Ab Initio 2.14/3.0.2, GDE 1.15/3.0.2, Ab Initio BRE, Oracle 10g, PL/SQL, SQL Developer, Solaris 9

Confidential, Omaha, NE

Ab Initio Developer

Responsibilities:

• Designed and developed various Ab Initio graphs based on the business requirements
• Developed generic graphs to extend a single functionality to many processes and reduce redundant graphs
• Reponsible for modifying the dml’s and xfr’s as per the business requirements and hence enhancing the Ab Initio graphs
• Used Sort and Transform components such as Join, Filter by Expression, Dedup Sorted, and Re format within the graph for business query
• Responsible for creating test cases to test the production ready graph for integrability, operability, and to make sure the data originating from source is making into target properly in the right format
• Responsible for giving Production support, working in flexible timings and coordinating with the offshore team
• Worked on exception handling by gathering all the rejected records to flat files
• Worked on the mainframe to extract the source file, when it is not triggered automatically
• Responsible for coordinating with the source teams to fix various production issues.
• Responsible for maintaining user security table thereby giving data accessing permissions to only the required users
• Worked on enhancement of different graphs thereby enhancing the processing time of huge data volume
• Performed data cleansing operations on the data using transformation functions like is valid, is defined, is null, string trim etc
• Providing full support and representing the team when there are database upgrades or enhancements during the weekends
• Created complex Ab Initio graphs and extensively used Partition and Departition components to process huge volume of records quickly, thus decreasing the execution time
• Used inbuilt emergency library (emerlib) to check-in and check-out graphs in order to perform necessary modifications

Environment: Ab Initio 2.15, GDE 1.15, IBM DB2, PL/SQL, UNIX AIX, CA7 and Mainframes