Candidates About

­­­­­­­­Anusha

PROFESSIONAL SUMMARY:

·         Over 7 years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for extraction, transformation, and loading (ETL) in Informatica Power Center from various database sources. 

·         Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources like SQL Server, Oracle, DB2, COBOL files & XML Files and flat files into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. 

·         Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications. 

·         Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies 

·         Strong knowledge of Entity-Relationship concept, Facts and Dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modelling. 

·          Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management. 

·         Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart. 

·         Extensive experience in developing Stored Procedures, Functions and Triggers, Complex SQL queries using SQL Server TSQL and Oracle PL/SQL. 

·         Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions. 

·         Good working knowledge of various Informatica designer transformations like Source Qualifier, Dynamic and Static Lookups, connected and Unconnected lookups, Expression, Filter, Router, Joiner, Normalizer and Update Strategy transformation. 

·         Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. 

·         Experience in Task Automation using UNIX Scripts, Job scheduling and communicating with Server using pmcmd. 

·         Created highly interactive visuals and dash boards in Tableau platform. 

·         Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries in Tableau.

·         Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts using Tableau.

·         In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines in Tableau.

·         Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

Additional Information

ETL Tools                                             :               Informatica PowerCenter 9.5/9.x/8.6/8.5 (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Server)

Databases                                           :               Oracle, MS SQL Server, MS Access.

Reporting Tools                                                :               Tableau
Scheduling Tool                               :               Autosys

Operating Systems                         :               MS office
Environment                                     :               UNIX, LINUX, Windows Server
Programming Languages              :               C, Java, SQL, Linux/Unix Shell

Work Experience

CIT Group, Livingston NJ                                                                                              December 2016 - Till Date

Informatica/Tableau Developer

Job Responsibilities: 

·         Worked closely with business analyst to analyze and understand the business requirements. 

·         Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Data warehouse. 

·         Designed complex mappings by using Lookup transformation, Expression, Sequence generator, Update, Aggregator, Router, Stored Procedure.

·         Created Mappings, Mapplets, Sessions, Workflows (reusable and non-reusable) by using Informatica Power Center. 

·         Designed and developed Tableau Reports, Dashboards and Stories using visual design best practices.  

·         Worked on creating various analytical Dashboards from multiple data sources by blending data on a single worksheet in Tableau Desktop. 

·         Created Prompts, Parameters, customized Calculations, Conditions, Groups, Sets, Bins, Context filters and LODs for various analytical reports and Dashboards. 

·         Experience in creating different visualizations using charts like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles.

·         Involved in troubleshooting and performance tuning of reports and resolving issues related to Tableau Server and Reports. 

·         Experienced in methodologies like SDLC and Agile methodologies such as SCRUM. 

·         Extensively worked on SQL override in Source Qualifier Transformation for better performance. 

·         Designed and developed stored procedures using PL/SQL and tuned SQL queries for better performance. 

·         Implemented slowly changing dimension (SCD Type 1,2 and 3) in various mappings.   

·         Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, Assignment, Timer and scheduling of the workflow. 

Environment: Tableau 10.0, Informatica 9.5.x, Excel, Access, Autosys, Oracle DB 11g, Windows Server 2008, 2010

Breakthru Beverage Group, Maryland                                                   January 2016 - December 2016

Informatica /Tableau developer                              

Job Responsibilities: 

·         Gathered functional requirements from analysts and designed and developed ETL mappings to extract and load data from various data sources (Flat files, relational tables) 

·         Extensively used Mapping Variables, Mapping Parameters and also worked with XML Sources& Targets 

·         Extensively worked on Informatica Power Centre 9.6 for Extraction, Transformation and Loading of data from various sources into the target database. 

·         Worked on complex mappings with transformations including connected/un connected lookup, Joiner, SQL, filter, router, Source Qualifier, expression, aggregator and normalizer transformations. 

·          Extensively used Informatica debugger to figure out the problems in the mapping. Also involved in troubleshooting existing ETL bugs. 

·         Involved in developing the Data Warehouse using Star schema. 

·         Defined best practices for Tableau report development. 

·         Administered user, user groups, and scheduled instances for reports in Tableau 

·         Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters on demand needed information. 

·         Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately. 

·         Executed and tested required queries and reports before publishing. 

·          Responsible for Release migration in between different environments. 

·          Performed Backup/Recovery of Informatica software. 

·          Extensively used Erwin for Dimensional Data Modeling. 

Environment: Informatica Power Center 9.6, Tableau Desktop 8.3, Windows 2010, Erwin, PL/SQL, Oracle 10g/11g, Unix

Insurance Auto Auctions, Chicago IL                                                       November 2013 - December2015

Informatica Developer

Job Responsibilities: 

·         Analysis and review of source data structures from various modules and the internal systems and develop specifications of our target data mart and Informatica mappings. 

·         Lead Design of ETL solutions with Informatica mappings, workflows and perform the unit testing for the developed mappings. 

·         Developed Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data mart. 

·         Used Informatica Designer to create complex mappings using different transformations like filter, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformations to move data to a Data Warehouse. 

·         Responsible for testing the entire applications and transport the data to Target Warehouse Oracle tables on the server, Schedule, Run Extraction and Load process and Monitor sessions by using Informatica workflow manager and workflow monitor. 

·         Created materialized views for better performance of the staging area for some of the high volume sources. 

·         Identified and deduced dependencies and created Batch parallelization. 

·         Developed test plans for Integration testing, system testing and acceptance testing 

·         Created Autosys jobs to schedule run for the workflows in Production. 

Environment: Informatica PowerCenter 9.1/8.6, Oracle 11g/10g, SQL Server 2005, Windows Server 2007-2008, Autosys, UNIX. 

Ajel Technologies, India                                                                                               September2011 – August 2013

Informatica Developer

Job Responsibilities: 

·         Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications. 

·         Involved in all phases of SDLC from requirement gathering, design, development, testing and roll out to the field user and support for production environment. 

·          Extensively worked with Informatica Power Center client tools like Source Analyzer, Warehouse Designer and Mapping Designer to develop mappings for implementing the transformation logic to implement the business rules and requirements. 

·         Worked with the DBA to build the fact and dimension tables. 

·         Extensively developed source to target mappings and scheduling Informatica sessions. 

·         Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure. 

·         Designed and Developed the workflows, validated the dependencies in between the workflows which involved various tasks like even-wait, command, session tasks. 

·         Monitored production jobs on a daily basis and worked on issues relating to the jobs failure and restarted failed jobs after correcting the errors. 

·          Developed reusable transformations and Mapplets. 

·         Used pmcmd command to run Informatica Workflows in Scripts. 

·         Involved in Performance Tuning of the mappings, used Informatica Debugger. 

·         Used Incremental Loading and Slowly Changing Dimension type 2 to maintain history data.

Environment: Informatica PowerCenter 8.6, Oracle 10g, UNIX, Windows Server 2007.

ZENQ, India                                                                                                                        May 2010 - August 2011

ETL Developer

Job Responsibilities:  

·         Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets. 

·         Involved in preparation of technical documentation, design transformations that are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution. 

• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.

·         Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse. 

• Created various Transformations like Lookup, Joiner, Aggregator, Expression, Filter, Router, Stored Procedure and Update Strategy.

·          Extensively worked on Mapping Parameters, Workflow Variables, Mapping Variables, and Session Parameters. 

• Scheduled Sessions on the Informatica Server using Workflow Manager and Workflow Monitor.

·          Used the Workflow Manager to create Workflows, Worklets and Tasks. 

·          Wrote SQL over ride queries in the required transformations. 

·          Used design and development techniques that resulted in efficient, maintainable, and high quality ETL processes. 

·         Communicated with Managers, and clients to help them make business decisions

Environment: Informatica Power Center 8.6, Excel, Access, Oracle DB 10g, Windows Server 2005