Summary of qualifications

• Offer 25 years of IT experience with last 10 yrs in building BI / Data warehouse solutions and Finance Planning/ budgeting solutions. Prior to that was involved in implementing ERP / EAI solutions at various client locations in US.
• 7 yrs experience in managing BI ETL team and responsible for design and development of BI / DW projects and led a team of BI analysts, data architects, data modelers, BI ETL developers to deliver BI solutions to business users. Customer service focussed engaged with business continously to ensure they have access to information to efficiently meet their objectives.
• Superior communication, interpersonal, and presentation skills Excellent project management, team building skills and expert in building consensus and project engagement across all levels of management and stakeholders.

Professional Experience

Confidential

BI MANAGER

• Manage the BI DW team and responsible for design, development and delivery of BI / DW projects well versed in activities including business requirements analysis, data profiling, data modeling, Solution architecting, ETL design development, OLAP/ Cube development, reports dashboard design, bursting, active reports and their delivery automation etc. Engage with business continously to ensure they have access to information to meet their objectives.
• Architected, Designed, Implemented and Managed setup of Data warehouses using Oracle PL/ SQL, Informatica, OWB and BI Systems including Cognos, Tableau OBIEE at Resmed.
• Manage BI departmental budgets and control actual spending within budget limits
• Lead BI Steering committee with key business leaders/ partners to help present, approve and prioritize BI projects
• Introduce data governance process and involve/ mentor power users from business serving as data owners
• Recently migrated from Cognos 8 to Cognos 10 and implemented latest features like Active reports, Active burst reports,Mobile reporting on iPad etc.
• Helped build BI ETL team at Resmed and great coach/ mentor to the team
• Achieved great productivity from BI / DW teams keeping small team size while expanding BI presence in the company from 20 users to 400 users
• Built BI roadmap for expanding BI usage and promote self-service data access capabilities along with building automated report delivery solutions
• Undergoing POC / prototype for Big data to collect various data sent from medical device products to cloud database , log files splunk etc using Hadoop and store in HDFS and use Informatica Big data connector to ETL into D/W - architecting solution and working with vendor for development work
• Rollout online Cognos access to entire sales team across the Americas for self-service reporting analytics and to help meet their sales targets project included integration Cognos within CRM tool SFDC
• Setup and managed offshore BI and ETL teams to reduce costs to maintain and implement BI projects
• Expanded BI usage by keeping tight control on software costs
• Implemented various BI applications including Cognos, Tableau, Manhattan SCI / SSIS/ SSAS and OBIEE /OBIA solutions
• In-process of re-designing global DW using Informatica as well as consolidating Cognos into single global environment
• Lead and managed various business critical projects like ROS - Resmed Online Store rollout providing business with data to perform reporting analytics on sales promotions and help expand customer base increase sales, TASP True ASP analysis for accurate pricing margin analysis etc

Confidential

SR. BI SPECIALIST

• Cognos 8 Framework Manager Modeling, Report Studio authoring - Includes modeling DMR, relational, OLAP with all various sources, data warehouse/ datamart. Debugging and analysis, publish databases from Cognos Planning, CDS links, Powerplay integrations, Cognos Planning and Cognos Finance integrations
• Powerplay Transformer Cube design/development/analysis
• Assisted BI Users, business analysts and SME's for their requirements gathering using fact qualifier matrix. Conceptual, logical and physical model design, gap
• analysis for model design based on Cognos SIM and TDWI Methodologies
• Mentor and guide business analysts, junior BI resources with Cognos products, issues and business analysis
• BI Processes workflow design, prepare BI Governance process methodologies
• Hardware and server layouts/ architecture design, performance tuning, best practice methods for Cognos setup
• Planned, maintained, configured and loaded user classes required for Cognos Contributor Applications Batch process elist user class update
• Software installations on Cognos environments test and prod , setup, Cognos configurations on BI servers , monitoring, performance improvement steps etc
• Designed security for BI, Cognos Planning, Contributor environments - Package, Folder security planning for Cognos connection designed and implemented for test and production environments, Cognos Planning and Contributor security designed, coordinated with user groups for implemention
• Integrated Cognos Planning with BI, Published databases, maintained /monitored/validated jobs/ reports

Confidential

BI SPECIALIST

• Designed, developed and implemented Cognos - using framework manager modeller, Cognos Transformer, report authoring, Powerplay cube design and BI reporting
• Involved in design of Cubes, star schema modelling and building cubes using Cognos Powerplay and Transformer.
• Provided BI / Data warehouse development and support using Oracle warehouse builder ETL tool, SQL Navigator and Cognos reporting - work performed included coordination with business on DW requirements, design and develop star schemas, cubes/dimensions and link/extaction process from ERP, support DW / ETL jobs using process flows and maps, support ad-hoc reporting for business etc.
• Designed and developed various maps, views, process flows for job scheduling etc for ETL / BI - Data Warehouse to load staging tables and create final data marts
• Provided techno-functional development and production support in BI / Data Warehouse environments including business and systems analysis, root cause analysis, testing etc.
• Performed BPR activities, gap analysis for ERP and BI products like Cognos, ETL etc and developed/supported ERP products - Baan 5.0c, Peoplesoft
• Closely interacted with technical team and co-ordinated technical development and support from both onshore and offshore resources.

Confidential

ERP LEAD ANALYST

• Analyzed user requirements, designed functional / technical specifications, provided techno-functional support in areas of Finance, Manufacturing, Distribution and Supply Chain.
• Studied and converted user requests to functional specifications.
• Lead several IT projects, i.e., adding new site to Baan, development of Baan-Aspect e-Source interface, Archiving, Baan-Lawson interface, Baan 4c2 to c4 upgrade etc
• Performed data migration and conversion
• Designed and developed various new ERP modules
• Mentored other ERP analysts
• Trained ERP user group for better understanding and functioning of interfaces.