Vivek Singh Email & Phone Number

Moncton, New Brunswick, Canada

Toronto, Ontario, Canada

Franklin, Wisconsin

Requirement gathering from metrics owners to understand the analysis that is expected out of the data. Developing business logic for importing the data for such analysis.Developing data labs to store data from diverse sources including flat flies, spreadsheets, different RDBMS databases such as Sybase, DB2, and SQL Server.Utilizing ETL tool SSIS for developing the Data warehouse loads with Data Acquisition and Data Integration.Worked with Agile Methodologies for planning of work and participated in bi-weekly sprints for completing assigned user story. User Jira and Kanban bords for monitoring the progress.Designing confirmed and traditional ETL Architecture involving Source databases such as DB2 , SQL server and Target databases such as SQL server, XML and Flat Files ( fixed width , delimited )Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements. Designing and developing complex mappings applying various transformations such as lookup, sequence generator, aggregator, rank, stored procedure, joins and sort transformations.Work with Entity Relationship (ER) Diagrams, Star and Snowflake schemas.Create database objects such as tables, views, stored procedures, Triggers etc.Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints. Identify columns for Primary Keys in all the tables at the design time and create them.Developing tabular model on the relational tables to generate the analysis, and developing quad chart reporting based on these tabular models.

Columbus, Ohio Area

New Delhi Area, India

1. Budgeting for the new financial year for marketing activities.2. Analysis to determine the impact of marketing activities.3. Tendering/ evaluation for empanelment of advertising agencies.4. Marketing through TV, Radio, newspaper and magazines.

New Delhi Area, India

1. Created numerous simple to complex queries involving self joins, correlated sub queries and XML techniques for diverse business requirements. 2. Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.3. Designed SSIS (ETL) Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2008R2.4. Created the packages in SSIS (ETL) with the help of Control Flow Containers, Tasks and Data flow Transformations.5. Conducted the Error handling in SSIS (ETL) using the Event Handlers.

Dallas/Fort Worth Area, Texas, Usa

1. Carried out Profitability Analysis of routes and networks with sensitivity analysis for fuel price, load factor and yield and recommended three new routes in European Market to increase profitability.2. Priced and analyzed new routes and existing routes and used this to analysis to recommend discontinue / continue the service in several routes.3. Analyzed American Airlines’ revenue premium with the industry in different market segments including North American, Latin American and European routes.4. Analyzed the impact of charging excess Baggage fee on revenue generation and resulting change in route performance in various markets to change flying pattern.5. Analyzed and tracked Jet Blue’s performance for benchmarking revenue items and cost items. Benchmarked performance parameters for improvements in American Airlines’ performance.6. Coordinating with various departments for monthly close activities

Dallas/Fort Worth Area, Texas, Usa

1. Developed financial models to analyze economic situations for pharmaceutical executives and developed optimum investment portfolios for them. Researched industries for growth opportunities.2. Conducted due diligence on prospective acquisition targets to find synergy and cultural fit between companies.3. Developed a model for progressive passive investment in advisory firms for ownership transition to new stakeholders. Involved in financial modeling for prospective firm acquisitions in investment advisory firms.

Mathura Area, India

1. Forecasted maintenance expenditures and prepared annual maintenance budget.2. Conducting internal audit of work procedures for environmental safety.3. Planned maintenance activities for each quarter.

Panipat Area, India

1. Managed power distribution substations operation through on-line data and parameter analyses. Remained actively involved in implementation of SCADA systems in substations.2. Involved in the development of documentation for OHSAS 18001 for electrical maintenance department. Coordinated safety audit for captive thermal power plant by DNV, our external auditor.3. Learned SAP modules for maintenance and operations for generating/ completing maintenance work requests and generating materials issue requests/ use reports. This helped in better time management for on-time maintenance and better material procurement and inventory control.

Certification, It- Business Analysis

Master Of Business Administration, Finance

Bachelor Of Engineering (B.E.), Electrical Engineering