SUMMARY:

• Over 20+ YEARS of professional hands on IT experience in Data warehouse administration & BI system life cycles.
• Certified in Confidential BI suite of products, trained and worked with the latest Confidential Analytics 11 version.
• 7 YEARS experience working with Confidential (as Technology Application Delivery Lead).
• 3 YEARS experience working directly with Confidential as a full Confidential employee (as Senior BI Consultant).
• 15+ YEARS of strong technical exposure and concepts with good degree of competence in handling BI Tools - Confidential BI Suites (10.x/11) & developing BI best practices/delivery standards and knowledge of programming techniques working with Oracle11i, Teradata and SQL Server Databases.
• Demonstrated leadership and adaptability in providing Corporate Performance Management & Business Intelligence Solutions. Involved with Software Development Life Cycle Methodology (SDLC), SIM (Solution Implementation Methodologies) and Architecture Design, Development, Deployment and Administration.
• Expertise in analyzing data/business requirements, existing system architectures and by interacting with users, implemented solutions for web-based Visual Insights (VI), Metric Studio Scorecards/Dashboards, Query/Reporting and multidimensional OLAP analytical systems. Involved in installation, configuration, troubleshoot, security, maintenance and administration of enterprise BI & DSS applications on UNIX/NT operating systems.
• Also worked closely with Database/ETL Teams and contributed significantly in Data Modeling, ETL, Unit-Integrated-System testing, SQL Programming/Query Optimization and resolving performance/functional issues.
• Trained and implemented SAP S/4HANA, BIG DATA/HADOOP/HIVE with AGILE/Scrum Master/JIRA Methodologies.

TECHNICAL SKILLS:

Applications: Confidential 10/11 BI (Version 10.x/11) - Confidential Clarity Visualizer, Workspace/Advanced, Framework Manager Modeling, Report/Query/Analysis/Metrics Studios, Metrics Designer, Confidential Planning, Data Manager, Confidential Configuration, Confidential Connection Administration/Customization), Upgrade Manager, Confidential Series Legacy Products (Powerplay Transformer, Powerplay Enterprise Server, Powerplay Client, Powerplay Web, PowerPlay Admin, Impromptu/IWR, Power Prompts, Confidential Query/Script, Upfront, Access Manager, Report Net V1.1 MR2, Notice Cast, Visualizer, CMM Configuration Manager, VVM), Tableau Desktop version 6.0/7.0/8.0/8.1 Developer/Admin, QlikView, Microstrategy 10 BI (Version 10.x - Microstrategy Developer/Architect, Visual Insight (VI)

Databases: Oracle V9.x/10g/11i, SQL Server 2008, NCR Teradata, Essbase MDBMS, MSAccess, Salesforce.com

Meta Data / ERP / ETL: Erwin ERX V4.1, Designer/2000 V1.0, Visio, SAP S/4HANA, Informatica, Data Stage

GUI’s: Crystal Reports v11.5, Developer 2000 v2 (Forms/Reports), Visual Source Safe, UNIX - Reflection, Putty V0.58, ClearCase

Languages / Tools: SQL, PL/SQL, Toad, UNIX Shell scripts, Confidential Script Macros, PERL, C/C++, XML, HTML, EC/EDI - GENTRAN Server Win NT

Web Servers: IIS 6.0, Apache 1.3.12, Tomcat

Operating Systems: Windows NT/2000/2003/XP, HP-UX (V11.0 / 11.23), Confidential AIX, SUN Solaris, NCR-UNIX SVR4, Linux ES3-U4 V2., MS DOS

Hardware: HP Itanium GB / V250024GB M, Confidential RS/6000 Server H70, Teradata SDW Server Intel-B2R3, NETFINITY Server 400 MHz, P4 Xenon 700MHz P 2.3G M 70G HD

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Senior BI Developer

Responsibilities:

• Involved in the design, development and deployment of Confidential ( Confidential ) Analytics with Confidential Dashboards/Reports/Ad hoc Query/Multi-dimensional BI Analysis for Healthcare Delivery and Financing Systems.
• Responsible for Confidential Analytics v11 upgrade process from V10 in multi-tiered Win/UX OS and resolved underlying report issues after the upgrade. Involved in Data Analysis, Relational/Dimensional data modeling, extracted data from multiple sources, verified model joins, validated metadata results against database data, and identified Report vs. Data related issues. Analyzed table/views data structures, performed data integrity test, and implemented multiple layers of data/object level security with single sign-on.
• D esigned/developed Confidential reports, Cubes, Advanced Dashboard visualizations & schedule automations.
• Responsibilities include; Analyzing Project Plan, System/User requirements, Deliverables, and Priorities with HM Operational Reporting Team & submit status on weekly basis. Worked on performance tuning of SQL scripts to load/update table/views with data, perform data integrity test, and implement multi layers of data/object level security.
• Analyze user report specification by interacting with Users/Business Analysts collect business requirements (BRDs). Handled Confidential change requests on a daily basis by revising, updating & publishing model/packages with new Tables/Views/Relationships to satisfy complex ad-hoc query and reporting requirements.
• Analyzed/Revised BRD’s by interacting with Business Analysts and created Technical Requirement Documents (TRDs). Created Functional/Program specs, Report Data Mappings, Templates, Development Standards and Proven Practices based on AGILE/JIRA Methodologies. Addressed day-to-day Confidential issues, advised/took corrective actions. Assisted HM team resources to facilitate knowledge exchange.

Environment: Confidential Analytics V11, Confidential BI Suites (v10.x/11) - Framework Manager, Report / Query /Analysis Studios, PowerPlay Transformer, Toad, SQL Server, Teradata, AGILE/JIRA Methodologies, UX/Win NT/XP

Confidential, Pennington, NJ

Technology Application Delivery Lead (Senior BI Developer)

Responsibilities:

• Responsible for design, development and deployment of BofA Data Quality Repository (DQR) Analytical Systems with Confidential Dashboards/Reports/Ad hoc Query/Multi-Layered Analysis in latest 10.x versions.
• Installed Confidential Modeling s/w in a multi-tiered Win/UX OS environment. Involved in Data Analysis, Relational and Dimensional data modeling, Modeling process from multiple sources, verified model joins, validated metadata results against database data, and identified Report vs. Data related issues. Analyzed DQ table/views data structures, performed data integrity test, and implemented multiple layers of data/object level security with single sign-on.
• Extensive experience in developing Confidential reports, Cubes, Advanced Dashboards & visualizations and Performance optimization. Involved in addressing Problem/Incidents managements, Release/Deployments, Service Analytics and Reporting, Production Governance, Confidential to Microstrategy conversions, Confidential 8 version to 10.1 migration issues using Upgrade Manager, performance tuning (SQL analysis/Explain plans) and security administration. Closely worked with COE Admin team in DEV/UAT/PROD Migrations on Information Modeling, Semantic layer design, OLAP Design, Integration, Migration, Quality, Metadata, Data Access, Security, Privacy and Content Management. Analyzed data and Reporting needs of projects, recommended and implemented solutions which maximize the compatibility of data across operating and functional environments including analysis, design and integration of the information related to business needs. Trained & implemented rapid prototyping using AGILE/Scrum Master/JIRA methodologies with BIG DATA/HADOOP/HIVE background.
• Developed Relational/Dimensional models with hierarchical Data/Business functionalities. Designed multi-layered custom Dashboards using dynamic Java/HTML codes with pop-up, Drill-up/down, Drill-Through functionalities. Worked with MetaPortal team to pass dynamic parameters to generate custom Confidential Reports.
• Handled change requests on a daily basis by revising, updating & publishing model/packages with new Tables/Views/Relationships to satisfy complex ad-hoc query/reporting/dashboards requirements.
• Analyzed/Revised BRD’s by interacting with Business Analysts and created Technical Requirement Documents (TRDs). Created Functional/Program specs, Report Data Mappings, Templates, Development Standards and Proven Practices based on SIM (Solution Implementation Methodologies)
• Addressed day-to-day Confidential issues, advised/took corrective actions; assisted BofA team resources to facilitate knowledge exchange. Provided guidance in report developments to optimize and fine-tune overall DQR BI platform performances.

Environment: Confidential 10/11 BI Suites (v10.x/11) - Confidential Framework Manager, Report/Query/Analysis Studios, Upgrade Manager, Workspace/Advanced, BIG DATA/HADOOP/HIVE & AGILE/Scrum Master/JIRA Methodologies, MicroStrategy Developer / Architect, Desktops, Mobile & Web, Report Services, OLAP services, intelligent server, Schema objects QlikView, Custom Java/HTML/XML Codes, Oracle 11i, Toad, SQL Server, Teradata, UX, IIS, Win NT/XP

Confidential, Fairfax, VA

Confidential BI Lead

Responsibilities:

• Responsible for architecture, design, development and implementation of Department of Defense (DOD) & Confidential ’s Defense Travel Systems (DTS) DW & BI system architecture. Supported maintaining & optimizing DTS Confidential BI & ETL processes.
• Maintained, optimized, (Performance Tuning) and monitored mission critical, automated DTS Confidential Cube Build/Delivery processes. I brought down a poor cube building Confidential of 3 days to 1 day cycle of Production cube build/update/data refreshing/delivery process. Performed analysis of existing Confidential -related System Problem Reports (SPRs) and provided recommended solutions and engineering estimates to resolve it on Confidential .
• Performed capacity planning for the Confidential Application server. Assisted NG Operations personnel in DTS Database Server and Storage Sub-System in performing capacity planning. Responsibilities include Review, Update, and Maintain documentation on existing DTS Confidential 8.3 Data Mart capabilities, includes design documents, logical and physical diagrams. Worked with both internal and external users to understand their requirements and translate them into Reports using a combination of SQL, PL/SQL Reports and Confidential 8.3/8.4 and Confidential Clarity Visualizer dashboards. Identified documented, corrected defects and suggested improvements to this process, worked on TM1 planning, budgeting and forecasting reports/dashboards.
• Identified, evaluated, documented, and reported any data access and security concerns to DTS Program Management & Information Assurance. Ensured the process complies with all DTS security, operations, and lifecycle processes and procedures. Worked in a fast-paced and dynamic environment.
• Installed, Configured, Upgraded latest Confidential s/w on Windows & UNIX operating system. Corrected and tested DTS SPRs related to the Confidential Data Mart. Updated existing and created new Confidential reports as requested.
• Analyzed data, worked independently, handled Confidential sensitive stressful production situations, prioritized workloads and schedules, and solved problems. Addressed day-to-day Confidential issues, advised/took corrective actions; assisted NGC team resources to facilitate Confidential knowledge exchange.

Environment: Confidential 8 BI Suites (v8.3 & 8.4) - Confidential TM1, Framework Manager, Transformer, Confidential Clarity Visualizer, Report/Query/Analysis/Metrics Studios, Oracle 11i, Toad, Informatica - ETL, UNIX OS, Shell Scripts, Win NT/XP, IIS, CMM - Level 5 WIKI Documentations

Confidential, Raritan, NJ

Confidential BI Lead

Responsibilities:

• Responsible for information architecture, design, development and implementation of J&J Totality Health Care Compliance (HCC) Applications & new Data Warehouse system architectures.
• Responsibilities include; Analyzing Project Plan, System/User requirements, Deliverables, and Priorities with J&J team and submit status on weekly basis.
• Involved in Data Modeling and ETL process for Transactional vs. Data Warehouse systems, verified model Joins, validated FM metadata results against database data, and identified report/data/server related issues. Fine-tuning of PL/SQL script to load/update table/views with data, perform data integrity test, and implement multi layers of data/object level security. Assisted upgrading Confidential version 8.2 thru version 8.4
• Analyze user report specification by interacting with Users/Business Analysts collect business requirements (BRDs). Handled Confidential change requests on a daily basis by revising, updating & publishing model/packages with new Tables/Views/Relationships to satisfy complex ad-hoc query and reporting requirements. Worked on TM1 planning, budgeting and forecasting reports/dashboards.
• Developed test plans in Mercury Quality Center and involved in Unit/integrated/system testing and deployment of Development, QA and Production phases.
• Addressed day-to-day Confidential issues, advised/took corrective actions; assisted ITS team resources to facilitate Confidential knowledge exchange. Provided guidance in report developments to optimize and fine tune overall BI platform performances.

Environment: Confidential 8 BI Suites (8.3/8.4) - Confidential TM1, FM, Transformer, Report/Query/Event Studios, Oracle 9i, Toad, Informatica for ETL, Mercury Quality Center, HP-Unix, Win XP/2000/NT

Confidential, New York, NY

Lead Confidential Architect

Responsibilities:

• Responsible for information architecture, design and administration of MM Reports and ad-hoc Queries. Responsibilities include involving in the analysis phase of Confidential architectures (Dev/QA/Prod) with GBS team and document systems requirements. Installed Confidential s/w in a multi-tiered Win/UX OS environment. Involved in performance tuning, capacity planning, security and server administration.
• Analyzed existing issues/challenges in existing Confidential 8.2/8.3 environment, based on capacity planning assisted Confidential platform sizing including determining hardware/software requirements.
• Involved in Data Modeling and ETL phases, verified model Joins, validated metadata results against database data, and identified report/data/server related issues.
• Based on the MM Report specs, analyzed & reviewed layout designs/business rules with GBS team resources and implemented proven practices.
• Report results validated, tested, reviewed and documented
• Worked with On-site/off-shore team on unit/system testing, provided technical assistance in performance tuning, troubleshooting and resolving report issues.

Environment: Confidential 8 (8.2/8.3) BI Suite - Report/Query/Metrics/Analysis Studios, Go Dashboard, Informatica, Oracle 10G, UNIX, Win XP/2000/NT

Confidential, Woodbridge, NJ

Lead Confidential Architect

Responsibilities:

• Involved in design, development and implementation of Confidential Retail/Marketing Reports and ad-hoc Queries. Responsibilities include analyzing reporting requirements for Retail Operations/Marketing and Finance. Installed Confidential s/w in a multi-tiered Win/UX OS environment. Involved in performance tuning, capacity planning, security and server administration. Established MicroStrategy to Confidential reports conversion task list and priorities for deliverables. Reviewed/updated report inventory, layout designs and specifications with Confidential team.
• Involved designing/updating/enhancing Data Mart structure and FM Model Package for Retail DW.
• Involved in Data Modeling and ETL phases, verified model Joins, validated metadata results against database data, Identified data related issues, and advised/took corrective actions.
• Designed & developed Metric Studio Scorecards/Dashboards/Reports identified by Confidential team.
• Report results validated, tested and reviewed, updated report designs based on change requests, Scheduled & implemented burst reports with security hierarchies.
• Helped identifying functional differences of Microstrategy migration reports; Demonstrated Confidential functionalities, Design OLAP Metadata, Drill-up/down - Drill-Through. (Dimensional - DMR) capabilities through delivered reports/queries. Worked on TM1 planning, budgeting and forecasting reports/dashboards.
• Built a representative set of reports with Confidential IT team to facilitate mentoring and knowledge exchange.

Environment: MicroStrategy v8.1, Confidential 8.2 BI Suite - Report/Query/Metrics/Analysis Studios, TM1, Data Manager, SQL Server, MS Access, Oracle 9i, Win XP/2000/NT

Confidential

Senior Confidential Consultant, Jacksonville, FL

Responsibilities:

• Involved in information architecture, development and infrastructure implementation of OCDUS/ Vistakon Sales Forecasting Reports and ad-hoc Queries.
• Responsibilities include; analyzing project plan, system/user requirements, deliverables, and priorities with J&J team. Reviewed report specs, layout design mockups.
• Updated “Report Data Mapping” document with requirements and other business logics using standard templates with SIM (Solution Implementation Methodology). Developed FM Model Package with DMR for OCDUS Sales Forecasting (Data/Business Layers) & used best practices.
• Involved in Data Modeling and ETL phases, verified model Joins, validated metadata results against database data. Handled change requests on a daily basis by revising, updating & publishing model/packages with new Tables / Views / Relationships to satisfy reporting requirements.
• Analyzed OCD Sales and Forecast data structure and implemented the unique OCD dynamic Exchange Rate and Currency Conversion business logics in multiple prompt page reports based on the count of currency codes query results & documented.
• Provided technical assistance to J&N team in the development of reports/queries/cubes. Responsible for overall BI platform routine maintenance and administrations, installation/configurations, provide data/application level security management, schedule automations, backup/recovery, troubleshooting and performance tuning.

Environment: Confidential 8 BI Suite (8.3) - Report/Query/Analysis Studios, Data Manager, Oracle 9i, SQL Server, Unix, Win XP/2000/NT

Confidential, Charlotte, NC

Senior Consultant

Responsibilities:

• Involved in Confidential BI information architectural design, development and implementation of 3 BoA reporting phases. Installed Confidential s/w in a multi-tiered Win/UX OS environment.
• Responsibilities include, use capacity planning and analyze system requirements, come up with most efficient design architecture. Involved in Data Modeling and ETL phases, verified model Joins, validated metadata results against database data.
• Monitored/managed BI platform to confirm "twice a day" build/cube refresh is scheduled and executed in accordance with their user community requirements and data availability.
• Involved in production migrations by making sure the automation scripts, build, move, swap and deployment are tested and functional. Tested complex Confidential internal navigations between cubes/reports/dashboards.
• For security, centrally managed/controlled critical User/Groups/Roles; implemented Data/Object/Package level security for Authorization/Authentication process. Developed test plans and involved in Unit/integrated/system testing process across Dev, QA & Production. Assisted identifying & troubleshoot list of QC defects in UAT.
• Created timing & audit logs to track Metric Studio Scorecards/Dashboards/Reports performances, identified data related issues, advised/took corrective actions and provided guidance in reports/cube developments to optimize and fine tune overall BI platform performances.
• Created functional/program specs, templates and development standards based on SIM methodologies.
• Standardized the look and feel of advanced “Executive Dashboards” to comply with BoA standards.
• Based on observations and Confidential best practices, provided recommendations and addressed day-to-day issues.
• Trained BoA team to build representative set of reports to facilitate Confidential knowledge exchange.

Environment: Confidential 8 BI Suite - Confidential FM, Transformer, Metrics Designer, Report/Query/Metrics/Analysis Studios, Oracle 9i, Unix, Shell scripts, Win XP/2000/NT

Confidential, Gaithersburg, MD

Lead Confidential Architect / Developer

Responsibilities:

• Responsible for information architecture design and implementation of Executive Performance Dashboard Reports and ad-hoc Queries. Involved in Data Modeling and ETL phases, verified model Joins, validated metadata results against database data, and identified report/data/server related issues.
• Responsibilities include, installation/configuration of Confidential suites of products, routine maintenance and administration, schedule automation, analyzing & delivering dashboard report requirements for Performance, Comparison, Compensation, Trends, Plans, Attainment & payout reports with FluMist & Synagis products in focus.
• Implemented security for different levels of Regional, Area & Territory analysis combined with bursting features.
• Complex multi-layers of graphs Metric Studio Scorecards/Dashboards/Reports used with the combination of Drill up/down and Drill thru functionalities in portlets to handle data security in multiple level of user hierarchy.
• Migrated BO Reports and converted their current business logics into Confidential reports.
• Assisted Confidential team with Confidential miscellaneous best practices to improve report performances. Analyze & troubleshoot Confidential system/day-to-day issues, provided problem resolutions.
• Given Users training, demo and provided Confidential critical on-line production technical supports.

Environment: Confidential 8 BI Suite - Confidential FM, Transformer, Metrics Designer, Report/Query/Analysis/Metrics Studios, SQL Server, Win XP/2000/NT

Confidential, New York, NY

BI Lead

Responsibilities:

• Responsible for information architecture, design, development and implementation of Financial Reports and ad-hoc Queries. Involved in Data Modeling and ETL phases, verified model Joins, validated FM metadata results against database data, and identified report/data/server related issues.
• Responsibilities include, analyze customer report specifications, by interacting with Users/Business Analysts collect business requirements, and categorize report groupings with Account/Data Mappings, Design/Develop FM Model and on-demand and batch BI Reports. Designed OLAP metadata for multidimensional cube analysis. Fine tuning of PL/SQL script to load/update table/views with data, perform data integrity test, and implementing security.
• Created functional/program specs, templates and development standards and proven practices.
• Developed test plans and involved in Unit/integrated/system testing and deployment of Development, QA and Production.
• Upgraded Series 7 version of Reports/Cubes to Confidential 8

Environment: Confidential 8 BI Suite - Report/Query/Analysis Studios, Oracle 9i, Win XP/2000/NT