Responsibilities:

• Development of Retail Management Call Center reporting solution using SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS and SQL Server Reporting Services SSRS .
• Retail Management Call Center cube design and development with 10 Facts and 28 Dimensions using Agile Software Development.
• Implemented efficient SSAS designs by incorporating leaf level calculations at the database level to gain performance compared to calculations design.
• Implemented Delta processing for SSAS multi-dimensional cubes by implementing Current partition creation for every measure group and implementing XMLA-driven processing jobs.
• Implemented Incremental Deployment Strategy for SSAS objects using SSAS Deployment Wizard and capturing Calculations using SQL Profiler for use in Calculations-only Deployments. Utilization of ASCMD command in XMLA execution for TIDAL jobs.
• Implementation of a total of 36 Crystal Reports migration to SSRS in multiple phases using SDLC in a rapid implementation phase that contained 30 development days and 15 QA days.
• Implemented Delta processing for SSAS multi-dimensional cubes by implementing Current partition creation for every measure group and implementing XMLA-driven processing jobs.
• Performance tuning of SSAS Server by intelligently switching between Partition design and Aggregation design to achieve maximum network efficiency. Involved in creating advanced Aggregation designs using BIDS helper application.
• Implementation of SQL-driven SSRS dataset code migration to Multi-Dimensional Expressions MDX using SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .

Confidential

Position: SSAS/SSIS/SSRS Developer

Responsibilities:

• Implemented a mid-size Ware house/data mart Vontik Application solution with 5 facts and 12 dimensions for analyzing Vontik application using SQL Server Integration Services SSIS and SQL Server Analysis Services SSAS .
• Designed and supported a scalable ETL process for the Vontik data mart using SQL Server Integration Services SSIS and T-SQL Stored Procedures.
• Streamlined data imports for Vontik data mart by re-designing existing legacy ETL Structure using SQL Server Integration Services SSIS for various data feeds such as Sql Server, MS Excel.. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Designed and developed several calculations such as Member Count per Customer, Profile Entity Count at Customer, company, profile level, Account by Ranges, etc. using SQL Server Analysis Services SSAS and Server side Multi-dimensional Expressions MDX .
• Performance tuning of SSAS Server by intelligently switching between Partition design and Aggregation design to achieve maximum network efficiency. Involved in creating advanced Aggregation designs using BIDS helper application.

Confidential

Position: SSAS/SSIS/SSRS Developer

Responsibilities:

• Implemented a mid-size Ware house/data mart TCR Transmissions Conversion Repository solution with 5 facts and 8 dimensions for analyzing Wachovia Migration Process Tracking using SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
• Designed and supported a scalable ETL process for the TCR Transmissions Conversion Repository data mart using SQL Server Integration Services SSIS and responsible for setting up DEV/SIT/UAT/PROD environments for improved efficiency and minimizing average error count per month.
• Streamlined data imports for TCR data mart by re-designing existing legacy ETL Structure using SQL Server Integration Services SSIS for various data feeds such as Oracle, MS Access, MS Excel, CSV files. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed and maintained an enterprise Reporting Solution using SSRS with an emphasis on -through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
• Designed and developed several non-additive measures such as DaysCompanyOnCompleteStatus, AgingDays at relationship, company, application profile level, ActualMonthlyTargetForCompanies, etc. using SQL Server Analysis Services SSAS and Server side Multi-dimensional Expressions MDX .

Confidential

Position: SSAS/SSIS/SSRS Developer

Responsibilities:

• Designed and developed enterprise warehouse solution containing 18 Dimensions and 12 Facts based on Star Schema using SQL Server technologies T-SQL, SSIS, SSAS and SSRS from multiple text, CSV files and Relational systems such as Oracle, DB2 and SQL Server.
• Performance tuning of SSAS Server by intelligently switching between Partition design and Aggregation design to achieve maximum network efficiency. Involved in creating advanced Aggregation designs using BIDS helper application.
• Implemented efficient SSAS designs by incorporating leaf level calculations at the database level to gain performance compared to calculations design.
• Experience in designing reports for the end user using SQL Server Reporting Services SSRS and creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
• Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports.
• Expert in calculating measures and dimension members using multi-dimensional expression MDX and mathematical formulas. Deployed and maintained SSAS Objects using deployment wizard or using Synchronize database wizard.
• Created static and dynamic named sets for financial reporting needs using multi-dimensional expressions MDX .
• Improvised existing stored procedures by applying performance tuning methods with clustered/non-clustered index creation, statistics, and creation of primary key constraint, removal of duplicates, replacing sub-queries with left and inner joins for underlying tables.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard.
• Wrote complex stored procedures for streamlining incremental data loads using left join.

Confidential

Position: SSAS/SSIS/SSRS Developer

Responsibilities:

• Wrote Client-side as well as Server-side MDX for multiple report types such as parameterized, drill down, drill through, URL and dashboard reports.
• Involved in client interactions as well as functional requirement document FRD generation.
• Worked with complex MDX functions such as Periods To Date, Year to Date, etc. to compute FOH/100 Front Office Hours per hundred guests , BOH/100 Back office hours per 100 guests , PPA Price Per Averages and plotting historical versus current sales, labor, guests statistics.
• Developed and maintained report models to be used as data source for ad-hoc reports.
• Facilitated on the fly and ad-hoc report request grants to financial team members on daily basis.
• Migrated existing SQL sourced reports to MDX sourced reports to facilitate faster report rendering and more transparency to the end user.
• Implemented conditional formatting in SQL SERVER Reporting Services to facilitate various report requests from finance, marketing, etc. departments.
• Developed Visual Basic VB Code for facilitating complex business logic in Reporting Services Code property for custom-report generation and converting date parameters into SSAS time dimension members.
• Expert in data verification in SQL Server database systems as well as SQL SERVER Analysis Services cubes for quality data preservation.
• Worked with MacMarket front end application developers for facilitating the ad-hoc query requests as well as embedding crucial company reports such as dashboards, Labor productivity, Sales margin reports in a .NET front end.
• Created Company health determining measures, KPI's as well as defining Actions, translations and perspectives. Deployed and maintained SSAS Objects using deployment wizard or using Synchronize database wizard.

Confidential

Position: SSIS/SSRS Developer

• Wrote complex T-SQL statements, Stored Procedures and performed Database storage migration.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions CTE's for recursive operations.
• Exceptional communication skills in requirement gathering and design strategies for database management system.
• Offered production support at regular periods for migration and data issues.
• Developed re-usable stored procedures for database application support.
• Worked with transferring the data using SSIS SQL Server Integration Services packages.
• MS Access, MS Excel, CSV files to the target.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Designed and rolled out canned and ad-hoc reports.
• Designed drill down, drill through, sub-reports and ad-hoc reports on large scale.
• Responsible for scheduling the subscription reports with the subscription report wizard.

Confidential

Position: SSAS/SSIS/SSRS Developer

• Created SQL Server Reports using SSRS 2005.
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down, drill down, sub reports, URL reports and dashboard reports in SSRS 2005.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Developed, monitored and deployed SSIS packages.
• Implemented different types of constraints on tables.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Confidential

Position: SQL Developer/DBA

Responsibilities:

• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Performed database backups operating system, flat file backups export/import .
• Used Snapshot replication for creating multiple instances of a database for distributing the workload.

Environment: MS SQL Server 2000/ 7.0, Windows 2000 Server, DTS, T-SQL.

TECHNICAL SKILLS: SQL SERVER 2008/2005, MS SQL ANALYSIS SERVICES, MS SQL INTEGRATION SERVICES, MS SQL REPORTING SERVICES, POWERPIVOT, XMLA, T-SQL/PLSQL, MDX, .NET FRAMEWORK, C and ANALYZER.