Shravya email@example.com Cell: 214-***-****
Around 4 years of Experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power center 9.6.1, IDQ 9.6.1.
Experience in Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 9.6.1
Good experience of ETL design principles and good practical knowledge of performing ETL design processes through Informatica.
Experience in SDLC and manages appropriate levels of systems documentation as required.
Extensively worked on Power Center Mapping Designer, Mapplet Designer, Transformation developer, Work flow Manager, Repository Manager and Workflow Monitor.
Experience in writing DML, DDL and Transaction queries in T-SQL for SQL Server database.
Good understanding in Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema).
Good knowledge in interacting with Informatica Data Quality (IDQ).
Strong analytical and conceptual skills in database design and implementation of RDBMS concepts.
Solid understanding of RDBMS and Data Warehouse concepts, OLTP & OLAP.
Good experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schemas.
Extensive experience in extracting data and creating SAS datasets from various sources like Oracle database, Access database, Excel and flat files using Import techniques
Well versed with creating HTML Reports for financial data using SAS ODS facility, Proc Report and extraction of data SQL-pass-through, PL/SQL facility. Wide-range experience in data manipulation and generating customized reports with SAS data steps and procedures.
Extensive experience on tools like SQL Developer, Application designer and Toad.
Experienced in Oracle database development using PL/SQL, Stored Procedures, Triggers, Functions and Packages.
Implemented the Change Data Capture using Informatica power exchange for Facets data.
Proficient in writing complex queries and stored procedures in SQL Server 2008
Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
Programming Languages: C++, Java, SQL, PL-SQL, UNIX shell and scripting languages.
knowledge in developing and executing Test Plan, Test Scenarios, Test Cases, and documentation of Manual and Automated Tests based on analysis of business requirements.
Informatica Power Center 9.6.1, IDQ
Unix(solaris) 9.0, AIX 5.2, MS Windows 95/98/NT/2000/XP
TOAD 7.x/8.5, SQL Navigator
Oracle 10g/9i/8i, DB2, SQL server 2000
Unix Shell and Python
University of Michigan Flint - Master of Science, Computer Science
Coursework: Advanced Database Concepts & Applications, Advanced Computer Networks, Algorithms & Complexity Analysis, Advanced Distributed Systems, Computer System Architecture, Advanced Human Computer Interaction, Advanced Software Engineering, Information Storage and Retrieval, Ethics and security Management and Data warehousing and Business Intelligence.
Company: Norwegian Cruise Line Holdings Ltd., Miami, FL July 2017 - Present
Role: Informatica Developer
Involved in gathering and analyzing the requirements and preparing business rules.
Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
Using Informatica and PLSQL, generate ETL operations for generating Data warehouse/OLAP for the BI applications
Creation of Oracle Procedures, Packages, Functions, Materialized Views, Triggers, PLSQL Collections
Involved Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
Experience in implementing end to end ETL process using MS BI Stacks (SSIS, SSRS, and SSAS)
Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.6.1.
Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
Involved in Performance Tuning of mappings in Informatica.
Good understanding of source to target data mapping and Business rules associated with the ETL processes.
Environment: Informatica 9.6.1, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader, Tidal Enterprise Scheduler 5.3.1, Accurev, Unix, Flat files.Microsoft Office, MS Access, Crystal reports.
Company: Mercy Joplin - Carthage, Joplin, MO Jan 2016- June 2017
Role: Informatica Developer
Extensively involved in writing ETL Specifications for Development and conversion projects.
Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
Involved in requirement definition and analysis in support of Data Warehouse.
Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
Worked with XSD and XML files generation through ETL process.
Defined and worked with mapping parameters and variables.
Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
Performed the performance evaluation of the ETL for full load cycle.
Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
Worked on Parameterize of all variables, connections at all levels in UNIX.
Created test cases for unit testing and functional testing.
Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process
Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.
Company: Spectacart India Private Limited July 2014 – July 2015
Client: Database Developer
Maintaining the data coming from the OLTP systems.
Tuned the database queries to improve the performance of the query and indexing strategies.
Coded database triggers to record the changes made to the database objects.
Coded functions and stored procedures to perform the user defined functions and execute the required query whenever needed.
Document the work performed each day.
Helped coding shell scripts for database scripting.
Establishing an application's security measures during development of Application in collaboration with DBAs.
Involved in Physical schema implementation, objects like table-space, table rollback segments.
Created database structures, objects and their modification as and when needed.
Managed users & roles for database security.
Maintained system security, control and monitor user access to database
Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.
Environment: MS SQL Server 2005, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, Erwin, ProClarity, QueryAnalyzer, MS Office 2003.
Graduate Student Research Assistant, MI Aug 2015 - May 2016
Student Research Assistant under Professor Dr. Turner and Suluyeman Uludag where I have written an IEEE papers –
Role of Trusted Third Party in Preserving the Electric Vehicle Identity
Grader for Computer Science (C#), MI Aug 2015 - May 2016
University of Michigan-Flint, Student Success Center
Grading Students for their assignments and Exams under Halil Bisgin.
Taking responsibility to conduct exams.
Helping students to understand C#
Tutor for Computer Science, MI Aug 2015 - May 2016
University of Michigan-Flint, Student Success Center
Helped fresher students for Database concepts.
Collaborate with the school supervisors and staff members to assess the student’s needs.
Assist students with Web Application Programming, C++, Data Structures, and Database Design, Algorithms, and Software Engineering.