Sql Server Data
Resume:
DANAM KAMPATIBE
Houston, TX *****
ac2akv@r.postjobfree.com
Profile
Data Analyst/Business Intelligence Developer with 7 years of extensive experience in Microsoft, SQL, SAS technologies; worked for various projects in every phase of Data Analytics Life Cycle, from business requirement gathering to project delivery. Excellent analytical, communication, interpersonal and decision-making skills and is well motivated to rapidly acquire new skills on the job.
Skills Summary
MS SQL Server, SQL Server Integration Services (SSIS), SSRS, SSAS, Data Transformation Services MS SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS),SQL, T-SQL, Oracle PL/SQL, MS Visual Studio, MS Access, HTML,XML, JQL, SAS, SAP Business Objects,TFS, Source Safe.
Education/ Certifications
University of Nebraska - Omaha
BA in Mathematics 2011
SOA Exams
Probability (Exam P), Financial Mathematics (Exam FM)
Professional Experience
AIG Houston, TX November 2016 - August 2017
Business Analyst / (SSMS, SSRS, SSIS, SSAS, SAP, Oracle, Sybase)
Created DDL scripts to create database schema and database objects.
Responsible to extract data from staging (Staging Raw), applying complex transformation and finally loading to Data warehouse after creating Dimensional and Fact tables.
Deploy SSIS Package into Production and used Variables to export various package properties to make package environment independent.
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
Created/Updated database objects like tables, views, stored procedures, function, packages.
Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
Involved in creating dynamic reports using SSRS for the monthly connections and details of all locations, generated report models using report builder for the Actuarial end users.
Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement.
Extensively used SQL Server Reporting Services 2008 with relational and multidimensional data.
Created and designed OLAP cubes and wrote MDX queries for calculating cube data using SQL Server 2005 Analysis Services (SSAS) and developed drilldown reports using (SSRS).
Data mine and extract fuzzy data from Oracle 11g sources for Experience Studies
First National Bank, Omaha, NE November 2015 - November2016
Reporting Analyst II / (SAS, SSMS, DB2, SSRS,SAP Business Objects)
Performed Data dumps using SAS commands to create Development, Test, Production environments for newly initiated projects from the Mainframe
Independently initiate, conduct, and manage complex credit risk, Customer care projects, including project design, data collection, analysis, summarization, presentation of result and recommendations
Lead implementation of new and modified strategies by working with cross functional areas to ensure successful implementation
Track campaign performance and identify opportunities in products offers and rewards
Utilize various benchmark studies to identify gaps in risk and product, develop new opportunities
Examines/evaluates purpose and content of business reports to develop new, or improve existing, format, use and control.
Complete ad-hoc analytical report request on an as-needed basis from JIRA tickets
Knowledge with ACAPS system
CSG International - Omaha, NE June 2013 – November 2015
Business Intelligence Developer / (SSMS, SSRS, SSIS, Business Objects )
Create numerous simple to complex stored procedures, queries involving large Data for business requirements for external clients including Comcast, Charter, Dish etc.
Create and maintain Key performance metrics, Dashboards, Heat Map for internal customers such as CSG Call center, Human Resources, Financial Services, etc.
Create packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources
Provide Training and documentation for end users on how to create Ad-hoc reports and quick Data extract.
Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler
Perform functional testing and assist in User Acceptance Testing to ensure developed solution meet the business requirements in accordance with quality standards
Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server
Develop reports or queries to retrieve and analyze data for projects/programs requiring sophisticated inferential techniques.
Created databases to track project management to help with managing contractor's projects, hours and billing. Also created numerous SSRS reports to implement on the web for various business groups
Awards and Activities
University of Nebraska-Omaha, Math club member
Mathematics tutor – Burke high school from 2010-2011 in Omaha NE
Volunteer works
oVolunteer monthly at the Siena Francis homeless shelter
oJaycees volunteer for the 2011 annual COX classic Golf tournament
oHabitat for Humanity for INROADS
Contact this candidate