SUMMARY:

• BI Solution Architect with Analytics and Technical Program/Project Management with over 16 years of experience in IT out of 20 years with thought leadership in working on multiple projects / programs concurrently in dynamic environments
• Health Care, Medical Equipment Manufacturing, Supplies & Channel Marketing, Financial, EPC, Consulting Services and Retail industry experience.
• Healthcare Data Integration and Management through EDW around HIPPA, PHI and HITRUST security.
• Worked with ICD 10, CAG, AHCA with PPACA data on Customer retention and value for dollar spent, etc..
• Working & implementing and upgrade experience in Big Data Technologies - Hadoop, Greenplum, Netezza, Attunity, Informatica BDE & PC, DataStage, Talend, Alteryx (POC for alternative/ Lite ETL), Paxata (POC and evaluation), SAS, EDQ, QlikView, Tableau, Cognos, Toad Data Point and Cisco Data Virtualization (POC and enterprise rollout strategy) and Oracle EBiz Suite.
• Assessing Businesses and envisioning the Architecture road map on Enterprise, IT and Applications solutions based on the Vision and Goals of the entities.
• Expert in developing effective working relationships with the client teams to understand and support requirements, scoping/ prioritizing projects, developing strategic plans to implement technology solutions, and effectively managing client expectations.
• Through working knowledge of PMO operations, IT project portfolio management, cost/ variance analysis, budget forecasting/tracking/control, resource modeling/ forecasting/ leveling, project planning/scheduling/controlling, project/executive dashboards, performance/ status tracking, trend analysis and projects prioritization of multiple projects in parallel.
• Waterfall, Rational Unified Process (RUP), Agile DevOps with Scrum Master Project methodologies usage as per project needs along with Budgets.
• Trained & implemented in Org. work culture - the Six Sigma, Agile, DevOps, PMP and CMMI approaches.
• Certified in ISO 9001, CMMi, Scaled Agile Framework for Scrum.
• Multi-project teams resource team mobilization and ramp-up and demobilization based on architecture built and projects.
• Over 5 years of experience comprising of handling Bid Management in Presales along with Project Management activities, Resource Management: identifying the right resources for deployment in Projects, which also includes recruitment and skill, based training requirement fulfillment, designing Knowledge Management (KM) in Presales and supporting Organizational initiatives on KM products and Research Analysts - Gartner, Forrester and AMR at Unit and Organization Levels.
• Good visibility at process creations, improvements and its compliance, change management, and has created & implemented the Presales bid management cycle and handled the Projects Management successfully and looks after its knowledge repository requirements and training fulfillment.
• Worked closely with the finance department, vendor management office and Oracle teams for various project management/ payment/ procurement/ human resource related efforts.
• Confident, pro-active, analytical, fast learner, assertive, detail-oriented candidate with excellent multitasking capabilities to perform exceptionally in ever changing and stressful environments.
• Exceptional organizational, interpersonal and leadership skills with goal-oriented attitude to motivate / work with the team as well as independently.
• A good listener with excellent oral/ written communication skills and excellent problem solving skills. Adept at learning new technologies with organized, disciplined mindset and positive professional attitude.

TECHNICAL SKILLS:

Languages: SQL, HQL

Databases: Oracle 10g, Teradata, MS-SQL, Netezza, Hadoop, AWS-RedShift, SAS SPDS and Greenplum

Operating Systems: Windows 8/ 7/ Vista/ XP/ 2000/ Me/ 98/ 95/ 3.1/ NT, MS-DOS, Windows 2008 Server R2

Productivity Tools: MS Visio, MS Project, MS Word, MS PowerPoint, MS Excel, MS Outlook, IBM-Lotus Notes, TOAD, Aginity and SAS-EG.

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case modeling & Analysis, Use case specification (UCS)

Data Quality & Prep. Tools: Oracle Enterprise Data Quality (EDQ), Alteryx, Paxata

BI Tools: Tableau, QlikView SAS-VA, Birst and BIRT

DV Tools: Cisco Data Virtualization, Dell Toad Data Point

ETL Tools: Informatica PC, BDE, SSIS, DataStage and Talend

PROFESSIONAL EXPERIENCE:

Confidential, Oak Brook, IL

Tableau Architect - Data Integration, Migration & BI Reporting

Responsibilities:

• Revamping existing EDW architecture with superior Big Data ‘Data Lake’ Architecture
• WellCare legacy and Business Managed Systems data movement through Big Data into Data Lake.
• Data Integrations with existing and future tools and processes including IBM-MDM
• Advisory on Data Dictionary and other Governance models for quality and Security and avoid data retiring.
• Creation of BI platform for Self-Services, IT and Management dashboard reporting
• Evaluation of new Tools like Denado, Cisco DV, Toad Data Point, Jethro and NiFi products around Big Data for faster under HITRUST security data retrieval and Confidential for alternative ETL/ lite transformations/ data preparation for reporting tools consumption.
• Self-paced analytics replacing Cognos and SAS with Tableau for cost effectiveness
• Upgrades of Big Data and BI tools in the BI-DW EcoSystem.
• Solution Engineered the Business, Member and Compliance critical data from the Implementations of Pega Workflow replacing Omini-flow into Data Lake.
• Implementation of Tableau complete setup
• Tableau Upgraded, Hardware Scaled and administered and trained the resource to become Tableau Admin. and manage daily chores.
• Extensive usage of Tableau Dashboards across existing and conversation of Reports / Dashboards from other Applications.
• Security around data used by Tableau
• Empowering Business users and developers through ‘Lunch-n-Learn’ programs
• Facilitated the Tableau training to the requested.
• Implemented Tableau COE at Enterprise level
• CEO and CIO Management Dashboards creation and maintenance through advanced analytics.
• Intro. of ‘R’ for algorithms by implementing R in a Linux server for Data Scientists with Tableau R features for POC.
• Rolled and monitored the progress of Tableau adaptability
• Implemented Standards and best practices and documentation.
• Setup of ticket system for Tableau usage and support through ITSM and SailPoint
• Planned and executed Change Management for rooting Tableau usage with EWD and all its heterogeneous sources at ease like Greenplum, SharePoint, Hadoop, Oracle, MS-SQL, SAS and large inputs like ECM CSV file sets.

Tools: Tableau Desktop and Server 9.x, Confidential 9.5, Salesfore.com, MS-Sql 2008 Server, MS Visio, MS PowerPoint, MS Excel, MS Access, Pega Dashboards, MS Word, Cisco Data Virtualization, AutoSys, Move IT, IBM-MDM, HP ALM, Hyperion Essbase, SAS, Cognos, Hadoop, Informatica-BDE and Greenplum.

Confidential, Mansfield, MA

Architect - BI COE and Support

Responsibilities:

• Introduced self-service BI under limited EDW architecture - Tableau product, upgraded, hardware & software scaled and channelized into corners of the 54,000 employee base spread across the geography. For visibility, even took couple of projects as a challenge and completed in record time with award winning ROI.
• Aligned sales with BI reporting with Salesforce.com (SFDC)
• Introduction and POC of Data Preparation and ETL alternative tool Confidential for IT users
• Introduced DW database IBM Netezza for advanced applications and analytics
• Moving existing data to new DW Architecture
• Built road map for Enterprise level Architecture to retire legacy systems integrating IBM MDM
• Project Requirement gathering and Analytics for Solution Architecting and Consulting
• Conducting JAD sessions with the Cross Business teams from various Business sites to vouch the requirements assessed.
• Data Modelling and Solution Architecting involving internal DataMart’s and external sources like IIM and SFDC, Sql databases
• Used data extracts placing Toad Data Point on heterogeneous sources to prepare POC.
• Hardware Sizing for the Project and emphasis on leveraging existing facilities for better ROI
• Dashboards built to suite Mobile/ Tablets apart from traditional Desktop users
• Maintenance and Support of Development, Quality Assurance and Production servers
• Constant Tableau development UI/ UX and project set up guidance to the ever evolving business power users for their internal and external dashboard consumers
• Prepared Tableau Standards and Practice under Covidien Tableau BI COE and implemented across the entity for better Tableau leveraging and benefits.
• Performed the tasks of automating and facilitating the scripts for Tableau’s command prompt i.e., ‘Tabcmd’ for synchronizing the security groups, determining the permissions and securing server backups.
• Also performed Tableau server upgrades and expanding the hardware for the three Tableau environment setups.

Tools: Tableau Desktop and Server 8.0, 8.0.x, 8.1 and 8.2, Confidential 8.6, Salesfore.com, MS-Sql 2008 Server, MS Visio, MS PowerPoint, MS Excel, MS Access, MS Word, Model Right, TOAD for SQL & Dell Toad Data Point, Informatica, Windows & Skybot Scheduler, Hyperion Planning, AS400 and Netezza.

Confidential, Bentonville, AR

BI Architect - Data Visualization

Responsibilities:

• New KPI generation for Scorecards through DW setup
• Data collection and leveraging on data manipulation teams for required data
• Identify new metrics and enhance the existing KPI’s
• UI/ UX
• JAD sessions for Proto Types on DevOps model
• Interactive Dashboard Visualization through Tableau BI application
• Evaluation of Greenplum
• Data-modeling
• Tableau 7.0 and 8.0 were used extensively for the dashboard reporting and analysis. Solution architecting, data-modeling to churn-out metric based transactional data which are in billions with several 100s of Terabits space from Hadoop to Data staging to Teradata environment to Tableau dashboard visualization.
• Used table calculations, parameters, sets, groups and other features of Tableau for better data visualization.
• Responsible for all the Quality Assurance of the dashboards in both pre-production and production environments.
• Publishing and administering the dashboards to the Walmart groups and associates through Active Directory (AD) as per designated user level access controls for UI/ UX.
• Performance tuning recommendation through the HQL optimization and Tableau scheduling. Working with incremental extracts for optimal performance.
• Prepared documentation for the end-users as well as for the developers and trained the user community, Walmart associates as part of the project.

Tools: Tableau Desktop and Server 7.0 & 8.0, MS Visio 2003, MS PowerPoint 2003, MS Excel 2003, MS Word 2003, Team Forge, Text Pad, Teradata, Hadoop - Hive, HPALM (QA), HP Clarity.

Confidential, Liquor & Spirits, NJ

Technical Project Manager - BI Analytics & Data Integration

Responsibilities:

• Setup EDW infrastructure with cost effective model.
• Business Intelligence vision based approaches for the profitability and business expansion.
• Customer transaction data analysis for increase and decrease on product line.
• Interactive Visualizations on Tableau exclusive and distribution - maps, bars, pies, line, scattered and heat-maps charts.
• Level based dashboards with appropriate UI/ UX experience
• Documentation for End Users
• Ensuring Quality Assurance.
• Deployment of Tableau readers
• Development of POC and evaluation of Qlikview.
• Administered Tableau Access through AD groups and extracts.
• Prepared Request for Proposal (RFP), Scope of Work (SOW) and project planner - Work Breakdown Structure (WBS).
• Responsible for the business application management, reposting to the high-level management as well as business users internally and externally.
• Worked collaboratively with business units, steering committee, project sponsors, technical leads, engineers, data architects, and external vendor project teams.
• Helped a group of 6 managers in managing project portfolios and coordinate various project management activities. Worked mainly with three program managers, on multiple (RMS, POS solutions and R&D on dashboard) projects, in parallel.
• Interacted with vendor management for various vendors related selection issues and on-boarding / off-boarding of consultants. Made arrangements for various consulting and training engagements.
• Both RUP and Waterfall Project methodologies were used due to project dynamics along with MoSCoW approach.
• Responsible for the progress of all the project phases - Initiation & Definition, Planning, Execution and control (design, test, build) and project production rollout in order to meet the milestone deadlines.
• Created Project Definition Document (defining goals and objectives, alignment and rationale, priorities, delivery timeframe, scope inclusions, scope exclusions, approach, project deliverables, costs / benefits, risks / assumptions /constraints, impacts, project organization, team members, roles and responsibilities, communication plan, change control process, resource requirements, contract partners etc.).
• Conducted and coordinated within the team, within the project group, business management team and with business users/ customers.
• Responsible for risk management, change management, delivery management and release management.
• Created implementation verification back out plans and activity announcements for the production rollouts. Maintained change/risk/issue logs and escalated risks /issues to the higher management, whenever needed.
• Prepared analysis reports, impact analysis reports, periodic and monthly status reports, delivery/release calendars, milestone reports and other ad-hoc reports, as needed by higher management.
• Prepared for transition execution and implementation activities as well developed the plan, working in collaboration with business user and prepared project charter & project detailed task schedule along task allocation to resources.
• Scheduled post project reviews and documented project deliverables / best practices / technical details on the Wiki. Created wiki pages, categories and lists on the Wiki for maintaining project documentation and other project related information.
• Participated actively in detailed project analysis/ budget analysis / market analysis activities, reporting. Created various metrics based on the analysis results, as needed by the higher management for various strategic decisions.
• Attended Steering Committee meetings with General Managers, Managers, project sponsors, project team and other higher management steering committee members. Captured / Published the minutes.

Tools: Windows,.Net,Oracle 10g, MS-Sql, MS Project (2003, 2007), MS Visio, MS Office Suite 2007, Toad, Tableau 7.0 & 8 beta, OBIEE 10g.

Confidential

Project Manager

Responsibilities:

• Responsibility for overall teams of Support both Post Production Support and Support activities.
• Planning and managing delivery within the agreed SLA (timelines).
• Managing delivery resources and training and mentoring team members with the objective of realizing project goals.
• Provide quality assurance on project deliverables.
• Monitoring project status and taking proactive measures to address any potential issues / risks affecting the SLAs.
• Managing project scope and implementing change control and change management procedures, where required.
• Managing stakeholder communications and obtaining key stakeholder buy-in on the change requests.
• Monitoring the project internal financial status including resource commitments and taking appropriate measures, wherever required.
• Logistics and support schedule of team and their allowances; On-call support.
• Assisting the Project Management of Confidential GBS implementation project.

Tools: MS Project 2003, MS Visio 2003, MS PowerPoint 2003, MS Excel 2003, MS Word 2003, MS SharePoint 2007, Notepad, MS Outlook, Time Tracker, Remedy, Toad and Oracle E-Business Suite 11i (11.5.10) - Financial and SCM modules.

Confidential

Presales and Project Manager

Responsibilities:

• Looking after the ERP consultant recruitment, training and deployment in projects of Oracle Enterprise Applications of Presales wins of both new and existing customers.
• Coordinating with the technical and functional teams and arranging compliances, POCs and Demos.
• Addressing the Surveys and Analyst questionnaires and make strategic presentations for the Unit
• SPOC for Data Quality, Enterprise Applications Knowledge Management Portals and looking after its business/ usage requirements.
• Taking part in Organizational and Unit level initiatives
• Building and preparing MIS reports and resource projections for pipeline potential probability.
• Taken up ad hoc presales activities from the team or as allocated by the senior management.

Confidential

Project Manager

Responsibilities:

• Data Architecture utilizing in-house Resources.
• Development of assessment tools for ITeS industry training and recruitment process in the State.
• Waterfall project methodology has been used for tool development and Spiral method for implementation of the tool at the sites.
• Supporting the Government initiatives to bring ITeS companies to the State of Confidential, India.
• Bringing the ITeS Industry, Training Institutions and Govt., Policies for creation and identification of employable citizens within the State.
• The penetration to the suburbs of the State of Confidential, India in search of talent pool creation through Data Quality aspect and increase of employment potential while also showing the infrastructure facilities to the investing global players.
• Responsible for overall operations of IITEST objectives.
• Tie-ups and guidance to other state Govt., bodies and foreign universities and institutions on the development of ITES policies - enhancements.
• Publications, Electronic and Print Media communications
• Syndicating ITeS training partners for achievement of common objectives.
• Responding to Legislative Assembly of AP questions through the Govt.,/ Secretariat.
• Preparing MIS reports and business projections to the Govt.,/ Secretariat.

Confidential

Sr. EPC Executive - Procurement and Logistics Management

Responsibilities:

• Creation of specifications RFPs for floating tenders with the inputs of technical divisions.
• Evaluation of Qualification criteria including company’s quality and financial health.
• Member of commercial negotiation panel and inspection panel.
• Award of contracts to the selected Vendor.
• Vendor Management
• Schedule effort and Variance, Task priority, Resource Management and Customer Communication
• Documentation control process for offices and project site offices.
• Team Leader for support function departments
• Resource planning to deployment.
• Formulating company’s personnel policies and procedures.
• Employee welfare and retention initiatives
• Providing monthly HR inputs for Payroll of employees.
• Administration and in charge of Japanese employees living, logistics, security, welfare and travel itinerary.
• Assisting Managing Director on identification of new business opportunities in APAC.
• Office automation, AMCs procurement and asset maintenance.
• Preparing MIS reports and business projections.
• Database and network management

Confidential

Coordinator - Corporate Finance

Responsibilities:

• Imports of computer and allied equipment - Letters of Credit and Bank Guarantees
• Analyst relations
• Inputs on cash flow to finance division
• SPOC for initiatives on US GAAP, Product - Vision Compass and Oracle Financial implementation.
• Making presentations to the Chairman and other Senior Executives of the Company Board.
• Database and documentation management
• Preparation of reports to AGMs, Media Analysts, etc..
• MIS for CMD, Secretarial and ED office review.