SUMMARY:

• Over 22 years of experience in IT.
• Extensive experience wif designing and implementing data warehouse, including systems architect, data warehouse design, Data modeling, implementation and tuning.
• In depth experience in Database Object programming like stored procedures, Triggers, Packages, Cursors, Tables, Constraints, Rules, using Standard Packages, system procedures, methods etc.
• Solid skills wif ETL design, development and implementation.
• Proficient wif system development methodologies, like System development life cycle (SDLC), and capability maturity model (CMM).
• Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• Good experience in integration of various data sources (DB2 - UDB, SQL Server, PL/SQL, Oracle, Teradata, XML and MS-Access) into data staging area.
• Good understanding/knowledge of Hadoop Architecture and its components - HDFS, Job Tracker, Task Tracker, Name Node, Data Node and MapReduce.
• Good working knowledge in NoSQL databases HBase and MongoDB.
• Developed big data workflows to process very large datasets.
• Experience in developing Hive Query Language and PIG Latin Scripts.
• Hands on in depth experience in Creating Conceptual, Logical and physical data designs/models, Data flow diagrams, data modeling including Star/Snowflake Schemas. Also, experienced in Forward / Reverse Engineering of physical data models.
• Possess good knowledge of commercial applications such as Health care, Pharmaceutical, Inventory, Banking, Finance, Education, Hotel industry, Oil and Gas, Payroll, Financial Accounting, Telecomm, and Energy.
• Excellent analytical skills and problem solving capabilities.
• Technical Project Manager, and Enterprise IT/Middleware Solution Architect, has good experience in DW and can identify deficiencies and recommend solutions.
• Experience in SOA, SOAP/XML, XSD, WSDL.
• Knowledge of laas, PaaS & SaaS
• Experience in implementation knowledge of Distributed Web Services, SOA Web services.
• Quick learner wif good communication, interpersonal and time management skills, can effectively manage and prioritize tasks, highly organized wif attention to details. Self-motivated, punctual, creative, responsible, hard working. Able to work under pressure in a multi-task environment.
• Talented, team player and intelligent.

TECHNICAL SKILLS:

Languages: C, C ++, SQL, PL/SQL, Transact SQL, UNIX K Shell, Perl, VBScript, Java, JavaScript, Python.

Software: PowerBuilder, Visual Basic, Access.

CRM: Siebel 6, Siebel Tools.

Big Data: Hadoop, Cloudera, Hive, HBase, Pig, Sqoop

NoSQL: HBase, Cassandra.

Databases: DB2, Oracle7,8,8i,9i,11,12, Sybase, Informix, MS SQL Server, Tera Data.

Data Modeling: ER Win, DBArtisan.

Utilities: Oracle Enterprise Manager, SQL*PLUS, isql*plus, Oracle Export/Import, SQL*loader, RMAN, SQL Navigator, SQL Trace, TOAD, Desktop DBA, Rapid SQL, SQL Navigator, Oracle*Net, Net8, SQL*Net, TCP/IP.

Operating Systems: AIX, SUN / SOLARIS, MS Windows, UNIX, Linux, OS/2, Apple OSx.

EPM: MDM(DRM), FDM, HFM.

ETL: Ab Initio co>OS 2.8/ 2.9/ 2.10, GDE 1.8/ 1.9/1.10, Datajunction, SQL Server DTS/SSIS/SSRS, Data Stage 7.9, 8.1, 8.7,11.

BI: Crystal Reports (5,6,7), Business Objects.

Hardware: SUN, Confidential RISC/6000, DEC VAX, Confidential PCs and Compatible.

Servers: IIS, Netscape, Apache.

Scheduling: Control-M, TWS, Zena.

Other Software: MS Office, VI, EMACS, PVCS, Test Director, MS Project, MS PowerPoint, MS Source Save, SCCS, Maximo, Putty.

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Senior Developer / Data Architect / ETL specialist

Responsibilities:

• Design and developed DataStage jobs.
• Created tech specs and mapping docs.
• Converted RedPoint jobs to DataStage.
• Used data quality to standardize name and address data.
• Used analytics to get teh best matches.
• Involved in Data modeling, data quality control, accuracy of data.
• Tuned SQL for performance.
• Developed data stage jobs for EDI834.
• Involved in Data modeling.
• Involved in data quality controls, accuracy of data.
• Setting up DW architecture for new clients.
• Wrote stored procedures, tuned SQL for better performance.
• Created mapping documents.
• Created tech specs.

Confidential

Senior developer/ Data Architect

Responsibilities:

• Involved in data modeling to emphasize on common model across platforms.
• Involved in data quality by analyzing, identifying, correcting messy raw data.
• Worked on conceptual, logical and physical models.
• Designed database structures by analyzing client operations and applications.
• Developed Aptitude Micro Flows/ Complex Rules.
• Worked on enhancements & bug fixes.
• Developed/Implemented historic data archiving packages/procedures.
• Created partitioned tables & converted regular tables into partitioned tables.
• Created Reports.

Confidential, Minnesota

Data Architect/ DW SME

Responsibilities:

• Involved in data modeling to design common format tables.
• Worked on conceptual, logical and physical models.
• Analyzed and cleansed data, worked on integration and migration of data.
• Created new and fixed existing DataStage jobs.
• Created sql for new jobs and fixed existing job sql.
• Created/modified TWS jobs/streams.
• Created technical specs/design docs / mapping documents / Implementation plans / Metadata docs per source.
• Created/modified perl scripts.
• Managed off shore team.
• Created / integrated new structures in existing EDW data model.

Confidential, Lisle, IL

Data / Data Warehouse Architect

Responsibilities:

• Worked on Cornerstone Pricing project
• Engaged wif business to analyze different streams to load data from various systems to PROS database.
• Developed jobs to use XML as source and target.
• Involved in data modeling, data mapping.
• Created technical design and mapping documents by utilizing functional specs.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through Control-M.
• Extensively used ETL to load data from Oracle database, SQL Server, XML & Flat files Source to Oracle and Teradata.
• Extensively used CDC to maintain history in database.
• Worked wif dba’s to use hints, create indexes, modified tables to optimize job performance.
• Actively involved in data modeling to incorporate new sources in existing EDW and branching out data marts.
• Maintained

Key Technologies/Skills: DataStage, Oracle, SQL Server, Teradata, Control-M, shell scripts, SQL, PL/SQL.

Confidential, Levisville, TX

Big Data / Data Warehouse SME

Responsibilities:

• Engage wif Customer and other vendors to resolve issues, come up wif short/ long term solutions.
• Meet & discuss requirements wif various Business Owners for fresh projects.
• Created tech plans for local and offshore teams to follow changes to teh existing environment.
• Involved in teh Software Development Life Cycle (SDLC) of teh project from Analysis, Design, Implementation and Testing.
• Prepared teh High Level Design (HLD) wif details like Class and Sequence Diagrams.
• Preparing teh Business Requirement Documents (BRD’s) and Technical Spec (High level) for teh requirements from teh Project Managers.
• Plan data ingestion and integration process from teh EDW env into a Datalake in HDFS
• Wrote Hive queries, created schema, created partitioned tables, loaded data in tables.
• Wrote Pig scripts to massage/cleanse data.
• Extensively involved in data modeling, and overall product design.
• Created ETL jobs to load data in EDW.
• Involved in OLAP design and loading data.
• Worked wif Hyperion DRM Metadata, defined DRM properties, validations, queries, extracts.
• Used java to create web interface to communicate wif DRM.
• To let users use java front end to maintain COA, HFM Metadata, PS chart fields in DRM.

Key Technologies/Skills: DRM, Hyperion API, Java, Java Script, DataStage, Teradata.

Restatement Project

Confidential

Responsibilities:

• Worked wif DRM Metadata, defined DRM properties, validations, queries, extracts.
• Created FDM loads, mappings and automation scripts.
• Experience in Building HFM Data Grids, Hyperion Reports and rules.
• Recreate accurate historical Confidential for teh legal entities involved in teh financial restatement.
• Obtain certification from KPMG on teh reproduced historical financial reports.
• Create and certify restatement journal entries to correct financial reports.
• Recreate accurate corrected financial reports from Hyperion based upon restatement journal entries.
• Loaded base level financial data into atomic level database tables.
• Loaded additional data required to produce trial balances from summary balance based data.
• Loaded historical adjusting journal entries into atomic level database tables.
• Produced copies and reports of base level AJE’s and LBOR data for certification by auditing teams.
• Obtained and loaded supporting data such as a Chart of Accounts, legal entity listing, and fiscal year end vs. calendar year end adjustments.
• Created staging table structure and logic to convert atomic level data into a standardized data structure.
• Created trial balance for all required periods for each legal entity.
• Created extract and report capability to feed new Hyperion consolidating application.

Key Technologies/Skills: Data Stage, Oracle, SQL, PL/SQL, TeraData, SOAP UI, WebService (SOA, iLog), Control-M.