SUMMARY

• 7+ years of experience in IT, Financial and Healthcare environments with primary skill on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• SQL Server 2000/ 2005/2008/2012 RDBMS database development including T-SQL programming.
• SQL Server 2005/2008/2012 OLAP database development including KPIs, Data mining, working with changing dimensions
• ETL implementation using SQL Server Integration Services (SSIS).
• Good ETL skills, Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance
• Developing reports on SQL Server (2000/2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Good understanding ofMicrosoft ReportingService(SSRS)with Report authoring, Report management, Report delivery andReport security.
• Experience in developingUser reports and management reports using MS SQL Server Reporting Services (SSRS).
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Experience in writing Distributed Queries between SQL Server.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
• Involved in DBA activities such as backups, restores, replication etc.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert, ActiveX).
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Databases: SQL server 2000/2005/2008 R2/2012, MS Access

Languages: Transact- SQL, SQL, HTML, C.

Operating Systems: Windows NT/98/ 2000/XP/Vista/2003

Reporting Tools: SSRS, Crystal Reports.

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

Other Tools: Microsoft Visual Studio, Microsoft Office, MS Visio.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Programming languages: C,SQL,PL/SQL,T-SQL

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, SQL Server2008/2012 Analysis Services and SQL Reporting services, DTS.

PROFESSIONAL EXPERIENCE

Confidential, New York

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

Responsibilities:

• Involved in Business Analysis and Requirements gathering from the Business Users and Technical document design of these requirements.
• Participated in the creation of the logical & physical data models as per the business requirements.
• Created database objects like tables, stored procedures, indexes, views, triggers, functions and cursors using TSQL statements, worked with DML and DDL for retrieval and modification of the data.
• Created stored procedures, scripts, cursors and tested them on the test servers and then moved them to production servers.
• Written Inline and Scalar User Defined Functions and implemented Instead Of and after triggers and specified their order of execution.
• Designed and Implemented Performance Tuning, Query Optimization and Maintenance plans for consistency checks, re indexing within defined Maintenance Window.
• Created and modified Complex T-SQL queries, stored procedures, Triggers to implement the complex business needs.
• Worked on archiving the data from large tables into zipped files to release space.
• Performed Business Analysis, Designed, Developed, Tested and Implemented packages using SQL Server Integration Services (SSIS) for extracting the data from the sources.
• Worked on SQL Profiler, Tuning Adviser (DTA), and Systems Performance Monitoring with various objects & Counters, DBCC commands to record and enhance the performance.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries and Resolving Deadlocking, Blocking and locking issues.
• Responsible in checking query plans and making sure each and every query is using appropriate useful indexes.
• Developed SSIS Packages with SQL Server Integration Services (SSIS) to migrate data from Oracle 9i/10g, and DB2, SQL Server 2005 to SQL Server2008 to support front end analysis system.
• SQL Server Integration Services (SSIS) was extensively used for Extraction, Transformation and Loading (ETL) process of Flat Files, Excel Spreadsheets to SQL Server 2008.
• Transformed data to and from various data sources by creating SSIS packages. Used BCP command line utility for bulk data import/ Export.
• Performed data conversions from Flat Files to database structures and loading data from FTP to Excel.
• Developed various SSIS packages satisfying Business requirements for different Interfaces.
• Successfully increased the performance of the SSIS packages by 20% by identifying the bottle necks and resolving them.
• Provided 24/7 Support for Production, Development & Test Servers of SQL Servers. Detect, Diagnose, Repaired and Reported databases errors, Application errors and Connectivity issues.

Environment: SQL Server 2008R2, SQL Server Management Studio, SQL server integration services (SSIS),SQL Profiler, Reporting Services (SSRS), XML, Windows 7.

Confidential, New York

Sr. MS SQL Server BI Developer

Responsibilities:

• Installed SQL Server 2005 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2000 to SQL Server 2005 without any service interruption.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2005.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2005.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created SSIS packages to transfer data from different data sources load it to data warehouse.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Used MDX expressions to define calculated members in cubes to calculate values at run time.
• Created copies of operational Databases using the Import/Export Wizard
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
• Wrote MDX queries according to the business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2005 Reporting Services (SSRS).
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.
• Created jobs and scheduled jobs using SQL Server Agent.
• Deployed code into the production environment. Provided 24/7 production support for the production database.

Environment: SQL Server 2005/2008, TSQL, SSIS, SSRS, SSAS, Windows NT/2000/XP, Microsoft.NET 2.0, VB.NET, ASP.NET 2.0, ADO.NET, Performance point server, ProClarity, MS Access, Excel, ER Studio.

Confidential, SD

SQL Server SSAS/SSRS/SSIS Developer

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Created the storage type (ROLAP), Created cubes for Business Intelligence.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Utilized Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Fact and Dimension tables, and OLAP Cubes while adhering to enforced development methodologies.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Experience in designing and managing SSAS projects.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Experience in building and maintaining Data marts. Created roles for using the cubes
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Transferring data between XML document and SQL server
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Designed the SSIS packages with error handling.
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise

Environment: SQL Server 2005/2008 SQL BI Suite (SSAS, SSIS, SSRS), MDX, Enterprise manager, Crystal Reports, ERwin, XML, VB.NET, ProClarity, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential, IL

SQL Server SSAS/SSRS/SSIS Developer

Responsibilities:

• Gather requirements, prepare functional specifications, form project plans and communicate progress throughout the software development life cycle
• Write technical specifications, participate in design reviews, provide technical ideas and concepts
• Lead joint application design sessions
• Perform system architecture high level design, coding, testing and debugging
• Participate in development, and implementation of complex web based applications
• May assume lead role in reviewing, analyzing requirements for new development or enhancements to existing systems
• Serve as a Subject Matter Expert (SME) and provide technical direction for specific initiatives and projects. Lead projects and collaborate with other programmers and business partners to ensure successful delivery and implementation of the software application.
• Troubleshoots production support issues post release deployment and come up with solutions. Ability to solve complex production issues.
• Collaborate with other IT teams such as Systems Analysts, Quality Assurance and Project Managers
• Offshore/Onshore Team management/Work distribution
• Coordinate and track project work of onsite and offshore resources
• Ability to work on multiple projects concurrently
• Able to communicate effectively across varied areas including technology, business units and senior leadership

Environment: MS SQL Server 2000, DTS, MS SQL Server Reporting Services, BIDS, Visual Studio, T-SQL, MS-Access, MS Excel, Report builder, Erwin, Windows XP Professional, SQL Profiler

Confidential

SQL DEVELOPER

Responsibilities:

• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Developed several database objects such as tables, triggers and views and also stored procedures.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Studied the existing environments and accumulated the requirements by interaction with various aspects.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Developed & executed several optimized queries.
• Written several stored procedures to achieve various functionalities of the system.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Assisted the Application team in data modeling and T- SQL coding.

Environment: SQL Server 2005, Windows NT, T- SQL, EXCEL, Access.