SUMMARY

• Over 12 years of professional experience in Information Technology with a focus in Telecom, Pharmaceutical, Healthcare, Finance and Commercial industries including around 10 years in implementing, designing and developing Data Warehouse applications.
• Excel at leading diverse, cross - functional teams through all project life cycle phases.
• Good knowledge with all the evolving new technologies including Big Data, Hadoop Hortonworks, Amazon WebServices, Redhsift, Netezza, etc.
• Extensive experience with PL/SQL programming, packages, stored procedures, functions, triggers.
• Strong understanding of the Oracle Architecture and the design and implementation of Slowly Changing, and Confirmed Dimensions and Star and Snowflake Schemas.
• Extensive experience in automation of Data Extraction, Data Mapping, Data Loading and Data Migration from Oracle, MS SQL Server and Flat files to Oracle, Amazon Redshift, HDFS and other environments.
• Experience in job automation, scheduling, QC, debugging and error reporting techniques in UNIX environment.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and process excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Excellent written and communication skills, ability to work independently and as a team.
• Experience in working and Handling the offshore team on day to day activities.
• Functioned as Team Lead, Senior Data Warehouse Consultant and ETL/Informatica Developer.
• Extensive experience in all phases of SDLC, system setup and testing, designing customer interfaces with external systems.
• Extensively worked with Netezza database to implement data cleanup, performance tuning techniques.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6, 9.1, 8.5, 8.1, 7.1, 6.2, Datastage

Frameworks: Hadoop Hortonworks

Database: ORACLE 11g/10g/9i /8i, AWS Redshift, Netezza, HAWQ, Postgres, Teradata, MS SQL Server 2005/2000, DB2.

DB Tools: SQL-TOAD, PL/SQL Developer, SQL*PLUS, SQL* Loader.

Data Replication: Attunity, Golden Gate.

Data Virtualization: Denodo 5.

Reporting Tools: Tableau, Cognos 8, Siebel Analytics, Crystal Reports.

Data Modeling: MS Visio Standard 5.0, ERWIN 4.1.

Scheduling Tools: Appworx, Tivoli Maestro, Siebel DAC, Control M.

Web Designing Languages: HTML, DHTML, XML and JavaScript

Operating Systems: Windows XP, Windows 2003 Server, AIX 6.1, HP UX 11i/10.20.

Programming Languages: SQL, PL/SQL, NoSQL,Postgres, Hive, PIG, VB 6.0, Java, Python.

Other Tools: Oracle Migration Workbench, ODI, Informatica MetaData Manager, PowerConnector, Power Exchange, JSM, Kafka.

Encryption/Decryption Tools: GPG 1.4, PGP 6.5.

Methodology: Agile

PROFESSIONAL EXPERIENCE

Confidential, Bethpage, NY

Lead/Senior Data Warehouse Consultant

Responsibilities:

• Analyzed business and System Requirements and completed Impact Analysis on existing systems and developed functional and technical specification documents.
• As a Team Lead, interacted with customers and different teams during requirement gathering, system designing and system integration.
• Creation of detailed project outlines and documenting the codes, scripts and unit testing. Involved in brain storming sessions through daily scheduled meeting and weekly status meetings.
• Participated in the installation of software’s like Informatica tools, database tools, and also involved in managing/assigning the users privileges to the Informatica folders.
• Extensively used Informatica command line scripts to update folder permissions, export folders, update relational connections and to schedule workflows.
• Automated many Administrative task by using shell scripts like creating new user accounts, creating development folders, cleaning up the cache directory, session/workflow logs.
• Lead the development team during the development processes includes - reviewing the code, migration of code to different stages of business lifecycle and knowledge transfer.
• Designed and developed Informatica mappings, creating sessions and workflows for Data Loads.
• Developed the design documents for ETL processes, defining the transformations and join conditions, which helped the users to better understand the type of data.
• Have Experience in designing and developing UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data between different servers.
• Hands on experience in implementing the Netezza stored procedures to load data from Oracle and Flat files into the Netezza Data Warehouse.
• Worked with NZLoad to load data from Flatfiles to Netezza Database.
• Played a key role in implementing and migrating Audience Measurements code/data into Redshift Database from Netezza Database using Unix shell scripting.
• Implemented Monitoring Framework for Daily Quality checks and Metrics in PostGres Database.
• Involved & developed Omniture project to load large amount of Big Data files using Hadoop Hortonworks with Hive and PIG programming.
• Big data unstructured files are stored in HBase which is a NOSQL database and sqooped data to other SQL databases for analysis and investigations.
• Tuned SQL queries and mappings for better performance. Performance tuning of the Informatica mapping using various components like parameter files, variables and dynamic cache.
• Used different techniques of Table partitions, exchange partitions at the database level and parallelism in Informatica. Used explain plan, gather statistics, different types of indexing.
• Developed PL/SQL procedures, functions using Dynamic SQL, PL/SQL tables, BULK Load features.
• Extensively used SQL overrides and substituted them in the place of multiple transformations. Designed and developed Target Warehouse Entity for Oracle using Power Center 9.1/8.5/8.1. Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Maintained existing mappings by resolving performance issues using tuning techniques such as load balancing and SQL tuning to improve performance.
• Developed ETL and scheduling processes, Batch file control and restart, Error handling and File transfer that featured the ability to store current and historical data in customer and product dimensions, the ability to store process time stamps and capture error messages for each subject area.
• Developed generalized PL/SQL procedures, Oracle Table Functions, External Tables, Dynamic SQL and Packages to process data and perform validations and calculations on data loaded in an application database.
• Applied Business Rules and Validations Scripts in the Migration/Integration of data.
• Extensive use of Shell & Perl scripts to generate log files and task scheduling and error reporting by connecting to the databases through scripts.
• Extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs

Environment: Informatica Power Center 9.1/8.5/8.1, MetaData Manager, PowerExchange, HP UX 11i, Oracle 11g/10g/9i, Netezza, Redshift, HAWQ, Hive, PIG, HBase,Kafka, HortonWorks, Denodo, Attunity, Golden Gate, MS Access, MS SQL Server, SQL, PL/SQL, MS Visio, TOAD 8.x/9.x., Toad Datapoint, Tableau, windows/shell Scripting, Python.

Confidential, Wayne, NJ

Team Lead/Senior Data Warehouse Consultant

Responsibilities:

• Analyzed business and System Requirements and completed Impact Analysis on existing systems and developed functional and technical specification documents.
• Creation of detailed project outlines and documenting the codes, scripts and unit testing. Involved in brain storming sessions through daily scheduled meeting and weekly status meetings.
• Designed and developed Informatica mappings, creating sessions and workflows for Data Loads. Developed the design documents for ETL processes, defining the transformations and join conditions, which helped the users to better understand the type of data.
• Tuned SQL queries and mappings for better performance. Performance tuning of the Informatica mapping using various components like parameter files, variables and dynamic cache.
• Used different techniques of Table partitions, exchange partitions at the database level and parallelism in Informatica. Used explain plan, gather statistics, different types of indexing.
• Developed PL/SQL procedures, functions using Dynamic SQL, PL/SQL tables, BULK Load features.
• Responsible for creating metadata tables and processes for automating QC processes.
• Developed generalized PL/SQL procedures, Oracle Table Functions, External Tables, Dynamic SQL and Packages to process data and perform validations and calculations on data loaded in an application database.
• Applied Business Rules and Validations Scripts in the Migration/Integration of data.
• Extensive use of Shell & Perl scripts to generate log files and task scheduling and error reporting by connecting to the databases through scripts.
• Created CRON JOB files to sequentially schedule batch processing for the project from a UNIX shell.

Environment: Informatica Power Center 8.5/8.1, PowerExchange, HP UX 11i, Oracle 10g/9i, MS Access, SQL, PL/SQL, Erwin 4.1, TOAD 8.x/9.x., Business Objects, Visual Basic, windows/shell Scripting, Perl.

Confidential, Nutley, NJ

Senior Data Warehouse Consultant

Responsibilities:

• Actively involved in System Development Life Cycle phases to design, build, test and implement ETL process.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Extensively used transformations like Joiner, Expressions, Aggregator, Stored Procedure, Lookup and Filter.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Proficient in SQL, PL/SQL, Procedures/Functions, Triggers and Packages.
• Involved in implementing product and territory hierarchies and establish master tables which includes cross references to map different data sources and maintain current and “as is” customer data integration processes to provide cleansed Prescriber-Level data
• Created various UNIX shell scripts for scheduling various data cleansing scripts and loading scripts. Maintained batch processes using UNIX Shell Scripts.

Environment: Informatica Power Center 8.5/8.1, PowerExchange, HP UX 11i, Oracle 10g/9i, MS SQL Server 2005, SQL, PL/SQL, Erwin 4.1, TOAD 8.x/9.x. windows/shell Scripting

Confidential, Sacramento, CA

Senior Data Warehouse Consultant

Responsibilities:

• Developed ETL procedures to translate business rules and functionality requirements into business logic; ensuring lack of redundancy and compliance with standards.
• Wrote pre-session Shell Scripts to check session mode (enable/disable) before running/ schedule batches. Used pmcmd command in the windows batch files.
• Wrote UNIX scripts to format the data and schedule jobs using UNIX Cron.
• Performed database tuning, analyzed queries, Explained plan on queries and created bitmap indexes and B-Tree indexes on appropriate columns.
• Populated various measures for annual sales data across the period dimension.
• Wrote SQL, PL/SQL stored procedures, packages and triggers.
• Extensively involved in creating a stored procedure for the Period table that can be run annually with various measures that help reconcile with existing processes such as quarter and trimester values.
• Implemented Change Data Capture at the database level using the database Triggers.
• Performance and fine tuning of SQL & PL/SQL stored procedures. Did performance tuning on development/production databases.

Environment: Informatica Power center 7.1, Oracle 9i, MS SQL Server 2000, PL/SQL, UNIX, SQL*Plus, Windows2003

Confidential, Lutherans, WI

Informatica Consultant

Responsibilities:

• Developed ETL mappings, Transformations using Informatica Power Center.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Created, launched & scheduled sessions.
• Involved in the Performance Tuning of Database and Informatica.
• Setting up Workflow, Tasks, Worklets and sessions to schedule the loads at required frequency using Power Center Server manager/Workflow manager.

Environment: Informatica-Power Center 7.1, Oracle, SQL* Plus, PL/SQL, Teradata, MS SQL Server 2000, Windows and UNIX.

Confidential, NY

Data Warehouse Developer

Responsibilities:

• Analyzed and studied various Schemas for implementation.
• Interacted with business users for requirements gathering.
• Modeled the Data Warehousing Data marts using Star Schema.
• Extracted data form flat files and Oracle database, applied business logic to load them in the central Oracle database.
• Extensively used PL/SQL Packages/Procedures/Functions to build business rules.
• Used SQL* Loader and External Tables to load flat files into staging.

Environment: Oracle/8i, Flat files, SQL, PL/SQL, Win 2000/NT, UNIX.