Sameera Guttula

Business Intelligence Developer at Quadax, Inc.
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Cleveland, Ohio, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Hospitals and Health Care
    • 400 - 500 Employee
    • Business Intelligence Developer
      • Aug 2020 - Present

      Cleveland, Ohio, United States

    • Lead Application Developer
      • Jul 2018 - Aug 2020

      Cleveland/Akron, Ohio Area • Led a division with over 20 clients in the fundraising outbound department o Responsible for creation of daily sales files and call summary analysis for the clients for both inbound and outbound calls using MS Access, MSSQL and SSIS packages o Generation of call efficiency reports, trackers, summary reports, internal and external reports for account staff using SSRS. • Worked on the development of a process to identify the target audience for new direct mail campaign and follow ups… Show more • Led a division with over 20 clients in the fundraising outbound department o Responsible for creation of daily sales files and call summary analysis for the clients for both inbound and outbound calls using MS Access, MSSQL and SSIS packages o Generation of call efficiency reports, trackers, summary reports, internal and external reports for account staff using SSRS. • Worked on the development of a process to identify the target audience for new direct mail campaign and follow ups from their previous response rate by evaluating the outgoing mails and the pieces fulfilled. o Developed automated processes using SSIS packages, stored procedures and SharePoint setup, to match back the fulfillment files from the client with the pledges made during the calls. • Involved in the development of screens for various inbound and outbound clients using VB.net with secure credit card processing, validations, encryptions, call backs and call forwarding. • Development of dashboards using Tableau for daily performance metrics for different call centers. • Provide productivity statistics to Call Center Supervisor and Manager for process improvements.

    • Application Developer
      • Feb 2017 - Jul 2018

      Cleveland/Akron, Ohio Area

    • United States
    • Environmental Services
    • 700 & Above Employee
    • BI Analyst Intern
      • May 2016 - Aug 2016

      Kent,Ohio • Responsible for the creation of an automated process to eliminate the duplicate customer accounts created in CRM, reducing the extra marketing investment. o Involved in gathering the requirements and identifying different criteria to group duplicated accounts to a single consolidated account by assigning new unique ID’s stored in a separate data warehouse, using SSIS packages, Cursors and Stored procedures. o Build QlikView reports for the Marketing Team to visualize the par… Show more • Responsible for the creation of an automated process to eliminate the duplicate customer accounts created in CRM, reducing the extra marketing investment. o Involved in gathering the requirements and identifying different criteria to group duplicated accounts to a single consolidated account by assigning new unique ID’s stored in a separate data warehouse, using SSIS packages, Cursors and Stored procedures. o Build QlikView reports for the Marketing Team to visualize the par performance of the new system and other existing license information. • Worked on Configuration of Cost Centers, Sales Offices and Plants in SAP and SAP security role maintenance. Show less

    • United States
    • Higher Education
    • 700 & Above Employee
    • Technology Support Student Assistant
      • Sep 2015 - May 2016

      The University of Akron • Developing and Maintaining Law web applications using HTML and CSS. • Troubleshooting software issues encountered by Law faculty and students. • Providing hardware support like basic Audio/Video setup.

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Business Intelligence Developer
      • Oct 2013 - Jul 2015

      Hyderabad,India • Worked on a reengineering project to transform the Legacy system with Mainframe data source to a new third party data feed. o Responsible for gathering the business requirements from the end users to get the appropriate transformation from the de-normalized design to a normalized data structure. o Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Marts. o Implemented SSAS Cubes, Facts and Dimension tables to perform… Show more • Worked on a reengineering project to transform the Legacy system with Mainframe data source to a new third party data feed. o Responsible for gathering the business requirements from the end users to get the appropriate transformation from the de-normalized design to a normalized data structure. o Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Marts. o Implemented SSAS Cubes, Facts and Dimension tables to perform analysis. • Developed a Financial Processing Platform to our Insurance client to access multiple Policy, Agent, Fund and Loan level details acquired from Attunity replicate data feed. o Developed complex SQL queries using cursors, views, functions, stored procedures and SSIS packages for analysis and modeling. . o Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS. • Developed dashboards and KPIs for analyzing the client satisfaction levels and team performance metrics using MS Excel (Pivot Tables) and Tableau. Show less

Education

  • The University of Akron
    Masters degree, Information systems Management
    2015 - 2016
  • BV Raju Institute of Technology
    Bachelor of Technology (B.Tech.), Electronics and Communications Engineering
    2009 - 2013

Community

You need to have a working account to view this content. Click here to join now