Uma Shankar

Technical Lead

acwdn1@r.postjobfree.com

551-***-****

PROFESSIONAL SUMMARY

9+ years of total experience in Software development and Management in Healthcare Domain and BNFS Domain.

Extensive Experience in Healthcare industry as Facets Application Architect / Senior Developer.

Designed and developed various Inbound/outbound Interfaces and Extensions in Facets.

Well-versed in writing & documenting business plan, Requirements document (BRD), Functional specification Document (FSD), Test cases and User manuals.

Expertise in various life cycle stages of implementation from Requirement gathering, Solution design, GAP Analysis, Testing through Deployment.

Hands on experience in diverse technologies such as C#.NET, VB.NET, ASP.NET (3.0 and 4.5), Azure, SQL Server, Sybase and Oracle PL/SQL.

Expertise in database modeling and design, normalization and data warehouse fundamentals.

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

Knowledge in developing T-SQL queries (DDL and DML).

Experienced in creating Tables, Views and other SQL joins and query writing.

Expert in creating Clustered and Non-Clustered Indexes to improve the performance of the SQL queries.

Strong in all aspects of software development life cycle from design, testing, quality assurance, process improvement, SQL data analysis, implementation, debugging and documentation.

Analytical, methodical, and resourceful approach to problem-solving, identifying and documenting root causes and corrective actions to meet short and long-term business and system requirements.

Hands on experience in managing team members and motivate them to accomplish their tasks on time.

A highly motivated team player with an ability to quickly adapt to new environments and technologies.

Excellent communication, analytical, verbal, writing skills along with strong management, organizational and mentoring skills.

Worked on Microsoft Azure Cloud platform.

Developed various Azure services like Compute(Web Roles, Worker Roles), Azure Websites, Caching, Sql Azure, Storage, Media Services, Machine Learning, Network services, Azure Active Directory, API Management, Scheduling, Auto Scaling, Power Shell Automation.

Architecture Design for application to be migrated on target cloud platforms.

Implementation of application for enterprises and service providers.

Handled projects on AGILE methodology.

TECHNICAL SKILLS

Web Technologies

ASP.NET, XML, XSD, XPATH, HTML, Azure, VB Script, HTML, XML, CSS

Source Control

TFS, VSS (Visual Source Safe)

ETL Tools

SSIS, SSAS, SSRS, DTS

Languages

VB.NET, C#.NET

Databases

SQL Server 2005, 2008, Oracle 10g, DB2, MS Access, Sybase

Operating Systems

Windows NT, Windows 2000, Windows 2003, Windows 2008, Windows XP

Reporting Tools

SSRS 2008 / 2005, Microsoft Excel

Tools

Trizetto FACETS, Tidal, Toad, SQL Server Management Studio, SQL Server Business Intelligence

Development Studio, Control M, MFT, SFT

PROFESSIONAL EXPERIENCE

American Express Global Business Travel, Phoenix, AZ

September 2015 – Present

Technical Lead

American Express Global Business travel (AEGBT) is a travel program tailored to achieve specific goals. Which allow users to build and implement strategies that can help streamline operations, improve the business traveler experience, reduce risk and increase savings.Wide-range of solutions for business travel and extensive travel data and fine-tuned methodologies.

Responsibilities:

Interacted with stakeholders to get a better understanding of client business processes and gathered requirements.

Providing assistance in developing solutions that meet the business requirements.

Managing issue/defect/break fix-bug fix resolution.

Re-issue of invoices to meet Payment Method regulation by Government.

Involved in modifying existing SQL Server objects like tables, Views, Functions, stored procedures.

Involved in creating stored procedures which load data from multiple tables to single table in data mart.

Modified existing SSIS package to add fields as requested by the business users.

Used XML configurations in SSIS packages to deploy them into DEV/ Testing/ Production environments.

Created various tablix and matrix reports in SQL server data tools as per user requirements and standards.

Created Ad Hoc reports and assisted users in building the reports using SSRS report builder.

Worked with business users in finding the issues related to data.

Performance improvement initiatives.

Managing file transfer from to MFT using ftp/sftp/ftps/https/Connect Direct protocols.

Creation of user with Seeburger BIS File exchange IDM.

Creation of entity group, file low activity from mailbox to mailbox or connect direct, SFTP Push etc.

Environment: .NET, SQL Server, DB2, SSIS, SSRS, SFT, MFT, Control M

Hospital Corporation of America (HCA-Parallon), Nashville, TN

January 2015 – August 2015

Technical Lead

HCA has developed a number of best demonstrated business practices that leverage our collective experience, scale and expertise in a way that is unprecedented in the healthcare industry. Parallon Business Solutions provide revenue cycle and other business processes, workforce management solutions, supply chain services and the purchasing power of HealthTrust Purchasing Group, one of the nation’s leading group purchasing organizations.

Responsibilities

Interacted with stakeholders to get a better understanding of client business processes and gathered requirements.

Requirement analysis, design, coding and testing of change requests made by client for all enhancements and new developments.

Document all client requirements, plans, project activities and MOM.

Monitor and support of the issue / incidents ticket and provide the resolution.

Enhancement of existing Data integration process in Pervasive.

Designing of new process flow in Pervasive for the new LOBs.

Scheduling Jobs of various applications.

Provided daily support, troubleshooting, monitoring of jobs running on SQL Server.

ETL implementation using SQL Server Integration Services (SSIS).

Optimized Complex queries using Indexes and execution plan.

Involved in performance tuning and optimization of stored procedures and queries.

Environment: .NET, SQL Server, SSIS, SSRS, Pervasive

American Express (Global Payments), Phoenix, AZ

November 2013 – December 2014

Technical Lead

BUSA (Business Unit Security Administration) is responsible for maintaining all types of IDs the user will need once they begin working at Amex. Working in department he may need access of CAS (Credit Authorization System) and CC90s (Credit Collections of the 90s) CSP (Customer Service Platform). BUSA will generate user ID and password of this system. Every year approximately 10,000 request of add, modify and delete of user ID and password is processed by BUSA. Ocelot is an application developed for BUSA (Business Unit Security Administration) group. Data Processing in Ocelot is fast. Forms are user friendly. Automation Process of Ocelot is a huge benefit for BUSA. Maintaining information is relatively easy than Louts Notes application.

Responsibilities

As an Agile process had daily Interaction with client, understand requirements, plan, project activities, software requirements and timelines of project deliveries.

Designed, developed and deployed a highly scalable SQL Azure database using T-SQL stored procedures and views.

Migrated VB.NET windows application to Azure environments like E1, E2 and E3.

Designed and developed VB.NET / ADO.Net repositories accessing the Azure hosted stored procedures/views.

The repositories are designed using generic access methods to centralize all of the core critical database operations.

Work on all the phases of enhancement.

Performed the testing of code after migration on Azure.

Documented each UAT support and production launch activities.

Monitor and support of the artifacts logged by client in each sprint planning meeting.

Implementation and design of new web services, Web API, SQL procedures, DLLs on target cloud platforms.

Implemented the hybrid cloud scenario POC using Windows Azure Pack

Environment: .NET, SQL Server, Windows Azure

Trizetto, Denver, CO

June 2011 – October 2013

Technical Lead

Facets is Trizetto solution to assist payer organizations in staying ahead of trends in the employer benefits market. Facets encompass sophisticated technology that automates work processes, reduce costs, and simplifies the process of navigating through a health care delivery system.

Base Facets modules include: security, accounting, application support, customer service, medical and hospital Claim processing, provider agreements, provider, and subscriber/member.

Responsibilities

Understood the technical business needs of the project through Business Requirement Document (BRD), Functional Specification Document (BSD) and Technical Specification Document (TSD)

Developed various Facets inbound and outbound custom interfaces for several clients.

Supported 140 interfaces with their enhancements, break fix and other extension related activities.

Created customer specific docs like DD, FD, AO11 and Mock up maps.

Implemented automated COB processing of Medicare claims into Facets.

Validated business rules and all artifacts with users, got approval and sign off.

Experience with Trizetto Facets System implementation, Claims and Benefits configuration set-up testing,

Inbound/Outbound Interfaces and Extensions, Load and extraction programs involving HIPAA 837 and proprietary format files and Reports development.

Backend change involved creation and modification of SSIS package, Stored Procedure, Views, Functions etc

Script code change was involved with VB Script and Perl Script.

All the Hosting Batch Architecture files were created in XML.

UI code change was designed in VB.NET.

Monitor and support of the issue / incidents ticket and provide the resolution.

Enhancement of existing Data integration process in Pervasive.

Designing of new process flow in Pervasive for the new LOBs.

Scheduling Jobs of various applications.

Provided daily support, troubleshooting, monitoring of jobs running on SQL Server.

ETL implementation using SQL Server Integration Services (SSIS).

Used PVCS, as source control(Configuration Management).

Optimized Complex queries using Indexes and execution plan.

Involved in performance tuning and optimization of stored procedures and queries.

Environment: .NET, SQL Server, XML, SSIS, VB Script, Perl Script, Facets, HBA Architecture

Morgan Stanley, Newyork, NY

December 2009 – June 2011

Software Engineer

Morgan Stanley is a global financial services provider headquartered in New York City, New York, United States. It serves a diversified group of corporations, governments, financial institutions, and individuals. Morgan Stanley also operates in 36 countries around the world, with over 600 offices and a workforce of over 60,000 through its subsidiaries and affiliates, provides its products and services to customers, including corporations, governments, financial institutions and individuals. The company operates in three business segments: Institutional Securities, Global Wealth Management Group, and Asset Management.

Responsibilities

Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.

Designed the functional and technical documents, report templates and reporting standards.

Involved in creating Named calculations and named queries.

Created SSIS packages to Oracle and other SQL Server instances.

Created Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

Performed maintenance of Stored Procedures to improve Performance of different front end Applications.

Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup.

Transform the data from the staging database and perform the transformation using the Data Flow Tasks

Operations and perform the Different required transformation in the Staging Database to load in the data warehouse.

Created SSIS packages using control flow and data flow elements.

Configured packages to deploy them to different environments.

Build database queries and test cases for the testing team to test the reports

Environment: SQL Server, SSIS, Oracle

Nortel, Ottawa, CA

CSC-Hyderabad, Telangana

April 2007 – December 2009

Software Developer

Nortel is a multinational telecommunications equipment manufacturer headquartered in Toronto, Canada. Nortel makes telecommunications network equipment including optical transmission equipment, wireless, voice, multimedia, and packet networking and associated services

Involved in creating, manipulation and supporting the SQL Server databases.

Developed the Data modeling, Physical and Logical Design of Database.

Created tables, constraints, indexes, sequences, procedures and triggers.

Implemented Stored Procedures and Triggers on business rules.

Participated in integrating the front end with SQL server back end.

Created User defined Functions, Stored Procedures and Triggers using DML and DDL.

Used Data Transformation Services (DTS) to import and export data from one server to other server.

Involved in performance tuning of T-SQL queries.

Environment: SQL Server, DTS, VBA, MS Access, Cold Fusion

Tata Consultancy Services, Noida, Uttar Pradesh, India

April 2006 – October 2006

Associate Consultant

Eli Lilly and Company is an American global pharmaceutical company with headquarters located in Indianapolis, Indiana, in the United States. Lilly was the first company to mass-produce penicillin, the Salk polio vaccine, and insulin, including one of the first pharmaceutical companies to produce human insulin using recombinant DNA. Lilly is also the world's largest manufacturer and distributor of psychiatric medications

Responsibilities

Actively involved in creation of database, modified tables, triggers, and procedures to clean and validate the data.

Data transformation activities using DTS Import/Export for transferring data between different Databases like Oracle, Sybase.

Design new DTS Packages as per needs, resolve problems with existing DTS packages etc.

Incorporate business logic and validations in DTS packages.

New database and table design to sync with DTS.

Written stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects and so on.

Ensured constraints and writing triggers to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.

Created different user level groups, and assigned appropriate permission level to the database. This made sure that only the right person with enough authority would be able to see the Customer Information.

Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.

Environment: SQL Server, Oracle, Cold Fusion

EDUCATION

Master's in Information Science

BIT Mesra Ranchi

Contact this candidate