SUMMARY

• Extensive experience in Business Intelligence (BI), ETL, Data Warehousing, Reporting, Data Modeling, Data Analysis, and OLAP. Strong in Informatica, SSIS, Cognos, Business Objects, MicroStrategy, SQL, T - SQL, Oracle PL/SQL, and other BI/Reporting tools.
• Extensive experience wif ETL and Business Intelligence (BI) Tools including Informatica ETL, SQL Server (T-SQL, SSIS, SSRS), Business Objects, MicroStrategy, Cognos, Oracle PL/SQL, SQL, Data Modeling, Analytics, OLAP, and Data Mining Tools.
• Strong Experience in SQL, T-SQL, PL/SQL, Oracle, SQL Server, and other databases.
• More than 12 years of IT experience in Business Intelligence(BI), Data Warehousing, ETL, Reporting, Data Modeling, Star Schema/Dimensional Modeling, Data Analysis, Data Mining, Business Analysis, Requirements gathering, design, coding, testing, and implementation.
• Extensive experience wif Informatica ETL PowerCenter.
• Developed ETL processes using Informatica, SSIS, Oracle PL/SQL, SQL, and SQL*Loader.
• Well experienced wif SQL Server BI Tools - Microsoft BI (SSIS, SSRS, T-SQL).
• Well experienced in MicroStrategy BI Tools Suite including MicroStrategy Desktop, Architect, MicroStrategy Web, Report Services, Intelligence Server, and NarrowCast Server.
• Experience in designing and developing MicroStrategy Projects including Schema Objects, Attributes, Facts, Metrics, Filters, Prompts, Reports, Dashboards, and Free Form SQL (FFS).
• Well experienced in Cognos BI Tools including Framework Manager, Report Studio, Cognos Connection, Query Studio, Analysis Studio, and Metric Studio.
• Well experienced wif Business Objects XI (BO XI) BI Suite - Universe Designer, Web Intelligence (Webi), Deski, Crystal Reports, Xcelsius, CMC (Management Console), Infoview.
• Advanced Excel and VBA skills including Macros, VBA, complex formulas, pivot tables etc.
• Extensively used Cognos Framework Manager to develop Reporting Models and Packages.
• Created complex reports, metrics, KPIs, and dashboards using Cognos Report Studio.
• Designed and developed Business Objects Universes, Webi Reports, Dashboards, and Metrics.
• Experience in OBIEE (Oracle BI), SQL Server BI (SSIS, SSRS), Tableau, Excel, VBA.
• Developed and maintained complex SQL Server T-SQL and Oracle PL/SQL Stored Procedures, Packages, Views, Materialized Views, Functions, and various other database objects.
• Well experienced in Extracting, Transforming, and Loading (ETL) data for data analysis, reporting, data migration, data conversion, and other data integration tasks.
• Strong database skills in Oracle, SQL Server, Access and other relational databases (RDBMS).
• Excellent Analytical skills wif strong experience in data analysis and business analysis.
• Extensive work experience wif Healthcare data, Claims, Encounters, HIPAA EDI Transactions.
• Familiarity wif Epic Clarity Data Warehouse and Reporting.
• Broad business functional experience in Reporting and Analyzing data from various business areas including Healthcare / Clinical, Sales, Finance, Marketing, CRM, Call Center Operations.
• Data from Customer Support, Supply Chain, Manufacturing, and other functional areas.
• Experience in business analysis, project management, business modeling, and data modeling.
• Extensive experience in assessment, requirements gathering, business analysis, gap analysis, design, planning, and project management.
• Excellent communication skills, strong business and system analytical skills.
• Successful in Planning, analyzing, coding, documenting, and meeting user requirements.
• Proven track of record on all stages of project and Software Development Life Cycle (SDLC).

TECHNICAL SKILLS

BI/ET: Informatica ETL, SSIS, SSRS, SQL, Business Objects, MicroStrategy, Cognos, Oracle PL/SQL

Databases/Tools: Oracle, SQL Server, T-SQL, Oracle PL/SQL, SQL, SQL*Loader, SQL*Plus, MySQL, Informix, Access, TOAD, OBIEE, MS Excel, Excel Macros/VBA, Power BI, Tableau, Talend, Hadoop, Hive

Business Objects: Universe Designer, Webi (Web Intelligence), Crystal Reports, Xcelsius, InfoView

Cognos BI: Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio

MicroStrategy: MicroStrategy Desktop, Architect, MicroStrategy Web, Report Services (Dashboards and Documents), Intelligence Server, and NarrowCast Server

Operating Systems: Unix, Linux, Windows, HP-UX (Unix), Solaris, SCO Unix

PROFESSIONAL EXPERIENCE

Senior BI Analyst/Business Intelligence

Confidential

Responsibilities:

• Design and development of Reports, Dashboards, Analytics, and Business Intelligence (BI) solutions using Business Objects (BO XI), MicroStrategy, Cognos, SQL, PL/SQL, and Oracle.
• Extensively used Informatica Powercenter designer, workflow manager, and workflow monitor for various ETL activities; Created Informatica mappings, sessions and workflows for ETL.
• Developed and maintained complex ETL (Extract, Transform, and Load) processes using Informatica ETL, PL/SQL, SQL, SQL*Loader, Stored Procedures, Packages, Materialized Views.
• Interacted wif different business teams to gather requirements for reporting and analysis.
• Designed and developed MicroStrategy Projects, Schema Objects, Metrics, Reports, Dashboards, Free Form SQL Reports, and other public objects using MicroStrategy BI suite.
• Extensively used MicroStrategy Desktop, Architect, Report Services, Narrowcast, me Server.
• Developed various Reports, Dashboards, Metrics, and analytics using Cognos Report Studio.
• Designed and developed reporting models and packages using Cognos Framework Manager.
• Developed Query subjects/item, Filters, Calculations, Parameter maps, query prompts, cascading prompts, and other objects using Cognos Framework Manager and Report Studio.
• Design, Modeling, and development of various Business Objects Universes using Designer.
• Created Reports, Dashboards, and Metrics using Business Objects Webi, Deski (BO XI).
• Performance tuning of Reports - Tuning and optimization of database queries and SQL scripts to resolve issues wif reports generation and better performance of reports.
• Reporting, Data Analysis, Data Mining, and Querying using MicroStrategy, Business Objects, Cognos BI, SQL, Oracle PL/SQL, TOAD, and other database query tools.
• Created views, materialized views, summary tables, and aggregates for reporting, analytics, and OLAP using Cognos, MicroStrategy, Business Objects XI etc.
• Developed and delivered ad hoc reporting via SQL queries, PL/SQL Scripts, Views, MS Excel.
• Extraction and Conversion of data from various data sources for reporting and data analysis.
• Maintenance and modification of existing reports as well as creation of new reports.
• Developed ETL processes using Informatica, Oracle PL/SQL, SQL, and SQL*Loader.
• Developed Informatica ETL mappings, PL/SQL, SQL scripts, SQL Loader, and Unix Shell scripts to perform data extraction and load for various reporting and data mart requirements.
• Wrote SQL and PL/SQL scripts to create and modify database objects including tables, views, materialized views, stored procedures, packages, functions, triggers, indexes, constraints etc.
• Data Warehouse/Data Mart design and modeling (Star Schema, Snowflake Schema, Slowly changing dimensions, Facts, Aggregate tables etc).
• Developed complex SQL queries and fine-tuned the SQL queries for performance.
• Profiling of source system data to ensure data quality, and developed data conversion rules.
• Performed requirements analysis and gap analysis, worked wif business users and source data SMEs to deliver data to meet the business intelligence and data analysis needs.
• Extraction of data from database tables to Flat files and various other formats.
• Extensively involved in the requirements gathering, user interviews, business analysis, design, coding, user acceptance testing, and implementation.
• Prepared Business Requirements Spec and Functional Design Documents.
• Developed project plan, test plan, and related project management documents as needed.
• Preparation of test plans; perform unit and integrated testing, and user acceptance testing.
• Troubleshooting of problems during the testing, bug fixing, and documentation.

Environment: Informatica Powercenter, SSIS, Cognos BI, MicroStrategy, Business Objects, SSRS, SQL, T-SQL, Oracle PL/SQL, Oracle database, SQL Server, Cognos Framework Manager, Report Studio, BO Universe Designer, Webi, Deski, CMC, Tableau, Erwin, Unix, Shell scripts, Python, FTP, XML

Database Developer/Analyst

Confidential

Responsibilities:

• Requirements gathering, business analysis, gap analysis, and design for HIPAA and EDI.
• Modification, enhancement and testing of programs and data for HIPAA compliance.
• Development and implementation of daily and periodically run reports and automated batch processes using PL/SQL, SQL, Unix cron jobs calling Unix scripts.
• Wrote SQL scripts and programs to extract data into flat files from database tables.
• Wrote SQL scripts and programs to load data from flat files into database tables.
• Wrote a data migration utility to transfer data from different sources to the central database using Oracle PL/SQL, SQL, SQL*Loader, Informix 4GL, Unix, Shell scripts.
• Design, implementation, support and maintenance of database, tables, and related objects.
• Preparation of test plans, Testing and troubleshooting of problems during the testing.
• Post implementation support, bug identification and resolution.

Environment: Oracle PL/SQL, SQL, Informix 4GL, Crystal Reports, Shell scripts, Unix

Programmer Analyst

Confidential

Responsibilities:

• Data mapping and conversion from the legacy system into Oracle database and testing.
• Data migration from old system to the new system, all related tests and process.
• Design and development of various Reports using SQL, PL/SQL, and Cognos Impromptu.
• Analysis, design, development and implementation of the back-end batch processes.
• Developed and maintained stored procedures, packages, functions, views, triggers, and other database objects using Oracle PL/SQL and SQL for Reporting and batch processes.

Environment: Oracle PL/SQL, Oracle database, SQL, Cognos Impromptu, Informix, SQL*PLUS, SQL*Loader, Forms, Reports, Unix Shell scripts, HP 9000 (HP-UX)