Shrikanth Premkumar

• Coordinated with stakeholders to ensure alignment of proposed solutions with business objectives.
• Participated in client meetings to discuss project requirements and provide feedback on potential solutions.
• Developed strategies for ensuring successful deployment of new solutions into production environments.
• Collaborated with project teams to ensure that all technical requirements were met during the software development life cycle.
• Developed a architectural design from data ingestion , data transformation to the end reporting layer. Instructed and assisted the team to use ADF for any raw data ingestion from different data source and use Databricks Medallion Architecture (Bronze, Silver and Gold layers ) for the Data transformation and finally use Power BI for reporting.
• Created detailed design documents that outlined system architecture, security measures, data models and integration points with other systems.
• Analyzed existing systems and identified gaps between current system capabilities and customer requirements.
• Managed multiple projects simultaneously while ensuring quality assurance standards were met throughout the process.
• Identified opportunities for improving existing processes, systems or applications.
• Provided technical guidance to other team members in the development of solutions.
• Advised on project costs, concepts or design changes.

• Prepared Architectural design, developed and optimized Data-Rich Power BI dashboards
• Constructed compelling data-driven narratives that facilitate key business decisions.
• Integrated existing data sources with Power BI, including but not limited to Azure Synapse, Databricks and SQL Server.
• Managed the development, production, and delivery of high-quality management information reports to support Operational reporting needs both internally and externally, including to customers
• Understood the data modeling particularly as it relates to the creation of visual representations of our data set to effectively relay information to our end users.
• Identified the gaps in current Business Analytics processes and provide solutions to close those gaps.
• Established trust with project stakeholders demanding high service level standards
• Ensured all reporting responsibilities and processes are properly documented and all reporting materials produced are subject to appropriate controls prior to distribution

• Responsible to create Global Campaign Analytics reports & dashboards in Power Bi for the Vaccine and Medical department and provide technical guidance to the team by articulating the requirement and provide support whenever there are any obstacles in moving forward with the project
• Provided various granular level insights on Reach, Awareness, Call to Action, Engagement, Impact metrics at campaign, country, and channel levels.
• Created many measures/KPIs using DAX formulas to identify the engagement level in the Social media platform and channels (Website, Facebook, YouTube, Instagram) like Total Clicks, Impressions, TV Reach, Print reach.
• Incorporated and plugged the measures in a suitable visual which can provide quick insights to the business users to identify the areas of improvements and take decisions accordingly.
• Created various reports in such a way that allows the end users to filter at various dimensions and compare the Key KPIs across all the campaigns.
• Analyzed the reports and dashboard created by another vendor using internal Performance Analyzer tool and external tools like DAX studio, Tabular editor and suggested various best practices that could optimize the performance of the report.
• Automated the source of the existing dashboards from local drive excel workbook to the Azure Synapse Analytics and then connected Power BI to Azure Synapse and schedule the data refresh automatically and eradicated the manual process that is being followed every month.
• Guided the team in the right direction on (1) when to use calculated column vs measures (2) when to use import vs direct query mode (3) encouraged the team to create shared dataset for a set of reports coming from a common business unit/domain (4) create date dimension tables using data flows and use in all of the reports that uses Time intelligence KPIs.

• Migrated Cognos and Crystal reports across multiple credit and lending applications for a US bank to Business Intelligence Reporting Tool (BIRT) an Open source software to improve report performance as well as to manage their budget.
• Developed Reports in Business Intelligence and Reporting Tool and deployed the .rptdesign files to the server
• Involved in all phases of SDLC including design, coding, reviews, testing & documentation.
• Troubleshooted and fixed issues with existing reports, created Sub Reports and drill-through reports as per customer needs and involved in developing Template Based Reports using BIRT report designer and Publishing Reports to the server.
• Responsible for creating Drill Through reports, Sub reports, Templates based reports and charts such as Pie, Bar, Gantt according to the business requirement using BIRT Report Designer.
• Responsible for query optimization in all the BIRT reports across applications to reduce the query run time.
• Responsible for the enhancements those were eventually made to the reports due to business requirement alterations.
• Created Cascading, Multi-select Parameter and Static and Dynamic Filter as per Business needs.
• Debugging, testing, and enhancing the reports which were showing false or incorrect data
• Responsible for creating the technical documentation to include business requirement, functional specifications, test plans and protocols, test cases/scripts, traceability matrices and validation reports.

• Migrated Cognos reports in the Mortgage and HELOC domain for a US bank to Tableau software to improve report performance as well as to manage their budget.
  • Develop Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Connected to data sources like IBM DB2 database and Flat files from Tableau and model the data using the Relationships, Joins & Union mechanism.
  • Designed data model from scratch to aid team in data collection to be used for Tableau visuals
  • Created calculated fields & measures as per report requirements.
  • Format the Visuals in the dashboard using number of available options in Tableau.
  • Using parameter, dynamically displayed the columns/data in the dashboard based on user selection of columns in the parameter list. This approach has directly reduce number of visuals in the dashboard.
  • Using Tableau reader, opened the workbooks and ensured all the reports are working as expected.
  • Publish the Tableau workbook to the Tableau server and ensured that all the users have required license to access the reports.
  • Configured Row Level security in the Tableau server for all the reports to ensure that users access the reports corresponding to their cost centers.
  • Conducted presentations to the business for each of report and ensured that they are all satisfied with the report design and structure. Performed the necessary modifications in the dashboard or report based on the busines feedback during the demos.
  • Documented each of the business logic for all the individuals reports and included in the shared repository for future reference.
  • Created a Job Aid on how to share the Dashboard in the Tableau server and how the email subscription works and ensured that all business users are aware of this feature.

• Handled a team of 22 support analysts. Monitoring their daily response, resolution and Quality parameters are met.
• Performed regular maintenance and application monitoring activities including daily, weekly, monthly, or any other regular or ad-hoc monitoring.
• Responsible for loading, testing, and maintaining courses/content and learning tracks in LMS and LCMS.
• Worked closely with cross-functional teams for LMS applications.
• Worked in conjunction with Subject Matter Experts and vendors to develop curriculum for courses.
• Responsible for creating, modifying, and enhancing a diverse array of courses for the purpose of improving the performance of individuals and groups with an enterprise focus.
• Responsible for building positive relationships with a wide variety of partners, vendors, and customers.
• Demonstrated success in supporting, monitoring, and managing the work of several support analysts and/or vendor partners, each of whom is responsible for multiple concurrent, quick turnaround projects involving different groups or departments.
• Develops, communicates, gain acceptances and implements innovative approaches to resolving training challenges.
• Make sure that the team members resolve the tickets within the response SLA and resolution SLA for each of the tickets on a daily basis.
• Ensuring best practices and automation are implemented every quarter inorder to reduce the manual tasks and streamline the support.
• Communicating with Senior Support Analyst in each of the 3 shifts across 24*7 support to identify any risks proactively and work together to mitigate it.

Involved in the migration of more than 10,000 eLearning courses and Learner History data from Legacy LMS Systems – SABA, MELS, ISOTrain LMS to SuccessFactors LMS which is now Sucessfactors LMS for a US based pharmaceutical company.
• As part of the migration, was involved in requirement gathering, analyzing the existing customizations from Legacy LMS systems to plateau LMS in its compliant format.
• Involved in the deeper analysis of the non-SCORM/non-AICC compliant courses and prepared the SCORM Framework Requirements document based on the patterns identified.
• Integrated plateau report designer to their existing learning platform for generating custom reports.
• Developed reports using Plateau Report Designer (BIRT) and SAP Business Objects based on given requirements, worked on Analyzing, designing, developing, testing, and deploying BIRT Reports, worked on integration of BIRT to Learning Management System.
• Worked on integration of BIRT to Learning Management System (LMS).
• Created complex reports in BIRT and deployed in the Learning Management System for the business users to access and run the report at any time.
• Translated business requirements into system specifications and comprehensive design documents including process flow chart.
• Troubleshooted and fixed issues with existing reports, created Sub Reports and drilled reports as per customer needs.
• Developed SCORM/AICC courses using eLearning authoring tools like Articulate Presenter & Storyline. Implemented interactions, quizzes and published it according to the client requirements.
• As a Senior Support LMS Analyst was responsible for managing the training needs and overall support activities.