Sameera Guttula
Business Intelligence Developer at Quadax, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Quadax, Inc.
-
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
-
-
-
The Davey Tree Expert Company
-
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
-
-
-
The University of Akron
-
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.
-
-
-
NTT DATA Services
-
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 -
BV Raju Institute of Technology
Bachelor of Technology (B.Tech.), Electronics and Communications Engineering