SUMMARY

• A Microsoft Certified Professional with over 9 years of Database administration, Data Warehouse and Business Intelligence Developer experience in Banking, Finance and Retail Industry
• Installed, administered and developed SQL Server 2008/R2/2012 Data Warehouses and Data Marts using business intelligence stack like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
• Experience building and executing SSIS Packages to load data from Flat File, XML, Excel and OLTP databases using Data Flow Tasks, Derived Columns, Conditional Split, Term Extraction, Aggregate, Pivot Transformation, Slowly Changing Dimensions, Lookup, Fuzzy Lookup and other tasks as per requirement
• Experience developing SSAS Multidimensional and Tabular Business Intelligence OLAP data warehouses solutions exploring Data Source Views, Cubes, Dimensions Mining Structures, Roles and Assemblies
• Developed different types of Tabular Reports, Matrix Reports, Drill - Down, Drill-Through, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS), Report Builder 3.0,MS Excel PowerPivot, Power View and Crystal Reports
• Expert in Data Warehousing methodologies and concepts, including star and snowflakes schema dimensional modeling using ERwin and Kimball data warehouse techniques
• Experience Creating and managing Databases, Tables, Indexes, Views, Partitioning of large tables and indexes, Stored Procedures, User-Define Functions, Statistics, Cursors, DDL Triggers, DML Triggers, the Transaction Log, Database Checkpoints, Backup and Restore Databases, Bulk Import and Export of Data, Data Compression, Event Notifications, Monitoring and Tuning of Databases for Performance
• Excellent analytical, interpersonal and presentation skills, effective planning, negotiation, flexibility and continuous learning ability, develops positive energy, creativity and teamwork among team members
• Strong Communication Skills with Tact, Professionalism and Diplomacy (written and oral)

TECHNICAL SKILLS

Database RDBMS: SQL Server 2005/2008/R2/2012, Azure SQL Database

Extract Transform Load (ETL): SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Analysis Tool: SQL Server Analysis Services (SSAS) Multidimensional and Tabular

Reporting Tool: SQL Server Reporting Services (SSRS), Report Builder 3.0, Crystal Reports

Database Management Tool: SQL Server Management Studio (SSMS), Master Data Services (MDS), PowerShell

Structured Query Language: Transact-SQL (T-SQL), Multidimensional Expressions (MDX),Data Mining Extensions (DMX)

BI Developer Tool: BIDS, SQL Server Data Tools (SSDT)

Data Cleansing Tool: Data Quality Services (DQS)

MS Office Applications: MS Word, Excel, Access, Visio, Project and PowerPoint

MS Excel Add-in: Power Pivot, Power View

Operating Systems: Windows XP/7, Windows Server 2008, 2008 R2, 2012

ERP Software: Microsoft Dynamics, SAP, PeopleSoft, Workday HCM, Financial Management

Content Management: SharePoint Server 2007, 2010

Programming Languages: C#, VBScript, JavaScript, HTML5, CSS3, ASP.Net

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

MS Business Intelligence Developer

Confidential, New York, NY

Responsibilities:

• Developed ROLAP and MOLAP data warehouses working closely with system analysts, business analyst, database administrators and programmers and participated in all stages of Data Warehouse/Business Intelligence Development Lifecycle to gather requirements, design cubes in SSAS, testing, and deploy to production
• Designed fact tables, dimensions tables and measures using star and snow flake schema dimensional modeling
• Administered and developed SQL Server Reporting Services (SSRS) to create, maintain and publish reports, dashboards, scorecards and other visual information displays through Report Builder 3.0 and Crystal Reports
• Managed Security in SSRS by creating custom roles, tasks, system-level and item-level permissions, authentication, creating Windows users and groups using the Report Manager
• Performed data analysis on multidimensional cubes and tabular data warehouses using MS Excel, PowerPivot and Power View as needed to support business analyst users in decision making developing accurate reports
• Developed KPI’s in SSAS using MDX queries on MOLAP cubes and DAX queries on tabular data warehouse
• Utilized SQL Server Data Tools (SSDT) to design, build and deploy ETL packages connecting with different data sources (OLTP, SQL Server, Excel Files, Flat Files, XML) and loaded the data into data warehouse using SQL Server Integration Services (SSIS)
• Worked on various tasks and transformations like Execute SQL Task, Slow Changing Dimensions, Conditional split, Script Component, Merge and Lookup while loading the data into data warehouse using SSIS
• Responsible to support SSAS and SSRS with ever-changing workloads, and achieving some level of predictable performance or minimizing variance in plans and performance
• Managed SSAS database Backup schedules and Restore strategies and Disaster Recovery procedures

Environment: MS SQL SERVER 2008/R2/2012, SSIS, SSAS, SSRS, SQL Agent and Profiler, MS Access, Excel 2003/2007/2010 , Visual Studio 2008, VB.Net, ADO.Net, ERwin, Report Builder, Crystal Reports, PeopleSoft

MS Business Intelligence Developer (SSIS/SSAS/SSRS)

Confidential, Jersey City, NJ

Responsibilities:

• Gathered and analyzed the business requirements with systematically designing the data warehouse OLAP cubes for storing and analyzing B2B and B2C sales data utilizing business intelligence stack
• Identified the dimensions, measures, fact tables and designed the data warehouse using star schema
• Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data
• Developed Multi-Dimensional Expression (MDX) queries to analyze data from SSAS cubes
• Created drill down, drill through, cascading parametric and sub reports from SSAS cubes enabling web browsing
• Worked with end users, business analysts and application developers to identify business needs and transforming business rules to database specifications
• Developed and scheduled reports using SQL Server Reporting Services to generate all daily, weekly, monthly and quarterly reports as per need of business analyst and business development teams
• Created T-SQL queries to generate reports from relational data warehouse stored in SQL Server Engine
• Partitioned Tables and Indexes to load data from OLTP to an OLAP system to transfer the data quickly, efficiently and maintaining integrity
• Developed ETL Processes using SQL Server Integration Services (SSIS) to migrate data from Oracle data source into a SQL Server 2012 database
• Created SSIS Packages by using different kinds of transformations like Pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast
• Created ETL Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations, Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more for existing/new packages and huge CSV file import into data warehouse
• Actively participated in meetings and checked for the development of the project

Environment: MS SQL SERVER 2008/R2/2012, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Agent, Profiler, MS Access, Excel 2003/2007/2010 , Visual Studio 2010, MS Windows Server 2008, VB.Net, ADO.Net, Kimball

SQL Server BI Developer (SSIS/SSAS/SSRS)

Confidential, Pittsburgh, PA

Responsibilities:

• Involved in analysing, designing, building, testing and deployment of OLAP cubes in SSAS 2008/R2
• Involved in creating data warehouse for credit cards data and analysing cubes using MDX and SSRS
• Developed various operational Drill-through, Drill-down, Charts, Matrix, Linked and Sub reports using SSRS
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
• Implemented Incremental load, used Event Handlers to clean the data from different data sources
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application
• Involved with Query Optimization to increase the performance of the Report using SQL Tuning advisor
• Developed Physical data models and created DML scripts to create database schema and database objects
• Implemented Full Text Search for fast and efficient querying when large and unstructured data is encountered
• Worked with Database Administrator to maintain the database, used DBCC Statements to perform maintenance tasks before backing up the databases
• Scheduled SSAS database Backups by building and deploying SSIS packages
• Employed Server Group Management, new to SQL Server 2008/R2 which enables T-SQL queries to be issued against multiple servers from a single central management server
• Performed Debugging on the Stored procedures for the requirement to handle the errors
• Employed Transparent Data Encryption, a new feature of SQL Server 2008/R2 to store the data securely by encrypting the database files
• Development of custom scripts and stored procedures for data import and manipulation
• Dealt with Fine-tuning of Stored Procedures to improve performance with a Query plan Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost
• Documented and maintained database system specifications, diagrams, and connectivity charts

Environment: SQL Server 2005/2008/R2, SSIS, SSRS, SSAS, Windows XP, Windows Server 2003, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management Studio,, ERwin

SQL Server DBA

Confidential, New York, NY

Responsibilities:

• Migrated SQL Server 2005 data bases into SQL Server 2008
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning
• Deployed new code base release to UAT and Production Environments
• Performed SQL Server service pack and Windows Service pack upgrades
• Worked with customers on Application rollouts and server migrations
• Extensively worked on Enterprise Manager for managing the database
• Troubleshoot performance problems and fine-tuning of databases
• Converted DTS packages into SQL Server 2008 Integration Services
• Recovered the databases from backup in disasters
• Analyzed long running slow queries and tuned the same to optimize application and system performance

Environment: Microsoft SQL Server 2005/2008, SQL Profiler, SQL Agent, Oracle 10g/9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003

SQL Server DBA

Confidential

Responsibilities:

• Involved with Installation, Upgrade and Troubleshooting of MS SQL Server 2005
• Created Complex Stored Procedure, Triggers, Cursors, Tables, Views and other T-SQL JOIN techniques
• Designed, Developed and maintained Relational databases
• Extensively involved with Database Space Management, Performance
• Involved with tracing activities using SQL Profiler
• Running Index tuning wizard and rebuilding indexes for faster query response
• Responsible for DTS activities to move data from text files to SQL Server on daily and weekly Basis
• Extensively involved in knowledge transfer for documentation team for development activities carried out by team
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS
• Extensively involved with the development team in carrying out the Unit testing of the applications and tuning of complex procedures
• Involved in Planning, development, and testing of disaster recovery strategies and procedures to restore the production environment to a production state

Environment: SQL Server 2005 and SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, VSS and Password Updater, SQL DB Access, Performance Monitor, Backup Utility