Karthik L. S.,

897******* (M), +91-040-******** (R)

Email id: accj7l@r.postjobfree.com

Objective

Want to be part of the environment that promotes team effort and provides opportunity for growth as well as career

advancement while making significant contribution to employer organization.

Summary of Experience & Qualifications

• Currently working in Fidelity & have a working experience of 5.10 years on diverse technologies.

• Good knowledge of Facets healthcare product and various modules in it like Claims Processing, Billing,

Subscriber/Member, Commissions etc.

Performance Point Services for creating Dashboards.

•

Creating analytical dashboards through data obtained from OLAP database

•

Tableau 8.0 used for performing visual analysis of SSAS cubes.

•

Well acquainted with Tableau Architecture & Design.

•

Have good knowledge on Data Conversion, Sort, Conditional Split and Fuzzy Grouping Data Flow Transformations

•

Tasks in SSIS.

Debugging SSIS packages with Control points, Break points, & Data Viewer control.

•

Worked in Encora Inc. on complex reports development in SSRS 2008 R2.

•

Worked on the SharePoint 2013 CSOM & REST APIs.

•

Handle client interactions on daily basis for communicating the project status & team work

•

Well acquainted with the use of Scrum, Kanban processes.

•

One year of Work Experience in UHG. Worked on Healthcare domain & a related product Facets.

•

Worked on Sybase, .NET during 1 year of working in UHG.

•

Two years of Work Experience in Deloitte. Worked on different domains that include Financial Industry, Hospitality

•

Management.

Intern in Microsoft for a period of 6 months. Gained extensive exposure on MOSS 2007, SQL Server 2005, SSIS,

•

ASP.NET 2.0 and SSRS.

Possess good knowledge on Object Oriented Analysis and Design concepts.

•

Good understanding of ASP.NET 3.5 concepts including LINQ, MVC, ORM.

•

Possess in depth knowledge on SSRS Architecture and Reports development.

•

Key Achievements

• Receive performance award from Fidelity for the work performed on building SSRS reports.

• Received Applause Award for DQI Portal Project which includes Development of Incident Tracker, PTO Tracker in

Deloitte.

Implementation of Virtual Learning Programs for enhancing the DQI related training programs in Deloitte which

•

was widely recognized.

Technical Experience

Development Tools / Languages: C, C++, PL/SQL, HTML, Microsoft Office SharePoint Server 2007(MOSS 2007),

•

SharePoint 2013, C#.NET 3.0, .NET 3.5, ASP.NET, SQL Server Reporting Services (SSRS), SQL Server Analysis Services

(SSAS).

Hardware / Operating Systems: Windows, Unix

•

Databases: SQL SERVER 2005, Oracle, Sybase, MS ACCESS, XML

•

Fidelity Experience (Nov. 2011 – Jan. 2014)

Project Name : Vision Global Production Duration : 18 months

Role : Reports Developer

Key Responsibilities:

• Writing MDX queries for SSRS reports.

• Working with Calculated members, filtering the results of the cube when displaying the data in SSRS report.

• Building charts for displaying & performing analysis on the data.

• Developed report for analyzing the cubes, dimensions, hierarchies, & members in the cube by using the DMVs.

• Developed reports based on dynamic grouping.

• Analyzing the requirements developed by the business analyst & accordingly develop the reports following the

specifications.

• Creating Dashboards with Tableau to represent information using visualizations.

• Writing calculations & KPIs in Tableau & accordingly represent the information.

• Creating Motion charts to represent changes in data.

• Using bullet charts to visually represent the KPI information.

• Develop Dual axis charts to compare two different measures.

• Using maps to represent the profits in accordance with the states.

•

Technical Environment: Tableau 8.0, SSAS 2012, SSRS 2012, SQL Server 2012, C# 4.0.

Duration : 7 months

Project Name : Incident Tracker

Role : SharePoint Developer

Key Responsibilities:

• Working with CSOM & REST APIs for retrieving information in the lists & document libraries & displaying the

information as part of Apps in SharePoint site.

• Developed custom web parts for displaying the user related information.

• Worked with Business Connectivity Services for fetching information of already recorded incidents.

• Possess good knowledge of SharePoint Object Model.

• Debugging the code using the ULSViewer tool.

• InfoPath forms utilized for entering Incident related information.

• Create and Test data source connections.

• Create Views that use those data connections.

• Creating Dashboards using Performance Point Services.

Technical Environment: SharePoint 2013, InfoPath Forms 2010, SharePoint Designer 2013, Visual Studio

2012,Performance Point Services 2010.

(Mar.2011 – Nov. 2011)

Encora Experience

Project: Gabriel Duration: 8 months

Role: Reports Developer

Key Responsibilities:

Interpret the design specifications developed by business analyst and accordingly developing the reports.

•

Writing complex expressions to meet the business requirements.

•

Worked on connecting Oracle 10g with SSRS.

•

Involved in writing custom code for connection databases with SSRS.

•

Regular interactions with the client on the status of the tasks.

•

Developed maps for representing visual information that meet the customer’s requirements.

•

Scrum & Kanban processes followed to make sure that the project is delivered within the estimated SLAs.

•

Technical Environment: .NET 2.0, SSRS 2008 R2, Oracle.

UHG Experience (Mar. 2010 – Mar. 2011)

Project: Facets Duration: 12 months

Role: Developer

Key Responsibilities:

Developing stored procedures in Sybase as per the design specifications.

•

Identifying performance bottlenecks caused by the code & resolving them.

•

Coding and developing as per the change requirement in Tracer/Work Order or in a ticket.

•

Improving the performance of batches both Trizetto as well as Custom batches.

•

Exploring the issue and providing necessary recommendation for the business users to solve the tickets.

•

Resolving issues in Maps that are developed using IBM Transformation Extender tool

•

Developing reports requested by the users in SSRS.

•

Scheduling & deploying reports using Report Server.

•

Identifying different categories of issues raised by users & resolving them appropriately.

•

Improving Performance of Reports by taking advantage of Caching.

•

Technical Environment: Facets, Sybase, SSRS, IBM Transformation Extender, Unix.

Deloitte Experience (Sept. 2007 – Oct. 2009)

Project: PTO Tracker Duration : 3 months

Role: Developer

Key Responsibilities:

Developer of DAL using ORM Designer tool

•

Utilizing Nested Master Pages for managing the UI

•

Role based Security for managing the security of web application

•

Managing very large data using SQL Server’s built in horizontal partitioning

•

Properly utilizing clustered and unclustered indexes according to the operations to be carried out on the data

•

Integrate custom .Net assemblies into Reporting Services Reports for outside the box solutions

•

Developed cubes in SSAS to help in analyzing business data

•

Integrate data from a variety of data sources into SQL Server using SSIS.

•

Technical Environment: .NET 3.5, SQL SERVER 2005, SSRS, SSIS.

Project: XBRL GMP Pilot Duration: 6 months

Role: Developer

Key Responsibilities:

Automating the path of database in InfoPath forms using JavaScript.

•

Making VBA changes to the Excel interface to make the code more flexible.

•

Automating the process of creating certificates in InfoPath forms.

•

Interacting with the Senior Managers in US and accordingly drive the application development.

•

Technical Environment: JavaScript, VBA, InfoPath, SQL Server XML.

Project: Clinical Documentation Excellence Duration : 8 months

Role : SQL BI Developer, .NET Developer

Key Responsiblities:

Developing Stored Procedures in Oracle according to the design requirements.

•

Developing Reports in SSRS (SQL Server Reporting Services) according to the requirements specification.

•

Deploying the Reports to the server and handling any Technical issues that arise during deployment.

•

Schedule the emails that include report attachments, to be sent to concerned persons.

•

Provided proper security to the web application by implementing Forms Authentication

•

Developed the Business Logic Layer of the application according to the business requirements.

•

Implemented Authentication and Authorization to the secured web pages using asp.net Windows Authentication

•

mechanism

Implemented validation using the ASP.NET Validation Controls and JavaScript.

•

Used Cascading Style Sheets (CSS) to attain uniformity through all pages.

•

Developed scripts to automate the integration in SSIS.

•

Technical Environment: Oracle, SQL Server Reporting Services (SSRS), ASP.NET 2.0.

Project: SDS Duration: 6 months

Role: Tester, MOSS Developer, SSRS

Key Responsibilities:

Testing the workflow of the application and checking if it works as per the requirements.

•

Troubleshooting bugs that arise during application usage.

•

Gathering requirements from end users and accordingly develop the application.

•

Develop stored procedures so as to create reports according to the requirements of end users.

•

Custom Web parts development according to the business requirements.

•

Use of CAML tool to provide relevant data suiting the business requirements.

•

Scheduling the reports to be sent to clients during specified intervals.

•

Report viewer controls used according to client specifications.

•

Technical Environment: Microsoft Office SharePoint Server 2003, SQL Server 2005, ASP.NET 2.0, SQL Server

Reporting Services (SSRS).

Microsoft Experience (Feb. 2007 – Jul. 2007)

Duration: 5 months

Project: SIT WIKI INDIA

Role: Designer, WWF Developer

Key Responsibilities:

Involved in interacting with the users and finalizing the requirements.

•

Developed the design of the portal in CSS.

•

Providing role based security to enable proper level of authorization and security to the portal.

•

Implementing workflows so that users are notified if any changes are made in the meeting requests in the

•

calendar web part.

Technical Environment: MOSS 2007

Education

Masters in Computer Applications (MCA) from Nirvana College affiliated to Osmania University, A.P.

Bachelor Of Computer Applications (BCA) from Niraj College, Begumpet, Affiliated to Osmania University, A.P.

References

Willing to provide upon Request

Contact this candidate