PROFESSIONAL SUMMARY:

• 17 plus years of experience in IT Services industry with 5 plus years.
• He has worked over 7 years in the Finance IT services industry.
• He is working for the past 9 years in the Banking and Financial services.
• Worked with large global customers whose operations are across multiple geographies catering to global markets and businesses.
• Involved in developing the various internal projects of Confidential .
• Confidential is an Internal Service Portal that provides transaction based operations this enables Associates to focus on their own core areas such as strategy, policy - making, analysis and MIS. Platform manages the workflow of all business processes defined in Confidential .
• Provides the framework for design time process mappings with respect to the role players involved, tasks to be executed and the status updates and runtime state invocations of the process. Resource Management System is one of the modules of E-Support which includes different processes named Resource fulfillment, Associate Relocation, Breakthrough, Skill/Visa campaign.
• Subject Matter Expert (SME) role for over 10 plus years and been in a client facing role for over 15 years.
• He has been associated with Confidential .
• Involved in User requirements gathering and analysis of the functional specifications provided by the client and preparing the Technical Specification documentation.
• Involved in all phases of a Data warehousing projects from requirements definition through implementation, on large scale, mission critical processes, performance tuning, quality and client coordination and application maintenance.
• Designed the date ware house system to maintain periodic data in a distributed environment.
• Worked on Query Optimization through query Analysis and Index Optimization.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports
• Involved extensively in SQL scripting and performance tuning in the databases SQL Server 2000,2005,2008,2012,2014.
• Provided quality solutions for most of the high Visible projects in Confidential Data ware house like Account Life Track, DataMart Archival and Optimization, Pre-Select Offer, Partial Charge off, GAML ADHOC, EBR REFRESH, SALES FINANCE, MULTI BUSINESS CUTOMER(MBC), GRYPHON, EWARA, CITISCREEN, CITISEARCH, Brach Self-Assessment(BSA), THRESHOLD, WINDOWS AND DATABASE SERVER UPGRADES, HOC COMPENSATING FACTOR, REJECT APPLICATIONS, HORIZONTAL RISK ASSESSMENT,CHAMP, ESCROW, NET CREDIT LOSS and Consolidated Data ware House .
• Achieved quality results within defined parameters.
• Used various tools and techniques and making use of the profiler and index tuner for trouble shooting the different distributed processes which were handling millions of records.
• Extensive Experience in carrying out the activities of project life cycle Analysis, System Design, Development (coding and testing) and Implementation.
• Sound expertise with .NET framework, VB.NET, ASP.NET, C#, ADO.NET, Web forms and Web Services
• Proficient in Migration of Data to/from various heterogeneous sources (DB2, MS-Access, Oracle, MS SQL server, Mainframe systems to Big data environment by using the SOLIX archival tool.
• Worked extensively in Business Intelligence tools and technology areas like Microsoft SQL Server Data ware house & Business Intelligence, SSIS, SSAS and SSRS
• Exensive experience with MS SQL Server 2014/2012/2008/2000/7.0/6.5 , Oracle 11/10/8.0/7.x, Hive and MS Access as back-end databases.
• Strong skills in Visual Basic 6.0, SQL, T-SQL, PL/SQL, OOP.
• Experienced in designing, developing, and support and maintaining Web-based application using ASP, VB script, Java Script, ADO, COM+, Visual InterDev 6.0, XML, XSL, IIS.
• Good skills with in transaction handling using MTS and COM
• Strong analytical and conceptual skills in writing stored procedures, Triggers, Views using Oracle, SQL Server.
• Good Team player with good interpersonal skills and ability to work in team.
• Familiar with many programming languages, web development and object oriented methodologies.
• Ability to learn new technologies as per the requirement and changing times.
• Demonstrated focus and technical leadership on key distributed ware house projects teaming up with business to make the BI processes much better and has come up with innovative ideas which help the business to execute many of their strategies.
• Designed multiple solutions for the unstructured data archival to Hadoop database from various source systems.
• Constantly striving to make BI DataMart application processes efficient and cost effective as possible.
• Designed automated solutions which have been doing manually since many years. Proactively worked on process improvements activities and well planned deliverables and strategies resulted in higher degree of customer delight.
• Analyzed the BI monthly load process and has come up with a new design solution which reduces the time to lead the account master feed to the distributed SQL Server and the solution benefited the business to see their monthly reports quickly. Prior to this solution business used to wait for 3 days to complete the load process for their report generations and analytical now the enhanced load process successfully completes in a day.
• Come up with a reusable solution for the consolidated data warehouse project (CDW) project which enables all the data manipulations happens in a centralized fashion with maintain the integrity. This solution enabled all the defined symphony models (payments, leads, account, creditbureu, customer, shared, webapps) loads in most efficient manner in the centralized Consolidated ware house.
• Designed and created a generic stored procedure to handle the switch and swap (utilized the partition mechanism) methods to add the data in more efficient manner and enables the automatic sliding window. Utilized a feature Partition Switch for the incremental loads and the end result of the respective daily loads drastically reduced from 2 hours to 10 minutes.
• Come up with cost optimized solution that benefits the customer to reduce the $ cost from extracting the vision data on monthly basis and enhancing the server configuration
• Studied to understand how the new methods of both SQL 2008, SQL 2012\2014 can be efficiently utilized.
• Automated the Account life track process which creates customer level dataset which will help risk management as well as branch network successfully execute many of our strategies (such as proactive loss mitigation, retention cash out programs) much sooner.
• Solely responsible for ensuring optimization for the Confidential data ware house application processes. Wrote efficient stored procedures for the optimal performance of the data ware house processes. Monitored performance and optimized SQL queries for maximum efficiency. Created indexed \ partitioned views and appropriate indexes to reduce the running time for complex queries\reports and faster retrieval.
• Created business crucial stored procedures and functions to support efficient data storage and manipulation. Performed Query optimization & Performance Tuning as requested by business users.
• Advised In-place Upgrade for the Successful migration of all the distributed data ware house environments (IST, UAT, COB, and PROD) to the new versions with little effort and resolved the End of life issues for both Windows and SQL before the scheduled dates. This solution saved a lot of effort hours for the client.
• Upgraded all the CDW server environments (DEV, UAT, COB and PROD) to the 2012 version (to address end of life issues and enhance the performance of the servers with the built in BI and reporting features of the new sql server version) as per the defined timelines without a single defect.
• Configured Distributed Servers with the email notify operator for sending automatic mails to the respective group dl's when a SSIS process failure or success. Automated the production application processes which has been executing manually since many years, this exercise benefited \ saved lot of efforts and cost savings and reduced the complete manual intervention of production support team efforts in long term.
• Come up with an approach to sync the cob server with the production data with very little effort.
• This sync up approach avoided the daily\weekly\monthly refresh process in the cob and reduced the efforts of production support team. Involved and provided valuable recommendations\inputs as part of Harmony project (Action system replacement) initiative.
• Took the ownership and responsibility for the Data Segregation \ Entitlements logical separation initiation exercise in both Legacy DataMart and consolidated warehouse (CDW) environments as part of the Legal Day1 project result of Spring Leaf.

TECHNICAL SKILLS:

Hardware: 8085,8086 Assembly language Programming

Operating Systems: WIN 95/98/NT/2000/XP/7, MSDOS, UNIX

Languages: FORTRAN, Pascal, C, Cobal, Basic, SQL,PL/Sql, C#,VB

Databases: SQL Server-2000, 2008, 2012, 2016 Oracle 11, MS Access. Hive

GUI: Microsoft Dot net Framework, Visual Basic, Developer 2000, Microsoft BI-SSIS,SSRS,SSAS, DW-AbIntio, Cognos, SOLIX, MS CRM

Web Related: HTML, XML, VBScript, JavaScript., ASP, ASP.NET, OOPS, Design patterns, Bootstrap, CSS, WCF

Tools & Utilities: Dream Weaver, Visual Interdev. Adobe Photoshop, Flash, clearcase, VSS, Visio

Domain Knowledge: Finance, Insurance, Inventory, Medical, Human Resources, purchase

PROFESSIONAL EXPERIENCE:

Confidential

Application Programmer Lead

Environment:

Software:

Database: SQLSERVER 2000/2005/2008/2012/2016

Tools: ClearCase, AbInitio ETL, Ms-Office, Ms-Visio, Clearcase, SSIS, SSRS, SSAS, SOLIX, HIVE

O/s: Windows 2008 Server

Hardware: Pentium

Responsibilities:

• Identify groups and individuals whose appropriate involvement in a project in order to obtain their support and commitment on all the key processes in the Confidential Distributed warehouse. Ensure that all interested parties understand a project's goals and objectives as clearly as possible.
• Greater understanding of the client needs effective communication with business groups and users and participates enthusiastically in design meetings and brings valuable insights resulted error free deliverables and adherence to defined SLA's though repeated changes in the business requirements and stiff timelines.
• Ensure that a sufficient amount of relevant and informative project documentation is produced
• Explored all BI features of SQL Server to provide an actionable performance insight to the dataware houses.
• Involved in writing stored procedures, DTS Packages, SSIS packages and producing the reports using SSRS and Cognos.
• Responsible for to improve the performance by optimizing the code of the stored procedures
• Incorporated the best practices for better scalability.
• Coordinated with internal client teams and business users to resolve problems encountered during acceptance testing
• Enhancing the system as per the requirements and expectations of the client
• Studied to understand how the new methods of both SQL 2008 & SQL 2012 can be efficiently utilized.
• Migrated several applications from the DTS methodology within SQL 2000 / SQL 2008 up to the SSIS Technology of SQL 2008 & SQL 2012. This work will allow for the eventual transition from SQL 2008 environment to the SQL 2012 environment that Confidential is moving towards
• Developed an efficient and effective stored procedure that allow for the load of data utilizing partitioning within the Consolidated Data Warehouse - with no defects.
• Works effectively with all technology teams such as the DBA, Wintel, Mainframe and Compliance Teams. Successfully deployed every new application that required efforts from all four of the above teams within a very limited period of time
• Resolves query performance bottlenecks in all Data ware house applications
• Taken proactive steps to make critical processes much more efficient and address business needs
• Meet all requirements, and be deployed without defect while utilizing the most efficient method of development
• Involved in producing the reports for Marketing, Finance, Compliance, Risk teams using SSRS and Microsoft BI methodologies
• Updated skills and competencies to the latest technical and managerial trends and get certified in both Business Management processes and Project management activities.
• Shared the technical knowledge with colleagues as and when needed
• Involved and participated in the proof of concepts(POC’s) along with DBA team which helps to minimize the performance impact on production systems and improve the scalability in terms of monitoring and collecting data from a number of servers and Poc’s for upcoming project initiates
• Participates in the COB planning and testing annually
• Create and submit the Service Now Change requests to migrate the changes to higher environments as well as creating a new Functional id’s to access the db’s in the distributed ware house.
• Responsible for moving the DB objects to Clearcase and Configuration Management

Confidential

System Analyst

Environment:

Software:

Languages : VB,C#, Vbscript, JavaScript

Database: SQLSERVER 2000

Tools: Microsoft.net Framework,ASP.NET,ADO.NET

O/s: Windows XP

Hardware: Pentium

Responsibilities:

• Been involved in the complete life cycle of the processes(Requirements gathering, System Analysis, design, implementation and testing phases)
• Successful implementation of different processes like Breakthrough, Associate Relocation, Subcontract and Visa/Skill Campaign
• Been involved for the change request phases of the RMS and Platform Processes.
• Analysis, understanding and design of change request phase by studying functional aspects of the system for the new requirement
• Preparing the prototypes based on requirements provided
• Responsible for reviewing and optimizing the teams’ code
• Responsible for time estimations, resource tracking and monitoring of work progress for assigned team members and the assigned module
• Responsible for overseeing the Quality procedures related to the project.
• Responsible for to improve the applications performance by optimizing the code and stored procedures.
• Incorporated the best practices for better scalability.
• Implemented Global Exception Handling for all the applications which exist in Confidential platform.
• Developed a reusable data access component
• Coordinating with client to resolve problems encountered during acceptance testing
• Enhancing the system as per the requirements and expectations of the client

Confidential

Team Leader

Environment

Software:

Languages: VB,C#

Database : SQLSERVER 2000

Tools: Visual Interdev, Microsoft.net Framework, XML

O/s: Windows 200

Hardware: Pentium 4

Responsibilities:

• Worked on Requirements phase of Easy Sell package
• Understanding and preparing the design document by analyzing the functional specs.
• Preparing the prototypes based on requirements provided.

Confidential

Senior Software Engineer

Environment:

Languages: ASP.NET,C#,ADO.NET

Database: AS/400

Tools: Class libraries provided by GWS

O/s: Windows 200

Hardware: Pentium 4

Responsibilities:

• Development of Technical architecture.
• Development of Modules.
• Validating the UI Prototype.
• Preparation of Test Plans.

Confidential

Senior Software Engineer

Environment:

Languages: C#

Database: SQL SERVER 2000

Tools: ASP.NET,ADO.NET

O/s: Windows 200

Hardware: Pentium 4

Responsibilities:

• Involved in the development of ASP.NET pages using C# language Development of Modules.
• Developed a calendar control using JavaScript
• Preparation of Test Plans.
• Involved in writing stored procedures
• Developed UI using Web Forms Server Controls, Validation Server controls
• Handling compatible issues for both Netscape and IE
• Done Client-side validations in JavaScript.

Confidential

Analystic Programmer

Environment:

Languages: C#

Database: SQL SERVER 2000

Tools: ASP.NET,ADO.NET

O/s: Windows 2000

Hardware

Responsibilities:

• Involved in the development of ASP.NET pages using C# language
• Preparation of Test Plans.
• Involved in writing stored procedures
• Developed UI using Web Forms Server Controls, Validation Server controls
• Done Client-side validations in JavaScript.

Confidential

Analystic Programmer

Environment:

Languages: vb script, java script

Database: SQL SERVER 2000

Tools: ASP, Html, Dream weaver.

O/s: Windows

Hardware: Pentium 4

Responsibilities:

• Involved in Designing of administration modules, design and coding
• Done Client-side validations in JavaScript.

Confidential

Analystic Programmer

Environment:

Languages: Visual Basic 6.0

Database: Access 97, Oracle, Sybase Adaptive Server

Tools: Sybase Power Designer

O/s: Windows

Responsibilities:

• Creating Interfaces to other systems like Mesonic, KHK etc
• Creating update programs for various customer databases
• Adding new functionalities to existing product to make user interface simpler
• Creating wizard for replicating the Confidential database