Description
PROFESSIONAL SUMMARY: * 5+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, and Telecom Sectors. * Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager. * Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP. * Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support. * Experience in designing and developing complex mappings from various transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc. * Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio. * Depth knowledge in Hadoop Hortonworks, HDFS, PIG, Hive, Sqoop, MR, Mongo DB, Oozie, Flume. * Expertise in working with relational databases such as Oracle 11g/10g/9i, SQL Server 2008/2005 and MS Access. * Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, Mainframes and SQL Server Databases. * Extensive experience in developing Stored Procedures, Views, Complex SQL queries using SQL Server and Oracle PL/SQL. * Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions. * Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documentation. * Extensive experience in writing UNIX shell scripts. * Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, Teradata, Mainframes and Flat Files into the staging area, ODS, Data Warehouse and Data Mart. * Worked extensively with SCD1 and SCD2. * Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplets. * Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing. * Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines Skill Summary: ETL/ELT Tools : Informatica (Power Center 9.x/8.x, Power Exchange 8.x) Dimensional Data Modeling : Dimensional Data Modeling, Star and Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling Analytical Tools : OBIEE 11g. Oracle Technologies : SQL, PL/SQL RDBMS : Oracle 11g/10g/ 9.i, Teradata Project Summary: Qualcomm Inc. is an American multinational semiconductor and telecommunications equipment company that designs and markets wireless telecommunications products and services. The company headquarters are located in San Diego, California, United States, and has 224 worldwide locations. The parent company is Qualcomm Incorporated (Qualcomm), which includes the Qualcomm Technology Licensing Division (QTL). They already have SCOM, Finance, Procurement and Spend, Service, Manufacturing Analytics and ton of custom applications deployed over several years and now they would like to check the fallouts and gaps if they were to bring in this new data into the existing environment. This phase involves only execution of a load and identifies the gaps and impacts. Responsibilities: * Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica PowerCenter 8.6.1. * Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design. * Loaded the data in incremental fashion by using batches & sessions on Informatica Server Manager. * Configured several Informatica Mappings to populate the data from Oracle into dimensions and fact tables. * Tuned sources, targets, mappings and sessions to improve the performance of data load. * Migrated Test Code from Development to QA and QA to Production of Repository, Dashboard Reports, Informatica mappings and workflows and DAC entities. * Validated the data/Reports each and every time a migration occurs from Dev to QA and QA to Production environment. * Responsible for updating/ tracking and documenting the development changes at both ETL level and rpd level. * Configured new tasks, parameter files and Execution Plan in DAC for Incremental and Full load. * Streamlined the Execution Plans with their respective tasks in DAC. * Monitored the Incremental & Full load through DAC. * Maintained the Full and Incremental loads through DAC on different environments like Development, QA and Production environment. * Performed Unit and Regressive testing during development of reports and dashboard. * Actively resolved the issues and defects raised by the tester during SIT and UAT testing phrases. * Attended daily status meetings, department meetings and defect review meetings. * Documented the complete project details like Best Practices, development standards, promotion and demotion policies and migration standards. Project Summary: Verizon Wireless is a wholly owned subsidiary of Verizon Communications offering wireless telecommunications products and services. With 142.8 million subscribers as of July 2016, Verizon Wireless is the largest wireless telecommunications provider in the United States. The company is headquartered in Basking Ridge, New Jersey. Verizon Fios service landed in 2005, Provides Internet, Television and Phone service using Fiber optic cable instead of copper wire over 5 Million people in 13 States. Verizon was one of the 1st major US carriers to offer Fiber to Home. Verizon Product Factory is a Product catalog Used to maintain Product information like high-speed Internet, 3G, 4G, Wireless, Wireline, Video, TV, Bundle Products (Combination of Video, TV-like TATA SKY) and moved data to different down streams like SSP, I2O, PCAT, Bill Media, RIBS, RETAIN, DTV, RBI. Responsibilities: * Responsible for Business Analysis and Requirements Collection. * Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor. * Parsed high-level design specification to simple ETL coding and mapping standards. * Designed and customized data models for Data warehouse supporting data from multiple sources on real time * Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse. * Created mapping documents to outline data flow from sources to targets. * Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse. * Maintained source definitions, transformation rules and targets definitions using Informatica repository Manager. * Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union to develop robust mappings in the Informatica Designer. * Developed mapping parameters and variables to support SQL override. * Created mapplets to use them in different mappings. * Developed mappings to load into staging tables and then to Dimensions and Facts. * Used existing ETL standards to develop these mappings. * Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow. * Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse. * Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables. * Extensively used SQL* loader to load data from flat files to the database tables in Oracle. * Modified existing mappings for enhancements of new business requirements. * Used Debugger to test the mappings and fixed the bugs. * Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder. * Involved in Performance tuning at source, target, mappings, sessions, and system levels. * Prepared migration document to move the mappings from development to testing and then to production repositories. * Documented the complete project details like Best Practices, development standards, promotion and demotion policies and migration standards. Project Summary: Axis Bank is the third largest private-sector banks in India offering a comprehensive suite of financial products. Headquartered in Mumbai, the bank has 2,959 branches, 12,743 ATMs and nine international offices. Verizon Fios service landed in 2005, Provides Internet, Television and Phone service using Fiber optic cable instead of copper wire over 5 Million people in 13 States. Verizon was one of the 1st major US carriers to offer Fiber to Home. Axis Bank will be using Finacle and Finlite product to store the customer information. Bank involves in the issues of loan amounts like Personal loans, gold loans, consumer durable loans etc . and bank will be calculated different type of interest calculation for different customers. Basically our data ware house is a data mart. We calculated the customer data in Fact and Dimension tables. They needed a Data Warehouse so that they could maintain historical data and central location for integration. Responsibilities: * Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications. * Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data. * Consolidation, standardization for the unstructured flat file data. * Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5.1. * Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area. * Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping. * Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, Joiner and Rank transformations. * Worked with SCD Type II with MD5 mappings implementing date based & flag based logic. * Managed the Metadata associated with the ETL processes used to populate the Data Warehouse. * Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets. * Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them. * Improved session Performance by enabling property incremental aggregation to load incremental data into target table. * Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements. * Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production. * Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values. * Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions. * Used PMCMD command to automate the Power Center sessions and workflows through UNIX. * Documented Technical Design, Migration Process, SIT Results and Best Practices. Project Summary: Pfizer is a Pharmaceutical company. Pharmaceutical information system plays a key role in any pharmacy-oriented organization. It deals with different product types used in developing products under various Batches, maintaining unit level details, stocks for Purchase and Sales, taking care of transactions like purchase order, Sales order along with their Vendor and customer information. The application frees the users from hard manual entries and gives the ease of use of transformation regarding Vendors, Customers, Products, units, and Stocks with transactions. Responsibilities: * Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications. * Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data. * Consolidation, standardization for the unstructured flat file data. * Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5.1. * Experience in integration of heterogeneous data sources like Oracle, SQL Server and Flat Files (Fixed & delimited) into Staging Area. * Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping. * Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, Joiner and Rank transformations. * Managed the Metadata associated with the ETL processes used to populate the Data Warehouse. * Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets. * Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them. * Improved session Performance by enabling property incremental aggregation to load incremental data into target table. * Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements. * Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production. * Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values. * Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions. * Used PMCMD command to automate the Power Center sessions and workflows through UNIX. * Documented Technical Design, Migration Process, SIT Results and Best Practices.
Accomplishments
Highlights:
Keywords
