Summary:

• Over 8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005/2008/R2/2012.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server R2/2012.
• Experience in database from scratch, design the structure of the database, create the ER diagram entity-relationship model , create relational table using primary key, foreign key and composite key.
• Excellent in using normal form to manage the database structure, including 1NF, 2NF, 3NF.
• Experience in refining the database design, star-schema and snowflake schema.
• Expertise in SQL Server Integration Services SSIS and SQL Server Reporting Services SSRS with good knowledge on SQL Server Analysis Services SSAS .
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Great ability to create and manage various database objects like tables, views.
• Excellent in High Level Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS.
• Experience in creating Crystal Reports 8/10 and connecting to various data source like g Microsoft Excel spreadsheets, Oracle databases, Microsoft SQL Server databases.
• Experience in report writing using SQL Server Reporting Services SSRS and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart and Sub Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Hands on experience in Data Modeling, familiar with snowflake schema, star-schema, Multi-dimensional model and tabular model. Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies, Aggregations, partitions, calculated members and KPIs in Dimensional Modeling.

Skillset: MS SQL Server 2012/R2/2008/2005/2000, Oracle 8i, MS-Access 97-2007, T-SQL, PL/SQL, .NET, Visual Basic 6.0, HTML, C, C , Windows Server 2003/XP/2000/NT/98/95, MS DOS 6.2, Microsoft Visio 2003, Erwin 3.x, Crystal Reports 8/10, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , Data Transformation Services DTS , MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor DTA , Internet Information Server IIS 5.0 / 6.0 , FTP, TCP/IP, Microsoft Office 2003/2007, Power View, Power Pivot

Projects Summary:

Confidential

MS SQL BI SSAS, SSRS, SSIS Developer

Confidential multinational consumer electronics corporation headquartered in Richfield, Minnesota, a Minneapolis suburb. I have been working in Projects involved in Crystal Report, SSAS tabular, SSIS, and T-SQL. The projects names are License Plate, Category Sales Scorecard and Logistics ODS.

Responsibilities:

License Plate:

• Modify the existing License Plate Summary Report by removing two calculated measure from License Plate Tabular Model.
• Extract Transform and Load ETL source data into respective target tables. Build the required data marts for UPS, COST PER STOP, Route Stop and Route Stop Item and TARGET.
• Communicate different Indian offshore team to continue build on the project or test our daytime development. Lay out specific task and email the offshore team.
• Act as offshore Tech Lead to join daily hand off meeting. Leading some separate discussion about the issue and the requirement during the night or morning call.
• Update the existing Category Sales Scorecard Crystal Report to contain 280 new metrics and layout already identified by the business which is 175 metrics.
• Category Sales Scorecard
• Update the report by adding new Parameter, new dataset and calculated measure.
• Create a new Audit Tracking column in License Plate Report by adding one new calculated measure from License Plate Tabular Model.
• Used complex T-SQL queries for data extraction in RV, IC, DP, OD, DP HIST and Mart. Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, CTASS, user defined functions and ad-hoc queries.
• Design configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Create DDL script with Cluster Index and hash key for UPS tables in target layer and send to Dev, QA and Prod DBA.
• Create SQL Server Maestro jobs and scheduled them to load data periodically.
• Work on Unit test for UPS and MI in DEV, QA and Prod. Migrate the code to QA or Prod and run maestro job which could involve interaction with BTI teams such as DBA team, Data Center team and support team etc.
• Finish filling and checking ETL LLD MDS Document for UPS, MI, Red Prairie, Route Stop and Route Stop Item. Get them approved by Best Buy people.
• Participate in design discussions in data model structure with data modeler.
• Test the data in Production database with real and most current data and prompt resolution of issues. Make sure that the production data meet Business requirement and transformation logic. Resolved query defect, data conflicts and inappropriate use of data.
• Involve in Query optimization, performance tuning and index creation.
• Work on Tabular Modeling Development and Multidimensional Modelling Development using SSDT. Create additional Timestamp for report.

Environment: MS SQL Server2012/ 2008 R2,Crystal Report, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Power Pivot, Power View, BIDS, SSMS, SSDT Microsoft Excel.

Confidential

MS SQL BI SSAS, SSRS, SSIS Developer

Confidential Industrial Direct is one of the largest direct marketers and premier distributors of metalworking and Maintenance, repair and operations supplier to industrial customers. The Project is to develop Global Business Intelligence Domain responsible for the processes required to extract, transform, cleanse, and move data/metadata from source systems so they can be loaded into new or existing Global Supply Data Warehouses/Business Intelligence applications.

Responsibilities:

• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Participated in design discussions with Database architects and Application architects.
• Responsible for preparing the technical specifications from the business requirements.
• Created new tables, stored procedures for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling. Created Triggers to enforce data and referential integrity.
• Designed and analyzed the SQL Server database and involved in gathering the user requirements.
• Wrote Stored Procedures and Functions for better performance and flexibility.

Environment: MS SQL Server2012/ 2008 R2, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , MS Visual Studio.NET 2008, SAP Business Objects, Microsoft Excel.

Confidential

MS SQL Server Developer/SSRS/SSAS

Confidential is an independent practice association, serving over 300,000 health plan members in CA. This association provides medical care to healthcare member. There are 3,700Specialty physician, 36 hospitals, 15 urgent care centers. The project focused on generating monthly, quarterly and ad-hoc reports using SSRS tool. The scope of this project includes developing reports, scorecards and dashboards.

Responsibilities:

• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations
• Worked closely with business unit s to understand key business drivers and then identify the individual business metrics and key measures that support them
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports
• Administrated and scheduled mailing subscriptions on SSRS reporting server
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Created SSRS Data Model projects using Microsoft Visual Studio and using Report Builder for report server to facilitate Ad-hoc reporting by the business users.

Environment: SQL Server 2008/2008R2, SSIS, SSRS, MS-Access, DB2/UDB, ERwin7.1, VB Script, WIN2000/XP.

Confidential

MS SQL Developer/SSRS Developer/SSIS Developer

International Specialty Products ISP is recognized globally for developing, manufacturing, and supplying innovative specialty ingredients that enhance product performance. In this project, I used SQL server 2008 tools, SSIS for ETL Process, SSAS for making cubes, SSRS for creating reports in different environment. My main role was to work on ETL process. This project is about to develop DSS for sales module, purchasing module, accounting module, logistics module using Business Intelligence technology like Integration service packages, analysis cube and reporting.

Responsibilities:

• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from various RDBMS and Non-RDBMS systems.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Created parameterized, drill-down and drill-through for sales module for business.
• Use Analysis service processing task to process the analysis cube in SSAS after DW run.
• Created Report Model project, specially designed for end business users so that they can create new and modify the existing ad-hoc reports using Report Builder.

Environment: MS SQL Server 2008, Windows server 2003, ER-Win, MS Excel 2007/2003, SQL Server Business Intelligent Development Studio, Team Server 2008.

Confidential

MS SQL Server / BI Developer

Confidential Technologies is an Electronic Components and Electronic circuits manufacturing company. Its devices are used in various fields of technologies like automotive, appliance, aircrafts etc., The objective of this projects is to have a consolidated clean and consistent Data warehouse for Sales, Product, Manufacturing, and Distribution divisions of the company with historical business trends using historical data so that we can estimate the Current Demand and provide information to Marketing Managers that helps them to make better decisions about pricing, advertising and other vital marketing matters.

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Data Analysis and Designed the logical and physical model architecture for database.
• Involved in Query optimization, performance tuning and index creation.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Developed custom selection of reports ordering using SQL Server Reporting Services SSRS
• Used SSRS to create reports, customized Reports, on-demand reports.
• Validating and Testing of the Database data, SQL codes and application

Environment: SQL Server 2005, SSRS, SSAS, T-SQL, SSMS, BIDS, Visio, Excel 2003, SharePoint

Confidential

MS SQL Server Developer

Confidential is one of the largest bank in the world. The company had web development projects involving GUI enhancements to the existing line of credit products Credit Card business where I was required for doing back end Database application development using SQL Server.

Responsibilities:

• Migrated data from SQL server to excel files for reporting the data regarding the credit available.
• Created tables, Stored Procedures, views, triggers to facilitate the web application.
• Coordinated with the front-end developer to put in the business rules. Created procedure to check some of the rules at the backend at the time of entering data.
• Created and managed indexes, which will enable the client for fast search and retrieval of the credit information.

Environment: MS SQL 2005, HTML, Microsoft Office suites Word, PowerPoint, Access, Excel, Project, Visio .