SUMMARY

• Experienced Data Analytics Professional with more than 5 years’ experience in the Financial, Retail, Healthcare, and Supply Chain and Logistics domains.
• Able to quickly learn unfamiliar material, exhibit great attention to detail, execute under aggressive deadlines, and adapt quickly to changing circumstances and systems to maintain the strategic vision of the organization and link it with everyday work.
• Great team player who values collaboration and communication, and possesses a very strong work ethic, and can relate and work efficiently with diverse groups.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, and DCL commands for various business applications OLTP, OLAP (Data warehousing) and AZURE Cloud environments.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Expert at developing ETL interfaces using SSIS, Cubes using SSAS and Enterprise Reports in SSRS, Power BI and Tableau
• Advance Experience in RDBMS concepts such as Tables, Indexes, Functions, CTE’s, triggers, and Stored Procedures
• Extensive experience developing and deploying Tabular SSAS Cubes, SSAS-Data Mining Models, and SSAS objects.
• Excellent analytical/Communication Skills, Team Player and result Oriented Team Lead and Manager.
• Expert understanding of Normalization /De-normalization and database design methodology.
• Proficient in Cloud computing technologies having created and deployed resources in AZURE and AWS

TECHNICAL SKILLS

• SSIS, SSAS, SSRS, Power BI, Tableau, Azure Data factory, T-SQL, MDX, DAX, Python
• Advanced Excel and Office suite
• ETL Development
• SSAS Tabular Data modelling
• Data Mining, Manipulation, Transformation, Analysis and Visualization
• Project Management, Planning, Coaching, and Scheduling
• Agile methodologies (Scrum, Kanban)
• Business Analysis
• Report Development and Analysis (Budgets, actuals)
• Telecommuting and offshore team leadership
• SDLC in Waterfall and Agile environment

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Manager

Responsibilities:

• Lead multiple projects, cross functional teams, and organizational initiatives concurrently.
• Plan, initiate, and manage Business Intelligence (BI) and data analytics projects and programs.
• Direct and coordinate activities of project/program personnel, ensuring that project/department milestones are met, while adhering to approved budgets.
• Manage our BI pipeline program so BI team understands the BI backlog, work in progress, and production release dates and milestones.
• Collaborate closely with various teams and Stakeholders to identify and analyze core requirements and create important metrices and KPIs for reporting.
• Provide technical, administrative, and operational management of assigned projects and tasks, including contract and subcontractor management, while serving as SME on agile principles and the SCRUM framework.
• Led the design and development of a reporting module for a salesforce integration portal for clients of Santander Bank

Business Intelligence Developer

Confidential

Responsibilities:

• Created new database objects like Stored Procedures, Functions, Packages, row and statement level Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012/2016.
• Analyzed, tuned, and optimized SQL Server Applications using performance monitor and SQL Server Profiler.
• Extracted and migrated Data from various heterogeneous sources by creating packages in SSIS
• Performed Data Transformation tasks like Lookups, Fuzzy Lookups, Conditional Splits, Event Handlers, Error Handlers etc.
• Studied existing OLTP system(s) and created facts, dimensions, and star schema representations for OLAP
• Automated processes by creating jobs and error reporting using Alerts and SQL Mail Agent, led the execution of tasks as needed, including: Data Analysis, Modeling, Cleansing, Transformation, Integration, import/ export.
• Worked with BI manager to plan BI strategies, create BI roadmap, and budget plans to deliver on BI needs
• Created tabular models in SSAS and used DAX to create complex dynamic measures and calculated columns per business requirements
• Embedded power BI report in Salesforce portal page and managed role-based user access
• Created easily shareable Power app in Power BI service
• Served as Power BI SME, providing maintenance for bug fixes and development of new reports
• Trained end-users and Technical support staff on Report use and maintenance

Data Analyst

Confidential

Responsibilities:

• Leveraged a basic understanding of multiple data structures and sources
• Maintained and assisted in the development of moderately complex business solutions, which included data, reporting, business intelligence/analytics
• Maintained data dictionary by revising and entering definitions
• Maintained direct, timely and appropriate communication with clients
• Supported data governance, integrity, quality, and audit functions
• Supported the implementation of technical data solutions and standards
• Utilized and prepared analysis reports summarizing Opportunities for Improvements (OFIs)
• Worked closely with other members of the database group