Alok · Lead Power BI / Data Engineer · 13.4+ yrs
PrincipalBuilt for
About Alok
Alok is a Business Intelligence Specialist with 17+ years of experience in designing and implementing data warehousing and business intelligence solutions. He has a strong focus on tools like Power BI, SQL, and Azure, driving insightful decision-making through advanced data visualization.
13.4+ years of commercial experience in
Skills(12)
Why hire Alok?
Led architectural design and end-to-end development of Power BI solutions for multiple clients.
Managed teams and conducted code reviews to ensure quality delivery.
Implemented data loading solutions using SSIS and Informatica from diverse data sources.
Optimized SSAS Olap Cubes for various BI and data warehousing systems.
Developed complex reports using SSRS with advanced features.
Architected Qlik Applications + NPrint reports end-to-end
Power BI architect design + dev for multiple clients
SSAS Cube + tabular model development across multiple projects
Project highlights(9)
EPAW Analytics – Manager/Lead
Managed EPAW Analytics, a central repository for data from diverse business streams, supporting dashboards, reporting, and SSAS cube development for analytics and business users. Responsibilities included project management and development activities, requirement analysis, and leading a team to track development status, ensuring process adherence and conducting code reviews.
Key outcomes:
Managed a team, including code review and testing to ensure quality development.
Led development of various BI components including SSIS packages, SSAS Cubes, Power BI, and QlikView dashboards.
Western World Insurance BI/DWH System – Project Lead
Developed a BI/DWH system on SQL Server 2008 for a commercial insurance provider, supporting agents and brokers. Responsibilities included tracking development status, engaging with the client for requirement gathering, and managing project development.
Key outcomes:
Led client interaction for requirement gathering and technical specification.
Developed SSAS Olap Cubes and SSRS reports for the insurance BI system.
Hyundai Accessory Reporting and Tracking System (HARTS Data Mart) – Project Lead
- Designed the HARTS Data Mart to provide customers with better control and easy access to accessory information, utilizing a snowflake schema for dimensional modeling to emulate analytical functionality.
- Project utilized MicroStrategy for reporting and Informatica 8.6.1 for data loading from diverse sources like Oracle and SQL.
- Tracked development status within the team.
- Designed the Datamart using snowflake schema and data flow for loading data via Informatica 8.6.1.
- Developed various reports and QlikView dashboards and data models.
Key outcomes:
Designed Datamart with snowflake schema and data flows using Informatica 8.6.1.
Developed QlikView dashboards and reports for the system.
Western world Insurance BI/DWH system – Project Lead
- Developed a BI/DWH system on SQL Server 2008 for a commercial insurance provider, supporting agents and brokers.
- The system was built using SSAS, SSRS, Cognos, and MicroStrategy.
- Tracked development status within the team.
- Engaged with the client for requirement gathering and technical specification design.
- Managed project development, providing regular updates to stakeholders.
- Involved in the development of SSAS Olap Cubes and SSRS reports.
Key outcomes:
Led client interaction for requirement gathering and technical specification.
Developed SSAS Olap Cubes and SSRS reports for the insurance BI system.
Geneva Data Warehouse – SSE
- Supported the Facilities Management (FM) business by managing helpdesks and works on contracts through the Geneva application.
- Mobilized new contracts and performed health checks to ensure timely data processing and updates.
- Coordinated with onshore teams for new Statements of Work (SOW) and provided effort estimates.
- Developed SSAS Olap Cubes and tabular models (Analysis Services 2012).
- Created SSIS packages for data loading from multiple sources and SSRS reports.
Key outcomes:
Developed SSAS Olap Cubes and tabular models, along with SSIS packages for data loading and SSRS reports.
Coordinated with onshore teams and managed new contract mobilization.
Industry experience
FinTech
2 projects- •One View application— SSESSAS · Business Objects · SSRS
- •Treasury Vision— SSE/OLAP ModelerSSAS
Logistics & Supply Chain
3 projects- •Geneva Data Warehouse— SSESSAS · SSIS · SSRS
- •Treasury Vision— SSE/OLAP ModelerSSAS
- •EUS Analytic Services Data Warehouse— SESSAS · SQL
SaaS / B2B
1 project- •Treasury Vision— SSE/OLAP ModelerSSAS
Automotive
8 projects- •EPAW Analytics— Manager/LeadPower BI · SSIS · SSAS · SQL
- •Western World Insurance BI/DWH System— Project LeadSQL · SSAS · SSRS
- •Hyundai Accessory Reporting and Tracking System (HARTS Data Mart)— Project LeadInformatica · MicroStrategy · Snowflake · QlikView +1
- •Western world Insurance BI/DWH system— Project LeadSQL · SSAS · SSRS · Cognos +1
- •Geneva Data Warehouse— SSESSAS · SSIS · SSRS
- •One View application— SSESSAS · Business Objects · SSRS
- •Treasury Vision— SSE/OLAP ModelerSSAS
- •EUS Analytic Services Data Warehouse— SESSAS · SQL
At a Glance
Single contract. No agency markup confusion.
Typically responds within 4 business hours.
Vetted by WitaristNot sure if this is the right fit?
Tell us your requirements and we'll match you with the best candidates.
Alok
Lead/Manager Power BI