Alok · Data Engineer · 13.4+ yrs
PrincipalAbout Alok
Alok has extensive experience in managing end-to-end BI projects, leading cross-functional teams, and collaborating with stakeholders to deliver actionable insights. His expertise spans various industries, including finance, insurance, and retail, where he has successfully implemented data solutions that optimize performance and enhance decision-making. Alok is skilled in utilizing a range of technologies to transform complex data into compelling visualizations.
Core expertise
Additional skills(11)
SnowflakeWhy 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.
13.4+ years of industry experience
- •One View application— SSESSAS · Business Objects · SSRS
- •Treasury Vision— SSE/OLAP ModelerSSAS
- •Geneva Data Warehouse— SSESSAS · SSIS · SSRS
- •Treasury Vision— SSE/OLAP ModelerSSAS
- •EUS Analytic Services Data Warehouse— SESSAS · SQL
- •Treasury Vision— SSE/OLAP ModelerSSAS
- •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. Billed in USD.
Typically responds within 4 business hours.
Top Skills
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