SUMMARY

• Over 7+ years of IT experience as a MS SQL Server Developer specializing in database design, development & administration work with SQL Server 2008R2,2008, 2005 and 2000 for OLTP, OLAP and large - scale data warehouse applications using SSMS.
• Experience indata warehouse development with Integration Services, Analysis services and OLAP report development.
• Experienced in creating real time applications using QlikView for various data sources such as SQl, Excel, AS-400.Created some real time sales and demand applications which can give the growth of the business hourly.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
• Strong knowledge in database design features including ER Diagrams, normalization, tables, views, indexes, constraints, keys,data dictionaries, and data integrity.
• Experience in Data Modeling & Database Design with Erwin, Performance Tuning and Optimization of SQL Server 2005 and 2000.
• Extensive experience in developing complex Stored Procedures, Functions,Triggers, Views, Cursors, Indexes, Joins and Sub queries with T-SQL.
• Designed an interface in C# and also gave some attributes to WCF an also has good command in Windows Communication Foundation (WCF) with creation, hosting and deployment.
• Experience in performance tuning and query optimization using toolslike SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Experience in Data Modelling i.e. designing of OLTP database.
• Hands on experience in migrating DTS packages to Integration Services Packages.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS,Bulk Insert and BCP.
• Extensive experience in developing and deploying SSIS 2005 packages.
• Experience in Handling Heterogeneous data sources and databases Oracle, IBM DB2 and csvandXML files using SSIS.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQLServerReporting Services (SSRS).
• Involved in Every stage of Report authoring, managing, developing, deploying.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in migration of MS SQL Server 2000 to MS SQL Server 2005 (Side by Side).
• Experience in installing, configuring and monitoringMS SQL Server 2008/2005/2000 installations.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning.
• Strong knowledge in implementing Transactional, Merge and Snapshot replications.
• Good understanding of high availability SQL Server solutions using active-active and active-passiveClustering modes.
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Excellent verbal and written communication skills combined with interpersonal, organizational and conflict resolution skills as well as strong analytical skills.
• Creative and aggressive self-starter with integrative thinking-skills, capable of forming and maintaining positive and productive working.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2008/2005/2000 , Oracle 11g/10g/9i/8i, Teradata V2R5, MySQL and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Programming Languages: HTML, C#.Net, VB.Net, C++, T-SQL, PL/SQL,PERL,COBOL,SAP

Design Technologies/Tools: Erwin, MS Visio

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr. Data Warehouse Developer (SSRS/SSAS/SSIS)

Responsibilities:

• Involved in building dimensional cubes with SQL Server Analysis Services(SSAS)and querying the data withMDXscript.
• Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various Data sources and thus developed Cubes.
• Create prototype SQL Server 2008 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Created and developed some real-time sales and demand applications using QlikView from various types of data sources.
• Generated Reports from the cube by using MDX Queries and created calculated members.
• Generated various reporting servicesRDL’S using reporting services for Account Aggregation reports
• Developed Custom Selection of reports ordering using SQL Server Reporting Services.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies and formatted them using Global variables and expressions
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services
• Created Reports with all Aggregate functions and Expressions using SSRS and VB.NET.
• Worked on ETL SSIS Development, Created packages using various transformation techniques and also created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.
• Created Batch Files for the Autosys Jobs for the procedures to run on a daily and weekly basis.
• UsedSQL Server profilerfor auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part ofPerformance Tuningoperations.
• Involved in migrating the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2008 Management studio
• Created Fact tables and Dimensions and deployed them to the existing cube.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database
• Extensive testing on the Performance of the Stored Procedures by using the execution plan.
• Monitored performance and fine-tuned the database objects and server to ensure efficient data retrieval.
• Managed existing indexes in ROLAP to optimize the performance of reports accessing it as well as all other BI applications.

Environment: MS SQL Server 2008Visual Studio, MS SQL Server 2008 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, SQL Server CE client, ASP.Net, vb.Net, VB Script, MS Access, Lite Speed Backup software, DTS, MDX, Sybase, OLAP, Windows 2008/XP, MS Visio

Confidential, Sunbury, PA

Sr. BI/MS SQL Server Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed software and database solutions.
• Worked closely with database to design and implement database components in timely manner.
• Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
• Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.
• Implemented other new T-SQL features added in SQL Server 2005 Like Error handling through TRY-CATCH statement, Common Table Expression (CTE)
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
• Used Change Data Capture (CDC) functionality of SQL Server 2008 alongside SSIS to populate the destination tables with inserted updated and deleted data.
• Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container, FTP
• Used configuration files, to migrate SSIS packages from development stage to quality analysis (testing) without having to reconfigure the packages.
• Updated database statistics, Re-indexed and fine-tuned of database objects and server
• Extensively worked on DTA, DMV’s, Online indexing, Data Partitioning and tuning of long running stored procedures and complex queries Designed the data warehouse structure, datamodeling and developed it using the Erwin tool, MS Visio.
• Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing, Cleansing, and Parsing etc.
• Normalized the and De normalized the Database dealing with more than 200+ tables as per the requirement of OLTP and OLAP database environments
• Reviewed cube with end user and changed the cube and documentation according to their requirements using SQL Server Analysis Services (SSAS).
• Assisted end users in USER ACCEPTANCE TESTING, by explain all the functionality of the data warehouse and its applications
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created complicated reports like parameter based reports, graphical reports, well-formatted reports, drill-down reports, matrix reports, chart and tabular using SSRS.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Developed MDX queries for Analysis Services & Reporting Services.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
• Designed a new schema for the OLAP database.
• Involved in installing and migrating legacy databases to SQL Server 2008.
• Involved in developing in prototype for front end application used for testing purposes using C#.
• Responsible for regression testing ETL jobs before test to production migration.
• Resolvedandclosedthe Production tickets generated due to failure of daily incremental production jobs.

Environment: MS SQL Server 2008/2005, VS2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), MDX, DTS, Microsoft Office SharePoint Server (MOSS) 2007, MS Visio, Erwin.

Confidential, Oklahoma City, OK

Sr. BI/MS SQL Server Developer (SSRS/SSIS)

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Transferred Data Base From SQL Server 2005 to SQL Server 2008 by Backup Technique.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Performed the Tuning of some existing ETL. The process time was reduced from 8 hours to approx. 6 hours. This was 25% gain in performance.
• Developed stored procedures/Packages using T-SQL, PL/SQL programming to meet the business requirements.
• Worked on PROCLARITY to create OLAP datasets and queries are created directly from unified Dimensional Model
• Used Visual Studio 2008 tool to design web based application and used ADO.NET to link the heterogeneous databases (like Oracle 9i using ODBC, SQL Server using OLEDB) to this application
• Developed unit test plans for SSIS packages.
• Provided documentation for all kinds of reports, DTS and SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on daily/weekly/monthly basis.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part ofPerformance Tuningoperations.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• UsedSQL Server profilerfor auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Designed GUI interfaces using various controls provided by C#, ASP.NET environment
• Managed existing indexes in ROLAP to optimize the performance of reports accessing it as well as all other BI applications.
• Involved in building dimensional cubes with SQL Server Analysis Services(SSAS)and querying the data withMDXscript.
• CreatedXML configurationfiles so that packages can be executed on any server/database by changing the configuration path in the XML files.
• Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
• Created cubes for the analysis of Insurance sales in specific areas Using Star Schema.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis.
• Implemented Performance Tuning In SSAS by Partitioning Technique In All MOLAP,ROLAP and Also HOLAP Environments
• Involved In Writing MDX Expressions Both Parallel Period And Non Empty Cross Join Expressions.
• Worked With KPI (Key Performance Indicator) While Developing Reports From Cubes. To set Certain Goals Every Month and Updated Status.

Environment: SQL Server 2008/2005,SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Windows Server 2003, DTS, T-SQL, SQL Profiler, SQL Server Agent, ProClarity, Oracle, MS Excel, C, C++, Visual Studio 2008, .Net (Asp .Net, C# .Net), Data Explorer.

Confidential

SQL Server DBA/Application specialist

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on Servers. Applied patches and service packs to keep the database at current patch level.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Implemented stand by servers and Log shipping
• Updating with latest service packs and security patches.
• Developed SQL scripts for maintaining administration tasks.
• Performance tuning of T-SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Conversion the legacy systems data into MS SQL server using DTS packages.
• Solved critical production problems and performed point in time recovery plans.
• Created Triggers to enforce data and referential integrity
• Worked on Migration techniques across different databases and servers
• Performed everyday backup and developed recovery procedures.
• Involved in Creation of new database, planning the location of data, index, and transaction log files on the disks.
• Created packages, procedures, functions, and triggers; handled database performance tuning.
• Used performance tuning techniques to improve performance for the slow running SQL.
• Used Execution plans and Hints to modify the SQL and increase the performance.

Environment: Windows 2000/XP, SQL Server 2000, Query Analyzer, T-SQL, SQL Profiler