Development Analyst Business
Resume:
Sindhuja Ramineni
Business Intelligence, Data and Solutions
Architect
********.*********@*****.***
USA, Denver
linkedin.com/in/sindhuja-ramineni
github.com/raminens
Motivated individual who is able to work under tight schedules and deadlines. Always striving for a better version of myself. WORK EXPERIENCE
07/2019 – Present
Business Intelligence, Data and Solutions Architect Public Trust Advisors-LLC
Denver/USA
Creates Power BI Dashboards, visualizations and reports using the Monthly data, transactions data which helps in progression of all the Sales Managers and PTA Teams.
Working with 3rd party consultants like IVP to design Data warehouse, ETL Data pipelines, Data integration, EDM, Data governance structure and Reporting.
Creates design workflows for all applications using Visio tool. Creates Microsoft flows, which is helpful in tracking the important outlook mails and attachments into an excel.
Works with several teams to do monthly and quarterly financial reporting and visualizations with the help of Datawatch, Excel, Macros, VBA and Power BI tools.
Develops service now applications - CRM, CIS, Sales Event management, Speaker requests that helped in strategic decision 10/2018 – 05/2019
Business Systems Analyst - Intern
Public Trust Advisors - LLC
Worked on DataWatch Prep studio and DataWatch Monarch to create rules and procedures for the daily update of CRM Sales dashboard. Created join statements, rules and expressions. Built CRM and Conference Portal Applications in Service now. Cretaed Service portal, widgets, visualizations, dashboards, reports, notifications, Maps and Reports
Used VLOOKUP, Indirect and direct statements to pull data from different excel files and calculated the fund summary and visualized using pivot tables and charts.
04/2015 – 08/2017
Application Development Analyst
ACCENTURE-(Credit Suisse Project)
Bangalore, India
Developed KPIs using data visualization, statistical analysis techniques and Agile-Scrum methodologies.
Used Devops tools like Teamcity, Nolio, JIRA, Service Now to deploy, upgrade and refresh environments.
Developed Scripts in UNIX and Python that alerts to improve stability of environments.
Extracted relevant information about how user interacts with database using Python scripts and tectia hosts.
Automated the manual refresh, upgrade activities using robotic blue prism and splunk technologies.
Trained new employees on several workflows of the project and worked on developing scripts.
Using Tableau and SQL to create daily status tracking that maintains the codes deployed on all the environments. EDUCATION
08/2017 – 05/2019
Masters in Information Systems - Business
Intelligence
University of Colorado Denver
GPA - 3.9/4.0
Data Warehousing, DBMS,
BI in finance modelling,
ITPM, Securing and
Protecting Assests
Stats in Business Analytics,
BI in health care,Business
Intelligence and Analytics
ACHIEVEMENTS
Client Appreciation Award - Excellence in Business Operations Got the award for converting all environments DB to VLDB's and client operations Excellence Award - Accenture Innovation Celebration Automation of Python scripts and maintaining stability among the environments. PERSONAL PROJECTS
Stats in Business Analytics (R, EXCEL-PHSTATS, TABLEAU) Predicted world-wide university rankings using R, Excel and Tableau. Analyzed and visualized the data using R exploratory analysis, data modifications. Correlation of results were conducted to build best model, cross validated the results for accuracy and predicted the future values. Predicted the sales performance analytics of employers using detailed statistical tests like ANOVA, VIF, Step wise regression method. Data Warehousing (PENTAHO, SQL, Oracle 11g)
Analyzed and Integrated data using the concept of schema diagrams in Pentaho software. Created revenue and sales analysis reports for various regions using sub-total and cube operators in Oracle-SQL. Performed data cleaning and ETL operations on stream data.
Database Management ( MS Access, Postgre SQL)
Designed a database for a restaurant depicting the menu card, items, client analysis, employee analysis using SQL and ACCESS. Developed interactive dashboard through FORMS tool IN MS-Access for better visualization . Business in Analytical Systems (SAS, Microstrategy) Transformed data using Wrangling scripts and developed a dashboard to monitor KPIs (Revenue, monthly sales, target) to identify variance in performance using SAS Analytics and MicroStrategy. Business Intelligence in Finance Modelling (Power BI, Excel) Analyzed food product sales, revenue and profits for 3 consecutive years using linear forecasting and moving averages techniques. Created a dashboard using Power BI tool to show their profit, revenue, sales. PROJECT MANAGEMENT (Project Libre, Visio)
Planned a project schedule for 'recycling waste and producing electricity' using project libre software. Planning includes time, cost, risk, resource, portfolio, procurement and investment management. Designed workflow using visio tool.
Contact this candidate