Sivakumar Ramu

Created and automated data visualizations to present insights and tell compelling stories.

• Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
• Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
• Leveraged text, charts and graphs to communicate findings in understandable format.
• Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
• Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms.
• Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
• Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
• Interpreted business questions and collaborated with engineering teams to identify data sources.
• Utilized data visualization techniques to present and explain complex data sets.
• Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
• Designed and developed data pipelines to acquire, clean and process data.
• 'Managed approximately 80 source feeds., Data warehouse Integrations, Generated 200 plus reports.

• Worked with Claims and reporting area to launch "Data Quality Framework" automated solution for review of suspicious transactions, leading to 60% reduction in questionable transactions.
• Managed, collaborated with ten-member development team, (project management) and engaged with $5 million projects for core quality management system built on SIERA platform.
• Optimized management roles at all levels, maintained industry standard and facilitated with legal requirements and data requirements and adjusted culture to be more open and productive.
• Translated business requirements into higher conceptual design while ensuring program met performance, usability, deciding source of truth (decision making) and functional requirements.
• Acted as business liaison and assisted business with financial collaboration.
• Analyzed large data sets problem, excelled in ETL data profiling, root case analysis, problem solving, and recommended data solutions.
• Performed data preparation, data exploration design, Model building, Evaluation, and Deployment with R, Git Hub and Python.
• Visualized data through BI Tools like Power BI, Micro Strategy, Tableau, SAS and R.
• Sliced and diced different sources with different modeling techniques such as Descriptive, Statistical Analysis and Predictive models.
• Assessed business systems, metrics and processes, identifying areas for improvement to support future growth, recommended best algorithm, identifies trends, and process improvement.
• Built, managed repository about data, Metadata, and documented (SOP)Standard operating procedure for each line of business.
• Resolved conflicts and negotiated agreements between parties in order to reach win-win solutions to disagreements and misunderstandings.
• Expertise in data modeling and analyzing complex and large source data-sets.
• Out shined business expertise in Insurance, Banking and Healthcare Industry.
• Developed claims roadmap, participated in frames, pricing techniques and business development.
• Influenced teams with excellent verbal communications skills and coordinated remote/ offshore teams with excellent written communications.
• Presented concerns, ideas, and areas of improvement to stakeholders.
• Exhibited unique Business Insight (business issues) and analytics skills and saved financial losses to sponsors (cost effective).
• Analyzing Business requirement specifications and identifying source data and transformations that needs to be applied in process of moving data to target database.

• Experience in Agile and Waterfall Methodologies. Experience in all phases of software development life cycle (SDLC), including analysis, design, develop, testing (Integrated and unit), and implementing applications.
• Excellent business knowledge & working experience in Software Testing Life Cycle, including requirement analysis, test planning, test case development, test execution, test reporting sign off.
• Outperformed in working with Business, Creation of Test Plan and Test Strategy documents concerning business requirement document (BRD/SRD).
• Self-motivated individual, and managed complex projects.
• Formulated, defined, and documented system specifications and Developed SQL queries to obtain complex data (data acquisition) from tables in remote(cloud) database.
• Implemented data warehousing techniques, Star / Snowflake schema, ETL, Fact and Dimensions tables, physical and logical data modeling OLAP, and Report delivery methodologies.
• Developed, and created workflows to extract, transform and load in parallel in multiple complex data sets using Data Stage, Informatica.
• Proficient in Data Warehouse testing using various Databases like Teradata SQL, Microsoft SQL Server, DB2 &Oracle, and ETL technologies.
• Experience in creating hierarchy and relational databases. Performed ETL design, modeling, created mapping document.
• Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance and functionality.
• Exhibited leadership skills and always passionate with work.
• Synthesized current business intelligence data to produce reports and polished presentations highlighting findings and recommending changes.
• Institutional and professional (Product), members( customer management), provider ( Distribution) and dental and pharmacy claims Dental teams
• Examined in strategic thinking, Critical and analytical reasoning.
• Validated (CMS) Submission, DHS submission and Pharmacy benefit management (PBM) in government neighborhood.
• Experienced Value-based program/product such as ACA Submission, Find a doctor.
• Experience in data manipulation with data tools to copy from one environment to another environments.