SUMMARY

• 6+ years of experience in MS SQL Server 2000/2005/2008 and .Net Technologies.
• Solid experience in Designing and developing high - volume DTS/ETL SSIS SQL Applications for efficiency and maintainability.
• Expert experience in ETL processes transferring/rewriting DTS packages to SSIS (SQL Server Integration Service) programs. Proficient in SSIS project design, implementation and troubleshooting
• Extensive working experience in using/generating Visual Studio 2008 BI Reports, SQL Server 2008 SSRS(SQL Server Reporting Service), ad-hoc reports using Crystal Reports, Crystal Analysis and development and deployment of Publishing Reports on the Internet and Internet.
• Proficient in Data warehousing and SSAS skills: MDDB/MDX, OLTP, OLAP (MOLAP, HOLAP, and ROLAP), Relational and dimensional modeling skills (star schema and snowflake schema). Strong experience in design and construction of data marts and data warehouse
• Solid knowledge and working experience in installing, configuring and managing SQL server 2000/2005/2008 , updating SQL Server 2005 to SQL Server 2008, migrating existing applications to SQL 2008
• Extensive experience with SQL Server and T-SQL in constructing tables, views, triggers, indexes, functions, stored procedures, user profiles, relational database models, data dictionary, data
• Hands-on working experience in SQL database architecture, data modeling, logical and physical database design utilizing Erwin Data Modeler, focusing on high-activity, normalized transaction systems (OLTP), highly-usable denormalized reporting systems (OLAP), staging areas and data marts.
• Hands-on working experience in design and implementation of Backup and Recovery strategy. Working experience in using Enterprise LiteSpeed to perform backup and recovery of databases.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and Data Replication.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and troubleshooting deadlocks
• Thorough understanding of Service Broker and hands-on experience with Service Broker Applications
• Hands on working experience in PL/SQL and T-SQL for writing Stored Procedures, Triggers, creating Tables, Indexes, Views.
• Experience with software development life cycle (SDLC) and project methodologies
• Hands-on experience with Microsoft SharePoint Service and BizTalk Server
• Hands-on experience in developing .NET C# based Window Application, ASP.net website with support of SQL Server 2008.
• Experienced in different business industries like Equity Trading, Finance, Manufacturing, Retail and Banking.
• Experience in mentoring teams and excellent presentation and communication skills, Team Player, Organized and Self Motivated.

TECHNICAL SKILLS

Programming Languages\Distributed Computing\: C#, C++, VC++, Visual Basic, SQL, \XML Web Services, SOAP, WSDL, \PL/SQL\WCF\

Web Skills\Web Servers\: HTML, XML, XSL, ASP, JavaScript, \IIS 5.0/6.0 \VBScript, ASP .NET\

Databases\Data Access\Databases Technologies\: SQL Server 2000/2005/2008 , Oracle 9i, \SSIS, SSRS, SSAS, OLAP, OLTP, DTS \Sybase, MS Access, ADO.NET\

Tools: and Utilities\Operating Systems\: Dundas charts\ Crystal Reports, MS Visio \Windows 2000/XP\2000/2003, VSS, Code Analyzer, \Windows server 2003\ UNIX\Query Analyzer, SQL Profiler, Data Base \Engine Tuning Advisor, Erwin 4.1/7.2, \LiteSpeed 3.1 SharePoint Service 3.0/ \ProClarity/BizTalk Server 2004\

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

DBA/Business Intelligence Developer

Responsibilities:

• Designed and created a data warehouse to maintain data for reporting purposes using SQL Server 2008.
• Designed and created partitioned tables to handle more than 2 billion rows per table. Partitions were spread across multiple disk arrays to increase performance of each table.
• Created Clustered and non clustered indexes to improve the performance of the warehouse.
• Designed and implemented the sliding window load to accommodate new data as it comes to the warehouse. Also optimized the warehouse for constant updates and inserts for new data
• Updated stored procedures that were accessing the old schema to work with the new schema
• Created maintenance scripts to keep the indexes and the partitions in optimal state for rapid query performance
• Involved in testing and fine tuning the system to make sure it can perform at its best.
• Redesigned the existing reports in SSRS 2008 to remove dependency on third party tool and recreated them in native SQL Server reporting server controls.
• Optimized the existing stored procedures to speed up data retrieval for client facing on-demand and ad-hoc reports.
• Designed new database tables to support new features being introduced in the company’s client facing CDN application.
• Created triggers, stored procedures, views, user defined data type and functions to support new development for the CDN application.
• Heavily involved in migrating the database from the server in LA to the server in Atlanta with almost zero down time using log shipping.
• Involved in daily maintenance and trouble shooting of 5 different existing applications with prompt resolution of issues and bugs.

Environment: SQL Server 2008 Enterprise, Windows XP Professional, Business Intelligence Development Studio 2008, SSRS, Team Foundation Server

Confidential, Tarrytown, NY

DBA/ Business Intelligence Developer

Responsibilities:

• Designed, created and maintained a data warehouse to host reports intended for Construction Industry Institute’s (CII) policy compliance using SQL server 2008.
• Transferred data from various data sources, SQL databases and EXCEL files, and loaded into the PMTS warehouse using an SSIS package.
• Designed and created the reports for the CII compliance using Dundas Charts for reporting services software. The reports are being used as industry standards for the policies implemented by the CII and are being used by CII as example for other companies to create similar reporting systems.
• Converted more than 30 reports from a legacy sales system which were created using SQL server 2005 to the new system using SQL server 2008.
• Created reports with dynamic groups and dynamic sorting. Users were given the choice to choose the way the resultant data was grouped. Also created drill down and drill through reports.
• Consolidated the data into a single table for these reports using a linked server to the transactional database. Created a stored procedure to run on a nightly basis to update the data for the reports. Set up the job to send an email to the project manager in case the process failed to complete.
• Increased the performance of the table by creating indexes on mostly used columns and made the retrieval of data faster for the reports.
• Migrated data from the old Value Plus system to the new database using SQL Server Integration Services (SSIS) Packages.
• The data, for the new value plus system was also cleaned, filtered or consolidated based on the business needs of the new site. Found and fixed many data anomalies in the source system.
• Integrated data between an Oracle based financial System and an SQL based accounting system. Also setup a job to transfer data to Oracle every 15 minutes and also receive from Oracle on schedules varying from 10 minutes to daily using OpenQuery.
• Created a completely dynamic system for a global project management system that the company is using to track incidents on its construction sites and improving the oversight of projects. The system can in corporate any new measurement by adding only a single row of data into the measurement table.
• Parsed formulas stored in the database and calculated the values using table valued functions and scalar valued functions.
• Created and populated a data warehouse for the Quality Data Systems dashboard using SQL Server Integration Service (SSIS) Package. Also created a dashboard report based on this data warehouse.
• Created a dashboard report for the Quality system using DUNDAS gauges to keep a track of project activity and timeliness.
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.

Environment: SQL Server 2008 Enterprise, SQL Server 2005 Enterprise, Windows XP Professional, Business Intelligence Development Studio 2008, Microsoft Visio 2003, SSIS, SSRS, Team Foundation Server, DUNDAS Chart/Gauges for Reporting Services, Oracle 10.1

Confidential, Atlanta, GA

Business Intelligence Developer

Responsibilities:

• Did data extraction from various sources transforming and loading into the target SQL Server databases using ETL tools, SSIS 2005.
• Created SSIS packages with which data resources such as Excel and XML were loaded daily in order to create and maintain a centralized data warehouse. Made the package dynamic so it fit the environment.
• Expertise experience with administering and debugging SSIS. Created scheduled jobs to execute SSIS packages.
• Transferred/Rewrote DTS packages to SSIS programs. Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Designed and built SSAS 2005 cubes to monitor the expenses on different categories of services, to trace the number of people who step out of list because of getting jobs.
• Create KPI to compare real number and target number.
• Troubleshoot and fixed issues in existing cubes in SSAS.
• Build SSAS MDX queries to be used in reports.
• Coordinated other Reporting Analysts in analyzing data and creating management reports.
• Utilized strong knowledge of relational database modeling principles, techniques and dimensional modeling to generate SQL/Crystal reports using OLTP data source or SSAS cubes.
• Assessed internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS) or Crystal Reporting Service.
• Developed reports without formal specifications often.
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Worked closely with IT project managers, programmers, and testers.
• Participated in the development of Web Application. Used C# for web programming. Solid knowledge and experiences with .NET programming.

Environment: SQL Server 2000 Enterprise, SQL Server 2005 Enterprise, Windows Enterprise Server 2003, Windows XP Professional, IIS 6.0/7.0, Visual Studio .NET 2005, Microsoft Visio 2003, Microsoft Analysis Service, Microsoft Reporting Service, Crystal Report 10

Confidential, Atlanta, GA

BI Analyst /Consultant

Responsibilities:

• Working on the complete life cycle of the project from design to implementation
• Translate user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
• Complete the data gathering and analysis before scheduling using this new technology
• In-charge of Development, QA and PROD Environments
• Set up SQL Server 2005, Windows SharePoint 3.0 and ProClarity Components, to establish environment of Microsoft Performance Point 2007
• ETL the monster data to SQL Server 2005
• Cleaned the data, created Fact and Dimension tables, performed calculations required for the reports using SQL Server 2005 environment and accomplished data modeling.
• Developed cubes for building reports using SQL Server Business Intelligence Development Studio
• Generated SSIS packages for data loading
• Created Performance Point 2007 reports, scorecards, dashboards, strategy map and deploy them using Windows SharePoint 3.0
• Created ProClarity reports and dashboards, publish them to Windows SharePoint Web Service
• Worked with Project Manager and Technical Leads for resolution of technical issues.

Environment: Microsoft Performance Point 2007, SQL Server 2005, ProClarity

Confidential, Alpharetta, GA

SQL Server Developer/DBA

Responsibilities:

• Involved in the Design and development of database infrastructure.
• Involved in the development of databases for the individual departments of the hospital and the central database, which contains information about all the departments
• Created ER diagrams (physical and logical using Erwin) and mapped the data into database objects.
• Normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Involved in Migration of application database from SQL Server 2000 to 2005.
• Written Complex and Extended Stored Procedures for application developers and some User Defined Functions.
• Created After and Instead of Triggers to enforce data consistency and referential integrity.
• Involved in creating Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created Clustered and Non Clustered Indexes on tables, views, and columns
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Performed data conversions from flat files into a normalized database structure.
• Migrated Microsoft Analysis Services to SQL Server Analysis Services (SSAS)
• Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs
• Migrated report system from a custom Crystal Reports system to SQL Server 2005 Report Services. Generated reports by using Repots using SSRS.
• Redesign/ Deploy reports using Report Services 2005.
• Involved in creating Technical Specification Document (TSD) for the project.

Environment: SQL Server 2005/2000 EE, Erwin 4.5, SSRS, SSIS, SSAS, Red Hat Enterprise Linux,Crystal Report 10

Confidential, Atlanta, GA

Jr. Programmer/MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Responsible for SQL Server performance tuning and troubleshooting.
• Developed a data model and implemented the same using ERWIN.
• Analyzed the existing data mart in SQL 2000, planned and performed the migration from SQL server 2000 to SQL Server 2005 following the Normalization standards to maintain data consistency.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL SSIS.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Involved in complete life cycle of the project.
• Used C#.NET and ASP.NET for developing Web pages for the In-patient tracking, Out-Patient module and Web appointments modules.
• Designed Dynamic Web pages by loading all the web user controls dynamically.
• Used Microsoft Visual Source Safe for Version controlling.
• Developed stored procedures, TSQL Queries in SQL Server 2000.
• Implemented input validation using the ASP.NET Input Validation Controls and JavaScript.
• Cascading Style Sheets (CSS) were used to attain uniformity through all pages.
• Improved the performance by selectively using page Output caching.