SUMMARY:

• SAP Business Objects Certified Professional — SAP Business Objects Data Integrator XI
• SAP Business Objects Certified Professional — SAP Business Objects Web Intelligence XI 3.0
• 10+ years of experience in Information Technology Industry including 7+ years as a SAP BusinessObjects Developer in Mining and Metals, Banking, Pharmaceutical, Gambling and Casino, Finance, Manufacturing, and Advertising Industries
• Worked on all stages of software development life cycle including Analysis, Design, Development,Testing, Implementation, Documentation, Maintenance and Enhancements and End Users
• Experience with full lifecycle activities with - ELT/ETL design, modeling and Scheduling
• Good exposure to Kimball methodologies of Dimensional modeling
• Expertise in designing efficient/optimized Data Integrator code for data extraction, transformation and loading data from various sources, proficient with T-SQL and PL/SQL programming
• Experience in deployment of Business Objects & Web Intelligence from Various Sources like Oracle,Oracle Applications, Informix, Oracle Siebel CRM, MS SQL Server, and Access
• Senior level skills in Analysis, Design, Development, Installation, Maintenance / Enhancements,

TECHNICAL SKILLS:

PL/SQL, Stored Procedures, T: SQL, MS-DOS/Perl/Unix shell scripts

Database: Oracle 7x / 8i / 9i/10g/11g, MS SQL Server 7.0/2000/2005, IBM Informix Dynamic Server Version 7.x/9.4 /11.5, Oracle Application 11i, Oracle Siebel CRM RELEASE 16, Labware LIMS, Sybase 12.x/15.x, Sybase IQ 12.x

Database Tools: DbVisualizer 5.1/6.0.2, Rapid SQL, TOAD, Oracle SQL Developer, Advanced Query Tool, ER/Studio 9.5.0

Business Intelligence: Business Objects 5.1.6/6.1, XI R2/3.0, Meta Data Integrator, Web Intelligence XI R2/3.0, Data Integrator 6.5/11.0.5.2/11.5.2/11.7/11.7.2/11.7.3.2, 11.7.3.3/Data Service, OBIEE, Oracle Data Integrator (ODI) 11.1.1.6.3, Oracle Data Integrator 11.1/12.1.3, Tableau Desktop Version 9.0.6

Operating Systems: Red Hat Enterprise Linux, UNIX (HP-UX), Windows 3.1, Windows 9X, Windows NT/2000/ME/XP, Windows Server 2003, MS-DOS, Mac OS

Other Tools: Microsoft products (word, excel, power point, Outlook), Visio, MS-Access, Microsoft VisualSource Safe 6.0, IBM Rational ClearQuest 7.1, Textpad 5.3.1, Large text File viewer 5.2u, Github

PROFESSIONAL EXPERIENCE:

Confidential, Maryland Heights MO

Senior Data Warehouse Developer/Analyst

Responsibilities:

• Did extensive data analysis using source data and UI to understand the data, to assist data modeler in designing the databases, to identify bad data, to help Business in improving and redefining the requirements
• Did error analysis for continued improvement of the system by catching data anomalies and code issues
• Mentored new Interns; trained them in ODI and WWT DW standards
• Designed Dimensional model to support WWT’s Business process to answer complex business questions
• Lead Enterprise Data Warehouse thought contribution and innovation meetings
• Organized daily stand up meeting to keep track of the progress and finding resolution for any obstacles faced by the team
• Communicated over all status of the project to upper management and stakeholders
• Planned and prioritized tasks to meet the deliverable deadlines in agile environment
• Gathered and documented requirements and translate them into technical specifications for data modeling for ELT (extraction, loading and transformation)
• Created Interfaces, custom store procedure to load data into staging, dimension and the facts
• Created Custom Procedure/Functions to make the code reusable
• Participated in all the phases of project - development, testing, deployment and support
• Participated in code reviews, code promotions from dev to test, staging and production environment using ODI
• Wrote unit test cases, test scenarios, unit test documents, unit tested for all the possible test scenarios.
• Re-architected Charts of Account of Oracle EBS into DW
• Used Type 1 SCD and Type 2 SCD mappings to implement Type-2 dimension and also a variant of T-2 to support month end reporting
• Developed Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, data blending
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Created report for ServiceNow data to keep track of trends in Incident, Service Request
• Dashboard to show daily load status of DW and data sync report
• Performed performance tuning of targets, sources, mappings and session
• Worked with complex SQL, Triggers and Views
• Worked along with DBA’s for deploying new tables using Oracle Golden Gate
• Loaded ServiceNow data feed via XML file into DW using ODI for quarterly Roadmap meetings
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository
• Engaged in 24 x7 rotational production support for business critical applications
• Helped fellow members, to understand and in designing Supply Chain solutions (PO fact table)
• Designed and Developed Operational Data Sources (ODS) for Shipping and Receiving business
• Helped fellow members, in fine tuning SQL queries
• Educating/Presenting new features of ODI to team members (JSON parsing)
• Managed off-shore team

Environment:, OBIEE, Oracle Data Integrator (ODI) 11.1.1.6.3 /12.1.3, Oracle 11.2g, Toad 11.5, Windows 7 Enterprise, Windows server 2008,, Oracle Sql developer 3.0.04/4.0.0, Tableau 9.0, ER/Studio 9.5.0

Confidential, St. Louis MO

Data Engineer

Responsibilities:

• Designed Data model for the Predictive model
• Loaded various flat files in to Oracle staging tables
• Normalized data in to monthly format from a propriety format of Ventyx’s
• Incorporated multiple scenarios in the model i.e., Coal, Gas, Transport prices and Weather scenarios
• Wrote various custom functions to speed up the overall execution of the ETL process
• Performed detail Unit testing
• Designed Universe for Predictive model, having 5 classes, with 77 objects
• Created Dispatch graph using R
• Designed Dispatch Curve, Avg Coal Burn, Avg Gas Burn WEBI reports for end users
• Documented the project, for future implementation using HANA and Sybase
• Worked as a Technical Lead with SAP team, on HANA and Sybase implementation
• Knowledge transfer to appropriate responsible party
• Re-designed complex PL/SQL codes into ETL code for ease of maintenance
• Recommended Primary keys, Indexes on DW tables, which reduced execution time from 25 mins to 18 mins
• Amended existing Fact jobs to include more granular data, to identify root cause
• Added more dimension tables to existing schematic as per user requirement
• Corrected/Re-designed old logic to bring prices into the warehouse, when the market was close
• Designed various reports for Business user, especially ‘Forward Price Consolidation’
• Optimized/fine-tuned existing code to reduce overall loading time of DW by 30%
• Optimized Source queries, by studying explain plan suggested indexes on source/target and staging tables
• Converted Target-based CDC to Source-based CDC
• Used various transforms like Map CDC, Table Comparison, Map Operation, Key generation and Query transforms
• Converted all SQL transform based code into DI code for Metadata reporting
• Re-designed Dim/Fact tables Job, to use Source based CDC
• Wrote various custom functions to implement day to day mundane tasks
• Responsible for Ad hoc / Regression testing and documenting all DI custom functions/programs
• Converted various SQL based transform into DI code
• Created various WEBI reports for end Users

Environment: Data Services 12.2.2, Business Objects Enterprise XI 3.1, Oracle 11.2g, Toad 10.2.2, Windows 7 Enterprise, Windows server 2008, Mincom Ellipse 5/8, Oracle Sql developer 3.0.04

Confidential, Bridgeport CT

SAP Data Services Consultant

Responsibilities:

• Created Flat File extract from various sources i.e., DB, FIS
• Wrote various custom function to implement complex processing logic
• Converted multiple format report data in to single report based upon Report-id
• Scrapped reports, and loaded data into a clean text files and then to IQ warehouse
• Used reconciliation report to validated data before they get into warehouse
• Used FTP batch scripts to load/unload flat files in to pre-defined landing areas
• Used variables and parameters extensively to write generic WF’s to support day to day mundane task
• Used File and Batch controls tables, to keep track of processing days of ETL jobs
• Used various transforms like Row generation, Query, Pivot, Reverse Pivot, SQL and Map Operation, Table Comparison, Merge, SQL
• Used complex in-built functions like gen row num by group, is group changed, match regex, match pattern, extract from xml to simplify design process
• Used XML Pipeline transform to process large XML files
• Worked with Secure Central Repo to maintain code versioning
• Responsible for Ad hoc / Regression testing and documenting all DI custom functions/programs

Environment: Data Integrator 11.7.3.3, Oracle 10g, Sybase ASE 12.x/15.x, Sybase IQ 12.7, MS SQL Sever 2005, Advanced Query Tool 7.1.7, Textpad, Large Text File Viewer

Confidential, Indianapolis IN

Lead ETL Developer

Responsibilities:

• Recommended best practice for ETL Standards, development and deployment
• Migrated code from 11.7 to 3.2 version
• Loaded data from different disparate sources into Staging area and then to ODS
• Used Data Profiler to determine the quality of source data before extraction
• Designed highly optimize job to load mass data volume from Informix source to Oracle Database
• Used various transformations like SQL, Case, Query, Map Operation, Table Comparison, Merge, Map CDC, Validation and Reverse Pivot etc
• Designed and developed 200+ Data Integrator programs
• Identified and rectified bottleneck in long run dataflow, using step-up approach
• Transferred 400GB of data from legacy DB to new ODS, loading 150+ tables
• Wrote generic custom function to reset Ora-sequences, to create indexes and to analyze tables among other useful custom functions to simplify design
• Used complex functions like pushdown sql, extract from xml in Query transforms
• Loaded data from inconsistent flat files, whose schema was stored in XML format
• Loaded data from Flat, Excel and XML files into Operational Data Source (ODS)
• Worked with Secure Central Repo to maintain code versioning
• Responsible for Knowledge transfer
• Responsible for detail Unit testing and documenting all DI programs
• Created and tested detail test cases for each Data flow

Environment: Data Integrator 11.7.3.2/12.2.1, Oracle 10g, Informix Dynamic Server 9.52C1/ 11.50.FC5W4X3, Lab Ware LIMS, Windows XP Prof, Windows Server 2003, Microsoft VisualSource Safe 6.0, IBM Rational ClearQuest 7.1

Confidential, Chicago IL

Data Warehouse Developer

Responsibilities:

• Studied the existing data model to in corporate new information
• Translate the Functional/Business requirements into detailed design documents and then to ETL mapping documents
• Created additional dimensions and fact tables
• Created the Data Stores, Data Flows, Work Flows, Jobs and Projects following the Client Specific Naming Convention.
• Created custom user defined functions and Stored Procedures, used multiple transformations like SQL, Case, Query, Map Operation, Table Comparison, Case, Merge and Reverse Pivot etc
• Wrote scripts within jobs to automate the process, parameter setting / initialization for the flat files
• Analyze data in the source systems to assess data cleanliness and make recommendations for addressing within the source systems or as part of the ETL process
• Responsible for end to end testing and fixing the defects
• Communicated with management and evaluating the DI Job execution Status to guarantee the consistent performance
• Configured excel adapter in DI on Linux Platform
• Implemented Delta load using Time Stamp based method on Dim and Fact table, there by reducing the total execution time from 8 hrs to 5 hrs
• Converted Oracle-Packages to BODI programs
• Created 25+ canned reports for end users in WEBI
• Created linked report using external variable at report level and at Universe level
• Created Universe mapping documents for all Universes
• Designed a Dynamic column selection report
• Modified Universe to create new objects
• Documented entire Data Warehouse ETL process
• Designed Data Model for the project
• Designed STAR SCHEMA following Dimensional Modeling approach
• Loaded data from MS SQL Server into Staging table
• Cleaned data in DI using proper data types and mappings
• Loaded Dimension and Fact table
• Tuned jobs for performance optimize the resources; push-down the load on to source database / applications
• Scheduled Job using Web Admin Feature
• Designed and developed several Data Integrator programs
• Designed Universe consisting of 11 classes and 89 objects
• Detected cardinalities, loops, and checked the Integrity of Universes
• Created aliases tables at Universe
• Created 20+ Ad Hoc WEBI and canned reports
• Extensively used For all, For Each and IN operator in the report
• Worked with Merge Dimension to create complicated reports
• Worked with combined queries to answer complicated business questions
• Performed unit testing / integration testing on data loaded into the dimension and fact tables
• Documented the whole ETL process
• Designed Data Model for the project
• Designed STAR SCHEMA following Dimensional Modeling approach
• Loaded data from Oracle Siebel CRM into Staging table
• Cleaned data in DI using proper data types and mappings
• Loaded Dimension and Fact table
• Tuned jobs for performance optimize the resources; push-down the load on to source database / applications
• Scheduled Job using Web Admin Feature
• Designed and developed several Data Integrator programs
• Documented the entire DI project, using Auto-Documentation Feature
• Designed Universe consisting of 4 classes and 110 objects
• Created Master/Detail reports. Included cross Tabs, charts, and drill functions in reports to analyze data
• Detected cardinalities, loops, and checked the Integrity of Universes
• Created 15+ Ad Hoc WEBI and canned reports
• Extensively used For all, For Each and IN operator and other inbuilt custom functions in the report
• Worked with Merge Dimension to create complicated reports
• Worked with combined queries to answer complicated business questions
• Performed unit testing / integration testing on data loaded into the dimension and fact tables
• Documented the whole ETL process
• Designed Data Model for the project
• Designed STAR SCHEMA following Dimensional Modeling approach
• Cleaned data in DI using proper data types and mappings
• Loaded Dimension and Fact table
• Tuned jobs for performance optimize the resources; push-down the load on to source database / applications
• Scheduled Job using Web Admin Feature
• Designed and developed several Data Integrator programs
• Documented the entire DI project, using Auto-Documentation Feature
• Designed Universe consisting of 6 classes and 200 objects
• Created Master/Detail reports. Included cross Tabs, charts, and drill functions in reports to analyze data.
• Detected cardinalities, loops, and checked the Integrity of Universes
• Created 20+ Ad Hoc WEBI and canned reports
• Extensively used For all, For Each and IN operator in the report
• Worked with Merge Dimension to create complicated reports
• Worked with combined queries to answer complicated business questions
• Performed unit testing / integration testing on data loaded into the dimension and fact tables.
• Documented the whole ETL process

Environment: Data Integrator 11.7.2, Oracle Applications 11i, Oracle 9i/10g, MS SQL Server 2005Windows XP, Red Hat Enterprise Linux ES release 4, BO XI R2 Designer, BO XI R2 Info view

Confidential, Washington, DC

Data Warehouse Developer

Responsibilities:

• Analyzed the old code and did some fine refinement on the same
• Changed some of the ETL logic for better understandability for future
• Incorporated Scripts and Variables to simplify the design
• Used tables instead of custom SQL transform code to implement YTD calculation
• Implemented Delta loading thereby reducing execution time of the job from 25 min to 12 min and from 150 min to 30 min
• Scheduled job using Web Admin triggered by some external event
• Designed Data Model for the project
• Analyze source data, to design Logical and physical database
• Designed STAR SCHEMA following Dimensional Modeling approach
• Loaded data from ORACLE DB into Staging table
• Cleaned data in DI using proper data types and mappings
• Loaded Dimension and Fact table
• Implemented Type 2 Dimension, for History Preserving
• Scheduled Job using Web Admin Feature
• Designed and developed several Data Integrator programs
• Documented the entire DI project, using Auto-Documentation Feature
• Designed Universe consisting of 24 classes and 450 objects
• Resolved Loop in the Universe
• Created 10+ Ad Hoc WEBI reports
• Created linked report using external variable at report level and at Universe level
• Created Custom Hierarchy for Dice and Drill functionality
• Analyzed data source to designed simple and efficient query transforms
• Loaded data from flat files
• Designed work flows and data flows
• Cleaned data in DI using proper data types and mappings
• Extracted data from Oracle database
• Wrote custom function to implement Business day logic for job execution
• Scheduled Job using Web Admin
• Designed and developed several Data Integrator programs
• Wrote customized Scripts
• Documented the entire DI project, using Auto-Documentation Feature
• Closely worked with B.A, to designed efficient Data Integrator Jobs

Environment: Data Integrator 6.5/ 11.7, Oracle 9i/10g, Data modeling, Windows 2003 server/XP

Confidential, NYC, NY

BO Data Integrator (ETL) Developer

Responsibilities:

• Used external scripts invoked from DI to remove headers in source files
• Converted files to single delimited appended by date
• Used T-SQL (Nested Cursor, SP) to load into staging tables
• Designed Work flows and Data flows
• Wrote scripts to populate dimension and fact tables
• Cleaned data in DI using proper data types and mappings
• Loaded data into staging table
• Designed and developed several Data Integrator programs
• Documented to whole DI project, using Auto-Documentation Feature
• Performed UNIT test against Source, Staging and Data mart
• Wrote customized PERL program, later invoked by DI

Environment: Data Integrator 11.5.0.2, MS SQL 2003, Windows 2003 server/XP, Perl

Confidential

Web-Master

Responsibilities:

• Gathering requirements from the faculties
• Designing-Developing WebPages for the faculties
• Amending existing information of the webpage
• Keeping up-to-date information for the faculties
• Designing-Developing Websites for small businesses
• Maintaining in-house database
• Designing database driven applications

Environment: Macromedia Dream Weaver, Flash, Fireworks, Win XP Prof, MySQL DB

Confidential

Graphic Designer

Responsibilities:

• Gathering requirements from the clients and Ad representatives
• Designing Flyers/Brochures for the clients
• Designing Ads for the clients based on the information supplied
• Making corrections on the existing advertisements
• Working closely with the Newsroom and Sales team
• Planning and designing of Newspaper layouts and ad design
• Maintaining a database of old and New Ads

Environment: Mac OS, Adobe Photoshop, Adobe In design

Confidential

Oracle Programmer

Responsibilities:

• Migrating from Oracle 7 to Oracle 8i
• Designed tables with integrity constraints for input data validation.
• Extensive use of triggers to check the entry of proper data into appropriate tables.
• Written stored procedures to exploit batch operation in the application.
• Implemented referential integrity among tables.
• Involved in the design, development, testing, and implementation of the modules.
• Changed the backup strategy.
• Maintained different security levels for different group of users.

Environment: Windows NT, Oracle 7.x/ 8.0.5, and Erwin 2.5.

Confidential

Graduate Student

Responsibilities:

• Online shopping cart system - Part of Web Design and Programming Studio course Work
• Came up with the idea for the project
• Acted as a Team Leader for the project
• Carried out detail design requirements
• Scheduled meeting with team members for week to week progress monitoring
• Prepared monthly project charter for submission and to track progress
• Created the final draft of the project
• Implemented the “PayPal Payment Gateway” feature for the project
• Presented and demonstrated a working prototype of the project to the class
• Vending Machine Controller - Part of Principles of VLSI Design Course Work
• Came up with the idea for the project, later approved by the Advisor
• Carried out detail design requirements for the same
• Implemented the same in AHDL and VHDL
• Studied the timing effects and various parameters
• Presented and demonstrated a working prototype of the project to the class
• Analysis of various Sorting Algorithms - Part of Design and Analysis of Algorithms Course Work
• Coded various sorting algorithms in C language on HP Unix platform
• Analyzed their performance for disparate input files
• Documented the whole projects with results and conclusion
• Time Management System - Degree requirement for Bachelors of Computer Engg.
• Designed various webpage layouts/screenshot in Photoshop
• Coded the front end in various language Java, Html, CSS
• Back end was driven by MySQL Database
• Consolidated the entire project and documented the same
• Presented and demonstrated a working prototype of the project
• Presented a topic Primality testing as a part of Theory of Computation course work, judged to be one of the most difficult topic presented in the class
• Researched on Parallel Programming language MPI under Dr. Ruttan, implemented various parallel program specially Game of life as a interesting one along with others
• Explored a research work under the guidance of Dr. Walker towards Master’s Thesis topic primarily focused on implementation of Longest Common Subsequence algorithm for DNA sequences on Associative Processor on FPGA