Himanshu Mishra

Professional Summary:

Over * years of IT experience with special emphasis on Development, Analysis, Design and Implementation of ETL methodologies in all the phases of the Data Warehousing life cycle with knowledge in ETL, Data warehousing & OLTP/OLAP technology and Data Migration.

Over 6 years of experience in building Data Warehouse/ Data Marts using IBM InfoSphere Information Server 11.5/8.5/8.1/7.5/6.0/5.2, Parallel Extender (PX), IBM Quality Stage 8.1/8.0.1/7.5, developing Unix shell scripts and involved in all the phases of Software Development Life Cycle (SDLC).

Over 4 years of experience creating dashboards and reports using the Business Intelligence tools.

Extensive experience in OBIEE 11g, and Oracle BI applications 7.9.5/7.9.6 which includes creating, customizing and managing repository and Presentation services (Answers, Dashboards & Delivers), BI publisher, BI (RPD and Web-catalog) administration.

Strong understanding of the Data Warehouse principles using Fact Tables, Dimension Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema.

Strong Knowledge of Extraction, Transformation and Loading (ETL) processes using Ascential Data Stage, UNIX shell scripting, and SQL*Loader.

Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), surrogate key assignment, CDC (Change Data Capture) and Change Apply.

Involved in Logical & Physical Design, Backup, Restore, Data Integration and creating Database objects (tables, indexes, triggers, views, and stored procedures).

Experience on OBIEE Administration, Production support, up gradation and Migration.

Expertise in integrating Heterogeneous data sources like Sybase, Oracle, MS SQL Server, Teradata, DB2 UDB, Flat Files, MS Excel and MS Access using Active/Passive stages available in DataStage.

Expertise in E-R modeling and Forward/Reverse Engineering using Erwin and experienced in Performance Tuning and Optimization of Parallel Jobs and Server Jobs.

Good experience in writing JIL scripts and designing Autosys jobs using Web GUI and proven track record in troubleshooting of DataStage jobs and addressing production issues.

Experienced with legacy systems and good understanding of SQL, RDBMS and Object-Oriented programming and design patterns.

Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Education Qualifications:

Master’s in Computer Science from Clemson University, South Carolina.

Employer:

FIRST-TEK, INC (Formerly known as CLOUDEEVA, INC)

August 2011 – Present

Projects Summary:

The Vanguard Group, Inc. Malvern, PA Dec 2017- Present

ETL/DataStage Developer

The Vanguard Group is an American registered investment advisor based in Malvern, Pennsylvania with over $4.5 trillion in assets under management. It is the largest provider of mutual funds and the second-largest provider of exchange-traded funds (ETFs) in the world. The scope of the project was to load the data into the SIEBEL EIM tables.

Hardware/Software: IBM InfoSphere Information Server 11.5, SIEBEL EIM, Oracle 12c/11g, OBIEE 12c/11g, UNIX, PL/SQL, SQL Developer, Control M, Slick Edit, Putty, Unix Shell scripting.

Responsibilities:

International Data Cleanup:

Designed DataStage jobs to extract the data from flat files, clean the data and load it into the staging Siebel EIM tables.

Evaluated daily batch schedules and ensured all deliverables and system availability, reports, extracts, SLA are within defined schedules.

Involvements in debug and enhance Data quality process using DataStage for daily file processing operation on test region, as required by the client and work root cause analysis.

Interacted closely with the team, in the scrum environment, to understand the SIEBEL EIM staging tables architecture and deliver the changes made to the requirements.

Created the best practices, coding standards for ETL development team coding tasks and performance tuning techniques.

Initiate and finalize the usage of external scheduler for ETL jobs execution overnight as part of daily night batches, weekly night batches, contingency batches.

Validations of all documentation being prepared by ETL team including technical specification, data flow diagrams, production operations notes and other system documentations.

Houston Community College, Houston, TX Feb 2013- Dec 2017

ETL/DataStage/OBIEE Developer

Houston community College System is a community college system that operates community colleges in Houston, Missouri City, and Stafford in Texas. The scope of the project was to build and maintain a Data Warehouse for the PeopleSoft EPM 9.1 OIR and performance tune the Campus solution ETL server jobs.

Hardware/Software: PeopleSoft EPM 9.1, IBM InfoSphere Information Server 8.5/8.1, Oracle 12c/11g/10g, OBIEE 12c/11g, UNIX, PL/SQL, TOAD, WinSCP, Putty, Unix Shell scripting.

Responsibilities:

OIR Module:

Built a data warehouse for the OIR module on PeopleSoft EPM 9.1,

Extracted the data from flat files and load it into the staging tables.

Conceptually design the dimension and fact tables.

Understand and develop SQR’s for the reporting team and guide the OBIEE team to produce similar report using OBIEE.

Analyzed crystal reports and guide the OBIEE team to apply proper filter to generate similar reports on OBIEE.

Designed new ETL jobs to extract the data from flat files and database tables and stage them.

Designed new ETL jobs to load the staging data in to the dimensions and facts after applying transformation and proper filter.

Created technical documentation for source to target mapping procedures to facilitate better understanding of the process and incorporate changes as and when necessary.

Campus Solution Module:

Support the existing Campus solution module

Designed new ETL jobs as per the requirements and did performance tuning of the existing server jobs.

Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database.

Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.

Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.

Prepared feature lists, technical documentation for source to target mapping procedures to facilitate better understanding of the process and incorporate changes as and when necessary.

Experience in using Data Stage Director to Validate, Run, and Schedule and Monitor Data Stage jobs and checking logs.

Extracted data from Oracle DRS databases, transformed data and loaded into Oracle data warehouse.

Created Data Stage jobs and Job sequences and tuned them for better performance.

Wrote complex SQL queries using joins, sub queries and correlated sub queries

Monitored system performance through UNIX.

Interacted closely with Business Analysts and BI developers to find out their requirements, designed the jobs accordingly, and assist with the dashboard creation.

Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.

Used the OBIEE 11.1.7 Administration tool to develop and enhance Meta data.

Worked extensively on OBIEE 11g Answers, Dashboards and Delivers to create reports.

Worked on Oracle 11g, PeopleSoft EPM databases.

Created mockup reports and dashboards for review by the business users.

Migrated repositories and catalogs from Development environment to QA and Production environments.

Created new Action Links in OBIEE 11g.

Involved in up gradations and Migrations in OBIEE.

Involved in creation of Aggregate tables in DataStage to increase the performance of OBIEE

Novo Nordisk Inc. Princeton, NJ Oct 2012 – Jan 2013

ETL/DataStage Developer

Novo Nordisk is a global healthcare company with 89 years of innovation and leadership in diabetes care. The scope of the project was to build a Data Warehouse for Aggregate Spend.

Hardware/Software: IBM Infosphere 8.1(Designer, Manager, Director), Windows XP, Unix Shell scripting, SQL Developer 8.1, Oracle 11g, UNIX, PL/SQL, TOAD, flat files, Putty, WinSCP, Siperian MDM.

Responsibilities:

Designed new ETL jobs as per the requirements to fetch the data from source and load it into the landing tables.

Designed jobs to run Siperian MDM batch Jobs that fetches data from the landing table and stores it into the staging table as well as into the Data Warehouse after the Match and merge process.

Worked closely with other team members to understand the Siperian Process and integrate it with the DataStage jobs.

Did thorough testing of the developed jobs and was also involved in Integration and System testing.

Used DataStage Director to schedule the jobs and also migrated the jobs from the development server to the production server successfully.

Developed jobs using Data Stage Designer as per the mapping specifications using appropriate stages.

Created Functional/Higher level document to document the business needs.

Created the quick books and naming standard documents for the ETL objects.

Created source to target mapping and job design documents from staging area to target area.

Worked on troubleshooting, performance tuning, performance monitoring and enhancement of Data Stage jobs.

Created test cases to test ETL jobs designs and documented the test results in the Excel and word document.

Provided production support and performed enhancement on existing multiple projects.

Houston Community College, Houston, TX _ Jan 2012 – July 2012

ETL/DataStage Developer

Houston community College System is a community college system that operates community colleges in Houston, Missouri City, and Stafford in Texas. The scope of the project is to build and maintain a Data Warehouse for the PeopleSoft EPM 9.1 Campus Solution and performance tune the ETL server jobs.

Hardware/Software: PeopleSoft EPM 9.1, IBM Websphere 8.1, Oracle 11g/10g, UNIX, PL/SQL, TOAD, WinSCP, Putty, Windows XP, Unix Shell scripting.

Responsibilities:

Designed new ETL jobs as per the requirements and did performance tuning of the existing server jobs.

Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database.

Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.

Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.

Prepared feature lists, technical documentation for source to target mapping procedures to facilitate better understanding of the process and incorporate changes as and when necessary.

Experience in using Data Stage Director to Validate, Run, and Schedule and Monitor Data Stage jobs and checking logs.

Extracted data from Oracle DRS databases, transformed data and loaded into Oracle data warehouse.

Created Data Stage jobs and Job sequences and tuned them for better performance.

Wrote complex SQL queries using joins, sub queries and correlated sub queries

Monitored system performance through UNIX.

Interacted closely with Business Analysts and BI developers to find out their requirements and designed the jobs accordingly.

Citibank, Mumbai, India July 2007 – July 2009

Oracle Developer

Citibank, a major international bank, offers standard banking transactions, insurance, credit cards and investment products and also online services division claiming about 15 million users. The scope of the project Strategic Decision Support System was to issue computerized registration of customer accounts and provide the management with complete transactional information of all types of accounts of their branches nationwide.

Responsibilities:

Involved in analysis, requirements gathering, functional/technical specification, development, deployment and testing.

Created simple, complex joins, calculated items and conditions. Developed packages, procedures and functions in PL/SQL for data loading and data processing.

Wrote SQL*Loader scripts and UNIX scripts to format, load data from text files to database.

Developed UNIX scripts for File formats archives, transfers and procedure execution.

Developed Views for users. Wrote database triggers for audit and data validation.

Investigation of production problems and bug fixing. Maintenance and enhancements to the application.

Supported post implementation of the project.

Environment: Oracle 9i, PL/SQL, UNIX Shell Scripts.

Contact this candidate