PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in software analysis, design and development for various software applications in client - server environment with over 5 years of experience in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems and OLAP application development in Windows and Unix platforms.
• Over Four years of solid experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio.
• Designed and built logical and physical models into catalogues and universes for end-user and management reporting needs.
• Expertise and well versed with various Ab Initio Transform, Partition, DE partition, Dataset and Database components.
• Developed prototype for parsing high volume XML files using Hadoop and storing output in Confidential for Ab Initio
• Extracted data from various sources like databases Teradata, Oracle, delimited flat files and Salesforce.com
• Experience with Ab Initio Co-Operating System, application tuning, and debugging strategies.
• Extensively worked in creating Data marts using Ab Initio Confidential 3.2.3/ CO>OP 3.2.2.3, Express>It 3.3.2.0 ETL Functions. Designed and built logical and physical models into catalogues and universes for end-user and management reporting needs.
• Expert in writing UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts.
• Very good experience with SQL Server & Oracle Databases.
• Extensive experience in conducting Data Analyses, Data Mapping, Gap Analyses, Risk Identification, Risks Analyses, and Risk management.
• Experience in AGILE development methodologies.
• Hands on experience in creating Continuous and Batch graphs.
• Involved in implementation of Business Intelligence Applications using Cognos and Business Objects, building Data Marts and enterprise wide Data Warehousing.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Worked on integrating data from flat files.
• Worked with Partition Components like Partition-by-key, Partition-by-expression, Partition-by-Round Robin to partition the data from serial file.
• Well versed with various Ab initio parallelism techniques, Multi file systems and implemented number of graphs using data parallelism.
• Involved in Developing Ab Initio Graphs in a MPP (Massively Parallel Processors) Environment for the ETL process jobs in a High Volume and dynamically growing environments.
• Worked with Wrapper scripting with UNIX Shell programming, Scheduling of Ab initio jobs with Auto Sys.
• Exposure of Data Profiling and Metadata hub.
• Good experience in development of PL/SQL stored procedures, functions and packages.
• Strong communication and inter personal skills with ability to work in a team environment or individually.
• Excellent communication skills, good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly
• Extensively used Ab Initio EME data store/sandbox for version control, code promotion, and
• Strong experience in Ab Initio Confidential, 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 map reduce, 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:

Data warehousing Tools: Ab Initio Confidential (3.1/3.0/1.15/1.14/1.13 ), Co>Operating System (3.1/3.0/2.15/2.14/2.13/2.12/2.11 )., Informatica 6.1/7.1x, SSIS

Teradata Tools: ARCMAIN, BTEQ, Teradata SQL Assistant, Teradata Manager, PMON, Teradata Administrator.

DB Tools: SQL*Plus, SQL Loader, TOAD 8.0, BTEQ, Fast Load, Multiload, FastExport, SQL Assistant, Teradata Administrator, PMON, Teradata Manager

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, Erwin 4.0, Visio

RDBMS: Oracle 10g9i/8i/,Tera Data V2R5, DB2, MS SQL Server 2000, 2005,2008

Scheduling Tools: Autosys, Tivoli Maestro

Version Control Tools: Clear Case, TFS

Programming: UNIX Shell Scripting, C/C++, Java, Korn Shell, TSQL, SQL*Plus, PL/SQL, HTML, ASP.Net

Operating Systems: Windows NT/XP/2000, UNIX, LINUX(Redhat)

BI tools: OBIEE 10.1.3.x, Crystal Reports 8.0/8.5

PROFESSIONAL EXPERIENCE:

Confidential, Morristown, NJ

Sr.Ab Initio Developer/ETL Developer

Environment: Ab Initio ( Confidential 3.1/3.0, Co>Op 3.1/3.0), Conduct>IT, Teradata 13 (BTEQ, Fastload, Multiload, FastExport), PL/SQL, TOAD, UNIX, Erwin 7.3, Control-M, Pl/Sql, Sql*Loader, HTML, ASP, Pro*C and Solaris 2.6 and WinXP.

Responsibilities:

• Worked in the Data Management Team on Data Extraction, Fictionalization, Subset, Data Cleansing, and Data Validation.
• Used Ab Initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases.
• Involved in creating high level design and detailed design documents for Ab Initio graphs.
• Extensively involved in Ab Initio Graph Design, development and Performance tuning.
• Worked on the sales Data Mart for moving the enterprise data from a queue system using Continuous Flows.
• Involved in Unit testing (UAT) System testing and debugging during testing phase and used Test Director to keep track of bugs.
• Updated and inserted transactional data according to the business changes using Continuous Flows.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Gather, Merge etc.
• Extensively used Conduct>IT to run the graphs.
• Creation of Low Level Design Document from Confidential .
• Developed Ab Initio graphs for Data validation using validate components.
• Extensively used the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Implemented Data parallelism by using Multi-File System, Partition and De-partition components and also preformed repartition to improve the overall performance.
• Developed graphs separating the Extraction, Transformation and Load process to improve the efficiency of the system.
• Involved in designing Load graphs using Ab Initio and Tuned Performance of the queries to make the load process run faster.
• Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files, Filter by Expression, Run Program, Join, Sort, Reformat, and Dedup.
• Used Data profiling task to identify problems in the data that have to be fixed.
• Performed validations, Data Quality checks and Data profiling on incoming data.
• Used Enterprise Meta Environment (EME) for version control, Control-M for scheduling purposes.
• Created Sandbox and edited Sandbox parameters according to repository Extensive exposure to EME.
• Used AIR commands to do dependency analysis for all ABI objects.
• Created temporary tables and views for intermediate calculations in Teradata.
• Developing the Teradata Macros to load data into Incremental/Staging tables and then move data from staging into Base tables.
• Testing and tuning the Ab Initio graphs and Teradata SQL’s for better performance.
• Used Fast Load, MultiLoad, and Tpump for loading data in to Teradata Database.
• Moving data feeds from the mainframe (MVS) system to the Data Developing Environment (Ab Initio).
• Enabled MVS input via DB2 and output as Teradata.
• Extensively used TOAD to create tables and to modify the same.
• Designed and build Ab Initio generic graphs for unloading data from source systems. Validated the unloading process with the row count of the landed file with that of the source table row count.
• Developed UNIX Korn Shell scripts to run various Ab Initio generated scripts and to automate the scheduling of batch jobs.
• Experience using Clear Quest, Clear Case, Quality Centre.
• Provided 24*7 extended supports during the production rollout.
• Worked with an offshore team to build the project and undertook responsibilities of working closely with users for requirements gathering and providing the offshore team with detailed requirements documents.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, TPump, Confidential Commands and DML Commands (SQL).
• Experience using advanced Business Rules Engine (BRE) technology to reduce time to market, improve quality, ensure regulatory/legal/tax compliance, increase sales, cut costs, and maximize revenue.

Confidential, Alexandria, VA

Ab Initio Developer/Teradata Developer

Environment: Ab Initio ( Confidential 3.0, Co>Op 3.0), Oracle 10g, DB2 UDB 8.2/7.1, Sybase, EME, SQL, PL/SQL, SQL Server, UNIX AIX, Shell Scripts, PL/SQL developer, Quest Central, Autosys.

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Participated in Logical and Physical Data modeling. Identified the Entity types, their attributes and the relationship between the Entities in the organization’s business process.
• Extensively used UNIX Shell Scripting for writing SQL execution scripts in Data Loading Process.
• Written SQL scripts which are used in Database Components of Ab Initio to extract the data from different source tables and to load the target table using Update Table and Output Table components with the support of Config (.cfg) file in graphs.
• Used Ab Initio components like Reformat, input file, Output file, Join, Sort, Partition by key, Normalize, Input Table, Output Table, Update Table, Gather Logs and Run SQL for developing graphs.
• Worked on Data enrichment and Data Standardization for Quality check data coming from various source systems (i.e., Oracle, Flat files.)
• Sorted the Extraction from heterogeneous source systems, like Oracle, internal and external flat files and building of the Transformations and Loading formatted data into the Multi-file and Serial files during the intermediate and the final stages of the processes (ETL) using Ab Initio.
• Used Enterprise Meta Environment (EME) for version control.
• Executed the test scripts and unit testing of Confidential / Confidential using Co>Operating system.
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Involved on the creation of IVR application to support the authentication of existing customers.
• Used Ab Initio Confidential to create graphs for the generation of the Loan Level file without summaries and to summarize loan-level data records.
• Developed number of Ab lnitio Graphs for the ETL processes based on business requirements using various Ab lnitio components like Partition by Key, Partition by round robin, reformat, rollup, join, scan, gather, replicate, merge etc.
• Created UNIX Shell scripts (wrapper scripts) to be invoked using Autosys.
• Extensively used the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Configured the source and target database connections using. dbc files.
• Generated DB configuration files (. dml, .cfg) for source and target tables and modified them according to the requirements.
• Used sandbox parameters to check in and checkout of graphs from repository Systems.

Confidential, Washington, DC

Ab Initio Developer

Environment: Ab Initio Confidential 1.14,Co.op 2.14, Oracle 9i, Tera data, Autosys, Toad 7.6.0.11, HP UX 11.x, IBM PCOM 4.2, TSO/ISPF, Korn Shell Scripting.

Responsibilities:

• Developed and Implemented extraction, transformation and loading the data from the legacy systems using Ab Initio
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs and written complex XFRs for implementing the business logic transformation.
• Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
• Extensively Used Transform Components Aggregator, Match sorted, Join, Denormalize sorted, Reformat, Rollup and Scan Components
• Involved in Unix Korn shell wrapper scripts to accept parameters and scheduled the processes using Crontab, Job Scheduler, Database Load Interface, and Denormalization using Ab Initio.
• Developed and supported in extraction, transformation and load process (ETL) for a Data Warehouse from legacy systems using Ab Initio and provided technical support.
• Interpret transformation rules for all target data objects and developed Ab Initio graphs to support the transformation
• Involved in creation of proper test data to satisfy all required test cases and performed unit testing on all deliverables also was part of the code review team
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process.
• Assisted in developing various reports using PL/SQL Stored Procedures.
• Involved in writing wrapper scripts to run the graphs, to load into Data Warehouse and to verify the counts while loading.
• Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
• Developed shell scripts to automate file manipulation and data loading.
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio Confidential .

Confidential

ETL/Ab Initio Developer

Environment: Ab Initio Confidential 1.13 Co. Op 2.13/2.14, UNIX shell scripting, Oracle 9i, Sun Solaris, Windows XP

Responsibilities:

• Worked with business to translate the business requirements into High level design, Detailed Level Design and Functional code.
• Responsible for setting up Repository projects using Ab Initio EME for creating a common development environment that can be used by the team for source code control.
• Developed Adhoc graphs to serve the instant requests from the business.
• Developed graphs using Confidential with various Ab Initio components
• Developed Complex Ab Initio XFR’s to derive new fields and solve various business requirements
• Involved in designing and development of Ab-Initio graphs using Ab-Initio Parallelism techniques, Data Parallelism and MFS Techniques.
• Implemented Star Schema models for the above data warehouses by creating facts and dimensions.
• Extracted and loaded data from various data sources like Oracle/Teradata databases, Flat Files and XMLs.
• Extensively worked under the Unix Environment using Shell Scripts and Wrapper Scripts. Responsible for writing the wrapper scripts to invoke the deployed Ab Initio Graphs
• Developed graphs to extract internal / external data needed from different source databases by using multi input file components and by configuring the dbc file in Input Table component
• Used phases and checkpoints in the graphs to avoid the deadlocks, improve the performance and recover the graphs from the last successful checkpoint.
• Created sandbox and edited sandbox parameter according to repository.
• 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.

Confidential

Jr. Ab Initio Developer

Environment: AbInitio Confidential 1.15, Co>p 2.15, Unix AIX, Oracle 11G

Responsibilities:

• Creating Confidential statements like Create, Delete, Drop using Oracle 9i, 10G SQL.
• Responsible for requirement gathering, analysis and designing of the AbInitio graphs
• Designing and development of complex generic and conditionalized AbInitio graphs involving complex business logics.
• Optimizing performance by analyzing, ETL workflow and query patterns.
• Development of UNIX shell scripts
• Involve in Unit testing and documented test cases
• Interacted with DB2 database.
• Unit Test Case preparation, execution and getting the result verification done by SME.
• Providing code turnover to QA.
• Involved in tracking and resolving the issues.
• Reviewing and optimizing the code to enforce standards
• Preparation of ETL detailed design document and reusable process related documents
• Dealing with processing logic, job scheduling or performance issues
• Participating in peer-review process of the code-fix for the quality of deliverables.
• Responsible for necessary documentation related to the AbInitio project.