Professional Summary

Microsoft SQL Server BI / Database Administration Consultant with 12 years of experience in Designing, Executing Managing the Business Intelligence and Data warehousing applications development using SQL 2012/2008/2005/2000, SSIS, SSAS, SSRS, DTS, MAS, MRS, ProClarity, MDX, MS Visio. Familiar with version management, build processes using TFS, Visual Source safe VSS6.0, Subversion.

Experience Summary

• Experience in Data Warehousing with emphasis on Business Requirements Analysis, Application Design, Development, Testing, Implementation and Maintenance of client/server Data Warehouse and Data Marts. Involvement in all phases of SDLC Systems Development Life Cycle from analysis and planning to development and deployment
• Extensive experience in database activities like data modeling, database design, development and maintenance, data transfer, documentation.
• Experience in database administration activities like Backup, Restore, server/database maintenance and SQL performance monitoring and query optimization.
• Strong skills and experience in creating T-SQL statements, functions, stored procedures, triggers and views to implement business logic in Microsoft SQL Server 2012/2008/05/00 database.
• Expertise in design, development and deployment of ETL Extract, Transform and Loading data methodology for supporting data transformations and processing, in a corporate wide ETL Solution using SSIS 2012/2008/2005 for a wide variety of source destinations. Experience in setting up the SSIS 2012 catalog setup running the SSIS packages through SSISDB catalog.
• Expertise in designing and developing Stage Mart environments as part of a BI solution
• Expertise in design and development of OLAP Structures, Dimensions using Star and Snow Flake schemas and Cubes Aggregations, User driven Security, Partitions, Actions, multiple measure groups, Calculated measures, Time Intelligence using SSAS 2012/2008/2005.
• Expertise in providing the consumption of the cube data/SQL database by the end user through pre built, drill down tabular, graph reports using SSRS 2012/2008/2005. All the reports are parameter driven. .
• Strong Knowledge in writing, troubleshooting performance tuning of MDX Expressions to query data from cubes and while developing the reports from Cubes.
• Experience in creating SSRS report subscriptions, data driven subscriptions, deploying maintenance of reports in both Native Mode Share point Mode, Report viewer.
• Facilitating the definition of project scope, goals and deliverables
• Leading, planning, estimating, executing the project
• Excellent Communication and Interpersonal skills. Ability to perform development tasks with minimum supervision following the project standards and procedures. Strong desire to make contribution and learn new technologies.
• Strong analytical, problem solving and programming skills.

Technical Skills

Confidential

Project Title: Program Data Management

Responsibilities:

• Analyzing the business requirements transforming into technical requirements
• Design Development of SSRS reports from SQL database using SQL
• Creating various raw data extracts from live application databases for end user requirements
• Designing Creating data mart cubes databases.
• Testing Deployment of SSRS reports to report native site/ report viewer
• Design Development/Enhancements to the cubes/dimensions
• Development, Testing Deployment of SSRS reports from SSAS cubes using MDX
• Performance tuning Optimization of the MDX queries Reports
• Creating the SSRS reports data driven subscriptions
• Working on SSIS Packages for extracting the data from different source systems loading into data marts
• Resolving and/or escalating issues in a timely fashion

Summary:

• YMCA runs multiple programs for children youth development across USA.
• PDM focuses on programs run in different cities tracks the child/youth information, attendance, performance etc.
• LCDC takes care of the Certifications/Licenses done by staff expiration/progress of the certifications
• Reporting project takes care of developing multiple reports to support research/evaluation specialist's needs.

Confidential

Project Title: Project Engine Reporting Warehouse

Tools: SQL Server 2008, MS Integration Server SSIS 2008, MS Analysis Server SSAS 2008, MS Reporting Server SSRS 2008, Subversion SVN

Responsibilities:

• Design Development/Enhancements to the cubes/dimensions
• Development, Testing Deployment of SSRS reports from SSAS cubes using MDX
• Performance tuning Optimization of the MDX queries Reports
• Design Development of SSRS reports from SQL database using SQL
• Creating Database objects i.e. views stored procedures.
• Deployment of SSRS reports to Share point site
• Working on SSIS Packages for extracting the data from different source systems
• Resolving and/or escalating issues in a timely fashion
• Coordinating with quality assurance teams

Summary:

• Tribune Company is a media company with major daily news papers like Chicago Tribune, Los Angeles Times etc.
• Project Engine is focused on maintaining the daily advertisements requests, costs, maintenance.
• Reporting Warehouse team takes care of the daily maintenance of warehouse, cubes, and reports.
• Integration roll out of Reporting warehouse for different news papers under Tribune Company.
• Creates different variety of reports for growing reporting needs of company.
• Reports are mainly used by Management, Sales Representatives and Sales managers.

Project Title: Data Analytics / Data warehouse

Confidential

Tools: SQL Server 2008, MS Integration Server SSIS 2008, MS Analysis Server SSAS 2008, MS Reporting Server SSRS 2008, Oracle 9i

Responsibilities:

• Maintenance and Support of the SQL Server 2008, SSAS 2008 Cube Databases.
• Design and develop the SQL tables, SSIS Packages, Dimensions, measures for bringing in new data into the existing system.
• Design and develop new Reports using SSRS based on SQL 2008 database and cubes with multiple parameters, groupings, charts.
• Creating stored procedures for implementing business logics for the SSRS reports.
• Constantly monitoring and reporting on progress of the project to all stakeholders
• Implementing and managing project changes and interventions to achieve project outputs
• Understanding the medical bill review process, networks and provider's etc business logics.
• Enhancing and Supporting the Existing Application
• Applying Patches, Testing and Bug Fixing.
• Performance Tuning
• Maintenance/monitoring of daily ETL jobs

Summary:

• Rising is a Medical Cost Containment Company and specialized in medical bill review, hospital bill review, and medical cost containment services for the workers' compensation, auto, liability and group.
• The Data Analytics team takes care of Rising Data warehouse. Data warehouse have several applications to extract data from multiple varieties of sources like Oracle 9i, Excel, SQL database etc, to build the cubes and maintains reports, daily subscriptions.
• Reports developed by us are mainly used by management customers.

Project Title: Hydra Hydra BI

Tools: SQL Server 2008, MS Integration Server SSIS 2008, MS Analysis Server SSAS 2008, MS Reporting Server SSRS 2008, Team Foundation Server TFS

Responsibilities:

• Developing and delivering progress reports, proposals, requirements documentation, and presentations.
• Determining the frequency and content of status reports from the project team, analyze results, and troubleshoot problem areas.
• Coaching, mentoring, motivating and supervising project team members and influencing them to take positive action and accountability for their assigned work.
• Building, developing, and growing any business relationships vital to the success of the project
• Enhanced and Supported the Existing Application
• Applying Patches, Testing and Bug Fixing.
• Maintenance and Support of the SQL Server 2005/ 2008 Database
• Performance Tuning
• Version maintenance of Source Code using TFS 2008
• Design and Develop the BI Framework for the Application.
• Development of Data Models and Creation of the Staging and Mart Environments.
• Building Complex SSIS packages using a variety of Tasks and Components Data Flow Task, Send Mail Task, Cache, Multi Cast, Merge Join, Lookup, Conditional Split, Derived Colum, Data Conversion, Union All, Row Cont, Sort
• Design and Development of Cubes and Dimensions using Star and Snowflake Schema methods. Parent Child Dimensions, Role Playing Dimensions, Slowly Changing Type 2 Dimension
• Interacted with the users, conceptualized, planned and created complex SSRS Reports sourced out of both SQL DB and SSAS DB
• Created Mining models using time series algorithm to get the estimated project completion dates and the analysis on the resources required to complete the project on the given timeline. The model uses a wide variety of parameters such as project start date, updated dates, percentage of completion at every update, number of resources.

Summary:

• The Tools and Automation team which I am part of architects and programs solutions that improve the efficiency and customer experience of service delivery from Avaya.
• Hydra is one such tool developed and supported by us. It is a project/incident management tool built on top of .Net framework and SQL server 2005/2008. In this user can create projects, action plans, tasks track and monitor them against a wide variety of parameters, notify the members involved based on the actions performed and lot more.
• Reporting for the management for this application is developed using the Microsoft Business Intelligence toolset.