SUMMARY

• A highly motivated IT professional with 7.5 plus years’ experience in diversified fields of Application Software having considerable "in the trenches" experience in Datawarehousing/Business Intelligence technologies and tools such as Abinitio GDE 2.x, 3.x Co>operating system 1.14.33, 1.15.5, 3.x Business Objects - 6.x and BO XIR2/XIR3 (CMC, Designer, Desktop Intelligence, Web Intelligence and Migration tools, Dashboard Design using Xcelsius, Crystal Reports) in Accounting, Education, Healthcare and Finance domains
• Excellent interpersonal & communication skills.
• 4 plus years of experience in Managing/Leading teams and contributing as a Senior Individual Contributor.
• Proficient in Data Modeling, Multi-Dimensional Modeling and involved in creation of Galaxy Schema, Snowflake dimensional data marts, OLAP cubes and slowly changing dimensions implementations.
• Capable of looking across the entire business model to develop and promote a strategic vision of the data environment as well as deep-dive into detailed data analysis and data mapping / modeling exercises
• Experience in identifying and evaluating the best sources of data for both internal and external loads, data quality analysis, defining and designing the process to extract, transform and load source data into data warehouses and data marts.
• Exposure to Data Modeling Tools like Erwin with Oracle, MS SQL Server databases.
• Proficient in defining ETL design and integrating data from disparate source systems/disparate data formats including Requirements gathering, Source system analysis, Data Quality, Performance Tuning, Maintenance and Production Support mainly using AbInitio Co-operation systems 1.14, 2.14,3.13,3.1.6
• Extensively used Abinitio EME, GDE for version control and dependency analysis, Conduct>it for developing plans and maintained project sandboxes.
• Hands-on experience using Abinitio Core components, phases, checkpoints and implemented number of AbInitio Graphs using Data parallelism and Multi file system (MFS) techniques.
• Expertise in Performance tuning various Complex Abinitio Graphs and have been successful in achieving upto 80% performance improvements across the Project.
• Extensively worked with Advanced Metadata techniques like Conditional DML, PDL (Parameter Definition Language) and able to build large complex graphs with multiple drill down sub graphs.
• Actively Involved in Data Cleansing, Data Profiling, and Source Data Quality Analysis
• Strong experience on developing re-usable generic / dynamic Abinitio applications for high-volume DWH environment. Excellent problem solving and meta-data, BI skills
• Experience in providing production support to various AbInitio ETL jobs and developing UNIX shell wrappers to run AbInitio and Database jobs.
• Good understanding of Business Objects administration and Business Objects server architecture since worked as a Business Objects Universe Designer, Reports developer and BO XIR2 and XIR3 migrations.
• Created over 200 Reports relating to various fields like finance, accounting and product analysis
• Designed and maintained Universes and various reports using Business Objects v 5.x, 6.x and XIR2/XIR3
• Strong PL/SQL programming skills including creating PL/SQL Functions, Stored Procedures, Packages and Triggers and a strong knowledge of TOAD,SQL Server
• Hands on experience in developing UNIX Shell Scripts and VI, Emacs Editor, UNIX Korn shell scripts for Abinitio start and end scripts configurations and day-to-day activities like, monitoring network connections, server loads, database ping utilities, Scheduler monitoring Log Rotation and metrics generation.
• Experienced in Resource planning & scheduling, participating in reviews/presentations, documenting control/compliance and project co-ordination with statistical updates and special expertise in Onsite/Offshore co-ordination and release management process.
• Strong team player, strong analytical, logic and problem solving skills, ability to meet tight deadlines with conflicting priorities and self-motivated with excellent work ethics.

TECHNICAL SKILLS

ETL Tools: Abinitio GDE 2.x, 3.x Co>operating system, 1.14.33, 1.15.5, 3.x

OLAP/DSS Tools: Business Objects XI- R3, Business Objects XI- R2, BusinessObjects5.x, Supervisor, Designer, Infoview4.0, BroadcastAgent5.0, WebIntelligence2.7.4 and 6.0

Databases: Oracle 11g,10g /Oracle 9.x/8i/7.x, MS Access 7.0, DB2, MS SQL

Database Modeling: Erwin3.5.2/4.0

Software Tools: Abinitio GDE 2.x, 3.x Co>operating system, 1.14.33, 1.15.5, Eclipse developer for J2EE, Jbuilder 7.0, MS FrontPage Editor, SQL Navigator 4.0/3.1,VisualSourceSafe (VSS), PVCS, Clear case, TOAD, Rational Clearcase

Programming Languages: JAVA, PL-SQL, Shell Scripting, UML, HTML

Web/Application Servers: iPlanet 6.0, Weblogic6.0/8.1, Java Web Server 2.0, Apache Tomcat Web Server.

Operating Systems: Sun Solaris (ULTRA 10, 3500,8800), Windows 7/XP/ NT/95/98/2000/ME, DOS

Network Protocols: SSL,HTTPS,TCP/IP, UDP, SMTP, HTTP, FTP, SFTP

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. ETL AbInitio Application Developer

Responsibilities:

• Created high level design and detailed design document from the functional requirements document provided by the business analyst team.
• Lead design sessions and write specification and functional design documents for enhancements and customization
• Worked with engineers from disparate source systems for data acquisition, transformation and Source data quality.
• Understood the structure and meaning of source data through data profiling and applied business content to the data and analyzed application for data integrity issues.
• Defined business rules and transformations for data coming from source systems into the data warehouse to match the business application of the data.
• Designed and developed production level data loads into the data warehouses that are optimized for fast performance and minimal maintenance.
• Developed various UNIX shell scripts to automate the Data Load processes and run AbInitio and DB jobs as a complete production system.
• Developed graphs/XFR by using AbInitio GDE which was extensively used as reusable XFRS and to aid in Parameterization
• Created Summary tables using Rollup, Scan & Aggregate and extensively used various core AbInitio components such as Join, Reformat, Scan, Rollup, Normalize, De-normalize, Partitioning and De-partitioning components etc.
• Tuned Graph performance by using various techniques like look ups (instead of joins), In-memory Sorts, Joins and Rollup to speed up various AbInitio.
• Extensively used various AbInitio Multi File Systems (MFS) to run graphs in parallel and improve graph performance.
• Worked with Departition Components like Gather, Interleave in order to departition and repartition the data from Multi Files accordingly.
• Used the existing surrogate centralized process to generate/retrieve surrogate Provider ids
• Created common graphs to perform common data conversions that can be used across the applications using parameter approach and conditional DMLs.
• Implemented Change Data Capture using Abinitio Adm Batch Process and Update table DB component
• Extensively worked on the p-sets and created UNIX shell wrappers to invoke graphs using these p-sets.
• Worked on resolving the data lineage issues by modifying the existing graphs and addressing the dependency analysis errors.
• Developed and used drill-down sub-graphs to prevent redundancy of transformation usage and maintenance.
• Multiple graphs were built to unload all the data needed parallely from different source databases by configuring the dbc file in the Input Table component.
• Created and monitored Autosys jobs using Autosys and set up batches to schedule the loads at required frequency using Autosys
• Identified data quality issues and their root causes. Implemented fixes and design data audits to capture the issues in the future.
• Implemented indexing and Data partitioning strategies that maximize query performance based on how users access the data.
• Extensively used Abinitio EME and GDE check-in check-out and maintained project sandboxes as part of version controls and dependency analysis
• Created common graphs to perform common data conversions that can be used across the applications using parameter approach using conditional DML’s
• Worked with architects, analysts, development team, and testing to implement enhancements or new applications. Participated in unit testing and integration testing
• Performed comprehensive code reviews and Converted specifications about business problems into programming instructions and to ensure compliance with standards
• Provided accurate high level and detailed effort estimates and scoped programming efforts
• Created release documentation and worked as part of a dynamic team throughout the software development life cycle
• Developed technical specification documents. Guided other developers on technical issues. Developed test protocols/test plan for testing revised application and reviewed the test results.

Confidential, New York City, NY

Datawarehouse/Abinitio Developer

Responsibilities:

• Worked on Data migration Strategy Analysis involving, studying data sources, targets, required transformations, required data cleansing, required data validations, performance requirements to meet SLA was incorporated.
• Designed dimension and fact tables for Snowflake Schema to develop the Data warehouse
• Worked with AbInitio Support to understand various bottlenecks in existing graphs.
• Incorporated tuning suggestions provided by AbInitio Support to Graphs and developed test strategy to validate end results after performance tuning.
• Involved in the requirements definition and analysis to enhance existing application
• Imported Relational metadata extract and loaded relational data and developed various Graphs for data cleansing using AbInitio functions like is valid, is error, is defined, string * functions, date *functions.
• Used debugger to test the data flow and Validate components to fix the graphs and tuned graphs taking more time but involving less data.
• Modified the AbInitio component parameters, introduced phases, utilized data parallelism and thereby improving the overall performance to fine-tune the execution times.
• Developed Complex AbInitio XFRs to derive new fields and solve various business requirements.
• Extensively used almost all the transformations in Abinitio such as Dataset components (Input file, output file, lookup file, and intermediate file), Database components (Input table, output table, RunSql, Truncated Table), Transform Components (Aggregate, Dedup Sorted, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components), Partitioning
• As part of enhancement process, data cleansing and data validations were added using transformations to reduce data errors in target tables and to increase data conformity and data consistency.
• Developed graphs between source systems (MS SQL Server, flat files, XML and Oracle) and Warehouse components(ODS)
• Widely used Lookup Files while getting data from multiple sources and size of the data was limited.
• Prepared ETL mapping Documents for every graph and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Prepared Run books providing guidelines to trouble shoot the errors occurred during the run time and instructions on how to restart the loads.
• Used Autosys job scheduler to run the sessions as per the requirement
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Maintained the Build process for setting up application in all the environments for different versions.
• Participated in the Defect Summary meetings to understand the defects and also update the status of those to the respective tester.
• Followed the process which has helped in maintaining high quality deliverables.

Environment: Ab Initio 2.x, 3.x, ERWIN, Oracle9i, 10g, 11g TOAD 9.6 IDE, UDB, MS SQL 2000, 2008, Solaris 10.0, Tomcat Webserver, Weblogic

Confidential, NYC

Lead Abinitio Developer/SDET II

Responsibilities:

• Used Abinitio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases
• Met with other LOBs to increase awareness of what is going on at an enterprise level and bought findings back to management and team.
• Developed various graphs using Abinitio core components and developed reusable graphs for the purpose of data extraction and data manipulation.
• Implemented a process to synchronize the data between the data warehouse and the reporting mart
• Built various Sandboxes in order to create Adhoc & Regular applications in AbInitio.
• Extensively used Lookups with Reformat component for fetching matched records based on the downstream process.
• Worked with Partition components like partition by key, partition by expression. Efficient use of Multi files system for Data Parallelism.
• Involved in Unit Testing of the developed components.
• Created Ab Initio plans as per the dependencies.
• Created and implemented Autosys Ops Console to create, modify and to automate the schedule process.
• Deployed AbInitio code and Unix packages from env to env (Dev to UAT and UAT to PROD)
• Prepared the Datasets for Initial and Incremental Loads
• Wrote wrapper scripts (sftp scripts, emailing, zero byte file size) for housekeeping.
• Executed the stored Procedures through Ab Initio and worked on meta-programming, PDL and Check in/Check Out of existing applications was done using EME.
• Used components like run program and run sql to run UNIX and SQL commands
• FTPed the New & Existing Abinitio applications to the Run Host.
• Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited.
• Wrote and modified several application specific config scripts in UNIX in order to pass the Environment variables.
• Tuned Abinitio Graphs for better performance.
• Developed Unix Korn shell wrapper scripts to accept parameters and scheduled the processes using Autosys.
• Developed a script which automated the loading process to the Oracle database
• Developed SQL queries/scripts to validate the completeness, integrity and accuracy of data within an ETL process testing cycle.
• Involved in establishing and documenting testing standards and methodologies for testing the Datawarehouse
• Validated the correctness of data populated in Datawarehouse tables (Source, ODS and Target tables) through SQL queries against the source system.
• Involved in testing the data quality from creating documents on front end (test data setup) to validation in database across several Operational data staging (ODS) Database layers and target tables in Oracle and MS SQL server databases.
• Replicated the transformation logic used in the ETL process so that the target data warehouse can be validated against the original data source.
• Utilized Data Analysis skills to track a data element from source through transformation to target.
• Wrote complex SQL queries to verify and validate output data generated by reports. (Used DMLs, Sub queries, Correlated Sub queries, Joins, Views, Indexes, SQL Functions, Set Operators and other Functionalities).
• Involved in testing Production fixes for data-mapping specific ETL issues
• Involved in testing data flow through various ETL systems interfacing with each other through an Operational Data Store (ODS)
• Involved in developing shell scripts for batch jobs to run interface test scripts and batch jobs for Integration System Testing
• Extensively used TOAD, MS SQL Server Query analyzer for writing/analyzing SQL queries
• Extensively ran and monitored and debugged SSIS packages, IBM DataStage ETL packages to port the data from source to target tables
• Monitored the job runs and debugged issues relating to data extractions and data transformations by modifying source extract queries, setting up data viewers to view the data flows etc.
• Reviewed the mapping of operational systems and data sources and involved in data analyses and data validation by writing SQL queries
• Involved in testing Production fixes for data-mapping specific ETL issues
• Involved in testing MQ based web services and MQ web service components testing.
• Extensive experience on analyzing error logs, identifying data defects, rejectedrecords and performing a root cause analysis of data rejections in the ETL jobs
• Involved in developing XSD specifications for interfaced documents and investigating issues with identified defects.
• Developed a framework for testing interfaced XML data using XSD and assisted testers in diagnosing problems with XML files, verification of the interfaced files if they comply with the XSD specifications
• Logged all the defects and generated reports using Defects module in Quality Center 10

Environment: Data stage, MS SQL Server SSIS, Windows XP, TIENET (.Net Front end application),Oracle Developers, ATS and CAP (Mainframe) PL/SQL, Oracle, Java, VB, MS Access, Quality Center, XML)

Confidential, Atlanta, GA

Business Objects/ETL Developer

Responsibilities:

• Designed and developed Business Objects Reports, Dashboards with XIR2 Business Objects
• Worked on maintenance of all aspects of the Business Objects in production and development BO environment.
• Designed the Data Model using Erwin 3.5 and integrating E-R models with the Oracle Database.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Developed Oracle Database procedures, functions.
• Involved in performance improvement for oracle queries building bit map and bit map join indexes
• Implemented Table partition, analyzed tables for faster data retrieval.
• Worked with Unix/Linux Operating Systems, UNIX/Linux shell scripting; bash/korn/c shell scripting
• Followed Snowflake Schema for methodology to organize the data into database by using ERWIN tool.
• Installed and configured Business Objects XIR2 in Various regions in a clustered setup on Websphere platform
• Migrated Web Intelligence and Deski Reports from BO 6.5 to BO XIR2 using import wizard
• Migrated Groups, Users, Connections, Personal Reports and User Security from BO 6.5 to BO XIR2 using import wizard
• Developed and implemented Security model for the Business Objects XIR2 repository
• Configured the BO security and BO parameters for timeout issues in various systems
• Migrated the universe and desktop Intelligence reports from 5.x to 6.5 and then to Business Objects XI R2
• Played the role of Business objects developer with responsibilities that includes report creation, generation and management.
• Maintained Web Intelligence Server on Solaris 8.0.
• Business objects- Info view was customized and was integrated in JSP technology. Was part of the team to develop this functionality in integrating the Infoview into JSP’s.
• Involved in optimizing oracle queries, debug the existing oracle stored procedures, and formulated optimized SQL queries for the Business users.
• Generated Standard reports (Pre-Canned Reports) on a Daily, weekly and monthly cycle.
• Data migration plan was developed involving defined process for identifying data sources, targets, required transformations, data cleansing techniques, data validators as required by business, performance benchmarks for meeting SLA.
• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Involved in Design and development of AbInitio applications for RDW.
• Developed many AbInitio Graphs using AbInitio GDE and troubleshot issues within existing Abinitio graphs and wrote complex transformations based on business requirements.
• Designed and developed complex AbInitio graphs using Partition by key, join, scan, gather, replicate, join, merge.
• Responsible for Deploying AbInitio graphs and running them through the cooperating systems mp shell command language.
• Assigned phases and set up checkpoints whenever necessary to complex graphs having large number of components to protect the graphs against failure, avoid dead lock and easy recovery of failed graphs.
• Developed various AbInitio Graphs for data cleansing using AbInitio functions

Environment: Business Objects XIR2, Business Object 5.x, Web intelligence 2.7.4, Broadcast Agent, Oracle 9i, TOAD IDE, Abinitio, Solaris 8.0, PLANVIEW, REMEDY, VIRTUA TECH, IPLANET, WEBLOGIC, SITESCOPE, TIVOLI, Autosys

Confidential, NY

Business Objects reports developer

Responsibilities:

• Installed and configured Business Objects XIR2 in various regions in a clustered setup on Websphere platform
• Migrated Web Intelligence and Deski Reports from BO 6.5 to BO XIR2 using import wizard
• Migrated Groups, Users, Connections, Personal Reports and User Security from BO 6.5 to BO XIR2 using import wizard
• Developed and implemented Security model for the Business Objects XIR2 repository
• Utilized Business Objects Universe Designer/Architect and was a single point of contact for all Business Objects Development deliverables provided by the Enterprise reporting team which included architecture, design and implementation and support of solutions using the Business Objects Enterprise Server, Crystal Reports and Web Intelligence and Xcelsius platforms.
• Worked on the discovery and enablement of row level security to get better performance when using universes.
• Worked on requirement gatherings from Business and created the specs for development of Universe Design/WebI
• Worked with cross functional Business and IT teams of business analysts, data modelers, solution architects, dba's and project managers during all SDLC phases
• Developed a methodology for migrating Webi reports belonging to an individual user from two independent security repository
• Developed Universes for Archived Data
• Responsible for POC, Development, testing and implementation of Business Objects reports and universes.
• Responsible for onsite/offshore co-ordination, provided understanding of client’s requirements to the offshore team and assist the offshore team with issues during development/testing cycle.
• Installed and configured Business Objects XIR3 in North and South regions in a clustered setup on Websphere platform
• Upgraded Business Objects XIR2 to XIR3 by migrating the repository from XIR2 installation into XIR3 installation.
• Copied all the objects from XIR2 to XIR3 using FRS copy from old to new version respectively and completed the process with an object update in CCM.
• Perform routine tuning/indexing of reports using tools provided in BO-XIR3
• Developed excellent Functional knowledge of the Vendor Procurement business in a problem-solving role.
• Interfaced with SMEs and Business Users to assess user/business/functional requirements.
• Facilitated User Acceptance testing (UAT) for the application as a Business user
• Coordinated execution of UAT test scripts and documented results
• Managed defects through effective and periodic defect triaging
• Conducted daily UAT test status meeting to identify and escalate any UAT testing issues to Test Manager
• Maintained Requirements Traceability Document.

Environment: Java, JSP, J2EE, Oracle 9i &10g, SQL* Plus, PL/SQL, Toad, PL/SQL Developer, Windows XP, UNIX HP- AIX, Business Objects 6.0,XIR3, Rational Clear Quest.

Confidential

Programmer Analyst - Abinitio

Responsibilities:

• Implemented AbInitio as an ETL tool to pull data from source systems, cleanse, transform and load data into databases and to respective files.
• Performed complex queries involving large data volumes.
• Replicated operational tables, Transformed and loaded data into Operational Data Store using AbInitio
• Informed manager on a weekly basis regarding development activities, issues the team is facing, work/milestones planned for the team.
• Strived to keep manger informed and have consensus on approach. Ability to provide written software development lifecycle documentation.
• Provided suggestions/Best Practices to team on code/logic/design, presented proof of concept for complex designs, Strived for Continuous Improvement
• Responsible for Development of complicated graphs with various AbInitio components.
• Implemented complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed into the Data Warehouse
• Used the following components of AbInitio in creating graphs. Dataset components (Input file, output file, lookup file, and intermediate file), Database components (Input table, output table, RunSql, Truncated Table), Transform Components (Aggregate, Dedup Sorted, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components), Partitioning
• Deployed and test run AbInitio graphs as executable UNIX Korn Shell scripts.
• Modified the AbInitio component parameters, utilized data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Identify/debug, troubleshoot, modify, document, test and fix production issues.
• Used the Autosys to schedule the jobs and used the UNIX wrapper scripts for linear scalability.

Environment: AbInitio co-operating system 1.x, 2.x, Autosys, Unix, Shell Script, Oracle, DB2, SQL Server, Java, JSP, Servlet, Struts 1.2, JavaScript, Html, Jscript, Windows XP OS, IBM Web Sphere Application Server 6.0, Crystal reports Oracle 8i, PL/SQL.