Mahesh
Rao
Date of Birth: 1 Jan 1982 Gender: Male Nationality: Indi a hyderabadPhone: Not specified Mobile: 91-9885524901 Email: [email protected] m Alternate email: [email protected] m
Current Location: Hyderabad
informatica
Work Experience : 2 years 9 months Skills : informatica
Domain Knowledge : IT/ Computers - Software Industry : IT/ Computers - Software
Category : IT
Roles : Software Engineer/ Programmer Current Employer : Accenture
Current Annual Salary : 3.00 lacs per annum
Work Authorization : Need H1 Visa - Authorized to work in India
Highest Degree Held : M.Sc, Computers, Nagarjuna University 2nd Highest Degree
Held : B.Sc, Computers, Nagarjuna University Preferred Job Location : Anywhere
Skill
Name Last Used Skill Level Experience Oracle Mar 2011 Intermediate 2 months
Maheswara Rao .B.V Email: [email protected] Contact: 9885524901 CAREER OBJECTIVE
Looking for a challenging and Responsible position in the field of Information Technology and have the flexibility to adapt to any new environment and work on any project wish to utilize this experience in an organization as part of them PROFESSIONAL SUMMARY
A highly dedicated and Dynamic Professional around 2.10 years of Experience in Data warehouse implementation
using Informatica tool as ETL-Developer. Main areas of expertise are analyzing, developing and testing the data warehousing
projects.
Experience in Development of mappings using needed Transformations using Informatica tool.
Experience in the Data Warehousing using Data Extraction, Data Transformation and Data Loading.
Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
Preparing the Documentation for the mappings according to the Business Requirements. Good Knowledge on Data Warehousing
concepts like Star Schema, Dimensions and Fact tables.
Optimizing Informatica Mappings and Sessions to improve the performance. Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet
Designer, Informatica Repository Manager and Informatica Workflow Manager Possess complete domain and development Life Cycle knowledge of Data Warehousing. Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.
EDUCATION
Msc Computer Science from Nagarjuna
University, SSN PG college ongole, 2006-2008. WORK EXPERIENCE
Presently working in TATA
CONSULTANCY SERVICE, Hyderabad from Ju ne-2008 to till date.
SOFTWARE PROFICIENCY ETL Tool Informatica Power Center 8.1.1/7.1.2
Database ORACLE 8i/9i,10g, SQL Server 7.0, Microsoft Access Operating
Systems UNIX, Windows
1.) PROJECT
NAME APO(Advanced Planning Optimization) Client ELI LILLY, US
Period June -2008 to Aprl-2009 Solution
Environment Informatica 8.5, Oracle 10g, Windows 2000, TOAD Role Informatica Developer Domain Pharma
Description:
The project comprises of various applications across various platforms. These applications cater to provide data to various marketing groups of a major pharmaceutical company. The data is received from an external vendor, is processed and then loaded in various databases and supplied to the respective business owners for further analysis and processing Responsibilities:
Designed the Mapping Technical Specifications on the basis of Functional Requirements.
Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts. Involved into source code review,the mappings created by my team members.
Prepared deployment document and assisted to deployment team while migration.
Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
Tested the Informatica mappings with manual testing and assisted QA team.
Involved in creating test scripts.
Developed different mappings by using different Transformations like Aggregator, Lookup,
Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
Monitored transformation processes using Informatica Workflow monitor.
Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.
2.) PROJECT
NAME Bank of Montreal Management System Client Bank of Montreal, Canada Period May2009 to March-2010 Solution
Environment Informatica 6.2, Oracle 8i, Windows 2000, TOAD Role ETL Developer
Domain Banking Description:
This project is involved in the development of data warehouse for BOM based on four kinds of data marts such as Accounts, Loans, Credit Cards and Insurance. Each data marts represent a collection of data pertaining to a single business process. In loan data marts BOM Involved in disbursal of loan amounts for various purposes like: Personal Loan, Educational Loan, Vehicle Loan, Housing Loan etc. The company requires different levels of analysis regarding loan amount, type of loans, type of customers, type of payment schedules, interest rates (variable or fixed), defaulters list and the penal interest calculations etc. They needed a Data Warehouse so that they could maintain historical data and central location for integration, analyze business in different locations, according profit areas, which could serve a purpose of a DSS for decision makers.
Responsibilities:
Mainly involved in ETL developing.
Analyzed the Sources, targets, transformed the data, and mapped the data and loading the data into Targets using Informatica.
Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator
are mainly used.
Creating the mapping and transformations using Informatica
Creating the reusable mapping using mapplet designer and that Mapplets are used in mapping Using ETL process to Extract, Transform and Load the data into stage area and data warehouse. Preparing the Documentation for the mappings according to the Business Requirements.
3.) PROJECT
NAME Banking Management System Client Shinhan Bank, Korea
Period April -2010 to still date Solution
Environment Informatica 6.1, Oracle 8i Role ETL Developer
Domain Banking Description:
This project is to provide different reports and support business queries for making intelligent banking decision based on data available in various branches across the country collected over a period of time. Bank wants to have tool, which will help it analyze the current business trends and to make predictions for future business trends. Bank is especially focused on getting the analytic information about targeted customer group, loss making schemes, session wise financial analysis …etc. The bank wants to aggressively launch new product for its loan and deposit customer in a very competitive market for which it wants the edge in identifying key customer on various age group to lure them to buy their product.
Responsibilities:
Creating Informatica mappings, mapplets and reusable transformations.
Design and Development
of Informatica mappings with Error logging logic's. Creating session & scheduling of session for loading data.
Coding and testing SQL*Loader control files to load data from various data files into Oracle tables. Created various Transformations like Lookup, Joiner, Aggregate, Filter, Expression, Router, and Update Strategy.
Perform debugging and tuning of mapping. Involved in preparation of test cases and testing of mapping.
Preparation of ETL mapping documents. PERSONAL PROFILE
Name : BV.Maheswara rao Nationality : INDIAN
Status : Unmarried Permanent
Address : 2-266, Nehru nagar, Guntur Road, ongole-523002(AP). Contact
Address : SR nagar, Hyderabad-5000082. [email protected] +91-9035167263
Vibha
Venkannagari
Date of Birth: Not Specified
Gender: Female Nationality: United States
Phone: 1--408.657.4648 Mobile: Not specified
Email: [email protected] m
Current Location: US
Informatica
Work Experience : 7 years 1 month Skills : Informatica Domain Knowledge : IT/ Computers - Software
Industry : IT/ Computers - Software
Category : IT
Roles : Software Engineer/ Programmer Current Employer : JPMorgan Chase Current Annual Salary : Not Specified Previous Employer : PNC Bank
Highest Degree Held : B.E/B.Tech, Computers, JNTU,Hyderabad Preferred Job Location : US
Skill
Name Last Used Skill Level Experience Informatic a Not specifie d Exper t 48 months Vibha Venkannagari Professional Summary:
• Over 7 years of IT experience
in Business Requirements Analysis, Data Modeling, Application Design,
Development, Testing, Implementation and Support for Data Warehousing applications.
• Over 5 years of Extensive
experience in developing ETL solutions using Informatica Power Center.
• Developed and designed ETL
methodology for supporting data transformations and processing, in a corporate wide ETL Solution using
Informatica Power Mart / Power Center
5x/6x/7x/8x/9x.
• Created mappings using
various transformations like Lookup, Aggregator, Expression, Source Qualifier, Joiner, Update Strategy, Router, Sequence Generator, Normalizer Transformation etc.
• Extensively worked on
Performance Tuning of ETL mappings and sessions.
• Experience in the design and development of Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), addressing Slowly Changing Dimensions
(SCDs).
• Involved in upgrading of
Informatica power center 6x to 7x and 7x
to 8x
• Extensively worked on
Informatica Designer Components -
Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Analyzed the session, event
and error logs for trouble shooting mapping sessions.
• Performed various kinds of
testing like Integration, Unit and User Acceptance testing.
• Extensively used SQL
statements while performing ETL process and applied Query.
• Setting up sessions to schedule
the loads at required frequency using Power Center Workflow manager, PMCMD.
• Strong exposure to metadata
manager.
• Strong expertise in Relational
data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS
Access, Teradata design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL LOADER.
• In-depth understanding of Star
Schema, Snow Flake Schema,
Normalization, 1st NF, 2nd NF, 3rd NF, Fact tables, Dimension tables.
• Proficient in writing UNIX Shell
Scripts for scheduling.
• Experience in SQL Plus and
TOAD as an interface to databases, to analyze, view and alter data.
• Highly proficient in writing,
testing and implementation of triggers, stored procedures, functions,
packages, Cursors using PL/SQL.
• Experience in working with
scheduling tools like Autosys, Control M
• Knowledge of reporting tools
like Cognos and Business Objects.
• Outstanding communication
and interpersonal skills, ability to learn quickly, good analytical
reasoning and high compliance to new technologies and tools.
Technical Skills:
ETL Tools: Informatica Power Center, Power Exchange, IDQ
Analysis/Reporting Tools:
Business Objects, Cognos
Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, MS Access
DB Tools: SQL*Plus, SQL*Loader, TOAD
Operating Systems:
UNIX (LINUX), WINDOWS XP/ 2000/98/95
Languages: C, VB.Net, SQL, PL/SQL, UNIX, Shell Scripting
Data Modeling: Dimensional Data Modeling, Star/Snowflake Schema, Fact
And Dimension Tables, ERWIN
Scheduling/ Tools:
Professional Experience:
JPMorgan Chase, Delaware Aug’10 –
Present
Informatica Developer
JPMorgan Chase is one of the oldest financial institutions in the United States. They are a leader in
investment banking, financial services for consumers, small business and commercial banking, financial
transaction processing, asset management and private equity. Corporate Data Warehouse serves as the
centralized repository for the bank's assets and liabilities. Transactional data from the loans,
deposits, home equity and other legacy applications is fed to the data warehouse on a daily basis. CDW
provides the ability to analyze the exposures at a cross product level and generate various reports (on
demand & canned reports) for analysis and helps the user in monitoring and controlling the exposures.
Responsibilities:
• Designed/Developed ETL
mappings/workflows using Informatica
Power Center 8.x with source/target as Oracle and MS SQL Server for
implementing account, customer,
securities, sales, marketing and operations users to have access to the single
consolidated view of the data.
• Used ETL methodology for all
data loads and developed mapping specifications and transformation logic to implement business logic.
• Extensively used Informatica
Power center and created mappings using transformations like Source
Qualifier, Joiner, Aggregator, Expression, Filter, Router, Update Strategy, and Sequence generator.
• Used Lookup Transformation to
access data from tables, which are not the source for mapping and also
used Unconnected Lookup to improve performance.
• Worked with Informatica
Debugger to debug the mappings in Designer.
• Used Workflow Manager for
Creating, Validating, Testing and Running the sequential and concurrent
Batched and Sessions, and scheduled them to run at a specified time.
• Develop complex mappings
such Slowly Changing Dimensions Type II - Time Stamping in the Mapping
Designer.
• Involved in upgrading of
Informatica power center 7x to 8x.
• Worked with business analyst,
source application developers and report developers to identify and
resolve data issues between the source systems and the CDW.
• Involved in business
requirements review. Developed the design specifications for the ETL process
testing
Environment: Informatica 8.6.1/7.1, ORACLE 10g/9i, SQL Server2005, UNIX (LINUX), Windows XP, Shell
Programming, TOAD, Business Objects.
PNC Bank, Lawrenceville, NJ Jan’09 - Jul’10
Informatica Developer
PNC is one of the nation’s premier financial organizations. They offer a wide range of services for all
customers. Middle office Data Mart(MODM) is a data-warehousing platform compiling trade data originating in
the Bank’s trading desks, validating it against their Settlement functions, enriching it with market and
company static data and also taking on trial balance and general ledger data. MODM serves as the primary
application for much of the bank’s regulatory requirements.
Responsibilities:
• Worked closely with end users
and business analysts for requirement gathering and analysis
• Responsible for data analysis.
• Extensively used ETL to load
data from fixed width and delimited Flat files.
• Extensively worked with
Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed
complex mappings, from varied
transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner and Update Strategy.
• Created ftp connections,
database connections for the sources and targets.
• Worked with Variables and
Parameters in the mappings to pass the values between sessions.
• Implemented Type I Slowly
Changing Dimensions.
• Created reusable
transformations and Mapplets and used them in complex mappings.
• Setting up sessions to schedule
the loads at required frequency using Power Center Workflow manager, PMCMD and also using scheduling tools. Generated completion messages and status reports using Workflow
manager.
• Created workflows and
worklets for designed mappings.
• Working on Dimension as well
as Fact tables, developed mappings and loaded data on to the relational database.
• Wrote session commands to
configure pre-session and post-session tasks.
• Created Event Wait, Event
Raise, Timer and Control Events in workflow manager according to the business requirement.
• Extensively worked in the
performance tuning of programs, ETL procedures and processes.
• Used Informatica Data Explorer and Informatica Data Quality for Data Quality Management and Data profiling purposes.
• Tested data using IDQ
(Informatica data quality) to resolve
inconsistencies in data.
• Used reverse engineering in
Erwin 4.x to understand the existing data model of the data warehouse.
• Participated in upgrading
process of Informatica power center from 6x to 7x
• Performed the troubleshooting
when the workflows fail in loading the data.
• Performed unit testing and
Involved in tuning the Session and Workflows for better performance. Environment: Informatica Power
Center/Power Mart 8.1/7.1/6.2, Oracle 9.2, Workflow Manager, PMCMD command, IDQ, PL/SQL, SQL, SQL*PLUS,
SQL*LOADER, Business Objects, ERWIN, UNIX Shell Scripting , Windows XP.
Hartford Insurance, CT Feb’08 - Nov’08
Informatica Developer
Hartford Financial Services is one of the largest insurance and investment companies based in United States. They are a leading provider of life insurance, group and employee benefits, automobile and homeowners
insurance and business insurance. Wealth Insurance Group primarily servers the single platform for high
net-worth and ultra-high net worth individuals. Wealth Insurance Data Warehouse(WIDW) insurance serves the business involving Home, Auto, Private Collections, workers compensation and Yacht etc. The system receives
the data from several legacy OLTP systems and other external vendors and helps the business as a single point
of source for all the reporting requirements of the group.
Responsibilities:
• Worked on Source Analyzer,
Warehouse Designer, Mapping Designer,
Mapplet Designer and
Transformation Developer
• Identified and tracked the
slowly changing dimensions,
heterogeneous Sources and determined the hierarchies in dimensions
• Extraction, Transformation and
loading of data from flat files and oracle sources into oracle
database. Created Informatica Mappings and Mapplets using different
transformations
• Involved in Performance tuning
for better performance
• Responsible for automation of
ETL processes using Autosys
• Responsible for Creating
workflows and worklets. Created Session, Event, Command, Control Decision and Email tasks in Workflow Manager
• Analyze data quality and
report the anomalies to business users using TOAD
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for
tables, Email tasks and various other applications
• Involved in Unit, System
integration, User Acceptance Testing of Mappings
• Involved in the production
support by monitoring the workflows and resolving the problems in the
production
Environment: Informatica Power Mart 7.0, Oracle 9i/8i, Shell Scripting, SQL, PL/SQL, TOAD, and UNIX (LINUX), Windows XP, Autosys.
Fossil, Richardson, TX
Sep’06 - Dec’07 Data Warehouse Developer
Fossil is a leader in the design, development, and distribution of contemporary, high quality watches, Apparel, and accessories. In order to quickly identify customer needs and improve services to its huge
subscribers, a business intelligence system
was implemented using Informatica
Power Mart software. With Power Mart a large amount of customer-related data was collected from diverse sources which included customer
billing, ordering, and support and service usage. Business users then analyzed this data to understand which
customers stayed the longest with the service and why and to gauge the effectiveness of promotional activities. The results have improved customer-retention efforts and more focused effective customer
promotions. Responsibilities:
• Involved in developing Data
Warehouse using Star schema.
• Involved in conducting design
sessions and reviews. Communicated with the users to observe various
business rules in implementing the data warehouse.
• Analyzed the requirements,
functional specifications and identified the source data to be moved to
the Data Warehouse.
• Developed mappings using
Informatica Power Center Designer.
• Configured Informatica with
different source systems.
• Developed PL/SQL stored
procedures for loading data into the data warehouse.
• Created, scheduled and
monitored the sessions and batches using Workflow Manager.
• Configured Workflow manager
to commit the expected rows.
• Worked with the pre session
and post session settings and Flat files.
• Developed the work flow
diagrams and worked with technical specifications.
• Defined the program
specifications for the data migration programs, as well as the necessary test
plans used to ensure the successful execution of the data loading processes.
• Involved in developing the
mapping, which contains all the Lookups used by all the facts to improve
performance.
• Involved in Performance tuning
of mappings and sessions. Environment: Oracle8i, PL/SQL,
Informatica Power Mart 6.2, Windows
2000, Erwin, UNIX (LINUX).
ICICI Bank, India Jun’05 – Aug’06
ETL Developer
ICICI Bank is India’s second-largest bank. They offer a wide range of banking products and financial
services to corporate and retail customers through its subsidiaries in the areas of investment banking, life
and non-life insurance, venture capital and asset management. The system helps the customer service
representatives to deal and transact with customers loan, credit, debit, portfolios, investment etc. The
operational data of different financial departments loaded into central Data Warehouse and transformed into different regional data marts. The various corporate metrics/web reports like Credit Profile, Product
Profile, and Funds Transfer etc…are generated periodically. Informatica
PowerCenter is used to extract the base tables in the data warehouse and the source databases include Oracle.
Responsibilities:
• Involved in the requirement
definition and analysis in support of Data Warehousing efforts.
• Created Repository using
Repository Manager.
• Worked Extensively on
Informatica tools -Repository Manager,
Designer and Server Manager.
• Involved in Extraction,
Transformation and Loading (ETL) Process.
• Created the Source and Target
Definitions using Informatica Power Center Designer.
• Developed and tested all the
backend programs, Informatica mappings and update processes.
• Created and Monitored Batches
and Sessions using Informatica Power Center Server.
• Tuned the mappings to
increase its efficiency and performance.
• Used Informatica Workflow
Manager to create workflows
• Workflow Monitor was used to
monitor and run workflows
Environment: Informatica Power Mart 5.1, Oracle 8i, UNIX, TOAD, SQL * Loader, Windows XP.
Insight Innovative Solutions, India Feb’04
- Apr’05 MS SQL Server Developer
Insight Innovative Solutions is a leading provider of information technology, consulting, web designing, web
hosting, domain name registration, marketing and business process outsourcing services. Insight Innovative Solution’s single-minded mission is to consistently outperform client’s best vendors by a nominal margin, thereby creating the most efficient customer centric enterprise for Clients and customers.
Responsibilities:
• Designed logical / physical data
models and defined primary key, foreign key using Erwin tool.
• Wrote SQL statements using
DML and DDL for retrieval of the data.
• Developed stored procedures,
functions, views and triggers.
• Actively participated in
gathering of User Requirement and System Specification.
• Created new database logical
and physical design to fit new business requirements, and implemented new design into SQL Server 2000.
• Created Users and Roles, and
managed security and permission of database.
Environment: SQL Server 2000, ASP .Net, Excel, Windows 2000
RamaKrishna
Ganni
Date of Birth: Not Specified
Gender: Male Nationality: United States
Phone: 1--972.782.9943 Mobile: Not specified
Email: [email protected] m
Current Location: US
Informatica
Work Experience : 7 years Skills : Informatica Domain Knowledge : IT/ Computers - Software
Industry : IT/ Computers - Software
Category : IT
Roles : Software Engineer/ Programmer Current Employer : Wells Fargo Current Annual Salary : Not Specified Previous Employer : Global Wireless Solutions
Highest Degree Held : B.E/B.Tech, JNTU,Hyderabad Preferred Job Location : US
Skill
Name Last Used Skill Level Experience Informatic a Not specifie d Exper t 48 months RAMAKRISHNA GANNI CAREER OBJECTIVE:
Objective: Around 7 years of experience in System Analysis, Design, Development, Implementation, and Testing
and implementation of business applications with RDBMS, Data Warehouse/Data Mart, ETL, OLAP, Client/Server
environment applications for Financial, Pharmacy and Insurance Verticals. Five-plus years of solid ETL data
integration and Data Warehouse experience using Informatica Power Center 8.6/8.1/8.0/7.1, Power Mart, Client tools – Mapping Designer, Workflow Manager/Monitor and Server tools –
Informatica Server Manager,
Repository Server Manager.
SUMMARY:
7+ Years IT experience in
Databases, Data Warehousing & Decision Support Systems.
Over 6 Years experience in
the Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center/ Power Exchange 8.0/7.0/6.x.
Experience with the SQL/
PL-SQL in Oracle, PL-SQL Server, DB2, MS-Access as RDBMS with Procedures, Functions, Triggers and SQL * Plus.
Experience with handling
Workflow Manager, Workflow monitor and Repository Manager.
Identification of User
requirements, System Design, writing Program specifications, Coding and implementation of the Systems.
Data analysis and profiling for
source and target systems and Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
Expertise in developing and
running Mappings, Sessions/tasks, Workflows, Worklets and Batch processes
on Informatica server.
Experience in Database
design, entity relationship modeling and dimensional modeling using Star and Snowflake schemas.
Experience of modeling tool
using Erwin 7.x/4.x Tools
Extensively worked with
mappings using different transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Update Strategy, Unconnected / Connected Lookup, Aggregator and SCD Type-1, 2&3.
Experience in tuning Mappings
and Sessions for better Performance.
Experience of unit testing of
each mapping what we developed.
Extensively worked on
creating, executing test cases and test scripts using Manual/Automated methods.
Worked in Production support
team for maintaining the mappings, sessions and workflows to load the data in Data warehouse.
Experience in writing Triggers,
Stored Procedures, Functions, and Packages using PL/SQL.
Experience in UNIX Shell
Scripting.
Sound theoretical and
practical background in the Principles of Operating systems and Multi-threaded applications.
Highly motivated with the
ability to work effectively in teams as well as independently.
EDUCATION :
Masters in Computer Science TECHNICAL SKILLS :
OPERATING SYSTEMS Windows XP Professional, Server 2003, HP UNIX, Linux
ETL Tool Informatica ,Power Center
8.x/7X
WEB TECHNOLOGIES HTML, DHTML, XML
LANGUAGES C, C++, PL/SQL,
JAVA, VB, .NET, J2EE, SQL, JCL and JMS
SCRIPTING LANGUAGES TSL, Java Script, VB Script, HTML, CSS, Perl, UNIX Shell,
DATABASES Oracle
9i/10g/11g, SQL Server 2005, MS-Access and DB2
WEB SERVERS Web Logic,
Apache 2.0., LDAP, LAMP, DNS, NIS
Other TOOLS Toad, Putty, Tel
Point, Visio, Remedy and Share Point, Mercury Quality Center, Version Control tool
PROJECT/WORK EXPERIENCE:
PROFESSIONAL EXPERIENCE:
ORGANIZATION DESIGNATION DURATION
Wells Fargo Informatica Consultant 09/2009 - Present
Global Wireless Solutions – VA Sr.ETL Developer 06/2008 – 08/2009
St. John`s Mercy Medical Center, MO ETL Developer 11/2007- 05/2008
Volkswagen, MI ETL Developer 08/2006 - 10/2007
Bayer, Berkeley CA ETL Consultant 10/2005 - 07/2006
Hucon Solutions, Bangalore, INDIA Data Warehouse Developer 05/2004 - 09/2005 PROJECT/WORK EXPERIENCE: Wells Fargo, CA 09/2009 - Present Informatica Consultant
An overall project is currently underway to Migrate Wachovia Global Treasury Solution (GTS) products from the WGC portal to the existing Wells Fargo CEO Portal, to eliminate redundancy in like Systems, which includes
corporate level customer facing portals. Responsibilities:
Analyze the source systems
data and the current reports at the client side to gather the requirements
for the Design inception
Extracted and transformed
data from high volume data sets of fixed width, delimited and relational
sources to load into target systems
Developed and maintained
critical and complex mappings and transformations involving Aggregator, Expression, Joiner, Filter, Sorter, Sequencer, Procedure, connected & unconnected Lookup, Update
Strategy and SQL transformations using
Informatica Power Center 8.6
Debugged mappings and
sessions by creating break points using debugger wizard
Redesigned some of the
existing mappings in the system to meet new business logic.
Created mapplets, worklets
and other transformations that enable the reusability of code.
Used parameters and
variables extensively in all the mappings, sessions and workflows for easier
code modification and maintenance
Created Pipeline session
partitions for concurrent loading of data and to optimize the performance in loading target tables
Effectively used error handling
logic mechanism for data and process errors
Performance tuning has been
done to increase the through put for both mapping and session level for
large data files by increasing block size, data cache size, sequence buffer length
and target based commit interval.
Extensively used pmcmd
commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files
Coordinated and lead the
complete code migration/merge process from Development, UAT to Production environments
Involved in extensive backend
testing of various modules and documented the results using Quality Center
Environment: Informatica Power Center 8.6, SQL Server, Oracle 10g, UNIX, Quality Center, CVS
Global Wireless Solutions – VA 06/2008 – 08/2009
Sr.ETL Developer
Global wireless solutions are a leading independent benchmarking solutions vendor for the wireless industry.
Here, benchmarking refers to the process of comparing one operator’s network delivered quality against
competitors and comparing network performance between markets. It also provides unique bench marking solutions for largest wireless carriers worldwide. My main job was to use data marts as the source data where each data mart belongs to a client and work on the ETL process using
Informatica.
Responsibilities:
Collection of requirements
from business users and analyzed based on the requirements.
Worked in the development,
Test, Production support of Informatica.
Created the Folder
Management i.e. Repository
administration using Repository Manager.
Created complex mappings
using Aggregator, Expression, Joiner, Filter, Sequence, Procedure, Connected & Unconnected Lookup, Filter and Update Strategy transformations using
Informatica Powercenter designer.
Developed and maintained
ETL (Data Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL Server and Flat Files to Oracle.
Designed and Implemented
the Informatica mappings to extract
data from source system to staging and from staging to target.
developed mappings,
mapplets, worklets and other reusable objects
Used SCD type1, Type2, Type
3 to load the present and historical data into EDW
Extensively used the various
features of Informatica and database
Performance tuning of the
Informatica mappings using various
components like Parameter files, Variables and Dynamic Cache
Performance tuning using
partitioning
Analyzed existing SQL
queries, tables and indexes for
performance tuning and advised based on the
loading time.
Developed UNIX shell scripts
and PL/SQL procedures, packages, triggers in Oracle 10g as required.
Designed and Developed the
Framework Manager Model and Projects using Cognos
Developed advanced reports
using IBM Cognos8 in Report Studio upon requests from business users.
Developed prompts and
customized prompts as per business user requirements using Cognos, report studio.
Environment: Informatica Power Center 8.6, IBM Cognos8, Oracle 11g/10g, MS Sql Server, Toad, Erwin, UNIX, Windows.
St. John`s Mercy Medical Center, MO 11/2007-
05/2008 ETL Developer
St. John's Mercy is one of the nation's largest Catholic hospitals and the second-largest hospital
in metropolitan St. Louis. . The clinical Outcomes Data Mart is a Star Schema Data Repository, maintained in an integrated Oracle environment optimized for reporting. The environment extracts data from heterogeneous source systems and integrates Clinical Management, Membership, Benefits, Eligibility and Claims information. Services empower individuals, expand consumer choice and strengthen patient-provider relationships across the health care spectrum.
Responsibilities:
Gathered the system
requirements and created mapping document which gives detail information about
source to target mapping and business rules implementation.
Designed, developed and
debugged ETL mappings using
Informatica designer tool.
Created complex mappings
using Aggregator, Expression, Joiner, Filter, Sequence, Procedure, Connected & Unconnected Lookup, Filter and Update Strategy transformations using
Informatica Power center
designer.
Extensively used ETL to load
data from different sources such as flat files, XML to Oracle.
Worked on mapping
parameters and variables for the calculations done in aggregator transformation.
Implemented slowly changing
dimension for accessing the full history of accounts and transaction
Tuned and monitored in
Informatica workflows using
Informatica workflow manager and
workflow monitor tools.
Created and configured
workflows, worklets and sessions using
Informatica workflow manager.
Scheduled the jobs using
third-party scheduler tool Autosys.
Implemented the National City
standard data population method loading the data into new set of tables
after successful completion of the data loading, rolled over to original tables. This concept used to high
availability of the data to users at the time of the data loading instead of users to wait to run their
reports.
Designed and developed
universes for reporting generation from warehouse database using Business Objects.
Resolved loops by creating
aliases and contexts.
Created different types of
reports like list, cross tab and etc. Environment: Informatica Power Center, SAP Business Objects XIR3, Oracle 11g/10g, MS Sql Server, Toad, Erwin, UNIX, and Windows.
Volkswagen, MI 08/2006 - 10/2007 Role: ETL Developer
Volkswagen manufactures vehicles in Germany and Mexico. And it distributes it to dealers all over US and
Canada. All the information pertaining to dealers such as dealer information, warranty information, labor
information etc. is stored in the data warehouse. Worked on dealers coding project and the vehicle in service project. The dealer project goal was to store all the information of the US and Canada dealers in a
centralized database where the users can use it for different business applications. The Vehicle In service
project aim is to store all the warranty start dates of the 2007 model VW minivan vehicles in the operational
databases. Responsibilities:
Co-ordinate, designed and
implementation for loading and updating the warehouse.
Worked for loading data from
source systems like DB2, XML into Oracle tables using various
transformations - Expression, Lookup, Source Qualifier, Update Strategy etc.
Applied business and
application knowledge to design the data loads for consistency and integrity.
Worked with production load
standards and error handing.
Assisted in performance
Created and facilitated presentations and demonstrations for
Informatica.
Scheduled Informatica
workflows using Shell Scripts. Created Tasks, Workflows and Worklets using Workflow Manager.
Created the transformation
routines to transform and load the data. Tuned Mappings and Workflows for better performance.
Defined Target Load Order
Plan for loading data into Target Tables.
Extracted data from SAP
sources using Informatica Power Connect.
Used Informatica
Powercenter Server manager to create sessions, batches to run with the logic embedded in the mappings.
Used Informatica power
exchange change data capture option to capture the updates to the existing data.
Maintained the Defects
Tracking in QC and to analyze the variation between the expected and actual results.
Fine tuned Transformations
and mappings for better performance.
Involved in the process design
documentation of the Data Warehouse Dimensional Upgrades.
Worked with analysts and
data source systems experts to map requirements to ETL code.
Environment: Informatica 7.1.3, Oracle 10g, Erwin 3.5, TOAD, Business objects, DB2, PL/SQL, Perl/Unix/Shell
scripting, XML, Tivoli, Power exchange, Rational Clear Case.
Bayer, Berkeley CA 10/2005 - 07/2006 Role: ETL Consultant
Bayer’s is one of the leading companies for bio-manufacturing with its primary capacity devoted to
producing a leading recombinant FVIII therapy. Berkeley site began to focus on the emerging field of
biotechnology, and robust capabilities of developing and manufacturing Bayer health care pharmaceuticals Responsibilities:
Used Repository manager to
create groups and users, and managed users by setting up their privileges and profile
Analysis was done using
existing transactional database schema and designing star schema model to support user need for reporting
Created the mappings in the
Informatica for extraction,
transformation and loading from Source to Targets
SDLC - from analysis to
production implementation, with emphasis on identifying the source and source data validation, implementing business logic and used transformations as per the
requirement in developing
mappings and loading the data into the target
Developed the ETL procedure
to ensure conformity, compliance with standards and lack of redundancy, translate business rules and functionality requirements into ETL procedure in PL/SQL
Implemented complex
mapping such as Slowly Changing Dimensions Type 2 using Flag.
Developed number of complex
Informatica Mappings, Mapplets and
reusable transformations for other mappings
Extensively used
Transformations like Router Transformation, Aggregator Transformation, Source Qualifier Transformation, Joiner Transformation, Expression
Transformation and Sequence generator Transformations
Designed and developed
Oracle PL/SQL Procedures
Developed stored procedures
using PL/SQL to backfill the data in production environment
Used PMCMD command to
trigger the workflow through command line in the UNIX environment
Environment: Informatica Power Center 7.1.1(Informatica Server, Informatica
Repository Server, Repository
Manager, Designer, Work Flow Manager, Work Flow Monitor), Erwin 3.5, Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, TOAD, MS SQL Server 2000, Flat files, UNIX
Hucon Solutions, Bangalore, INDIA 05/2004 - 09/2005
Role: Data Warehouse Developer Amgen-CCS Data warehouse collect, denormalize and integrate data from its operational database, as well as third-party hospital, pharmacies and physician patient’s reports to provide critical analytical data for
decision makers. Informatica
Powercenter 6.2.2 is used to extract, transform and load the data from staging area built through Oracle 8i snapshot replication of operational database into the data warehouse implemented in Oracle 8i.
Responsibilities:
Designed and implemented
for loading and updating the warehouse.
Implemented data integration
from source systems into Oracle data marts using various transformations - Aggregator, Expression, Lookup, Source Qualifier, Update Strategy etc.
Applied business and
application knowledge to design the data loads for consistency and integrity.
Worked with production load
standards and error handing. Worked with IMS Data to validate Sample
History module data. Assisted in performance tuning by running test
sessions.
Created and facilitated
presentations and demonstrations for
Informatica. Scheduled Informatica
workflows using Shell Scripts. Created Tasks, Workflows and Worklets using Workflow Manager.
Created the transformation
routines to transform and load the data. Tuned Mappings and Workflows for better performance. Used Informatica
Powercenter Server manager to create sessions, batches to run with the logic embedded in the mappings.
Fine tuned Transformations
and mappings for better performance. Involved in the process design documentation of the Data Warehouse Dimensional Upgrades. Worked with analysts and data source systems experts to map requirements to ETL code. Environment: Informatica PowerCenter 7x, Oracle 8i, Erwin, TOAD, JSP, Web Logic, XML, MS SQL Server2000, MS Visio, UNIX-HP.
Roshitha
Phone: 1--408.884.1548 Mobile: Not specifiedBellam
Date of Birth: Not Specified Gender: Female Nationality: United States Email: [email protected] Current Location: US InformaticaWork Experience : 7 years Skills : Informatica Domain Knowledge : IT/ Computers - Software
Industry : IT/ Computers - Software
Category : IT
Roles : Software Engineer/ Programmer Current Employer : Bank Of America Current Annual Salary : Not Specified Previous Employer : Bayer Healthcare Pharmaceuticals
Highest Degree Held : B.E/B.Tech, Computers, Amity Business School Preferred Job Location : US
Skill
Name Last Used Skill Level Experience Informatica Not specified Expert 48 months
Roshitha Bellam Sr. ETL Informatica Developer
Summary:
Over 7years of IT experience in
Software Design, Development, Analysis, Testing and Implementation of
business applications for Insurance, Banking, Pharmaceutical and Realtor verticals.
Data Processing experience in
designing and implementing Data Mart applications using ETL tool
Informatica Power Center
8.6.1/7.1.4/6.2/5.1,power exchange 8.x.
Adept at understanding
business processes / requirements and implementing them through mappings and transformations.
Involved in Database design,
entity relationship modeling and dimensional modeling using Star and Snowflake schemas.
Extensively worked with
mappings using different transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Update Strategy, Unconnected / Connected Lookup,
Aggregator and SCD Type-1,2&3.
Experience in tuning Mappings
and Sessions for better Performance.
Experience in loading various
data sources like Oracle, SQL Server, ERP?, DB2 and Flat Files into
Data marts.
Developed Complex, Logical
and Physical Data Models, using Erwin 4.x/3.5, Oracle Designer Tools and extensively worked on integration.
Excellence to satisfy
organizational goals and objectives by using UDB DB2.
Developed various projects
using the SDLC methodology.
Skilled professional experience
in developing test plans, test cases, test procedures and execution
of application using both Manual and Automated-testing tools.
Experience in requirements
gathering, creating documentation and unit testing of each developed
mapping.
Worked in Production support
team for maintaining the mappings, sessions and workflows to load the data into the data warehouse.
Experience in Oracle 10g/9i/8i,
writing Triggers, Stored Procedures, Functions, and Packages etc using PL/SQL.
Experience in Data modeling
using Erwin 4.0/3.5 and UNIX Shell Scripting.
Technical Skills:
ETLInformatica 7.x/8.x, SQL Server 2005 (SSIS)BI/OLAPMicroStrategy 8.0.1, Crystal Reports 8.0/7.0, Business
Objects Data ModelingERWin
3.x/4.xDatabasesOracle11g/10g/9i/8i, MS SQL Server 2005/2000, MS Access, Db2, Netezza, Informix, Teradata V2R5Operating SystemsWindows 95/98/2000/2003 Server/NT Server Workstation 4.0, UNIXProgrammingVisual Basic 6.0/5.0, PowerBuilder 6.0, C, PL/SQL, JavaScript, PERL, VBScript, HTML, XML,
DHTMLOther ToolsSQL*Loader, SQL*Plus, TOAD, MS Visio
Professional Experience:
Bank Of America,Merill Lynch,NJ Jan'10 Present
Sr. Informatica Developer
Description: Working as an Informatica
Developer in one of the leading banks in the United States. My
primary responsibilities are development and validation of new mappings, maintaining existing mappings,
fixing issues and documenting the findings. Data sources used are Mainframe DB2, Oracle, sql server and flat
files. Target Database is Oracle/Sql Server. Control-M is used as the scheduling tool. Responsibilities:
• Used Third Party tools like
Informatica PowerCenter 8.6.0 and Oracle 9i.
• Developed ETL jobs to extract
information from Enterprise Data Warehouse.
• Responsible for developing the
mappings from given technical documents using various transformations
like Aggregator, sorter, update, expression, etc.
• Experience in modifying
changes to the existing mappings according to user requirements.
• Worked with sources like flat
files, oracle and DB2 tables.
• Target database is oracle.
• Wrote various types of SQL
queries involving joins, aggregate calculations and tuning the queries to optimize performance.
• Performed extensive testing
and wrote queries in SQL to ensure loading of the data.
• Performed unit testing at
various levels of the ETL and documented the results.
• Set Standards for naming
conventions and best practices for
Informatica mapping development and
migration of mappings to QA and Production.
• Responsible for creating
workflows and worklets.
• Created Session, Event,
command, and Control Decision and Email tasks in Workflow Manager.
• Used Informatica debugging
techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Extensively used Expression,
Joiner for heterogeneous sources, look-up, filter, aggregate, and update
strategy transformations to transform data before loading into the target tables.
• Developed workflow sequences
to control the execution sequence of various jobs and to email support personnel.
• Implemented transformation
logic using transformations like Joiner, Aggregator, sorter, Update
strategy etc.
• Responsible for implementation
of one time data movement and data replication methods.
• Prepared migration checklist,
fixed the errors, documented the changes applied and test results.
• Worked extensively with
parameritrising the workflows, configuring the reusable success and failure
mails, command tasks.
• Setting up batches and sessions
to schedule the loads at required frequency using Power Center
Workflow manager and also using scheduling tools. Generated completion messages and status reports using Workflow manager.
Environment: Informatica Power Center 8.6(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer,
Mapping Designer, Mapplet Designer, Transformations),Oracle 10g, DB2 OS/390 8.1.5, SQL Plus, PL/SQL,
Microsoft Sql Server 2005, Windows XP. Bayer Healthcare Pharmaceuticals, NJ Nov'09 - Dec'10
Sr. Informatica Developer
Description: Bayer is a leading
pharmaceutical company in United States. They have got several regional
offices inter connected amongst one another. The objective of this project was to develop a complete data
warehouse so that they can analyze, do slicing, dicing, drill down on patient data. Database was maintained
in Oracle 8.x on Solaris. Data warehouse is designed using Erwin with different Fact and Dimension tables.
Created multiple instances for redundancy. Data is transferred to data warehouse. Responsibilities:
• Designed data models to
support user? business requirements.
• Designed and developed
complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica
ETL PowerCenter 6.0 tool.
• Used the Slowly Changing
Dimensions (type 2) to update the data in the target dimension tables.
• Created sessions, database
connections and batches using
Informatica Server Manager / Workflow
Manager.
• Optimized mappings,
sessions/tasks, source, and target databases as part of the performance tuning.
• Configured the server and
email variables using Informatica Server Manager / Workflow Manager.
• Used command line program
cmd to communicate with the server to start and stop sessions and batches to stop the Informatica server and recover the sessions.
• Used all types of caches like
dynamic, static and persistent caches while creating sessions/tasks.
• Used Metadata Reporter to run
reports against the repository.
• Created and populated the
intermediate aggregate tables to make the reporting efficient and fast.
• Designed the physical
structures necessary to support the logical database design.
• Designed processes to extract,
transform, and load data to the Data Mart.
• Involved in Informatica
mappings development using PowerCenter designer and server manager / Work flow Manager to create the sessions and did lot of testing and data cleansing.
• Performed impact analysis,
remedial actions and documented on process, application failures related
with Informatica ETL and PowerAnalyzer.
• Performed developments and
changes using ETL tool (Informatica) and Oracle database/data warehouse.
• As part of optimization and
revival process, performed design changes and changes in Informatica
mappings, transformations, sessions. Involved in development of complex mappings.
• Interacted with external,
internal users and DBA in troubleshooting problems reported in huge Volume testing (100-200 Million records Data) systems.
Environment: Informatica PowerCenter 6.x/7.x,Oracle 8i, SQL Server2000, MS Access, SQL, PL/SQL, TOAD 7.x, Windows NT.
Move.Com,CA Feb' 08 -Oct'09
Informatica Developer
Description: MOVE is a realtor company dealing with a number of agency systems to maintain and store their
data in a centralized database where the end users can use it for different business applications. This
project maintains and enhances the agencies data warehouse, thus enabling them to perform trend analysis. The data was being extracted from various databases such as Oracle, SQL server, and Flat Files and loaded into an
Oracle database using the ETL tool
Informatica. The reporting was done
using OBIEE. Responsibilities:
• Designed the ETL processes
using Informatica tool to load data from Oracle, flat files into the
target SQL Server and Oracle databases.
• Followed and Implemented
standards for BI & DW at various levels of the SDLC.
• Developed and improved
existing and new Oracle procedures.
• Developed mappings in
Informatica to load the data from various
sources using transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Aggregator, Update Strategy, Filter,
Router, etc
• Created new and customized
existing OOTB mappings as per end user requirements.
• Responsibility included
resolving tickets raised by the business users on ad-hoc reporting requests.
• Used Informatica workflow
manager to create, schedule, monitor and send the messages in case of
process failures.
• Designed SQL queries with
multiple joins to pull relative data during import state.
• Designed and modified PL/SQL
stored procedures to modify data flow.
enforce business rules.
• Worked on tuning and
performance improvement of jobs in
Informatica. Translated business
requirements
to Informatica mappings. Involved in unit
testing of mappings.
• Worked closely with the end
users and business analysts to understand the requirements and developed
transformation logic to be used in
Informatica.
• Created the transformation
routines to transform and load the data. Developed processes for
automation of loading data using parameter driven sessions for batch schedule
processes, verification and
re-conciliation of data stored in several different source systems.
• Developed complex, logical and
physical data models, using Erwin 4.x tool and extensively worked on
integration.
• Worked with analysts and data
source systems experts to map requirements to ETL code.
• Designed and documented
validation rules, error handling routines and testing strategy for the
mappings.
Environment: Informatica 8.6/8.6.1, Power exchange 8.5, TOAD, SQL plus, Oracle, Erwin 4.0, XML, Autosys, Erwin 4.0, PL/SQL, Oracle Business Intelligence 10.1.3x , Unix/Perl/Shell Scripting.
Chase,NY
May'07- Feb'08
Informatica Developer
Description: This project was done for Chase, in the credit card division, built a Data warehouse to be
customer-centric to analyze transactions across finance, marketing, risk collections, and consumer relations.
The Data Warehouse is growing in analytical richness with customer data successfully implemented.
Responsibilities:
• Analyzed various schemas for
implementation and modeled the Data Warehousing Data marts using Star Schema.
• Created mappings using
transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data from flat files
and oracle database, applied business logic to load them into the
central oracle database.
• Developed complex mappings &
mapplets in Informatica to load the data using different
transformations.
• Created and monitored
Sessions and Batches using Server Manager.
• Extensively used various performance tuning techniques to improve the session performance
(Partitioning etc).
• Successfully moved the
Sessions and Batches from the
development to production environment.
• Extensively used Informatica
client tools - Source Analyzer, Warehouse designer, Mapping designer,
Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Generated completion
messages and status reports using Workflow manager.
• Created workflows and worklets
for designed mappings.
• Developed mappings and
loaded data into relational database. Worked on Dimension as well as Fact tables.
• Extensively used PL/SQL
procedures and functions to build business rules.
• Identified and fixed bottlenecks
and tuned the complex Informatica
mappings for better performance.
• Scheduled the batches using
UNIX.
• Worked to parameterize all
variables, connections at all levels in UNIX. Environment: Informatica Power Center 7.1.4, Cognos, Oracle, Teradata, Toad 8.6, UNIX, HP-UX 11i, Sun Solaris5.4, SQL,
FACETS 4.X, MS Office Visio 2003
Boston Mutual Life Insurance,MA Sep'06-Apr' 07
Sr.Informatica Developer
Description: Boston Mutual Life Insurance Company sells traditional group and individual life insurance, as
well as disability and supplemental accident and illness coverage. To migrate and manage the data from
various regions required a Data Warehouse be designed.
Responsibilities:
• Used Source Analyzer,
Warehouse designer, Mapping designer, Mapplet designer, Transformation developer and Informatica Repository Manager.
• Developed and tested Mappings
and Workflows.
• Experienced in performing the
analysis, design, and programming of ETL processes for Teradata.
• Extensively worked in the
performance tuning of the ETL mappings and workflows.
• Involved in writing shell scripts
and added these shell scripts in Autosys as scheduled daily,
weekly, monthly.
• Extensively created
mapping/mapplets, reusable
transformations using transformations like Lookup,
Filter, Expression, Stored Procedure, Aggregator, Update Strategy, etc.
• Strong expertise in using both Connected and Un-connected Lookup transformations.
• Extensively worked with various
lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Developed Re-usable
Transformations, Re-usable Mappings (Mapplets) and Re-usable workflows (Worklets).
• Wrote Shell scripts to schedule
batches on Cron Jobs.
• Used Informatica scheduler to
run workflows on UNIX box and monitored the results.
Environment: Informatica Power Center 6.x,7.1.1, Oracle 10g, OBIEE 10.1.3.3.x, TOAD, UNIX, Windows XP,
Teradata. Airtel, India
Aug 05-July 06 Data Analyst
Description: Airtel is a powerful integrator of telecom products, services and e-commerce technologies
specializing in the distribution of pre-paid telecom products and services including phone cards and pre-paid
wireless products. Project involved in Normalizing and designing Tables, Constraints, Views, and Indexes etc. in coordination with application
development team. Fine tuned application logic for better performance.
Developed complex queries, functions, stored procedures and triggers using PL/SQL.
Responsibilities:
• Documented business
workflows textually as well as in UML diagrams (Use Cases, Activity diagrams, State diagrams) Identified and documented attributes for entities and also defined domain for all attributes.
• Analyzed the DW project
database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Responsible for creating Use
Cases, Business Processes and Work Flow Diagrams using MS Visio and MS
Excel.
• Collected the information about
different Entities and attributes.
• Used Active Directory to store
information and settings in a central database.
• Was involved in the designing
and Normalization of complex OLTP data base models.
• Followed 2NF/3NF
Normalization standards to create database for OLTP databases.
• Carried out denormalized for
the DW and generated Star schema.
• Used Erwin 4.0 to design
(PDM)Physical and logical models(LDM) for the relational database.
data models to physical data models.
• Worked extensively in creating
a schema to create tables in the database.
• Worked with Business
managers to confirm logical models based on data requirements.
• Performed Logical to Physical
mapping.
• Responsible in the process of
Data profiling in Spreadsheets.
• Worked extensively in creating
a schema to create tables in the database.
• Responsible in creating and
maintaining the Data Dictionary.
• Used Active Directory to store
information about the network resources across a domain and also
centralize the network.
• Fine-tuned application logic for
better performance. Developed complex queries, functions, store
procedures and triggers using PL/SQL.
• Designed and created stored
sub programs with Dynamic SQL at both client and Server side.
• Designed and developed
backend PL/SQL packages in database layer, stored procedures, functions and triggers.
• Session management to
provide security to web access.
• Tuned stored procedures &
developed business logic in database layer using PL/SQL.
• Worked on PL/SQL Packages,
Procedures, Objects, indexing, Functions, and REF Cursors.
• Worked with developers to
improve the performance of the SQL statements to increase the performance.
• Actively implemented system
control. Also provided production support with DBA in using Active
directory to assign policies, deploy software, and apply critical updates to an organization
• Worked on tuning the
performance of the existing reports, and successfully completed testing the reports.
Environment:
Oracle 9i, Reports 9i, SQL*Plus, Active Directory, MS PowerPoint, MS Excel, MS Access, MS Visio SQL
Navigator, UML, VB PL/SQL, Oracle Designer 6i, Windows Server 2000, Toad, ERWIN 4.0, MS Access
Mohit
Rastogi
Date of Birth: 4 Oct 1983 Gender: Male Nationality: India Flat nos:21/3,Mutha Chambers, Senapati Bapad Road, Pune - 411057 Phone: 91-120-2776873 Mobile: 91-9881722477 Email: [email protected] Alternate email: [email protected] Current Location: Pune
INFORMATICA
Work Experience : 5 years 7 months
Skills : INFORMATICA
Domain Knowledge : Not specified
Industry : IT/ Computers - Software
Category : IT
Roles : Team Leader/ Technical Leader
Current Employer : COGNIZANT TECHNOLOGY LTD Current Annual Salary : 6.90 lacs per annum Previous Employer : INFOSYS TECHNOLOGY LTD
Highest Degree Held : B.E/B.Tech, Electronics/Telecommunications, LNCT
Preferred Job Location : Anywhere
Skill
Name Last Used Skill Level Experience Informatica Jul 2011 Intermediate 48 months
Unix Jul 2011 Beginner 8 months
Oracle Jul 2011 Beginner 12 months
MOHIT RASTOGI Row House Nos:1/Yash Residency/Phase 2/Sus Road /Pune - 411057
©: +91-9881722477
Email: [email protected]
OBJECTIVE
A challenging growth oriented position, where my technical and professional skills can be effectively utilized and improved, eventually leading to
contribution in the growth of organization.
PROFESSIONAL SYNOPSIS
Worked extensively on Data warehousing project for 5yrs 7months.
Skills in UNIX ,Oracle, Informatica Power Center, Data Warehousing concepts, Teradata , Microsoft Visual Source Safe
Proven abilities in leading complete SDLC entailing analysis & development.
An effective communicator with excellent relationship management skills. Strong analytical, problem solving abilities. Possess a flexible & detail oriented attitude.
ORGANIZATIONAL EXPERIENCE
Current Organization: Cognizant Technologies Ltd. (April10 – Till Date)
Project:Investment Bank Intelligence Engine19 April 2010 to till date (14 Months) Client:JP Morgan Chase.
Team Size: 5
Role: Associate Consultant (Lead)
Scope:JP Morgan Chase (JPMC) is a fortune 25 Financial Giant with revenue figures over US $125 Billion. JPMC Bank is a global banking firm serving the complex needs of its customers (Includes Government organizations, Corporate Sector, Institutional investors etc) through a sophisticated & highly integrated range of financing, advisory, trading, investment & associated capabilities
JPMC provides a full range of IB (Investment Bank) and commercial banking products and services. The Firm also commits its own capital to proprietary investing and trading activities. IB Intelligence Engine is one of its prominent business areas.
JPMC has initiated a program called IBIE-Integration to integrate data from different