Sql Server Customer Service
Resume:
Uma Shankar
Technical Lead
**********@*****.***
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