Experience

• 

  WIS Group Ltd

  • United Arab Emirates

  • Program Manager

    • May 2022 - Present
    • United Arab Emirates

• 

  GEMS Education

  • United Arab Emirates

  • Product Officer / Business Analyst

    • Nov 2021 - Mar 2022
    • United Arab Emirates

• 

  Wolke Business Applications

  • Dubai, United Arab Emirates

  • Project Manager

    • Oct 2016 - May 2018
    • Dubai, United Arab Emirates

    • Manage Client Relationships, Requirement Analysis and Design, Product Customization, Projects Implementations.• Thorough understanding of HR Processes - Core HR, Workforce Planning, Payroll, Talent Management, Employee Benefits, Time & Attendance, Learning & Development.

• 

  PNC

  • Mumbai Area, India

  • Business Analyst and Project Lead

    • Jan 2010 - Oct 2015
    • Mumbai Area, India

    • Build robust data warehouse (1TB) from various loan origination and servicing system in a batch and real-time process.• Develop and Design ETL Process, SSIS packages, SQL objects, query performance analysis and tuning, convert data mapping document to SQL code, • Design and deploy webservices and websites, automated notifications & monitoring.• Offshore Project Delivery Manager, Support and Maintenance management, Environment and Deployment Management, Grooming Team, Conduct brainstorming sessions, Strive for more business from Clients and Strengthen Client Relationship.• SQL Server, Advanced T-SQL, Query Analyzer, SSIS, Datamart,SQL Agent, BIDS, TFS, .NET, C#

• 

  Tata Consultancy Services

  • Project Manager

    • Jan 2010 - Oct 2015

    o Project involved building a robust data warehouse for a US bank to integrate data via ETL from various loan origination & servicing system in batch & real-time load.o Developed and reviewed various SQL objects, SSIS packages , designed the database, partition scheme, query optimizations and deployments across 7 database environments.o Optimized the load of 4GB data file by 1 hour daily by analyzing the data and changing the database design using low and high volatile tables.o Designed application flow, UML diagrams and developed Web applications and Windows Services to track ETL load and to automate the notification process.

  • Associate Consultant

    • Jun 2006 - Oct 2015

    • Recognized as a High Performer for 4 years and received "BEST Team Award" in 2015• Experience at onshore location (Columbus, USA) for 2 years while managing client interface and was successful in bringing various projects to offshore and build an offshore team• Delivered solutions & growth while developing & grooming a team with resources from diverse technological backgrounds

• 

  National City Bank

  • Analyst and Developer

    • Jun 2006 - Dec 2009

    • Loan Origination Products, Mortgage System, Mortgage rules, Pricing and Products, Corporate Sales, Tax, SOX Compliance, Finance Systems, Condo Project Approval systems.• Developed, designed and deployed website (UI and code), customized and upgraded product solutions, build deployment module, wrote test cases, unit and system testing, defect fixing, impact analysis, CRs and ticket resolutions, managed client relationship.• Received "Best Debutante Award" , "On the Sport Award" and many client appreciations.• SQL Server 2000-2005, Oracle 10g, .Net, C#, VB.Net, HTML, Unix