Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ravishankar Ramanan

Danbury,CT

Summary

  • Accomplished Senior Business Systems Analyst with a proven track record at The Hartford, enhancing data-driven decision-making through expert analysis and Business Intelligence tools like SAP Business Objects and Snowflake. Skilled in requirements gathering and business analysis, I spearheaded initiatives that resulted in a 10% performance improvement, demonstrating a strong blend of technical proficiency and strategic insight.
  • Highly skilled Senior Business Systems Analyst with broad experience in identifying and resolving complex system issues. Strengths include, but are not limited to, strategic planning, project management, and process improvement. Notable impacts made in previous roles include streamlining workflows for increased efficiency and implementing innovative solutions to enhance overall business performance.
  • Technical Architect with 17+ years of success in conceptualizing technical solutions and system development environments. Focused on working closely with clients to determine technical project objectives, specifications, and solutions. Detail-oriented in coding and testing the functionality of deliverables
  • Technical Architect with 17 + years of success in conceptualizing technical solutions and system development environments. Focused on working closely with clients to determine technical project
  • objectives, specifications, and solutions. Detail-oriented in coding and testing the functionality of deliverables
  • Over 15+ years of experience in data analytics, driving BI roadmap, architecting, data acquisition and visualization
  • Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
  • Motivated and results-driven Data Analyst with proven track record in data analytics and process
  • mapping. Identifies business needs and develops valuable solutions to improve accuracy and process optimization. Drives business success with recommendations based on data findings.
  • • Business and Data Analyst with expertise in analysis and testing of business requirements. Drives deployment of applications, business processes and system solutions to successful outcomes. Highly analytical and detailed with documented track record in full software development life cycle completion.
  • Collaborating and aligning with various stakeholders both internally and externally to drive the actionable data inside
  • Extensive experience in various Reporting tools, data visualization tools and databases
  • Rich experience in architecting self-service analytics
  • Experience in leading distributed team and onsite-offshore coordination
  • Have extensive knowledge in installation, Configuration and Administration of Reporting tools
  • Experience in Information Technology having strong programming skills, database design, Application Development

Overview

17
17
years of professional experience

Work History

Senior Business Systems Analyst

The Hartford
Danbury, USA
01.2021 - Current
  • Collecting, collating, and carrying out complex data analysis in support of management & customer requests for the legacy source systems
  • Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality
  • Analyzed large amounts of data to identify trends and find patterns, signals, and hidden stories within data
  • Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action
  • Mapped current business and operational processes and recommended areas for improvement
  • Involved in the complete software development lifecycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems
  • Analyzed raw data, drawing conclusions & developed recommendations with the mapping document for the legacy source system to be ingested into EDW
  • Created complex stored procedures, CTE, temp table, SQL joins, ranking functions, and dynamic SQL
  • Responsible for performing T-SQL tuning and optimizing queries which takes longer time in execution with SQL server 2016
  • Collect and maintain a planning and execution profile for each task
  • Created SSIS packages to import and extract data from various sources such as flat file, SQL server, Snowflake data lake and loaded to an Enterprise data warehouse (EDW)
  • Used various control flow and data flow tasks from the toolbox
  • Performed error handing and version log using event handler
  • Involved in troubleshooting SSIS packages and migration procedures
  • Interact with customer to constantly seek out the methods to better handle data and increase system efficiency by writing more complex and optimized queries, changing the way data is stored or structured, or bringing data onto a new server that can better meet the needs of the organization
  • Manage production release of developed and tested code to production environment
  • Perform detailed analysis of the complex/critical issues reported on production during data load and provide solution to these issues
  • Interact with offshore technical teams, instruct, and explain the requirement, technical designs and mapping document for speedy development and testing of integration and reporting services

Technical Architect

Lincoln Financial Group
Greensboro, USA
05.2017 - 12.2021
  • Company Overview: AMS Project
  • Met with clients to gather and understand requirements and coordinated with system administrators and directors to plan and schedule project activities
  • Provided leadership and support for IT department
  • Analyzed project-related information and made recommendations based on discoveries
  • Developed suggestions for technical process improvements to optimize resources
  • Platform owners for maintenance of Prod and Non-Prod Business Objects/Tableau/Power BI Servers of 4 environments (Enterprise, RPS, AIS Term, Genesys)
  • Support Web Application servers related to Business Objects/Tableau/Power BI (WebSphere, WebLogic, Tomcat)
  • Patching and Upgrades in Prod & Non-Prod Servers
  • Migration of SAP BO 4.1 SP7 to BO 4.2 SP8 - Reduced around 10% in license cost by proactive monitoring
  • Implemented SAP BO & Tableau Migration projects
  • Enterprise architect for all Reporting/Analytics tools (Business Objects/Tableau/Power BI)
  • Design and solution architect new project from a deployment and content security standpoint
  • Business Objects/Tableau/Power BI License tracking (Prod & Non-Prod) (Servers, Named, CPU & Concurrent licenses)
  • Daily backup of the BO FRS and CMS and restore (if needed)
  • Weekly backup of AUDIT DB and restore (if needed)
  • Default Auditing, 360 Suite (360 View, 360 Plus, 360 Bind & 360 Eyes) and Sherlock (3rd party tools) to generate Audit metrics out of CMC for Usage analysis
  • Work with SAP tech support on resolving SAP BO product/development related issues Act as Infrastructure partners to the Project teams
  • Act as point of contact for the auditing team insights sighs as HIPAA, SOX, etc
  • AMS Project

Technical Lead

Alliant Credit Union
Chicago, USA
02.2014 - 04.2017
  • Company Overview: DW & BI Modernization
  • Developed and provided technical solutions for day-to-day operations and longrange strategic planning of scheduling and finance system for users
  • Responsible for requirement gathering and analysis, profiling source data, building ETL data pipeline and visualization
  • Collaborated with business stakeholders and external vendors for source data collection, building metrics, KPIs and data validation
  • Developed self-serving dashboards in a consistently iterative manner that provided high level KPI/metrics for senior management, providing better insight of the data and process, which resulted in 10% increase in performance improvement and 5% increase in revenue
  • Exhibit customer centric visualization for metrics generated that resulted in 15% increase in adoption of the dashboards
  • Building subject area mart and applying business logic using advanced SQL
  • Built data validation standards for the team that increased the accuracy of the data insight for the entire analytics team
  • DW & BI Modernization

Module Lead

Imperial Tobacco Group
Chennai, India
07.2012 - 01.2014
  • Company Overview: Russia BI Project
  • Compiled and maintained variety of departmental documentation including logbooks, run reports, training records, reports of suspected arson, violations of fire codes or ordinances, firefighter timesheets, accident reports, and 'close call' reporting
  • Played the role of a customer facing BI lead responsible for the design, development, and deployment
  • Involved from the definition phase right up to the realization/implementation and stabilization of the BI systems for multiple customers
  • Studied the legacy system and Responsible to design and implement the SAP Business Objects solutions in BOXI
  • Exhibit customer centric visualization for metrics generated that resulted in 30% increase in adoption of the dashboards
  • Have knowledge on Client tools such as BO Explorer and Live office
  • Have knowledge in Installing SAP BO at server level
  • Interact with different touch point teams at onsite mainly to collect the business requirement and create the requirement document
  • Involved in Review of the code developed by the team
  • Experience in Information Technology having strong programming skills, database design and Application Development
  • Creation and modification of existing universe, addition of objects / filters in the universe
  • Conversion of Report Specification based on the functional specification
  • Development of BO Reports based on the report specification
  • Validating developed reports with the data
  • Analyzing and fixing of bugs raised
  • Designed Master-Detail, crosstab reports for analysis purpose
  • Used SQL Scripts for Unit testing of Reports
  • Russia BI Project

Module Lead

Girl Scouts
Chennai, India
01.2011 - 06.2012
  • Company Overview: Enterprise Datawarehouse Support Module
  • Experience in Information Technology having strong programming skills, database design and Application Development
  • Performed system study and Interacted with the Business users and business analysts to identify and develop business requirements and transform them into technical requirements
  • Created Semantic Layer (Universe) Documentation for the Girl Scouts Business
  • Design of high valued business decision reports as per the functional specifications
  • Worked for getting the Report Specifications for reporting purposes
  • Worked on Production Support for the Existing System
  • Played a key role in testing of the reports with respect to accuracy in various modes - Universe, Web Intelligence and at the Database end
  • Upgraded from BOXIR4.0 to BOXIR4.1 - 10 % increase in Revenue post the migration and cleaning up the environment
  • Used PL/SQL developer to run PL/SQL & SQL queries and validated the data pulled in reports
  • Created Daily Status Report to be sent to Client side
  • Enterprise Datawarehouse Support Module

Senior Software Engineer

Panasonic
Chennai, India
07.2010 - 12.2010
  • Company Overview: BO Reports Migration
  • Played the role of BI Senior Developer responsible for the design, development and Support Experience in Information Technology having strong programming skills, database design and Application Development
  • Discussed project progress with customers, collected feedback on different stages and directly addressed concerns
  • Creation and modification of existing universe, addition of objects / filters in the universe
  • Conversion of Report Specification based on the functional specification
  • Development of BO Reports based on the report specification
  • Validating developed reports with the data
  • Analyzing and fixing of bugs raised
  • Designed Master-Detail, crosstab reports for analysis purpose
  • Used SQL Scripts for Unit testing of Reports
  • Evaluated project requirements and specifications and developed software applications that surpassed client expectations
  • Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications
  • Converted Crystal Reports to Web Intelligence reporting bringing around 20% increase in revenue
  • Upgraded from BOXIR2 to BOXIR3.1 - 30 % increase in adoption of the Webi intelligence reporting
  • BO Reports Migration

Programmer Analyst

Healthnet
Chennai, India
02.2009 - 06.2010
  • Company Overview: Analytics
  • Played the role of BI Senior Developer responsible for the design, development and Support Experience in Information Technology having strong programming skills, database design and Application Development
  • Performed system study and Interacted with the Business users and business analysts to identify and develop business requirements and transform them into technical requirements
  • Good experience in Business Objects Installation, Deployment and good exposure in Business Objects Administration
  • Design and Development of the Universe in Business Objects based on Business requirements Have knowledge on Client tools such as BO Live office
  • Have knowledge in Installing SAP BO at System level Preparation of various technical and functional documents
  • Conversion of Report Specification based on the functional specification
  • Development of BO Reports based on the report specification
  • Validating developed reports with the data
  • Analyzing and fixing of bugs raised
  • Designed Master-Detail, crosstab reports for analysis purpose
  • Developed Prototype using HTML for Claim Sphere
  • Developed User interface screens for Claim Sphere using Java, J2EE and struts
  • Did unit testing for Claim Sphere
  • Customized Java SDK of Business Objects and created a portal for Health Net called Claim Sphere
  • Responsible for documentation of various stages in development including Design, debug, maintenance etc
  • Used PL/SQL developer to run PL/SQL & SQL queries and validated the data pulled in reports
  • Analytics

Programmer Analyst

T-Mobile
Chennai, India
11.2007 - 02.2009
  • Company Overview: BINGO & Mass Market IP Services (MMIPS)
  • Detailed analysis of the requirements to identify the things to be done and to measure the impact of each module on the other
  • Contributed immensely to design and coding Developed POCs
  • Providing the point of contact for Onsite as well as to provide coordination between Onsite and Offshore teams and managed connectivity Issues between Offshore and Onsite through an in-house tool OOT (Offshore Online Tool)
  • As a deployment manager, handled the deployments on multiple servers/environments like Web sphere Process Server (WPS), Web sphere Application Server (WAS)
  • Worked as a System/Core Administrator for all the servers used in the SDP project in all the environments like Integration Testing, System Testing and Production Design of implementation methodology for online environment tool
  • Configuring the servers for a release and maintaining it with the latest fixes as the release proceeds till production and troubleshooting & fixing environment specific defects
  • Development of Online Environment (UI) for the assigned modules
  • BINGO & Mass Market IP Services (MMIPS)

Education

MBA - Information Technology

Anna University
Chennai
08.2010

Bachelor of Engineering - Electrical, Electronics Engineering Technologies

Anna University
Chennai
05.2007

Skills

  • Snowflake
  • Business Data Analysis
  • SAP Business Objects
  • BO Client Tools (Webi, IDT, UDT)
  • Tableau
  • Power BI
  • Crystal Reports/Lumira
  • Informatica
  • Business Objects Data Services
  • Python
  • Java
  • BO Java SDK
  • Oracle/SQL Server
  • Amazon Redshift/PostgreSQL
  • Business Intelligence/Advanced Visualization
  • Requirements gathering
  • Business Analysis
  • Data mapping

Timeline

Senior Business Systems Analyst

The Hartford
01.2021 - Current

Technical Architect

Lincoln Financial Group
05.2017 - 12.2021

Technical Lead

Alliant Credit Union
02.2014 - 04.2017

Module Lead

Imperial Tobacco Group
07.2012 - 01.2014

Module Lead

Girl Scouts
01.2011 - 06.2012

Senior Software Engineer

Panasonic
07.2010 - 12.2010

Programmer Analyst

Healthnet
02.2009 - 06.2010

Programmer Analyst

T-Mobile
11.2007 - 02.2009

MBA - Information Technology

Anna University

Bachelor of Engineering - Electrical, Electronics Engineering Technologies

Anna University

Similar Profiles

CREATE PROFILE
Ravishankar Ramanan