SUMMARY

• Over 7 years of strong experience in the IT industry as a BI Developer and SQL Server Developer.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2000/2005/2008/2008 R2/2012 and hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008 R2/2012.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, ETL processes, dimensional modeling and reporting tools.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experienced in using Business Intelligence Development Studio (BIDS), Graphical User Interface (GUI) to design SSIS (SQL Server Integration Services) packages for Data Management applications.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expert in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS 2005/2008/2012.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/2012.
• Developed Drill through and Drill down reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Proficient in T-SQL queries DDL/DML
• Having a good knowledge of ActiveX Scripts
• Knowledge of Oracle 10g
• Highly proficient in unit testing skills.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Efficient in up gradation and migration of SQL Server 2000/ 2005/2008/2012.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008/2008 R2/2012, MC Access, MYSQL, Oracle 10g

Database Reporting Tools: Microsoft SQL Server 2005/2008/2012 Business Intelligent Development Studio (BIDS), Microsoft SQL Server 2005/2008/2012 Integration Services Toolkit (SSIS), Microsoft SQL Server 2005/2008/2012 Analysis Services Toolkit (SSAS), Microsoft SQL Server 2005/2008/2012 Reporting Services Toolkit (SSRS), Crystal Report, Autosys, Sharepoint

Data Modeling Tools: Erwin, VISIO, SQL Profiler, Tableau, Cognos

Programming Languages: C, T-SQL, C#, ASP.NET, PHP, HTML, JAVASCRIPT, Microsoft Visual Studio 2008/2012, Silverlight, JQuery, Informatica

Operating System: Windows 2008/2003 Enterprise, Windows 2000 Datacenter, Windows XP, Vista, Windows Server 2003/2008.

Architecture: Relational DBMS, Client-Server Architecture and OLTP, Service Oriented Architecture

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

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

MS SQL BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Responsible for creating powerpivot reports based on the requirements using SSRS 2012.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed MDX for cube calculations and KPIs.
• Scheduled the monthly/weekly/daily reports
• Created performance point dashboard
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Implemented the scoreboard reports
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Created Packages to group logically related column types and to transfer data
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Established the terms and procedures

Environment: MS SQL Server 2012, SQL Server Reporting Services (SSRS 2012), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Erwin, Sharepoint, Tableau

Confidential, NY

MS SQL BI Developer

Responsibilities:

• Involved in installing and migrating legacy databases to SQL Server 2008
• Worked on the data warehouse and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
• Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing
• Created multiple reports (SSRS) in Drill mode using tables, crosstabs and charts.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008
• Implemented powerpivot reports
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear view of the reports
• Scheduled monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes
• Created cubes and MDX
• Implemented the scoreboard solution for the client
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Erwin, Sharepoint

Confidential, NJ

MS SQL SSIS/SSRS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL, DML) statements using dynamically generated SQL.
• Designed an OLAP system with the help of ERWIN to visualize data structure.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2008.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Improved query performance by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2008.
• Generated daily, weekly and monthly reports using SSRS 2008.
• Implemented powerpivot reports as per the client requirement
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Developed MDX for cube calculations and KPIs.
• Created and implemented the performance point dashboard solution
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• At the end created the scoreboard reports
• Defined Referenced relationships with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Established a sound backup and recovery policies and procedures.

Environment: MS SQL Server 2008/2008 R2 Enterprise Edition, MS SSAS 2008/2008 R2, MS SSRS 2008/2008 R2, MS SSIS 2008/2008 R2, Erwin

Confidential, NJ

MS SQL SSIS/SSRS Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2008 with latest Service Packs
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Developed Event Handlers for executing Stored Procedures and storing the rows Inserted, rows Selected, rows Rejected, rows Updated and rows Unchanged in appropriate SQL Tables
• Using Checkpoints in packages to enable the package to run from the point of failure
• Creating package dependencies by calling Child packages within Parent
• Using Configurations to make dynamic changes to packages
• Configurations like XML, SQL Server and Environment Variables have been used.
• Using the Default logging as well as Custom Log to keep track of the package
• Designed, administrated and developed Star Schema Data marts
• Designed and created OLAP cubes defining the dimensions and relationship between dimensions and measure groups
• Experience in creating multiple reports (SSRS) in Drill mode using tables, crosses tabs and charts.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008
• Created powerpivot reports
• Developed stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, and Implementation
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008/2008 R2, MS SQL Server Reporting service 2008/2008 R2, MS SSIS, T-SQL, Erwin

Confidential

MS SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from SQL server
• Written various stored procedures for the purpose of application development.
• Tuned SQL statements (Using Indexes) and Stored Procedures
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Disaster recovery and database maintenance plan
• Replication of data using Transactional method
• Data conversion from Text File into SQL Server Table
• Created constraints and validated database integrity.
• Designed and implemented data access stored procedures and triggers for automating tasks. Job scheduling and alerts
• Designed and implemented user log in and security.
• Extracted Data from MS Access
• Created many complex Stored Procedures / Functions and used them in Matrix Reports.
• Created reports and hosting it in the web for the users.

Environment: MS SQL Server 2005, T-SQL, SQL Server 2005 Reporting Service, VSS, Windows 2005 Server, Enterprise Manager, Query Analyzer, SQL Profiler.