SUMMARY

• 13 years of experience in all stages of the development cycle for dynamic projects across Finance, Logistics and Health Care (Medicare, Claims Processing) domains.
• 13 years of experience in environments involving Mainframe technologies and developing and implementing business requirements as a Microsoft SQL Server 2016/2012/2008/2005/2000 Developer/BI Developer.
• 3 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in Client - Server application development using Oracle 10g PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Extensive experience with Web technologies like ASP.NET, WCF & Web Services, IIS 5.0, 6.0, HTML, XML, SOAP, JavaScript, SSRS and SSIS.
• Over 5 years of strong professional experience in .Net Development, SQL and SQL Server Integration/Reporting Services experience in various applications based on Object Oriented Programming (OOP), Client/Server, N-tier architecture, Web based and Internet Technologies.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS and SSRS
• Extensive experience on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle.
• Excellent understanding of Relational Database Systems, Normalization, Data Mining, and Data Warehousing.
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects.
• Excellent T-SQL programming skills in writing complex queries to Create and Update Database objects such as Tables, Views, Stored procedures, Triggers and User-Defined Functions.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in building Data Integration and Workflow Solutions for Extracting, Transforming, and Loading data with SSIS packages, DTS and BCP utility.
• Experienced in implementing Incremental Data Load from an OLTP to a staging database for further Analysis.
• Extensive experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS) 2008 and excellent understanding SSIS Control Flow items and SSIS Data Flow items
• Experience in implementing Transactions, Logging, Error handlers and XML configuration files to SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• 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) using SQL SSRS.
• Good Understanding of Data warehouse concepts such as like Kimball model, Inman model, Star-schema and Snowflake schema.
• Developed Scorecards with advance set of dashboards using different Business Intelligence tools such as ProClarity and Performance Point Server.
• Well-versed in building and deploying Mainframe Legacy applications with Service Oriented Architecture using Web Services.
• Profound ability to quickly understand complex systems.
• Highly organized and efficient in fast-paced multitasking environments, able to prioritize effectively to accomplish objectives with creativity, enthusiasm and humor.
• Proven ability to work in a high-pressure environment.
• Exceptional presentation and organizational skills.
• Flexible, enthusiastic and project-oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs.
• Strong background in management and leadership.

TECHNICAL SKILLS

• ASP.NET, MVC (2.0, 4.0, 5.0), ADO.NET entity frame works, ADO.NET, Web Services, WCF, LINQ
• Visual Studio .Net 2015/2012/2010/2008 z/OS for Mainframe, zLinux, Solaris, Windows
• CICS/IMS DC
• DB2, IMS DB, SQL Server 2008/2012, Oracle
• C#, COBOL, PL1
• Team Foundation Server, Visual Source Safe 6.0, Changeman, Endevor
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• Informatica
• MQ, MQFTE, FTF
• Azure

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

Responsibilities:

• Continuous interaction with Business Analysts and end users to gather business requirements.
• Reviewing the High level and Low-level design documents prepared by the team.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements.
• Ensure Quality work products being delivered to the customer on schedule.
• Mentor and Guide to new joiners in Project.
• Responsible for technical growth and development of team.
• Create SSIS Packages for Incremental loading and slowly changing dimensions.
• Design and develop SSIS packages to Extract transform and load data from various data sources into SQL server.
• Grouping, aggregating, and splitting data using SSIS.
• Develop SSIS packages to automate FTP file processes and emailing to different clients.
• Implement logging, custom logging and error handling for SSIS packages.
• Work on Confidential 's proof of concept on implementing Azure Data studio and Data factory for Microsoft SQL Server.
• Develop application database to satisfy clients requirements using Oracle 10g PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Implementation of Data warehouse concepts that help in ETL processes.
• Develop complex database objects like stored procedures, functions, packages, and triggers using SQL & PL/SQL.
• Perform on demand data load to Oracle tables using SQL Loader.
• Design table partitions based on the range partition technique
• Create reusable shell scripts that invoke SQL scripts to drop table indexes, recreate indexes and gather table stats.
• Update physical and logical data models for every project based on the changes implemented.
• Support the system testing and User acceptance testing.
• Migrate Classic ASP applications to .Net Framework.
• Developing the front-end web forms using ASP.NET and C#.
• Developing Business Logic layer by implementing OOPs features like Inheritance, Polymorphism, Abstraction and Encapsulation in C# .NET.
• Support Mainframe batch claims process and Point of Service network transactions for Pharmacy claims.

Confidential

Global Delivery Lead

Responsibilities:

• Develop Stored Procedures and Views to be used to supply the Data to the Reports.
• Implement complex queries to show derived fields and to format the reports data based on specific conditions.
• Implement ETL (Extraction, Transformation, Loading) processes extracting data from heterogeneous source systems. Assist DBA in using the repository manager to give permissions to users to create new users and repositories.
• Create subscription to SSRS reports.
• Generate Reports using Global Variables, Expressions and Functions for the reports.
• Write complex Mainframe DB2 queries to provide UPS packages status to the user groups.
• Create complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Create and schedule SQL jobs to run SSIS packages on a daily basis.
• Design, Code and test .Net and Mainframe based applications.
• Prepare Detail Design based on Functional requirements provided by client/business analysts - suggest any changes/ improvements if necessary.
• Requirements gathering, Impact Analysis, estimation & Quality processes.
• Resolve User queries.
• Resolve Production abends, keeping in mind the severity and Service-level Agreements.
• Create and Manage service requests and co-ordinate with the clients.
• Manage the offshore resources (team of 8) and their tasks (Lead the Test Plan reviews & Test design development), Define the team roles & responsibilities.
• Provide Budget estimations to senior Managers.
• Creating Unit Test Plans based on Functional Requirements and technical Specifications.
• Resolution of defects, issues through modification of components (coding, Unit and Regression testing) and their implementation.
• Extensively worked in exposing existing Legacy applications as Web Services Client/Provider by adopting SOAP based Web Services in to project using CICS Transaction server.
• Proficient in developing applications which consume Web Services using XML parsing.
• Adept at setting up PIPELINEs, Channels & Containers to facilitate Web Services functionalities.
• Highly experienced in handling Legacy applications with front end on Web using CICS Web Support (CWS).
• Experienced in integrating with applications on SQL platform using DB2 Stored Procedures and User Defined Functions (UDFs).
• Design, Code and test applications primarily involving technologies like COBOL, CICS Web support/Web Services, DB2, JCL, VSAM.
• Prepare Detailed Design based on Functional requirements provided by client/business analysts - suggest any changes/ improvements if necessary.
• Subject matter expert for the client in the areas/applications responsible. Responsible for validating the Business Rules in the application and Database Analysis.

Confidential

Senior System Engineer

Responsibilities:

• Developed and worked with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2005.
• Created Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations
• Worked with a combination of multiple Control Flow Tasks, Data Flow Tasks and Dataflow Transformations to build packages in SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Analyzed, designed, developed reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Used Report Manager to configure Web URLs, E-mail and Databases to prepare reports and make reports visually appealing by adding different report formatting options and also provided back-end support for functional testing and performance testing.
• Worked on Mainframe PL1 migration project.
• Primarily responsible for maintaining & developing PL1 code in the applications.
• Responsible to translate customer requirements into formal requirements and design documents.
• Trained the team in SDF Tool (Screen Definition Facility) for designing online CICS screens. Use of this tool reduced the effort involved in screen designing by 80%.
• Set up new project in SCLM tool for this application.
• Developed 15 new CICS online screens and 6 new PLI-CICS-DB2 programs.
• Prepared time estimates for the project/enhancement.
• Designed new and high-quality solutions to clients in response to varying business requirements
• Responsible for developments/enhancements.
• Responsible for preparing unit test plan and perform unit testing.
• Utilized in-depth knowledge of functional and technical experience in all 8 finance applications in conjunction with industry and business skills to deliver solutions to customer.
• Apart from enhancements, provided quick analysis and solutions to Production problems. Ensured that SLA was met.
• Migrate PL1-IMSDB/DC functionality from MCB to MCD application.
• Translated business requirements into Project Definition Report, Detailed Design Document and prepared time estimates and schedule for the project.
• Designed and created new IMS DC screens using SDTM tool
• Created new COMSEC options for online and provided the necessary authorization levels called ‘restriction fields’.
• Set up Automatic job scheduler using Operation Planning and Control Tool (OPC) for this application.
• Set up the whole application in UAT environment and further involved end users in UAT.
• Communicated activities/progress made to project manager and technical team lead.
• Co-coordinated with IMS Admin group and other dependent teams before implementation.