Kiran Karamsetti

(admxjt@r.postjobfree.com)

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

****, ******* **, **********, **, USA - 30005

Data Architect/Engineer with a proven ability to design complex data warehouses/Data Mart/Data Lake that is scalable, flexible and robust. Expertise in architecting & developing high performance data warehouse and business solutions using SQL server, MSBI (SSIS/SSRS/SSAS), Power BI & Azure.

15+ 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 & Azure.

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.

Strong Data Modelling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Visio, Erwin

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 and Erwin.

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 working in Waterfall and Agile development methodologies.

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

Experience in creating dashboards/reports using Tableau & Power BI

Developed calculated measures using Data Analysis Expressions (DAX)

Experienced in Azure SQLDB, ADF, Azure Data Services

Technical Skills

Microsoft Specific Skills

• SQL Server 2005/2008/2012/2014/2016/2017

• SQL Server Integration Services

• SQL Server Reporting Services

• SQL Server Analysis Services

• Power BI

• GIS using google API

• C#.Net, VB.Net, WCF

• AngularJS

• JIRA

• DAX

• Azure (Azure Data Factory, Azure Data Bricks, Azure Data lake)

Other Skills

• Tableau

• C

• Hypertext Markup Language

• Extensible Markup Language

• Java Script, VB Script

• Crystal Reports 8.0

• PowerPivot & Power Views

• MS Visio

• Erwin

Certifications

Microsoft Azure Fundamentals Certification

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.

Professional Experience:

1) Company Name : Accenture Services LLP, Atlanta

Designation : Application Development Manager

Duration : Dec 2019 to Till Date

2) Company Name : Accenture Services LLP, Atlanta

Designation : Application Development Associate Manager

Duration : Oct 2013 to Nov 2019

3) Company Name : Accenture Services Pvt Ltd, Hyderabad

Designation : Application Development Team Lead

Duration : Oct 2010 to Sept 2013

4) Company Name : Accenture Services Pvt Ltd, Hyderabad

Designation : Senior Software Engineer

Duration : Apr 2007 to Sept 2010

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

Designation : Software Engineer

Duration : Oct 2006 to Apr 2007

6) Previous Company Name : Hoch Technologies Pvt Ltd., Secunderabad

Designation : Software Engineer

Duration : July 2003 to Sep 2006

Experience

AXIS Insurance – Cyber DataMart & Property DataMart:

Axis Insurance has different lines of businesses and Cyber & Property are one of these. Axis pricing actuarial business requires a consolidated Data Mart to drive actuarial and analytics solutions. Fast, reliable, accurate, user friendly and flexible data solution for entire property book comprising of Renewable Energy, E&S Property, Global Property, International Binders and UK/EU/US Property Facility lines of business, similarly for Cyber data.

These are the consolidated DataMart including policy, claim, exposure, reserve info, ledger info, rate monitor, premium allocation, CAT Score, pricing info, exposure information and external data.

The solution will include all Property & Cyber data sources in one place easily accessible by Axis property actuarial and analytics team.

Technologies: SQL Server, SSIS, SSRS and SSAS, Power BI, Tableau, Visio, Azure

Duration: Feb 2020 – Current

Team Size: 7

Role: BI Architect & Lead developer

Responsibilities:

-Responsible for end-to-end delivery of the projects and work on deliverables(hands-on)

-Architecting the Enterprise Data Warehouse for Property and Cyber data.

-Responsible for Staging and data warehouse design

-Designing Star data models using MS-Visio

-Implement Master Data Services and SSIS packages.

-Implementing processes for transactional and incremental loads.

-Architecting the BI solution for data load.

-Work as SME for Data Warehouse, ETL and BI Solutions.

-Creating SSRS, Power BI, Tableau reports for Premium & Claims data.

-Assisting the team in analyzing and completing the project work.

-Interacting with clients and end-users to finalize functional requirements for the assigned deliverables.

-Improved the performance of the SSIS or SQL processes

-Created dashboards using Power BI and DAX (for calculated measures).

-Azure data migration

-Lift and shift of SSIS packages to Azure Data Factory.

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, Power BI, GIS, .Net, WCF, AngularJS and MS-Visio.

Duration: May 14 – Feb 2020

Team Size: 7

Role: BI Architect & Lead developer

Responsibilities:

-Architecting the Enterprise Data Warehouse for Axis Pricing Analytics and Exposure Management systems using Star & Snowflake modelling

-Implement Master Data Services, Data Quality Services and SSIS.

-Implementing Change data capture feature for transactional and incremental loads.

-Architecting the BI solution for Pricing Analytics project.

-Prepared data models and flow diagrams using MS-Visio.

-Work as SME for Data Warehouse, ETL and BI Solutions.

-Creating SSRS, Tableau and Power BI reports.

-Assisting the team in analyzing and completing the project work.

-Interacting with clients and end-users to finalize functional requirements for the assigned deliverables.

-Performed incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.

-Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

-Enforced data Integrity by maintaining and assuring the accuracy and consistency of data (using Constrains, Foreign Key relations) over its entire life-cycle.

-Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.

-Involved in creating multiple dynamic reports using SSRS and scheduled a report to run weekly, monthly and quarterly based on the business requirements.

-Designed dashboards that provided interactive reporting environment for market trend, forecast and budgeting using tableau.

-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, SSAS and Erwin

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

-Designed Star & Snowflake data models and flow diagrams using MS-Visio and Erwin.

-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.

-Designed SSRS reports using SQL queries and MDX

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: Lead Developer

Responsibilities:

oInteract with client and gather requirements.

oCreated the database and stored procedures

oCreated SSIS packages and fixed SSIS Packages performance issues in existing packages.

oInvolved in change requests in more than 100 SSIS Packages.

oInvolved in Regression Testing phase of reports.

-Reports Development and Modifications.

-Involved in Support and in solving the tickets.

-Involved in doing the Change Requests.

-Improved performance of SSRS reports using cube and MDX queries.

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.Responsible for 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.Responsible for requirements analysis

2.Writing the SQL queries and 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. Requirements gathering and analyzing

2. Design the database as per client requirements,

3 Writing the stored procedures,

4.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. created database as per client requirement

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 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. Understanding the existing system,

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 analytical skills

Other Details

Name : Kiran Karamsetti

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

DOB : 28-04-1980

Contact this candidate