SUMMARY:

• Over 10 years of IT experience in Application Design, Data Modeling, Application Development, Data Analysis, Implementations and Testing of Applications in Data Warehousing as different segments in SDLC and more TEMPthan 9 Years of experience in DW.
• Experience working on Amazon Redshift and Big Data technologies for teh past year and half.
• Hands on implementing teh cloud solution by moving all teh historical data to teh cloud and implementing Data pipeline for teh incremental high volume data processing.
• Maintained outstanding relationship with Developers, Business Analysts and Business Users to identify information needs as per business requirements.
• Extensive Data Warehouse experience using Informatica PowerMart / PowerCenter v 7.1, 8.1 as ETL tool on Oracle, SQL Server and DB2 Databases and other Informatica components Power Exchange, PowerConnect, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administration Console Data Quality and Data Explorer.
• Configured teh Real time option using Power exchange along with Informatica
• Having strong skills in Administration, Designing, Coding, Development, and Implementation of Business Applications with Web - enabled, three tier and Client/Server environment using Informatica, on UNIX and Windows Platforms.
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
• Worked on Data conversion and migration projects.
• Involved in migrating teh projects using Informatica to higher versions of Informatica.
• Involved in developing Logical and Physical Models using Erwin 3.5/4.0 Designer.
• Tuned SQL queries and performed refinement of teh database design leading to significant improvement in system response time and efficiency.
• Experience in creating and using PL/SQL Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in databases.
• Implemented performance-tuning techniques at application, database and system levels.
• Strong noledge on Project & Change Management, SDLC and System Analysis & Design.
• Good noledge and experience in Shell Scripts.
• Used teh scheduling tool Autosys for automating teh process.
• Good exposure to development, testing, debugging, implementation, documentation, and production support.
• Motivating team player with outstanding Organizational and Inter-personal Skills
• Developed complex SQL queries and PL/SQL packages.
• Involved in Setting up teh whole environment for teh development of ETL.

TECHNICAL SKILLS:

Database: Oracle10g/9i/8i, MS SQL Server 2000, Teradata, DB2

ETL Tools: Informatica PowerCenter 7.1.2, 8.1, 8.5, 9.0 Informatica Power Exchange, Data Quality and Data Explorer.

Languages: SQL, PL/SQL, XML Python, Java, Hive

Data Modeling: Erwin 3.5/4.0, MS Visio

Packages: Siebel DAC, MS Team Foundation Server

Scripting: UNIX Shell scripting, VB script

Reporting Tools: Webfocus, MicroStrategy

PROFESSIONAL EXPERIENCE:

Confidential, CA

Migration Lead

Responsibilities:

• Efficiently migrated all teh on premise data from Pl/SQL databases to Amazon redshift using Java, Shell script and Hadoop methodologies.
• Built a framework to validate all teh data between Redshift data base and teh on premise data base ParAccel.
• Developed data pipelines to process teh data from teh source systems(API’s, files on FTP server) directly into Redshift database.
• Scheduled teh data pipelines using cron Jobs to run at regular interval of time.
• Designed teh DB architecture and teh security model.
• Designed teh summary and teh TD tables for efficient reporting in Tableau.
• Fine-tuned teh reports dat are running slow.
• Worked on teh design of building teh combined system Architecture.

Environment: Python, Java, Amazon Redshift, S3, Hadoop, Pig Hive, Amazon EC2, Data pipeline.

Confidential, CA

Technical Architect

Responsibilities:

• Migrated all teh on premise data from sql server, oracle, MySQL and db2 databases to Amazon redshift using python, Attunity tool on Amazon EC2 instance.
• Built a framework to validate all teh data between Redshift data base and teh on premise data sources.
• Built a mechanism to sync teh sql server on premise data and teh Redshift DB on Amazon.
• Developed data pipelines to process teh data from teh source systems(API’s, files on FTP server) directly into Redshift database.
• Scheduled teh data pipelines using cron Jobs to run at regular interval of time.
• Successfully resized teh clusters from 16TB to 32 TB in quick time.

Environment: Python, Java, Amazon Redshift, S3, Glacier, Hadoop, Pig Hive, Attunity, Amazon EC2, Data pipeline.

Confidential, CA

Technical Architect

Responsibilities:

• Analysis of requirements and designing teh new global integrated reporting systems.
• Involved in reducing teh dependencies on multiple systems to pull teh metadata so as to reduce teh chances of errors.
• Designed teh ETL framework to process multiple files from different partners and load into DW with different audit tables and checks in place.
• Designed teh framework to trigger teh reports once teh ETL jobs completes.
• Coordinating with MSTR/reporting team to understand teh tool capabilities and provide teh optimal solution.
• Proposed solution for critical business logic to meet teh needs.
• Involved in setting up teh complete process from development to production migration.
• Worked on integrating teh data from external systems post acquisitions.
• Involved in setting up teh process to support teh system post production.

Environment: Informatica Power Center 9.0, SQL Server, Oracle, Perl.

Confidential, CA

Migration Team Lead

Responsibilities:

• Analysis of all teh existing systems and teh functionality
• Creating teh equivalent tables and objects in Netezza database
• Leading teh team to Migrate teh code to support Pushdown Optimization
• Find how to achieve teh same logic as teh existing system
• Review teh test case presented by teh team
• Help teh team to implement in Re-Architecting certain scenarios
• Provide teh Migration check list documents to teh team
• Review teh issues raised in teh issue logs.
• Coordinating teh parallel run and support UAT
• Migration of teh whole code to teh production.

Environment: Informatica Power Center 9.0, SQL, NZPLSQL, Netezza, FITS, Aginity, Linux, Teradata, Oracle, and DB2

Confidential, Torrance, CA

Sr. Informatica Architect / Team Lead / Netezza Developer

Responsibilities:

• Analyzed of all teh sources and designing teh LDM, PDM of teh DataMart
• Created teh source to target mapping document.
• Reviewed teh stored procedures developed.
• Reviewed teh Informatica code.
• Designed teh automation part of teh whole process.
• Reviewed teh test cases for teh whole Datamart.
• Prepared Production deployment documents and checklists.
• Coordinated with teh offshore team for teh whole cycle of teh project.

Environment: Informatica PowerCenter 8.6, SQL, NZPLSQL, Netezza, Mercury Quality Centre, Aginity

Confidential, CA

Sr. Informatica Architect / Team Lead

Responsibilities:

• Installed all teh components related to Siebel Warehouse development. Components include Informatica 7.1.2. Siebel Analytics Packages.
• Created Database Objects like Tables, Views, Partitions and Indexes.
• Involved in creation of PL/SQL Packages, Functions and Stored Procedures using Dynamic SQL and handled exceptions.
• Created Indexes and table partitions to fine tune teh performance of SQL Queries.
• Created a customized process for teh customer profitability analysis.
• Performed QA for teh mappings developed and prepared testing documents.
• Loaded data in to XML Targets using different transformations and mappings according to teh requirement.
• Coordinated with teh Onsite/offshore team during teh whole life cycle of teh Project.
• Prepared all teh documents related to teh Project.
• Created Unix Shell Scripts for automating teh execution process and to execute post production jobs.
• Involved in teh performance tuning of teh various jobs.
• Handled huge POS data on Teradata data base.
• Implemented Real-Time option using Power Exchange with Informatica for teh real time interfaces required

Confidential, CA

Migration Team Lead/Administrator

New Environment: Informatica 8.5.1, Microsoft Windows 2003(64 bit), Microsoft SQL Server, Common Share SAN-Drive

Roles & Responsibilities:

• Installed all teh components (Informatica Power center 8.5.1 Server, Client) related to Informatica.
• Set up three different environments for Development, QA and production and installed all teh software’s on teh servers.
• Coordinated with teh DBA’s for teh repository data bases to be created.
• Converted all teh UNIX scripts, VB scripts according to teh new environment with teh help of teh Offshore Team.
• Took back up of teh repositories on teh old Informatica Server, Importing teh repositories to teh new version 8.5.1 and Upgrading to it.
• Attended weekly meetings to review teh status of teh upgrade.
• Installed Power Exchange using teh Real Time option, enabling teh Log miner options with teh help of DBA’s and setting up teh whole environment for a particular project dat requires teh real time option.
• Allocated tasks to teh offshore team in testing teh whole new environment and getting teh status every day.
• Coordinated with teh Informatica Technical support to get teh issues resolved and applying teh patches provided by teh Support team.
• Migrated all teh Code from Development to QA and then Production phase by phase
• Supported teh Production support teams in fixing teh issues.
• Created New Users and assigning teh roles and responsibilities and folders in teh new Environment
• Documented teh whole work related to teh Installation.

Environment: Power Center 8.5.1, PL/SQL, SQL, Unix with Oracle, Oracle 10g, SQL Server 2005, Siebel DAC, Informatica Power Exchange

Confidential, CA

Sr. Informatica Designer / Developer

Responsibilities:

• Extraction, transformation and loading of data from various source system to Siebel Application were performed on daily, monthly basis
• Loaded teh data in to XML Targets for Application team usage.
• Created a complex release assignment mapplet to be used for various Processes like Invoices, Orders and POS data Load.
• Extensively used teh Power Center client tools Designer, Workflow Manager, and Workflow Monitor.
• Involved in Unit and Integration Testing of Informatica Mappings and sessions.
• Prepared program specifications for PL/SQL Procedures and Functions to do teh conversion.
• Involved in Technical Documentation, Unit test, Integration test and writing teh Test plan.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, and Records.
• Scheduled workflows and sessions depend on client requirement.
• Created Dimension models by defining teh relationships and cardinalities between different entities in Erwin.
• Assisted DBA in creating teh Physical data model.
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting teh proceedings.
• Created UNIX scripts to be called by Autosys for scheduling teh jobs.
• Profiled and cleansed teh data from different source systems using informatica Data Explorer and Data Quality.

Environment: Informatica PowerMart/PowerCenter 8.1,Informatica Data Quality and Data Explorer PL/SQL, Unix with Oracle, MS-SQL, Oracle 10g, DB2, Flat files, Autosys

Confidential

Informatica Developer

Responsibilities:

• Involved in data modeling and design of teh whole system.
• Extracted data from sources including Oracle and Field width and Delimited Flat files and Loaded into DB2
• Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy
• Transformed teh data to integrate with teh business requirements.
• Handled operating system tasks by generating Pre and Post-session UNIX shell scripts.
• Involved in optimizing teh performance by eliminating target, source, mapping and session bottlenecks.
• Created ad hoc queries from teh database using SQL to provide information to teh business units.
• Used Autosys tool to schedule sessions and batches via Shell Scripts.
• Analyzed data loads, coordinated teh changes for proper data transition, and adhered to quality standards.
• Testing teh interfaces by writing different test cases
• Preparation of Production deployment documents and checklists.
• Reporting teh data errors.

Environment: Informatica PowerMart/PowerCenter 7.1, PL/SQL, Unix with Oracle, Oracle 8i, DB2, Autosys

Confidential, Irvine, CA

Informatica Developer

Responsibilities:

• Developed teh mappings using Informatica’s data integration technology to extract, transform, and load data from teh oracle and flat files.
• Tested for teh business rule and prepared teh test cases.
• Prepared teh detailed unit test cases for ETL mapping.
• Converted teh stored procedures in Oracle SQL into Informatica mappings.
• Tuned teh mapping for its better performance.
• Involved in teh development of reporting
• Validating teh reports by writing teh test cases and SQL scripts
• Post production support

Environment: Oracle 7.3, SQL*Loader, SQL, PL/SQL, Erwin3.5 and Windows NT 4.0, Netezza, Informatica Power Centre 7.1

Oracle Developer

Confidential

Responsibilities:

• Created dimensional data model for different modules using Erwin3.5.
• Developed complex SQL queries and PL/SQL packages, including stored procedures & functions, to fetch data for reporting and to accomplish several computations.
• Created various SQL and PL/SQL scripts for verification of teh required functionalities
• Generated a number of reports for management to review for system functionality as against teh old legacy system
• Worked with various functional experts to implement their functional noledge into working Procedures
• Worked on optimizing existing procedures and functions using PL/SQL
• Created various Database triggers using PL/SQL
• Developed several forms and reports in teh process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.

Environment: Oracle 7.3, SQL*Loader, Erwin3.5 and Windows NT 4.0, Java