SUMMARY

• Over 7 years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.
• Experience in Development and Implementation of Client - Server Applications & Database systems using MSSQL 2000/2005/2008 for both OLTP (Batch Processing, Online Processing) & Business Intelligence (SSIS, SSAS, SSRS) applications.
• Extensive experience in T-SQL to write: stored procedures, triggers, user defined functions, tables, views, cursors, indexes and relational database models.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Strong experience with ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Merge Join.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Created data sources, connection strings and defined the datasets for generating the report.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Drill-through, Parameterized reports, Linked reports, OLAP and Sub reports, and formatting them using both SSRS 2005/2008.
• Strong ability in defining query for generating Cascaded Reports, Custom Reports and creating stylish report layouts in SSRS 2005/2008.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Experience in database performance tuning and query optimization, data integrity and statistics.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Knowledge of Software Development Life Cycle (SDLC).
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Possess excellent oral / written communication and interpersonal skills.
• Proficient in technical writing and presentations and a good team player.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

Data Bases: MS SQL Server 2000/2005/2008 , Oracle 9i/10g, MS access

Languages: C/C++, SQL,T-SQL, PL/SQL, HTML, XML

ETL Tools: SQL Server Integration Services (SSIS), DTS

Operating Systems: Windows Server 2000/2003/2008 , Windows XP/Vista.

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, Profiler, Export & Import (DTS).

Business Intelligence Tools: Business Intelligence Development Studio (BIDS)DTS Packages, Server Reporting Services (SSRS)SQL Server Integration Services (SSIS), Cognos report studio.

Web Technologies: VB.NET, ASP.NET, C#.NET, ADO.NET, Visual Studio.Net

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

SQL Server BI Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specifications.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Involved in designing and implementing database applications using MS SQL Server 2005/2008 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Developed complex T-SQL code for the application.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created various database objects such as tables, indexes and views based on the requirement.
• Automation of creating Accounting code module for each account.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.
• Wrote complex T-SQL queries for data extraction.
• Created DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Documentation of SQL objects using Red Gate’s SQL Source Control tool and Erwin.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Created Report Subscription and Data Driven Subscription using SSRS 2008R2.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Monitor and provide support to the application during the testing and production environments.

Environment: SQL Server 2008R2/2008/2005, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services),Business Intelligent Studio, SQL Server Management Studio, ASP, Enterprise Manager, MS Excel, Windows XP Professional.

Confidential, Wilmington DE

SQL server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up & Recovery.
• Developed stored procedures, functions, views and triggers.
• Migrated SSIS packages from SQL server 2005 to SQL server 2008
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created indexes, constraints and rules on database objects.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.

Environment: Windows XP Professional, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, SSIS.

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.

Environment: SQL Server 2005, Oracle, Toad, SQL Server Management Studio, SSIS, SSAS, SSRS, Mirroring, Replication, WINDOWS 2003, ETL, Log Explorer, Visual Studio 2005/2008, VISIO, ERWIN, Excel Macro 2003, Data-Warehousing.

Confidential, Augusta, ME

SQL Server Developer/DBA

Responsibilities:

• Rebuilding the indexes at regular intervals for better performance.
• To analyze long running slow queries and tune them to optimize application and system performance.
• Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files
• Created and managed schema objects such as tables, views, Indexes, procedures, triggers, while maintaining referential integrity.
• Used SQL Profiler for troubleshooting, monitoring, optimization of MS SQL Server and non-production database code.
• Created SSIS packages to import data from MS Access, Excel to MS SQL 2005 and generated reports using SSRS.
• Involved in Test Script development, Verification, Testing, Data Extraction and Loading using DTS, Import and Export Utility.
• Created stored procedures for the business logic using T-SQL.
• Created job schedules to automate the routine tasks.
• Performed Database Normalization.
• Involved in performance tuning.
• Created DTS packages for the data cleansing/transfer and transformation.
• Worked with SSIS for data integration.
• Responsible for creating fact and dimension tables.
• Responsible for providing 24 X 7 dedicated production supports.

Environment: Windows XP Professional, MS SQL Server 2005, SSIS, SSRS, T-SQL, PL-SQL.

Confidential

Jr. SQL DBA/Developer

Responsibilities:

• Worked on escalations, troubleshooting complex SQL issues
• Implementing High availability solutions (setting up log shipping, Cluster installation)
• Performed Log shipping, cluster Failovers to maintain high availability
• Involved in root cause analysis for blocking and on-going SQL issues
• Suggesting backup strategy for clients and working on performance tuning issues on a need basis.
• Modification of existing stored procedures and development of new modules, tools related to enhanced support management.
• Organized trainings and transferring Knowledge to the team members.
• Participated in root cause analysis meetings with clients and post mortem analysis meetings conducted by clients.
• Performance tuning the DBA issues for SQL Server Instances.
• Auditing of Incidents and plan to automate recovery procedures.

Environment: SQL Server Enterprise 2000, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, Windows Server 2000, Query Plan, Profiler.