Data Science Power Bi

Dan Kakulawaram

Cell: 714-***-**** & Email: ********@*****.***

Summary of Experience:

Senior BI Consultant, Architect, Reporting expert, Administrator, and Implementer with more than 28+ years of experience at emerging international corporations including in the areas of Business Intelligence, Data Warehousing, reporting, Data Analytics, Data science, Bigdata, Cloud, ERP, and Internet technologies.

Good understanding various industries including Higher-Ed, Insurance, Healthcare, Utilities, Entertainment, Financial, warehousing, Real estate, Auto, Aerospace and hi-tech areas.

Expert in Data Analytics/reporting/BI/ETL/ELT/Data Science solutions and has more than 22 years of experience in using various reporting tools like SSRS, SSIS, SSAS, Power BI Enterprise, Power BI Report Builder, MDX, SQR, SAP Crystal Reports, DOMO, XML-Publisher, N-Vision, GitHub, Tableau, DAX, DBT, Snowflake, AZURE Analysis Services, Azure SQL, Amazon S3, Jira, ServiceNow and Oracle.

Expert in using Microsoft BI suite has more than 15 years of experience in using Power BI, Power Platform, SQL-Server 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 (Azure Synapse, Azure Data Factory and Azure Databricks, Fabric), Data Science, AI, WhereScape RED, MDM and Bigdata Technologies.

Evaluated various BI tools and suggested which BI tool will be a best fit for the customers’ needs, can work with new BI 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, Data Governance, Data management 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/BI tools and technologies.

Worked with PeopleSoft Corporation and developed number of original SQR’s for PeopleSoft Student Admin 7.x product.

Involved and worked with various California State University’s CSU CMS PeopleSoft project since its inception.

Managed teams for BI, DW, SharePoint, ECM, and Reporting projects.

Qualifications:

MS in Computer Science from University of Detroit Mercy, Detroit in 1993

Two Years Post Graduate Diploma courses in Inventory & Supply Management, Marketing & Sales management from Bharatiya Vidhya Bhavan, Hyderabad India in 1989-90

BS in Electronics and Communication from CBIT (Osmania University), Hyderabad India in 1986

Certificate course in Financial Modeling and Valuation from Investment Banking institute in 2010.

Relevant Experience:

Sr. BI/Data Consultant

Carmel Partners, San Francisco CA Oct 2024 to Present

Carmel Partners is one of the nation’s leading multifamily real estate specialists with expertise in the investment, development and construction of exceptional communities

Involved in the design, build, configure, and Visualization of Operational Data on Microsoft Platform utilizing various tools and systems including PowerBI Desktop, PowerBI Service, Microsoft SQL Server Database, pivot tables, Analysis Services Cubes, DAX queries and functions.

Involved in Visualization of complex data will be delivered on Microsoft Fabric, Power BI Desktop, Power BI Service, Dataflow Gen2, AI, Chat GPT, CoPilot and Mobile platforms

Provided recommendation on best-practices when needed.

Building Analysis services reporting models connecting data sources, importing data, and transforming data for Business intelligence.

Architected, designed, and developed/enhanced very complex reports/dashboards involving multiple business areas of multifamily real estate company Carmel Partners.

Modify/Create/maintain and optimize ETL processes using SSIS. Create Data extraction and Import programs using SSIS.

Responsible for Administration of Power BI Service workspaces, Apps, Subscriptions, User access, Mobile Access and gateways.

Involved in nightly load/refresh into the Datawarehouse from various sources AWS, Yardi into the Data Warehouse and followed by refreshing in Power BI Server and Service

Develop SSRS Reports and dashboards using Microsoft Reporting Services platform (SSRS), Microsoft SQL, MS Excel, pivot tables and other tools Analysis Services Cubes and relational databases

Sr. BI/Data Consultant

Dava Cana, Inc., Cypress CA Feb 2024 to Sep 2024

DAVA CANA is a non-profit 501(c)(3) organization whose mission is to create a global platform for providing medical access to remote and underserved populations around the world.

Involved in Visualization of complex data will be delivered on Microsoft Fabric, Power BI Desktop, Power BI Service, Dataflow Gen2.

Designed and developed number Power BI reports using data from Excel and other third-party data sources.

Provided recommendations on best practices when needed.

Visualization of data will be delivered on Power BI Desktop/Service and Mobile platforms

Trained the users as needed.

Sr. BI/Data Consultant

Rocketlab USA, Inc., Long Beach CA Dec 2022 to Jan 2024

RocketLab is an end-to-end space company including satellite design & manufacture, space software, reliable launch services, spacecraft, satellite components and on-orbit management. Headquartered in Long Beach, California, Rocket Lab operates facilities including advanced manufacturing and mission operations centers in Virginia, New Mexico, Colorado, Maryland, Toronto and New Zealand.

Worked closely with various teams across the company in identifying business issues, gathering the requirements, and providing the robust BI solutions.

Globally Responsible to Architect, design, develop, maintain, administration and support of reporting, dashboarding, Data Warehouses using various Microsoft tools including but not limited to Power BI Desktop, Power BI Service, SQL Server 2019, SharePoint, LN ERP, MS Azure SQL, SSIS, SSRS.

Architected, designed, and developed/enhanced very complex reports/dashboards involving multiple business areas including but not limited to Production, Manufacturing, Spaces Systems, Finance, Supply chain, Payroll, Engineering, HR and managers Self-service.

Developed/enhanced very complex Stored Procedures, DAX, CTE’s, Views, Power BI Modeling, Dataflow Gen1/Gen2, Bookmarks, RLS, customized Apps, Drill Trough, Drill Down, Visualizations in providing robust business solutions using Microsoft BI tools.

Coordinated with BI Development by offshore (New Zealand) team members and ensure timely delivery of complex BI solutions to business.

Involved in Agile/Kanban software development, Jira, Git, testing and responsible for maintaining development/test/production BI related code. Also Involved in development and implementation Data Governance and Data management across the organization.

Involved in evaluating various cloud platforms including but not limited to Azure Synapse, Fabric, Databricks services, AI, Gen AI, Chat GPT, WhereScape RED and snowflake.

Worked closely with Data Engineering team in administrating and Maintaining Power BI service environment including but not limited to Deployment pipelines, Power Automate, Apps, workspaces, gateways, refresh issues.

Worked closely with Data Engineering team on production data related issues, Python data load issues, SQL job issues and external/internal Data architecting & load issues for BI Data Warehouse.

Trained the users and other developers as needed.

Sr. BI/Data Consultant

Veritas Investments, Inc., San Francisco CA Feb 2021 to Dec 2022

Veritas Investments, Inc. is a technology-enabled real estate investment and management company that specializes in sustainably operating mixed-use multifamily properties in major West Coast markets.

Responsible for all databases and data applications across the company’s divisions for Data Warehousing and Business Intelligence.

Globally Responsible to Architect, design, develop, maintain, administration and support of reporting, dashboarding, Data Warehouses using various Microsoft tools including but not limited to Power BI Server (2022), Power BI Service, SSRS, SSIS, SSAS Tabular Model, Visual Studio, Tabular Editor, Dax Studio, Salesforce, ArcGIS StoryMaps, Yardi, AWS, and Funnel

Extensively involved in design and development of complex Power BI Dashboards (Server/Service) and SSRS Paginated reports.

Used Service Now and Remedy tool for change management and created change tasks for the implementation and used incident management to work on the tickets.

Extensively used DAX, Bookmarks, customized Apps, Drill Trough, Drill Down, Visualizations in development of complex dashboards using Power BI.

Power BI Dashboards and SSRS reports are consumed by the users from Power BI Service, Power BI Report Server and Salesforce. Responsible to maintain the data consistency across all the 3 platforms.

Responsible for Administration of Power BI Service workspaces, Apps, Subscriptions, User access, Mobile Access and gateways.

Responsible nightly load into the Datawarehouse from various sources AWS, Yardi, Smartsheet’s into the Data Warehouse and followed by refreshing in Power BI Server and Service.

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.

Sr. BI/Data Consultant

PIMCO, Newport Beach CA Feb 2020 to Dec 2020

PIMCO manages investments and develops solutions across the full spectrum of asset classes, strategies and vehicles including fixed income, equities, commodities, asset allocation, ETFs, hedge funds, and private equity. PIMCO is one of the largest investment managers, actively managing more than $1.78 trillion in assets for central banks, sovereign wealth funds, pension funds, corporations, foundations and endowments, and individual investors around the world.

Responsible to Architect, design, develop, maintain, administration and support of reporting, dashboarding, Data Warehouses using PowerBI Enterprise, PowerBI Report Builder Oracle, Snowflake, Data Build Tool (DBT), Amazon S3, Airflow, GIT and MS SQL Server.

Responsible for design and develop semantic layer and user-friendly views in Oracle for the consumption Power bi development team working with ETL/ELT Teams, business analysts and the stake holders.

Responsible for design and develop semantic layer and user-friendly tables, views in Snowflake using DBT and Airflow orchestration/pipelines for the consumption of PowerBI Enterprise development team working with ETL Team, business analysts and the stake holders.

We used Niagara Framework (Oracle->S3->Snowflake) to bring the data into Snowflake and DBT will transform the data with the help of Airflow orchestration. We developed Data Lineage and Data Catalog by Integrating DBT, Gitlab CI/CD and Niagara Framework to help the developers and Analysts. Worked on development and implementation Data Governance and Data management across the organization.

Developed power BI Reports, Reference models and docs for development teams, Business analysts, stake holders and guide them as needed on issues of Power BI Enterprise, Power BI Desktop, Power BI Report Builder, enterprise level architectural, DAX and security issues.

Involved in Agile/Kanban/lean software development, Jira, Git, testing and responsible for maintaining development/beta/production BI related code.

Work closely with EDW team to get the data from various databases and sources as needed by business.

Sr. BI/Data Consultant

WME Agency, Beverley Hills CA Apr 2019 to Jan 2020

Formed in 1898, William Morris Agency (www.wmeagency.com/endeavorco.com) is the longest-running talent agency. In 2009, WMA merged with Endeavor to become one of the leading entertainment and media companies with an unparalleled list of artists and content creators. In 2014, WME acquired IMG, the global leader in sports, events, media and fashion, forming Endeavor.

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 Analysis Services, 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

Sr. BI/Data Consultant

Parker Hannifin, Irvine CA Oct 2018 to Mar 2019

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.

Sr. BI Developer/Administrator

Kofax Inc., Irvine CA June 14 – Sept 18

Kofax is a leading supplier of software and solutions to automate and digitally transform human and information intensive processes across front and back office operations. Kofax 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, .Net, C#, SAP, Oracle NetSuite, Boomi, Salesforce, ServiceNow, 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.

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/Data Consultant

PlutusTek Inc., Cypress CA Jan 12 to June 14

As a Sr. BI 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 pioneered (hair drug testing analysis company since 1986) 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. (REALTOR.COM®) 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 Data Consultant - InfoNidhi, Inc., Cypress CA Oct 08 to Dec 11

Worked with various customers and partners globally on onsite and offshore projects in number of different environments.

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 - MITS, Inc., Westminster CA

June 96 to Oct 08

As a principal consultant worked on number of Client projects onsite, offsite and offshore projects with California State University, IBM, PeopleSoft, BlueShield of CA, United Health, Corinthian College, LADWP, Genpact, Corinthian colleges, M&T Bank, Southern California Edison, Pacific Mutual Insurance and Farmers insurance in number of different environments and different roles.

Involved in developing proposals and won the CSU CMS MSA’s continuously with chancellor’s office and won number of individual projects (Finance, HR, Payroll, Benefits, Pensions and campus solutions) 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 Epic and Claims processing systems for BlueShield of CA.

Involved in integration of FileNet ECM data into SQL server Data Warehouse and developed reports using SSRS.

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.

Consultant – Pittsburgh Business Consultants, PA Jan 94 to May 96

Worked with MSA and led the reporting team of Broadcast and Cable media system. Involved in Very complex reports using SQR in Oracle and VB Environment.

Worked with Alpha and Omega developed number of reports using SQR and Oracle reports in an UNIX environment.

Contact this candidate