SURYA

Phone: 248-***-****

Email: ac3osa@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 8+ years of experience with Data Warehousing implementations across various industries.

ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 9.x/8.x/7.x/6.x and Power Mart 6.x.

Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.

Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.

Experience in creating High Level Design and Detailed Design in the Design phase.

Good Understanding knowledge of Ralph Kimball & Bill Inmon Methodologies.

Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.

Extensively worked on the ETL mappings, analysis and documentation of OLAP reports

Well versed in OLTP Data Modeling, Data warehousing concepts.

Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).

Experience in integration of various data sources like Oracle, DB2, SQL server and non-relational sources like flat files into staging area.

Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup,

Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).

Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.

Experienced in UNIX work environment, file transfers, job scheduling and error handling.

Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.

Experience in Working on various source systems and data profiling as well as in co-ordinating data modeling of sources and targets.

Experience in migrating Informatica mappings/sessions /workflows from Development to Test to production environment and also in troubleshooting data issues.

Expertise in Identifying root cause and implementing resolution for production issues.

Conducted Unit Testing and created Unit Testing Results Documents.

Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.

Migration, up-gradation, Development, Administration and Support experience in Business Objects

XI tool suite.

Involved in Unit testing, System testing to check whether the data loads into target are accurate.

Experience in building, enhancing and managing Universes, creating WebI, DeskI, Complex, Adhoc Reports, Canned Reports, Charts using Business Objects.

Experience in complex data analysis in Designer, used data from multiple data providers, performed extensive data analysis with complex queries, drill up, drill down, slice and dice.

Strong hands-on experience in creating/enhancing Universes using BO Designer and in creating and maintaining reports using Business Intelligence, Business Objects, Crystal reports, Web Intelligence, WebI Rich Client and Desktop Intelligence.

Assign work and provide technical oversight to onshore and offshore developers.

TECHNICAL SKILLS:

Databases

Oracle 7.x/8.x/9x/10g/11g, SQL Server 2008/2005/2003/2000, DB2 UDB 7.2, My SQL 5.0/4.1, MS-Access. Editors (SQL Navigator, Toad), Netezza, Teradata

Oracle Tools

Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader

ETL Tools

Informatica 10.1/9.x/8.x/7.x/6.x, Informatica PowerExchange 9.x/8.x/7.x

Data Modeling

ERWIN, Visio

Reporting Tools

MS SQL Server Reporting services 2005, Business Objects XI, Crystal Reports 10, Crystal Reports 2008, Business Intelligence 4.1 SP8

Programming Skills

C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, JAVA, HTML, JAVA Script, J2EE, CSS.

Operating Systems

UNIX, Windows ME/2000/2003/NT/XP, IBM AIX

Scheduling tools

Autosys, Tidal, Control-M

PROFESSIONAL EXPERIENCE:

Visiant Health, Southborough, MA May 2017 - Present

ETL Informatica Developer

Visiant Health provides solution for health plans and providers looking to maximize opportunities in the competitive Medicare Advantage market. Visiant Health also partners with clients to develop tailored solutions and services that achieve immediate scale.

Roles & Responsibilities:

Working in a competitive Agile environment to Develop standard ETL framework and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.

Woking closely with Business Analysts to gather Business Requirements and implement them.

Involved in analyzing and writing complex queries to extract data using SQL Developer.

For loading data used multiples sources like flat files, RDBMs databases.

Currently working on migrating all our existing development from our servers onto into Microsoft AZURE, a cloud based service.

Working on performance tuning of Informatica sessions for large data files by making changes to the existing mappings, sessions and database tables.

Using Contol-M job scheduling to schedule Informatica workflows.

Working on developing shell scripts to automate the data loading process and to clean the flat file inputs.

Working extensively on JIRA for issue tracking and project management.

Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Preparing and using test data/cases to verify accuracy and completeness of ETL process.

Co-ordinating between different teams across circle and organization to resolve release related issues.

Environment: Informatica Power Center 10.1, Oracle 11g, JIRA v7.1.4, SQL Developer.

Blue Care Network, Detroit, Michigan Aug 2015 – May 2017

ETL Informatica Developer

Blue Care Network is a non-profit corporation and independent licensee of the Blue Cross and Blue Sheild Association.

Roles & Responsibilities:

Worked closely with business users while gathering requirements, analyzing data and supporting existing reporting solutions.

Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.

Checked performance tuning/debugging at different levels like workflows, mappings, database etc.

Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.

Created testing metrics using MS-Excel

Performed Configuration to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment also troubleshooted data issues.

Identify root cause and implement resolution for production issues.

Designing and developing ETL solutions in Informatica Power Center 9.6 and Toad,SQL developer and performed shell scripting.

Written SQL Queries, Triggers, and PL/SQL Procedures to apply and maintain the Business Rules.

Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.

Worked on various source systems and conducted data profiling as well as co-ordinated data modeling of sources and targets.

Conducted Unit Testing and created Unit Testing Results Documents.

Preparing and using test data/cases to verify ETL process.

Actively involved in the production support and also transferred knowledge to the other team members.

Created various reports using Business Objects 3.1 as well as Business Intelligence 4.1

Worked and helped during the migration of reports from Business Objects 3.1 to Business Intelligence 4.1 and performed regression testing on many of the reports after migration.

Developed complex custom queries by creating objects in the Universe to overcome loops and followed the rules as per the requirements to overcome the loops

Worked extensively with an off-shore resource to develop a corporate dashboard report.

Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc

Used Alerters, Filters, Breaks, Sorts and Rankings, Customizing User Objects, List Of Value (LOV’s) in the reports.

Environment: Informatica Power Center 9.6, Business Intelligence 4.1 SP8, Oracle 11g, Windows server 2003, TOAD, SQL Developer.

Well point, Iselin, NJ Jul 2014 - Jul 2015

Informatica Developer

Creating/Building Data mart for maintaining pharmacy, Provider and Member information and migrating the data from mainframe system to Oracle Database.

Roles & Responsibilities:

Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.

Used Informatica PowerCenter 9.6 for extraction, loading and transformation (ETL) of data in the data warehouse.

Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.

Extracted data from different sources like Oracle, flat files; XML and SQL Server loaded into Enterprise DataWareHouse (DWH).

Involved in Migration process of moving all the informatica objects from Informatica 8.6 to Informatica 9.6 and in this process building an entirely new enterprise data warehouse (BIW).

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Performed Unit Testing and tuned the Informatica mappings for better performance

Used TOAD to execute SQL queries and perform any query tuning etc.

Developed various stored procedures, Cursors and Triggers using Oracle PL/SQL.

Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.

Created various standard reports and queries based on the existing classes/objects. Exported reports to Excel based on the user requirements.

Created, enhanced and maintained Universes for different domains and defined various Classes and objects according to the Business Requirements provided.

Environment: Informatica Power Center 9.6, Business Objects XI, Oracle EBS 11i, Oracle 11g, Windows server 2003, TOAD

NYCHDC, NY Feb 2013 - Jun 2014

Informatica Developer/Business Objects Developer

NYCHDC is the nation’s number one issuer of bonds for multi-family affordable housing. They issue tax-exempt and taxable bonds to finance low-cost mortgages to developers for the creation and preservation of affordable housing. HDC implemented Data Warehousing project to integrate the data from Oracle E-Business Suite modules and COBOL based Cash Management system called Emphasys. HDC has number of data marts to cater to different business needs and has numerous reports based on these data marts for various business units like Legal, Credit Risk, Asset Management, Loan Servicing and Finance.

Roles & Responsibilities:

Analyzed the requirements and framed the business logic for the ETL process.

Involved in JAD sessions to understand the business requirements.

Worked on Informatica Power Center tool–Source Analyzer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica workflow Manager.

Created Informatica mappings for initial load and daily updates and developed several mappings to load data from multiple sources to data warehouse.

Created mappings for Emphasys data using COBOL as source using sql override and loaded data into warehouse tables.

Used Alerters, Filters, Breaks, Sorts and Rankings, Customizing User Objects, List Of Value (LOV’s) in the reports.

Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).

Extensively used mapping parameters, mapping variables and parameter files.

Developed jobs for different Dimension and Fact mappings and created Sessions and Workflows for the mappings.

Implemented SCD methodology including Type 1, Type 2 and Type 3 changes to keep track of historical data.

Extensively used PL/SQL Procedures/Functions to build business rules.

Developed mappings using Informatica Designer to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, and Joiner.

Performed Unit testing for mappings, checked the source, target and mapping bottlenecks to tune the ETL process performance.

Scheduling the sessions to extract, transform and load data into warehouse database on Business requirements.

Scheduled the tasks using Autosys.

Monitoring scheduled jobs and going through the log files, also setting up e-mails upon success and failure.

Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe

Created, enhanced and maintained Universes for different domains and defined various Classes and objects according to the Business Requirements provided.

Environment: Windows, Business Objects, Informatica Powercenter 9.1, UNIX, SQL, PL/SQL, SQL Developer, Oracle 10g.

Huntington Bank, Columbus, OH Mar 2012 – Jan 2013

Informatica Developer

Responsibilities:

Involved in complete SDLC phase in collecting and documenting requirements. Wrote TSD documents for developers easily to understand and code.

Developed Informatica mappings to consolidate data from 10 source systems into the new data warehouse that we built. All the 10 data sources resided on various platforms. These 10 sources include fixed width and delimited flat files, Excel, Oracle.

Formulated and implemented Historical load strategy from multiple data sources into the data warehouse. Data concurrency, Prioritization, comprehensiveness, completeness and minimal impact to existing users are taken as key attributes for Historical data load strategy.

Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets.

Connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.

Deployed the WebI reports/Universes as BIAR from Test to Production for the go-live, performed Smoke testing and validated the reports working.

Performed Root Cause Analysis to address production issues related to BO application

Configured E-mail functionality in Business Objects.

Scheduled WebI reports to run weekly/monthly automatically and sent the reports as PDF to DHS and FEMA users

Extensively used Mapping Variables, Mapping Parameters to execute complex business logic

Development of PL/SQL Stored Procedures to implement complex business logic and integrate them with the ETL process as pre/post Stored Procedures.

Responsible for the documentations of the different processes carried out like design documents and mapping documents, share point for the version control of the documents and star team for the version control of source code for all the interfaces in the Interface Project.

Designing the dimensional model and data load process using SCD Type II for the quarterly membership reporting purposes.

All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.

Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.

Environment: Informatica Power Center 8.6.1, Business Objects, Informix, SQL Server 2005, Erwin 4.1, UNIX, UNIX Shell Script.

Tata Consultancy Services Ltd, Mumbai, India

Clients: GE Transportation, GE Energy May 2009 – Jan 2012

ETL Developer

Projects: Customer Master File (CMF), Electronic Searchable Invoice (ESI)

Client is a division of the multinational conglomerate corporation based in USA.

As part of CMF, we were required to send an extract, of the customer data stored in the system, to the CMF Data Mart on a weekly or monthly basis. This data will then be used to track CMF compliance and assist in reconciliation of discrepancies between customers in a legacy system and the Customer Master File.

Project ESI (Electronic Searchable Invoice) is to develop a system to make the invoices available to clients online. Initially invoices are printed on the paper and it was faxed to the customer. All the required data has been flown into a common data base ESI. From this Front end application is used to display the repair details of the invoice using Java.

Responsibilities:

Design and developed Oracle PL/SQL Scripts for Data Import/Export, Data Conversions and Data cleansing.

Extensively used Power Center/Mart to design multiple mappings with embedded business logic.

Created Mapplet and used them in different Mappings.

Provide Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mapping.

Developed Complex mappings and workflows using Power Center designer and Workflow manager for loading data into Data warehouse from staging.

Involved in unit testing and system testing

Performed SQL query tuning

Tuned the mappings and reports for better performance

Resolved the production issues and supported the system

Updated / reviewed system description.

Involved in the change management process for each bug fixes and enhancements done by maintenance team. Involved in the change management process for each bug fixes and enhancements done by maintenance team. Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.

Extensive use of Persistent cache to reduce session processing time.

Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.

Modified the shell/Perl scripts as per the business requirements.

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.

Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.

Developed shell scripts for file transferring

Extensively used Netezza Utilities to load and execute sql scripts using Unix.

Implemented screen door process for cleaning flat files as per the business requirements.

Preparing 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.

Refreshed the data by using fastexport and fastload utilities.

Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 8.6.1, Business Objects, Informix, SQL Server 2005, Erwin 4.1, UNIX, UNIX Shell Script.

Contact this candidate