SUMMARY:

• 16+ years of IT experience being a Portfolio Manager specializing in Data warehousing and Business Intelligence and ETL integration solutions with experience in implementing full life cycle of the software development processes including requirements analysis, prototyping, POCs, design, interface implementation, development, Production support, testing and maintenance.
• Established track record of driving strong business results in dynamic environments through strategic planning, building and motivating teams, assessing technical capabilities and managing Global Solutions Delivery, IT Operations and Client Relationships.
• Extensive experience in providing Leadership to several high value projects with focus on Software Development, System Integration and Implementation. Possesses excellent communication, presentation & interpersonal skills. Recognized as a leader with the ability to collaborate with multiple business units to define the scope of a project, develop case models, create diagrams, and analyze supplemental specifications in support of project scopes. Excellent track record of managing complex projects with demonstrated ability to define and map project scope, specifications, timelines, resources and budget requirements.
• Architecture, Hipaa and other healthcare compliance, development, implementation and integration projects spanning numerous platform and operating systems.
• Actively involved in project management role managing larger teams and coordinating client relationship, setting expectations with client and other stakeholders and reporting project status to the leadership. Recognized as a creative and effective strategic planner and problem solver who excels at turning individuals into teams that work efficiently and exceed expectations.
• Extensive Experience in Banking & Financial and Health Care domains with processing of data related to AML, Sanctions, Customer Data Integration using ETL strategies and handling data related to Risk Management (Implementation of BASEL II norms), Customer Data Integration, Credit Cards, Partnerships, Home Loans, Origination/Servicing and Auto Finance along with Health Insurance domain.
• Skilled in Data Migration, Integration across Legacy and Modern technologies using cutting edge tech solutions. Possess the ability to acclimatize to new technologies, conditions and situations with ease.
• Experience of working in AGILE using SCRUM methodology with expertise in facilitating various SCRUM ceremonies.
• Strong leadership skills managing Application, Infrastructure delivery and Support and hands - on experience in process management, team building and delivering value.
• Information Builders, Omni-Patient Omni Framework: EMPI enterprise master patient index,Iway Data integration, Data Quality and Master Data Center.
• Have strong knowledge in developing and Performance tuning of Ab Initio graphs. Reviewing ETL graphs and Unix Scripts.
• Have strong experience in ETL Design, Development, Data Analysis, Requirements Gathering, Gap Analysis, Production Support, Incident/Problem Management, Release Management, Configuration Management, and Testing.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Worked extensively on application maintenance tasks such as requirement analysis, functional studies, estimation, design, coding, testing, implementation, 24/7 L3 support and quality reviews.
• Organized and detail-oriented, able to work well under deadlines in a changing environment and perform multiple tasks effectively and concurrently.
• Program Management, Requirements Management, Knowledge Management, Configuration Management, ITSM (IT Service Management), Test & Defect Management, Estimation & Resource Planning, Technology Trends, Data Profiling and Analysis, Service Support & Maintenance, Scrum Master
• Innovation, Effective Communication, Client Focus, Managing Teams, Collaborative Leadership, Relationship Management, Strategic Leadership
• Reduced Overall AMS incidents by22% YOYby implementing 45+ defect fixes, 25+ CSIs.
• Handled Application development, maintenance and innovation for a portfolio of 150+ applications.
• Managing application uptime of99.5%with SLA management at 100%.
• Critical Monthlybatch cycle period reduced from 8 to 3 business days by streamlining the batch jobs which helped customers to add new critical business accounts.
• Completed9 CSIs since Jan 2021, Overall savings of89 hoursof AMS effort and reduction of34 tickets per month.
• Monthly data issuesvolume reduced from800+in +in 2021 by implementing number of production defects.
• Revenue growth.
• Leading a large team of 40+ Professionals at Onsite and 60+ Professionals at Offshore.

TECHNICAL SKILLS:

ETL Tools: Ab Initio, Datastage

RDBMS Known: Teradata v2R16, SQL Server 2008, ORACLE 9i, DB2

Data Warehousing Concepts: Dimensional Modeling, Metadata management & analysis, Star & Snowflake Schema, SCD, ETL, Data lineage and profiling.

Languages Known: SQL, UNIX Shell script, Python

Other Tools: HP Service Manager, Version One (Agile), Jira Scrum Board(Sprint Planning Agile), Service Now, AYS

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Responsible for overall management of project to meet objectives and impact to current deliverables as well as forecasting for future scheduled deliverables.
• Work closely with multiple work-stream leads and SMEs in identifying and managing interdependencies
• Manage multiple, simultaneous, interdependent initiatives across different work-streams.
• Identify best practices and suggest improvements in the defined project management processes
• Analyze and effectively manage stakeholder expectations
• Manage project finance and report using various productivity tools
• Responsible for leading project teams, project coordination and work direction of technical staff.
• Supporting 150+ applications for Operational Data Store and propose necessary enhancement framework on Enterprise data warehouse systems.
• Analysis and continuous interactions with clients, business team in gathering business requirements and performed detailed technical and functional assessments based on business requirements.
• Ability to work both independently and in team - oriented environment ICE team member HIPAA task force.
• Documented the data Integration rules and developed new Information ETL processes which populated tables for a new Enterprise Master Index(EMPI) application.
• Identify opportunities to automate the tasks to the possible extent by leveraging proficiency with the technologies and tools and implement the same to minimize the manual intervention.
• Resolving technical challenges and providing strategic solutions for data defects/validation issues encountered while publishing the data to the business users. handling all job failures and data issues to ensure project deliverables towards the predefined timelines.
• Met corporate objectives in migrating work and reducing expenses while maintaining client satisfaction and group productivity.
• Promote teamwork, motivate, mentor and develop team members.
• Leading and managing a team of 35+ associates.

Confidential

Responsibilities:

• Led teams across broad technical, financial and business disciplines.
• Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
• Mitigated risk factors through careful analysis of financial and statistical data. Anticipated and managed change effectively in rapidly evolving global business environments.
• Develop relevant metrics that help the team see how they are progressing and provide management insight regarding the performance of the team
• Provides leadership in the establishment and development of project base line budgets, resource allocations.
• Gathered user requirements, make recommendations for system changes came up with business solutions to satisfy HIPAA requirements.
• Work with leadership and team for ongoing process improvement initiatives to implement best practices.
• Responsible for interacting with Clients and customers of Clients for gathering Business requirements to enhance the applications with new functionalities.
• Perform technical impact assessment for new requirements, prioritizing and providing support and ticket resolutions
• Debugging data issues, ETL job failures, fine tune performances by working with team to increase overall health of the system.
• Coordinating with multiple teams for deployment activities and implementing Change Requests for deployments.
• Collaboration with Offshore team for Production Support activities, status reporting and Client Deliverables.
• Provide monthly metrics reporting to customer leadership team on burn down progress and release updates.
• Effectively communicating the status of all workstreams across the projects and programs, highlighting issues or conflicts between teams to stakeholders and management.
• Leading and managing a team of 15+ associates.

Confidential

Responsibilities:

• Drive implementation of best agile practices: dynamic team collaboration, informative metrics, continuous improvements.
• Successfully delivered products meeting all goals for schedule, quality and budget within defined timelines.
• Works as a Scrum Master, conducts and effectively participates in sprint planning, task estimates, task sequencing, sprint reviews and retrospectives
• Proactively identifies and tracks project risk and develops mitigation plans to manage risk.
• Responsible for all development, testing, and implementation.
• Architecture, designed, and developed new solutions and also to support the production applications.
• Worked with the customer in strategic design process and translate business needs into technical system solutions, prepare technical documentation for developers and assisting with development of test plans.
• Enhanced existing systems by analyzing and identifying areas for improvement/modification.
• Design and developed complex PL scripts in Teradata for Home Loans Origination and Servicing.
• Interfacing offshore delivery & efforts with client expectations/requirements
• Refinement and finalizing the requirements with the product manager for a healthy and sustainable team backlog.
• Creating technical design and operational guides and transitioning support groups during production release for application handovers after regular warranty support.
• Collaboration with Data Stewardship and Risk office teams to ensure the metadata quality and modelling standards.

Confidential

Responsibilities:

• Understand the specifications of Data warehouse ETL Process. Interact with Business Analyst for requirement analysis and to define business and functional specifications.
• Involved in sprint planning and grooming to understand and define the required stories and allocate the tasks to the resources. Interfacing offshore delivery & efforts with client expectations/requirements
• Participate in Architectural Discussions and Design for database, ETL Components.
• Design, Development and Deployment Activities for specific client requirements.
• Design and develop ETL processes.
• Work closely with QA testing team to fix the issues that were reported.
• Production Support
• Root Cause Analysis
• Ensures best practices and standards are followed during design and development.
• Efficient coordination with Offshore Team by mentoring them.

Confidential

Responsibilities:

• Recovery of application specific jobs from abortions due to source/data issues to ensure their uninterrupted execution in the production environment.
• Producing daily, weekly and monthly metrics for tracking the incidents and data issues.
• Maintenance of application specific support documents.
• Co-ordination with L2 and other platform teams along with data stewards.
• Tracking of value-ads and recommendations in order to bring down the incident count.
• Problem solving skills for different Data Quality issues raised by customer.
• Solving day to day incidents so that data for different applications will be processed without any delay.
• Provided Proactive recommendations which will reduce the number of incidents.
• Implemented Change requests to avoid recurring Incidents.

Confidential

Responsibilities:

• Played the role as an ETL tech lead.
• Requirement discussions with business & SMEs for finalizing the solution design.
• Contributed in the designing phase of the Logical and Physical Data model.
• Design and developed complex Abinitio graphs along with code optimizations.
• Developed graphs in order to calculate various KPI’s of the business.
• Conducted peer reviews and leading the team.
• Actively involved in business calls with the clients in order to gather the business requirements.
• Full end to end testing so as to ensure successful deliverables.
• Acts as a mentor to the new joiners so as to make them familiar with the application.
• Participated in detailed analysis and comparison of existing data and performance tuning.
• Involved in the estimation process.

Confidential

Responsibilities:

• Gathering Business requirements, analyzing the requirements and Designing.
• Preparing the Technical design document.
• Creating jobs using the Ab Initio as the ETL tool along with UNIX, Oracle and Sybase.
• Developing Abinitio graphs for batch processing using Abinitio components like Input file, Output file, Read multifiles, Out Table, Input Table, Update Table, Reformat, Join, Lookup, Normalize, Denormalize, Merge, Gather, Roll Up, Scan etc.
• Developed Abinitio graphs for derivatives cashflows and indicatives.
• Contributed in enhancements of existing graphs.
• Actively involved in the production support for Equity Reconciliation project.
• Design and Testing of Unix Wrapper Scripts for processing the graphs.
• Actively taking care of the reconciliation matching process.
• Unit Testing