Sr. Consultant Resume
Fairfax, VirginiA
SUMMARY:
- Senior - level Information Technology Leader with a combination of leadership, business, and technical expertise.
- Over 17 years of proven experience in software development, management of large application development projects, project leadership, and vendor management for various verticals including E-Commerce, Banking, Insurance, and Telecom/Mobile Applications.
- Involved in all phases of software development life cycle (SDLC), from requirements gathering through implementation, on large-scale, mission critical processes.
- Extensive experience with MDM
- Worked extensively on creating Business Cases for Information Systems projects.
- Excellent understanding of business requirements development, data analysis, business/technical liaising, and workflow.
- Lead and managed business, technical and functional team deliverables, plans, risks, quality and processes.
- Extensive experience in scope analysis, budget planning, activity estimation, staffing and .
- Problem solver with out of the box thinking with a strict focus on bottom-line results.
- Incisive ability to make tough business decisions to transform organizations with forward-thinking strategies.
- Build a culture of enthusiasm and excellence through exceptional leadership of people.
- Record of driving profitable revenue growth from the ground up through clearly defined strategies and thoughtful management of P&L and investment budgeting.
- Managed Data warehousing, Business Intelligence, Reporting, Migration, Development, QA, Validation and SCM teams.
- Created and executed various documents and process like RFI, RFP, NDA, SOW, SOP and POC.
- Experience on SDLC, Scrum and Lean process.
- Strong technical background in Cloud (SaaS and PaaS) Architecture, Database (OLTP & OLAP) Architecture and Java and .Net service oriented architecture.
- Experience leading enterprise Software, IVR, Digital and Online Projects, Infrastructure, Web, Shared Services, Cloud & Infrastructure, Data architecture and Data Warehouse projects for ODS, Datamart, and Data Warehouse data including designs for Reporting Layer.
- Defined Enterprise Reporting Strategy that enables an end-to-end approach for gathering reporting requirements, report design and creation, user adoption and, security, distribution, and presentation.
- Expertise in IT Management Functions, PMO operation, Cross Functional Projects, Strategic planning, Technology selection, Resource planning, Cost and ROI analysis and Staff development.
- Extensive experience in Requirements Gathering, Gap Analysis and Re-engineering business process to strategically focus on critical business functions. Developed Business Requirement, Functional Specification, Project Plan and Schedule and SLA documents. Developed PMP/PMBOK specific documents for project communication.
- Conducted Confidential, Requirements & Design Review, Sign-off and Checkpoint meetings. Successfully Managed UAT and Production cutover activities. Coordinated UAT & Conference Room Pilots.
- PMP in progress.
TECHNICAL SKILLS:
Project Management Areas: Requirements and Development Management, Release management, Quality Assurance, Change Management, GAP Analysis, Risk Management, System Security Plan, Budgeting
Databases and related tools: Oracle 11g, MS SQL Server 2014,TOAD, PL/SQL Developer, SQL Loader, SQL Navigator
Profiling: BO DQ 11.7
ETL/Data warehousing Tools: Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administration Console), Mapping Designer, Warehouse Designer, TOAD, SQL Navigator, Informatica Analyst
Programming: SQL, PL/SQL, SQL*Plus and HTML
Operating System: Windows 8, DOS, Linux
BI Reporting: Cognos Reporter, Crystal Reports XI, Microsoft SQL Server Reporting Services/Analysis Services
Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, MS Access
Project Management & Business Process Tools: MS Project 2013, Planview, Primavera, RFP, RFI, SOW, Excel, UML, Rally, ERWIN, Oracle Designer, VISIO
Tools: Clear case, Sharepoint
PROFESSIONAL EXPERIENCE:
Confidential, Fairfax, Virginia
Sr. Consultant
Responsibilities:
- Performed cross impact and feasibility analysis for vendor selection.
- Developed the Physical Data Centre to Cloud architecture Gap Analysis, Goodness Parameters, and SWOT analysis.
- Developed Enterprise Project Life Cycle (EPLC) Risk Management Plan for the HHS hosting project in Amazon Web Services (AWS).
- Developed and maintained Work Breakdown Structures (WBS), timelines using MS Project, Excel and as well as Trello.
- Maintained project Budget and communicated with the team regarding hardware disposal, and software licenses.
- Developed the EPLC System Security Plan for the move to cloud architecture from the current physical architecture.
- Communication with AWS on the technological features and aspects on the service.
- User Profiles & My Site configuration within Central Administration including customizing User Profile Service & Properties for the Hosting Project.
- Create, modify, and delete Sharepoint accounts and in compliance with all standard operating procedures.
- Experience working with stakeholders to understand vision, business objectives, and critical success factors
Confidential, Silver Spring, Maryland
Project Manager
Responsibilities:
- Lead Sprint Iteration Planning, Daily Scrum Stand-up, Customer Demo and Retrospective meetings and maintained detailed Project Plans.
- Created Project Prioritization Process, Resource Allocation/Management Matrix, Budget Tracking various templates/tools including Reporting Templates, Planning Tools, Vision Templates, Project Communication and Delivery/Handover document.
- Effectively communicated Project Status via weekly and monthly reports to stakeholders and executives including updates to Project Timelines, Scope and updated Mitigation Strategies.
- Worked with Developers to track design of Informatica ETL mappings, enabling the extract, transport and loading of the data into target tables.
- Collaborated with cross team architects, DBA’s and infrastructure engineers to define Data Models and ETL strategy to capture new data, store historical data and update data warehouse in the most efficient way.
- Created Project Prioritization Process, Resource Allocation/Management Matrix, Budget Tracking with Reporting Templates, Planning Tools, Vision Templates, Project Communication and Delivery/Handover document.
- Effectively communicated Project Status via weekly and monthly reports to stakeholders and executives including updates to Project Timelines, Scope and updating Mitigation Strategies.
- Created weekly, monthly reports using Crystal Reports.
Confidential
General Manager
Responsibilities:
- Responsible for planning and managing of several simultaneous technical projects at client site that included resource planning, infrastructure, utilities and time management.
- Responsible for interacting with senior management in Germany regarding project status, progress, risks and issues.
- Dramatically reduced employee turnover by 50% through better interviewing techniques, implementing pre hire tests, and designing modules.
- Full budget and P&L responsibility for 60 million product line.
- Through better resource management built the Confidential team from 2 to 23 employees in 2 years.
- Achieved 4 million in annual savings through better placement, purchase price negotiations and staff .
- Lead negotiator with the C-management on all customer contracts keeping 99% of business under immediate payment agreements due to strong persuasion skills.
- Made presentations to the customer C-level executives highlighting the company profile and product portfolio for all turnkey projects.
- Developed performance management tools, wrote employee manual, and ensured all legal aspects of employment. Built strong rapport with personnel and won the respect of senior executives.
- Developed and directed all integrated marketing and communications strategies, ensuring continuity of corporate brand consistency and distinction.
- Travelled extensive to south East Asia, Europe for implementation of projects and strategic tie-ups with new partners respectively.
Confidential, San Francisco, California
Sr. Project Manager
Responsibilities:
- Demonstrated experience in defining, managing, and delivering complex, mission-critical initiatives and considered "go-to person" to immediately turn around troubled programs
- Worked with executive team, IT Steering committee and senior management to identify and prioritize opportunities for utilizing IT to achieve the goals of the enterprise.
- Established industry best practices by documenting processes for various teams and drove continuous improvement initiatives including reports to executive management on health of platforms using key metrics (latency, availability, ticket volumes)
- Led the requirements effort and organized Joint Application Design (JAD) sessions with all key stakeholders from each program. internal department members on administration of SharePoint, governance and best practices.
- Re-architecting the SharePoint infrastructure to enhance performance, decrease deployment time periods, and add disaster recovery and lower costs.
- Configure SharePoint services and settings.
- Tracked key project milestones and communicated status to all stakeholders and made changes to meet dynamic requirements using project management methodologies.
- Worked with operations team and business team in the implementation of change management process.
- Worked with business and identified key KPI's for Business Intelligence project.
- Analyzed the business requirements documents and performed cross impact and feasibility analysis.
- Responsible for creating the technical, functional documentation for various deliverables.
- Responsible for creating deployment plans for all the releases for the EDQ team.
- Excellent experiences working with cross functional teams to get the deliverables delivered on time.
- Prioritized business and systems problems; analyzed legislation and conducted impact analysis.
- Reduced implementation program from 18 months down to 12 months
- Created complex reports using BOBJ XI and SQL Server reporting tool for various pre-conversion weekly, monthly reports as well as post conversion daily reports.
- Performed data profiling on MDM from MS Excel, oracle data sources to study the data anomalies and redundant data.
- Worked extensively on Clear Quest for logging and tracking defects and Clear Case for version control of the code developed.
- Responsible for creating the technical, functional documentation for various deliverables.
- Worked on important business critical projects like DNAC to find anomalous data and Address Enrichment to cleanse and enrich the data from MetaVance post conversion and delivered on time.
- Performed the security implementation for the EDQ team to comply with the Enterprise security standards.
- Responsible for publishing and scheduling all the crystal reports developed on BOXI servers in all the environments (DEV through PROD)
- Worked on important business critical projects like DNAC to find anomalous data and Address Enrichment to cleanse and enrich the data from MetaVance post conversion and delivered on time.
- Expert level knowledge of MetaVance Load Utility which is used to load the cleansed data back into the MetaVance Oracle database.
- Analysed Data quality before loading the data into Oracle database during pre-conversion as well as post conversion.
Confidential, San Francisco, California
Project Manager
Responsibilities:
- Managed offshore and onsite teams using Planview by keeping the optimum number of resources with skillsets meeting the project requirements during various stages of the project.
- End to End Project Manager for multi track Online and BI/DW initiative including project Confidential, charter, planning, execution and budget management.
- Create detailed project plan, timelines and tasks and tracked timesheets and budget - actual vs. forecast.
- Managed OLB (Online Banking), OAO (Online Account Opening) and DW/BI development projects. Helped track project staff, determine project tasks, establish timelines, establish estimates-to-complete, prepared and communicated project statuses, identified and responded to risks and issues and managed change requests.
- Tracked key project milestones and communicated status to all stakeholders and made changes to meet dynamic requirements using Plainview.
- Lead internal and external resources, to create a mobile centric design with Mobility and experience that connects with potential and existing customers in a compelling and meaningful way.
- Monitor and track and key business performance indicators across all customer interactions with Personal Savings (Web, Mobile, Servicing Communications, Customer call depositions, etc…). Develop a scorecard that will be shared across the business.
- Successfully manage relationships with 20+ Wholesale lines of business officers, Wholesale Operations areas, Corporate Credit and Corporate Finance.
- Define and manage program strategy, program charter, work breakdown structures and project plans, including a rolling 18 month roadmap of features and concepts.
- Lead and supervise efforts in release planning, financial analysis, & ROI of multi-million dollar projects.
- Demonstrated analytic experience in budgeting, estimating, and project financial reviews
- Served as project leader on data warehousing projects, business process design, identifying and implementing system improvements and liaison to various business groups throughout the company.
- Transformed key business metrics to a process and database design technology solution that promotes a consistent and easy to use data analysis and reporting.
- Participated in requirements and design sessions with stakeholders to define list of Use Cases.
- Research Sources and identify necessary Business Components for Analysis.
- Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
- Reviewed source systems and proposed data acquisition strategy.
- Used SQL tools like TOAD to run SQL queries and validate the master data.
- Extracting and Analyzing the data from various systems like LDAP, N1Users, Badges, and Documentum, Actimize, Tealeaf, Peamart etc which was in the form of MS Excel spreadsheets.
- Analysed Data quality issues before loading the data into SQL Server Database
- Improved the performance of the workflow by tuning the session and mapping.
- Schedule and Run Extraction, Load process and monitor sessions using Informatica Workflow Manager from MDM in order to meet business requirement.
- Created technical documentation and provided to members of the organization.
- Developed and maintained the SQL Server Database for User and System level review. Developed plan to load data into the SQL Server DB.
- Performed ETL on the data from MS Excel, MS Access data sources to SQL Server.
Confidential, San Jose, California
Sr. Marketing Analyst
Responsibilities:
- Responsible for carrying out attribute archiving and increasing the system performance of the database server in the 3 instances Confidential has for the marketing data mart.
- Created functional, technical documentation, conducted s, and hosted meetings.
- Led workgroup sessions with business managers to gain final approval on business requirements and solution documents. Delivered product features presentation in order to obtain buy-in from key stakeholders.
- Involved in Requirement Scoping and identifying high priority requirement for implementation.
- Interacted with Business users for information gathering for various sub-projects which involved onsite as well as off-shore teams.
- Collaborated with marketing & sales to conduct customer feedback sessions, surveys, and competitive analysis.
- Conducted group meetings with the users of various departments to get a better understanding of the current system.
- Performed data profiling on data from MS Excel, oracle and MS Access data sources to study the data anomalies and redundant data.
- Handled multiple projects at the same time with efficiency
- Member of the team which supported the Marketing Data Mart using PL/SQL and Informatica PowerCenter.
- Extracted the data from SQL Server, Oracle, Files, and Access into Data warehouse.
- Working with different transformations like Source Analyzer, Lookup, Filter.
- Created sessions, batches and scheduled the same.
- Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
- Used the repository manager to give permissions.
- Responsible for creating test marketing campaigns and testing them in a test environment.
- As a Team Lead (team comprising of 3 members), efficiently handled up gradation of third party software used for direct campaign marketing called Kana from version 6.3.1 to 6.3.2 and installing JBoss and Web Server.
- Responsible for troubleshooting and fixing the bugs in the QA environment before (Data Mart) DM 4.0 goes live.
- Extensively responsible for troubleshooting and modifying shell scripts which pull data from the source (Teradata or Flat Files) and load them into text files.
- Solely accountable for upgrading server farm that consist of web servers, application server, and oracle database server for campaign marketing through the load balancer and the firewall.
- Provided on-call (support) every other week for troubleshooting and supporting the Informatica mappings, oracle database and UNIX scripts.
- Worked extensively on ClearQuest for logging and tracking defects and Clear Case for version control of the code developed.
Confidential
Marketing Manager/Sr. Marketing Executive
Responsibilities:
- Created and launched all consumer and retail promotions, co-promotions, corporate sponsorships, marketing collateral, advertising efforts and media relations.
- Achieved a 38% increase in revenue growth and converted prospects to invest in the products.
- Designed promotional materials to increase sales and developed cross marketing promotions.
- Structured and managed effective marketing strategies and programs that ensure a competitive edge.
- Responsible for performing analysis of survey information, and developing marketing plans based on results.
- Marketing strategic decisions regarding Trade Fairs from setting objectives & budgeting to negotiating with potential clients. ed the Top 5 sales executive for 1995 and 1996 among the 750 sales executive in the organization with sales of more than INR 60 million each year.
- Targeting and contacting potential clients and responding to queries to develop ongoing business relationship.
- Carried out market research and customer surveys to assess demand, brand positioning and awareness, evaluate marketing campaigns, and monitor competitor activity.