VIKRAM SHARMA
Technical Specialist BI
Summary
Experienced professional with a strong foundation in data analysis, data modeling, and the software development life cycle (SDLC). Proficient in utilizing tools like PowerBI and PowerBI Report Builder for impactful data visualization. Skilled in working with Azure SQL, T-SQL, and MSBI, leveraging this expertise to develop robust solutions. Adept in data modeling techniques including dimensional and relational approaches such as star-schema and snowflake schema modeling, as well as managing fact and dimension tables. Proven track record in process enhancement, normalization/de-normalization strategies, and adeptly handling data extraction, cleansing, and manipulation tasks. Demonstrated familiarity with essential database components like views, indexes, joins, and partitioning, contributing to efficient query performance. Continuously striving for process optimization, with a keen eye for refining processes and improving overall data quality.
Overview
9
9
years of professional experience
3
3
Certifications
Work History
Technical specialist, BI
Hydro BS India Pvt Ltd.
12.2023 - Current
- Work SSIS/SSRS packages based on assigned user stories
- Communicate with Business partners, get the requirements and deliver on agreed timelines
- Develop and/or Fix PowerBI reports based on the requests
- Work on tickets by following SLAs
- Develop and maintain BI solutions using the Microsoft technology stack
- Work with departmental stakeholders to gather requirements, design data models, and develop solutions that meet their business needs
- Analyze business data to identify trends, insights, and opportunities, and present findings in a clear and actionable manner
- Develop and maintain data pipelines, data warehousing, and ETL processes
- Design, develop, and maintain Tabular models for efficient querying and data analysis
- Stay up-to-date with the latest Microsoft BI features and best practices, and implement them as appropriate
- Collaborate with other IT teams to ensure the stability, security, and scalability of our Microsoft BI infrastructure
- Lead BI initiatives and provide technical leadership to drive the development and implementation of BI solutions
- Ensure to work in compliance with Hydro Quality system, HSE regulations, policies and standardized operating procedures
- Perform all other tasks upon the instructions of the superior in charge which may be necessitated by the operations of the related unit and which do not conflict with any applicable laws, statutory provisions, and company rules
- Compliance with area-specific customer requirements.
Programmer Analyst
Dotsquares Technologies India Pvt. Ltd.
01.2021 - 12.2023
- Developed intricate optimized queries, scripts, tables, views, stored procedures, functions, and triggers to provide robust backend support for application development
- Executed ETL processes and generated data reports using Power BI, effectively transforming raw data into actionable insights
- Designed and implemented data cleansing strategies, ensuring data accuracy and integrity throughout the systems
- Expertly performed data mapping exercises, facilitating seamless data integration between various sources and destinations
- Employed diverse chart types, graphs, and data grids to visually represent information sourced from data streams, enhancing data comprehension
- Crafted insightful reports containing carefully chosen measurements and dimensions, tailored to meet specific data analysis requirements.
Data Analyst
Nlineaxis Pvt Ltd
09.2019 - 02.2020
- Gathered data from primary and secondary sources, ensuring the acquisition of accurate and relevant information while also maintaining and updating databases
- Employed data filtering and cleaning techniques, meticulously reviewing computer-generated reports, printouts, and performance indicators
- This process aimed to identify and rectify any underlying code issues
- Collaborated closely with management to ascertain and prioritize both business and information-related needs, ensuring alignment with organizational goals
- Successfully executed incremental data migration tasks using efficient ETL tools, contributing to the seamless integration of new data into existing systems
- Proactively identified and defined opportunities for process enhancement, continuously seeking ways to improve data quality and operational efficiency
- Collaborated with senior team members to implement effective T-SQL queries, harnessing the power of SQL for data retrieval, manipulation, and analysis.
Associate IT (Database Developer)
Jewel alliance network Pvt ltd.
08.2018 - 03.2019
- Spearheaded end-to-end development, maintenance, and support of hosted web applications at Gemporia INDIA
- Leveraged MS SQL Server 2012 for proficient database development, ensuring robust data management
- Orchestrated the implementation of key database components including stored procedures, packages, triggers, functions, indexes, while excelling in Performance Tuning and Query Optimization through T-SQL
- Conducted comprehensive Data Analytics and visualization tasks, harnessing the power of Power BI to create insightful tabular reports that facilitated data-driven decision-making.
Trainee Software Engineer
Appcino Technologies Pvt. Ltd.
12.2017 - 04.2018
- Sound knowledge of Appian BPM, experienced with designing complex processes.
Database Developer
Vision Tech Solutions Pvt. Ltd.
08.2016 - 10.2017
- Crafted efficient stored procedures, triggers, and functions utilizing T-SQL for streamlined database operations
- Contributed to crucial aspects of the project, including Database Merging and the meticulous design of components at various levels
- Played an integral role in the overall database design process, ensuring the project's foundation was robust and well-structured.
Data Quality Analyst
Astegic Info soft Pvt. Ltd.
11.2015 - 04.2016
- Actively engaged with Circle Back, contributing to its operational success
- Utilized Excel for efficient ticket management and streamlined project oversight
- Demonstrated proficiency in ticket creation and the meticulous execution of cases
- Applied data refinement techniques, systematically updating Circle Back's existing data by sourcing, and integrating information from online search engines.
Education
B. Tech (IT) -
CompuCom Institute of Information Technology and Management, Jaipur
12th (PCM) - undefined
Disneyland Public Senior Secondary School, Jaipur
10th - undefined
Disneyland Public Senior Secondary School, Jaipur
Skills
Data Modeler
Certification
Azure Data Fundamental (DP-900), H753-2016, 01/01/2020
Languages
Hindi
Bilingual or Proficient (C2)
English
Intermediate (B1)
Personal Information
- Father's Name: Sanjay Sharma
- Mother's Name: Anita Sharma
- Date of Birth: 04/18/1990
- Marital Status: Married
Disclaimer
I hereby declare that above mentioned information is true to the best of my knowledge.
Timeline
Technical specialist, BI
Hydro BS India Pvt Ltd.
12.2023 - Current
Programmer Analyst
Dotsquares Technologies India Pvt. Ltd.
01.2021 - 12.2023
Data Analyst
Nlineaxis Pvt Ltd
09.2019 - 02.2020
Associate IT (Database Developer)
Jewel alliance network Pvt ltd.
08.2018 - 03.2019
Trainee Software Engineer
Appcino Technologies Pvt. Ltd.
12.2017 - 04.2018
Database Developer
Vision Tech Solutions Pvt. Ltd.
08.2016 - 10.2017
Data Quality Analyst
Astegic Info soft Pvt. Ltd.
11.2015 - 04.2016
B. Tech (IT) -
CompuCom Institute of Information Technology and Management, Jaipur
12th (PCM) - undefined
Disneyland Public Senior Secondary School, Jaipur
10th - undefined
Disneyland Public Senior Secondary School, Jaipur
Similar Profiles
Deepak VijayDeepak Vijay
Team Lead (Manager) at Hydro BS India Pvt. Ltd.(Part of Norsk Hydro)Team Lead (Manager) at Hydro BS India Pvt. Ltd.(Part of Norsk Hydro)
Chirag YadavChirag Yadav
Account Executive - Payables and Receivables at Matrix BS India Pvt LTDAccount Executive - Payables and Receivables at Matrix BS India Pvt LTD
Pratiksha SinghPratiksha Singh
HR ADVISOR (PEOPLE RESOURCING) at NORSK HYDRO (SAPA EXTRUSION INDIA PVT. LTD)HR ADVISOR (PEOPLE RESOURCING) at NORSK HYDRO (SAPA EXTRUSION INDIA PVT. LTD)
Nitish JillundraNitish Jillundra
Technical Specialist at CognizantTechnical Specialist at Cognizant
Barbara MastrandreaBarbara Mastrandrea
Senior BI Analyst | BI & DWH Specialist at DG REGIO at FreelanceSenior BI Analyst | BI & DWH Specialist at DG REGIO at Freelance