Sql Server Manager

RAJASHEKHAR POLKAM

Owings Mills

abpz0h@r.postjobfree.com Phone: 443-***-****

SUMMARY OF QUALIFICATIONS

Over ten (10) years of strong working experience in IT industries with exceptional exposure in diversified environments with domain experience in financial, Healthcare and insurance Industries.6+ years of experience in data extraction, transformation and loading using Informatica PowerCenter 8.6/7.1.3/7.1/6.1,6.2 (Source Analyzer, Repository Manager, Data Warehousing Designer, Mapping Designer, Mapplets Transformation), Informatica PowerExchange and PowerConnect .2+ years of experience in Dimensional modeling using Star Schema and Snow Schema5+ years of experience in Mainframe Programming experience using COBOL, CICS, JCL and DB2.Profound experience in Installation and Configuration of Informatica Power Center and Cognos Suite of Products Stupendous experience in data extraction, transformation and loading data using Informatica PowerCenter 8.6/7.1/6.1,6.2. Good experience in using Oracle 10g/9i/8i, IBM DB2, MS SQL Server 7.0/2000, PL/SQL (Functions, Procedures, Triggers and Cursors), SQL*Plus, SQL*Loader and TOAD.Automated and scheduled the Informatica jobs using UNIX shell scripting (CRONTAB) and AutoSys.Tuning of SQL Queries, Database leading to significant improvement in system response time and efficiency using Execution Plan/TKPROF and Trace File.Experience in performance and tuning of Informatica - sources, targets, mappings and database Emphasized on Performance of Mapping Optimizations in Informatica Proficient in interaction with the business users. Pioneered load strategies of loading staging area and data marts. Dealt with SCD Type1/Type2 loads. Ability to work individually as well as in a team with excellent problem-solving and trouble-shooting capabilities. Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL EXPERTISE

Data warehousing Tools: Informatica Power Center 8.x/7.x/6.x, Informatica

Power Mart.

Data Modeling: ERwin 4.0/3.5, Star-Schema Modeling, Snowflake schema

Modeling, FACT & Dimension Tables.

Data Reporting Tools: Cognos 6.0/7.0, Cognos Impromptu, Power Play

Transformer, Power Play for Windows

Operating Systems: UNIX, Sun Solaris, Linux (redhat v9.0), Windows

95/98/2000/XP/NT/7.

Programming Languages: PL/SQL, Shell Scripting, COBOL, PERL SCRIPT, CICS,

JCL, Java, VB, .Net and Java Script.

Databases: Oracle 8i/9i/10g, MS SQL Server 7.0/2000, SQL*PLUS,

DB2 and TOAD

Database Tuning: TKPROF, Execution Plan, Explain Plan, Cron

Tools: Autosys, SQL * Loader.

PROFESSIONAL EXPERIENCE

Carefirst BCBS, Owings Mills, MD Aug’08 – Present

Lead Systems Programmer Analyst

Carefirst is a leading health care provider in National Capital region. The firm is a not-for-profit, non-stock holding company with subsidiaries providing managed health care plans to about 3.3 million members in Maryland and Washington, DC. The company's main subsidiaries, CareFirst of Maryland and Group Hospitalization and Medical Services are licensees of the Blue Cross and Blue Shield Association. Together, the subsidiaries do business as CareFirst BlueCross BlueShield and offer Blue-branded HMO and PPO plans, as well as consumer-driven coverage, to individuals and employers throughout their service areas. Non-Blue subsidiaries and affiliates provide life insurance and third-party benefits administration.

Responsibilities:Extensively worked on Informatica PowerCenter 8.6 for extraction of data from the operational data sources, transforming the data as per business rules and loading data into the target database to populate the data mart.Handled various types of relational sources such as Oracle, DB2 and file sources such as flat and COBOL files.Developing number of Complex Informatica Mappings, Mapplets and Reusable Transformations for different types of reports research studies for Monthly Loading of Data.Created various transformations like Source Qualifier, Lookup, Router, Stored Procedure, Aggregator, Joiner, Filter, Expression and standard mappings.Modified the Target Load Order groups according to the required order to populate the targets and used Constraint based loading in every target load order group to ensure correct data load sequence into the data mart.Used Pre session and Post session PL/SQL scripts to drop and recreate indexes on the targets to improve session performance.Performed Partitions on the sources to improve the performance.Designing the Star schema and populating the Fact tables and designed the dimension and fact tables.Developed Sequential and Concurrent sessions using the Server Manager and configured the scheduler properties according the refresh frequency.Configured Post session emails to provide information about the mappings used sessions and batches completion statuses.Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.Participated in weekly meetings and discussed modification request with team.Conducted and involved in JAD sessions for complex decisions.Performing GAP and Impact Analysis for in-house changes with the impact of ITS releases.Member of on call team for Production support. Involved in analyzing and solving the production issue tickets.Updating weekly status report, Creating Quality related reports etc.

Environment: Informatica PowerCenter 8.6, Oracle 10g (SQL, PL/SQL, SQL* Loader), DB2 8.0, SQL Server 2000, UNIX Shell Scripts, Windows 2000/7.

Global Healthcare, Towson, MD Mar’07 – Aug’08

Lead ETL DW Analyst

Global Healthcare Exchange is a leading provider of supply chain solutions and services that bring together hospitals, Integrated Delivery Networks (IDNs), manufacturers, distributors and Group Purchase Organizations (GPOs). Data warehouse is built, through which a critical mass of buyers and suppliers can benefit from aggregated, accurate data and realize true cost savings and process efficiencies. The System generates reports for covering purchase order status, purchase order history by department, purchase order history by supplier, and item exception reports etc.

Responsibilities: Gathered business scope and technical requirements.Worked with Power Center -Designer tool in developing mappings and Mapplets to extract and load the data from flat files, Oracle to Oracle.Used different transformations for loading the data into targets like Source Qualifier, Joiner transformation, Update Strategy transformation, Lookup transformation, Rank transformation, Expression transformation, Aggregator transformation, Sequence Generator.Developed reusable transformations and Mapplets to use in multiple mappings.Used shell scripts for automation.Implemented performance-tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.Written Data-loading stored procedures, functions using PL/SQL from Source systems into operational data storage.Prepared effective documentation for future references.Created and monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.Extensively used Calculations, Variables, Breaks, Sorting, Slice and Dice, Alerters for creating reports.Scheduled BO Reports through Broadcast Agent.Offered support for the application on a time-time basis.

Environment: Informatica Power Center 7.1, MS SQL Server 7.0, Oracle 9i, SSIS, UNIX, Windows NT

ING ANNUITY AND LIFE INSURANCE, HARTFORD, CT Nov’05–Mar’07

SR. ETL Developer

ING’s business in the United States offer personal and institutional clients a broad array of Services in Insurance. ING Annuity provides services in retirement services, annuities, life insurance, and employee benefits. The data warehouse was being designed for the life insurance group. Informatica tools were used to source data from sources SQL Server, DB2, flat files, oracle and populate a Datamart, data warehouse on Teradata. The data warehouse was to provide the managers of ING, the Slice and Dice capability to analyze the data they have.

Responsibilities:Business Analysis and Requirement Collection.ETL development and automation of complete process. Technical lead role for data discovery, logical & physical modeling using ERWIN.Analyzing the source data coming from flat files/Oracle and working with business users and developers to develop the Model.Working on Dimensional modeling to Design and develop STAR Schemas.Using ER-win to identify Fact and Dimension Tables.Working closely with user decision makers to develop the transformation logic to be used in Informatica.Extensively used loader utilities to load flat files into Teradata RDBMS.Extensively used Informatica functions like IIF, DECODE, ISNULL, ADD_TO_DATE, TO_DATE, etc., in transformations.Developed Re-usable transformations, Mapplets to use them for data load to data warehouse and database (Teradata).Identifying and tracking the slowly changing dimensions, heterogeneous Sources and determining the hierarchies in dimensions.Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.Used Trillium postal GeoCoder and Census Geo-coder for mappingExtensively using Transformations like Router Transformation, Aggregator Transformation, Normalizer Transformation, Source Qualifier Transformation, Joiner Transformation, Expression Transformation, Aggregator Transformations and Sequence generator Transformations.Performed high volume maintenance on large Teradata tables using MultiLoad loader utility.Working with Oracle, SQL Server. Using Informatica to extract data into Data Warehouse.Used Cognos Series for generating reports.Automation of the process using autosys.

Environment: Informatica PowerCenter 8.0/7.1.2, DB2 8.0, Oracle 10g/9i/8i, ERWIN 4.5/4.0, Cognos 6.0, SQL, PL/SQL, SQL*Loader, Teradata V2R5 (Multiload, Fastload, Tpump, BTEQ), Trillium SQL Navigator, SQL Server 2000, Autosys, Windows NT/2000, HP-Unix.

Perot Systems, Noida, India May’00 – Nov‘05

Associate Analyst

Responsibilities:IMMS is centralized Material Management system for TENET hospital chain located around Texas.IMMS deals in each and every aspects of managing material into hospitals they vary from huge machinery, construction of building, buying new buildings and ordering pharmacy stuff etc. Preparing the Historical Data Reports using culprit reports, Maintaining Divestiture Processes, Minor Enhancements, Adding the new facilities etc.Used EDI X12 standard to transfer data In formats like 846, 867, 844, 849 etc.,Updating weekly status report, Creating Quality related reports etc.Member of Production support team for year-end critical jobs.Mentoring of new members for Production support activities.Also involved in designing and developing of Browser based application using some of ADSO HTML API’s

Environment: OS/390, VS COBOL II, DB2, JCL, MVS, OLQ, DMLO, TSO/ISPF, ENDEVOR, SORT, CA7, RACF, ADSALIVE, XML.

Contact this candidate