Vikas Brahmbhatt

VIKAS BRAHMBHATT Mail:-Phone: - Experience Summary: Thirteen plus years of extensive experience in IT services with specialization in BI & Big Data. Extensive experience in Sales support, Pre-Sales and custom solutions architect as per client needs to address all business needs and adhere to government rules Performed various roles as Program management, Product manager, Service delivery lead, Pre-Sales lead and Project manager in IT services Extensive experience in Sales support and Pre-Sales life cycle to provide custom made solutions as per business needs ensuring higher win rate Experience in various project types and worked across all phases of project life cycle e.g. Scoping, Pre-Sales, Blue printing, Road map creation, Estimation and Planning, Project Mobilization, Project Development and Delivery, Support and Enhancement, Technology and Tools Migration and Upgrades, Conversion of legacy systems to Standard Products Very good exposure on analytics and process implementation using standard tools like business analysis tool and workflow management tools. Well versed with project management and UAT tools like Microsoft Project Plan, Quality Center, and Clarify. Good exposure with data modeling technique and tools like ER Win, Spread sheets and database tools Excellent understanding of various industries e.g. Lease and Loan, Insurance, Retail, Media and Entertainment…etc. Very good exposure on Enterprise Reporting and ETL with experience of end to end data warehouse implementation, technology upgrade and data conversion Experience Summary: OrganizationStart DateEnd Date Teradata India Pvt Ltd.26-Sep-201631-Mar-2017 Rolta Technologies Limited17-Dec-201531-Aug-2016 Accenture Pvt. Ltd.19-Jan-201012-Jul-2015 Capgemini Consulting India27-Oct-200818-Jan-2010 Polaris Software Lab Limited04-Jun-200822-Oct-2008 Tata Consulting Service Limited18-Dec-200304-Apr-2008 VMF Softech Ltd – Ahmedabad04-Aug-200303-Nov-2003 Educational Qualification: Bachelor of Engineering (Computer) – North Gujarat University, Gujarat, India -) Skills: Management Tools:MPP, MS Office, MS Visio, Quality Center, Clarify BIG DATA:HADOOP, HDFS Database Systems:Teradata, Oracle, MS-SQL Server Special Tools:Informatica, Business Object , Cognos ERWIN Certifications and Trainings: Internal Certification for Business analyst Media and Entertainment Teradata V2R5 Basic Certification Informatica 6 Internal Certification for Business Object XI R2 migration specialist Professional Experience Teradata, Pune, India Sep 2016 – Mar 2017 Title: Service Delivery Manager Platform: Teradata database Responsibilities: Understand client’s need and provide custom solutions to ensure 0 downtime for any production system Provide pre-sales support for every new engagement and extension of existing contracts Lead 24x7 Production operations support teams Identify and proactively manage all potential risk to ensure 0 downtime and higher customer satisfaction Ensure all production support SLA are met and value added service is provided for higher customer satisfaction Manager team expectations and ensure smooth shift coverage with minimal overhead; ensure team is engagement in full potential with career and organizations goals alignment ensuring team is motivated to ensure low attrition Proactively identify all automations and identify new sales leads within existing support structure Manage and track delivery, provide weekly and monthly reports to higher management Resource mobilization and effort estimation, tracking and reporting Manage financials of program and track effort, schedule, expense and ensure profitability margins Rolta, Mumbai, India Dec 2015 – Aug 2016 Title: Senior Manager, Solution Delivery & Pre-Sales Platform: BI & BIG DATA Responsibilities: Identify industry trends and propose additional features to existing product portfolio Identify potential leads in industry and engage in sales support activities to ensure tailored solutions are provided as part of pre-sales providing higher conversion ratio from opportunity to contract Lead pre-sales team of BI & BIG Data capabilities Mobilize new delivery projects Manage and track existing projects Identify new opportunities with in on going contracts to propose automation using Rolta’s product suites Manage and track delivery, provide weekly and monthly reports to higher management Resource mobilization and effort estimation, tracking and reporting Manage financials of program and track effort, schedule, expense and ensure profitability margins Loblaw, Mumbai, India Jul 2014 – Jul 2015 Title: Offshore AO Project Manager Platform: BODS, Teradata, Responsibilities: Understand clients need and provide custom solutions to ensure 0 downtime for any production system Provide pre-sales support for every new engagement and extension of existing contracts Lead 24x7 Production operations support teams Monitor and close all open incidents with in SLA to ensure high customer satisfaction Identify recurrent issues, perform RCA and provide solution to improve existing process or automations Review new delivery and provide approval for production deployment Manage and support all technology upgrade across environments Manager team expectations and ensure smooth shift coverage with minimal overhead; ensure team is engagement in full potential with career and organizations goals alignment ensuring team is motivated to ensure low attrition Manage and track delivery, provide weekly and monthly reports to higher management Manage financials of program and track effort, schedule, expense and ensure profitability margins KOHL’s Media Services, Mumbai, India Dec 2012 – Jun 2014 Title: Offshore Project Manager Platform: Informatica 8.1.6, Teradata, Responsibilities: Identify potential leads in industry and engage in sales support activities to ensure tailored solutions are provided as part of pre-sales providing higher conversion ratio from opportunity to contract Identify new opportunities with in on going contracts to propose custom solution based on existing infrastructure and capabilities ensuring higher conversion ration from opportunity to contract Understand business requirement for integration from source system to EDW, develop extensive RFP response in line with client’s enterprise planning, multiple release, project mobilization, efficient usage of existing infrastructure and resource mix Setup ETL architecture and process Develop project plan and execution - tracking Review and approve functional specification for ETL Review and approve ETL high and low level design Create end to end scheduling for ETL Co-ordinate day to day activities related to ETL development Project management and reporting Prepare deployment plan and execution Warranty support KOHL’s Media Services, Milwaukee, USA Apr 2012 – Nov 2012 Title: Onshore Lead Platform: Informatica 8.1.6, Teradata, Responsibilities: Understand business requirement for integration from source system to EDW and provide pre-sales support for all new releases, estimation of multiple release for ETL, resource identification and resource loading Understand business requirement and propose design solution Setup ETL architecture and process Develop project plan and execution - tracking Review and approve functional specification for ETL Review and approve ETL high and low level design Create end to end scheduling for ETL Co-ordinate day to day activities related to ETL development Project management and reporting Prepare deployment plan and execution Warranty support KOHL’s Item Services, Milwaukee, USA Nov 2011 – Apr 2012 Title: Onshore Lead Platform: Informatica 8.1.6, Teradata, Responsibilities: Understand business requirement for integration from source system to EDW and provide pre-sales support for all new releases, estimation of multiple release for ETL, resource identification and resource loading Understand business requirement and propose design solution Setup ETL architecture and process Develop project plan and execution - tracking Review and approve functional specification for ETL Review and approve ETL high and low level design Create end to end scheduling for ETL Co-ordinate day to day activities related to ETL development Project management and reporting Prepare deployment plan and execution Warranty support AGL C & I, Mumbai, India Apr 2010 – Nov 2011 Title: Project Manager Platform: Informatica 8.1.6, SQL 2005, SAP ISU Responsibilities: Understand clients enterprise plan and identify all areas for potential leads, provide pro-active solutions with proposal to ensure higher conversion rate in RFP As conversion lead understand scope and validate estimates for all phases Resource identification and resource loading Understand business requirement and propose design solution Setup conversion architecture and process Develop project plan and execution - tracking Design and develop DB for conversion Design and develop ETL Scripts Perform mock conversion and dress rehearsals Project management and reporting Foster’s GDP, Mumbai, India Oct 2008 – Jan 2010 Title: Senior Consultant, Reporting technical lead Platform: Business Object XI R3, Oracle 9i, Crystal 2008 Responsibilities: Understand business requirement and propose design solution Impact analysis Task allocation Understand current reporting requirement and propose data modeling changes Design and development of BO universe Design and development of Dashboard on crystal reports 2008 Preparation of Test cases and conducting peer review for reports Unit testing and production movement KILN, London, UK Jun 2008 – Oct 2008 Title: Data warehousing Consultant Platform: Business Object XI R2, BODI XI R2, SQL Server 2000 Responsibilities: End to end project planning with estimates and high level risk management Define road map for migration to new environment Provide consulting for all interface migration Analyze current KILN environment Identify all source system and their replacements if any Define scope for new development Design new architecture and get approvals Develop and implement new ETL and Reporting environment Co-ordinate with offshore team and review all deliverables provided by them Define release mechanism and perform phased release Weekly reporting to all project stack holders Support UAT Production movement Post-production support Colruyt, Brussels, Belgium Dec 2007 – Mar 2008 Title: Migration Consultant, Pre-Sales consultant Platform: Business Object 6.x and Business Object XI R2 Responsibilities: Analyze current Colruyt environment Identify all interface and impact analysis for the same Define scope for migration Define migration strategy End to end project planning with estimates and high level risk management Run Proof of Concept to evaluate high level risk and validate work estimate Interview application owners and developers; requirement gathering Define road map for migration Create high level business flow and case diagram Provide consulting for all interface migration Provide project management consulting and draft high level plan Hand over to delivery center for project execution SPE, Mumbai, India Sep 2006 – Nov 2007 Title: Project Manager - Offshore Platform: Business Object 5.x, 6.x and Business Object XI R2 Responsibilities: Define migration strategy End to end project planning with estimates and high level risk management Inventory the existing repositories Attend meetings with application owners and developers Define road map for migration on each application Create high level business flow and case diagram Migrate and convert reports from BO versions 5.0.x, 5.1.x, 6.5.x Full Client and Web Intelligence to BO XI R2 to both Desk Intelligence and Web Intelligence formats. Test and remediate the migrated reports so that the results match those of the report prior to migration. Log Defects using Mercury Quality Centre Ensure team has necessary tools and access Define structured process flow for easier project execution Collect statistics and validate against estimation after each application production move Identify all delta in scope and actual requirement; update estimation and get buy in from end users Prepare weekly progress and status updates; circulate amongst all stack holders GE Commercial Finance, Bristol, UK Aug 2005 - Aug 2006 Title: Project Lead / Lead Architect Platform: Oracle 9i, Oracle apps, Business Object 6.x, Informatica 6.x Responsibilities: Understanding existing business reporting needs Requirement gathering for any additional needs going further or any business critical metric definitions Proposing Design Solution and Effort estimation Project planning and team identification Define road map and high level process flow Create high level business flow and case diagram High level Data modeling and Designing of final solution Low level Data model and transform it in physical data model design Define High level design for ETL routines with error handling and atomization Define High level reporting structure as per business need Define weekly status reporting process Co-ordinate between clients, third party vendors, key stack holders and developers Assigning the work from functional & technical perspectives Ensure timely deliveries and keep progress track Log defects with Mercury Quality Centre and track till closer. Co-ordinate with onshore and offshore team and management Transitioning the knowledge to offshore team Conduct Training and Mentoring Tracking and mitigating the risks Identify new business opportunities and overall program management GE Equipment Finance, Bristol, UK Apr 2005 - Aug 2006 Title: Project Lead Platform: Oracle 9i, Business Object 6.x, Informatica 6.x Responsibilities: Requirement gathering from Business users Analyzing current reporting needs and validation against current Data availability in Data warehouse Propose alternative for design solutions Provide effort estimation for selected design solution Understanding business critical parameters and project planning Identify team and define roles and responsibilities Coordinating design and development activities Get user sign-off after each major deliverable Log defects with help of Clarify and track till closer. Coordinating and support UAT with business users Set-up process for Support and stabilize system HFS, Budapest, Hungary Dec 2004 - Mar 2005 Title: Project Lead Platform: Oracle 9i, Business Object 6.x, Informatica 6.x Responsibilities: Requirement gathering from Business users Analyzing current reporting needs and validation against current Data availability in Data warehouse Propose alternative for design solutions Provide effort estimation for selected design solution Understanding business critical parameters and project planning Coordinating with IT teams for multiple platform regarding data feeds Identify team and define roles and responsibilities Coordinating design and development activities Deployment of rapid data mart for Volume, Risk and Vendor reporting Get user sign-off after each major deliverable Log defects with help of Clarify and track till closer. Coordinating and support UAT with business users Set-up process for Support and stabilize system GE CF, Mumbai, India Dec 2003 - Nov 2004 Title: Program Analyst Platform: Oracle 9i, Business Object 5.x / 6.x, Informatica 5.x / 6.x Responsibilities: Requirement gathering from onsite coordinator Analyzing current reporting needs and validation against current Data availability in Data warehouse Propose alternative for design solutions Provide effort estimation for selected design solution Understanding business critical parameters and planning Log defects with help of Clarify and track till closer. Get tickets and support both ETL and reporting change request Provide technical support to BI users Narmada Nigam, Gujarat, India Jan 2003 - Nov 2003 Title: Quality Analyst Platform: Oracle 9i, Rational Rose, ASP.NET Responsibilities: Requirement gathering from business users Define use cases and test cases Coordinate with developers to explain functionality for each module Write functional and technical test scripts Atomize testing using rational rose Generation testing logs and circulate amongst stack holders Update project planning according to testing status