SURESH CHILUKURI

732-***-****(Mobile)

Email:

acsycu@r.postjobfree.com

SUMMARY

Extensive career Experience of More than 16 years in Software development

and 12 years in Data Warehousing and Decision support Systems and has

Wide Experience in implementing Data Warehousing solutions to large

corporate clients and has professional experience working in various

industries such as Retail, Manufacturing, Pharmaceuticals, Finance and

Government .

> Strong Consulting experience in Implementing Full Life cycle Data

Warehousing Projects.

> Skilled in defining and implementing the various components of a data

warehouse such as Operational source systems, Data staging, Data

presentation and Data access tools.

> Strong in Dimensional modeling techniques.

> Strong in designing Star Schemas and snow Flake Schemas.

> Skilled in Converting the Business Logic into Technical

Specifications.

> Over 12 years of experience with ETL tool Data Stage

9.1/8.7/8.1/7.5/7.1/6.0/4.0.

> Over 12 years of experience with Business Objects 4.1/4.0/X1

R3/6.5/5.1/4.0, Web Intelligence.

> Over 12 years of Hands-on experience in designing, tuning, and

leveraging large data warehouses.

> Over 14 years of experience in implementing Oracle database

applications.

> Over 3 years of experience in Data Modeling.

> Over 10 years of experience in AIX environment.

> Expertise in deploying OLAP tools, Materialized Views, and

partitioning techniques for highly responsive Decision Support

Systems.

> Over 4 years of experience with ETL tools such as Informatica (Power

Mart/Power Center).

> Over 3 Years' Experience working as an Independent Verification and

Validation (IV&V) Consultant.

EDUCATION

MBA, Information Systems and Marketing

Bachelor of Engineering, Electronics

SKILLS

> DW Development - 14 years

> DW Architecture - 12 years

> Business Intelligence/Reporting -14 years

> SAP - 2 years

> Business Objects -14 years

Professional Experience:

BCBS, Richardson, TX

Nov2014-Tilldate

Senior Data stage / Info Sphere Consultant

Blue Cross and Blue Shield known for health care coverage. It has been

around for more than 80 years, and the cross and shield has come to

represent the most experienced health care coverage organization in the

state and the nation. The Data Integration Hub (DMIH) project is

responsible for the processing of changed data transactions (generated from

internal and external source systems of record) into conformed and

standardized data ready for consumption by the enterprise. The DMIH will

employ an Integration Data Store and Enterprise Metadata to accomplish this

task.

. Involved in meetings with business analysts to gather and understand

the business requirements and process flow details in order to plan

the ETL extraction and loading.

. Extracted data using different strategies from the various native SQL

against relational databases like DB2,Teradata and flat files for

multiple projects involved in.

. Enhanced and developed data stage jobs for data load into Fact and

Dimension Tables using different stages like Transformer, Aggregator,

Sort, Join, Merge, Lookup, Sequential file, Dataset, Funnel, Remove

Duplicates, Copy, Modify, Filter, Surrogate Key .

. Imported healthcare data from various transactional data sources

residing on DB2, Teradata,flat files and performed Null value

handling, data Cleansing using null handling functions and UNIX.

. Developed complex jobs and made sure that each record in all processed

files has at least one ETL action indicator in its corresponding ETL

audit table identifying if the record was an insert, update, no

change, or delete followed by loading into oracle Database and flat

files.

. Enhanced the reusability of the jobs by making and deploying shared

containers and multiple instances of the jobs.

. Involved in writing UNIX shell scripts for automation, job run, file

processing, initial load, batch loads, cleanup, job scheduling, and

reports Linux/UNIX environment.

. Created Audit jobs and generated Reconciliation reports balancing the

Source and target record counts using DS Job Report Functions and DS

job commands by reading job Start time, End time, Source records

count, Target records count, Reject records count and no of warning

messages generated in the DataStage director log.

. Extensively worked on error handling, data Cleansing and performing

lookups for faster access of data.

. Used lookup stage with reference to RDBMS tables for insert/update

strategy and updating of slowly changing dimensions.

. Involved in Unit testing, Integration testing, UAT by creating test

cases, test plans and helping Data stage administrator in deployment

of code across Dev, Test and Prod Repositories.

Environment: IBM Info Sphere DataStage 8.5 (Designer, Director,

Administrator, Parallel Extender), Db2, Teradata 13, Sequential files,

Zena, UNIX

Office Of Information Technology, State Of New Jersey, Trenton, NJ Sep

2003 - October 2014

Title: Senior Systems Integrator /Data warehouse Architect (ETL and

BI)//IV&V Consultant

. Liaise with business subject matter experts in analysing business

requirements (Productivity related - KPIs), understand the various

data sources.

. Architect the productivity data mart. Review and maintain the schema,

its tables, indexes, views and PL/SQL procedures in Oracle 10g.

. Conducted Verification Activities for the Clients.

. Used Verification techniques such as Code reviews, Inspections and

Process walk Trough's.

. Used Validations techniques such as Unit testing, Functional Testing

and User Acceptance testing,

. Develop strategies for use in high volume, high performance

heterogeneous environment.

. Map source data elements from various systems like

-eCATS,NJAWS(Treasury),BMS,Transparency and develop, test, and

support extraction, transformation and load processes.

. Analyzed source data and Applied business rules to the data in the raw

data mart and load it to the reporting data repository. Defines and

captures metadata and rules associated with ETL processes in

Datastage.

. Design and develop the technical/functional specification for ETL

development and implement using Datastage. Analyze dependencies for

Sequences for various ETL processes, handle exception, and maintain

logs.

. Manage artifacts - versions, including software code, documents,

design models, and even the directory structure itself.

. Designed specifications for reports.

. Documented all Meta data dictionary. Involved in Full life cycle

design and development of Business Objects reporting Applications.

. Involved in designing data marts from data warehouse and generated

reports using Business Objects.

. Designed reports in outline mode for different hierarchies.

. Designed and maintained Complex BO universes for report development.

. Involved in testing new feature in BO XIR3.

Environment: Data Stage 9.1/8.7/8.1/7.5 (Manager, Designer, Director,

Administrator), SAP Business Objects 4.1/4.0/ XIR3/6.5, ER/Studio, Oracle

9i/10g, AIX 5.2

KOMATSU America Inc, Chicago, IL

DEC 2002-SEP2003

Title: Project Lead (Data warehouse Consultant)

. Involved in system analysis and design of the Data warehouse.

. Responsible for designing Data warehouse schemas using Erwin.

. Developed Functional (Business terms) and Technical Design documents.

. Involved in developing Logical and Physical Data Models.

. Responsible for Formulating the DW process to load from sources to

Target tables.

. Involved in Installation of Data stage 6.0 and setting of ODBC

drivers.

. Implemented security for data stage projects and groups.

. Designed data stage jobs logic flow from Various Sources to ORACLE

Data warehouse.

. Developed Data Stage jobs where in using data stage, data from

different sources formatted, Cleaned, summarized, aggregated and

transform into data warehouse.

. Developed database triggers for data validations.

. Responsible for integrating the data warehouse on both Windows and

Unix platforms.

. Designed, build, and maintained Business Objects universes.

. Responsible for fitting Business Objects into the Information

Architecture of the company as well as supporting business users and

developing new and maintaining existing Universes.

. Design and develop extensive Business Objects reports, including

complex reports using multiple queries, combination chart and tables,

Will set up Business Objects Universe for each reporting group Assist

in establishing a Business Objects environment.

. Interaction with end-users and business analysts to identify and

develop business requirements and transform it into technical

requirements and ultimately will be responsible for delivering the

solution.

Environment: Business Objects 6.0 Enterprise (Designer, Reporter, Info

view, Supervisor, Broadcast Agent and BO Web Intelligence),Data Stage 6.0

Oracle 9i, Windows NT Advanced Server, UNIX (Solaris, AIX),, SQL Server

2000,SAP R3, Windows 2000.

BP-Amoco, Warrenville, IL

Oct 2002-Nov2002

Title: Team Lead (Data warehouse consultant)

. Involved in the Design of the BIE Data warehouse.

. Designing the Target Schema definition and Extraction, Transformation

and Loading (ETL) using Data stage.

. Mapping Data Items from Source Systems to the Target System.

. Interviewed users to collect requirements, analyzed them and

transformed them into technical specifications.

. Generated various reports as per the client's requirements

. Used Business Objects 5.1.2 for developing reports

. Responsible for Creation of the Universe with Classes, Objects and

Condition objects.

. Resolved loops in universes using Aliases and Contexts.

. Set up Aggregate Awareness to enhance the performance of SQL

transactions.

. Developed Hierarchies to support drill down reports

. Created the reports using Business Objects functionalities like

Queries, Slice and Dice, Drill down, @Functions, Cross Tab,

Master/Detail and Formulas etc.

. Responsible for creating various Users and implementing Securities

depending upon the operational basis using BO Supervisor.

. Involved with documentation of the code, organizing production and

deployment.

. Assisted in creating technical documentation and user manuals.

. Extensively involved with end user training in Business Objects

Reports.

Environment: Business Objects 5.1/5.0 (Designer, Reporter, Info view,

Supervisor, Broadcast Agent and BO Web Intelligence), Data Stage4.0,

PL/SQL, Windows NT Server 4.0, UNIX (Solaris, AIX), ORACLE 8i, SQl Server

2000,SAP R3, Windows 2000.

Bearing Point (Formerly KPMG Consulting), NY

July 2002-Oct 2002

Client: Pfizer Inc. (SEE Group)

Title: MIS consultant

. Involved in the design of the data mart

. Interviewed users to collect requirements, analyzed them and

transformed them into technical specifications.

. Responsible for design and development of reporting system using

Business Objects 5.1.2 as well as training end-users.

. Responsible for Creation of the Universe with Classes, Objects and

Condition objects.

. Resolved loops in universes using Aliases and Contexts.

. Set up Aggregate Awareness to enhance the performance of SQL

transactions.

. Developed Hierarchies to support drill down reports

. Created the reports using Business Objects functionalities like

Queries, Slice and Dice, Drill down, @Functions, Cross Tab,

Master/Detail and Formulas etc.

. Tuned the reports for better performance using SQL.

. Involved with documentation of the code, organizing production and

deployment.

. Assisted in creating technical documentation and user manuals.

. Extensively involved with end user training in Business Objects

Reports.

Environment: Business Objects 5.1/5.0 (Designer, Reporter, Info view,

Supervisor, Broadcast Agent and BO Web Intelligence), Informatica 5.1,

PL/SQL, Windows NT Server 4.0, UNIX (Solaris, AIX), ORACLE 8i, Windows

2000.

Employer: Global Cynex INC

May 98 -July 2002

Responsibilities

. Involved in system analysis and design of the Data warehouse.

. Responsible for designing Data warehouse schemas using Erwin.

. Developed Functional (Business terms) and Technical Design documents.

. Involved in developing Logical and Physical Data Models.

. Responsible for testing and data quality the data and conforming it to

the business rules before loading to the Data Warehouse.

. Involved in connecting to Oracle, Sybase, db2 databases and other flat

files using ODBC.

. Developed data base triggers for data validations.

. Written stored procedures for complex calculations.

. Created Partitions and indexes on database tables for faster execution

of queries and involved in database performance issues.

. Developed complex transformations like aggregator, expression and

filters etc.

. Worked extensively with lookup and Router transformations.

. Created folders and users with repository manager.

. Ran batches and sessions with Informatica server manager.

. Developed mappings, transformations, sessions and batches using

Informatica power center 5.1.

. Provide technical support for data warehouse

. Deploy application to end-users.

. Responsible for integrating the data warehouse on both Windows and

Unix platforms.

. Designed, build, and maintained Business Objects universes.

. Responsible for fitting Business Objects into the Information

Architecture of the company as well as supporting business users and

developing new and maintaining existing Universes.

. Design and develop extensive Business Objects reports, including

complex reports using multiple queries, combination chart and tables,

Will set up Business Objects Universe for each reporting group Assist

in establishing a Business Objects environment.

. Interaction with end-users and business analysts to identify and

develop business requirements and transform it into technical

requirements and ultimately will be responsible for delivering the

solution.

Environment: Informatica power center 5.1,Erwin4.0, Oracle 8i,Terradata,

Sybase, DB2, MS-access, SQL Server, HP Unix, Windows NT4.0/2000,

Business Objects 5.1.1, Web Intelligence 2.7, IIS, ASP, MS

FrontPage, VB Script, HTML

Interface technology Group

Mar'96 to May'98

This Project was done as part of my Coursework

Responsibilities:

. Designing of Forms.

. Coding & testing.

. Documentation and Maintaining Versions.

Environment: Visual Basic 5.0, oracle 7.1.

Contact this candidate