Sushma Reddy

Sr. Business Intelligence Professional

+1-612-***-****

ad2e8y@r.postjobfree.com

Austin, TX

Visa Status: Green Card

SUMMARY

Strong IT experience with 13+ years of experience in Data architecture, metadata management, data quality or governance and business requirements analysis, application design, developing solutions for the data execution, reporting and metrics. Proficient in analyzing multiple data sources, identification of alternative solutions, designing and assisting projects. Expertise in solving business problems through the creation of advanced reporting and visualization design with the goal to deliver high quality trending and associated data analytics.

KEY SKILLS

Report Development

Data Trending

Dashboard Design and Development

Adhoc Reporting, Product Performance, Breach Reports

Report Validation, Functional and UAT Testing

Process and Project Improvement

Identify root causes and Performance Tuning

Report Schedules/Automation

TECHNICAL SKILLS

•Tools: Spotfire, Business Objects - Interactive Analysis, Web Intelligence, Information Design Tool, Universe Designer, Data Integrator, Design Studio, Live Office, Xcelsius, Crystal Reports, Power BI, Lumira, MS Access Reports, Explorer, Voyager, Tableau, Cognos, JMP, Shiny

•Database: Snowflake, Oracle, SAP HANA, SQL Server, Teradata, DB2, Siebel

•Languages: SQL, XML/HTML/CSS, JavaScript, VB Script

•OS: Windows, Unix and Linux

PROFESSIONAL EXPERIENCE

Medtronic Inc.

Jun '10 – Present

CRM Post-Market Quality (Prin. Quality Engineer)

Tracking and implementing threshold in the Track wise application and monitoring threshold to identify breaches for further investigation.

SME for the entire Product Group, presented Quarterly, Yearly PPR and and provide data necessary to support the CAPA, RPI, IIA and other regulatory, clinical and R&D processes .

Support Reliability group and other management groups with data collection and analysis for PMSR, PSUR and other information related to product performance.

Consult other groups to determine when observed trends should be escalated for additional investigation.

Perform validation activities for Spotfire report Method validations, spreadsheet, BO report and Database Tables.

CAS Trending and Data Analytics (Trending and Data Engineer)

Monitored product performance and identifying signals for further investigation of CAS products.

Worked on analyzing multiple data sources including complaints, sales, service and returned product analysis data using established procedures, analysis tools and ensuring market released CAS products remain safe through the entire product life cycle.

Developed Share point ticket system for the adhoc report requests.

Generated monthly, quarterly, yearly reports and presentation for Product Performance and Breach Reports.

Worked on Spotfire GCH data validations, writing functional specs, test cases, conducting peer reviews and testing the reports.

MITG (Report Writer)

Conversion of all data from legacy Covidien Complaint Tracking System to Medtronic Global Complaint Handling System.

Worked on various CER reports for various business key products.

Worked on Power BI for historical data for various data visualizations.

BI Team (Business Objects Support)

Monitored all the worldwide daily and weekly report distributions and the report distribution time.

Facilitate issue resolution related to business processes, identifying system options, testing scenarios, and supporting knowledge transfer activities.

Helped users in resolving issues for Power BI, Lumira and Tableau reports too.

Identify trends in system issues via Production break ServiceNow tickets and develop actions to minimizing the recurrence either through identifying technical changes needed or providing recommendations for end user training.

PRS – Patient Registration Services (Customer Care)

Worked on Validations, writing functional specs, test cases and testing the reports.

Performed Functional and non-functional testing using Quality Center and developed detail Test Plan and Test Report documents for each report.

Worked closely with the PM’s and ran the queries based on their requirements and sent the excel file of it for them to take some decisions related to business.

Neuro - Business Analyst/Developer

Generating queries for data retrieval and post-processing of data from various databases

Created complex reports which is based off three different data sources.

Integration of data sources to provide ongoing monitoring relative to developed acceptance criteria.

Application of technical knowledge to interpret data analysis results.

Analysis of monitoring trends and collaboration with business partners to establish correlation to product or clinical practice changes.

Creation of custom analysis and reports to communicate overall product performance results to business partners including Quality, Reliability, Clinical and Legal

Leadership of effort to automate of business processes and reports.

Ensure personal understanding and adherence to applicable procedures to ensure quality system compliance and high-quality work.

Involved in developing macros, creating charts, graphs in excel.

Decisions which based on the reports developed by me were submitted to FDA.

Involved in Kaizen meetings which is used for business improvement process.

CRM/CVG (Business Analyst/Developer)

Developing systems and tools to perform complex analysis of product and clinical performance data.

Created custom reports which keeps track of the work progress and the employees.

Used advanced reporting functionalities for creating complex crystal reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Crosstab, graphical, aging reports etc.).

Worked on Spotfire tool to get a detailed level dashboard.

Worked on Validations, writing functional specs, test cases, conducting peer reviews and testing the reports.

APO – Advanced Planning and Optimization (Business Analyst/Developer)

Familiarized the business, its strategy and implementation.

Worked as Business analysts and gathered requirements from the end users and gave estimations of work.

Worked on complete life cycle of the APO project.

Worked actively on modifying Universes and on the performance tuning.

Built reports on top of BEx queries and developed many reports like Forecast Template Reports, Forecast Accuracy Reports, Waterfall Reports, Inventory Management Updates and Pipeline Reports.

Worked with SAP to address the limitations/issues with the integration of BW-BO projects.

Global IT (Business Objects Developer)

Worked on different projects/CRDs and played Business analyst, data analyst, developer role .

Linked two universes using kernel approach.

Developed various complex Webi and Deski reports which involved use of combined queries and sub queries from multiple data providers.

Developed webi reports for CTMS (Clinical Trail Management System) project.

Designed and built reports for KPI’s, AR Aging, Purchasing order, Sales Reports, Cost Analysis, Supply Chain Planning, Financial Focus.

Created Excel-based interactive visual analytics, dynamic charts and groups and business presentations with Crystal Xcelsius.

Worked on Business Objects 4.0 test scripts and in creating POC for the projects.

Worked on new version of tools like Interactive Analysis, Crystal Reports for Enterprise, and Information Layer.

Worked with SAP to address the limitations/issues with the integration of BW-BO projects.

Southern California Edison, Rosemead, CA

Crystal Reports Developer

May '10 – Jun '10

Involved in Report requirements and designed functional specifications.

Migrated & upgraded Crystal Reports 10 and Business Object 6.5 to Crystal Reports XI.

Installed and configured BO xir2 and Crystal Reports XI.

Designed many Stored Procedures in Oracle to improve the performance of report generation.

Schwan, Marshall, MN

Sr Business Objects Xcelsius Developer

Dec '09 – Apr '10

Interacted with business analysts and end users to understand technical and functional requirements.

Involved in the creation of Macros to save the reports as Excel and send them to user’s inbox.

Created critical visualization using Business Objects Crystal Xcelsius 2008 for the Business Dashboard.

Designed Calendar, Metrics, and analytics Dashboard reports.

Build Dashboards using various connections such as Qaaws, web service, SAP NetWeaver BW, xml.

Developed Interactive Dashboards, analytics in Crystal Xcelsius using Live Office.

Created a multi provider and virtual key figures and characteristics to populate fields in the BEx queries and web reports.

Build reports with BEx Query Designer and Web App. Designer and assisted the Portals consultant to publish reports on web.

Supported migration activities of universes & reports into Production environment.

PROJECTS:

WIU

Animated a scene in POV-RAY

Fall 2008

Animated an ocean and boat

Boat moves towards the sun

Final output was a .gif file

Animation robot using OPEN GL

Spring 2008

Animated a robot with moves with user commands and mouse clicks

SMCET, JNTU

Automation of Personnel Management Dec '06 – May '07

Web based application to keep track of details of the employees in the organization.

Designed the database and developed the GUI to access the database.

Technologies : VB.NET, ASP.NET, SQL Server

Intranet Mailing System Feb '06 – May '06

Developed a prototype of a typical mailing system which can work in a local network.

Technologies : J2SE, Oracle 9i

Intranet Messenger Sep '05 – Nov '05

Developed a prototype of a messenger (like Yahoo messenger) which can work in a local network.

Technologies : J2SE, Oracle 9i

EDUCATION & CERTIFICATIONS

Master’s in Computer Science Engineering

Western Illinois University, IL, USA

Aug 2007-Dec 2009

Bachelor of Technology in Computer Science Engineering

Jawaharlal Nehru Technological University, TG, India

Aug 2003-May 2007

SAP Business Objects Certified for Universe 3.1, Web-Intelligence XI 3.1, Crystal Reports 2008 & Xcelsius 2008.

Contact this candidate