Candidates About

 

Sreepriya Goteti

8+ years of IT experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center (9.x/8.x/7.x).

·         Data Architect /developer with experience in Healthcare, Insurance, financial, Telcomm and Retail domains

·         Extensive Knowledge and experience in completing and implementing each and every phase of the SDLC in data warehouse environment in time

·         Experienced in building data quality controls on the on-going data loads

·         Extensive knowledge in Data Modeling using Dimensional Data Modeling techniques like Star Schema Modeling, Snowflake Modeling

·         Implemented Multi Layer ETL Data Extracts, Data Load Logic, Mapping, Work Flows, stored procedure Developed/ tested and version controlled physical database changes (DDL/DML) approved by the MATS (Model Adminstration Tracking System)

·         Experienced in Agile and waterfall methodology

·         Hands on experience working with various databases including Oracle, Sql Server with SSIS, DB2, Teradata.

·         Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information

·         Excellent capabilities in integration mappings including dynamic cache lookup, shared, and persistence mappings for Type I, Type II, Type III slowly changing dimensions

·         Experienced with Informatica Power Center(IPC) / Informatica Data Quality (IDQ) /SSIS, B2B DX tools for Data Analysis

·         Experienced with Data masking techniques for security of sensitive data

·         Experience in implementing update strategies, incremental loads and change Data capture

·         Developed mapping and workflows with parameters and variables

·         Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations

·         Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.

·         Helped with data profiling, specifying and validating rules (Scorecards), and monitoring data quality using the Informatica Analyst tool.

·         Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / De-normalization strategies

·         Scheduling jobs using Maestro (TWS), Crontab.

·         Experienced in the CDC (Type1, Type2 and Type3), session partitioning, Performance Tuning and advanced optimization techniques.

·         Implemented CDC in oracle databases to capture latest updates from source to destination.

·         Experienced in database development using PL/SQL stored procedures/packages, Functions, Triggers, Synonyms and all type of Oracle Objects

·         Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.

·         Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, and Folders, taking backups and restoring dbs

·         Experienced in BMCC Remedy User in creating and managing the Change Requests

·         Expertise in using UNIX and writing UNIX shell scripts.

·         Demonstrated ability to work and communicate effectively with both business and technical audiences.

·         An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities.

·          

.

 

Databases:  SQL Server 2008/2005/2003, Oracle 11g/10g/9i/8i, DB2/UDB, Teradata,  Vertica ,Netezza

ETL Tools:  SSIS, Informatica power center 9.x/8.x/7.x, Informatica Power Exchange  navigator 8.x/7.x, Informatica Data Quality(IDQ) 8.6,Scribe, B2B DX console

Data Modeling:  ERWIN 7.x, 9.X, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema,  Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, Denormalization.

Agile Tools : Rally, TD Platform, VersionOne

Reporting Tools:   Jasper Reports,ireports

Programming Skills:  C, Shell Scripting, PL/SQL, Unix scripting

Operating Systems:  Windows XP/2000/98, UNIX, IBM AIX

WebServices : XML, WSDL,SOAP UI,CRM, mainframes

 

HMS, Irving, TX

 

Eligibility /B2B DX                                                                                                            July’17 - current

ETL Analyst

 

Responsibilities: 

 

·         Working as a part of Informatica B2B project in onboarding the files from multiple health care clients/carriers using B2B DX console.

·         Created partner / accounts for each client /carrier and also profiles/ endpoints for onboarding the Claims , non-claims and eligibility data files from each client/carrier

·         Monitored the DX events from the B2B console

·         Worked as a part of Eligibility carrier loads team to extract and load the Medicaid and Medicare clients data

·         Developed informatica mappings to extract, transform and load the mainframes files into DB2 tables.

·         Worked on the design for the Intermediate /stage/ base tables for Medicare process.

·         Created intermediate/stage and base tables in DB2

·         Created shell scripts to ftp the file from EDI server to the informatica server for Carrier loads projects

·         Created mappings to extract the data from mainframes using informatica power exchange

·         Imported and row tested the data maps using power exchange navigator

·         Created etl /design specs for the project related requirements

·         Worked closely with the BA /QA team to efficiently design/develop and test the new process for Medicare

·         Successfully update the status of the projects in track plus/ version one.

 

 

Project Environment:

Informatica Power Center v 9.6.1, Informatica Power exchange 9.5.1, Passport, Db2, SQL Server , toad, Linux, track Plus, Version one ,service now

 

 

 

 Amdocs@AT&T, Richardson ,TX

 

eCDW Sunrise                                                                                                     Jan’16 – July’17

Sr. Data Architect

 

Responsibilities: 

 

·         Working as an Architect to design/develop/test/install/migrate/troubleshoot various ETL deliverables using Informatica,  Teradata, Vertica and UNIX shell scripts.

·         Leading a team of 3 in offshore

·         Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

·         Designed, Developed and tested the new ATT products like  DirectTV Now (OTT) , Connected Car , NFL SUNDAY TICKET, etc., to load the data in DWH and make the data available for the clients and the end users

·         Analyzed the existing systems and the business user requirements for tactical and strategic needs

·         Etensively created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing the data using Erwin datamodeller

·         Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation

·         Assisted team members in data modelling

·         Developed design documentation for all development efforts

·         Developed Logical and Physical Datamodels using Erwin tool to support the business

·         Interacted with the Clients and business users on regular basis to consolidate and analyze the requirements and present them the design results

·         Recommended process improvement for internal design methodology to facilitate Rapid Development

·         Mentored DA's on Erwin Data models, SCD's, CDC, standards - resolved multiple issues

·         Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts

·         Translated business requirements into design and technical specifications for implementation.

·         Collaborated with business analysts and offshore developers toward the implementation of changes, and worked with Quality Assurance (QA), and change management teams for IT releases to the data warehouse

·         Created AOTS  change tickets, trouble tickets for the changes requests (deployements) using BMCC Remedy User

·         Supported deployments and ensured all the changes have been validated and migrated successfully

·         Engaged in data analysis, technical design, documenting, coding, unit testing, deployment and maintenance of various data load modules.

·         Worked as a part of Agile team in delivering the code on time

·         Worked closely with the Teradata/ App DBAs to get the data models materialized in time 

·         Helped BI / Microstrategy team to create views to be used in their reporting documentation

·         Executing and Monitoring jobs using Maestro (TWS) scheduling tool

·         Creation of Runbooks / Deployment Readiness Packages / CRs etc,

·          

Project Environment:

Informatica Power Center v 9.1, IDQ, Oracle 9i (SQL, PL/SQL), Teradata ,Netezza, vertica UNIX, Rally,TDPlatform (agile methodology), Erwin ,Unix, Linux, TWS

 

 

eCDW Sales

Data Architect / Developer                                                                             April’14 – Dec ‘15

 

Responsibilities: 

 

·         Worked as an architect to validate the Retail data coming into enterprise data warehouse

·         Developed Informatica mappings  to extract , transform and load the data from different systems into eCDW Sales tables

·         Involved in every phase of project like gathering requirements, coding, testing and deployment

·         Developed all required documents required for deployement like deployment readiness package, etc.,

·         Developed Teradata utility scripts like TPT,BTeq, Mload

·         Analyzed and created logical and Physical Data models

·         Developed design documentation for all development efforts

·         Efficiently investigated production issues

·         Diligently performed code reviews on fixes

·         Effectively coordinated team efforts to ensure timely and successful project completion

·         Created tables, views, synonyms, procedures, functions in Oracle backend for Golden Gate process

·         Fine-tuned Oracle queries to improve performance

·         Implemented ETL methodology for designing and developing extraction, transformation and load processes using Informatica Power Center and IDQ

·         Successfully created mappings and mapplets in Informatica Power center Designer

·         Created tasks (session, command, event wait, even raise etc.), workflows and worklets in Workflow Manager

·         Developed Unix Shell Scripts to ensure successful execution of the ETL processes

·         Build a re-usable staging area in Oracle for loading data from multiple source systems using template tables for profiling and cleansing in

·         Created, maintained and stored manual Unit test cases, test plans using HP Quality Center

·         Actively involved in unit and system testing while moving code to production

·         Executing and Monitoring jobs using Maestro (TWS) scheduling tool

·         Developed design documentation for all development efforts

 

Project Environment:

Informatica Power Center v 9.1, IDQ, Oracle 9i (SQL, PL/SQL), Teradata ,Netezza, vertica UNIX, Rally,TDPlatform (agile methodology), Erwin ,CRM

 

 

OCX :

Developer

 

Responsibilities: 

·               Worked as a part of  OMS/OCX development team to source data from salesforce.com and to load the data successfully using Java coding(APIs), XMLs, Junits, JSP and SOAP UI

·               Created, maintained and stored manual test cases, test plans using HP Quality Center

·               Actively involved in unit and system testing while moving code to production

·               Strong knowledge of SOAPuI testing and loading data into Oracle tables for downstream apps using toad

·               Experienced with functional web services tests

·               Skilled with creating automated web services testing processes

·               Able to create data-driven tests using external sources

·               Excellent troubleshooting and problem-solving skills

·               Works well as a member of the web development team

·               Highly analytical and focused on details

·               Creative and has good critical-thinking abilities

·                

 

Project Environment:

XML, WSDL,SOAP UI, Java Junits, REST API,Salesforce.com , Ultraedit, ,oxyXML,TOAD, Oracle 9i

 

 

QDM/ Alliance :                                                                                 Apr’13 – Mar’14

Data Architect /Developer

 

Responsibilities: 

• Worked as a Data Architect for designing the audits on the incoming data from various sources into eCDW
• Actively involved in gathering requirements and acquiring application knowledge from Business Managers.
• Involved in designing the process flow for extracting the data across various systems interacting.
• Introduced design standards for ETL processes to enhance audit and support capability.

 

• Worked with different kinds of source databases involving Oracle, SQL Server, DB2 and flat files.
• Developed ETL routines using SQL Server Integration Services (SSIS) , Informatica PowerCenter

·         Published the data models to LAB(The Library of Alliance Blueprints) wiki website

·         Audited the data models according to the ACRE terms

·         Updated the Named Objects List data to see what is in Production today, as well as what is being worked on for a future release.

·         Acquired good understanding of the business and propose suitable audits for multiple projects loading data to data ware house tables

·         Worked with ST and UAT team to make sure code is working as expected and no sensitive data has been exposed

·         Worked with Data Governance team to establish a common set of Alliance Data Governance policies, practices and processes to define and maintain common metadata, business rules and data integrity through the data/metric lifecycle

·         Ensured compliance with standard software development practices, processes and enterprise standards

• Involved in unit testing and system testing while the code is moved to production
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Written and used UNIX shell scripts for scheduling and pre/post session management.
• Executing and Monitoring Jobs using Control-M.
• Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by

provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.

 

Environment: SSIS , Oracle 11g, UNIX,  SQL Server 2000/2005, Erwin 7.0.

 

                                                                                                                   Jul’12 – Mar’13

eCDW Project:   

ETL Developer 

Project Role:

·         Analyze and identify the eCDW tables (existing/new) in which CTMS source data can be integrated.

·         Identification of appropriate data types

·         Direct sourcing and integration of data to the data warehouse

·         Created targets and sources and added their definitions to the repository

·         Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, 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. 

·         Used workflow manager for session management, database connection management and scheduled the jobs to run in the batch process

·         Troubleshoot the issues by checking sessions and workflow logs.

·         Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.

·         Written and used UNIX shell scripts for scheduling and pre/post session management.

·         Extracted data from Flat Files and transformed and loaded into Oracle database and vice versa

·         Developed design documentation for all development efforts

·         Worked with BI team in creating views required for their reporting purpose

·         Creation of Runbooks for the IPC workflows

·         Dev folder  and mapping comparisons

·         Ran TPT and Bteq scripts for loading the data into Teradata stage and ODS tables

·         Created Ireports ( Jasper Reports) for the requirements

·         Worked on Deployment Guide for ST and Production deployment

·         Installed Hadoop Hive on VM env for the team usage

·          

 

 

 

 Environment: Informatica Power Center 8.6.1/9.1, Oracle 11g,  SQL Developer, TOAD, Unix Shell Scripts, Windows 7, Teradata, SQL Assistant, Ireports 4.7.1, Hadoop, Hive, VM env

 

 

 

TWEDDLE GROUP TECHNOLOGIES, Seattle, WA

Informatica, PL/SQL Developer                                                                                                                      Oct’11 –Jun’12

Project Role:

 

·         Managed the process of requesting the change, assessing changes, authorizing changes and reviewing changes

·         Created targets and added their definitions to the repository

·         Responsible for processing FDF (Factory Data Feed) and RDR (Retail Data Read) files received from Toyota/Lexus to generate VIN and User access to Entune/Enform Application

·         Developed PL/SQL code to generate access to Entune/Enform Applications to the users

·         Extracted data from Flat Files and transformed and loaded into Oracle database and vice versa

·         Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.

·         Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

·         Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

·         Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

·         Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

·         Developed materialized views for data replication in distributed environments.

·         Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

·         Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.

·         Loaded Data into Oracle Tables using SQL Loader.

·         Partitioned large Tables using range partition technique.

·         Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.

·         Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.