SUMMARY

• Senior BI Consultant, Architect, Reporting expert, Administrator, and Implementer with more than 24 years of experience at emerging international corporations including in the areas of Business Intelligence, Data Warehousing, reporting, Data Analytics, Data science, Bigdata, Cloud, ERP, ECM, Unix scripting and Internet technologies
• Good understanding various industries including Higher - Ed, Insurance, Healthcare, Utilities, Entertainment, Financial, warehousing, Auto and hi-tech areas.
• Expert in Data Analytics/reporting/BI/ETL/Data Science solutions and has more than 22 years of experience in using various reporting tools like SSRS, SSIS, SSAS, Power BI, MDX, SQR, SAP Crystal Reports, XML-Publisher, N-Vision and Oracle reports.
• Expert in using SQL-Server BI suite 2005, 2008 & 2008-R2, 2012, 2014,2016, 2018,2019 on SSRS, SSIS and SSAS DAX(Tabular)/MDX areas, TFS and visual studio 2015/2017/2019.
• Good understanding of Microsoft Cloud, Data Science and Bigdata Technologies.
• Evaluated various reporting tools and suggested which reporting tool will be a best fit for the customers’ needs, can work with new reporting tools as needed.
• Expert in writing database and platform independent SQL, T-SQL, PL-SQL, Sybase Transact SQL, Stored procedures for Reporting, Data Warehousing, Business Intelligence, Data Mining, Data Cleansing and Data Analytics needs.
• Experience in Enterprise Data Modeling (Dimensional & Relational) with a good understanding of the Data modeling concepts like Star Schema and Snowflake schema as well as Normalization.
• Developed custom Reports and Analytics for Management, Executives and Board meetings using various reporting tools and technologies.
• Involved and worked with various California State University’s CSU CMS PeopleSoft project since its inception.
• Managed teams for BI, DW and Reporting projects.

PROFESSIONAL EXPERIENCE

Sr. BI Principal Consultant

Confidential, Cypress CA

Responsibilities:

• Responsible for all databases and data applications across the company’s divisions globally for Data Warehousing and Business Intelligence.
• Developed reporting and analytical solutions to satisfy requirements to a high degree of quality using Power BI, SSIS, SSAS, JIRA, AZURE, DAX, GitHub, Data Science, SQL Server 2016/2017 and Visual Studio 2017/2019
• Involved in delivering end-to-end products from data ingestion, ETL, Data Warehouse, semantic layers and front-end reporting on greenfield projects
• Involved in leveraging big data technologies to deliver newer ways of interacting with data
• Involved in work through full projects from inception, scope, requirements, planning, development, testing and delivery working in a soft-agile environment
• Worked with the wider development team and others ensuring open lines of communication
• Provided testing to ensure requirements have been met and support the business through UAT, issue resolution and new feature requests
• Involved in providing basic reporting and data analytics to the business providing useful and new insights into an exciting industry and pave the way for more advanced analytics
• Parker Hannifin is a Fortune 250 global leader in motion and control technologies. For 100 years the company has engineered the success of its customers in a wide range of diversified industrial and aerospace markets.
• Developed Functional Requirements based on the information received from the key business users, gathering business requirements, documenting the requirements, and proposed the Power BI report design mockups to the business users.
• Designed and Developed Data Warehouse and loading the complex data from various sources and systems including but not limited to .txt files, .xls files and SQL Server databases using SSIS 2012 and scheduled to refresh the data nightly. Created and Modifying Data Warehouse Tables, Stored Procedures as required and managed the code in TFS.
• Designed and developed number Power BI reports using the data from SQL server Data Warehouse and deployed to Power BI server 2018/2019.
• Power BI reports data will be refreshed after the Data Warehouse refresh on daily basis.
• Involved in analysis, design, configuration, and custom programming in the implementation of Power BI Data Analytics and Data Warehouse, miscellaneous technical support for Sharepoint Online and other information technologies.
• Designed and developed number Power BI reports using the data from Excel/CSV/SQL server and deployed in PowerBi.com and managed as needed.
• Managed CHSU SharePoint workflow project to automate the publishing process and upgraded to SharePoint Online.

Sr. BI Developer/Administrator

Confidential, Irvine CA

Responsibilities:

• Confidential is a leading supplier of software and solutions to automate and digitally transform human and information intensive processes across front and back office operations. Confidential delivers its software and solutions through its direct sales and services organization and more than 650 indirect channel partners in more than 60 countries throughout the Americas, EMEA and Asia Pacific.
• Globally Responsible to Architect, design, develop, maintain, administration and support of reporting, dashboarding, Data Warehouses using various Microsoft tools including but not limited to SSRS 2008-R2/2016, SSIS 2008-R2/2016, SSAS 2008-R2, SSAS 2016 Tabular model, Power BI, TFS and Visual Studio 2015.
• Involved in getting the data from various sources including but not limited to SQL server 2018R2/2016, Microsoft Dynamics AX, Microsoft Dynamics CRM, SAP, Oracle NetSuite, Boomi, Salesforce, Financial Force various M&A and System Upgrade Projects.
• Imported and loaded the data in Salesforce and created Power BI reports and dashboards connecting to Salesforce.
• Involved in salesforce administration as and when needed.
• Transformed complex business logic into Database design and maintaining it by using SSAS 2016 tabular models to support users on SSRS 2016 Excel workbooks, paginated reports and power BI Desktop reports and dashboards.
• Extensively involved in design and development of SSRS 2016 Paginated reports, Power BI Desktop reports and Dashboards.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views , T-SQL Scripting and Jobs.
• Created and Modifying Data Warehouse Tables, Stored Procedures , Views, Indexes, User-defined Functions, and Triggers as required.
• Maintained and enhanced SSAS 2008R2 Cube and MDX as needed.
• Maintained and enhanced SSIS 2008R2/2016 (ETL) packages to get the data from Various data sources.
• Administered the global user access for 2008 R2 SSRS reports using SharePoint intranet site.
• Administered the global user access and subscription management for SSRS 2016 Report Portal, KPIs, Excel workbooks for tabular models, paginated reports, Power BI Desktop reports and dashboards.
• Extensively involved with the end-users and also in functional areas including but not limited to Billing, Contracts, CRM, Finance, Invoices, Procurement, Professional Services, Quotes, Sales and TechSupport.

Sr. BI Principal Consultant

Confidential, Cypress CA

Responsibilities:

• As a principal consultant worked on number of Client projects including EDI, Ultura, Psychemedics, Cyncast, Muve Music & Move inc.
• At Education Dynamics Inc, worked on a project to build Staging DW Database Cube using SSIS, ZAP Cube express and SSAS. Developed reports/Dashbords/ScoreCards/KPI’s/Analytics using SSRS/ZAP BI
• At ULTURA™ worked on a project to load the global data from various sources like Microsoft Dynamics, Sage, XL to SQL Server 2012 Data Warehouse and Sales Force using SSIS and also developed reports using SSRS and SSAS.
• At Psychemedics Corporation designed and developed very complex eDW(Enterprise Data Warehouse) in SQL Server 2008 R2 from scratch using SSIS, SSAS and SSRS. Developed and enhanced very complex TSQL scripts, Stored Procedures and triggers to meet the business/reporting needs using SSRS. Used SSAS, SSRS, XL and MDX for analysis and reporting/analysis/ad-hoc reports/Dash Boards in SQL Server 2008 R2 BIDS, TFS environment. Worked on performance tuning/optimizations of queries using various technics to improve the performance of reports and ETL packages.
• At CynCast Corporation developed SSIS packages in 2008 R2 and 2012 environments based on the SQL scripts developed in 2005. Developed SSRS reports in 2008 R2 and 2012 environments based on the SQL scripts developed in 2005.Worked on performance tuning/optimizations of queries using various technics to improve the performance of reports and ETL packages. Built number reports/presentations using SSRS. Developed and enhanced very complex TSQL scripts, Stored Procedures and triggers.
• At Muve Music extensively utilized SSIS packages to create complete ETL process and load data into SQL Server database which was to be used by Reporting Services. Performed operations like sorting, merging on the source data in order to clean the data and remove duplicates. Created SQL Jobs to execute SSIS packages and processed the cube to publish data on SharePoint server. Handled the DBA activities on production (VLDB) and development environments. Used SSAS, SSRS, PowerPivot, XL and MDX for analysis and reporting purpose in SQL Server BIDS environment.
• At Move, Inc. (REALTORS®) involved in transition of very complex DWG (Legacy Data Warehouse) to EDW (Enterprise Data Warehouse). Extensively used all the Microsoft SQL Server BIDS tools like SSIS, SSRS and SSAS and developed very complex packages and reports. Also used Tableau and PowerPivot for data visualization and analysis.

Principal Consultant

Confidential, Cypress CA

Responsibilities:

• Developed various SSIS packages for implementing ETL logic that involve data extraction from heterogeneous sources like CSV, Excel, SQL Server, and Oracle
• Built number of Very Complex reports/presentations using Crystal Reports and SSRS with desired rendering formats like PDF, Excel, Visio and CSV to present statistical reports/graphs/ Dash boards according to business requirements.
• Handled the DBA activities on various Data Warehousing and reporting environments.
• Remotely supported and developed number of reports and processes for various CSU’s in PeopleSoft area.
• Gathered requirements and coordinated with various teams to assure satisfactory data content, quality, data integrity and receipt of desired information.
• Created stored procedures, functions, triggers, views and User defined functions for implementing business logic. Also did performance tuning and optimization as per the need.
• Created multiple types of reports from SSRS including drill down, drill through, linked, and sub reports.
• Created Cubes in SQL-Server BIDS and deployed in SSAS. Developed Ad-hoc reporting using ReportBuilder 2.0/3.0 and XL as per the business needs.

Principal Consultant/ Executive

Confidential, Westminster CA

Responsibilities:

• Involved in developing proposals and won the CSU CMS MSA’s continuously with chancellor’s office and won number of individual projects with number of CSU campuses including Chancellor’s office around 10 years.
• Worked very closely with CMS Project Directors, BMS Project Directors and CMS Project sponsors.
• Managed and trained number of consultants mainly on Reporting projects using SQR/SQL, Crystal Reports, N-Vision, SSIS, SSAS and SSRS
• Built number of Very Complex reports/presentations using SSRS with desired rendering formats like PDF, Excel and CSV to present statistical reports/graphs/ Dash boards according to business requirements.
• Developed database objects stored procedures, DTS packages for the Claims processing system for BlueShield of CA.
• Worked with CSU Fullerton on number of PeopleSoft, MS SQL Server, Oracle technology-based Projects mainly using SQR/SQL, Crystal Reports, N-Vision.
• Involved in developing Accounts payable solution and integrated with PeopleSoft 8.4 Accounts Payables module.
• Deep understanding and exposure on PeopleSoft, SQL Server, Oracle, ECM, Java and .Net platform based products, frameworks, solutions and projects using onsite and offshore models
• Managed and worked with BMS at Chancellor’s office on number of PeopleSoft, Oracle and main frame development and administrative projects.
• Worked on number of CSU Fresno onsite and remote PeopleSoft/Oracle and Financial Projects using SQR, SSRS 2008, Crystal and nVision reports. Responsible for delivering the projects to campus, managing the consultants work and coordinate with functional and technical people at the CSU.
• Worked for PeopleSoft Corporation and developed Number of the complex reports and processes in Student Records and Academic Advisement and Student Financials. Reports were developed using various PeopleSoft reporting tools like SQR, Crystal and was developed in platform and Database independent and involved in system, regression and integration testing.
• Worked for Southern California Edison and developed very complex SQR reports, Stored Procedures on Sybase and VB environment.
• Worked with Pacific Mutual Insurance Co and developed and fixed very complex SQR reports on UNIX and Oracle environment.