PROFESSIONAL SUMMARY:

• Results - oriented software engineering professional with 13+ years of experience in full life cycle software development requirements analysis, design, coding, testing, documentation, and Implementation of Business Intelligence solutions using Data warehousing tools.
• Extensive work experience in Informatica and Microsoft Business Intelligence tools with good domain knowledge on Insurance, Healthcare and Media & Entertainment clients like Confidential, Confidential, Confidential Inc.
• Informatica Power Center Data Integration 10: Developer, Specialist Certification.
• Well conversant with the Data Warehousing & Data Modeling methodologies. Experienced in Data warehouse designing and Data modeling of logical/physical data, Dimensions and Facts, Star/Snowflake schema implementation by using Erwin and Visio.
• Experience in ETL operations to load data from different sources systems such as MainFrame, Flat Files, XML Source, Oracle, MS SQL Server, Mysql and Excel Files into Data warehouse, Data marts and DSS using Informatica Power Center 10.x, 9.x, 8.x
• Working Knowledge in Informatica Power Exchange to extract data from Mainframe System.
• Solid understanding of Guidewire Policy center and Billing Center data. Involved in designing policy administration and KPI data marts sourcing data from Policy center and Billing Center.
• Good knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys, Normalization & Denormalization.
• Experienced in writing Complex SQL Queries, PL/SQL Stored Procedures, Functions, Database Performance Tuning, Partitioning and Query optimization techniques.
• Good working experience with Waterfall & Agile Methodology and exclusively trained in Agile for SCRUM.
• Well experienced in Data warehouse designing and Data modeling of logical/physical data, Dimensions and Facts, Star/Snowflake schema implementation by using Erwin and Visio.
• Expert in transforming complex business logic into Database design and implemented by creating Stored Procedures, Views, and T- SQL Scripting.
• Performance Tuning of reports, mappings and SQL queries.
• Knowledge in OLAP and OLTP processes, UNIX Shell scripting integrate and synchronize Mainframe data with corporate IT environment
• Experienced in using Informatica Admin console for creating repository services, recycling services, creating users and assigning privileges and permissions.
• Sound interpersonal skills highlighting an ability to explain complex technical issues.
• Ability to communicate with users at all levels and inform them as to the most efficient use of information systems.

TECHNICAL SKILLS:

ETL: Informatica Power Center 10.x, 9.x, 8.x, 7.x, Informatica Developer, Informatica Power Exchange, Microsoft SSIS

OS: Windows, UNIX/LINUX

Programming: PL/SQL, SQL, T-SQL, Shell Scripting, Windows Scripting

Database Tools: TOAD, SQL Developer, SQL Server Management Studio, MySQL

Database: Oracle 10g/9i/8i, SQL Server

Reporting Tool: Cognos 8, SSRS, Power BI, SSAS

Modelling tools: Erwin, VisioEm

PROFESSIONAL EXPERIENCE:

Sr. Informatica Developer

Confidential, West Trenton, New Jersey

Roles & Responsibilities:

• Participate in Requirements Analysis meetings with Data Analysts & users to understand requirements.
• Create High Level Design Document and reviewed with Architects & Data Analysts.
• Analyze and change existing mappings as per the logic mentioned in the mapping document.
• Implemented the projects in Agile Methodology and used tools like RALLY and JIRA for user stories tracking.
• Worked in implementation of Different Integrations for HUD (Home Owner, Umbrella and Dwelling) project with Guidewire application.
• Created new SCD-1/SCD-2 Mappings using Transformations like Expression, Joiner, Union, XML Parser, SQL, Aggregator, Connected & unconnected lookup, Filter, Sequence generator, Router, Sorter, Transaction Control, Update Strategy.
• Involved in migrating the Mappings, Sessions, Workflows from DEV environment to QA and UAT environment.
• Worked in implementation of Different Integrations for Commercial Lines of insurance project with Guidewire application.
• Used Informatica TDM tool that reduced test data provisioning and management overhead, also used TDM for Enterprise Platform built for compliance and scale.
• Used key features of TDM for Data masking and Data warehouse self-service related work.
• Have written windows batch scripts to execute the workflows and raised requests to schedule it in Tivoli Work load scheduler.
• Design and implement Enterprise Data warehouse and subject area data mart based on KPI reporting requirements.
• Created mappings to create parameter files and reusable cache. Also created mappings to clear the cache files.
• Captured changed data from Mainframe VSAM files into Data warehouse using power exchange connectors.
• Tuned ETL process by analyzing target and source bottlenecks. Also used pushdown optimization & Dynamic partitions.
• Design data integration strategy and guide the team to implement ETL solution.
• Created Mongo DB connector in ETL to fetch data from Mongo DB.
• Used Labeler, Standardizer, Address Validator transformations to create IDQ mappings for address cleansing. Also created profiling objects.
• Created DT project using Data Transformation Studio and deployed to use in the UDT transformation to convert Excel data to XML messages and processed XMLs to store it in tables.
• Coordinating with offshore team. Distribution of work. Work distribution.
• Preparing test plan, test cases and testing of data and code.
• Participated in Unit Testing, Integration Testing and Spot Checking of data.
• Used Quality Center to keep track of issues and track the progress of the development of projects
• Preparing design documents and providing KT and guiding other resources.

Tools: & Technology Used: Informatica Power Center 10.0.1, Informatica Power Center 9.6, SQL Server, SQL, PL/SQL, UNIX Shell Scripting, SSIS, SSRS, Guidewire Application, Power BI.

Confidential

Senior BI Developer/Data Analyst

Roles & Responsibilities:

• Participated in walk-through sessions with business users and ensured requirement are understood and captured properly.
• Worked with internal and external customers to determine data requirements.
• Conducts data analysis and testing to ensure the integrity of data loading process.
• Played key role in database design, data modelling.
• Coordinating with Subject Matter Expert for understanding their system and data model.
• Creating High level design document.
• Defining Extraction, Transformation and Loading standards. Creating mapping analysis document for ETL developers.
• Reviewed target and source systems to formulate data acquisition strategy.
• Troubleshoot problems identified and make recommendations to improve process.
• Performed Data Profiling for analyzing the source data.
• Creating PLSQL stored procedures and custom SQL to define ETL processes.
• Responsible for post-go live application support and transition to support group.
• Exposed to various technologies i.e. Oracle, Sybase, Mysql, SQL Server and Microsoft BI suite (SSIS, SSRS and SSAS).
• Understanding the functional requirements and designing.
• Responsible for creating the Dimensional Model for various Business Intelligence applications
• Creating ETL packages for data integration, BI reports and Cubes through Microsoft BI tools.
• Understand Client’s requirement and gaps thoroughly to provide the best service in customization and provide value add services.
• Coordinate with customer for status updates, ticket queries, and verification of solution
• Fixing the issues post production deployment.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow
• Maintenance and support of all the production applications and coordinating the production support with Offshore team.

Tools: & Technology Used: Microsoft BI, SQL Server 2005/2008, MySQL, Sybase

Confidential

BI Report Developer

Roles & Responsibilities:

• Assessment of Cognos Powerplay Reports and Cubes - Creation of Inventory list and Complexity derivation.
• Analyze the Cognos Powerplay Cubes and Reports which are to be migrated to Cognos 8.
• Analyze the Cognos Report Net Reports which are to be migrated to Cognos 8.
• Importing and Exporting reports and packages from CRN to C8, Creating DSN and Publishing packages in Cognos Framework Manager.
• Identifying and solving the Migration Issues and documenting them with the required fix details.
• Creating Process documents

Tools: & Technology Used: Cognos 7 series (Power play, Cognos Report Net), UNIX, Framework Manager, Cognos 8.2 Report Studio & Analysis Studio