SUMMARY

• Business Intelligence Lead with 9 Years 5 months of experience in analysing, designing, developing and supporting effective Business Intelligence solutions for large enterprises.
• Expertise in designing OLAP cubes, ETL, Designing Database, Data Visualization, Statistical Analysis and Modelling, data warehouse methodologies using different BI tools and databases.
• Experience in conducting Requirement gathering and Analysis, project estimation, requirements analysis, functional specification, technical design, technical development, test planning and test execution, implementation planning and support.
• Highly motivated, proven analytical skills and good at decision making.

TECHNICAL SKILLS

BI Tools: SSAS 2012/2008/2005/2000, SSIS 2012/2008/2005/2000,SSRS 2012/2008/2005,SAP business objects XI 3.1, SAS Enterprise Guide 4.3, SAS Forecast Studio, SAS OLAP Manager, SQL server2000,, SPAGOBI 3.6, Infor Office plus, Tableau 8.1 server/desktop, SSDT 2012/2014, Visual Studio 2005/2008, SharePoint 2010 Performance Point Service

Languages: MDX, T - SQL, R.

Analytics Packages: R, R studio server

Statistical techniques: Logistic Regression, Linear Regression, Time Series Analysis, Principal Component

PROFESSIONAL EXPERIENCE

Confidential, Omaha, Nebraska

MSBI Lead/ Sr.Developer

Responsibilities:

• Responsible for the comprehensive project execution and planning, requirement gatherings from different Project and districts Managers, documenting functional requirements, technical designs.
• Effectively managed team size of 6 for the development and support activities.
• Refactored existing OLAP cubes and ETL solution, which were on SQL Server 2008 on to SQL Server 2012.
• Developed template cubes of different OLAP cubes on SSAS 2012, Reports on SSRS and got approved by Project Controls team and Stakeholders
• Responsible to design, develop and maintain 20 OLAP cubes (Both OLAP and Tabular Models)
• Designed and developed complex SSRS reports by using features like Sub-reports, Charts, Linked reports, Hierarchy Reports, Drill through, Drill Down reports etc.
• Developed views and complex Stored procedures for Self-service model ( tableau)
• Experience in developing complex Tableau dashboards for the Site Project Manager, District Managers.
• Responsible to Co-ordinate with project control teams and DBA for the Weekly production deployments and testing.
• Delivered intuitive and innovative Data visualisations for Site Project Manager, District Managers using Tableau and SSRS
• Designed, developed and managed SSIS packages for the extraction of data from different data sources like Oracle, CSV files, SAP MM and load them on to respective data marts.
• Coordinated Data Architect, DBAs, Project controls, Business Analysts and Microsoft development Team for the deliverables.
• Worked closely with the development and support to trouble shoot any technical issues on SSAS/SSIS/SSRS and Tableau dashboards.
• Responsible for ensuring 100% process compliance for new implementations as per design document on development, QA and production.
• Conducted stake holder meetings, Subject Matter experts (SME) for the Quality day meeting, Road maps for new implementations, Delivery status meeting, change requests.
• Mentored the team with best practises of SSAS like Attribute Relationships, Analysis Services Query Performance, error handling for the better performance of the OLAP cubes, performance of SSRS reports.
• Have developed new process for the new Implementations, support activities and Change requests and to update the Business Process Management (BPM) document accordingly.
• Effectively delegated work between the team members, while handling change requests, issue tickets
• Documented User-end manuals and provided user-end training for the ad-hoc analysis, SSRS and Tableau

Environment: Visual Studio 2012, SQL Server 2008 R2/2012/2014,Oracle 12g, SSAS 2012/2008, SSIS 2012/2008, SSRS 2012/2008, C#, Tableau server 8.1,Tableau desktop, SQL server profiler, Share point 2013, PerformancePoint Services, TFS .

Confidential, Omaha, Nebraska

MSBI Lead/ Sr.Developer

Responsibilities:

• Understood the Data model of SAP PM and SAP CRM module tables and map the tables on SQL server, which are required for Equipment reports.
• Align with Simplement team to create a standard Report foundation Views, which include all the key relevant dimensions relating to Equipment and how it is used throughout the SAP system
• Designed and developed views on ODSECC database to build fact and dimensions, for the tabular model on SSAS 2012.
• Align with Project control team, Field Engineers, Project bidding team and Field service managers for the delivery of the equipment usage reports.
• Conducted kick off, requirement gathering, go-no go and sign off meeting with stake holders.
• Developed stored procedures and views for live SSRS 2012 reports and tableau dashboards.

Environment: Visual Studio 2012, SQL Server 2008 R2/2012,Oracle 12g, SSAS Tabular 2012, SSIS 2012, SSRS 2012, Tableau server 8.1,Tableau desktop, Windows server 2008 R2, SQL server profiler, Share point 2013, PerformancePoint Services, TFS

Confidential, ARKANSAS

MSBI Lead / Sr.Developler

Responsibilities:

• Responsible to understand the Legacy solution on Analysis services 2000 and migrate on to SSAS 2008 R2.
• Have created the project execution plan and responsible for delivery of the solution as per schedule.
• Streamlined the process of development, UAT and deployment of SSAS cubes and ETL package on Production.
• Responsible to check the day-to-day activities - monitoring SSIS scheduled jobs for the data loading and refreshing OLAP cubes.
• As per new requirement, developed and configured a new SSIS packages for the data loading, developed the new OLAP cubes and created SSIS packages for the refresh of the cubes accordingly.
• Responsible to attend different service tickets and change requests and address them within SLAs.
• Responsible to understand new change requests and check for technical feasibility, convert them into technical requirements and implement Change requests accordingly.
• Mentored team members and help them to understand different technical requirements for new implementations.
• Responsible to troubleshoot any technical issues, data quality issues, failed SSIS jobs in SSAS 2008/SSIS 2008 and MDX.
• Single Point-of-contact for 5 Windows 2008 servers and 150+ cubes.
• Managed cube refresh schedule windows for all production cubes and make 100% available for end-users for data analysis.
• Conducted root cause analysis on different issues tickets and documented for support activities.
• Prepared different status reports, service ticket logs and weekly support meetings and aligned with BI program manager.

Environment: Microsoft Business Intelligence Studio, SQL Server 2008,Oracle 12g, SSAS 2008, SSIS 2008, SSRS 2008, C#, Tableau server, Windows server 2008, MS Excel 2010/2007,SQL server profiler.

Confidential, MINNESOTA

MS BI Technical Lead

Responsibilities:

• Responsible to check the day-to-day activities like checking the SSIS scheduled jobs for the data loading and refreshing the OLAP cubes.
• As per new requirement, responsible to develop and configure a new SSIS packages for the data loading, developing the new OLAP cubes and create SSIS packages for the refresh of the cube accordingly.
• Responsible to attend the different service tickets and change requests and to address them before defined SLAs.
• Responsible to develop and maintain different reports like weekly, monthly, daily reports and executive dashboards on SSRS for the different functional groups .
• Responsible to understand the new change requests and check for the technical feasibility, convert them into technical requirements and implement the Change requests accordingly.
• Responsible to mentor team members and help them to understand different technical requirements for new implementations.
• Responsible to troubleshoot any technical issues, data quality issues, failed SSIS jobs in SSAS 2008/SSIS 2008 and MDX.

Confidential

SAS BI/MSBI technical Lead

Responsibilities:

• Successfully migrated the reporting solution from MSBI 2005 to SAS BI platform.
• Responsible to understand the business process, functional requirements from different stakeholders, create migration plan, technical design document, develop and deploy on SAS BI environment.
• Responsible to understand the design of the different OLTP reports, OLAP cubes which are developed on the MSBI platform and translate them on to SAS BI environment.
• Managed team of 5 members for executing the migration plan and deliver BI solution on-time.
• Responsible to create dashboards, web reports and publish them on to SAS portal using the SAS Web report studio and document them accordingly.
• Developed OLAP cubes - building the user defined hierarchies, dimensions, fact tables, KPIS and measures using SAS OLAP Studio.
• Worked closed with Oracle DBA for the data quality issues, access for the different views and tables in reporting databases, follow up them for development of different views and materialised views to generate reports on SAS BI.
• Responsible to maintain the metadata, which enables developers to create different reports and dashboards and also give access to the analytics team for to perform analytics on data.
• Developed and support time series forecasting modules on SAS Forecast studio (ARIMA, ARMA, HOLT WINTERS).
• Responsible to schedule the refresh jobs based on refresh schedule windows, monitor them, and debug the failed jobs.
• Responsible to provide the ad-hoc reports for the Executive reporting team, using SAS Enterprise Guide by connecting to oracle reporting database.
• Identify the commonly requested ad-hoc requests and develop on SAS Web report studio and publish them on to SAS portal
• Have created end-user manual to access the different reports and dashboards on the SAS portal.

Environment: Microsoft Business Intelligence Studio, SQL Server 2005, SAS Enterprise studio, SSIS 2005, SSRS 2005, Windows server 2003, MS Excel 2007,SAS forecast studio, SAS Enterprise BI server,SAS Meta data Server, Fedora, Ubuntu LTS 8.10

Confidential,Cinncinatti,OH

SQL Server Developer/ SSAS/SSIS/SSRS

Responsibilities:

• Performed SSAS 2005 capabilities like creating data source views, designing dimensions, fact tables, user defined hierarchies, KPIs, Measure groups on QA and deploy them on production.
• Actively involved in creating SSIS 2005 packages to transform data from OLTP database to respective data marts.
• Performed ETL capabilities on SSIS 2005 like develop new packages, configure packages, deployment of the packages from development to production, scheduling and debugging.
• Configured and maintained huge OLTP and OLAP databases.
• Querying and manipulating multidimensional cubes data through MDX Scripting.
• Migrated data from Oracle to SQL Server data warehouse and developed OLAP cubes using SSAS 2005 and make them available for the end-users and reporting services.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Loading data from various sources like flat files, Oracle database, Access, mdb files to SQL Server database Using SSIS Package.
• Using SQL server reporting services (SSRS) delivered different types for all functional groups.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Improved the performance of the ETL process and reports by tuning the SQL database, SSIS packages and SSAS cubes.

Environment: Microsoft Business Intelligence Studio, SQL Server 2005,Oracle 12g, SSAS 2005, SSIS 2005, SSRS 2005, Windows server 2003,C#.