SUMMARY:

• More than 17 years of Information Technology and Data Warehouse / Business Intelligence professional experience with diverse domains, healthcare, retail, manufacturing, human resource etc.
• Strong experience in Data Warehouse, BI & data Architect, Data modeling, Big Data, Hadoop, NoSQL and Machine Learning along with Epic clarity, Cogito, Caboodle, Tableau, SAS, BO and IBM Cognos.

AREAS OF EXPERTISE:

• Enterprise Data Warehousing (EDW) \ Data Warehouse (DW) and Business Intelligence (BI)
• Data modeling and data mart design (Financial, Retail, healthcare - more than 5 years)
• Reporting Data Mart (star \ snowflake schema) design and implementation.
• Epic clarity, Cogito, Caboodle, Tableau, SAS, BO and IBM Cognos
• Experience in managing off-shore technical team (India, Germany, Russia, Ukraine)
• Database: Oracle 7\8\9\10g, MS SQL Server (SSAS, SSRS, SSIS), Teradata V2R4\5,
• ETL: Informatica 7.x\8 and manually writing ETL scripts.
• Dashboard \ Visualization: Tableau and Roambi

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. BI & Data Architect

Responsibilities:

• Legacy Ad-hoc Reporting system - Answer to question business asks
• Artificial Intelligence Reporting (Data Science \ ML) - Answer of 'Question' business never thought of asking.
• Working as primary point of contact to provide IT, BI and Data Analytic needs for Beauty & Apparel Retail Company as center of contact for Sales, Marketing, HR, Finance, Stores and inventory and EDW department.
• Currently managing team for legacy BI data system and well as Data Scientist for future needs and prediction of budget, inventory & consumer behavior, utilizing Machine Learning.
• Established trust and developed strong tied among departments and groups (DotCom, DotCA, Finance, Inventory, HR Pay Roll etc) in France, US, Canada and Brazil.
• Responsible for IT development of Business Intelligence solutions, strategy and roadmap, including both existing and future capabilities, BI Cloud and Big Data.
• Manage, define, develop, and coordinate best requirements for Business Intelligence requirements, as well as for the Data Warehouse, Data marts and Reporting/Analytics needs.
• Planning, designing, implementations include infrastructure, data warehouse and BI applications.
• Design develop test case and script for QA in multiple projects like EDW-Cloud (AWS), Software upgrade, Business Intelligence application developments etc.
• Individual contributor as well as technical leadership and direction to coach, mentor, motivate, and lead team members to achieve company as well as self goals.
• Introduce and identify opportunities in driving platform decisions for major solutions and provide direction and guidance to internal and external teams to ensure that requirements are met in an architecturally sound manner, meeting fundamental technical requirements.
• Process, budget and planning of multiple projects and programs simultaneously.
• Manage people & projects though the entire IT lifecycle.
• Planning, designing, implementations include infrastructure, data warehouse and BI applications.
• Vendor negotiation and communication with management and to sway the opinions of corresponding party at the executive level.
• Interface with users and data architects in order to translate user requirements into data requirements.
• Create prototype, workspace and demo to executives.
• Maintain strategic partnerships and drive joint initiatives with the corporate divisions: IT- EDW, sales, Marketing, Finance, Stores, Fraud Reporting etc
• Working in a fast paced, Agile environment; delivering projects and solutions in 3-8 weeks Sprints.

Environment: s: IBM BI (Cognos), Roambi, Tableau, SAS, SQL Server, SSRS, Big Data, Hortonworks, R \ R Studio, Python

Confidential

Sr. BI & Data Architect

Responsibilities:

• Assigned to develop BI data model and self-service BI reporting system.
• Use external patient data, came from different hospitals and doctors office, with Epic data to build dashboard reports and drill down reports for analyst and management to identify existing epic registered vs external patient over time. These applications also help to analyze claims and eligibility data from multiple sources.
• Develop report and dashboard like patients length of stay and flow, Re-admissions, procedure counts and specialized treatments as well as admit and discharge.

Technology: Epic Cogito, Caboodle, SQL Server, Tableau

Confidential, CA

Sr. BI & Data Architect - Technical Director

Responsibilities:

• Worked to set up end-to-end Global EDW/BI strategy, development, implementation and continuous innovation of the strategic and tactical information management function for the department of annual budget of $2.2B.
• Implemented BI environment in multi server system with scalability, disaster recovery & availability.
• Design and implement logical and physical data models, data mart focusing in finance & health data.
• Data Governance - multi layer Data security and fast data availability across the company.
• Point of contact for Data \ Report delivery with data integration - Epic, planning & forecasting as well as data from in house application for specialized medicine.
• Participated and lead my team in CAB meeting for SOX and HIPPA compliances.
• Built a core team of junior to very senior professional in a Center of Excellence (COE) to support the complete decision support and management cycle systems.
• Provided state of art BI applications to senior executives (CFO, VP of Pharmacy, Directors).
• Designed the roadmap for Executive Reporting System (ERS) for Kaiser Pharmacy (6 regions), set up and maintain business and IT techno functional relationship.
• Implemented process to replace spreadsheets from financial system and generating an average of 95% efficiency gains by utilizing BI system
• Designing and streamlining HL7 massaging data from diverse data source for BI reporting system.
• Simplify and cleaning of HL7 data from radiology information system (RIS), lab information system (LIS), hospital information system ( Confidential ) and electronic medical record (EMR) to present data to doctor’s group (TPMG), Pharmacy group and upper Management for better decision making and stream line the process, like how long a patient is waiting for lab or outpatient before getting work started.
• Worked with Epic data like Epic’s reporting infrastructure: Reporting Workbench, Clarity, and the Caboodle data warehouse (an enterprise data warehouse platform) Set up the process to build best of the best technical and functional resource to secure future for the company.
• Worked very closely and built trust with business, end users, business counterparts to provide state-of-art application to make best corporate decisions.
• Upgraded BI infrastructure (Hardware & Software) along with existing BI applications.
• Managed technical teams on shore \ off shore (India).

Technology: IBM Business Intelligence software; install and configured Tableau 7.0 desktop & servers; R&D on Hadoop - Big Data to implement in Kaiser; Oracle, Teradata, IBM Cognos BI, SAS, Informatica, Tableau, Business Objects, Java, .NET.

Confidential, San Leandro, CA

Sr. BI Manager

Responsibilities:

• Hired to improve reporting system.
• Developed a vision, strategy and roadmap for EDW - BI capabilities.
• Designed executive data mart - data modeling, star schema design, utilizing planning and forecasting data, salesforce and actual financial data. Coded ETL script for entire system. Collaborated with the business regarding their data, reporting and analytic needs.
• Promoted the development of self-service capabilities for the business in the access and reporting of business information.
• Worked closely with business and IT stakeholders to gain consensus
• Led efforts in defining enterprise data definitions, implementing data governance and data stewardship best practices.
• Developed strategies needed to expand the Enterprise Data Warehouse and Analytic and Reporting functions (EDW - BI).
• Track record to deliver applications (BI-reports or OLAP) with execution (run) time less than 10 seconds.
• Built Financial data mart (star schema - finance data warehouse) by integrating data from excel sheet, IBM FP&A Software, salesforce.com & PeopleSoft (Actual data).
• Oversaw the development and expansion of the Business Intelligence infrastructure and ensured data integrity.
• Oversaw progress on major BI initiatives including schedules, scope, resourcing, etc.
• Supported the management of daily activities for the EDW - BI initiatives.
• Mentored staff and provided educational and training opportunities.
• Managed EDW - BI vendors and negotiated contracts as required.

Technology: Oracle, Cognos BI & EP, PeopleSoft, Hyperion, Essbase

Confidential, Pleasanton, CA

Sr. BI Solution Consultant \ Architect (Business Intelligence Lead)

Responsibilities:

• Worked as Senior BI consultant (Solution architect) & BI lead in KPIT.
• Designed and deployed Program Office data model for financial and forecasting database.
• Worked with several groups to build BI & EP environment & applications out of new data warehouse in the diversified environment like K-people, HR, Teradata, Oracle, BI, EP and IBM BI Software.
• Worked as 3rd level of support for post production and critical executive BI application development.
• Worked in very aggressive and time critical project delivery - multiple projects simultaneously ( Hawaii (Hi-RET), PORPT, POFTE and SPRPT - Strategic Planning and Reporting).
• Managed development, testing and production migration under SOX and HIPPA compliances as well as managing group of developers for various projects.

Technology: Teradata, Oracle, Business Objects, Crystal Report, SAS, IBM Cognos BI & EP, PeopleSoft, Crystal Report.

Confidential, San Jose, CA

IBM BI & Data Architect - Solution Delivery Project Manager

Responsibilities:

• Talked to end users, department managers and executives for application requirement.
• Responsible for delivering financial application data mart (Balance Sheet, Income Stmt, Stmt of Shipment, Opex, revenue and expense).
• Delivered financial dashboard and score card applications for diverse management group and made sure that any executive financial report should not take more than 10 second to run and all the SOX and company policy and practice got implemented.
• Trained users in class sessions and at the user’s location if needed.
• Project Management (Finance) Phase I: Managed data warehouse BI applications with the help of 2 off-shore (Indian and Russian) teams of more than 15 employees for the development of all BI applications (Financial Application, Performance Management, dashboard and score card-Metrics) for 4 months. Developed 25 OLAP and 75 reports by extracting data from Enterprise Planning application and merging data with QAD financial System.

Technology: IBM Cognos BI, Oracle, SQL Server 2005, MS OLAP, IBM Cognos cubes.

Confidential

Data Warehouse Specialist \ Project Management

Responsibilities:

• Parallel multiple project management of: Travel and expense, e-budget and invoice in compliance of Sarbanes-Oxley (SOX).
• Responsible for replacing server and migrate IBM Cognos BI application from Cognos series 7 and ReportNet to Cognos 8 in new server. Design and develop data mart and Cognos application by migrating data from lotus Notes and Peoplesoft to Oracle 10g star schema.
• Finance data modeling and database design.
• Install, configuration, development and maintenance cognos applications and reports like Account Receivable, Account Payable, General Ledger, Trail Balance and other financial reports and cubes with the interface of Oracle / People-soft databases. Troubleshoot Cognos cubes, impromptu and ReportNet reports, Cognos Analyst and contributor.

Technology: Cognos EP and BI, ReportNet and Series-7, PeopleSoft, Informatics, Oracle 10g, WinXP.

Confidential, Santa Clara, CA

BI Architect

Responsibilities:

• Fulfilled Technical Lead and project manager role for on-site and off-side group of employees.
• Responsible for multiple projects management and administration, leadership for developers and programmers.
• Participated and motivate co-workers to meet the goals and deadline for projects.
• Established the standard and best practice to provide quality data to the on-site and off-site clients (users - Germany) in diverse environment.
• Coordinated the synchronization and merge to gather Cognos BI environment after 2 component of Guidant medical industry being bought by Confidential .
• Documented migration plan, production setup, wrote company’s standard Cognos application.
• Tested and validated plan before moving to production as well as setup standard best practice for developers.
• Provided full project management with responsibility to fulfilled functional lead roles, and designed, implemented, and documented data warehouses using Cognos BI tools to support budgeting, planning, forecasting, financial consolidation, reporting and analysis applications.
• Established and improved help desk & ticket system to support end users and developers.
• Managed and supported software and license uses.
• Setup development (single server), testing (single server) and production (Multi Server cluster) of Cognos series 7 environment.
• Migrated numerous Cognos reports and cubes from old to new environment.

Technology: Cognos Series-7, PeopleSoft, Informatics, Oracle 10g,WinXP, Unix.

Confidential

Data Warehouse - BI Architect

Responsibilities:

• Hired to fixed and troubleshot existing application error as well as set up best practice for data warehousing and BI applications.
• Wrote batch scripts to automate IMR and PPR reports to run and get data extracted in csv, pdf or xls format that saves 50% of users and developers time.
• Data mining for several branches throughout the world.
• Implemented Cognos 8 in multi-server environment, migrated Series-7 applications to Cognos 8 and trained new users by writing documentation with local data.

Technology: Cognos 8 and Series-7, Oracle 10g, Win XP, Sun Unix.

BI Architect - Project Manager (Informatica 7.1 Developer)

Confidential, El Segundo, CA

Responsibilities:

• Migrated data warehouse application from Oracle system, integrated with Cognos Series-7 to Teradata database and Cognos 8.
• Set up Cognos 8 environment and data certification against old system.
• Tuned up Cognos component as well as application models for better performance.
• Mapped more than 300 and validated Informatica applications from Oracle to Teradata, most of the sessions were re-created.
• Cognos 8 implementation, migration in test box and hands on conducted training on Cognos 8.

Technology: Cognos 8 and Series-7, Oracle 9i, Informatica7.1, Teradata, WinXP.

Project Management - Solution Design & Architect

Confidential, Port Hueneme, CA

Responsibilities:

• Set up ReportNet to email reports to corresponding users and users’ groups around the world.
• Updated ReportNet from 1.1 to 1.1 MR2, keeping all data as is in the content store. Converted Catalogs, IMR and CEM files to XML files for ReportNet and imported to the Cognos connection. Setup and imported Cognos Series-7 Security to Cognos ReportNet. Developed and published Project packages from Frame Work manager to Cognos Connection.
• Developed cubes and wrote (Scripts) batch jobs for scheduling cubes and moved applications from development to production area.
• Wrote user's manual for training and trained users based on data being used by users on day-by-day basis. Trained Navy civil employee and new intern for Cognos applications. Established and improved help desk & ticket system to support end users and developers. Managed and supported software and license uses.

Technology: Cognos Series-7, ReportNet, Oracle 9i and 10g, MS SQL Server 2000 (T-SQL), Win 2000.

Cognos / Teradata Architect

Confidential, Troy, MI

Responsibilities:

• Responsible for converting Oracle database to Teradata database (in team, migrated data from multiple data sources to Teradata box). Converted Oracle reports into Cognos Reporting environment. Set up Cognos 7.1/7.2 server systems for reporting. Gathered business users requirements and developed Power Prompt Applications (desktop applications) for end users.
• Published Cognos applications (Reports and Cubes) on the Upfront Portal. Developed IMR report and put PowerPrompt (using JavaScript and HTML) on IMR and finally published on the upfront. Wrote training manual and User guide based on the data warehouse, data and Cognos system. Trained and supported developer and end users in the Cognos product. Helped the new report writers and troubleshot for report development. Provided information if application needed to be done by Impromptu/PowerPrompt, PowerPlay / Transformer or Cognos Query. Data mining and validation for multiple data sources.

Technology: Cognos 7.2, ReportNet 1.1, Confidential Teradata, Win XP.

BI Developer

Confidential, Dallas, TX

Responsibilities:

• Provided business and technical expertise in the requirements gathering, report design, report development, and support of all client/server layers and components of the data warehouse (DW).
• Data Certification of legacy Data Warehouse to Enterprise Data Warehouse (EDW). Updated old reports (Impromptu - 6) to new Cognos 7 application environment.
• After merger of 3 data warehouse of 3 states (Texas, Chicago, New Mexico), formed the Enterprise data warehouse and developed the corresponding Reports, Cubes and Power Prompt application using EDW.
• Set up reports (Impromptu report, Teradata SQL codes and SAS code sets) on the production cycle using Win batch scripting code to run every month.
• Scheduled and ran production cycle of more than 400 reports every month.
• Published reports on the web using upfront portal. Granted access privilege to the users group on the web, (Access Manager for the web). Building and management of Cognos Catalog. Conduct requirements gathering sessions with business users and served as the systems integrator intermediary between client and DW server back end.
• Developed Data Warehouse Schema (Star Schema and Snow Flak Schema) according to business requirements. Presented Dependent & Hybrid data mart and data to business users.
• Ensured business requirements met the delivered solution. Formulated and defined solution scope and requirements through proactive fact-finding to develop or modify complex decision support front-end systems for the data warehouse.
• Prepared detailed business requirements and specifications from which reports and analytical cubes designed and written.
• Defined and implemented consistent graphical end user interfaces to the Data Warehouse.
• Developed and implemented Training for data access to reports or cubes.
• Performed all data mining for corresponding departments.

Technology: Cognos7 (IWR, Upfront portal), Confidential Teradata, Queryman, WinDDI, Win XP - Professional.

Lead Data Analyst

Confidential, Dallas, TX

Responsibilities:

• Developed logical data model by importing data from multiple data sources in Cognos Architect. Extracted and modified imported data in Data access and Business layers. Transferred to build Package (Data Mart - star and Snow-Flake Schemas) and stored as catalogs for Data/Business Analysis.
• Set up users and user classes for Cognos, assigned privileges to user groups. Managed user and user groups.
• Set up Data Source, Namespaces and Directory server. Also set up security on Cognos Applications.
• Trained new users in groups of 10 to 20 each quarter (classes were on Basic Impromptu, Advance Impromptu, Basic PowerPlay and Advance PowerPlay).
• Worked as team lead on a group of 6 members who established a Data Warehouse designed to support business analysts by generating reports.
• Installed and configured Cognos Applications (Impromptu, Access Manager, Transformer, PowerPlay, Architect, Power Prompt). In accordance with business requirements, built Business Model and Package, Reports & Sub-Reports and also created Power Cubes using Transformer and PowerPlay for Call Center, Telemarketing and Sales Departments.
• Developed and published Reports on the web using Power Prompt, ASP and VBScripts for multiple departments and different geographical regions.

Technology: Oracle, Access, Sybase (T-SQL), Cognos, IIS 5, ASP, VBScripts, ODBC.