Business Intelligence, Analytics, Project Management

Radha Devi

Trumbull, CT ***** 203-***-****

www.linkedin.com/in/radha-devi ad5nck@r.postjobfree.com

Business Intelligence/Analytics and Data Management Leader

Deliver Actionable Insights that Improve Quality and Performance

Collaborative problem solver with impressive record of accomplishment in architecting and delivering new, high-value and unique solutions to complex business problems spanning 18 years.

Proficient in Project Management, design, implementation, maintenance and administration of secure metadata, Data Management, enterprise business intelligence production environments and data warehouse. Enthusiastic, results-driven mentor who successfully guides teams by demonstrating personal proficiency in tasks to be performed.

Project Management Requirements Gathering Technical Leadership Data Cleansing, Modelling & Data Visualization Process Improvement Architectural Best Practices

Technical Skills

BI Tools:

MicroStrategy, Power BI, Tableau,IBM Cognos Analytics, Cognos BI tools (Dashboards, Report Studio, Analysis Studio, Query Studio and Event Studio), Framework Manager, DMR Models, Dynamic Cubes, Data Modules, TM1, MS Excel.

ETL Tools:

SSIS, WhereScape, Data Junction

Databases:

RedShift, Teradata, DB2, Oracle, MS SQL Server

Data Modelling Tools:

Rational Rose, Erwin, MS Visio, Microsoft Visual Studio

DB Tools:

SQL-A, SQL*Plus, SQL Navigator,

Database Admin:

Oracle Database Administration, SQL Server Administration

Programming Languages:

Advanced SQL, PL/SQL, Python, SAS

Project Management:

SDLC, SCRUM, KANBAN: Tools: Azure DevOps, Microsoft SQL Server Management Studio, GitHub

Professional Experience

Charter Communications (Spectrum), Stamford, CT Aug 2023 – till date

Spectrum maintains 32 million customers by offering trailblazing products and services through TV, Internet, Voice and Mobile mediums.

BI Analyst III

As a lead Analyst in the BI Marketing team - to empower Charter business leaders with concise, high-quality information, helping them leverage it to identify and address business opportunities and threats.

Collaborated with Redshift team to migrate several tables, stored procedures and structures from Teradata to AWS Redshift Database platform.

As an SME helped to deliver critical projects on time to budget by working with cross functional teams to ensure alignment in business needs, timelines and department standards are met.

Maintained Data Quality, Data Integration and managing data elements, data dictionaries in the warehouse at a very detailed grain to support any form of user needs from research to adhoc querying or delivering large information projects.

Orchestrated complex and high visibility Data Analytics projects to Business to derive data driven decisions.

BYRAM HEALTHCARE, White Plains, NY Aug 2018 – Aug 2023

Byram is a leading provider of disposable medical supplies for people managing their chronic health conditions.

Sr. Data Warehouse and Business Intelligence Architect/Project Leader

Involved in leading a team and providing solutions to complex Business problems for Executives, Finance and Accounting, Contracts, Pricing, and Costumer Service departments of the Organization

Worked with Business users from Finance, Customer Service, Accounting and Contracts department to understand requirements. Ensured project requirements are met within scope, identified risks, communicated plans effectively across teams and stakeholders to resolve complex business issues.

Designed mockups and helped in converting the Business requirements to technical specifications, extensively worked on data acquisition integrated it into SQL Server Database for Business Intelligence and Analytical purposes, making SQL Server Database ‘Single Source of Truth’.

Designed and developed easily accessible and high performing BI environment by creating a highly efficient Data model, ETL process, creating aggregate tables, indexed tables and views helped in increasing the efficiency by 90% and reducing manual processes by 100%.

Involved in redesigning several Cognos Reports and Dashboards to Power BI for FP&A Department from inception to execution including refining database models.

Involved in Data Management and reconciliation, continuous process improvement with respect to data cleaning for Analytics.

Managing and mentoring a team of three Developers/Admin. Providing BI support and services to 500+ user community.

UNITED RENTALS, Bridgeport, CT Feb 2014 – Feb 2018

The largest equipment rental company in the world with 997 rental locations in 49 states and every Canadian province

Application Architect, Business Intelligence and Data Warehousing

Partnered with business users, senior management, HR, and technical teams to analyze business requirements, identified reusable components, prepared statement of work (SOW), designed proof-of-concept, developed, and implemented working solutions.

Designed functional specification and workflows, provided support to the developmental team, and helped senior management in visualizations for customer focus and retention trends, fleet management, employee performance and career progression.

Spearheaded and successfully implemented over 1K user metrics used by different departments of organization through re-modelling data warehouse Business layer and delivery of key performance indicator metrics for power users.

Developed and delivered technical solution that enhanced run-time performance of standard BI scorecards and e-mail burst reports by 75% and ad-hoc reports by 100%. Reduced Microsoft Exchange storage space by 50% during e-mail bursts.

Automated security process to configure access control to users / user groups to handle exceptions and realignments, reducing support calls by 50% and increasing team productivity.

Created standard operating procedures for educating team members, increasing knowledge base of support team for better customer support while helping to efficiently manage over 997+ branches and 14.7K+ users in various departments of organization.

Built audit reports as a part of server administration and monitoring, production support to 10,000 users, user issue resolutions, server performance management, license management, version upgrades (installation, configuration, monitoring), multi-server architecture and migrations that reduced number of virtual servers by 87%, which resulted in greater efficiency.

CENTRAL NATIONAL GOTTESMAN INC, Purchase, NY Apr 2012 – Nov 2013

Leading independent worldwide manufacturing and marketing organization in the pulp, paper, and packaging industry.

Senior Cognos Administrator / Developer

Created complete project management solutions, including requirements, data architecture and dimensional modelling for sales, finance, operations excellence, and HR departments. Delivered insights on current performance, trends, and future projections.

Updated and streamlined Cognos report designs and complex reports, enhancing report performance by 90% in the e-commerce environment.

Created data extracts and SQL queries for delivering daily, weekly, and monthly reports. These ETL processes reduced the manual intervention by 100%.

Resolved issues quickly and efficiently by serving as point of contact for root cause analysis, Cognos server administration, migration, and production-related issues.

UNIMIN CORPORATION, New Canaan, CT Oct 2010 – Jan 2012

North America's leading producers of non-metallic industrial minerals and provider of essential raw materials for every industrial process.

Senior BI Programmer / Administrator

Translated business requirements to technical specifications. Designed and developed custom reports and ad-hoc reports per specification from finance department, senior executives, and plant managers. Provided Cognos BI and Cognos Controller day-to-day administration. Maintained SQL server, database tuning and administration.

Performed data mapping and designed SSIS package to extract, transform and load data into desired tables from Navision system to data warehouse system, providing foundation for BI reports used by Senior Vice Presidents, Vice Presidents, sales teams, and plant managers to arrive at key business conclusions.

Maintained database, access control, data validation and database backup.

AON-HEWITT, Norwalk, CT Nov 2006 – Sep 2010

Programmer Analyst Advanced

Scheduled meetings with Business Implementation Manager and end client to create requirements documents, detailed client data analysis, detailed flow diagrams and documentation. Designed test plans (unit, integration, regression, and acceptance) for client projects. Mentored offshore team and reviewed tasks completed by junior members of team.

Created data mapping and generated complex queries for data extracts, building custom and ad-hoc reports as requested by clients and business users using SAS, SQL, DB2, SQL and Crystal Reports

MEGA LIFE HEALTH INSURANCE, Norwalk, CT Apr 2005 – Oct 2006

Senior Database Analyst

Performed data analysis for development projects such as generic load procedures for provider load, knowledge-based search engine and several client data load analysis and data feed analysis procedures to improve quality of service to clients. Developed complex queries using SQL, PL/SQL, stored procedures, and designed reports generation using Crystal Reports for claims and benefits department of organization.

Minimized errors 100% by automating ETL load procedures.

Created documentation that was used by other members of team.

Previous experience includes Averion Inc., Darien Senior Center and Kindle Systems Private limited as Database Programmer, Developer and DBA and Software Analyst, respectively.

Education

Post Graduate Diploma in Data Science and Business Analytics, McCombs School of Business, University of Texas, Austin

Bachelor of Engineering (BE), Dayananda Sagar College of Engineering, Bengaluru, India

(4-year graduate degree)

Certifications

Certified ScrumMaster® (ID: 000765101)

Oracle Certified Internet Applications Developer 6i (ID: I00038297)

Oracle Certified DBA (ID: I00038297)

Microsoft-Certified Solutions Developer VB 6.0 (ID: 2933734)

Microsoft-Certified Solutions Developer VB.NET (ID: 2933734)

Contact this candidate