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.
• 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.
• 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 teh 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 teh entire IT lifecycle.
• Planning, designing, implementations include infrastructure, data warehouse and BI applications.
• Vendor negotiation and communication with management and to sway teh opinions of corresponding party at teh 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 teh 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.

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

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 teh strategic and tactical information management function for teh 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 teh 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 teh complete decision support and management cycle systems.
• Provided state of art BI applications to senior executives (CFO, VP of Pharmacy, Directors).
• Designed teh 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 (HIS) 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 teh 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 teh Caboodle data warehouse (an enterprise data warehouse platform) Set up teh process to build best of teh best technical and functional resource to secure future for teh 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 teh business regarding their data, reporting and analytic needs.
• Promoted teh development of self-service capabilities for teh business in teh 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 teh 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 teh development and expansion of teh Business Intelligence infrastructure and ensured data integrity.
• Oversaw progress on major BI initiatives including schedules, scope, resourcing, etc.
• Supported teh management of daily activities for teh 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

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 teh 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 teh SOX and company policy and practice got implemented.
• Trained users in class sessions and at teh user’s location if needed.
• Project Management (Finance) Phase me: Managed data warehouse BI applications with teh help of 2 off-shore (Indian and Russian) teams of more than 15 employees for teh 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.
• 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 teh 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 teh goals and deadline for projects.
• Established teh standard and best practice to provide quality data to teh on-site and off-site clients (users - Germany) in diverse environment.
• Coordinated teh 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.
• 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 teh 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.
• 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 teh 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

Confidential, CA

Responsibilities:

• Setup and upgraded advance BI environment for multiple departments/Branches, established teh best environment for BI among ReportNet 1.1 MR2, Cognos Series-7.1 / 7.3 and Database. Customization of upfront user interface per Navy standard. Migrated Cognos applications from 7.0 to newer 7.1 MR1/MR2/MR3 using Deployment Manager.
• Established data warehousing system by migrating data from Mainframe to teh Oracle and setup multiple data marts using star and snowflake schemas (In teamwork).
• Migrated IMR reports and Architect models to ReportNet environment and replaced 30 years old Mainframe legacy reports with Cognos BI tools.
• System setup for batch jobs/Scheduling for reports and cubes for production environment. Set up, supported and maintained Cognos applications to move over to production server from staging and development area. Data mining, verification and application output accuracy as well as documentation for applications and server performance enhancement.
• Planned and managed teh set up of BI (OLAP/MOLAP/ROLAP) environment based on teh end user as well as management level. Developed and supported Client & Server side as well as end user side. Gathered requirements, analyze it, designed model (star schema), built Applications (cubes, reports and CQ) and supported users (user admin - Access Manager). Setup directory structure for teh production environment and smooth performance.
• Set up ReportNet to email reports to corresponding users and users’ groups around teh world. Updated ReportNet from 1.1 to 1.1 MR2, keeping all data as is in teh content store. Converted Catalogs, IMR and CEM files to XML files for ReportNet and imported to teh 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 teh Upfront Portal. Developed IMR report and put PowerPrompt (using JavaScript and HTML) on IMR and finally published on teh upfront. Wrote training manual and User guide based on teh data warehouse, data and Cognos system. Trained and supported developer and end users in teh Cognos product. Helped teh 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.
• Provided business and technical expertise in teh requirements gathering, report design, report development, and support of all client/server layers and components of teh 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 teh Enterprise data warehouse and developed teh corresponding Reports, Cubes and Power Prompt application using EDW.
• Set up reports (Impromptu report, Teradata SQL codes and SAS code sets) on teh 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 teh web using upfront portal. Granted access privilege to teh users group on teh web, (Access Manager for teh web). Building and management of Cognos Catalog. Conduct requirements gathering sessions with business users and served as teh 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 teh delivered solution. Formulated and defined solution scope and requirements through proactive fact-finding to develop or modify complex decision support front-end systems for teh 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 teh 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), NCR 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 teh web using Power Prompt, ASP and VBScripts for multiple departments and different geographical regions.
• SAS programming using SAS/BASE, SAS/MACRO, SAS/SQL and basic SAS procedures (Tabulate, Means, Datasets, etc.).
• Use of SAS/CONNECT to communicate between local SAS and SAS/Server.
• Use of SAS/ACCESS OR SAS/ODBC to communicate with other RDBMS.
• Imported raw data, created and enhanced list Reports. Imported and transformed raw data and created Graphical Reports. Used SAS/ODS to create HTML, Listing, Output, and Data reports.
• Designed a Data Warehouse: project served teh purpose of supporting business decisions by analyzing and evaluating teh market and its different trends.
• Denormalization of data, developed target table, star schema, snowflake schema, and fact tables, data modeling and mining, moving data into target tables.
• Built multi-dimensional cubes and reconciled financial information from new and old legacy systems.
• Created reports on OLAP data using PL/SQL Scripts and Oracle Reports.

Technology: Oracle 8i, SQL*Loader, PL/SQL, SQL*Reports, Erwin, Windows NT.