SUMMARY:

• Dynamic result oriented Technical design developer with 7years of experience in design & coding of database and applications as SQL Server and Informatica. Work experience in major sectors such as Sales, Financial Services, Insurance, Banking Sector and Technology.
• Developed complex Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objectscreation such as Tables, CTE, User Defined Data Types, Stored Procedures, Views, User Defined Functions and Triggers.
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Efficient in creating SSIS Packages. Created packages to extract data from flat files, TeraData, Oracle and DB2 and transform the data according to the business requirements and load the data in SQL server tables.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS) and Informatica.
• Experienced in performing Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems, ERP to SQL Server 2000/2005/2008.
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Designed and developed DB2, OLTP and OLAP databases in support of Service Oriented Architecture solutions.
• Experience in generating various types of reports like Dropdown List, Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.
• Developed reports using Expressions and Functions. Performed Expressions in reports to control content and report appearance. Used Functions to manipulate the specified expressions.
• Thorough experience in Database Backup, Recovery. Performed Backup and Recovery when data damage, loss or corruption occurred.
• Involved in maintaining, designing, and building system applications to satisfy business needs of the client.
• Experienced on Performance monitoring using SQL Profiler scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.
• Design High Level Intermediate ETL Design documents and Logical data mapping for the Decision Supporting System based on the data warehousing practices and standards.
• Design and Developing Automated UNIX Shell scripting for loading, running the mappings and validating the data in the data warehousing system.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• Experience in working creating Multidimensional cubes using SSAS for sales, Inventory, operational, merchandising and financial environment.
• Good knowledge in Tuning SQL Queries and ETL Code to Improve Performance.

EDUCATION

• Bachelors in Electronics and Communication Engineering

CERTIFICATIONS

• 070431: Microsoft SQL Server 2005 Implementation and Maintenance

SKILLS
Languages T-SQL, PL/SQL, C, C#, HTML, XML, VB script.
Operating Systems MS-DOS, Windows 95/98/NT/XP/2000/2003 Server, UNIX.
RDBMS/ Databases MS SQL Server7.0/2000/2005/2008, IBM DB2, PL/SQL.
Data Warehouse Tools OLAP, SQL Data Transformation Services (DTS),
Netezza, Informatica.
ETL tools SSIS, DTS,Informatica 6.0/7.1/8.1/8.6.
Reporting Tools Microsoft reporting server, Business Objects, Crystal Reports,
Performance Point, Microsoft Technologies VB.NET, ASP.NET.
Application Areas Replication, DTS/SSIS, SSRS, SSAS, Informatica, Log
Shipping, Data Mirroring, Performance Tuning, Backups, Restore
And Database Security.

EXPERIENCE

Feb '11 - Present SSIS/SSRS Developer, Confidential, Bloomington, Illinois.
Confidential, is the one of the leading Insurance company with more than 68,000 employees and 18,000 agents service 81 million policies and accounts throughout the US and Canada.

• Created new database objects like Tables, User Defined Functions, Triggers, Procedures, Functions, Indexes and Views, SQL joins and statements as per the developer team's request through team tracks.
• Involved in data cleansing to facilitate efficient data transfer between various environments.
• Analyzed performance related queries and tune the same using SQL Query Analyzer to optimize application and system performance.
• Wrote Stored Procedures / Transact-SQL scripts, Altered/Re-indexed tables as per the business need.
• Involved in administration tasks such as importing, exporting and transforming data to support data consolidation using MS SQL Server 2008.
• Involved in monitoring database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Designed SQL Server Integration Services (SSIS) packages to extract data from JDE to SQL Server Data Warehouse following the JDE specs and SQL Server standards.
• All SSIS standards are followed to maintain reliability and scalability in the extraction.
• Completed database logging, error logging, checkpoints and configuration files were taken care of in all the development, QA and Production environments.
• Performed OLAP data functionalities for Business Intelligence applications using SQL Server Analysis Services (SSAS 2008).
• Implemented cell based security by creating roles for different users based on their access to the data.
• Worked on the script components in SSIS using VB script for getting latest files and ETL logging areas.
• Created Configuration files with XML documents to support the SSIS packages in different environments.
• Generated interactive reports using SQL Server Reporting Services (SSRS 2008) as per the client's request.
• Created multiple operational and finance reports and Charts and scheduled them to run Hourly, Daily, Monthly according to client requirements for the periodic analysis using SSRS 2008.
• Documented all the project work in support for maintenance.

Environment:
SQL Server 2005/2008, SQL Server Integration Services(SSIS), Microsoft Reporting Service (SSRS), MS Excel 2007, MS Access 2003, Enterprise Manager, Toad, Share Point 2010, Ultra Editer, Chilkaat Components, ASP.NET, Red gate, Informatica, Cognos, BizTalk, SQL Profiler, Trash Destination and IDERA (Diagnostic manager), MS Visio, Unix, TFS 2010.

Apr '10 - Jan'11 ETL Developer SSIS/T-SQL/SSRS. Confidential, Dunmore, PA
Confidential, is one of leading publisher in UK/USA, supplies books to big companies like EBay, Amazon, Apple(IBook's) etc., My role here, clean the data(Flat file) by designing SSIS package and then load into SQL server tables to maintain Audit and send across the cleaned file to Business Analysts, wrote C# code where ever necessary.

• Wrote Stored procedures where ever Necessary, to maintain Archives and Error tables.
• Scheduled Jobs using TOAD, to run the batch files. Send the automated mail to Manager and team members.
• Worked on data cleansing by creating SSIS packages against the Flat Files.
• Wrote C# code in Script Component to maintain daily, weekly and monthly Flat files.
• Created tables, views, functions and Stored procedures wherever necessary.
• Developed packages to send Sales information of Companies like Amazon, EBay, KOBO, Apple etc., in PDF or Excels formats.
• Created reports to analyze the sales based on business requirements and specifications.
• Worked on Netezza application for handling large queries from multiple users.
• Created reports Monthly, Weekly and Daily Sales reports.
• Responsible for identifying Key Performance Indicators (KPI), attribute relationships, aggregations using SQL Server Analysis Services (SSAS 2008).
• Wrote C# code where ever scripting is necessary especially to manipulate the files coming from UNIX box.
• Created Backups using Lite Speed for daily sales and monthly Sales.
• Used Red gate Tools for comparing the database while migrating to new data base and creating a new data base to check dependencies.

Environment:
SQL Server 2005/2008, SQL Server Integration Services, MS Excel 2007, MS Access 2003, Enterprise Manager, Toad, Ultra Editer, Chilkaat Components, RedGate Tools, SQL Profiler, Trash Destination and File Watcher Components, IDERA (Diagnostic manager), Informatica, MS Visio, Unix.

Sept '09 - Mar '10 SSIS/Informatica Developer, Confidential, Tampa, FL
Confidential, is a leader in delivering broadband and other wire line and wireless communication innovations to mass market, business, government and wholesale customers. I worked for Verizon Product Facilities (VPF), migrating existing Informatica Mappings to SSIS Packages.

• Created new database objects likeTables, User Defined Functions, Triggers, Procedures, Functions, IndexesandViews, SQL joins and statements as per the developer team's request through team tracks.
• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Import/Export and successfully migrated the Databases such as DB2 and MS Access to SQL Server 2005 using SSIS. Scheduled the same packages by creating the corresponding job tasks.
• Created packages to extract data from flat files,Teradata, Oracle and DB2 andtransform the data according to the business requirements and load the data in SQL server tables.
• Created Complex packages by understanding Informatica Mappings, workflows and sessions.
• Involved in Analyzing, designing, building & , testing of OLAP cubes with SSAS 2005. Identified and defined Fact and dimension relationships. Partitioned the cubes on daily, weekly and monthly based.
• Worked with DTEXEC and DTUTIL utilities for scheduling in SQL Server Integration Services (SSIS) and jobs in SQL Server.
• Worked on the Support to solve the existing Informatica mappings issues and SSIS packages.
• Created Check Points, Breakpoints, Database Logging and Event Handlers where ever necessary. Created Configuration files with XML documents to support the SSIS packages in different environments.
• All SSIS standards are followed to maintain reliability and scalability in the extraction.
• Involved in data cleansing to facilitate efficient data transfer between various environments.
• Documented all the project work in support for maintenance.

Environment:
SQL Server 2005/2008, SQL Server Integration Services (SSIS), Informatica 8.6.1,Business Intelligence Development Studio (BIDS), Oracle 10g, 9i, IBMDB2, Unix, Advanced Query Tool(AQT).

Feb '08 - Aug '09 SSIS/SSRS, Confidential, Atlanta, GA.
Confidential, serves more than 160 million customers each year. With its unsurpassed global network, Delta and Delta connection carriers offers service more than 350 destinations in nearly70 countriesin 7 continents. Delta employs more than 70,000 employees worldwide and operates a mainline fleet of nearly 800 aircraft. As a part of team, my responsibilities included creating packages to extract data from flat files, transforming and loading the data into SQL server tables, designing DTS and SSIS packages, providing technical support and guidance to operational models by checking for data quality and its consistency while developing.

• Created SSIS packages for extracting, transforming and loading the data from SQL Server 2000 and flat files.
• Migrated Informatica mapping to the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005.
• Designed and developed complex Mappings, Mapplets and reusable transformations using various Transformations.
• Responsible for creating batches and scripts for implementing logical design to T-SQL.
• Performed T-SQL tuning and optimizing queries using SQL server 2005.
• Involved in maintaining, designing, and building system applications to satisfy business needs of the client.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the legacy databases to SQL server.
• Performed trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Modified old crystal reports by adding new business requirements using SSRS and Create reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Created useful user defined functions and multifaceted stored procedures for reporting purposes.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS and Configure Report Manger and run reports on weekly and daily basis.
• Created Documentation for the packages and scripts and created job to migrate data from legacy system to SQL Server 2000.
• Created datasets using stored procedures and reports using multi value parameters, Created sub reports, bar charts and matrix reports.

Environment:
SQL Server 2000/2005, SQL Server Integration Services, MS Excel 2003, Informatica 8.6, Enterprise Manager, Management Studio, MS SQL Query Analyzer, SQL Profiler and SSRS and Crystal report 9.0.

Sep '06 - Jan08'ETL Developer, Confidential, Hyderabad,India.
Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions and for managing banks property and equipment.

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Designed and developed tables, view, stored procedures and triggers in MS SQL Server database on Windows NT platform.
• Migrated SSIS packages 2005 to Informatica Mappings by applying proper transformations for long term use.
• Proficient in designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router and rank.
• Perform unit testing at various levels of the ETL.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Designed and developed reports using Crystal Reports.

Environment:
SQL ServerBI 2000/2005, Windows NT platform, Visual Basic 6.0, Crystal Reports 9.0, Informatica.

July '05 - Aug '06 ETL Developer, Confidential, Hyderabad, India.
Confidential, is a software products and services company that focuses primarily on Business Management system, Transaction Billing & Banking solutions. It provides custom software development to the clients.

• Writing DTS Package to import Data from Excel sheet and Text Files to Database Tables.
• Installation of SQL Server 2000.
• Designed Logical and Physical database design using Diagram feature in SQL Server
• Writing Stored Procedure and Triggers.
• Creating Databases and Users.
• Configuration of SQL Server Jobs for Full, Differential and Transaction Log Backup.
• Restoring the Database to Disaster Recovery Server.
• Performing Point in Time Recovery.

Environment:
MS SQL Server 2000, Windows 2000, Windows 2000 Professional, Microsoft VBScript/Script, T-SQL.