SUMMARY

• Around 9 years of experience in Information Technology including Data warehousing, RDBMS, Client Server applications.
• Eight years of data warehouse experience using Informatica Power Center 9.6/9.x/8.x/7.x/6.x/5.x and ETL Concepts.
• Experience in Implementation, Maintenance, Testing and Troubleshooting on Informatica Master Data Management MDM ETL/DWH applications Data Quality, Data Integration.
• Experience with InformaticaPower Exchange5.x/8.x for Loading/Retrieving data.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Involved in creating Dimensional Data Modeling and creating Fact table and Dimensional tables.
• Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling.
• Extensive experience in extraction, transformation and loading of data directly from various data sources like flat files, Excel, SQL Server, Sybase, Teradata, DB2 and Oracle.
• Worked on all facets of MDM implementations including Data Profiling, Metadata Acquisition, Migration Validation, Reject Processing and Pre - Landing Processing.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer. Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Monitored and Optimized SSIS package performance to reach the expected time frame for data loading.
• Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Developed Standard Reports, Sub Reports, Cross Tab Reports, Used various Charts and graphs like Bar Chart and Line graphs in SSRS.
• Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance.
• Expertise in Data Extraction, Transforming and Loading (ETL) between different Systems using SQL tools (SSIS, DTS, Bulk Insert, and BCP).
• Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Experience in SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing and Datamart concepts.
• Experienced with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Understanding & Working knowledge of InformaticaCDC (Change Data Capture).
• Integrate and managed workload of Power Exchange CDC.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Working experience in using Oracle, SQL Server, Teradata, PL/SQL, SQL Loader, TOAD, ERWIN.
• Experience in using different kind of Partitions for the better performance and fast retrieval of data from the Database.
• Extensively used Partition by Range, Partition by Hash Function, Sub Partition, List Partitions.
• Extensive experienced in writing stored procedures (PL/SQL), triggers, Functions and Packages.
• Experience in using the Informatica command line utilities like PMCMD to control workflows in non-windows environments.
• Experienced in creating Jobs, Alerts using SQL Mail Agent. Well versed in various high availability solutions like clustering, mirroring, log shipping.
• Experiences in devising Disaster recovery strategies and effectively testing them. Experience in managing security, creating security policies and rules.
• Moved Data from external source into Oracle Database using SQL Loader.
• Experience of TPT loader utilities.
• Have involved in ST, SIT, UAT and PROD Support.
• Have hands-on experience on Informatica Data Quality (IDQ).
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes.
• Experience of scheduling the jobs in B2B, CA7 and Autosys.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Experience with software development life cycle (SDLC) and project management methodologies.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation.

TECHNICAL SKILLS

Languages: Shell Scripting, PL/SQL, PERL, JAVA, .NET

Databases: Oracle11g/10g/9i/8i/7x, MS SQL Server 2008/2005/2003/2000 , Teradata, Sybase15/12.0/11.x/10, DB2, UDB 7.2, My SQL 5.0/4.1 MS Access 2003/2000/97/7.0. Editors (SQL Navigator, Toad)

Operating Systems: UNIX, Windows 7/XP/2000/98,Win NT

ETL: Informatica Power center 9.x/8.x/7.x/6.x/5.x. Power Exchange 8.x/7.x, Metadata Manager, Informatica PowerMart 7x/6x, IDQ, B2B Data Exchange.

Web Technologies/ Tools: XML, XHTML, HTML, VBScript

Data Modeling: ERWIN 4.x/3.x, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, De-normalization

Reporting Tools: MS SQL Server Reporting services 2005, Business Objects XI, Cognos

Relational Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, Oracle 8i/9i/10g/11g, SQL Server Management Studio (SSMS), MS Access.

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, Microsoft Visual Source Safe, Visual Studio .Net.

Languages: T-SQL,SQL, PL/SQL, C, C#, ASP.Net

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL,, IIS(4.0/5.0/6/0)

Operating Systems: Windows 2008, Windows 2000/2003 Server, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

Data Modeling Tools: ETL, Visio, Microsoft Office Suite, Erwin

BI Tools: SQL Server Integration Services(SSIS), SQL Server Reporting Tools (SSRS), Crystal Reports

Configuration Management Tools: Visual Source Safe, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Sr. Informatica/MDM Developer

Responsibilities:

• Preparing the TDD docs based on FSD and Data Dictionary documents.
• Involving the design of the project and provide the design solutions if required.
• Extracts data from Flat Files and DB2 database and applies business logic to load them in the STD and RDS.
• Resolve all development issues and responsible to delivery the code in time.
• Review the development work and release docs before hand over to Deployment Team.
• Develops map, reusable objects, transformation, and Mapplets using Mapping Designer, transformation developer and Mapplets Designer in Informatica Powercenter 9.6.
• Created reusable transformations and Mapplets and uses them in mappings.
• Uses Informatica Powercenter 9.6 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Installing and Configuring of Informatica MDM Hub Console, Hub Store Cleanse and Match Server Address of Informatica Power Center applications.
• Performing, requirement gathering, developing, testing, implementation support and maintenance phases of both MDM and Data Integration.
• Implementation of Informatica MDM workflow including data profiling configuration, specification coding match rules and tuning migration.
• Used TPT loader utilities for better performance.
• Works with data modelers to prepare logical and physical data models and adds and deletes necessary fields using Erwin.
• Implemented Informatica recommendations, methodologies and best practices (Value Adds).
• Developed the IDQ components.
• Import the IDQ components to Powercentre mappings as part of data quality profiling.
• Used Informatica B2B and Autosys to create jobs to run the workflows.
• Exported the workflows in B2B and created end points in B2B to trigger the workflows.
• Created complex mappings in Powercenter Designer using aggregate, expression, filter, and sequence generator, update strategy, union, lookup, joiner, XML source qualifier and stored procedure transformations.
• Applied the concept ofChange Data Capture (CDC)and imported the source from Legacy systems usingInformaticaPower Exchange.
• Used transformations such as router, aggregator, normalizer, joiner, expression, lookup, update strategy and sequence generator, and procedure.
• Used BIPM (Business Intelligence and Performance Management) stream SQL, Pl/Sql, Unix, DWBI with Informatica tool.
• Developed PL/SQL and UNIX Shell Scripts to scheduled sessions in Informatica B2B and Autosys.
• Created e-mail notification tasks using post-session scripts.
• Worked with command line program PMCMD to interact with server to start/stop sessions and batches, stop Informatica server and recover the sessions.
• Build out best practices regarding data staging, data cleansing and data transformation routines within the Informatica MDM solution.
• Worked on Real Time Integration between MDM hub and External applications.
• Wrote SQL, PL/SQL, stored procedures, triggers and cursors to implement business rules and transformations.
• Created procedures to drop and recreate indexes in the target data warehouse before and after sessions.
• Have involved in ST, SIT, UAT and PROD Support.
• Created deployment groups and migrates code into different environments.

Environment: Informatica 9.6.0, Power Exchange 8.6.1, AML, Autosys, DB2, Oracle 11g/10g, Teradata, BIPM, PL/SQL, B2B Data Exchange, IDQ, TOAD, Windows XP ERWIN 4.2 and UNIX.

Confidential, New York City, NY

Sr. Informatica Developer

Responsibilities:

• Have worked on POC on Power Exchange CDC, XSLT, and Informatica Data Transformation.
• Have involved in Architecture of the project.
• Have solved all development issues.
• Review the development work and release docs before hand over to Service Team.
• Analyzed the business requirement document and created functional requirement document mapping for all the business requirements.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Implement Informatica MDM workflow including data profiling, configuration specification, coding match rules and tuning migration.
• Developed the mappings using various cleanse functions in the hub and the address doctor to standardize the data.
• Created Customer onboarding process to load data into landing tables of MDM hub using external batch processing for initial data load in hub store and define automation process for staging, loading match and merge.
• Configured, designed and delivered MDM hubs across multiple data domain party Service/Product prospect.
• Automated the load process using UNIX shell scripts.
• Used heterogeneous files, flat files, XML files, Teradata and oracle as sources.
• Involved in tuning the SQL statements to optimize the performance.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created reusable objects in Informatica for easy maintainability and reusability.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Extensively involved in coding of the Business Rules through PL/SQL using theFunctions, Cursors and Stored Procedures.
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Re-designed ETL mappings to improve data quality.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Modifying the shell/Perl scripts as per the business requirements.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Partitioned sessions for concurrent loading of data into the target tables.
• Used the IDQ reusable components in Mappings.
• Scheduled the jobs in B2B Data Exchange.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Used Shell Scripting to automate the loading process.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica 9.1.0, Informatica Power Exchange, Teradata, Oracle, Informatica Data Transformation, B2B Data Exchange, XSLT, UNIX and Windows XP.

Confidential, Chantilly, VA

Informatica Developer

Responsibilities:

• Interaction with the Client, Data Modelers and Business Users to gather the requirements and assign work to offshore team.
• Involved in Design Phase and prepared Macro and Micro documents.
• Reviewed IDD & Data Mappings documents.
• Designed and developed reusable components.
• Reviewed the development work and prepared release docs.
• Have involved in ST, SIT, UAT and PROD Support.
• Have involved in PROD remediation process and prepared remediation documents.
• Analyzed Business and Systems Requirements documents and other documents as a preparation for the creation of required System Design Documents.
• Involved in Dimensional Data Modeling design and populating the Business rules into integrated data warehouse.
• Created logical and physical data models for Business users to determine data definitions and establish referential integrity of the system.
• Experience of working on Fact Tables and Dimensional tables.
• Extensively used and created Complex Mappings using Source Qualifier, Aggregator, Expression, Joiner, Lookup, Router, Filter and Stored Procedure transformations.
• Used Star schema for the data warehouse.
• Created and Monitored Sessions using Informatica Powercenter. Designed Sequential and concurrent workflows for whole process.
• Migrated the objects between various repositories and maintained the repository.
• Involved in working with heterogeneous data sources like flat files, Teradata, DB2 and Oracle.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Tuned the SQL queries used in the SQL overrides of the Source Qualifiers.
• Wrote SQL, PL/SQL, Stored procedures, triggers and packages.
• Used TPT load utilities for better performance.
• Reused IDQ components.
• Constantly assisted Business Users in data validations for any data issues observed and mismatches.
• Involved in Unit testing, system testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with CA7 Scheduling team to schedule jobs daily and weekly based on Feedback from Business Analysts.

Environment: Informatica 9.1.0, UNIX, CA7, Teradata, Oracle and Windows XP.

Confidential, Richmond, VA

SSIS/SSRS Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Created User Defined functions for sharing formulas across multiple reports.
• Modified existing reports according to requirements of the end users.

Environment: MS SQL Server 2005/2008, SSRS 2005/2008, SSIS 2005/2008, SSMS, ASP.NET, VB.NET, C#.NET, T-SQL, PL/SQL, Oracle 10g, MS Share Point, Access and Excel.

Confidential

Associate SQL Developer

Responsibilities:

• Involved in gathering requirements from business users.
• Involved in transformation of data from various sources and legacy systems like Teradata, SQL Server 2000 and Excel into SQL Server 2000 using DTS.
• Created triggers that capture the claims and wrote complex formulas that calculate the amounts related to those particular claims.
• Created number of complex formulas to calculate the amounts related to different claims in sub reports using different types of variables like shared variable and retrieved them from master report
• Created complex stored procedures to fetch and manipulate data in the databases.
• Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
• Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.
• Modified report content and exported reports in multiple formats based on user input.
• Designed/modified database schema objects to support existing and new business related application development for a global-application. Write/test SQL scripts to perform application specific data manipulation

Environment: MS SQL Server 2000, T-SQL, DTS, Teradata, Excel.