PROFESSIONAL SUMMARY

• Over 8 years of IT experience in the Business Analysis, Data Analysis & Mining, Business Intelligence and Portal Application development.
• Possess extensive knowledge in Business modeling and Data modeling.
• Experience in SSRS SSAS Administration, Configuration and Implementation
• Experience as Analysis Services Cube Developer (OLAP) and Report Developer (SSRS)
• Excellent knowledge of creating Matrix Reports, List Reports, Chart Reports and Drill-down Reports.
• Experience in SSAS all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Creating, modifying, deploying and browsing Cubes with multiple fact measures and multiple dimension hierarchies in SSAS.
• Experience in SSRS design and deployment of Parameterized, Drilldown, Drill through, Sub, Linked, Snapshot, Cached, and Ad hoc Reports.
• Using Report Builder 3.0, Designing Report Models, Scheduling Reports and Building Tablix, Chart, and Map reports.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint.
• Expert in Queries, Stored Procedures and Views Development in SQL SERVER 2005 2008
• Experience in setting security and assigning roles to end users on report server connection.
• Expert in Design, Implement and Manage the SQL Server Analysis Services and Reporting Services Database
• Experience in Share point Server 2010 and WSS 3.0 (Development, Administration, Configuration and Implementation.).
• Expert in creating OLAP cubes, dimensions, business critical KPIs, and MDX queries using Analysis Services.
• Experienced in Business Intelligence Solutions (Share point Designer 2010) like: Dashboards, KPI´s, Scorecards, OLAP Cubes, Analytic Charts and Reports.
• Expert in Enterprise portals and Web Portals Implementations with Share point Server 2010
• Experience in developing and implementing: Share point Sites Collections, Web Applications, Web Parts, Excel Services OLAP Cubes, Custom Metadata, Libraries, Lists and Document Management.
• Strong Knowledge in Reporting Development (Costing, finance, Inventory Management, production, etc.)
• Strong understanding of Relational database. Proficiency in writing SQL Queries, Stored Procedure and Views in SQL Server.
• Worked with the Clients/users to get the user requirements and created the specification and the Documentation for the Warehouse and Cognos Business Intelligence Environment
• Worked with SharePoint Master Pages, Page Layouts using HTML, CSS, and JavaScript.
• In depthknowledge in SharePoint architecture along with extensive exposure in using SharePoint Designer, InfoPath, Performance Point Dashboard.
• Extensive knowledge in out-of-box functionalities of SharePoint 2007/2010.
• Adeptness in understanding business needs and rapid adaptability to changing environments.
• Experience in managing all aspects of daily IT operations with focused, detail oriented approach to completing tasks with the demonstrated ability to work with conflicting priorities under tight deadlines.
• Skilled Team Leader, trainer and motivator with excellent analytical and communication skills.

TECHNICAL SKILLS
Operating Systems Windows Server 2000, Windows NT Server, Windows Server 2003, Windows 7/XP, UNIX
Portal technologies SharePoint 2010, Project Server 2010, Microsoft Office SharePoint Server 2007, Office 2010, Share Point Designer2010/20007, BI Scorecards and Performance Point Server
Languages C, C++, C#, Java, SQL, Shell Scripting, ASP.NET, UML, and XML
Reporting Tools SQL Server Reporting Services (SSRS), Crystal Reports 9.0, and Report Builder 3.0
Database SQL Server 2005 2008, SQL Cluster.
Applications Microsoft Business Intelligence Development Studio 2010, Report Builder, Performance Point 2010, Share point Dashboard Designer 2010, Power Pivot, Visual Basic and MS- Visio

PROFESSIONAL EXPERIENCE

Confidential,MA June 12 Present
Sr. OLAP Developer/Team Lead

Confidential,provides a comprehensive suite of analytic products and data management services to include insurance companies, health plans, third party administrators (TPAs), self-insured employers, disease management organizations, consultants, insurance brokers, hospitals, and provider groups. My primary role is to provide architectural guidance in the area of Microsoft BI stack: SSAS, SSRS, PerformancePoint and Excel Services. I was extensively involved in the Cube Creation, SSAS Aggregations, Dimensions, Measures, calculations, MDX report generation and Dashboards.

• Served as SME for designing, developing, and delivering high performing Microsoft SQL Server Analysis Services (2008) OLAP cubes using industry best practices.
• Created and modified SSAS cubes (dimensions, facts, members, calculations, etc) including relational side design
• Worked with project team to deliver OLAP solutions to provide robust high availability and performance.
• Created Cubes and performed data mining on the data using the fact table and the dimension using SQL Server Analysis Services 2008.
• Developing OLAP cubes using SSAS 2008 and calculated the metrics that were revealed in the functional analysis.
• Designed and implemented facts, dimensions, measure groups, measures and OLAP cubes using dimensional data modeling standards in SQL Server 2008 that maintained data.
• Involved in development & Deployment of SSAS Cube, Monitor Full and Incremental loads and support any issues.
• Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.
• Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements and Created roles using SSAS to restrict cube properties.
• Developed SSAS reporting data models, drill-down and drill-through capabilities, security / access controls and error handling.
• Defined MDX Scripts for querying the data from MOLAP cubes (SSAS) and build reports on top of cubes.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Assisted other developers in design and implementation of high availability/high performance SSAS solutions while ensuring best practices are followed.
• Actively participated in meetings with multiple business units and end users from many disciplines to ensure that developed and integrated systems meet their needs
• Creating complex queries for report development against relational and multidimensional database systems using Transact-SQL and MDX for SQL Server Analysis Services
• Troubleshoot and diagnose critical issues with SSAS Cubes.

Confidential,OH Nov ’11 June 12
Sr. Reporting Team Lead

Pacer International is a leading asset-light based transportation and logistics services provider. Pacer provides an array of other transportation services including truck services and brokerage, flatbed/specialized trucking, international ocean shipping and freight forwarding, warehousing and distribution, and transportation management. My primary role is to provide architectural guidance in the area of Microsoft BI stack; SSIS, SSAS, SSRS, PerformancePoint and Excel Services. I was extensively involved in the SSAS Aggregations, Dimensions, KPI, Measures and calculations, MDX and SQL report generation, Dashboards and Excel Automation.

Key Responsibilities:

• Meet with customer business and technical leaders to identify and scope the business opportunities, document business requirements, identify effective reporting techniques.
• Created Cubes and performed data mining on the data using the fact table and the dimension using SQL Server Analysis Services 2008.
• Developing OLAP cubes using SSAS 2008 and calculated the metrics that were revealed in the functional analysis.
• Designed and implemented facts, dimensions and OLAP cubes using dimensional data modeling standards in SQL Server 2008 that maintained data.
• Involved in development &Deployment of SSAS Cube, Monitor Full and Incremental loads and support any issues.
• Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.
• Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements and Created roles using SSAS to restrict cube properties.
• Created usage based aggregations in cube to minimize time for query retrieval.
• Developed Score Cards and advanced set of Dashboards using Microsoft Performance Point Server 2010 to implement KPIs.
• Designed and implemented Parameterized, Cascading parameterized, Drill through and Tabular reports using SSRS.
• Developed queries for drill down reports to get the dataset required building the report, created data source and data sources views for metadata view.
• Identified the best data sources for reach report field, identify risks and constraints, and design reporting formats.
• Respond to ad-hoc query requests from various departments including Rail, Pricing, Network, Vendor Services, Finance, and Professional Services.
• Provide guidance and recommendation on BI reporting packages.
• Provide guidance and mentor junior developers and participate in team improvement discussions
• Provide a consultative approach with business users and deriving the data flow requirements based on those needs
• Coordinate with Project Managers and participate in project planning
• Participate in, and contribute to, architecture discussions to design new data warehouse platform
• Lead coordination of the QA test process and migration of objects through the change control process

Environment: VS 2010, SQL Server 2008, .NET Framework 3.5, SQL Server BIDS, SQL Server SSIS, SSAS, SSRS, DTS, Report Builder, SharePoint, PerformancePoint Services, Power Pivot, Server 2008.

Confidential,MN Dec ‘10 Nov ‘11
Sr. SQL BI Consultant/Team Lead
My role is to provide architectural guidance in the area of Microsoft BI stack; SSIS, SSAS, SSRS, PerformancePoint, Excel Services and their integration into MOSS. Designed and optimized OLAP databases, designed the role based security for SSAS databases, designed effective reports and dashboards.

Key Responsibilities:

• Business Intelligence development and support, database administration of SQL Server 2005 and 2008, data modeling and database design for newly developed systems and enhancement of existing systems, and system integration efforts.
• Dedicated Business Intelligent resource for re-architecting existing production databases.
• Actively engaged in design discussions for all Business Intelligence and Database initiatives.
• Worked on all phases of data warehouse development life cycle, from gathering requirements to testing, implementation, and support using SSAS.
• Designed the Cognos Server Architecture with Multiple servers in a clustered environment
• Developed Complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs. (Cubes for costing, production, finance, sales, purchasing, accounting and inventory management.
• Designed facts and dimension tables and defined relationship between facts and dimensions with Star Schema and Snowflake Schema in SSAS.
• Created Stored Procedures, User-Defined Functions, Triggers, Cursors, and Views.
• Created MDX scripts and SSAS user defined functions.
• Designed and deployed Tabular, Matrix, Chart, Linked, Drill-down, and Drill-through Reports with drop down list of parameterized options in SSRS.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Helped users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services.
• Developed reports on SSAS Cubes as data source.
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint.
• Development of analytical reports for process costing, production, finance, sales, purchasing, accounting and inventory management with Microsoft Business Intelligence Development Studio (BIDS).
• Generated Matrix Reports, List Reports, Chart Reports and Drill-down Reports and parameterized reports using SSRS.
• Design of analytical reports for decision-making in the main departments that make up the core business (Costing, finance, inventory, etc.)
• Ensured smooth running of SQL Server and confirming databases are fast and efficient.
• Configured and managed database maintenance plans for regular backup operations.
• Participated with users, and technical manager to fully understand the implementations (reports and cubes)

Environment: VS 2010, SQL Server 2008, .NET Framework 3.5, SQL Server BIDS, SQL Server SSIS, SSAS, SSRS, DTS, Report Builder, SharePoint, PerformancePoint Services, Power Pivot, Server 2008.

Confidential, MN Dec ‘09 Nov ‘10
SQL BI Developer & SharePoint Consultant
Confidential,is a global medical device company that sells medical devices and instruments in more than 100 countries and has over 20 operations and manufacturing facilities worldwide. My role as an team lead is to provide architectural and implementation guidance of enterprise Microsoft Business Intelligence suite; Skinning/Branding, Farm Design & Management, User Adoption Strategy Planning, SP 2007->2010 Migration, Custom Web part Development, Workflow Development, BCS, User Profile, Faceted and Custom Search, SSAS, SSIS, SSRS, PerformancePoint and Power Pivot.

Key Responsibilities:

• Pilot Upgraded and Migrated the MOSS farm custom solutions and Custom solution to SharePoint 2010 farm.
• Re-Architecting the Custom Solutions and applications build on MOSS 2007 to work in the new frameworks of SharePoint 2010.
• Upgraded Project Server 2007 to Project Server 2010
• Installed and Configured SharePoint 2010 on windows 2008 R2 base System by strip out server from scratch.
• Designed and Developed a SharePoint based Email Archiving Solution for the entire user community.
• Work directly with key stakeholders to define and develop an executive dashboard for reporting program level KPI and developed custom web parts
• Created themes in Upfront for client and internal user access for the Cognos Portal.
• Designed and developed SQL database monitoring tool to update SharePoint Site and KPI lists.
• Developed dashboard to see the overall performance of the serves, SQL instance sizes, and SharePoint farm Databases.
• Defined and designed taxonomy for the Intranet and Extranet portal after extensive interviews with business users.
• Re-branded the out-of-box portal with themes and created a consistent user experience in MOSS 2007.
• Architected, designed and implemented MOSS 2007 features and Custom Solutions on SharePoint 2010 and 2007 solutions, Web parts, Event handler workflow and custom SharePoint web services
• Installed and configured SQL reporting 2008 services which are used for project management solution. Developed Custom reports for helpdesk application.
• Developed SharePoint InfoPath form to capture data, integrate with the existing helpdesk system using .Net 3.0, C#, Web services and custom workflow.
• Analyze, design, test and implement software tools to enhance web technology and web-based database connectivity.
• Troubleshoot and research potentially difficult SharePoint challenges, best practices, and feature development to deployment, and WSS 3.0 object models.
• Responsible for guiding the technical efforts of the team, ensuring that the best technical approach and practices are applied in all phases of the application lifecycle including quality of code produced by their team members and consulting resources.

Environment: VS 2010, SharePoint Server 2010, .NET Framework 3.5, ASP.NET, VSS, AvePoint DocAve Replicator, Nintex WF 2010, SharePoint Designer 2010, Server 2008, jQuery and Microstratergy.

Confidential, MN Jan ‘09 Nov ‘09
Senior BI / SQL Data Analyst
United Health Group is one of the leading Insurance Company in the country. My role is to implementation guidance of Business Intelligence solution using MS SQL Server 2005 tools, EXCEL, PerformancePoint and SharePoint Servers;
Consolidating data from diverse data sources into a uniform SQL Server 2005 database, using SSIS to define data imports, build and schedule packages, define integration flow, log and notify via email data and execution error exceptions, and create Database Maintenance Plans.

Key Responsibilities:

• Advised and implemented SSRS installation in SQL Server 2005, including custom-built security extension.
• Designed and implemented multiple reports in SSRS for membership lists, team rosters, and physical locations of matches, establishing SSRS as a viable tool for reporting, replacing ASP applications, accelerating design and deployment of management reports.
• Designed and implemented multiple SSIS applications for importing and data scrubbing text files into SQL Server 2005 databases.
• Extensive use of Regular Expressions for custom transformations, packages isolated and posted invalid data to alternate error tables for later correction and re-importing.
• Created and implemented multiple OLAP applications in SSAS, including SSIS packages to process cubes, as well as supporting data marts.
• Using Windows Performance Monitor and SQL Server Profiler, analyzed database performance on all SQL Server databases, improving performance and reducing system and network overhead
• Designed and implemented data mart for monitoring and analyzing data through a web interface in a timely fashion.
• Designed and implemented multiple ETL processes for staging, scrubbing, and importing data into SQL Server databases for use by web applications.
• Analyzed and modified underperforming legacy T-SQL code greatly improving performance and accelerating through-put.

Environment: VS 2008, T-SQL, SQL Server 2005, OLAP, SSIS, SSRS, SSAS, DTS, Data Marts, Data Warehousing, Business Intelligence, Performance Monitor.

Confidential,GA Aug ‘05 Dec ‘08
SQL Server BI Developer
The scope of the project included tracking multimillion dollar product sales in IT shared services with a primary focus on the North America operations. This provided the sales division with current data on inventory, sales, shipping cost, sales price, profit analysis & margins. Gathered project requirements and worked through layered report approval process.

Key Responsibilities:

• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2005/2008.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Used MDX expressions to define calculated members in cubes to calculate values at run time.
• Created copies of operational Databases using the Import/Export Wizard.
• Monitored the performance of Database objects using Performance Monitor that ships with SQL Server 2005/2008.
• Developed Triggers to raise events on executing insert, delete and update stored procedures.
• Optimized existing stored procedures to achieve improved performance
• Used MDX scripting for querying OLAP cubes.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2005/2008.
• Generated reports using the Crystal Reports and Reporting Services 2005/2008Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005/2008.
• Developed XML tags to structure data and improve the data migration process.
• ETL process was documented for future references.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment
• Created OLAP CUBEs using SQL Server Analysis Services (SSAS).
• Designed user defined hierarchies in SSAS including parent-child hierarchy.

Environment: MS SQL Server 2000/2005, Windows Server 2003, SSIS, SSAS, SSRS, DTS, SQL profiler, T-SQL, Agile, MOSS 2007 , XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008.

EDUCATION

• Masters of Business in Finance
• Masters of Science in Computer Science
• Bachelor of Engineering in Computer Science