Senior Insights Specialist Resume Example
Love this resume?Build Your Own Now
SENIOR INSIGHTS SPECIALIST
Professional Summary
- 13+ years of IT experience in analysis, design, development, testing and implementation of client/server applications with sound knowledge in Data warehousing and Business Intelligence systems for HR, Finance and Oil & Gas industries.
- Experienced software professional in Data Modeling, Data Analytics and Data Warehouse.
- Expertise in Microsoft Business Intelligence Tools (SSIS/SSRS/SSAS/Power BI) and T – SQL using SQL Server 2008R2/2012.
- Experience in developing reports using tools like SSRS, Power BI, Tableau, Excel Reporting, SAP BO and Crystal reports.
- Experience in Prototyping, Developing and Supporting inter active Tableau dashboards.
- Experienced in building Power BI Reports and Dashboards using data sources like SSAS, Teradata, SQL Server and SAP HANA.
- Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multidimensional expression (MDX), Perspectives and Roles.
- Expertise in DAX Queries to build Power BI calculated measures and Calculated columns.
- Created complex measures including ranking, KPIs, aggregation by DAX in SSAS cubes according to business requirements.
Work History
Senior Insights Specialist, 12/2018 to 12/2019Advance Auto Parts, Reynoldsburg , OH
- Automated PMO system there by reducing manual intervention and brought down the resources worked on the system from 5 to 1.
- Derived insights for the Leadership teams and Business operating managers.
- Designed the database schema and built the database in SQL Server 2012.
- Used disparate HR data sources like Workday, People Express, NetSuite,Open Air and integrated the data from all these sources.
- Built the Data Extraction (ETL) SSIS packages for Data load and scheduled SQL server agent jobs for weekly data load.
- Rationalized the existing Excel reports and rebuilt them in Tableau.
- Built SSAS Tabular model and created Power pivot reports using DAX.
- Used several DAX functions such as SUMX, MAXX, if, switch, time intelligence, summarize, calculate etc. to create calculated measures and columns for reports.
- Subject matter expert in driving and delivering the project.
Assistant Manager BI, 03/2015 to 11/2018Verizon Communications, Idaho Falls , ID
- Power BI SME for the BI Center of Excellence team.
- Worked with stakeholders and business users on migrating the reports from Tableau to Power BI.
- Conducted user trainings on Power BI using Dashboard in a day suite from Microsoft.
- Supported teams with the technical issues on Power BI.
- Interacted with Microsoft team on bi-weekly basis to go through the good to have feature recommendations from Unilever business teams.
- Published the Power BI monthly newsletter with the release updates for the enterprise and showcasing the new features.
- Worked on several proof of concepts to test the connectivity using different sources, gateway, Row level security features.
- Implemented several DAX functions for various fact calculations as per business needs
- Migrated HR Analytics dashboards from Tableau to Power BI.
- Built Content Packs for the organization.
- Used different sources like SAP HANA, SSAS to build the dashboards.
- Designed Wire-frames and Mockups to present the stakeholders and get sign-off.
- Leveraged HR data from Workday and built Tableau dashboards.
- Created SSIS packages for data extraction,transformation and loading the data to target databases.
- Front End lead in driving/executing the project and delivering the Dashboards/Reports.
- Built the Contingent Worker dashboards in People Soft platform later the organization migrated from People Soft to Workday, handled the migration of dashboards in Tableau.
- Built Semantic data layer
- Built Tabular Model and Multidimensional Cubes.
- Build, Deploy and process Cubes.
- Worked on SSAS Cube enhancements.
- Performance tuning of SSAS cubes.
- Performance evaluation of reports and fine tuning them to meet SLAs by implementing the best practices on backend and front end layer.
- End to End Dashboards design and development
- Designed and built Alteryx models.
- Simplified the old VBA code to accommodate the changes in macro enabled reports for Sustainable projects.
- End to end testing, Peer- review, deployment and post go live support.
BI Lead, 10/2010 to 02/2015Accenture, City , STATE
- Requirement gathering, creating Business Requirements, Business Specifications and Technical specifications documents.
- Kick off the project post sign off by the business.
- Designed and built reports in various reporting tools like SQL Server Reporting services, SAP Business Objects, Crystal and Excel reports.
- Developed Ad-hoc reports like excel reports based out of cube as needed.
- Testing, peer- review, deployment of reports.
- Enhanced SSIS Packages for changing business needs.
- Worked on Incidents and Service Requests from users.
- Trouble shooting the ITSM incidents raised by the client,finding the root cause analysis and resolving them.
- Handled several demonstrations/ walk through for the client.
- Maintaining the the active directories for new user, SLA's/Targets setup.
- Team handling, mentoring the juniors and assisting them to meet the deliverables.
Software Engineer , 01/2007 to 06/2010TESCO, City , STATE
- Built SSIS packages to load the data from the text files into SQL Server tables.
- Developed SQL stored procedures
- Developed SSRS reports and integrated them ASP.NET web pages.
- Prepared Unit test plans and executed the unit testing, peer reviews.
- Detailed documentation on the build.
- Implemented the Recruitment details, Attendance, Shift maintenance ASP.NET pages of the application.
- Built SSRS reports for the application to generate any data load errors report and Shift exceptions.
- Developed the deployment package which is written .cmd, .bat and .vbs etc files for the application which includes installation of hardware, software, activation of hardware and software.
- Code management for the project in Clear Case.
Education
Bachelor of Technology, Electronics And Communications Engineering, 04/2006
JNTU - City
Skills
Databases:
MS SQL Server 2008/2012, MS Access, TEREDATA 12/13, Azure SQL.
SQL Server Tools:
SSMS, Configuration Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor.
ETL-Tools:
DTS, SQL Server Integration Services (SSIS), Alteryx, BCP, Import/Export Wizard.
OLAP - Tools:
SSAS, MS Excel, Tabular Models
Reporting and Analysis Tools:
Tableau 10.5, POWER BI, Report Builder, SSRS, SAP Business Objects, Crystal Reports, Excel reports
Programming:
T-SQL, MDX, DAX, VBA, C# .NET, XML, JSON
Scripting Languages:
D3.JS, PowerShell, VB Script, HTML, Java Script and CSS.
Operating Systems:
Windows 10,7, UNIX.
Application Packages:
MS Office, SharePoint Server 2010, O365.
Data modeling Techniques:
ERD, UML & Data Dictionary
SourceSystems:
NetSuite, Workday, PeopleSoft, PEX (People Express), OpenAir
Framework:
.Net 2.0, ETL Framework 4.0
Web Server:
IIS 6.0
Project Methodologies:
Agile, Waterfall
Project Tracking Tools:
JIRA, Clear Case, ITSM
Version Control:
TFS 2012, SVN
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Formatting
- Word choice
- Length
- Measurable results
- Strong summary
- Typos
Resume Overview
School Attended
- JNTU
Job Titles Held:
- Senior Insights Specialist
- Assistant Manager BI
- BI Lead
- Software Engineer
Degrees
- Bachelor of Technology , Electronics And Communications Engineering 04/2006
Similar Resumes
