Data Analyst Resume Example

Responsible to convert existing legacy Hyperion reports in the Credit & Lending domain of an US bank to Power BI service platform.

Created multiple calculated columns , custom tables using DAX query and published the reports to the Workspaces in Power BI service and performed testing, validation to ensure that the data is accurate and the report design and parameters are working fine as expected.

Analyzed the pros and cons of the ‘Direct Query' & ‘Import' mode and suggested a best approach to the client as per the project requirement\client needs.

Helped the client infrastructure team with the On-premises data gateway server set up to perform the automatic schedule refresh.

Performed a regular demo with the Key users ( Executives, SVPs, CAOs ) and noted down their wish list items and incorporated the changes in the report which was very much appreciated by the customers.

Resolved data security of the reports in Power BI by applying the Row Level Security ( RLS ) such that users get to see the report based on their own cost center\division.

Email scheduling in Power BI service does not work as per client requirement, so worked out different options to cater the needs of the client by providing options which include Microsoft Flow, Dashboard Subscriptions, Organization content packs, 3rd party tools like Power BI report scheduler, Power BI Robots.

Stayed up-to date with the Power BI updates in the Power BI Desktop, Service, Blogs, Forums, Community, Feeds, Announcements..etc and educate the team about the latest updates and its usage.

Migrated Cognos and Crystal reports across multiple credit and lending applications for a US bank to Business Intelligence Reporting Tool an Open source software to improve report performance as well as to manage their budget.

Involved in all phases of SDLC including design, coding, reviews, testing & documentation.

Troubleshooted and fixed issues with existing reports, created Sub Reports and drilled reports as per customer needs and involved in developing Template Based Reports Using BIRT report and Publishing Reports to the Apache tomcat server.

Involved in the migration of more than 10,000 elearning courses and Learner History data from Legacy LMS Systems – SABA, MELS, ISOTrain LMS to Plateau 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 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.

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.

Experience working in several LMS like Sucessfactors, Cornerstone On demand, SABA, Compliance Wire, Sumtotal , ISOTrain to manage the training needs of US,German and UK based pharmaceutical companies.