SUMMARY:

• Microsoft certified technology specialist with 7+ years of strong experience in the IT industry as a SQL Server Developer/BI Developer.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP - Online Analytical Processing technologies.
• Extensive experience in writing complex SQL Server 2000/ 2005/2008 Stored Procedures, Views, Function, and Triggers in SQL Server Management Studio using T-SQL Programming.
• Extract, Transform and Load data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, text format data using OLE DB connection by creating various DTS & SSIS packages.
• Experience in DTS Packages and data designer usage.
• Moving DTS packages from one environment to another (SSIS).
• Designed and developed the entire business intelligence reports using SQL Server Reporting Services 2005 and integrating it to the front end application.
• Experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering.
• Experience in recreating existing Data marts, OLAP Cubes, Deploying Cubes and Partitioning cubes.
• Easily adapt to new technologies at greater pace and fulfill the project goals and objectives.
• Good sense of teamwork, quality and integrity.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003/2008, NT 4.0, Win XP Prof/Standard, Win 98.

Databases: SQL server 2000, SQL server 2005, SQL Server 2008/R2, MS Access, My SQL, Sybase

Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, Business Intelligence Studio

ETL Tools: SSIS, SSRS, SSAS

Languages/Utilities: T-SQL, MS Enterprise manager, Query Analyzer, BCP, SQL Agent, Erwin, SQL profiler.MS DTS(export and import),Index Analyzer, DTS Backup Server, SQL Alerts, SQL Jobs

Data Modeling: Microsoft Visio, DB Designer, Front Page, Erwin

EXPERIENCE:

Confidential, Santa Ana, CA

ETL/ SQL Developer

Responsibilities:

• Involved in gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design documents and Approach documents.
• Created High Level Design (HLD’S) for Tier-3 Modules which involved Payment Processing, Power to Sale and Tax Compliance and Operation.
• Created Mapping documents for Payment Processing, Power to Sale and Tax Compliance and Operation module which involves discussion of the business logic from Internal Users and applying them on Legacy database to target system.
• Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration services (SSIS).
• Used the SSIS Configuration files to make the packages connections, variables etc configurable and maintained the same on Test and Production environments.
• Designed Program code for data migration from the Mapping documents.
• Utilized extensively SSIS packages functionality to create and complete ETL process using scripts, stored procedures, functions, transformation of data.
• Created a program to apply Penalties for Secured and Unsecured Tax Bills.
• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc,
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc in SSIS packages.
• Designed and Build Cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and also Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Created interactive reports for sorting, different Parameterized Reportswhich consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required for Tier -1 and Tier 1A Data warehouse.
• Scheduling jobs and Alerting using SQL Server Agent.
• Improved performance of the system by suggesting composite indexes.

Environment: MS SQL Server 2008/2005, Reporting Services (SSRS 2005/2008), SSIS, Visual Studio 2008, Windows 2003 Server, BIDS, MS Office 2007, MS Access, MS Excel, Framework, VB, ASP.NET, DB2.

Confidential, NY

SQL/ BI Developer

Responsibilities:

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and performed different kinds of transformations using SSIS.
• Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Converted all existing DTS package of MS SQL 2005 to SSIS packages by using package migration wizard and Deployed new Package in different Server.
• Optimized the performance of queries and Stored procedure by creating, recreating and dropping indexes wherever necessary using query execution plans.
• Migrated SQL server 2005 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2005 Upgrade Advisor
• Created package configurations for dynamic connection string and to provide values to the global variables in the SSIS package at the run time.
• Involved in capacity planning, disk usage, processor and memory usage during allocation management for Development, Staging and Production environments.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Involved in creating cubes in Business Intelligence Development Studio (BIDS), deploying them on the server and processing the OLAP cubes to generate aggregate data for faster querying.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages on the .NET applications.
• Designed and involved in troubleshooting the reports using report manager for the SSRS.
• Designed and Build Cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Extensively used SSRS for building complex Reports according to the business Requirements and deployed to various environments.
• Optimized the query performance on Cube by following the recommended best practices.

Environment: MS SQLServer2005/2008, MS Access, Query Analyzer, DTS, SSIS, SSRS, BCP, SQL Profiler, Windows 2000 Server.

Confidential, Basking Ridge, NJ

SQL/ETL Developer

Responsibilities:

• Written many complex stored procedures to assist the data import and export
• Created and updated tables, reports and populate the data into power point dynamically
• Performed Scheduling jobs and Altering using SQL Server Agent
• Written a number of T-SQL queries and a number a nested queries and worked with enterprise manager in SQL
• Worked on SSIS packages in SSIS, DTS Import/Export for transferring data from other databases
• Imported data from excel sheets into SQL Server
• Used Visual studio to analyze the reports using SSAS
• Deployed SSIS packages and Scheduled Jobs and Extracted data from XML and flat files using SSIS.
• Worked extensively with OLAP cubes to access the size of the database
• Written some MDX queries.
• Worked extensively with fact tables, measures, dimensions while creating cubes.
• Used cubes for the analysis of the data for a particular requirement
• Created test cases from project documentation that can be understood to anyone with a vast knowledge of application
• Deployed a number of reports on the server and also deployed them on a SharePoint server
• Ensured test cases are mapped to the requirements
• Met project schedule deadlines for several complex projects
• Report daily testing status using the Standard test status analysis

Environment: MS SQLServer2000, MS Access, Query Analyzer, SQL Profiler, Import & Export Data, Windows 2000 Server, SSIS, SSRS.

Confidential, Blue Bell, PA

BI Developer/SQL Server Developer

Responsibilities:

• Developed database objects such as SSIS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Identified, modified, tested, and resolved database Upgrade & conversion related issues.
• Worked on SCD (Slowly changing dimensions) type I and II in order to keep historical data in enterprise data warehouse.
• Worked on staging database, data clean up, data cleansing and concatenation of data in staging environment through ETL process and T-SQL queries.
• Createdconfiguration files for SSIS packages and migrated on \Dev, \QA, \UAT and \Prod environment.
• Migrated data from legacy system (text based files, Excel spreadsheets, SQLServer 2000 and Access) to SQL Server databases using DTS, SSIS.Data conversion from SQL Server 2000 to SQL Server 2005.
• Deploy DTS packages into SSIS and develop new SSIS packages.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL andDTS/SSIS.

Environment: T-SQL, SQL Server 2008/2005 (Query Analyzer, Enterprise Manager, SSIS packages, SQL Profiler), SQL Server 2000, MS Excel, MS Word, Erwin 4.1.

Confidential

SQL Developer

Responsibilities:

• Involved in the development and testing of application.
• Involved in developing Data Access Layer.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Migrated MS Access database to SQL Server 2000 and also created, tested and optimized Stored Procedures and SQL queries.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: ASP.NET 1.1, Java Script, HTML, MS Access, SQL Server 2000, T-SQL, Visual Studio 6.0, Windows 2000 Server.