Summary

• Having 16 years of IT consulting and managerial experience
• Currently working as DWH Delivery Manager on Customer Analytics Marketing Capabilities for a Leading American Retail Chain
• Certified Project Manager and Delivery Manager. individual talent appreciation process conducted by Deloitte for the Wipro Delivery Manager and rated above ideal score of industry standards
• Worked on some of the DW implementations and migration projects for Retail and Transportation customers
• Provided end-to-end program management throughout the lifecycle of a project by managing and directing the efforts of project team of up to 100 resources and project budgets of up to 10 Million US dollars. Responsible for managing data migration project for one of the leading helicopter company in Canada.
• Received Best People Manager Award.
• Over 9 Years of hardcore experience in Mainframe Technologies. JCL, COBOL
• Over 8 years of experience in ETL Data warehousing . Extract, transform and load the data from Mainframe to Teradata tables using Data Mart using Load jobs
• Over 2 Years of Experience as a Business System Analyst and Implementation of software at various properties
• Experience in Nomad Language, Database and Reporting Tool, DB2 and Testing the Mainframe Applications
• Experience in Web focus , Bi-Query Reporting Tool, Unix , Java and Oracle
• Managed various medium to large scale projects for top US based customers like Best Buy, Bank Of America, United Airlines, American President Liners, Harrah's Entertainment Inc,, Southern California Edison
• Experienced in Retail, Airlines, Shipping, Banking and Entertainment Casino domains.
• Diverse experience across all phases of SDLC.
• Knowledge of the Systems Development Life Cycle SDLC and the process of decomposing a system using Entity Relationship and Data Flow Diagrams.
• Experience in Project management / People management /Quality Management and ensuring compliance to agreed SLA's
• Experienced in managing large application support engagements and contributed in expanding the business current engagements

Technical Skills

• Operating Systems : MVS, Windows 9.x/NT/2000/XP/2003, MS-Dos, UNIX.
• Languages and Tools : JCL, COBOL, Nomad, DB2, Focus, Endeavor, Test Director, Remedy, SPUFI, BI Query,
• Web FOCUS.
• Web Technologies : Java, HTML
• Databases : ORACLE, DB2, Teradata, Netezza MS Access

PROFESSIONAL EXPERIENCE

Confidential

DELIVERY MANAGER

Confidential is the number one specialty retailer of consumer electronics, personal computers, entertainment software and appliances in the U.S. The company's corporate headquarters are located in Richfield, Minnesota, USA.The Company operates retail stores and commercial web sites under the names: Best Buy BestBuy.com , Magnolia Hi-Fi MagnoliaHiFi.com , Media Play MediaPlay.com , On Cue OnCue.com , Sam Goody SamGoody.com , and Suncoast Suncoast.com .The company's subsidiaries include Geek Squad, Magnolia Audio Video, Pacific Sales, and, in Canada operates under both the Best Buy and Future Shop label The Company reaches consumers through more than 1,700 retail stores nationwide, in Puerto Rico and in the U.S. Virgin Islands.

Confidential

• Developed a holistic solution to integrate the customer data across all channels to provide a clean, accurate and 360 degree view of customer and enable client to perform analytics. The program involves multiple work-streams such as
• The client has embarked on a critical customer data management program to overhaul its marketing approach which will help the client to develop more targeted, relevant, personalized communications for customers. It was facing a challenge to integrate all the contacts and interactions it has with its customers before, during, and after a purchase across multiple channels such as marketing, web, phone, services and store data and get a clean and cohesive view of the customer and perform analysis. This was owing to inability of their systems to support visibility, understanding and actions across these interactions and channels.
• New data model and data quality to improve Customer Identification CID
• Store customer data using industry-leading technology in the Customer Analytics Master CAM
• Apply Predictive Modeling to give insights on consumer behaviors to complete Customer Segmentation so that the business can take the next best action through effective Campaign Management
• Achieved a milestone by completing deployment of all 47 CAM data marts and data loads as committed to the client. These CAM Marts will enable multi-channel customer insights, analysis, greater reach and relevancy of customer communications by storing customer contacts and transaction data from multiple brands and channels in a single data repository. The team leveraged IBM Netezza / Aginity, Teradata, and Informatica, IDQ data quality tool technologies for the solution.

Confidential

Executed Service Analytics

• Effectively communicating objectives, plans, status, issues and risks in a timely manner to team members, stakeholders and management in Daily and weekly status meetings to the team, Weekly status review meeting with Management, clients and various stake holder and defining the approach for mitigating the risks
• Manage client expectations and demands proactively while maintaining good client relationships, working closely with the business to ensure effective application development and delivery within the required project timescales
• Create and execute appropriate quality plans, project plans, test strategies and processes for development activities in concert with business and project management effort
• Delivery of quality applications on-time and on-budget
• Creating Project Work Order, Change Request, RICEF Estimate cover sheet, Scope document with all estimate summary and Resource Loading for the new demands and Manage and execute against project plans and delivery commitments
• Creating Project Health card for EBI with Dash board for the month on summary of In progress, Active, Closed project Accomplishments, Look Ahead Meetings, Business benefit delivered, Key Suggestion/Improvement areas and capability Demand management
• Creating Holiday readiness plan to support EBI application during freeze and lockdown application. To handle such needs, ensure team has established a process that helps to ensure visibility and better accountability for planned changes, ensure team understands the freeze dates and prepared to effectively handle issues, understands the change process during freeze, understands how to interact with command center and escalation procedure, understands the what they need to know during the holiday season
• Creating EBI release plans, release calendar, deployment schedule for the project which are going live
• Ensure all the new joiners in EBI aware of EBI ON/OFF boarding process, gone through EBI Orientation process documents. Assign a buddy to help with initial settling-in, Walk the new employee through this deck establish broad scope of role responsibilities, Inform team about arrival of new team member send an introduction on their first week in EBI
• Created the due diligence Questionnaire for Access requirements, Application walk through, Estimation process, Migration process, Service Introduction, Commercials, Data Management and Data Quality etc

Confidential

PROJECT MANAGER

• Confidential is one of the largest banks in the US and intends to transform its enterprise wide data warehousing, data movement and analytics technology environment to improve data quality and access controls, instantiate common data routines through the Data Integration DI architecture with a view to corresponding cost reduction based on the simplification.
• Application Development and Maintenance ADM which transfer the support of these environments to IBM will run the current environment while they are transformed from their current state and maintain support responsibility in the transformed state.

Confidential

• Teradata is migrated from V2R5 to V2R12 and hardware configuration node, disk types and disk capacity will be increased to support the growing needs of the business activity on the platform. Teradata will be taken offline from Jul 16 around 5 PM to Jul 20 Hardware upgrade TD will be down for approximately 20 hrs . As Application development Maintenance team supports around 420 applications which load 50 to 60 GB data everyday and we need to take care of following
• Identify applications affected by outage
• Analyze up- and downstream application dependencies
• Prepare job-hold list
• Prepare JCL overrides wherever necessary and to increase size of JCL override library if required
• Prepare and reconcile final job hold list to send to CA-7 team for all the 420 application
• Once the TD is taken online, release the on-hold jobs one by one
• Application development team will take care of application which is on warranty period

Responsibilities:

• Participating in the planning calls
• Demonstrated in-depth and detailed knowledge of all aspects of EIM leadership in planning, coordinating, executing and closing a hardware upgrade event. Including all aspects of Share Point and other support tool maintenance and upkeep.
• Assess changes based on previous H/W upgrade plans Determine new Load IDs
• Accurate and Regular reporting and updates on share point/Discovery related portals
• Provide the status report for all the application monitoring, tracking status
• Participate in technical quality reviews of own projects
• Coordinate test cases and signoff with BP.
• Documented and complete lessons learned.

Confidential

PROJECT MANAGER

• PRAS Passenger Revenue Accounting Systems consist of over 30 subsystems, which start with core PRIMS Passenger Revenue Management Systems applications and include several applications supporting Passenger Revenue Accounting Information. Passenger Revenue Accounting is a business critical function which tracks the revenue gained through the sale of passenger travel and its associate revenue related functions. Some of these associated functions are:
• Government reporting of revenue, tax and travel based information.
• Interline settlement due to passenger travel
• Passenger refunds
• Employee pass travel

Responsibilities:

As a Project Manager was involved in below activities

• managed the team and ensured the process by which projects are defined, planned, scheduled, monitored, controlled, evaluated the activities to ensure that the stated objectives of a project are achieved and delivered on time and to the specified cost, quality and performance
• oversee the execution of entire project, including hiring members of the production team, assigning tasks, organizing and scheduling the writing and production process, and attending to all meetings
• Maintaining strong relationships with several key Client managers, Business user at United Airlines by providing resolutions on time, client focused, value adds to client, broadening the knowledge on different technologies, domain, client business, understanding of the industry issues and the key business stakeholders needs.. These business contacts initially developed from extensive assignment experience in the implementation PRAS wave I project which resulted in the winning of a significant further assignment from United Airlines.
• Participated in technical quality reviews of own projects
• Preparing System Appreciation document for all PRAS Application and involved in Gathering Requirement, Reviewing and Validating the requirement Details and Preparing HLD and DLD's and Code Review, Test Plan and Result reviews
• Transitioning the knowledge to Infosys offshore team on mainframe and open system application
• Providing technical and user support of all PRAS Mainframe and Open system Application
• Developed and Used Knowledge Asset to find appropriate examples of deliverables that provide some guidance for similar projects and adopting best practices from similar projects and so on.
• Have contributed deliverables to Knowledge Asset databases in the past and Documented all the learning and shared the knowledge with the team regularly during knowledge sharing sessions
• As the project aimed at an productivity improvement of 5 one of the strategies identified is 'usage of tools and automation' and 'Usage of reusable components'. The strategy also include beneficial processes like usage of templates for similar programs for improving productivity, implementation of group reviews for every complex program to improve review effectiveness and quality Tools and automation
• Made sure that the team goals are totally clear and completely understood and accepted by each team member

Technologies used : Mainframe JCL, COBOL, DB2 and Open System Application UNIX, Java

Confidential

PROJECT MANAGER

• Confidential is one of the largest electric utilities in the U.S., and the largest subsidiary of Edison International. It supplies electric power to 13 million individuals, 430 cities and communities, 5,000 large businesses, 280,000 small businesses in areas of central, coastal and southern California. The other businesses of Edison International includes Edison Mission Energy which is an independent power producer, and Edison Capital which invests worldwide in infrastructure and energy projects
• Care Phase II - Confidential- The main purpose of this development project is to correct the process related loopholes in IQP Income Qualified Program Processing so as to bring in consistency, data integrity and more automation.

Confidential

PROJECT MANAGER

Communication Utility is the Point Of Arrival POA platform for all outbound communication from American Express. The communication can be addressed to Amex card members, Amex customers, Amex merchants etc. The communication can be letters, emails, faxes, pagers, text messages etc. As of now, Communication Utility is doing only letters and emails, but there are projects underway to send out faxes, pagers etc. The communication is generated automatically, triggered by some Business event. For instance, if an Amex card member defaults on his payment for the card, a letter/e-mail is generated to that card member CM , reminding of the missed payment and asking to pay immediately.

Confidential

TECHNOLOGY LEAD

• PRAS Passenger Revenue Accounting Systems consist of over 30 subsystems, which start with core PRIMS Passenger Revenue Management Systems applications and include several applications supporting Passenger Revenue Accounting Information. Passenger Revenue Accounting is a business critical function which tracks the revenue gained through the sale of passenger travel and its associate revenue related functions. Some of these associated functions are:
• Government reporting of revenue, tax and travel based information.
• Interline settlement due to passenger travel
• Passenger refunds
• Employee pass travel

Confidential

BUSINESS ANALYST

• Confidential is the world's third-largest gaming company behind Park Place Entertainment and MGM Mirage , Harrah's is a geographically diverse casino company: it owns, operates, and/or manages about 26 casinos under the Harrah's, Harvey's, Players, Showboat, and Rio names in 13 US states. Its operations include casino hotels, dockside and riverboat casinos, and Indian gaming establishments.
• Confidential, it is attempted to deploy the HETCMS system at various Harrahs properties. In the NV Marketing track of HETCMS, the differences that are classified under the marketing functionality of CMS have been identified for implementation. These changes that are to be implemented should be driven either by regulatory requirements or critical business needs.

Responsibilities:

• As an Onsite Business System Analyst I involved in Environment Set up, System, Integration, Regression testing.
• Coordinating with business at various properties to understand to production bugs and fixing the production issues at the Casino.
• Recognize the unit, regression, system, integration and acceptance testing
• Identify any fault and oversights or to verify the system is functioning correctly
• Evaluate the business requirements for testability
• List out the errors and exceptions that impacts the business
• Improve the testing processes by capturing and using the testing metrics
• Fixing the production issues at the Casino
• Document the existing AS IS business process
• Use the AS IS business process model to prepare business process problems
• Track the ongoing process

Confidential

• As a Application contact was involved in below activities
• Ensuring the quality of deliverables
• Analysis, Coding and Testing as part of maintenance
• Enhancements as a part of maintenance
• Creating the test plan
• Coordinating with onsite to understand the business requirements, and helping them in completion

Confidential

• Confidential is part of the Neptune Orient Lines NOL group a global transportation company engaged in shipping, logistics, ocean transportation and related businesses.
• NOL1019 is a maintenance project to maintain different applications of APL. The project handles Production support, Maintenance and enhancement requests for the applications namely Tariff Online Pricing System, Rate management system, Bid transaction system, Customer Profile, Customer account Profile, Sales Tracking and Reporting, Revenue Accounting System, Quote Transaction System, Pricing Tool, Journal of Commerce and Siebel which cater to Pricing, Sales and Marketing needs of APL.

Responsibilities:

• Sr. Analyst / Lead Developer. Involved in Coding and Testing as a part of Maintenance.
• Involved production Support of Sales and Marketing Applications.
• Enhancing the Sales and Marketing Application