Sql Server Manager
Resume:
SWETHA PABBATI ***@*********.***
Pho.No.732-***-****
[pic]
PROFESSIONAL SUMMARY:
. 7+ years of experience in designing, developing and maintaining large
business applications such as data migration, integration, conversion,
data warehouse and Testing.
. Professional understanding of Software Development Life Cycle (SDLC).
. Expertise in data warehousing, ETL architecture, Data Profiling using
Informatica Powercenter 8.6/8.5/8.1/7.1/6.2 - Client and Server tools.
. Expert in designing Fact & Dimension Tables, Physical & Logical data
models using ERWIN 4.0 and Erwin methodologies like Forward & Reverse
Engineering.
. Experience in integration of various data sources like SQL Server,
MySQL, Oracle, Tera Data, Flat files, DB2 Mainframes into the staging
area
. Business Requirements review, assessment, gap identification, defining
business process, deliver project roadmap including documentation,
initial source data definition, mapping, detailed ETL development
specifications and operations documentation
. Expert in Installation and configuration of Informatica server with
sql server, oracle and able to handle the Informatica administrator
tasks like Configuring DSN, creating Connection Strings, copying &
moving mappings, workflows, creating folders etc.,.
. Strong experience in complex PL/SQL packages, functions, cursors,
triggers, views, materialized views, T-SQL, DTS, and SSIS.
. Expert in SSIS package using Import/Export wizard, creating packages,
connection manager, Control Flow, Data Flow, Event Handlers,
scheduling and troubleshooting.
. Expert in troubleshooting/debugging and improving performance at
different stages like database,workflows,mapping.
. Expert in all phases of software development life cycle - Project
Analysis, Requirements, Design Documentation, Development, Unit
Testing, User Acceptance Testing, Implementation, Post Implementation
Support and Maintenance.
. Experience in writing UNIX shell scripts
. Expert in design and development of Business Intelligence reports
using BI tools Business Objects, Cognos and knowledge in
microstrategy.
. Have Got Proven experience leading Team.
. Experience includes thorough domain knowledge of Business Financial
system, Banking, healthcare information technology, Insurance &
Reinsure, Pharmacy claims systems, Telecom Industry.
. Enthusiastic and goal-oriented team player possessing excellent
communication, interpersonal skills and leadership capabilities with
high level of adaptability
TECHNICAL SKILLS:
Data warehousing : Informatica PowerCenter 8.6/8.5/8.1/7.1/6.2,
InformaticaPowerConnect for
Siebel/SAP/Peoplesoft, PowerExchange for
DB2, Metadata Reporter Data Profiling,
Data cleansing, OLAP, OLTP, Star &
Snowflake Schema, FACT & Dimension Tables,
Physical & Logical Data Modeling, Data
Stage 7.x, Erwin 4.0
DB Programming Languages : RDBMS, Joins, Indexes, Views, Functions,
Triggers, Clusters, Procedures,
SQL*Plus, SQL*Loader, Export/Import, TOAD,
SQL Navigator, Explain plan, SQL Trace
BI Tools : Business Objects XIR2/6.0/5.1/5.0,Crystal Reports,
Microstrategy 8, Cognos 8.
Database Applications : SQL Server 2005/2000/7.0/6.5, DTS, SSIS,
Oracle 10g/9i/8i/8, Sybase, My SQL, MS-
Access, DB2 8.0/7.0
Programming Languages : C, C++, XML, SQL, T-SQL, PL/SQL, UNIX
Shell Scripting
Operating Systems : HP-UX11/10/9,IBM-AIX4.0/3.1, Sun Solaris
9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows XP
Professional/2000/NT/98/95
Other Tools : MS Visual Source Safe, PVCS, Autosys, Control Remedy,
Mercury Quality center, Star Team, Lotus
Notes.
PROFESSIONAL EXPERIENCE:
GE, Detroit, MI
May 2010 - Till date
The General Electric Company, or GE, is an American multinational
conglomerate corporation incorporated in the State of New York. The Company
operates through five segments: Energy Infrastructure, Technology
Infrastructure, NBC Universal, Capital Finance and Consumer & Industrial.
The primary objective of the project was to construct an aggregated data
warehouse (DWH) for analytics and reports used by business, risk
management, asset management groups.
Responsibilities:
. Interacted with business community and gathered requirements based on
changing needs. Incorporated identified factors into Informatica
mappings to build the DataMart.
. Developed a standard ETL framework to enable the reusability of
similar logic across the board. Involved in System Documentation of
Dataflow and methodology.
. Assisted in designing Logical/Physical Data Models, forward/reverse
engineering using Erwin 4.0.
. Developed mappings to extract data from SQL Server, Oracle, Teradata,
Flat files and load into DataMart using the PowerCenter.
. Developed common routine mappings. Made use of mapping variables,
mapping parameters and variable functions.
. Used Informatica Designer to create complex mappings using different
transformations like Filter, Router, Connected & Unconnected lookups,
Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator
transformations to pipeline data to DataMart.
. Developed Slowly Changing Dimension for Type 1 SCD
. Used mapplets for use in mappings thereby saving valuable design time
and effort
. Used Informatica Workflow Manager to create, schedule, execute and
monitor sessions, worklets and workflows.
. Written procedures, Queries to retrieve data from DWH and implemented
in DM.
. Data extraction and data Transfer from and to SQL Server Database
using utilities / tools like BCP, and BULK INSERT.
. Written shell scripts in UNIX to execute the workflow
. Written shell scripts to run the workflows and automated them through
maestro job scheduler.
. Responsible for submitting DBA requests, following up with data base
DBA's and Informatica administrators, creating remedy ticket, handling
all the singoff's for the production, updating all changes with new
versions using START team, creating test cases using Quality Center.
. Written SQL Queries, Triggers, PL/SQL Procedures to apply and maintain
the Business Rules.
. Troubleshooting database, workflows, mappings, source, and target to
find out the bottlenecks and improved the performance.
. Written Indexes, primary keys and checked other performance tuning at
data base level.
. Conducted Database testing to check Constrains, field size, Indexes,
Stored Procedures, etc.
. Created testing metrics using MS-Excel
. Implemented various Performance Tuning techniques on Sources, Targets,
Mappings, Workflows and database tuning.
. Involved in generating reports from Data Mart using Cognos.
. design and generate crystal reports from a wide range of data sources.
. Defects were tracked, reviewed and analysed.
. Used Source Analyzer and Warehouse designer to import the source and
target database schemas, and the Mapping Designer to map the sources
to the target.
. Performed Configuration Management to Migrate Informatica
mappings/sessions /workflows from Development to Test to production
environment.
Environment: Informatica PowerCenter 8.6/8.5, SQL Server 2005/2000, Oracle
10g, Teradata 6, SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Cognos, STAR
team, Remedy,Crystal reports, Maestro job scheduler, Mercury Quality Center
Symantec Corporation, Cupertino, CA September
2009 - April 2010
Symantec helps consumers and organizations secure and manage their
information-driven world. Our software and services protect against more
risks at more points, more completely and efficiently, enabling confidence
wherever information is used or stored.
Responsibilities:
. Developed a standard ETL framework to enable the reusability of
similar logic across the board. Involved in System Documentation of
Dataflow and methodology.
. Identified all the dimensions to be included in the target warehouse
design and confirmed the granularity of the facts in the fact tables.
. Assisted in designing Logical/Physical Data Models, forward/reverse
engineering using Erwin 4.0.
. Developed mappings to extract data from SQL Server, Oracle, Teradata,
Flat files, DB2, Mainframes and load into Data warehouse using the
PowerCenter, power exchange.
. Developed common routine mappings. Made use of mapping variables,
mapping parameters and variable functions.
. Export/Import data from different data bases, flat files using DTS
package and BCP by defining source and target.
. Scheduling and troubleshooting DTS.
. Written SQL Queries, Triggers, PL/SQL Procedures, Packages and UNIX
Shell Scripts to apply and maintain the Business Rules.
. Checked performance tuning/debugging at different levels like
workflows, mappings, database etc.
. Conducted Database testing to check Constrains, field size, Indexes,
Stored Procedures, etc.
. Created testing metrics using MS-Excel
. Implemented various Performance Tuning techniques on Sources, Targets,
Mappings, and Workflows.
. Used Source Analyzer and Warehouse designer to import the source and
target database schemas, and the Mapping Designer to map the sources
to the target.
. Performed Configuration Management to Migrate Informatica
mappings/sessions /workflows from Development to Test to production
environment.
. Generated reports using cognos.
. Collaborated with Informatica Admin in process of Informatica.
. Worked closely with the business analyst's team in order to solve the
Problem Tickets, Service Requests. Helped the 24/7 Production Support
team.
. Created reports like crystal reports, Master/Detail reports, Cross Tab
reports, slice and dice reports, and drill down reports
Environment: Informatica PowerCenter 8.1/7.1, SQL Server 2000, Teradata 6,
Oracle 9i, DB2,SQL, PL/SQL, Mainframes, Sun Solaris, UNIX Shell Scripts,
Business Cognos 8, Erwin, Autosys, Remedy.
National Penn Insurance, Columbus, OH
October 2007 - July 2009
National Penn is the fifth largest bank holding company headquartered in
Pennsylvania. National Penn operates 140 branch offices in Pennsylvania,
Maryland and Delaware. The primary objective of the project was to
construct an aggregated data warehouse (DWH) for analytics and reports used
by business, risk management, asset management groups.
Responsibilities:
. Involved in Requirement Gathering and identifying the report set to be
produced.
. Attended user design sessions, studied user requirements, completed
detail design analysis and wrote design specs and regularly reported
update to the management.
. Developed ETL job workflow with error/exception handling and rollback
framework.
. Performed root cause analysis and identified and implemented
corrective and preventive measures.
. Designed mappings that loaded data from flat-files to the staging
tables.
. Designed workflows for 270, 834 EDI transactions.
. Knowledge about interchanging data between health care sector and
insurance organizations via EDI process though requirements mainly had
billing and financial scope.
. Developed Informatica mappings, sessions and workflows.
. Extensively used Teradata and Oracle for a highly estimated dataflow.
. Extensively worked with Repository Manager, Designer, Workflow Manager
and Workflow Monitor.
. Used Informatica variables to implement complex logic for Informatica
mappings.
. Worked with XML Sources and Targets.
. Loaded data according to the Hospital Tables for Patient information,
Service information, Claim/Claim payment information, Payers/Insurance
company information.
. Identified tables/Scripts required for full load, daily delta-load and
monthly load and documented ETL process for each load.
. Worked on Customer Data Integration to solve the complex data input.
. Scheduled the Workflows and monitored them.
. Designed the Migration Plan document to migrate the Mappings and work-
flows to the Testing and Production environments.
. Documented the number of source / target rows and analyzed the
rejected rows and worked on re-loading the rejected rows.
. Conducted peer-to-peer code review meetings.
. Created test plans and worked with QA team for System Integration
Testing.
. Interacted with key users and assisted them with various data issues,
understood data needs and assisted them with Data analysis.
. Validated the Report data by verifying with queries from database.
Environment: : Informatica PowerCenter 8.1/7.1, SQL Server 2000, Teradata
6, Oracle 9i, DB2,SQL, PL/SQL, Mainframes, Sun Solaris, UNIX Shell Scripts,
Business Cognos 8, Erwin, Autosys, Remedy.
LincolnLife Financial Groups, Fort Wayne, IN
January 2006- August 2007
LincolnLife Finance serves individual and institutional customers
worldwide. They offer a variety of products and services, including mutual
funds, annuities, real estate brokerage franchises, relocation services and
more.
Worked as data warehouse Developer for cash reserve calculations, customer
information sales tracking which strengthened its commitment to CRM.
Historical, current, and future acquired bond, claims, agency support,
product, channel, and financial services data are converted, summarized and
made available to a broad base of internal and external users.
Responsibilities:
. Interacted with user groups through facilitated meetings.
. Extracted data from flat files, DB2, Teradata and loaded them into
DB2, teradata.
. Routine checks of log and trace files to see whether there are any
problems requiring action.
. Worked with Source Analyzer, Warehouse Designer, Transformation
designer, mapping designer and Workflow Manager.
. Developed data Mappings between source systems and warehouse
components
. Created various Transformations like Joiner, Aggregate, Expression,
Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router
etc. and Fine-tuned the mappings for optimal performance.
. Developed and modified many scripts using Ksh scripting in VI editor.
. Knowledge on UNIX shell command in scripting such as ssh, scp, mailx
etc.
. Made use of System variables (SYSDATE), Mapping parameters and
variables in the transformations within a mapping. Employed variable
functions (like SetMaxVariable) to manipulate mapping variables and
parameter files to initialize mapping parameters.
. Coordinating with the DBA's for managing the databases in different
environments for UAT and system testing, also involving with DBA's
during the release nights and troubleshooting with any of the
production problems.
. Worked with Testing team in trouble shooting the defects in
application.
. Used informatica as a tool for the test data preparation in various
environments
. Involved in performance tuning of SQL Queries.
. Provided on-call support for the nightly load process that run from
12a.m to 7 a.m.
. Worked on Documentation to describe program development, logic,
coding, testing, changes and corrections
Environment: Informatica PowerCenter 7.1, Oracle9i, SQL Server 2000, Erwin,
XML, TOAD, HP-Unix 11.11, Dendrite Webforce, Cognos Report Net.
Standard Chartered Bank, Kolkata, India
October 2003-December 2005
Standard Chartered Bank is a British financial services company
headquartered in London, England with operations in more than seventy
countries. It operates a network of over 1,700 branches and outlets and
employs 80,000 people. This project is to develop the DWH to store the data
of customers, calling plans, contract details, etc. from different sources
through Informatica and generating reports for business analysis's to
improve the business.
Responsibilities:
. Used Informatica Workflow Manager to create, schedule, execute and
monitor sessions, worklets and workflows.
. Created new mappings according to business rules to extract data from
different sources, transform and load target databases.
. Debugged the failed mappings and fixed them.
. Conducted Database testing to check Constrains, field size, Indexes,
Stored Procedures, etc.
. Defects were tracked, reviewed and analyzed.
. Modified the mappings according to the new changes and implemented the
persistent cache in several mappings for better performance.
. Implemented various Performance Tuning techniques on Sources, Targets,
Mappings, and Workflows.
. Involved in writing stored procedures and shell scripts for automating
the execution of jobs in pre and post sessions to modify parameter
files, prepare data sources.
. Identified the issues in sources, targets, mappings and sessions and
tuned them to improve performance.
. Created and used reusable mapplets and worklets to reduce the
redundancy.
. Developed robust Informatica mappings and fine-tuned them to process
lot of input records.
Environment: Informatica power center, Oracle9i, SQL, PL/SQL, Solaris, MS
Vision, Ms-Access.
Contact this candidate