SUMMARY

• Over 13 years of experience in IT with Business Intelligence/ETL code design & development, and Data Analysis in Production, Development, implementation, Debugging, Testing and Staging Environments.
• Proven track record in implementing technological solutions in a cost - effective manner by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators and partners.
• Good team player with extensive communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Experience working in Agile and Waterfall methodologies in SDLC.
• Knowledgeable in defining the business process flows, gathering business requirements and analyzing user data processing needs to develop/enhance appropriate reporting systems.
• Experienced in technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Strong familiarity with Microsoft Business Intelligence technologies like SSIS, SSAS and SSRS, Power BI & Cognos and other BI tools.
• Expertise in MS SQL Server 2017/2016/ 2014/2012/2008 R/2000/7.0, Full stack of MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis services (SSAS).
• Adept at creating reports, Scorecards, KPIs, and Dashboards in Power BI report server from multiple data sources, test, deploy and administer security.
• Completed ITIL Foundation in IT Service Management Certification, and used some of the best practices in data management and reporting systems.
• Completed Six Sigma Yellow Belt Training, certification and a 5S project towards fulfillment of companywide training requirements.

TECHNICAL SKILLS

Databases: MS SQL server 2017/2016/ 2014/2012/2008 /2000/7.0, Oracle 9i.

Programming Languages: SQL, PL/SQL, Transact- SQL, C.

BI Reporting Tools: Power BI Desktop, Power BI Service, SSRS, SSIS, SSAS, BIDS/SSDT, SQL,Cognos.

OLAP/Reporting Tools: MS Access, Excel, MS SQL Server Reporting Services 2014/2012/2008 R2/2005, Power BI (Basics).

SQL Server Tools: SSMS, Query Analyzer, SQL server profiler, SQL Server Agent.

Data Modeling Tools: Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).

Other Tools: MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio, P4SS(Prophix for SQL Server).

Operating Systems: Windows 10/8/7/XP/Vista, MS-DOS.

Web Development: HTML, XML, and Visual Studio 2015/2017.

Cloud technology: Knowledgeable about Microsoft Azure.

PROFESSIONAL EXPERIENCE

Confidential

Lead BI Analyst

Responsibilities:

• Held discussions with executive and senior management to gather insights and created frameworks to define key KPI’s and architect dashboard reporting in Power BI for use by the teams across the organization.
• Evaluated BI tools like Tableau, Qlikview and Power BI and provided Cost-benefit analysis and recommendations to management on the choice of the right tool resulting in significant savings for the Company.
• Organized and participated in project planning sessions with project managers, business managers and executives to analyze business requirements and outline proposed solutions.
• Worked with Microsoft team on product limitations and communicated limitations and tool capabilities to the stakeholders in the departments.
• Developed business rules for populating dimension tables, fact tables, and Aggregate tables as per requirements and provided input to the DBAs on the ETL processes.
• Created DB Objects, SSAS tabular models and DAX functions for use with the dashboards.
• Created dashboards in Power BI by connecting to various data sources (SQL DB, XLSX, CSV, SSAS Tabular models, Sharepoint) and assigned to Analysts to interact users to finalize, test and publish to the production server.
• Managed refresh schedules, security administration on the servers and troubleshooting issues with data inaccuracies in reports.
• Oversaw the development of user guides and held training sessions for the users to help understand the functionality of the dashboards.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
• Ensured proper documentation of BI systems policies for data security, trouble shooting data inaccuracies and escalation processes as per J-SOX standards.

Environment: Power BI Desktop, Power BI server, Excel, SSRS, SSIS, SSAS, SQL Server 2016, BI Development Studio (BIDS),MS Office, SQL, SSAS, Windows, SharePoint.

Confidential, Basking Ridge, NJ

Lead BI Analyst

Responsibilities:

• Liased with external ERP vendor team to evaluate, create and refine functional requirements for 1000+ Legacy ERP reports in multiple phases to migrate from Legacy platform to SSRS 2008 R2.
• Coordinated meetings with the vendor team and offshore team and provided guidance in data mapping and recreation of existing dimensions and cubes using Star Schema on SQL Server 2012.
• Assisted DBAs in the development of ETL code packages from different data sources and load the data into target data sources by performing different kinds of transformations using SSIS.
• Created and Modified Tables, Stored Procedures, Views, Indexes and User-defined Functions for use in reports.
• Worked with the team to design, develop, test, deploy and maintain various custom and standard reports along with parameterized & cascading parameterized reports as well as drill-through reports that can navigate to other reports or to another URL.
• Set up email subscriptions for reports, scheduled automatic refresh tasks and created AD Groups and administered security on the reporting server.
• Managed change request queues to expedite and resolve production issues related to data inaccuracies using the ChangeGear IT Service Management Tool.
• Created documentation and provided training to end users on the correct usage of the new reports.

Environment: SQL Server 2012, T-SQL, Windows 7, SSDT BI, Visual Studio, SSRS 2012, MS-Visio, Microsoft-Office.

Confidential, Basking Ridge, NJ

BI Analyst

Responsibilities:

• Facilitated meetings with the Finance management team to understand the requirements and prepared a project plan.
• Interacted with the Stakeholders and the DBAs to determine and create dimensions like Zone, Account, Product, Time, Version tables and Sales fact tables for the Star Schema.
• Worked with the DBAs to create Batch and Powershell scripts to synch TIMS 4.0 GL data from ISAM files into SQL Server staging tables for IGG data and load data from staging tables to Fact tables.
• Reviewed source/destination mapping fields with the team and specified data connectors within Prophix for the import process.
• Conducted monthly run of the import jobs and cube processing after monthend close and running reports and troubleshoot issues by coordinating with Prophix support.
• Maintained and administered security for the Prophix users as per requirements from the finance team.

Environment: SQL Server 2008, T-SQL, P4SS 5.0, Windows 7.0, MS-Visio, Microsoft-Office.

Confidential, Basking Ridge, NJ

Principal Datawarehouse Administrator

Responsibilities:

• Actively participated in the meetings with Business Users to gather Technical/functional requirements.
• Created functional requirement specifications and supporting documents.
• Used MS Excel, CSV files as data source and copied data to the target.
• Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers to retrieve the data as per the requirement.
• Designed drill down, sub-reports and ad-hoc reports on a large scale.
• Worked on analysis of data in Power Pivot by connecting to various data sources.
• Deployed reports to production after UAT and administered security for the reports on the servers.

Environment: SQL Server 2008, T-SQL, Windows, Visual Studio, SSRS 2008 R2, MS-Visio, Microsoft-Office.