Data Sql Server
Resume:
Shravan
Sr. Informatica Developer
**********@*********.***
Professional Summary
•With 8 years of extensive IT experience in all aspects of Software Analysis, Design, Development, Implementation, Testing of Data Warehousing Systems and Data marts.
•Experience in OLTP/OLAP systems, Data Modeling Experience with ER and Dimensional Data modeling using Star Schema and Snowflake Schema modeling, Logical and Physical data modeling using ERWIN 4.0/3.5.
•Experience Database development experience using SQL server 2008/2008R2/2000/7.0/6.5/6.0, Oracle 11g/9i/8i/7.3, PL/SQL, NCR Teradata V2R5/V2R4/V2R3, SQL*Plus, Developer 2000, and MS Access 2000/97/7.0.
•Experience in writing scripts like SQL scripts, PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized Views and Triggers.
•Installing and Configuring of Informatica MDM Hub Console Hub Store Cleanse and Match Server Address Informatica Power Center applications
•Experienced in setup tasks like IBM MDM installation, troubleshooting errors while deployment and installation followed by upgrading the tool.
•Have extensive experience in customizing the InfoSphere MDM Server using MDM Work Bench.
•All facets of MDM implementations including Data Profiling metadata acquisition data migration validation reject processing and pre landing processing
•Strong Business Process Management & Application Implementation/Integration experience in Healthcare Payer
•Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects
•Master Data Management MDM Data Integration concepts in large scale implementation environments
•Closely worked with other IT team member’s business partner’s data steward’s stakeholders steering committee members and executive sponsors for all MDM and data governance related activities
•Extensively used ETL methodologies for supporting data extraction, transformation and loading process, in a corporate-wide-ETL Solution using Informatica Power Center (7.1.4/8.6/9.1/9.6.1).
•Vast experience in designing and developing complex mappings from varied transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Normalizer etc.
•Expertise in Query Analyzing, performance tuning of Informatica mappings.
•Extensive experience in Data Warehousing Reporting using Business Objects (XI version R1/R2) using Desktop Intelligence/Web Intelligence.
•Experience working with Designing, Customizing and Configuring Universes for generating customized scheduled reports.
•Experience working with Autosys, scripting JIL files to schedule jobs, Informatica Scheduler and Unix Scheduler.
•Experience in writing UNIX shell scripts to support and automate the ETL process.
•Experience working with Versioning Tools like TFS, CVS and PVCS Version Manager.
•Experience in Complete Software Development Life Cycle (SDLC).
•Expert in Troubleshooting/ Problem Solving.
•Exceptional written and verbal Communication Skills with ability to work and interact with teams and individuals at all levels.
Technical Skills:
ETL Tools
Informatica MDM, Informatica Power Center 9.6.1/9.1/8.6.1.1/7.1.2/6.2/6.1/5.1, Power Mart 5.0/4.7,
Dataware House Builder, Abintio. Data stage, SSIS. IBM Infosphere Quality stage
Operating Systems
Windows XP/2000/NT/98/95, Windows 2003, 07,10servers, Unix. MSDOS
RDBMS
Oracle 11g,10g/9i/8i/8.0, MS-SQL Server 2008/2005/2000/7.0/6.5
Data Modeling
Erwin 4.1.4/3.5.2, r7.1/7.2, ER studio v8 0.1 and oracle designer.
Data Base Tools
SQL Loader, MS Visio, MS Access
Reporting Tools
Business Objects XI/6.x/5.x, OBIEE 10.x/9.x; Power play and Transformer.
Scripting
UNIX Shell Scripting
Web Technology
Web Technology HTML, Java script
Languages
SQL, PL/SQL, C, C ++, Java 1.2, XML.
BI Tools
Cognos, micro strategy
Query Tools
Toad, Teradata SQL assistant
Educational Qualification:
•Bachelor of Information Technology
Health First, NYC JUL 2015 - Till Date
Informatica Developer
This assignment involved working with many on-going projects, deployments at different stages involving working with the implementation and enhancements of several existing ETL applications. Among other responsibilities involved developing, testing and deploying new enhancements that encapsulates business requirements that influence travel products promotions, marketing, and business reporting for traveler’s participating in OAT (Oversees Adventure Travel).
Roles and Responsibilities:
•Worked on Customer Segmentation Cutover Process, part of which involves the update of all associated Informatica code, update of associated SQL views in the DataMart tables.
•Define and build best practices regarding creating business rules within the Informatica MDM solution
•Worked on the SLA Development Project-For all Data Warehouse subject areas below the DW operations team is responsible to send a notice to the distribution lists if the data delivery expectations are not met.
•Extensively worked with Informatica Repository tables to analyze workflows, tasks, worklets run statistics and developed code to enable reporting of the delay in SLA for the scheduled batch runs daily and weekly.
•Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems
•Enrollment and Maintenance EDI data from employer groups to various health insurance payer
•Extensively used IBM InfoSphere DataStage to develop various DataStage Parallel jobs.
•Worked on data cleansing using the cleanse functions in Informatica MDM.
•Wrote numerous BTEQ scripts to run complex queries on the Teradata database.
•Support the Informatica Grid environments
•Used Joins like Inner Joins, Outer joins while creating tables from multiple tables.
•Created Multiset, temporary, derived and volatile tables in Teradata database.
•Support newly introduced Informatica TDM and DVO utilities
•Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre-Prod and Prod Environments.
• Involved in implementing the Land Process of loading the customer/product Data Set intoInformatica MDM from various source systems.
• Involved in scheduling the workflows through Autosys Job scheduler using UNIX scripts
•Supported PWX for DB2, CDC and data files.
• monitor and work for PWX starter tasks and restart tokens
•Participated in an Agile BI/DW team setting, as a Core team member, participated in the daily scrum meetings for reporting updates on onsite work as well as the offshore development team.
•Worked with multiple source systems DB2, SQL Server, Oracle databases.
•Developed mappings by implementing the High Level Design Document, was involved in discussions in preparing the low level design document and used several transformations such as Expression, Aggregator, Connected and Unconnected Look-up, Router, Joiner, Store Procedure Transformations using Informatica Power center 9.5.1.
•Unit Testing was done extensively with comprehensive test cases and scenarios to validate the data in the DW tables. Unit testing was documented at every stage of the code for the tables.
•Extensively worked with SQL for unit testing as well as during developmental phases.
•Extensively worked with nested workflows involving both reusable and non-reusable worklets.
•Extensively worked with Informatica Versioning and Informatica Scheduler.
•Developed, transformed and tested business required data enhancements using ETL processes.
•Worked on impact analysis of different transformations, targets and sources by querying the Informatica Repository OPB tables, extensively worked with Informatica dependency tool to identify the associated mappings, session, Worklet and workflow to analyze dataflow from ODS to DM tables.
Environment: Informatica Power Center 9.5.1/8.1, Informatica MDM 9.5.1 IBM Infosphere Quality stage SQL server 2008, Oracle, DB2, Toad, Unix, Informatica Versioning Tool, Autosys, TFS, Informatica Scheduler Teradata 13 and 14, Teradata SQL Assistant, Teradata Manager.
Univision, Teaneck, NJ Jan 2015 - Jun-2015
Informatica MDM Developer
Responsibilities
•Installed Informatica MDM 9 5 In UNIX Red Hat with the middleware JBOSS 5 1 GA
•Configured cleanse server and address doctor
•Implement Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration
•Build out best practices regarding data staging data cleansing and data transformation routines within the Informatica MDM solution
•Define and build best practices regarding creating business rules within the Informatica MDM solution
•Have a working knowledge on IBM initiate based on Suspect Duplicate Processing implementation.
• Have a working knowledge in IBM InfoSphere MDM
•Created Base Tables Stages tables based on the data model and number of source systems
•Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
•Worked with Business users in understanding Match Merge setup and incorporated their requirements and ideas
•Upgrade of Unica modules from v8.2 to v9.1.1 & apply relevant Unica patches (9.1.1.3)
•Migrate and validate existing Campaign, Offers, Strategic segments, Templates.
•Integrate with eMessage
•New Campaign Design and development.
• Design and implement multi-channel marketing campaigns for execution through IBM EMM Suite (formerly Unica Affinium).
•Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching
•High level review of SAM discussed use of Roles creation of users and assignment of user to Role
•Supported the Informatica Analyst project
• Work on any on the services failures using the admin console and using the infa commands.
•Scheduled jobs using Autosys.
• Work on different adhoc requests using different infa commands or metadata table queries.
•Defined Roles and privileges for each environments according to the platform requirements
•Defined the security such that schema will be secured with access only granted for specific downstream integration uses using users created for those specific integrations
•Develop and maintain the master and translation entities in the MDM Hub and published the data into SFDC s and ERP s for supporting the ongoing business support
•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 IBM Infosphere Quality stage hubs across multiple data domains Party Service/Product Prospect
•Used hierarchies tool for configuring entity base objects entity types relationship base objects relationship types profiles put and display packages and used the entity types as subject areas in IDD
•Created and Developed IDD application by creating Subject Area Groups Subjects Areas and Entity Relation ships
•Performed analysis design development and maintenance activities associated with the database and data in support of multiple applications including following standards/procedures to achieve integration of systems through database design
•Finally Created Data Validation Document Unit Test Case Document Technical Design Document Informatica Migration Request Document and Knowledge Transfer Document
Environment Informatica MDM 9.5.1 Informatica 9.5 IDQ, IBM Infosphere Quality stage Oracle 11g MS Excel Unix, Autosys.
SunTrust Bank, Richmond, VA May 2013 – Dec 2014
ETL Consultant
SunTrust Banks is an American bank holding company with primary businesses include deposit, credit, trust and investment services. The project was to build a Data warehouse for operational and strategic reporting (MODS). The project was to design, develop and maintain Enterprise data warehouse. The objective is to integrate different source systems like US & CANADA, APAC and Emerging Markets into homogeneous environment to build Enterprise Data Warehouse. The goal of the project is to better decision making with appropriate data views.
Responsibilities:
•Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
•Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
•Extensively worked on tuning mappings and reducing processing times.
•Involved in Code reviews and determining Informatica standards for Mappings/Sessions/Workflows.
•Met with end users to gather requirements.
•Translated business requirements into Informatica mappings/workflows.
•Created various transformations such as Normalizer, Union, Aggregator, Update Strategy, Look Up, Joiner, Filter and Router Transformations.
•Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
•Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, Power Designer.
•Created shell scripts to kick off Informatica workflows and PL/SQL procedures.
•Used DAC (Data warehouse Administration Console) for both incremental and full loads.
•Created Database Triggers, Stored Procedure, Functions and Packages.
•Extensively used debugger to trace the errors.
•Extensively tested the code and documented the Unit Test Cases.
•Created UNIX scripts for automation of ETL process.
•Designed and created an Autosys job plan to schedule our processes
•Assisted the testers in system and integration testing and preparing the test cases and test plan.
•Trained on building Conceptual, Logical and Physical data model
•Taking the backup of the repository at regular interval depending on the amount of work done.
•Worked with DBA to identify source and target bottle necks.
•Involved in bug fixing. Debugged the issues during QA level.
Environment: Informatica Power Center8.6.1/9.1, SQL Server 2005, Control M, Oracle 10g, PL/SQL, Business Objects XIR2, DAC, Toad, Linux, Autosys, UNIX Shell Scripts.
Sensata Technologies, Attleboro, MA Dec 2012 to May 2013
Informatica ETL Consultant
Sensata Technologies is an Electronic Components and Electronic circuits manufacturing company. Its devices are used in various fields of technologies like automotives, appliance, aircrafts etc., The objective of this projects is to have a consolidated clean and consistent Data warehouse for Sales, Product, Manufacturing, and Distribution divisions of the company with historical business trends using historical data so that we can estimate the Current Demand and provide information to Marketing Managers that helps them to make better decisions about pricing, advertising and other vital marketing matters.
Responsibilities:
•Interact with Business Analyst to assist him in Understanding the Source and Target System.
•Responsible to pull the data from XML files, Flat files (Fixed width & Delimited) and COBOL files by using complex transformations like Normalizer, XML Source Qualifier etc.
•Extracted and transformed data from various sources like relational databases (Oracle, SQL Server).
•Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
•Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
•Worked on different tasks in Workflows like sessions, events raise, event wait, decision mail, command, worklets, assignment, timer and scheduling of the workflow.
•Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
•Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
•Efficiently implemented Change Data Capture (CDC) to extract information from numerous Oracle tables and experienced Pushdown Optimization in Informatica Power Center.
•Designed and developed UNIX Shell scripts to report job failure alerts.
•Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, and initial and Incremental Load.
•Used Version Control to check in and checkout versions of objects.
•Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
•Scheduled Informatica Jobs through Autosys scheduling tool.
•Involved in Unit testing, System testing and UAT to check data consistency.
•Assisted QA team to fix and find solutions for the production issues
•Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes, etc.
Environment: Informatica Power Center 9.1, Oracle 10g, Erwin, PL/SQL, Autosys, MS-SQL Server 2008, Toad, MS-Visio, Windows XP
Canara Bank Jan 2011 to November 2012
Hyderabad, India
Informatica Developer
Canara bank is a financial firm that dealt with mobile banking information. There were several OLTP systems that received data on a dynamic basis and needed to be processed for better analytics. A highly normalized data model was built to create reports for stakeholders for rapid reporting.
Roles and Responsibilities:
•Business Analysis and Systems Design.
•Developed Logical and Physical database design.
•Extensively used XML transformations in Informatica for processing data.
•Created transformations in Informatica such as XML parser and XML generator transformations for processing xml related data.
•Maintained Shared objects at the Informatica level to avoid redundancy.
•Extensively used packages, stored procedures and database triggers.
•Analysis is done based on business rules in existing systems and user requirements.
Environment: Informatica 7.1, Oracle 7.x, Windows 3.1/95, Forms, SQL, PL/SQL.
Bharat Heavy Electrical Limited (BHEL), Hyderabad, India Jan 2008-December 2010
Informatica Developer
This project provides the details of different Products in the Company. These details are collected periodically from all Marketing Executives and Customers. These records contain the details of Products, Customers and Marketing Executives at different stages as include product details, marketing executive information, customer information, call schedule, start of the day, end of the day details, quotation generation, purchase order receipt and invoice report. Data from CRM is distributed to all other downstream applications/data marts and serves the reporting needs of all the various divisions.
Roles and Responsibilities:
•Worked on Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
•Involved in developing multidimensional data modeling using star schema and snow flake schema.
•Used Informatica to extract and load data from Oracle database and flat files to Oracle tables.
•Created various mappings using Designer which include Expression, Router, Aggregator, Stored Procedure, Update strategy and Look-up Transformations.
•Created Mapplets using Mapplet Designer to reuse in different mappings.
•Handled Performance Tuning by checking bottlenecks also created partitions, SQL override in Source qualifier.
•Designed and developed Reporting System using Business Objects.
•Performed Unit Testing and documented the complete Mappings
Environment: Informatica Power Center 7.1.3, Oracle 10g, UNIX, Windows XP, Business Objects.
Contact this candidate