Manager Data

Sreedhar Mami

Senior Informatica Consultant

E-mail: ****************@*****.***

Phone: 309-***-****

Summary

* ***** ** **** ********** with diverse range of technical/management skills which

includes Informatica Power Center, Informatica Test Data Management, Talend, MS-BI

and Project management skills

Awarded as one of the TOP 3 contributors for Q3 2013, Informatica My Support Forums

from Informatica by posting more than 500 threads in a quarter

Good knowledge in full life cycle of ETL (Extraction, Transformation and Loading)

be it Informatica Power Center (Repository Manager, Mapping Designer, Workflow

Manager & Workflow Monitor), SSIS or Talend

Expertise in using multiple Informatica transformations like Source Qualifier,

Expression, Filter, Router, Rank, Sorter, Aggregator, Joiner, Look up, Update

stragety Sequence Generator etc.

Experience in data extraction from heterogeneous sources like Flat Files, Oracle,

SQL Server using ETL tools (Informatica Power Center, Talend, SSIS)

Knowledge Genie in Informatica Test Data Management (Data Masking Tool) for data

subset and data security

Specialized in identifying long running sessions and apply Performance Optimization

by tweaking buffer blocks at Informatica Session Properties level

Experience in tuning Sql that is used in Sql Override of Source Qualifier

transformation and apply Indexes where ever required

Innovative in process automation like alerting mechanism for Informatica Session

Failures, workflow failures and services being down

Developed ST Mappings document including transformation rules based on business

requirements

Experience in data validation for sources and targets including unit test plan

document as per Informatica Standard Pratices

Ability to create complex mappings like SCD's and complex workflows depending on

business requirements

Experience in Informatica Administration Skills like Installation, creation of

Repository Service, Integration Service, Model Repository Service, Data Integration

Services, LDAP configuration, creation of groups and assigning permissions

Familiar in using database application tools like Toad, Sql Developer and Sql Plus

Experience in Deployment Groups to migrate objects from one environment to another

environment using Repository Manager

Conducted training sessions on various transformations, usable and reusable

sessions, worklets and workflows

Experience in upgrading the Power Center Versions (861 to 910, 950, 951) and

migrating Repository Objects

Proven track record in Sql Server Partitioning, Shrinking database, releasing of

unused space to disk and maintenance of Index on a regular basis

Superior communications skills in dealing with clients and employees- both verbal

and written

Ability to grasp technical and business concepts as per the requirements, and

quickly deliver a credible solution

Respond quickly to changing situations; work well under pressure while maintaining

individual and team effectiveness

Technical Skills

Data Warehousing Informatica Power Centre 8.x,910, 950, 951& SSIS

Tools

Databases Oracle 11g/10g/9i, MS Access, MS SQL Server

2005/2008/2008R2/2012

Business Business Objects, MSBI (SSIS), Talend

Intelligence Tools

Other Tools & SQLPLUS, TOAD, SQL Developer, PG Admin for PostGreSql, SQL &

Languages PL/SQL

Scheduling Tools Informatica Schedular, IBM Maestro Tivoli

Environment Windows Server 2003, Server 2008, 2008 R2, Windows

7/Vista/XP/Millenium/98, Unix, Linux

Monitoring Tools Whats up Gold, Automation of Oracle in Excel for Repository

Database

Data Masking Tools Informatica TDM (Test Data Management), Data Subset and

Persistent Data Masking and Dynamic Data Masking (DDM)

Project Profiles

PPL, Allentown, PA Aug 2013 - Present

Senior Informatica Consultant

PPL, formerly known as PP&L or Pennsylvania Power and Light, is an energy company

headquartered in Allentown, Pennsylvania, USA. It owns or controls about 19,000

megawatts of generating capacity in the United States, sells energy in key U.S.

markets and delivers electricity and natural gas to about 10.3 million utility

customers in the United States and the United Kingdom

The intent of the project is to upgrade their Informatica Environment from 8.6.1 to

9.51. HF2 on Linux machine and to manage/support a mature BI/DW system, providing

the skills, tools and processes necessary to keep the system performing at the

highest levels.

Responsibilities:

Gathered repository information and analyzed the existing environment

Created Project Plan at high level and also detailed level including milestones and

resources

Consolidated Corp and E+ Informatica Environments hosted on two different servers

Analyzed critical workflows under each subject area and upgraded them at utmost

care before the other workflows being upgraded

Migrated Informatica mappings from Unix (8.6.1) environment to Linux (9.5.1 HF2)

Upgraded Informatica mappings subject area wise, including Scripts

Performed unit test and validated Informatica workflows/sessions after the upgrade

Resolved issues incurred due to Informatica Power Centre upgrade

Reported Informatica technical bugs to Informatica Technical Support Team faced

during the process of upgrade

Automated core file generation, Informatica services, modified production objects

in last 24 hours using alerting mechanism

Optimized performance for long running sessions/workflows

Resolved data issues of Business users by debugging reporting analysis and ETL

mappings

Gathered requirements from business users and analyzed to modify existing subject

area ETL design

Modified existing mappings/sessions where ever required

Created new mappings/sessions/workflows with respect to requirements and ST mapping

design document

Scheduled workflows on IBM Maestro Tivoli using Job Stream and Jobs

Scheduled jobs based on workflow dependencies (external and internal)

Copied subset of secured data from Production database to development and Testing

environments using Informatica Test Data Management by applying masking techniques

Resolved Informatica failures by investigating session logs from workflow monitor

and closed Service Now tickets (Project Management) that are generated by ANS

(Automated Notification System)

Promoted Workflows from Dev to test and Test to production using Deployment groups

from Repository Manager

Clarabridge, USA November 2012 - July 2013

Consultant

Clarabridge provides text mining solutions to Fortune 1000 customers based on their

customer survey data. Clarabridge content mining platform (CMP) product process

unstructured data through various transformations and convert to structured data

format for further analysis and review results through BI reports.

Responsibilities:

Extensively used Source Analyzer/Target Designer/Mapplet Designer/Transformation

Developer/Mapping designer

Designed and developed various mappings using Source Qualifier, Expression, Joiner,

Aggregator, Filter, Router, Look up, update Strategy, Sorter, Sequence Generator

transformations

Created various sessions and workflows using workflow manager

Scheduled Workflows using Informatica Workflow Monitor tool as per business needs

(Daily/Weekly/Monthly and Quarterly)

Monitored workflows as per their scheduled timings and take immediate action in

case of failure, fetching the Session logs

Interacted with Engagement Managers and Support team for Critical issues to resolve

their queries

Mentored the team and provided status updates on a weekly basis to Technical

Manager

Ensured SLA is met on production failures by proactively working on them suggesting

the best possible solution

Worked on Text Analytics Tool like assigning permissions to business users and also

create/delete/assign relevant permissions to the users on BI Platform

(MicroStrategy and Cognos)

Monitored more than 150 clients servers on Whats Up Gold (Monitoring Tool) and take

appropriate action if they go down

Razorfish, PA July 2011 - October 2012

ETL Developer

Razorfish Inc. (formerly Avenue A Razorfish (AARF)) is one of the world's largest

interactive agencies and one of the largest buyers of advertising space. Razorfish

provides services to its clients in the areas of digital advertising and content

creation, media buying, strategic counsel, analytics, technology and user

experience. Their goal is to create, plan and handle advertising for their clients.

Their marketing and design capabilities, rooted in digital combine user insight,

technology and creativity.

Responsibilities:

Involved in Source System Study, gathered / analyzed requirements and built a data

warehouse for various clients

Engaged as Database Administrator like assigning permissions to users, security

related issues, Partitioning, Shrinking database, releasing of unused space to disk

and maintenance of Index on a regular basis

Managed and compiled documentation for all ETL processes; increased the performance

optimization for long running sessions/workflows

Designed ETL as per business requirements

Developed various Mappings/Sessions/Workflows using Power Centre Mapping Designer,

Workflow Manager

Focused on instrumentation (Logging/Auditing) and notification while designing ETL

packages, worked on reusable components while designing

Scheduled workflows to load data to warehouse for reporting purpose and also for

business users

Gained good knowledge on other technologies like Talend (Open Source ETL tool) and

SSIS (Sql Server Integration Services)

Worked proactively with team members, business customers, business analysts,

developers and DBA's to create innovative analytical solutions

Resolved on call support issues for various production servers

Followed Kanban process in JIRA ticketing system to keep track of Production

Support Issues

Automated various processes like Disk Space Alert, Log alert, Capturing user's

queries and create/delete user logins

Triad Financial Corporation, USA

Software Developer July 2010 - June 2011

Triad financial Corporation fulfills the financing needs of consumers across the

United States. Their mission is to be the non-prime auto finance company of choice

for their Customers, Employees and Shareholders. The principal object of this

project involved working with a financial data mart that was periodically fed from

various sources, apply business logic as per the requirements and load the data

into data marts

Responsibilities:

Gathered requirements, analyzed and created ST mappings for ETL design

Delivered supporting end-to-end source to target mapping and transformation logic

for ETL processing

Designed and developed mappings using Source Qualifier, Expression, Lookup, Router,

Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and

Rank transformations

Used extensively Informatica client tools like Source Analyzer, Target Designer,

Mapping designer, Mapplet Designer and Transformation Developer, Workflow Manager,

Workflow Monitor, etc.

Created sessions, configured workflows to extract data from various sources to

loading into data mart

Developed mappings, workflows to extract data from various sources like oracle,

flat files and load them into oracle database

Developed complex mappings and SCD type-I and Type-II mappings in Informatica to

load the data from various sources using different transformations like Source

Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update

Strategy, Sequence Generator, Joiner, Filter, Rank and Router

CarMax, USA June

Software Developer 2009 - June 2010

CarMax was built on the idea that there had to be a better way to buy a used car.

This project is aimed at evaluation of sales performance of the Business covering

the consumer products. Data warehouse is designed for the purpose of Sales Analysis

that basically helps the decision makers to analyze the sales patterns. The main

achievement of this project is to improve the sales forecasting by identifying key

factors like the total sales revenue on the monthly and quarterly basis on the

region and the sale amount.

Responsibilities:

Involved in understanding and documenting the requirements of Business analysts and

Corporate Managers

Participated in the entire life cycle of the project - understanding scope,

functionality, technical design and complete development

Involved in extraction of data from various sources like flat files and Oracle

database

Implemented Filter, Router, Expression, Lookup, Update Strategy, Sequence

generator, and Aggregator transformations

Created reusable transformations and used in different mappings

Developed incremental and updateable loading through Informatica mappings

Created SQL scripts during pre and post load of data

Scheduled several workflows for its execution

Used workflow manager for session, database connection management and scheduling of

jobs

First Group - UK, March 2007 - March 2009

Engineering Analyst

First is UK's leading transport company transports more than 3 million passengers

around the country every day. Leeds, nestled in one of the Great Britain's most

beautiful areas employs more than 1500 people with leading bus operator in West

Yorkshire region.

The project aimed to build a warehouse for Engineering department collecting data

from various sources. The company has 4 departments where it fetches data from

Engineering, Operations, Finance and Administration. The prime focus is to study

the existing source system, analyze the requirements and fetch data to warehouse

which has more than hundred dimensions and 5 fact tables.

Responsibilities:

Involved in Business process right from source study requirements and analysis

Extracted functional requirements from regular meetings and translated those

requirements into detailed business requirements

Developed Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data

loads

Co-ordinated with Source System Owners for proper data feeds and Defaults for the

Incoming Data

Populated data into staging tables from flat files and Relational Sources

Prepared Unit Test Plans, verified functional specifications and reviewed

deliverables

Gained significant experience on interacting with employees from different

departments within the company and external clients

Managed a team of 15 from Engineering department in the absence of supervisor

Instore DC, UK September 2004 -

Business Analyst November 2006

Responsibilities

Worked as part of a close-knit team to develop mappings/sessions for stores orders,

distributing orders according to the business requirements

Gained good knowledge on different transformations like Source Qualifier,

Expression, Filter, Router, Sorter, Rank, Aggregator, Look up, Update strategy

Worked on time deadlines, travelled extra miles to meet the challenges

Acquired immense knowledge on reusable and non reusable transformations, sessions,

worklets and workflows

Extracted data from heterogeneous sources like flat files and tables from Oracle

data base

Fully complies with all company health & safety policies and practices

Education

Master of Science, University of Huddersfield, September 2006

UK.

Major: Embedded Systems Engineering

Bachelor of Technology, Kakatiya University, April 2003

Andhra Pradesh

Major: Electrical and Electronics Engineering

Contact this candidate