Manager Sql Server
Resume:
[pic][pic][pic]
Hareesh
************@*****.***
Summary
Over 12+ years of IT experience in the Analysis, Design, Testing,
Development, Implementation and Maintenance of applications.
Certified as Informatica Designer, Administrator and Consultant with
Excellent ETL experience using, Informatica PowerCenter 8.6.1/7.1.4/6.2
(Source Analyzer, Warehouse Designers, Repository Manager, Server manager,
Mapping/Mapplet/Transformations, Repository Server, Workflow Manager).
Have a proven experience in activities related to the development,
implementation, administration and support of ETL processes for large-scale
data warehouses using Power Center, Power Mart and Power Connect.
Experience in FACT and Dimensions, star schema and snow-Flake Modeling.
Extensive Database experience using Oracle 9i/8i/7.x, DB2, MS SQL Server
2000/7.0/6.5, MS Access 7.0/2000, Oracle Report Writer,TOAD, SQL, PL/SQL,
SQL*Plus, SQL*Loader and Developer 2000.
Have extensive knowledge in Database Performance Tuning and Backup.
Experience in Sun Solaris 2.7, HP-UX, SCO-Unix, Linux, Win NT4.0, Win
95/98/NT/2000/XP.
Good exposure with operating systems Windows NT/2000/XP and UNIX with load
utility Scripts.
Worked on Client/Server applications by using VB 6.0, ASP, COM+
Experience in Financial, Chemical, Textile, Pharmaceutical and Tele
Communications industries.
Excellent analytical and problem solving skills.
Actively involved in production support.
Technical Skills
Databases: IBM UDB DB2 7/8, Oracle 7.x/8.x/9i and SQL
server7.x/8.x/2000/2005, Ms Access
ETL Tools: Informatica Power Center6.x/7.x/8.x and
OLAP Tools: Business Objects 5.x/6.1, Power Play, Crystal
Reports 6/7/8.0/9.0/10
Database Modeling: Erwin 3.5.2/4.1, Star-Schema and Snowflakes
Modeling.
Operating Systems: Sun Solaris 2.7, HP-UX, SCO-Unix, Linux, Win NT4.0,
Win
95/98/NT/2000/XP.
Languages: SQL, PL/SQL, Shell Scripting, C, C++ and Java
GUI: VB. NET, VS.NET, ADO.NET, VB 6.0/5.0
(COM/ DCOM, ActiveX
DLL/EXE, ADO, RDO, DAO, ODBC, OLE-DB, ActiveX, Developer
2000.
Web Technologies: HTML, DHTML, VBScript, CSS, JavaScript, ASP, XML and
XSL
Web Servers: IIS
Web Tools: Front Page, Visual Studio, XML and Dream weaver
Other Tools: Visual SourceSafe, TOAD and Crystal Reports
9.0/8.5/6.x
XL Insurance, Hartford, CT
Aug'09-Present
Data Warehouse / ETL Developer
Currently working on Monthly Management Information Pack (MIPack) project.
The primary objective of MI Pack Phase 1 is to automate the creation of the
Management reports that comprise the MI Pack and the secondary objective is
to build business hierarchies within the OBI reporting tool or IDW, or
both. This will be accomplished by leveraging the data consolidation
efforts performed by the Insurance Data Warehouse (IDW) and reporting
functions of Oracle Business Intelligence (OBI).
XL Insurance, Hartford, CT Jul'07-Aug'09
Data Warehouse / ETL Developer
XL Capital Ltd (XL) is a provider of insurance and reinsurance coverage to
industrial, commercial and professional service firms, insurance companies
and other enterprises on a worldwide basis. The Company operates through
four business segments: Insurance, Reinsurance, Life Operations and Other
Financial Lines.
Worked as a developer on a project to acquire data from Insurance Financial
Reporting and Controls database and produce a data mart for Financial
Reporting needs. This was successfully implemented on time, meeting all
deliverables within a very tight timeframe.
Responsibilities:
Extensively used ETL to load data from AS400, SQL Server and Flat files to
feed the General Ledger.
Involved in Designing generic Mapping tables and Helper tables.
Used Transformations mostly as Expressions, Filters, Joiners, aggregators,
Lookups and Routers, Normalizers and unions to load consistent data into
Database.
Worked with Informatica Workflow Manager to create Workflows, database
connections, sessions, and batches to run the mappings.
Dynamically generated param files by using windows batch scripts.
Involved in Dimensional Modeling Techniques to create Dimensions, Detail
Fact and summary fact tables.
Monitoring the workflow performance and status with Workflow Monitor.
Developed Various Command Tasks to automate the Pre session jobs.
Used various Performance Tuning techniques to improve the load.
Have written complex SQL Queries involving multiple tables with joins.
Involved in Converting SQL server Procedures and SQL Loader scripts to
Informatica mappings.
Tuning SQL server procedures and Functions with different utilities like
EXPLAIN PLAN.
Tuning complex ETL mappings
Created Automation EMAIL process to notify users for OOB issues.
Involved in writing stored procedures, Pre-session and Post- Session
Scripts.
Used PMCMD to interact with Informatica workflow's and automated individual
object import and export process.
Developed Autosys jobs to schedule the informatica jobs.
Involved in consolidated error processing mechanism.
Extensively worked with QA and PROD and Volume estimations.
Involved in Informatica Version up gradation from 7.1.4 to 8.6.1
Involved in Production defects and enhancements.
Environment: SQL server 2000/2005, Windows server 2003, Power Center
7.1.4/8.6.1, oracle 8/9.
Previous projects
ING Insurance & Financial Services, Hartford, CT Sep'04-
Jul'07
Data Warehouse / ETL Developer
This project is about to maintain the Accounts and Transactions details
information. ING has distinctive assets from legacy Source Systems into
Operational data Store (ODS) and transforming them into the Data Ware-House
and accumulating into Data Marts using IAA Business Model using
INFORMATICA. The data cleansing process is done at Stage, HUB, Warehouse,
Info HUB levels and finally loaded into the ODS and Data Marts. Balance
Controls and Error Recycling Process takes place at each level to validate
the ETL Process and to provide accurate and valid data for the customers.
Responsibilities:
Scheduling meetings with the business users to gather the business analysis
reporting requirements.
Extensively used ETL to load data from DB2, SQL Server, Sybase databases
and Flat files to e-business application database.
Involved in Designing and creating mappings and mapplets using Informatica
Source Analyzer, Warehouse designer, Mapplet Designer &, Transformation
Designer.
Used all Transformations mostly as Expressions, Filters, Joiners,
aggregators, Lookups and Routers to load consistent data into Database.
Worked with Informatica Workflow Manager to create Workflows, database
connections, sessions, and batches to run the mappings.
Developed Transactions for ACES (source system) data.
Involved in Dimensional Modeling Techniques to create Dimensions, Detail
Fact and summary fact tables.
Monitoring the workflow performance and status with Workflow Monitor.
Developed Various Command Tasks to automate the Pre session jobs.
Used various Performance Tuning techniques to improve the load.
Designed and Developed Dynamic SQL Scripts in DB2 UDB.
Have written complex SQL Queries involving multiple tables with joins.
Involved in Converting SQL/Procedures and SQL Loader scripts to Informatica
mappings.
Tuning PL/SQL procedures and Functions with different utilities like
EXPLAIN PLAN.
Scheduling the Workflows and sessions for daily loads.
Automation of FTP process to and from source systems.
Involved in writing UNIX shell scripts and PL/SQL procedures, Pre-session
and Post- Session Scripts.
Used PMCMD to interact with Informatica workflow.
Have very good experience in developing Control M jobs to schedule the
informatica jobs.
Have Good experience in IBM DB2 Export/Load utility Scripts.
Involved in consolidated error processing mechanism.
Extensively worked with Test Director in QA and Volume Environments.
Involved in Informatica Version upgradation from 6.2.2 to 7.1.4
Defeats created by users involved in different source systems and re
implementing them in production and providing valid data with user
acceptance.
Involved in small other projects and working in Production Support
Environment: IBM DB2 UDB 7/8/8.1, Sun Solaris 8, Power Center 6.2.2/7.1.4,
oracle 8/9, SQL Loader, Erwin, Business Objects 6.x and XML, SUN FIRE
10000, Mercury Test Director
Champion Mortgage, Parsippany, NJ Mar'03 - June'04
Business Intelligence System - Data Warehouse Developer
The project main objective is to create a central database and provide a
set of standard reports. It extracts data from legacy systems through flat
files, Mainframes data, transforming and loading into Oracle target
database using Informatica Power Center
Responsibilities:
Involved in project cycle plan for the data warehouse, analyzing the source
data, deciding the exact data extraction, transformation, loading strategy
(Informatica 6.1 is used) & Dimensional modeling.
Extensively used Informatica Power Center Client Tools - Source Analyzer,
Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet
Designer, Informatica Repository
Developed Mappings between source systems and Warehouse components.
Developed mapplets, mappings and configured sessions.
Extensively used almost all the transformations.
Created reusable transformations and mapplets to use in multiple mappings.
Used debugger to test the data flow and fix the mappings.
Created and monitored workflows and tasks using Informatica Power Center
Work flow Manager.
Managed Informatica Workflow Manager and Workflow Monitor.
Involved in designing the Data Model using Erwin and integrating E - R
models with the Oracle Database.
Created global repository, Groups, Users and assigned privileges using
repository manager.
Developed Unix scripts to automate the Data Load processes to target
Datawarehouse.
Created reports using Business Objects
Developed Universes using Business Objects Designer based on business
requirements to feed the reports.
Created various queries using Business Query.
Publishing reports on the web browser as well as saving reports in
corporate environment.
Created the reports (Master/Detail, Cross tab, Chart templates) in Business
objects and Web Intelligence using the universes as the main data providers
and writing the complex queries including sub queries
Created, modified, maintained the business complex reports using business
objects reporting module.
Involved in generation of complex reports charts based on functional
specifications using Business Objects documents for inquiry transactions
from database.
Environment: Informatica Power Center 6.1/6.2, Business Objects
5.1/6.0/6.1, Web Intelligence2.6/6, DB2, Oracle 9i, SQL, PL/SQL, ASP, Erwin
and UNIX Shell Scripts.
Inhibitex, Inc. (Pharmaceutical Company), Alpharetta, GA Mar'02
- Jan'03
Operational Data Store - Data Warehouse Developer
This project is an extraction of data from SIEBEL and legacy systems and
building the common operational data store (ODS) and Analytical Data Store
(ADS)
Responsibilities:
Analysis of Source, Requirement, existing OLTP system and Identification of
required dimensions and facts from the Database.
Identified business rules for data migration.
Parsing high-level design spec to simple ETL coding and mapping standards.
Involved in designed new database tables to meet business information
needs. Design Mapping document, which is a guideline to ETL Coding.
Worked on Informatica Power Center 5.1 tools - Source Analyzer, warehouse
designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable
Transformations.
Using Informatica Designer designed Mappings, which populated the Data into
the Target Star Schema, which is on Oracle 8i Instance.
Used Workflow Manager (Server Manager) for Creating, Validating, Testing
and running the sequential and concurrent Batches and Sessions and
scheduling them to run at specified time.
Maintained and improved integrity by identifying and creating relations-
ships between tables.
Shell Scripts and PMCMD to interact with Informatica Server from command
mode.
Created Daily Reports, Dynamic Reports and Ad-hoc Reports.
Environment: Informatica Power Center 5.1 on HP-Unix, DB2, Oracle 8i
(Staging, Data Warehouse), Toad (Oracle Query Tool), XML, HTML, Erwin (Data
Modeling), Cognos Impromptu and Power play 6.6, Power Play Web viewer,
Power Play web explorer.
Bell South Inc., Birmingham, AL Mar'01
- Oct'01
Central Data Warehouse - Data Warehouse Developer
This project was built with an objective to help top-level management is
decision making. The data from different departments is collected and
integrated into a data warehouse which has been sent to data marts that are
built based on subject areas.
Responsibilities:
Involved in designing the target Data Warehouse using Star Schema.
Extensively used Informatica Power Center in Extraction, Transformation and
Loading (ETL) Process.
Created Dimension Tables and Fact Tables based on the warehouse design.
Wrote Triggers and Stored Procedures using PL / SQL for Incremental
updates.
Created necessary Repositories to handle the metadata in the ETL process.
Created the Source and Target Definitions in Informatica Power Center
Designer.
Created Reusable Transformations and Mapplets to use in Multiple Mappings.
Created Sessions and Batches using Server Manager for data movement through
Mappings.
Created reports using Business Objects.
Built Universes using Business Objects Designer to feed the reports.
Performed Drill down and Slice and dice operations in business objects.
Created various queries using Business Query.
Customized Info View portal in Web Intelligence.
Implementing security among the Business Object tools using Supervisor.
Scheduled and refreshed reports using Broadcast Agent.
Creating various financial reports as per the requirement.
Environment: Informatica Power Center 5.0, Oracle8i, Business
Objects4.x/5.1, Web Intelligence 2.5 and Windows NT
HSE GLOBAL AS Oslo, Norway Feb'00 -
Mar'01
Oracle/Web Developer
This project is complete, well arranged and centralized management system
for internal filing and distribution of SDSs. As chemical card index for
raw materials and finished products, and it will also be filing system for
former versions of our SDS
Responsibilities:
Designed Database and Functional Flow Diagram.
Written PL/SQL Procedures in oracle 8.0.5.
Created Web interface screens using ASP, JavaScript, VB script, visual
Studio
Involved in creating Components by using VB 6 DLL.
Developed Error Handling and Error hook application
Created MSI packages for Support libraries.
Created Crystal Reports 7.0.
Involved in Setting Configuration Files.
Involved in production support and help desk
Environment: VB6.0, ASP, Visual Studio, Oracle 8.0.5, COM/COM+, Windows
2000
Telenor AS, Oslo, Norway Dec'99-Feb'00
Web Developer/SQL server
The purpose of this project is to provide a tool that gives salespeople the
ability to add new cellular customers from any location where the Internet
is available.
Responsibilities:
Designed and developed web pages using HTML, VBScript, JavaScript, ASP
Used COM + Technology and VBScript to achieve functional specifications
Used ADO 2.0 objects to handle the database
Created stored procedures in SQL Server and used in web pages
Development of COM objects using VB 6.0, installed packages in MTS
Created various sessions and design database
Performed Production support and Help Desk on weekly basis.
Environment: VB6.0, ASP2.0, Visual InterDev6.0, SQL Server 2000,
Transact SQL, COM/COM+, MTS 2.0, and Windows 2000, IIS 6.0
Pt Wearwel Cambodia Ltd, Phonm Penh, Cambodia Mar'99-
Nov'99
System Developer & Support
This Project(Smart suite) is basically Smart Card based application, which
is a ideal solution for Payroll system and Attendance monitoring
Responsibilities:
Collected requirements and prepared requirement specifications.
Designed and developed in VB 5.0
Created smartcard interface using visual basic DLL.
Installed Smartcard Readers.
Involved in documentation, implementation and testing of the system.
Written views and functions in Oracle 8.0.
Generated various reports.
Involved in offshore support
Environment: VB 5.0, Oracle 8.0, Smartcard Reader
Horticultural Producers Co-operative Marketing
Jan'98-Jan'99
and processing Society, Bangalore
Programmer/Analyst
This Project is a Client-Server Architecture for computerizing
Horticultural Producers Co-operative Marketing and processing Society.
Responsibilities:
Involved in documentation, implementation of the system.
Designed and created database tables in Oracle and user interface forms by
using Visual Basic.
Written views and functions
Generated various reports using Crystal reports 4.5.
Environment Visual Basic5.0, Oracle 7.3
Education
Master in Computer Science
Contact this candidate