Uploaded File
Prasadh
prasadh.kailat@gmail.com
734-635-8588
4216 Crownwood Dr,
Marietta, GA 30064
Business Intelligence Developer
9 years experience W2
0
Recommendations
Average rating
308
Profile views
Summary

Experience
BI Programmer Analyst
Information Technology
Jan 2017 - present

Detroit Public Schools Community District (DPSCD) is a school district that covers the city of Detroit, MI consisting of over 100 K-12 schools. The Division of Technology & Information Services caters to administrative and IT functions which governs the overall functions of the school system.

  • Work with the business users to gather and understand reporting requirements.
  • Document the requirements and create technical specifications based on the business requirements and reporting needs.
  • Responsible for software development life cycle (SDLC) including requirement gathering, requirement analysis, design, development, implementation and testing.
  • Agile development methodology is used for all development initiatives.
  • Create user stories, define tasks, provide effort estimation for each work assigned.
  • Understand the technical & functional specifications, develop the physical layer, business logic layer, presentation layer and user interface for addressing reporting needs.
  • Responsible for development of SSIS Packages to perform ETL functions that fetches data from heterogenous data sources (Excel, Text, CSV files, staging area tables), transforms data as per requirements and loads data into a MS SQL Server Datawarehouse on a scheduled basis.
  • Write SQL / T-SQL queries for data retrieval and data manipulation.
  • Responsible for performance tuning of SQL queries.
  • Using MS SQL Server Data Tools (SSDT 2015), develop SSAS Tabular cubes containing necessary measures and calculated columns using DAX / MDX serving as an analytical layer.
  • Use Power BI Desktop to connect to SSAS cubes (live connection) or directly to database tables (Direct Query Mode) or to flat file sources (Import mode). Design reports based on business requirements. Deploy the reports to Power BI Service Workspaces to create Dashboards for consumption by end users.
  • Automate such BI solutions using MS SQL Server Agent to populate data on a defined schedule.
  • Analyze SQL Server execution plans, table structures to resolve performance issues.
  • Provide post-implementation, application maintenance and enhancement support for the product / software application.
Business Requirements Data Warehousing SQL Server ETL SSIS Agile Methodology Requirements Gathering Requirement Analysis Technical Specifications T-SQL SSAS CUbe SSAS SQL MS Power BI Performance Tuning MDX Database Maintenance Analysis Microsoft Excel
Remove Skill
Business Intelligence Developer
Information Technology
Sep 2014 - Dec 2016
  • Designed data marts - (Star and Snowflake schemas) for Maximum Miniatures Inc., a company that sells painted figurines.
  • Performed ETL (Extract, Transform, Load) using SSIS packages to load data marts with data extracted from heterogeneous data sources.
  • Designed Multi-Dimensional OLAP cubes for analyzing Manufacturing, Inventory and Sales Fact tables.
  • Defined key performance indicators (KPIs) to measure company performance against pre-defined goals.
  • Performed data mining to discover patterns in Customer and Sales data using different mining algorithms like Naive Bayes, Neural Networks, Clustering, Classification and Association Analysis.
  • Interviewed the stakeholders and conducted meetings with business users to gather requirements for UltimaCNCParts - an ecommerce company which sells automobile parts.
  • Designed business process flow and functional requirements for streamlining development of a BI solution.
  • Designed Entity-Relationship Diagram (ERD) for database design and implementation.
  • Developed the OLTP database and performed ETL using SSIS package to extract data from source systems and load the transactional SQL Server Database.
  • Worked with business users to validate the data in the transactional database.
  • Created and deployed parameterized reports and charts for reporting and quick data analysis.
  • Developed reports and dashboards using Power BI to facilitate informed decision making.
  • Worked at the EMU CIS Department to develop close to 500 SSRS reports including tabular, matrix, chart, drill down, drill through, stepped reports, sub-reports, linked reports, parameterized and cascading reports.
  • Analyzed web metrics to develop marketing strategies for four different e-commerce businesses to increase lead generation. Optimized marketing campaigns and product listings for targeting potential customers.
  • Developed Windows Form applications which can calculate GPA, restaurant bill, estimate cost for a cake factory, track weather and track students registered for a course using object-oriented programming (C#).

Environment: MS SQL Server 2012, SSMS 2012, SQL Server Data Tools (SSRS / SSIS / SSAS), MS Power BI Desktop, MS Visual Studio 2012, Google Analytics

SQL Data Marts SQL Server ETL SSIS SSRS Business Intelligence Requirements Gathering Database Design Data Mining SSMS OLTP C# OLAP Visual Studio Google Analytics BI Developer MS Power BI Snowflake Analytics Clustering Analysis Neural Networks Data Analysis Windows
Remove Skill
Programmer Analyst
Information Technology
Jan 2012 - Aug 2014
  • Played a vital role in maintaining global regulatory compliance by triaging, analyzing, capturing patient- drug safety data into Enterprise Database using company's front end applications.
  • Conducted thorough data analysis to develop executive reports and dashboards which enabled the steering team make fact-based strategic decisions leading to a $3 million increase in revenue in 2012.
  • Developed modules for training and mentoring associates which led to a 50% reduction in new recruit on- boarding time.
  • Formally recognized for commitment to work excellence evidenced by timely delivery of high-quality project deliverables on a consistent basis with a great focus on customer satisfaction.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, T-SQL, SSMS 2008.

T-SQL SSMS SQL Server SQL Data Analysis Compliance SSIS SSRS Analysis Microsoft Excel
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Information Systems MSIS
Eastern Michigan University 2016
Bachelor's in Science
University of Mumbai, 2007 - 2011
Certifications
Microsoft: Microsoft Dynamics Student Certificate * Online: Programming with C#, Python and Excel fo
Oracle: Oracle Business Intelligence Suite 11g Certified Implementation Specialist
Certificate of appreciation for outstanding work at TCS October 2013
Skills
Analysis
2021
5
Microsoft Excel
2021
5
SQL
2021
5
SQL Server
2021
5
SSIS
2021
5
Data Analysis
2016
4
SSMS
2016
4
SSRS
2016
4
ETL
2021
3
MS Power BI
2021
3
Requirements Gathering
2021
3
T-SQL
2021
3
Analytics
2016
2
BI Developer
2016
2
Business Intelligence
2016
2
C#
2016
2
Clustering
2016
2
Compliance
2014
2
Data Marts
2016
2
Data Mining
2016
2
Database Design
2016
2
Google Analytics
2016
2
Neural Networks
2016
2
OLAP
2016
2
OLTP
2016
2
Snowflake
2016
2
Visual Studio
2016
2
Windows
2016
2
Agile Methodology
2021
1
Business Requirements
2021
1
Data Warehousing
2021
1
Database Maintenance
2021
1
MDX
2021
1
Performance Tuning
2021
1
Requirement Analysis
2021
1
SSAS
2021
1
SSAS CUbe
2021
1
Technical Specifications
2021
1