Resume

Sign in

Software Engineer Sql Server & MSBI

Location:
Alpharetta, Georgia, United States
Posted:
January 31, 2018

Contact this candidate

Resume:

Kiran Karamsetti

(ac4ae4@r.postjobfree.com)

Cell: +1-770-***-****

Summary

I am MCPDEA, MCITP certified, Senior Software Engineer working on Microsoft technologies. Have a good understanding of SQL Server latest Microsoft Business Intelligence tools such as SSIS, SSRS, and SSAS, Tableau, PowerBI, GIS and .Net technologies.

13+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data

Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing

(OLAP)/Business Intelligence (BI) applications.

Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management.

Expertize in architecting MSBI End to End solutions.

Expertize in writing complex stored procedures and dynamic SQL

Extensive knowledge in Tuning SQL queries and improving the query performance.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.

Experienced in SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases

Expertise in implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages and dynamic packages.

Experience in implementing Transactions, Logging, Error files to SSIS Packages.

Worked on performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.

Experience in designing Database Models using MS Visio.

Expertise in generating reports using Crystal Reports 8.0, SQL Server Reporting

Services (SSRS) and Tableau

Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS).

Expertise in developing and extending SSAS cubes, Dimensions, Data source views, SSAS- data mining models including deploying and processing of SSAS objects.

Experience using SQL Server Analysis Services (SSAS) in building OLAP Cubes in SSAS

Created/ Used MDX queries for accessing Cubes and used the data in SSRS reports.

Used SSAS Cubes for creating reports in SSRS and Customized SSAS cubes according the Clients requirement.

Experience in deploying created reports in various sources like Share points, Reporting servers.

Good understanding of Data Warehouse Design aspects like Kimball model, Star-schema, snow flake schema.

Experienced in visualization tools like Power Pivot, Tableau and GIS.

Created reports using different data sources in SSRS and Crystal Reports

Created interactive dashboards using Tableau

Experience working in Waterfall and Agile development methodologies.

Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.

Knowledge on .net framework in various projects.

•Experienced in using C# and VB.NET scripts for various tasks in SSIS.

•Experience in status tracking and bug logging using TFS and JIRA.

•Experience with versioning tools like Microsoft Team Foundation Server(TFS),Visual Source Safe (VSS) for version controlling of the Application.

Excellent business, analytical, user interaction, presentation skills coupled with excellent written, interpersonal and verbal communication skills.

Technical Skills

Microsoft Specific Skills

• SQL Server 2005/2008/2012

• SQL Server Integration Services

• SQL Server Reporting Services

• SQL Server Analysis Services

• ADO.Net

• ASP.Net 2.0

• C#.Net, VB.Net, WCF

• Visual Basic 6.0

• Microsoft Visual Source Safe(VSS)

• TFS(Team Foundation Server)

• Tableau

• GIS using google API

• AngularJS

• JIRA

Other Skills

• C

• Hypertext Markup Language

• Extensible Markup Language

• DTS

• Java Script, VB Script

• Crystal Reports 8.0

• PowerPivot & Power Views

• MongoDB

• MS Visio

•QlikView

•PowerBI

Certifications

Microsoft Certified Solution Developer For Microsoft® Visual C# .NET

Microsoft Certified Professional Developer – Enterprise Applications For Microsoft® Visual C# .NET

Microsoft Certified IT Professional – For Business Intelligence

Accenture DW Certified Resource

Accenture ASDA certified

Educational Qualification:

M.Sc(I.S) from Kakatiya University.

BCA from Kakatiya University.

Intermediate from Board of Intermediate Education.

SSC from SSC board.

Professional Experience:

1) Company Name : Accenture Services Ltd, Hyderabad & Atlanta

Designation : Software Engineering Associate Manager

Duration : Apr 2007 to Till Date

2). Previous Company Name: Digital Group Infotech Pvt.Ltd., Pune

Designation : Software Engineer

Duration : Oct 2006 to Apr 2007

3).Previous Company Name : Hoch Technoloiges Pvt.Ltd., Secunderabad

Designation : Software Engineer

Duration : July 2003 to Sep 2006

Experience

AXIS insurance - Risk Management & Pricing Analytics :

AXIS Insurance’s Risk Management Property unit offers Commercial Property Insurance through appointed retail brokers across the U.S. RiskOps handles all aspects of insurance operations.

Risk Ops is reporting project to address the key reporting needs, helps business analysts to take decision making around relevant business functions. The reporting solution is critical and used by various underwriters in AXIS with the latest data from different sources. Providing details with visualization using Google Maps to analyze the policy details and understand the risk.

Axis support different LOBs/types of insurances internationally and in US region. Provided a solution to manage the all pricing raters data in a centralized data warehouse and make it available to underwriters for future analysis. Report solution provides underwriters with different metrics and implemented different mechanisms like Adhoc reporting, archive process and Audit process etc.

Technologies: SQL Server, SSIS, SSRS and SSAS, Tableau, PowerBI, GIS, .Net, WCF. AngularJS

Duration: May 14 – Till Date

Team Size: 4

Role: BI Architect & Lead developer

Responsibilities:

-Gathering requirements from client

-Propose design solutions and architecting the application

-Involved in Database designing and writing complex queries using dynamic SQL.

-Wrote efficient stored procedures for the optimal performance of the system.

-Implemented complex dynamic SQL stored procedures and called SSIS packages from Stored Procedures

-Improved performance of the SQL procedures, SSIS packages and SSRS reports.

-Creating SSIS packages for pulling data from different sources

-Scheduling the packages to keep extracting the data from various OLTP systems

-Created dynamic SSIS package and reports which works for run time data

-Generated custom and parameterized reports using SSRS

-Created complex SSRS reports involving cascading parameters, Sub Reports, Matrix/Tabular reports and Charts

-Involved in data visualizing using Tableau, creating and deploying tableau reports

-Involved in documenting the tasks/steps and presenting to the team members

-Responsible for end to end development and deployment

-Creating different types of GIS maps using exposure data using Google Maps API

-Created HeatMap, Points, bubble map using google maps API

-Experience in using KML files in Google Maps

-Created WCF services based on user requirements to pull data from other systems and embed in excel

-Designing and implementing web applications using ASP.Net, AngularJS

Darwin COMM (Microsoft):

Commercial Operations facilitates software and services purchases for Microsoft partners and customers of all sizes. It is Microsoft’s goal to deliver innovative and efficient operational solutions that create great customer experiences. This Microsoft organization includes regional operating centers (“ROC” or “ROCs”). Each ROC provides consistent functions, field productivity efforts, and sales alignment for its geographic area to process customer agreements, orders, queries, and partner operations relationships at consistently high standards for efficiency and service. Business Intelligence supports Services, Global Process Office, and Partner & Field.

I am responsible for leading the team, requirements gathering, preparation of estimates/ project plans for new assignments, communicate with clients, motivating the team in doing automations and developing tools and takes care of development work.

Technologies: SQL Server, SSIS, SSRS and SSAS, Win 8 App

Duration : Aug 10 – Apr 14

Team Size: 8

Role : BI Architect & Lead Developer

Responsibilities:

-Responsible for gathering requirements and project planning.

-Responsible for architecting the solution and data modeling

-Involved in development and enhancements of SSIS Packages performance.

-Involved in change requests in more than 100 SSIS Packages.

-Involved in Regression Testing phase of reports.

-Bug Finding and Fixing in Reports

-Reports Development and Modifications.

-Win 8 application development.

-Back end testing for Data Validation Queries in UAT and SIT phase.

-Leading the support team to support 3000 SSRS reports and more than 800 SSIS packages.

-Involved in doing the Change Requests.

-Responsible for creating subscriptions using data driven subscriptions on weekly and monthly basis.

-Working on new change requests on SSIS, SSRS and SSAS.

-Prepared weekly status reports

-Logging and addressing problems in the internal ticketing system.

P & G:

InStore Navigator Advance Reporting system is an OLAP reporting application which is rendering data for around 90 reports every day for Retail Execution activities of P&G. These reports are generated from OLAP data and this data is extracted and loaded from source to staging database and then staging to data ware house database every day two times with Incremental Load in morning timings and Full Load in night timings with the help of ETL packages which are scheduled through jobs.

Technologies: SQL Server, SSIS, SSRS and SSAS.

Duration : Aug 08 – Aug 10

Team Size: 4

Role: BI Architect & Lead Developer

Responsibilities:

-Responsible for gathering requirements and project planning.

-Responsible for architecting the solution and data modeling

-Involved in development and enhancements of SSIS Packages performance.

-Involved in change requests in more than 100 SSIS Packages.

-Involved in Regression Testing phase of reports.

-Bug Finding and Fixing in Reports

-Reports Development and Modifications.

-Back end testing for Data Validation Queries in UAT and SIT phase.

-Involved in Support and in solving the tickets.

-Involved in doing the Change Requests.

EMRP(Microsoft):

The Emerging Markets Regional Program (EMRP) is designed to provide royalty discounts and rebates to qualifying OEMs to further marketing, promotion and Sales Out Reporting (SOR) of Customer Systems preinstalled with genuine licensed versions of Windows Vista® software.

OEM SOR Customer Upload user logs on to the OEM SOR tool to upload sales out reporting (SOR) file in excel format. OEM SOR MS Policy and Program user can also upload the SOR files on behalf of OEMs. The workflow will be same for both the cases.

The OEMs upload the SOR file before 15th of every month for the previous reporting month to meet the compliance. Additional 90 days will be provided as grace period to upload the SOR file.

During the upload process, the file will undergo Level-1 and Level-2 validations which checks for Excel file and data format.

Duration: Apr 2008 - July 2008.

Technologies: SQL Server, SSIS

Team Size: 3

Role: Senior Software Engineer

Responsibilities:

Involved in Business requirement gathering

Created SSIS Packages to move the data from flat flies into sql server database

Loading the data to History tables

Writing the store procedures to remove the bad data and for validations

Log all the errors generated by SSIS package into windows event log

Performance tuning for the exiting store procedures

Testing the Package by using file status table

User accepting testing

Deploy the SSIS package into production

WMCS (Washington Mutual Card Services)

Headquartered in San Francisco, Washington Mutual Card Services, formerly known as Providian Financial, is a leading provider of credit cards and deposit products to customers throughout the United States.

Accenture will provide the IT solution to Washington Mutual Card Services (WMCS). The business applications of WMCS will be transitioned to Bangalore for support, maintenance and development.

Accenture Solutions Centre will be using various methodologies for the transition of the applications from onshore to offshore.

Duration: Dec 2007- Feb 2008.

Technologies: SQL Server, SSIS

Team Size: 3

Role: Senior Software Engineer

Responsibilities:

Involved in Business requirement gathering

Created SSIS Packages to move the data from flat flies into sql server database

Loading the data to History tables

Writing the store procedures to remove the bad data and for validations

Log all the errors generated by SSIS package into Sysdtslog90 table

Performance tuning for the exiting store procedures

Testing the Package by using file status table

Designing Reports using SSRS.

User accepting testing

Deploy the SSIS package and SSRS Reports into production

Biz Ops PoC

Biz Ops PoC: Senior Management, Capability Leads and Global Leaders at Accenture require various reports to track and analyze the demand and supply of the employees, ratio of people working on different projects and the scorecard of the demands fulfilled etc within different data windows. The CIO reports cater to these needs by using the data from various in-house applications. The current scope of the PoC involves re-designing reports initially built on the BO platform to the MS BI platform SQL Server Reporting Services and/or latest reporting tools like Proclarity.

Duration: May 2007- Dec 2007.

Technologies: SQL Server, SSIS, SSAS, SSRS

Team Size: 6

Role: Senior Software Engineer

Responsibilities:

Involved in Business requirement gathering

DataWareHouse Database design

Created SSIS Packages to move the data from Excel flies into sql server database

Loading the data to History tables

Writing the store procedures to remove the bad data and for validations

Log all the errors generated by SSIS package into Sysdtslog90 table

Testing the Package by using file status table

Star Schema and Cube Creation using SSAS 2005 based on the Dimension and Fact tables

Calculated Measures using MDX.

Designing Reports using SSRS.

User accepting testing

Deploy the SSIS package and SSRS Reports into production

Phoenix

Case Vault is a Web application ideal for large cases involving multiparty or multi-district litigation, CT Summation Case Vault is a subscription-based hosting service that lets you collaborate securely and successfully on a reliable, neutral Web site. Winnow ediscovery to only relevant documents, efficiently organize, review and analyze case information, and create production sets for use online or offline. Centralizing essential case information and controlling access to it helps you manage risk so you can concentrate on winning your case. Store case data and access it, anywhere, anytime using an internet connection and a standard browser. Search, edit retrieve and collaborate on:

Scanned/imaged discoverable documents, eDocuments and email (native file format or image files), OCR (full text), Production sets, Transcripts, Notes (Transcript and Database), Work product (i.e. Correspondence and precedents).

CT Summation Case Vault provides a uniform platform for collaboration among litigation groups, particularly when cooperating or adversarial parties want shared data hosted at a reputable, neutral site. Its SQL backend provides a robust and powerful backend while the application provides an ideal solution for online collaboration between multiple parties 24 hours a day, 7 days a week.

Role: Senior Software Engineer

Responsibilities:

1.Gathering requirement from client

2.Created technical specification document

3.I involved in the database design,

4.Writing the complex stored procedures,

5.Designing and coding the application

6.Responsible for end to end testing and bug fixing

7.Involved in deploying the application in different environments

Platform:

ASP.NET, C#, SQL Server 2000, Windows 2000, Windows Services, TFS.

Duration: Oct 2006– Apr 2007

CODE EXCEL

CodeMed: CodeMed is the main admin group who has complete access for creating and editing Healthcare providers and coding companies in the software.

Healthcare Provider: Healthcare Provider submits the patient medical records to CodeMed.

Coding Company: Coding company performs the coding for a patient based on the medical records received by the codeMed.

Role: Software Engineer

Responsibilities:

1.I involved in the database design,

2.Writing the stored procedures,

3.Designing and coding the web pages.

Platform:

C#, SQL Server 2000, Windows 2000, Crystal Reports.

Duration: May 2006– Sep 2006

P4B.Net- Hub

P4B.Net Hub is a buyer supplier network. Based on web services and service oriented architecture.

E-Procurement is the buying and selling of goods and services (business to business) in a digital environment by means of software applications that are "web" or "internet" based.

An e-procurement network provides a secure market place, sales platform and transaction tracking system to buyers and sellers.

Features of P4B.Net Marketplace are:

Ability to integrate with buyer and seller systems

Ability to integrate smoothly with other partners

(E.g. credit card firms, courier companies etc.)

Ability to configure/reconfigure services

Ability to match the information of the participants in a transaction.

Role: Software Engineer

Responsibilities:

1.I involved in the database design,

2.Writing the stored procedures,

3.Designing and coding the web pages.

4.Involved in unit testing and bug fixes

Platform:

Asp.Net, C#, Web Services, XML, SQL Server 2000, Windows 2000.

Duration: Dec 2005– April 2006

Intelligent Property System(IPS)

IPS consists of five modules – Applicants, Owners, Properties, Tenants and Reports. The main purpose of IPS is used to search for appropriate property(land) in a particular area, and to search for owners of those properties . Owners has the modules like Sign agreement deciding the rent commission. And Tenants has the module like sign agreement deciding the rent Amount, other charges and the rent duration (Monthly, Quarterly, Half yearly, yearly). And Searches All the Properties depending on various criteria’s – Location, No of Rooms, Rent amount. And register all properties for sale including units. And IPS has the reports like Property information, Property sales, Property rent/lease, and customer’s details and their payments and due amounts and other information also shown in the form of daily, weekly, monthly reports.

Role: Software Engineer

Responsibilities:

1. Involved in gathering requirements

2. Involved in the database design,

3 Writing the complex stored procedures,

5.Designing and coding the Application

Platform:

Windows 2000, VB.NET, SQL Server 2000, Crystal Reports.

Duration: Apr 2005 – Oct 2005

HRMS of HealthCare Department

The HRMS module consists of four modules- Masters, Transactions, Enquiries and Reports .The Masters module deals with the registration of employees, candidates, details of placement agencies, declaration of leave types, and visa details etc.,. The transactions module consists of mainly man-power indent, cv details, candidate interview schedules, offer letter details, employee details, employee leave details, medical license details,, work permit details, and maintaining employee attendance details, and calculating the OTs and hours worked, payroll maintenance and employee termination details, etc.

The Enquiries module is useful to retrieve the information about a particular department or particular employee. It is useful to view the details of employee details, attendance details, salary details. The reports module consists of reports related to employee attendance, employee details, leave details, payroll details, visa details, etc.

Role: Software Engineer

Responsibilities:

1. I involved in the database design,

2.Writing the stored procedures,

3.Designing and coding the Application

4.Involved in unit testing and bug fixes

Platform:

Windows 2000, VB.NET, SQL Server 2000, Crystal Reports

Duration: July 2004 - Mar 2005

Online Issue Management

It’s an intranet application. The main concept for developing the project is conference on the net. Only the allowed employees can login, and have conference with other allowed employees and individual conclusion is made.

It is having mainly two modules. One is at Administration Level and other one is of Employees. It maintains authentication in order to access the application. Administrator task includes Employee Registration i.e., new employee recruitment will take place. News and information about company can access employee.

The complaints which are given by employees will be referred by authorities. Issues will put in front of related employees to get proper solutions. For selecting higher posts Elections will be conducted.

The user module includes reading and checking notice and displayed issues. Employees can register complaint against management. Every employee can participate in the elections. Nominees can put their promise on net through canvas module. Results will be displayed for every issue. On an issue an employee can vote only for once. It generates all the related validations.

Role: Software Engineer

Responsibilities:

1. Involved in creating the database

2. Writing the stored procedures,

3. Designing and coding the Application

4. Involved in deploying and testing the application

5. Involved in bug fixes

Platform:

Windows 2000, ASP.NET, C#, SQL Server 2000

Duration: Jan 2004 - Jun 2004

Security Attendance Software

This software is designed for attendance monitoring of an organization. This attendance is recorded in a smart card based terminal, which has got built in memory. At the end of the month the attendance records of employees are downloaded from the terminal through rs-232 communication. This software has modules for setup of this software for a particular organization, entry of departments, designations, leave types, holidays and user creation and employee registration. It also has modules for leave application, leave processing, manual attendance and modules for setting date and time of terminal, clearing memory of terminal and downloading attendance records from terminal. This software gives exhaustive attendance reports periodic, employee wise, department wise and designation wise. In periodic reports daily, monthly and selected period reports are available. Attendance reports give the details of employee like his basic attendance status of half day/full day/leave/absent, time in, time out, hours worked, late, over time. At the end of the month it generates monthly summary of an employee with days present, days absent and days on leave which ensures an effective payroll system.

Role: Software Engineer

Responsibilities:

1. I involved in the database design,

2.Designing and coding the Application

3.Involved in testing the system

4.Involved in bug fixing

Platform:

VB6.0, SQL 8, Crystal Reports 8.

Duration: July 2003 - Dec 2003

Professional Activities/Other Items

• Good Communication Skills.

• Good Technical Skills.

• Good understanding and analysis skills

Other Details

Name : Kiran Karamsetti

Phone Number : +1-770-***-****

DOB : 28-04-1980



Contact this candidate