Data Manager

Name:

Neetu P. Notani

Clearance(s):

Public Trust @ DHS

Top Secret Active

Certifications:

Oracle Business Intelligence Applications 7 for ERP Certified Implementation Specialist

Cognos

Informatica

Ab Initio

Diploma in Oracle/ Developer 2000

Degree/Education:

Bachelor of Engineering in Computer Science, University of Pune, India

Total Years’ Experience:

She has over fifteen years of experience in the commercial and government sectors.

Citizenship:

United States

Summary of Qualifications:

Ms. Notani has 17 plus years of experience in both the public and private sectors supporting Senior Executive reporting. She has extensive experience at the DHS in delivering BI solutions and managing cross-functional teams to meet customer requirements, and convert proprietary reports to the needed format. She also has experience working directly as a BI administrator ensuring smooth operations and managing a user base. Managed TSA account individually from PwC side.

Expertise in business intelligence and data visualization concepts sufficient to conduct visualization meetings to document the process flow and draft user experience design.

Expertise in managing multiple projects and prioritizing them and delivering quality product in given time.

Good communication and written skills to develop and present reports, summaries, and recommendations, and provide guidance related to products, services, and business initiatives.

Expertise developing and designing dashboards for senior leadership. Provides business area and technical expertise to management and stakeholders to facilitate planning, set direction, define business initiatives, and develop solutions to business information systems needs and requirements.

Expertise in data analysis.

Ability to plan and implement change management communications

Work on creative designs and user interface in advanced analytics presentations, dashboards and reports.

Extensive background delivering Business Intelligence analytic solutions to Department of Homeland Security

Functional lead interacting closely with BI and ETL architects to help translate functional specifications

Knowledge of basic data integrity and database principles, such as data analysis, data modeling, and database tools.

Worked on Senior Leadership reports like Monthly Execution Reports and Funding Status Report and Trial balances and reports to be provided to Capitol Hill.

Worked on technologies using Toad and SQL Navigator to run SQL queries to find data discrepancies.

Work closely with ETL team to enhancements of PL/SQL scripts

Worked with Data Modelling team on technologies like Erwin

Understanding and Supervising Geospatial Analytics (Geo coding data, Developing Maps)

Employment History:

USAC: Supervisor -Business Intelligence IT Team, Jan 2017 to Present

Accenture Federal Services: Cross Finance Business Intelligence Reporting Manager, Sep 2016 to Jan 2016

PricewaterhouseCoopers: Subject Matter Specialist, 2012 to Aug 2016

IBM Corporate Head Quarters: BI Specialist, Technical Team Lead, 2005 to 2012

IBM Global Business Services: Software Consultant, 2002 to 2005

PricewaterhouseCoopers: Software Specialist, 2000 to 2002

Gillette, Data warehouse Developer, 1999 to 2000

USAC, Supervisor Business Intelligence, Feb 2017 to present

Working as Supervisor for 2 Programs High Cost and Lifeline in capacity of Architect and PM.

IT support responsibilities that include providing technical and analytical direction for multiple IT specialty areas to support the information management needs

Planning and organizing work and project assignments to be accomplished by developers, setting priorities and deadlines

Working with Help Desk Unit with other organizations in planning for the installation and implementation of new systems and ensuring optimal use products

Providing advice and guidance on complex IT issues

Provide recommendations to management and other technical specialists on critical IT issues

Creating and publishing management level reports

Managing Servers and monitor the functionality, security and integrity of servers

Responsible for directing and providing necessary support on after hours and weekends in necessary

Working in Agile environment and run scrums and manage Project Schedules

Focusing on Self Service BI Platform - Pentaho (based on Open Source)

Leading a BI Team to drive Self-Serve Business Analytics (Looking out how can we use new technologies in Data within the organization to achieve enterprise goals

Supervising the development of Data Marts & Enterprise Data Warehouse and working with Open Source Technology - Pentaho BI Suite & Pentaho Data Integration.

Understanding of API

Understanding and Supervising Geospatial Analytics (Geo coding data, Developing Maps)

Used various technologies like Pentaho Suite, Socrata, Postgres, Vertica, QGIS, Python, JIRA

Accenture Federal Services, Cross Finance Business Intelligence Reporting Manager, Sep 2016 to present

Drive consistency and standardization through end-to-end reporting solution and within the organization

Identify and implement opportunities to improve reporting efficiency

Effectively team with IT and Finance stakeholders including:

oWorking with business stakeholders to identify and design reporting needs, dashboards, and key performance indicators (KPIs)

oWorking with Enterprise Reporting and Analytics team to provide reporting, as required. This includes providing guidance on design, development, and testing activities.

Manage report rationalization including monitoring and analysis of report usage metrics, including supporting a reporting blueprint.

Manage report decommissioning

Effectively represent the Cross Finance Reporting team in multiple meetings, discussions, and presentations

Support the review, analysis, and responses to business inquiries related to report contents (incidents and user questions)

Identify content and support the development and delivery of training and communications to business users

Provide oversight of reporting data quality including monthly close and operational reviews

Demonstrate strong communication and organizational skills

Demonstrate strong technical, analytical, and problem solving skills

PwC, Functional Business Intelligence (BI) Team Lead, SME Aug 2012 to present

Working on delivering Business Intelligence analytic solutions to DHS.

Experience in DHS-TSA Systems Development Life Cycle (SDLC) processes

Lead OBIEE developer and designed and developed different dashboards in OBIEE, and worked on converting discoverer reports to OBIEE (new version of existing tool)

Worked on reports for TSA Administrator and CFO of TSA.

Demonstrated understanding/experience with the configuration, design, and development of OBIEE 11g, Oracle databases, and ETL processes

Utilize Business intelligence tools and technologies using principles in the evaluation and analysis

Led effort to convert Fed traveler Historical data to OBIEE solution.

Strong Analytical skills to create adhoc reports.

As a functional lead interacted with BI users to understand their requirement and maintained positive relation with users. Worked on functional specifications and mockups for reports.

Worked closely with ETL architects to help them understand and translate functional specifications.

Led the project to developed Financial Dashboards in OBIEE and converted 100 +discoverer reports to OBIEE (new version of existing tool).

Worked on Report Specifications, Documentation and user training.

Well versed with PowerPoint and Excel used for senior leadership presentations.

Worked as BI Administrator and ensured smooth BI operations. Managed users and privileges given to users. Communicated with IT services team to make sure users list is up to date with users leaving and joining the agency.

Experience with Federal Financial Management Systems

Worked as BI Administrator and ensured smooth BI operations

Worked on 2 OBIEE upgrades successfully (From 10g-11.1.6.5-11.1.7.1)

Currently working on an upgrade to BI Apps (Oracle R12 environment with ODI & OBIA). Developing 400 plus reports using new star schema structure. Using reverse engineering methodology to look at OOTB reports to look at report layouts, metadata mappings and ODI transformations.

Worked on BI publisher to create System Check Reports.

Managed PMO side of project for PwC team.

IBM CHQ, Executive Dashboard Team Lead, Jul 2005 to Mar 2012

Led the project to support CEO of IBM for 7 years.

Created reports for the CFO, CIO, General Managers and 1st line managers to take timely decisions. Experience building dashboards, reports, and related content in using Cognos, Lotus IBM suite & Web sphere

Provided concise and consolidated views of a wide variety of information across all business units and geographies, including structured and semi-structured data - its demand, leads, and market opportunities.

Were able to roll up the data electronically for every client team, every customer set, every Geography, every product line everywhere in the world.

Business Performance Reporting with trusted data sources where data ownership is clearly defined and data owners are responsible for data quality, reliability and timeliness.

Helped executives identify shortfalls in the sales pipeline or projected revenue early in the quarter when action can be taken to address them.

Focused Reports Analytics and Alerts.

Provided customized reports from C level executives to 1st line managers and staff. Experience manipulating various data sources to support Senior Management decisions.

Complete life cycle experience in Data warehouse life cycle.

IBM CHQ, BI Specialist, Jan 2011 to Mar 2012

Delivered Hyperion reports that were currently in the portal using Cognos framework manager and report studio ahead of anticipated 2Q12 plan.

Achieved this through a three-step process that leverages an additional IBM technology, DB2, to create a business data layer (or ETL), consolidating the data into a simpler and more efficient format that can be stored and then used by Framework manager.

Acquired knowledge from this project that will enable to use data modeling and consultant expertise to provide an expanded business model through BI@IBM and the Data layer.

IBM GBS/PwC, BI Analyst/Data warehouse Developer, Oct 2002 to Jun 2005

Worked on analyzing business scenarios for extracting data from different systems, geographies into global warehouse.

Worked on School District Data Warehouse project as Data Analyst/Reports Developer using Oracle Discoverer.

Job responsibility includes conducting interview with Clients and Analyzing there requirements.

Utilized Erwin for data modeling for design, mapping and development.

Acquired deep skills in Extracting, Transforming (or Transporting) and Loading (ETL) data from source systems into the data warehouse.

Involved in Development and Deployment of Complex Reports.

Tuning and optimization of SQL queries.

Developed Used Cases in health care industry.

Worked as technical architect in banking industry.

Gillette, Data warehouse Developer, Aug 1999 to Oct 2000

Worked on Reporting Data Warehouse implementation to develop extracts for different geographies.

My responsibilities as an ETL Analyst included to work on Mainframe environment, understand the Bank’s data models.

Process involved interacting with Business users build ETL process using ETI* Extract.

Provide an analysis of the end to end nightly financial reporting process.

Participated in the design of improvements to the report generation process flow that would increase efficiencies in the reporting cycle time.

Analyzed and designed the technical and business requirements and defined the strategies to load data into the Warehouse.

Worked on project plan, process flow diagram, and the unit test.

Contact this candidate