SUMMARY:

• Over 10+ years of Information Technology experience in media and hotel domain in the field of software project management, handling projects with international clients, project design, and development.
• Worked with IGATE global Solutions for the client MGM Resorts International Operations - Las Vegas and worked with NBC Universal, Los Angeles, CA and in Mexico and Working with Farheap Solutions(Las Vegas).
• Currently Working as a Business Intelligence Analytics- Senior Manager, managing Data Warehouse Projects, SSIS, SSAS, Power BI, R, SAS projects.
• Has extensively worked in VB.Net, Crystal Reports, SQL Server including 2000, 2005 & 2008 as the technological base. Has handled Website creating Project in PHP, Drupal, Joomla, and GWT.
• Experience in handling Data warehouse Project, SSAS Project and Analysis and reporting projects.
• Experience in Migration of data from Excel, Flat file to MS SQL Server by using DTS and SSIS. Experience in Extraction Transformations and Loading (ETL) cycle based on SQL Server 2000 native stored procedures as well as SQL Server Integration Services (SSIS).
• Experience in all phases of project life cycle starting from business requirement gathering and analysis, dimensional modeling, iterative development and testing the entire system for final implementation and ensuring delivery of projects within the time & cost
• Experience in designing and developing the solutions and software applications applying SDLC - Waterfall, Iteration, Agile, Scrum.
• Communicating with all Stakeholders, stayed in budget and on schedule for all projects with Six Sigma, Resource creeping, Crashing, fast tracking based on schedule and budget.
• Working closely with Marketing to work on contracts and performance analysis, schedule the project based on Market demand and Business need.
• Collaborate with senior management, functional managers and project managers to plan business and technology initiatives and budget.
• Has extensively worked in Project Estimation (Cost and Man power) and sign off estimates

HIGHLIGHTS:

• Resource Planning
• Requirements Gathering
• Scheduling
• Analysis
• Estimation
• Design & Development
• Review, Testing
• Configuration Management

TECHNICAL SKILLS:

• SQL
• Web Analytics, GA, Adobe
• Data warehouse
• Finance Analysis
• SSIS,SSRS,SSAS
• Marketing Analysis (Adwords, Affiliate, Display,Social)
• Power BI
• R, SAS
• .Net

PROFESSIONAL EXPERIENCE:

Confidential

Environment: DWH, SQL, Reporting and Analysis

Roles and Responsible:

• Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives
• Drafted project charter and defined the scope of the project.
• Created the Workbreak down structure.
• Cost estimates based on analogous, Resource cost rate and bottom up estimates.
• Defined and initiate projects and managed cost, schedule, and performance of component projects, while working to ensure the ultimate success and acceptance of the program.

Environment: Joomla, Drupal,GWT,SQL2005,2008, PHP, DWH

Responsible for:

• Involved in analyzing and discussions with the business for the enhancement and daily changes for the public website.
• Participated in review of the project charter and stakeholders’ analysis
• Has extensive experience in estimating the project and scheduling.
• Provided status reports. Provided user guide for the Content Managers. Formalized and obtained final acceptance for the project
• Developed a project scope statement and WBS. Monitored project schedule, resources and resource leveling.
• Hands on experience in developing N-tier applications using .NET Framework 3.5, C# ADO.NET, Linq, WCF Web Services, JavaScript.
• Experience with SQL Server 2005, 2008 indexing and Update Status for performance improvement..
• Requirement gathering for development project like Mlife Insider Reskin, worked in estimation , coordinating with Tibco team, QA and extensively involved in environment set up for development and preproduction
• Design and Deployment iterations on all phases of the applications and production support.Peer Code Reviews, testing and coordinating for UAT signoffs.

Environment: Visual Studio 2005 ,C#.Net, MS SQL Server 2005

Roles and Responsible:

• Defined project scope. Drafted project charter.
• Evaluated the feasibility of the new project. Performed stakeholders ‘analysis.
• Participated in WBS
• Cost estimates based on analogous, Resource cost rate and bottom up estimates.
• Has worked in WPF for media services, templates and effects.
• Risk assessment is done by identifying risks, risk analysis, assessing probability and impacts and planning a risk response and implementing it.
• Utilized expert judgment to identify critical path to create buffers. Presented status to management
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc
• Has extensively worked in Project Estimation and sign off estimates like TOR,PPAR,PPDR,ASOR,DSOR.

Environment: VB Script, Java Script, MS SQL Server 2005

Responsible for:

• Worked closely with Business Analysts and gathered the requirements
• Developed Responsibility Assignment Matrix, and performed a risk analysis.
• Obtained project plan approval. Developed a change management plan
• Worked Analysis and Design of the new project/ Enhancements.
• Obtained resources through procurement plan. Provided status reports
• Development of various automated VB scripts which works on MIIS for backup purpose and validation scripts.
• Account provisioning for the users in DB, creating User Instance , configuring data directories.
• Develop, modify and optimize stored procedures, triggers, Views and SQL scripts to solve data related issues when upgrading databases from legacy to newer versions.
• Customizing various process in the project

Environment: Visual Studio 2005 ,C#.Net, MS SQL Server 2005,Crystal Report

Responsible for:

• Involved in analyzing and discussions of the business requirements and developed technical documents
• Design and Deployment iterations on all phases of the applications and production support
• Designing and developing various reports in Crystal Reports and excel reports, excel chart reports.
• Create reports as per customer requirements using crystal reports 8/11.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS.
• Assist junior programmers with scripts, SSIS projects, troubleshoot complex stored procedures and query optimization.
• Peer Code Reviews
• Worked with Functional and QA teams for testing and performing Defect fixing.

Environment: Visual Studio 2008, ASP.NET 3.5, C#, MS SQL Server 2005

Responsible for:

• Requirement Gathering and module wise estimation
• Analysis & preparing HLD and LLD Design documents
• Developed the modules with various IE compatibility and globalization and localization is done to support English and Spanish
• Writing Procedures, Triggers, Functions, Views and creation of other SQL server objects.
• Peer Code Review is done for other modules.
• Unit and Integration Testing using various explorers.

Environment: ASP.NET 1.1/2.0, C#, Crystal Report & SQL Server 2005

Developer/Sr.Developer

Responsible for:

• Requirement Gathering for enhancements
• Analysis & Design for enhancements
• Development and bug fixing, worked on crystal reports and application migration from 1.1 to 2.0 and SQL Database migration.
• Develop, modify and optimize stored procedures, triggers, Views and SQL scripts to solve data related issues when upgrading databases from legacy to newer versions.
• Unit and Integration Testing
• Co-Ordinate with Onsite for Project related activities and Client interactions.