SUMMARY

• 12 years of progressive hands on IT experience with prime focus on design, development, testing, Implementation, deployment and support of client’s business applications with leading edge software and efficient maintenance of solutions.
• Experience in the design and implementation of automated Continuous Integration, Continuous Delivery, Continuous Deployment pipelines DevOps processes.
• Focused on automation, integration, monitoring and configuration management. Streamlined applications delivery to get applications out to customers faster.
• Experience in implementing and developing solutions enabling development and Operations teams to build, deploy, monitor and test applications and environments.
• Working with and supporting multiple World - wide development teams delivering a wide range of software applications.
• Six Sigma Yellow Belt Certified, technical expertise in troubleshooting principles, methodologies, and issue resolution techniques like Six Sigma, trend analysis and FMA.
• ITIL Certified, expertise in various support processes using incident Management and Change Management.
• PRINCE2 Foundation Certified.
• Excellent in Team, Crisis Management (MI), 3rd party Vendor Management, Project Delivery, Integration, and Application Development.
• Business Analyst experience with excellent communication and interpersonal skills, broad understanding of business operations and requirements in Retail, Education and Airports operations domain.
• Have good knowledge and experience in the areas of Data Warehousing Concepts & OBIEE Report development.
• Experience in ETL methodology in Data Extraction, Transformation and Loading using Informatica/ODI and creating Source/Target definitions, building Mappings/Mapplets, creating Sessions/Workflows and monitoring ETL batch.
• Highly Experience in T-SQL (DDL, DML), documentation, coding, programming and implementation of Business Intelligence solutions using SQL Server.
• Experience in SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Reporting Services (SSRS).
• Expert in T-SQL coding and testing: functions, views, triggers, cursors, dictionary, stored procedures etc.
• Experienced in designing report layouts in SSRS.
• Reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.

TECHNICAL SKILLS

BI tools: MS BI (SSIS and SSRS), Oracle BI (OBIEE/ODI), Informatica and DAC

Web Languages: ASP.NET 1.1/2.0/3.0, HTML, JavaScript, IIS5.0/5.5/6.0/7.0

DBMS/RDBMS: SQL Server 2008/2005/2000/, Oracle 8.0/8i/11g

Reporting Tools: Crystal Reports, SSRS, Oracle Forms and Reports

Tools &Utilities: Visual Studio.Net, VSS, SVN, BMC Remedy, Cruise Control

Languages: VB 6.0, VB.Net, C#, XML, MS-SQL, PL/SQL, UNIX shell Script

PROFESSIONAL EXPERIENCE

Technology Team Lead

Confidential

Responsibilities:

• Responsible for analysis, system designing and effort estimation of the new enhancements and development work.
• Responsible for preparation and testing of disaster-recovery plan for all application under my control for high availability and helped other teams on disaster-recovery plan for their applications.
• Actively engaged in the technical & functional meetings with clients and vendors for the upcoming applications for smooth handover of applications to support.
• Developed metrics and used tools available in organization for code and monitor applications performance, ensuring consistent improvement.
• Successfully delivered the disinvestment process of client business for multiple IT systems which involve setting up separate instances of application on new infrastructure.
• Involved in activities like creation of functional and technical documents, creation of test cases and test plans, working within constraints like limited access to Database / environments.
• Actively involved in various phases of deployment from Development to QA to Staging and finally into Production.
• Improved the documentation of QA testing practices and code review to remove their repeatability, created saving in term of time and money. Standardization the best practices which in turn resulted into fewer defects.
• Debugging, reuse, source code management strategies and release management.
• Deployed automated build solution using Cruise control which in turn removed cumbersome and time consuming manual build process of .NET application for production release.
• Handled migration of code in versioning tool from VSS to SVN.
• Expertise in ETL methodology in Data Extraction, Transformation and Loading using Informatica and creating Source/Target definitions, building Mappings/Mapplets, creating Sessions/Workflows and monitoring ETL batch.
• Hands-on experience in creation of iBots and integration of the same with Informatica ETL jobs.
• Experience in creating executive reports withBI Publisherintegrated with OBIEE.
• Installation and Configuration of OBIEE 11g.
• Developing business layer mapping via RPD in Oracle business intelligence enterprise edition (OBIEE).
• Developing presentation layer reports using OBIEE.
• Experience in creation of ad-hoc reports, charts, graphs, and design of customized interactive dashboardsusing drill down, guided navigation, prompts, filters, and variables.
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
• Expertise in Configuring Repository and Create/Manage Dashboards, Reports/Answers.
• Proficient in Merging/Importing Objects from Different Repositories using OBI Admin Tool.
• Knowledge in Scheduler setup and iBot Configurations for delivering reports using Oracle BI Delivers component of OBIEE.
• Experience in Migration from QA to prod servers.
• Review, Unit testing and QA testing of ETL mappings and Reports, Defect logging /tracking and following them to closure.
• Innovative Accomplishments and Rewards
• Received Confidential AO Star Award for outstanding performance and implementation of innovative and best practices approach on reduction in ticket count and successful migration of IT applications on to new infrastructure as part of disinvestment work.
• Leaded initiatives to restructure/upgrade legacy software product to new version/new tool so to reduce maintenance cost and increase availability of system with goal of 100% uptime through project work which in turn generated revenue for accounts and increased client satisfaction.
• Analyzed portfolio applications tickets data to identify the areas of concern and assisted other TL’s in implementations of improvements resulted from analysis in their respective applications.
• Batch Performance Improvement - Improved nightly batch performance by about 30% which in turn increased the Up time of application which provided application user’s better insight into airport operation data during opening hours and removed manual work done by customer, resulted in savings of 1 FTE to client.
• Conducted database management, performance measurement and performance tuning on existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager. Optimized SQL queries for improved performance and availability. Identified bottlenecks across the system and fine-tuned the components for performance optimization. Potential benefit to client by boost in application performance and reduced repeated ticket counts by 10% on support team.
• Performed Six Sigma analysis on auto generated alerts tickets for whole account and implemented/suggested fix which reduced in coming auto tickets by 60% YoY, potential savings of about 2 FTE Year to project.
• Performed Failure Mode and Trend analysis on user tickets for identification of problem areas on 4 important applications and suggested and implemented fix/developed tools which reduced tickets by 40% yearly, potential savings of about 2 FTE/Year to project.
• Analyzed portfolio applications those supported by 3rd party vendor which internal support team can support which provided potential saving to clients and increased revenue for account. Successfully completed the handover of 8 applications to internal support team from 3rd party vendor.
• Worked on migration of Excel based tools/applications into web-based tool using .NET which benefited account/clients on improved visibility on tracking of statuses and actions in more robust web-based tool with enhanced reporting.
• Part of IMSC initiative which focuses on encouraging cross training/ knowledge/ resources sharing between different accounts for better utilization of existing resources.
• Developed online tools for 1st line support team, resulted in potentials reduction in 2nd and 3rd line application supports team tickets by 30% for three priorities 1 application which in turn helped PM to utilize 2 support resources for other activities.
• Developed web-based Dashboard Tool for auditing/health checks using SSRS and .NET for DBA and application support team for enhanced monitoring of automated scheduled DB/Apps Jobs with functionality to send scheduled email alerts in case of any fault for debug / resolve issues faster - Potential benefit to client by boost in application uptime and reduction in support tickets because of early warning. Potential savings of 2 FTE / Year as previously all these health checks have done manually by support team by logging onto several applications and DB servers.
• People and Operational Management
• Handled team of 8 resources and responsible for managing support/development activities in accounts for all Microsoft technology applications. I was also responsible for team career management activities like goal setting, mentoring, counseling, performance evaluation and training plans of team members.
• Onsite POC and offshore coordinator for all Microsoft technology development work in account.
• Acted as a Liaison between the business and the IT teams to build relationship and engage business users in evaluating new technology changes.
• Assisted PM in maintaining project schedules, work breakdown structures, issue/decision logs, meeting summaries and status reports to ensure effective, ongoing communications across all team members.
• With Technical and functional expertise of the system assisting other teams on various ongoing and new works in domain or application functionality to complete project design and build/testing phase activities as required with ease and on time.
• Collaborated effectively with projects, product and program managers to ensure project deliverables remained on track and aligned with business goals and expectations.
• Actively involved in improvement of Problem management and Change management process.
• Received special recognition from client for work delivered as part of batch Performance Improvement and DB query optimization which improved the application performance by 30%; this was pending from long time and causing lots of trouble to end users.
• Enhanced end users' understanding of systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials like how to Guides.
• Responsible for monthly review meeting with senior client management to provide ongoing, at-a-glance summaries of activities/issues status and applications performance leading to enhanced customer satisfaction.
• Improved communication between product managers and the software development team by modeling requirements in use cases and holding combined walk-through meetings, resulting in fewer issues in test.

Senior Onsite Support Analyst

Confidential

Responsibilities:

• Performed Failure Mode and Trend analysis on user tickets for identification of problem areas on 4 important applications and suggested and implemented fix/developed tools which reduced tickets by 30% yearly, potential savings of about 1 FTE/Year to project.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager. Optimized SQL queries for improved performance and availability. Potential benefit to client by boost in application performance and reduced repeated ticket counts on support team.
• Involved in tracking and documented the problem-solving process, including all successful and unsuccessful decisions made, and actions taken, through to final resolution.
• Analysis of the new enhancements from the Client for application and implementation.
• Involved in activities like creation of functional and technical documents, creation of test cases and test plans, working within constraints like limited access to Database / environments.
• Involved in analysis and solution design of migration of old Excel based application to web based tool using.NET technologies.
• Analysis of raw data, drawing conclusions & developing recommendations
• Debugging, reuse, source code management strategies and release management.
• Designed integration of various systems taking into consideration their interdependency. Identified bottlenecks across the system and tuned the components for performance optimization.
• Taken care of CR (Change Request) and Major Incident.
• Creation of new stored procedures and modification of existing ones for various applications as well as wrote modules, classes designed forms and used ADO to retrieve data from database.
• Improved communication between product managers and the software development team by modeling requirements in use cases and holding combined walk-through meetings, resulting in fewer changes in test.
• Enhanced end users' understanding of systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials like how to Guides.
• Conducted workshops with business representatives for changes in critical business processes
• Liaising with end-users and 3rd party suppliers for new application deployment.

Support Analyst

Confidential

Responsibilities:

• Received Confidential Project Star Award for excellent performance and successfully delivering innovative approach on reduction in ticket count using FMA technique.
• Successfully managed the roles of Onsite (UK, London) POC.
• Developed online fault investigation and resolution tools for first line support to improve the service which reduced ticket counts on 2nd and 3rd line support team, potential saving of 1 FTE YoY.
• Designed integration of various systems taking into consideration their interdependency. Identified bottlenecks across the system and fine-tuned the .NET and SQL components for performance optimization.
• Understand the overall business so that identification of processes becomes simple.
• Database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager. Optimized SQL queries for improved performance and availability. Potential benefit to client by boost in application performance and reduced repeated ticket counts on support team.
• Responsible for the development, and implementation of the end-to-end project solution, including creation of the low level functional specifications, and test plans.
• Responsible for development of various modules in this application which include GUI or Front End development using VB, COM,.NET technologies and Database or Back End development in SQL 2000/2005.
• Handled complete configuration of customized/new tasks and loading process through Control-M jobs.
• Analyzed the enhancements coming from the Client for application and implemented the same.
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Understand the Business requirements and estimate the effort for the new requirements.
• Trend analysis of defects/logs for identification of problem areas and to improve productivity.
• Coordination with other module leads from co-vendors / clients
• Assists other members in project team in domain or application functionality to complete project design and build phase activities as required project.

Application Developer

Confidential

Responsibilities:

• Understand the overall Investment Management business so that identification of processes becomes simple.
• Involved in Analysis Phase to gather the requirement provided by user and prepare the functional document.
• Interacting with BA’s and downstream end users to understand the requirements clearly.
• Performance tuning of new or existing application wherever required.
• UI Designing and Coding as per the specification
• Involved in understanding of the existing application
• Involved in preparation of Low-level design
• Code Review for the coding standards and code optimization.
• Create the Unit Test Cases and done SIT testing.
• Configuration management using tools like VSS.
• Understand the Business requirements and estimate the effort for the new requirements.
• Assists other members in project team in domain or application functionality to complete project design and build phase activities as required.

Developer and Support Analyst

Confidential

Responsibilities:

• Responsible for development of various modules for application which include the new development and reports.
• Understand the Business requirements and estimate the effort for the new requirements.
• Trend analysis of defects/logs for identification of problem areas and to improve productivity.
• Working as Support Analyst for production support and resolving the P1 calls.
• Estimation and development work on new CR (Change Request).
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Creation of Unit Test Cases for testing purpose.
• Performance tuning of the application wherever required
• Performed System improvement wherever required.