PROFESSIONAL SUMMARY

• Over 7 years of MS SQL Server Development experience in Retail, Finance, Telecommunications, and Telemarketing domains with expertise in MS SQL Server 2005 and MS SQL Server 2008/2008R2/2012 suite of products like SSIS, SSAS, and SSRS.
• Proficient in creating highly flexible Database Architecture, Modeling, Data Warehousing, Design, Development and Technical Management
• Experience in utilizing complex joins such as right, left, full outer, self, and cross joins to create effective views that can later be used for reporting.
• Proficient in implementing business logic and procedure in backend using T-SQL, Stored Procedures, Views, Indexes, Denormalization, Triggers, Rules, Defaults, user defined data types and functions.
• Experience in Query Performance Tuning using tools such as SQL Profiler, Estimated Execution Plan, and Actual Execution Plan.
• Hands on experience in troubleshooting performance related database issues.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion data load.
• Created complex packages for Data Migration and Transformation. Experienced in data migration form Oracle/Access/Excel Sheets to SQL Server 2012/2008
• Worked in OLTP and OLAP environment including Production, and development databases in SQL Server 2012/2008.
• Developed and deployed OLAP Cubes, Fact Tables, and Dimension Tables. Expertise in increasing security and performance of OLAP Cubes by developing perspectives and partitions.
• Experience in Dimensional Modeling, Star and Snowflake Schemas, Fact and Dimensional Tables.
• Experience in developing Custom Report and different types of Chart Reports, Drill-Down reports, Cross-tab-reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS 2012/2008.
• Experience in utilizing MS SharePoint to distribute reports and to create attractive reports, dashboards, and scorecards using KPIs and Power BI Suite.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program.

SKILLSET

MS SQL Server 2014/2012/2008R2/2008/2005/2000, MS SQL Server Integration Services SSIS , MS SQL Server Analysis Services SSAS , MS SQL Server Reporting Services SSRS , MySQL, Oracle DB, DB2, MDM, MS Office Suite 2007/2010/2013, MS Visio 2010/2013, Visual Studio 2010/2012, MS Power BI, Power Pivot, Power Maps, TFS 2005/2008/2010, MS SharePoint 2007/2010/2013, Google Drive, Drop Box, Skype, Windows Vista/XP/NT/, Windows 7, SAP, QuickBooks, ERP Systems, Adobe Acrobat.

PROJECTS SUMMARY

Confidential

MS SQL BI SSIS/SSAS/SSRS

Confidential founded in 1984. House of Beauty carry over 100,000 beauty products that start with Fragrance, Clipper, dryers, flat/curling irons, hair products, wigs, human hair, skin care, cosmetics, nail products, barber products, etc. . The main purpose of this project at House of Beauty was to create Data warehouse and increase company efficiency by generating various analytical reports to help the management on decision making. To improve their business in areas like assortments, replenishment, vendors, supply chain and markdowns.

Responsibilities

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents and also created new design documents
• Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer to DW.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, flat file, Text Format Data.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Involved in creating a Data Mart of two schemas relating to Customer Service and Products to analyze the various factors that were involved in ensuring customer satisfaction.
• Created Dimension and Fact Tables and Schemas for the Data Mart using SQL Server Management Studio.
• Utilized SQL Server Profiler and Database Design Engine Tuning to analyze traces files to improve data warehouse performance.
• Experience in development and deployment of cubes that were generated to analyze KPIs by utilizing SQL Server Analysis Services SSAS .
• Created Snapshot, Cached, Linked, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Responsible for generating annual reports based on the growth of sales with respect to customers.
• Created calculated measures and dimension members using multidimensional expression MDX , and user-defined functions.
• Worked on tuning the long-running SQL /PL-SQL Stored Procedures, when needed
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Functions, Triggers.
• Collected performance data from previous financial quarters to determine the patterns/trends in company's operations and performances.
• Implemented self-service business intelligence using Microsoft Power BI.

Environment: MS SQL Server 2012, SQL Management Studio 2012, SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS , MS Power BI, SQL Server Profiler, MS Excel, MS Master Data Management.

Confidential

MS BI-SSIS/SSAS Developer

• Worked as a database developer on databases like MS SQL Server 2008/2012 using T-SQL, stored procedures and views to get data from Data warehouse to Data marts.
• Involved in the analysis of the Production data mart that utilized the SQL Server 2008 Platform using SQL Server Analysis Services SSAS 2008.
• Developed and deployed a cube which included Timberline Total Solution's exclusive brand's dimension and fact data and developed perspectives for users in sales and for users to analyze revenue.
• Worked with SSIS to extract data from different source systems and used transformations like Slowly Changing Dimensions, Data Conversions, Derived Columns, Merge, and Union to cleanse and scrub the data.
• Created Entity Relationship ER Diagrams to the proposed database and database objects such as tables, views, stored procedures, functions and triggers as per the requirements.
• Identified columns for Primary Keys in all the tables at the design time and create them.
• Involved in creating cubes in SQL Server Analysis Services using SQL Server 2012 version.
• Analyzed, developed and created cashed reports, snapshot reports based on financial statements.
• Developed and maintained SSIS Extracts Transforms and Load ETL processes across multiple data sources.
• Created several dashboard reports with drill-down, drill-through, cross Tab Reports and sub-report using Report Definition Language RDL
• Worked with a reporting team on building charts, graphs and tables.
• Designed, developed and implemented data management and data analytics solutions.
• Performed Conceptual, Logical, Physical, Multidimensional, Hierarchical data modeling.
• Identified data discrepancies and data quality issues and work to ensure data consistency and integrity.
• Monitored system details within the data warehouse including stored procedure and execution time and implemented efficiency improvements.
• Optimized the ETL process to ensure that business requirements are met.

Environment: Microsoft SQL Server 2008/2012, SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS .

Confidential

MS BI Developer

Responsibilities

• Involved in requirements gathering, analysis, design, development, deployment and user training.
• Experienced in creating numbers of complex formulas in sub reports using different type of variables likes shared variable and retrieved them from master report.
• Experienced in Data warehouse design and implementation
• Experienced in designing, developing complex SQL queries to support reporting requirements
• Presented data in multiple formats including reports, charts, graphs, aggregates and statistical computations.
• Involved in writing Custom Functions to be used in other Functions.
• Understood an existing system and designed modifications to the system to support new requirements.
• Successfully created Fact Tables, Dimensions and joined them to extract meaningful data.
• Understood an existing system and designed modifications to the system to support new requirements.
• Designed, developed and tested processes, which include the creation of SQL views, scripts, T-SQL, stored procedures, functions, triggers and DTS packages.
• Experienced in tuning SQL statements using indexes, SQL stored Procedures and views.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Used Query Analyzer to optimize SQL Queries.
• Configured, patched, tested, and supported all MS SQL Server database instances.

Environment: MS SQL Server 2008-R2, SQL Server Integration Services Migrated DTS Packages to SSIS Packages , Crystal Reports 8.5, T-SQL.

Confidential

SQL BI- SSIS Developer

Responsibilities

• Involved in Creation, Manipulation and Supporting the SQL Server Database.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler.
• Extensively involved in designing SSIS packages to make the automated synchronization of data from one system to another system.
• Created and tested SSIS packages for importing and exporting data from data warehouse.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2008-R2.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc. from event viewer, SQL Error log files.
• Configured Mail Profile for sending automatic mails to the respective people when a job failed or succeeded.
• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function, Aggregate function.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Environment: MS SQL Server 2008-R2, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Profiler, MS Excel.

Confidential

SQL Server BI SSIS/SSRS Developer

Responsibilities

• Involved in the analysis and the modeling of data that was related to customer service and product quality from MS SQL Server 2008R2 Data Warehouse platform.
• Experience in working with SSIS to extract data from different source systems and used transformations like slowly changing Dimensions, Data Conversions, Derived Columns, Merge, and Union to cleanse and scrub the data.
• Experience in creating a Data Mart that consisted of two schemas relating to Customer Service and Products to analyze the various factors that were involved in ensuring customer satisfaction.
• Created Dimension Tables, Fact Tables and Schemas for the Data Mart using SQL Server Management Studio and ensured that the data mart's physical implementation matched the conceptual design.
• Utilized SQL Server Profiler and Database Engine Tuning to analyze Trace files to improve data warehouse performance.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in creating Snapshot, Cached, Linked, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Experienced in developing T-SQL Stored Procedures and Triggers and User defined Data Types and Functions to enforce the business rules.
• Created Triggers to maintain log history of all tables and major changes to the existing production databases.
• Imported customers table data to the Microsoft excel sheet as Reporting for checking status of customer application.
• Developed the required data warehouse model using Star schema for the generalized model.

Environment: SQL Server 2008, T-SQL, ETL, SQL Server Integration Services, SQL Server Reporting Services, SQL Profiler, MS Excel 2007, MDM.