Mid Level experience in IT industry, spanning across areas like Data Architecture, Data Analyzing, Data Warehousing, design, development and Implementation of Business Analytics solution using Data Warehouse Design, ETL and Web Applications on Windows.
*More than year of experience in IT industry, spanning across areas like Mainframes installation, up gradation and configuration.
Data Warehousing experience using Informatica Power Center 9.0/8.6/8.1.1
Full development lifecycle from requirement gathering through development and support.
Well versed with Dimensional/Relational Data Modeling to design and develop Star/Snowflake schema, Fact and Dimension tables, Physical and logical data modeling using Erwin and Visio
Expertise in Extraction, Transformation and loading data into Enterprise Data Warehouse (EDW) and Operational Data Store (ODS) using ETL operations
Proficient in writing and using SQL queries, SQL * Loader, Stored Procedures, Triggers, Materialized Views, Indexes, Cursors, Partitioning, Exception handling and Optimization Tuning . DW/ETL Tools: Informatica 8.1/8.6/9.0
Data Modeling Tools: Microsoft Visio, Erwin 4.0
Reporting Tools: Cognos 8.4/10, SSRS
Databases: Oracle 9i/10g/11g, SQL Server 2000, IBM DB2
Operating Systems: UNIX, Virtual Operating Systems, Windows 2000/XP/Vista/7
01/2011 to Current
Data Warehouse DeveloperDeloitte Consulting LLP – Harrisburg, PA
Home and Community Services Information System (HCSIS): Enterprise Data Warehouse (EDW) Designed the logical data model and physical data model for the enhancement purpose as per the client requirements for EDW.
Extensively involved in the requirements gathering process and analyzed the functional specs provided and created technical specs documents for all the ETL related process.
Work closely with BA and Application developers to understand the source data, application structure to develop and create data warehouse process which is consistent with the application screens.
During maintenance release by implementing the severity level ranking method based on business impact documentation helped Clients decide the order of bug fix list which avoids over committing and helps concentrate on quality of deliverables.
Directly working with BTAs to contrivance a delivery proposal including LOE estimate and release plan helped get signoff from the stake holders without much of deviations in the original plan.
Analyzed Program Change Request(PCR) related to ETL and Cognos reports as per requests from client and approve/implement the request.
Developed ETL strategy based on the data model design and different subject areas which conformed to the set of business requirements.
Modified existing data models to suit changing requirements.
Developed various Sources to Stage and Stage to Target Informatica process using Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
Coded Oracle SQL and PL/SQL to implement business logic.
Used Debugger by making use of breakpoints to monitor data movement, identified and fixed the bugs.
Ensured the deliverables are compliant with enterprise data architecture standards.
Schedule the session tasks comprising of different mappings for data conversion and extraction in order to load data into target database.
Migrated mappings, sessions and workflows from Development to testing and then to Production Environments.
Run Monthly EDW workflow in Production, troubleshoot session failures, and validate the data in Production.
Monitor, schedule, and troubleshoot batches and sessions for weekly and daily extracts from various data sources across all platforms to the Target database.
Involved in the maintenance process by changing and updating of the existing EDW and ODS complex mappings, sessions and workflows.
Created Data Dictionary, EDW Stage load to Target Load process documents.
Worked closely with managers to evaluate the overall project timeline.
Actively contributed in framing the Data Warehouse SDLC standards, methodologies and best practices.
Used Informatica features to implement Type II changes in slowly changing dimension tables.
Worked on creating database triggers, functions, database constraints and indexes.
Made performance improvements to database by building partitioned tables, Index organized tables, bitmap indexes and by creating materialized views on tables.
Developed shell scripts for Informatica pre-session and post-session scripts.
Worked with DBA's to consistently improve the overall performance of the data warehouse process and to debug the oracle errors.
Production support for Weekly, Monthly, Quarterly jobs.
Created reports in Cognos and performed extensive testing in Cognos for dashboard reporting, Ad Hoc reporting, and cube reporting.
HCSIS: Operational Data Store (ODS) Gathered requirements from the end users.
Analyzed the functional specs provided and created technical documents for all the ETL.
Worked along with Data Warehouse Architect and DBA's to design the ODS data model for reporting purposes.
Transformed the business requirements to system/data requirements.
Design and published the logical data model and system context diagram.
Defined Data Mapping rules and data transformation rules.
Performed all data validation and data reconciliation tasks.
Designed and developed new data models for reporting purposes.
Designed the database tables and constraints using data modeling techniques using Erwin.
Used various kinds of transformations to create robust mappings in the Informatica Designer to implement simple and complex business logic.
Implemented mapplets and reusable transformations to prevent redundancy of transformation usage and maintainability.
Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
Created Stored procedures for data transformation purposes.
Performed folder level migration from development to testing environment on ODS folders.
Monitor, schedule, and troubleshoot batches and sessions for daily extracts from various data sources across all platforms to the Target database.
Involved in the maintenance process by changing and updating of the existing ODS complex mappings, sessions and workflows.
Used session parameters, mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
Deployment steps document I created is used as a the nucleus for the deployment playbook across all projects to unify migration process from Development to Testing and Production environments.
Concise resource allocation plan and cost estimation allowed carefully and effectively utilize resource and investment without over running time and estimate.
Wrote complex SQL which in turn help to thoroughly test the mapping logics.
Provide production support for daily jobs Created Integration, UAT testing scenarios.
Performed regression and unit testing.
Enterprise Incident Management (EIM) Worked parallel with EIM application team and Data architect to create logical and physical data model as per the client requirements.
Responsible for Data Analysis of Source Systems (legacy systems) for ETL initiative.
Analyzed the source data coming from Oracle, XML, Flat files, Excel files and worked with business users and developers to develop the model Designed and published the conceptual data model.
Created complex mappings to load data from XML source to target tables in EDW.
Created source to target mapping document, Integration testing scenario document and Cognos Ad Hoc reporting document.
Mapplets and Reusable transformation created to prevent redundancy of transformation usage and maintainability.
Created parameter file for database connections and for incremental load.
Monitor, schedule, and troubleshoot batches and sessions in production.
Pre- K Counts DW Responsible for Data Analysis of Source Systems for ETL initiative.
Interacted with PRE-K program office to get requirements to provide accurately and monitor and control locations providing Pre-K.
Developed and created report to help analyze risk of academic failure.
Developed a system to help clients to monitor child enrollment and development with the help of a classrooms and curriculums offered within the program.
Developed Extract and backup mappings using Informatica Designer Developed Validation scripts to ensure the correct data load in the system Used OLAP dimensional modeling for multidimensional analysis of business data to develop fact and dimension tables and generated data for reporting purposes.
07/2007 to 07/2008
Associate System AnalystNational Stock Exchange IT – Mumbai, India
National Stock Exchange – Mumbai, India
Monitoring and performing daily test on the Status Mainframes performances.
Also was responsible in validate, provide the archive data set details to co-responding developer base on request.
Installed, upgraded and configured the new and old Stratus Systems and performed testing in lower development environment before upgrading the system in Production.
Provided training to the new analysts about the systems, and monitoring process.
Applied bug fixes on the existing issues.
Provided migration support to backup the data from the production systems to Backup Servers located in different state.
M.S: Computer Science New Jersey Institute of Technology - Newark, NJ Computer Science
B.S: Electronics and Telecommunication Don Bosco Institute Of Technology - Mumbai Electronics and Telecommunication