Summary:

• Dynamic IT Professional with more than 8 years of experience in system analysis, design, development and implementation of Database and Data Warehousing systems using SQL Server 2005/2008 R2/ 2012, SSIS, SSRS and SSAS.
• Experienced in developing client/server Business intelligence BI database application. Experienced in designing, developing, documenting, and testing of ETL jobs in Data Warehouse and Data marts.
• Proficient in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Expert in writing T-SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Proficient in using SQL Server Integration Services SSIS to build Data Integration and Workflow Solutions, Extract, Transform and Load ETL solutions for Data warehousing applications. Experienced in transforming OLTP data into Data Warehouse using SSIS and T-SQL queries.
• Expert in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes. Experienced in building Referential Integrity Constraints and implementing different types of Replication models like Snapshot, Merge and Transactional.
• Expert in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services SSRS .
• Expert in Integrating SSRS Reports and SSAS Cubes in web sites. Involved in Schedule the reports and checking the security for reports.
• Expert in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Expert in designing Enterprise reports using SQL Server Reporting Services SSRS 2008/2012 generated drill down reports, parameterized reports, linked reports, sub-reports, matrix dynamics and filters, charts in SSRS 2008/2012.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services SSAS 2005 .
• Excellent hands on experience in creating and configuring Data Source Data Source Views, Dimensions, Cubes, Measures, using SQL Server Analysis Services SSAS 2008.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Skillset:

MS SQL Server 2005/2008/2008R2/2012, SQL Server Reporting Services 2005/2008/2012, SQL Server Analysis Services, MS SQL Server Integration Services, Business Intelligence Development Studio BIDS , MS Access, HTML, MS Visio, Windows server 2005/2008/2008 R2, Visual Studio 2005/2008/2010, T-SQL, Windows SharePoint MS Office

Projects Summary:

Confidential

MS SQL Server SSIS/SSRS/SSAS Developer

Confidential operates the world famous fashion shopping search website: Shopstyle.com. The site's search function allows visitors to customize and filter their searches by trend, brand, style, store, price, and what's on sale. The project is aim to optimize online price and information inquiry application, involved designing databases and creating product pricing and sales' information reports.

Responsibilities:

• Created, maintained, and optimized data objects like indices and schemata. Various enhancements have been made to the old system so that reports can be easily managed by other departments.
• Developed logical and physical model for schemas. Created standard data documentation, such as ERD and Flow Diagram. Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Employed Transparent Data Encryption to store the data securely by encrypting sensitive data such as credit card numbers, specific store's name for each pricing record.
• Employed Server Group Management, new features to SQL Server 2008, which enables T-SQL queries to be issued against multiple servers from a single central management server.
• Wrote T-SQL queries, stored procedures to build packages. Developed user defined functions, triggers, views based on business requirements.
• Designed and wrote SSIS ETL systems for data from many disparate sources, structured and semi-structured, using transformations such as lookup, merge, derived column, data conversion and aggregates extensively.
• Gathering various reporting requirement from business analysts. Translated the business requirements into workable functional and non-functional requirements.
• Developed Drilldown reports, Drill-Through reports, Parameterized reports, and Cascading Parameterized reports using SSRS. Tested all the generated reports with some test cases in the actual application.
• Designed and created Report templates, bar graphs, pie charts, and map reports based on the source data. Involved in creating snapshots, subscriptions and scheduling for the reports
• Developed numerous ad-hoc reports using SSRS for day to day pricing reporting. Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.

Environment: Windows Server 2012, MS SQL Server 2012, MS SQL Server Reporting Services SSRS 2012, MS SQL Server Integration Services SSIS 2012, Microsoft Visio 11.0, Visual Studio 2012, Report Builder 3.0

Confidential

MS SQL Server SSIS/SSRS/SSAS Developer

Confidential only nationwide, full-line, upscale department store and a division of Macy's Inc. Bloomingdales' loyalty membership card service enables customers to earn rewards at Bloomingdales. The Scope of the project was to replace the existing application of card services. Was involved in creating the database for the new application and integration of the data warehouse using SQL Server 2008 R2 SSIS .

Responsibilities:

• Worked close with System Analysts to create the functional document for the development for the new databases.
• Created ER diagrams using Visio. The entities in the diagram including accounts, merchants balance history.
• Created copies of operational Databases using the replication of the database on to the new database using the wizard.
• Created Stored Procedures, Triggers, Tables, Views and other T-SQL code ensure efficient data retrieval.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency.
• Migrated data from MS SQL Server 2008 to MS SQL Server 2008 R2 using OLE DB connection by creating various SSIS packages using tasks like Bulk Insert and created SQL server configurations for the same.
• Created SSIS packages to load data into data warehouse using various SSIS tasks like Execute SQL Task.
• Used Reporting Service SSRS to generate drill-down and drill-through reports for the default accounts and the accounts with the higher risk.
• Designed, developed and deployed reports in MS SQL server environment using SSRS.
• Used SSAS to create cubes with various measures and dimensions for financial reports generation.

Environment:MS SQL Server 2008 R2, SSIS, SSRS, SSAS, Visual Studio 2008, Windows NT, asp.net, MS Access.

Confidential

MS SQL Server SSIS/SSRS/SSAS Developer

Confidential is an American software company that develops financial and tax preparation software and related services for small businesses, accountants and individuals. The goal of the project was drive business intelligence solutions that empower business units to gain faster insights into key sales performance metrics and will enable the access and use of information for financial analyses and forecasting.

Responsibilities

• Partner with key business and technical teams to drive the implementation of strategic business intelligence and analytics initiatives.
• Understanding business unit/finance/sales reporting needs and translate those needs into technical solutions planning, feasibility assessments, developing requirements, implementation, testing, problem solving, working across business and IT .
• Partnering with technical teams as needed to enable data flows from Demand force's data warehouse s into technical solutions using SSIS.
• Enabling MS SQL Server2008 and developing reports and dashboards
• Leading internal customer training on using data reports in MS SQL Server2008.
• Making efficiency improvements as needed.
• Maintaining production data and report integrity.

Environment: MS SQL Server 2008 R2, SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS , T-SQL, SharePoint Server MOSS2007, Dashboard Designer, MS-Office, Visual studio

MS SQL Server SSIS/SSRS/SSAS Developer

systems, tools, ARO pumps, material handling systems and more. The goal of this project was to make structural changes to the data warehouse database, automate the entire claims component of the business, and create reports on the Dashboard using SharePoint server to compare goals, targets, budget for different years in order to evaluate performance of the company.

Responsibilities:

• Performed day-to-day production support activities that are prioritized and assigned by the manager.
• Performed code and tested activities for Business Intelligence project using the Microsoft suite of products, including SSIS, SSAS and SharePoint.
• Designed and developed SSIS packages to move data from different environments within the organization.
• Scheduled jobs to call packages and stored procedures, and also create alerts for successful and unsuccessful completion of schedule jobs
• Created configuration files in order to deploy packages in different environments.
• Wrote test scripts for testing the data in order to ensure accuracy.
• Developed, maintained and executed SQL scripts/ queries and validated completeness, integrity and accuracy of data.
• Created OLAP cubes and dimensions for the analysis of sales in different locations using SSAS.
• Analyzed and test data in the cube using SSAS.
• Generated reports using Dashboard and deployed them on SharePoint server.

Environment: MS SQL Server 2008 R2, SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS , T-SQL, SharePoint Server MOSS2007, Dashboard Designer, MS-Office, Visual studio

MS SQL Server SSIS/SSRS/SSAS Developer

and retails books for the local education market. This project involvement was in Data warehouse and BI Reporting to analyze and manage related Data.

Responsibilities:

• Actively involved as part of team for gathering and analyzing the needs of end user requirement and system specification.
• Coded T-SQL scripts for stored procedures, user defined functions, views for complex business logics.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Migrations of database from MS SQL 2005 to MS SQL 2008.
• Used SQL Server Integration Services SSIS to export and import data.
• Designed and deployed reports with cascading parameterized, Drill Down, Drill Through and Drop down menu option and parameterized and Linked reports using SSRS 2008.
• Deploying and scheduling Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008, Integration Services SSIS , T-SQL, MS Excel, Access and Excel.