Professional summary:

• Over8years of total IT Experience in ETL Processing, Analysis, Design, Development, and Coding by using various technologies like Informatica PowerCenter,Oracle Data Integrator, Oracle Business Intelligence, Crystal Report/Cognos reporting tools in the area of Data Warehousing
• Extensively worked with Erwin, Object Oriented Analysis and Design OOAD , Unified Modeling Language UML , Design Patterns and Visio for data modeling and creating dimensions/fact tables in Star Join Schema/Snow Flake Schema
• Proficient in software development life cycle SDLC process, Software Testing Life cycle STLC process and Project Life cycle in various phases along with Change management and Service requests process implementation
• Excellent working knowledge of Ralph Kimball and/or Bill Inman Methodologies for building DWH and BI environments
• Extensive experience in providing end to end BI solutions configuring Star schema design, Fact and Dimensions tables, Physical and logical data modeling in OBIEE 11g
• Expertise in OBIEE 11.1.1.7.0, providing end-to-end solutions by dimensional modeling design, building business models, configuring metadata, creating reports and using dashboards
• Expertise in designing, development and testing of ETL methodology for supporting data transformations in Informatica Power Center 9.1/8.x/7.x
• Trained in Oracle Data Integrator 11gDesigner, Creating Projects, Creating Models, Reverse engineering the data-stores metadata from Database, developing ODI Interfaces, developing ODI Procedures
• WrittenPL/SQL Objects like stored procedures/functions, triggers, packages, Sequences, Materialized views and Cursors
• Strong work experience in Data Mart life cycle development
• Evaluate all functional requirements and map documents and perform troubleshoot on all development processes from OLTP to OLAP development process. Also did gap analysis for tight integration.
• Documenting all the required artifacts like technical specs,source to target mappings, Deployment documents, Support run books, change request formsand all other associated project deliverables
• Created and Configured mappings to implement Slowly Changing Dimensions Type-1 2 for dim/fact load ordering
• Assist in business requirements gathering process, including working with endusers to interpret functional requirements into technical specifications and solutions.
• Worked on Enhancements and performance tuning of existing scripts/mappings/jobs.
• Experienced at creating effective test data and development thorough unit test cases to ensure successful execution of the data
• Strong analytical, problem-solving, organizational, communication, learning and team skills. Quick in learning new tools and technologies.

Technical Skill Set:

Professional Experience:

Confidential

ETL/OBIEE Developer

Roles Responsibilities:

• Implemented snapshot logic to take monthly snapshots of the fact and dimension tables and load them to the datasets for OBIEE subject area
• Implemented initial/historical data full loading and incremental loading for daily/weekly/monthly jobs run
• Design and development of change data capture CDC process using time-stamping method
• Created PL/SQL Packages to drop and recreate the indexes in the target data warehouse before and after the sessions used in stored procedure transformation in Informatica mappings to implement bulk loading option
• Created model for error handling, exceptions and re-start ability logic in mappings for failed sessions to be rerun automatically without any modifications of implemented code in production. Also deployed code from DEV to SIT/UAT environments.
• Performed the PerformanceTuning of Dashboards and Reports
• Optimized Lookup SQL/source qualifier queries in order to reduce lookup cache size and to enforce change capture of source data for daily processing with minimum session run times
• Responsible for coordinating development and testing efforts with business users
• Developed metadata repositoryand configured metadata objects in all three layers using OracleBIAdministrationtool
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts
• Created Informatica mappings/sessions/workflows along with proper comments documented in code
• Understanding of processes involving data modeling and building data marts for type 1 2 dimensions and facts. Creating source to target mappings designs, test strategy etc.
• Reviewed peers codes and Unit/Integration testing of Informatica mappings/sessions
• Test and Validate data and Migrated the code into UAT and Production

Environment: Informatica PowerCenter 9.1/8.6, Oracle 11g/10g, Oracle Business Intelligence 11.1.1.7, TOAD, XML Spy, MS Office Suite, SQL Developer, PL/SQL, QC

Confidential

ETL/OBIEE Developer

Roles Responsibilities:

• Instrumental in understanding of processes involving data modeling and building data marts for type 1 2 dimensions and facts. Creating high level documents like Tech design, Sizing document, source to target mappings, test strategy etc.
• Created Informatica mappings/sessions/workflows along with proper comments documented in code
• Built slowly changing dimension for address for the employee dimension and customer dimension
• Developed OBIEE reports/dashboards with different analytics views Pivot Table, Chart, Column and View Selector and Tabular with prompts, global and local Filters
• Modified Metadata Logical definitions in Analytics Repository using OBIEE Administration Tool
• Worked with end users to identify, create, and deliver reports according to requirements
• Responsible for coordinating development and testing efforts with offshore team members and on site business users
• Optimized Lookup SQL/source qualifier queries in order to reduce lookup cache size and to enforce change capture of source data for daily processing with minimum session run times
• Worked with heterogeneous sources including XML, flat files and SQL Server sources
• Created model for error handling, exceptions and re-start ability logic in mappings for failed sessions to be rerun automatically without any modifications of implemented code in production. Also deployed code from dev to SIT/UAT environments.
• Created PL/SQL Packages to drop and recreate the indexes in the target data warehouse before and after the sessions used in stored procedure transformation in Informatica mappings to implement bulk loading option
• Design and development of change data capture CDC process using time-stamping method
• Implemented initial/historical data full loading and incremental loading for daily/weekly/monthly jobs run
• Identified bottlenecks and fixed them in Informatica mappings and sessions for better performance. Also optimized PL/SQL code in Oracle using explain plan to avoid full table scans, created indexes and used Oracle hints.
• Used command line program pmcmd to interact with Informatica PowerCenter server to start and stop sessions/workflows and batches and recover the sessions from Unix scripts as well from trigger files
• Reviewed peers codes and Unit/Integration testing of Informatica mappings/sessions, PL/SQL packages and schedules timings
• Responsible for production support for modules developed and deployed in to production environment for first month.

Environment: Informatica PowerCenter 9.1/8.6, Oracle 11g/10g, OBIEE 11g, AIX-Unix, TOAD, SQL Developer, PL/SQL, QC, SQL Server 2008

Confidential

ETL Developer

Roles Responsibilities:

• Identified and created mappings for different source definitions to extract data from input source feeds and load into relational tables staging/integration/data marts layer using Informatica PowerCenter.
• Extensively worked and collaborated with off shore teams used ETL to load data from RDBMS, flat files to Oracle.
• Provided Knowledge Transfer's at all levels and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings
• Responsible for getting approvals for change requests from senior managers to deploy code from one environment to other
• Accountable for delivery and status reports on each assigned projects and also conducted interviews with internal clients to pinpoint the problems in existing solutions. Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Adhoc Reports request queries for internal clients. Designed and created job schedules using JIL files for Autosys

Environment:Informatica PowerCenter 8.6/8.5, Oracle 11g/10g, DB2 UDB Control Center, SQL Server 2008, Windows XP, SQL Plus/SQL Developer, AIX/UNIX, MS-VSS, Autosys, MS Office suite, QC, Erwin 8/7

Confidential

PL/SQL ETL Developer

Roles Responsibilities:

• Contributed in writing the Technical Specifications Documents and requirement gathering from dealer's representatives.
• Created utility and ETL packages using PL/SQL in Oracle loading data from different feeds like dealer sources, campaign events conducted in various locations from Sources like SQL Server, Oracle and Flat files.
• Integration of Different ETL process like Data Merging, Data Cleansing, Data source sync and Data Aggregation.
• Created ad-hoc SQL Queries for different reports daily and weekly basis alongside with development
• Code review with peers to enhance execution times and fixing bugs/add new functionality in existing procs/funcs in packages
• Extensively Unit tested codes of mine and other peers by doing like Quantitative Testing and Qualitative Testing
• Migrated code from Development to SIT/UAT and then Production Environment

Environment:Oracle 11g/10g, SQL Server 2008, Windows XP, SQL Plus/SQL Developer, TOAD, AIX/UNIX, SVN, Autosys, MS Office suite, Visio, JIRA

Confidential

Software Developer

Roles Responsibilities:

• Involved in the planning, designing, implementation and documentation of the project.
• Involved in the development of the presentation-tier Windows Forms using VB.NET.
• Involved in the development of the middle-tier reusable, scalable components using VB.NET.
• Used ODBC.NET to connect to the IBM DB2 database from the middle-tier .NET components.
• Creating and managing IBM DB2 databases involving privileges, quota management, taking backups and recovering databases
• Implemented Asynchronous Logging and Exceptions Handling services. Created reports using Crystal Reports

Environment: VB.Net, IBM DB2, .Net Crystal Reports

Roles Responsibilities:

• Programmed the Kofax Capture system to read the TFSA scans
• Involved in testing the Kofax Capture's OCR for data capture

Environment: Kofax Capture 8.0, VB, IBM Content Manager

Confidential

Roles Responsibilities:

• Involved in the planning, designing implementation of the project.
• Involved in the client side development using C .
• Involved in the development of the middle-tier reusable, scalable components using C .

Environment: C , Win Server 2003, Red Hat Linux

Confidential

Android Application

Responsibilities:

• Involved in the planning, designing implementation of the project
• Involved in the design and development of the GUI for the App.
• Implemented Bouncy Castle Crypto API to encrypt/decrypt the passwords and user data using 128bit AES encryption

Technologies Used:Android 2.1, SQLite, Windows 7, Eclipse Subversive SVN