SUMMARY:

• Around 12 Years of experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems
• 3 Years of BI - Data architect experience.
• Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert and BCP.
• Completed a large legal expense EDW project that feeds data on a monthly basis
• End to end development of business intelligence solutions. Solution selection, business analysis, project management, and ETL coding responsibilities
• Good understanding of Data warehousing concepts/methodologies- Involved in architectural design, Data Modeling (Star Schema, Snowflake), Designed dimension, Fact and Aggregate tables and slowly changing dimensions
• Provided Architectural design for engineering data unit and launched an ETL application for converting legacy MHC data structures and mapping them to Oracle table structures
• Interpreted high-level business requirements into Logical Business Models (Facts, Dimensions)
• Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
• Enforced naming standards and data dictionary for data models.
• Performed SQL Query performance analysis using Toad Client software for Oracle / SQL Server.
• Responsible for data model design; SSIS/Informatica ETL architecture, design and development; OBIEE architecture, design and development
• Applied normalization as appropriate. Implemented Type 2 slowly changing dimensions. This data warehouse was several hundred Gb in size.
• Designed new ETL packages to support changed environment.
• Create new, modify existing and manage all Informatica ETL programs (more than 250)
• Proficient in configuring the physical/logical/presentation layers of the OBIEE Administration Tool
• Extensive working experience in creating Calculation Measures, Time Dependent Measures, Initialization Blocks and Repository Variables.
• Designed/Developed complex reports in OBIEE Answers/Dashboards, BI Publisher Reports and trained the Business/ Power users to create reports in OBIEE
• Hands On experience integrating OBIEE with Oracle E-Business Suite - Financial Analytics, Oracle Supply Chain and Order Management Analytics
• Configured segmentation in OBIEE 11g.
• Created marketing segments in OBIEE for e-mail and mail notifications.
• Proficiency in object level and data level security management of all aspects of OBIEE.
• Worked in Multi-User Development Environment (MUD) in OBIEE.
• Designed and developed reports from ODS, OLTP, EDW and OLAP.
• Expertise in implementing complex business rules by creating robust mappings, mapplets and reusable transformations using Informatica PowerCenter 9.5.1/9.6.1 and SSIS
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x / 8.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Functional experience in Health Care, Manufacturing and Retail Industry. Have Federal Government experience.
• Excellent skills in Client Relationship Management, interaction with business partners, subject matter experts, portfolio architects and technology partners.
• Involved in Onsite & Offshore coordination.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/2003/2008

Languages: SQL, SAS, VB 6.0, COBOL

Databases: Oracle 10g/11g/12c, SQL Server 2008/ 2012,IBM DB2, MS Access

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling

ETL Tools: Informatica Powercenter 9.5.1/9.6.1 , SSIS,ODI 11.1.1

BI Tools: OBIEE 10.1.3.4.1 / 11.1.7.1 / 12 c, BI Publisher, Tableau 8.2 / 9.0.1

OBI APPS: 7.9.6.4 and 11.1.1.7.1

Data modelling tools: Toad Data modeler, ERwin

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

BI- Data Architect

Responsibilities:

• Experience in Analyzing Data and developing Data Warehouse
• Drove the standardization of data warehouse design and ETL towards a dimensional model.
• Converted Hyperion/SQR reports to Informatica/SSIS.
• Created new ETL Package/Workflow and managed existing packages/workflow.
• Implemented processes to ensure complete and consistent data extracts were provided to the data warehouse.
• Work with Enterprise Data Warehousing team to design effective Star/Snowflake schemas for effective reporting.
• Established the OBIEE 11g BI suite of tools as the preferred standard for presentation and worked diligently to optimize the application architecture and performance.
• Migrated Hyperion Reports to OBIEE
• Built out OBIEE repository to meet organization needs
• Responsible for performance tuning ETL and analytics applications
• Upgraded custom reporting application from OBIEE 10.x to OBIEE 11g
• Managed the application maintenance and support relationship for business intelligence with LA Care.
• Create new and modify existing reports for Senior Management, Financial Management, Claims Management and the Medical Management using OBIEE
• Managed BI projects and third party resources to deliver results.
• Improved communication between teams to build trust and a sense of community. Regular mentoring meetings with key analysts enhanced the team's credibility within the company.
• Responsible for ensuring the Scheduled report jobs complete successfully
• Administered the OBIEE 11g environment, including RPD development and security
• Used salesforce as source to HR reports.
• Configured new application roles and session initialization blocks as part of 11g upgrade.
• Use aggregate functions, fragmentation and time series functions to provide effective interactive Capitation reports and Claims Processing reports to users.
• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Full Life Cycle Development - Includes User Interviews, Analysis, Requirements gathering, Design, Development Etc
• Participate in brainstorm and peer review sessions to do process improvements.

Environment: OBIEE11g / 12c, BI Publisher, Oracle 11g, Tableau 8.2 / 9.0.1, Hyperion, Informatica Power Center 9.5.1/9.6.1 , SSIS, Oracle Data Integrator 11g, SQL Developer, MS SQL Server 2008/2012, Windows 7, TFS, MS-Office Suite and Visio.

Confidential

BI Architect

Responsibilities:

• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary. Defined the Foreign keys and Complex joins between various Dimension and Fact Tables at BMM layer.
• Worked on Business data modeling.
• Analyzed metadata and slowly changing dimensions.
• Have setup data connection for source systems.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Adding new Columns to the Warehouse in accordance with OLTP changes and bringing them to OLAP with new logic to Analytics Metadata for the Star Schema configuration in the Repository.
• Created Repository and OBIEE reports.
• Worked on the OBIEE Dashboards and reports based on the requirements and specifications given by Business analysts.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer.
• Developed a Roadmap for the Client Dashboard and work with Client Partner to deploy a beta dashboard
• Worked for performance tuning by finding out the bottlenecks in Reports.
• Involved in Migration in Development, Testing and Production environment.
• Developed security setup for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Extensive Working Experience in creating Calculation Measures, Time Dependent Measures, Initialization Blocks, Repository Variables and Cache Management.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Implemented Usage Tracking for better administration and auditing purposes.
• Worked with BI Publisher 11g for document composition and delivery.
• Designed templates and created reports using BI Publisher.
• Using BI Publisher developed reports in MS Word using integration feature
• Integrated Oracle BPM with Web Center Content and BI Publisher reports.
• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents

Environment: OBIEE 11g/10g, MS SQL Server 2008, Web logic Server, SQL, Informatica 9.5.1, SSIS, BI Publisher.

Confidential, Westborough, MA

Lead BI Consultant

Responsibilities:

• Customized the Financial Analytics SDE/SILOS Informatica mappings, RPD and reports according to the reporting needs of the client.
• Identified Facts and Dimensions (with levels & hierarchy) and requested changes to the Data Warehouse as per gaps.
• Played a key role in installing and configuring OBIA 7.9.6.3 for Oracle Finance Analytics on Windows 2008 Platform
• Debug and resolve and Financial Statement Generator (FSG) reporting problems for month end purpose
• Prepared custom financial reports for month end MU process using FSG
• Created Ad-hoc reports using Oracle FSG.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schema.
• Added Aggregate measures using Aggregate Persistence Wizard
• Enabled Usage Tracking Table and Dashboards
• Worked on the Time Series Wizard and implemented time comparison measures.
• Worked on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations
• Participate in meetings with business users to review the detail design.
• Manage offshore team of 4 members and managed deliverable.
• Reviewing deliverable provided by offshore team
• Attending milestone meetings with clients.
• Managed resource issues through resource leveling.
• Documented Lessons learnt for future reference.

Environment: OBIEE 11g, Windows Server 2008, Web logic Server, OBIA 7.9.6.3, Oracle 10g, Informatica 8.1, BI Publisher, Oracle FSG.

Confidential, Stamford, CT

Lead BI Consultant

Responsibilities:

• Extensively Involved in Production support, Enhancement and SME support to Rate change management and Warehouse management system.
• Customized the Order management SDE/SILOS Informatica mappings, RPD and reports according to the reporting needs of the client.
• Identified Facts and Dimensions (with levels & hierarchy) and requested changes to the Data Warehouse as per gaps.
• Played a key role in installing and configuring OBIA 7.9.6.2 for Oracle Supply Chain Analytics on Windows 2008 Platform
• Experience in Siebel Marketing. Managed Rate change communication through Siebel marketing and campaign module.
• Created push notification using Siebel CRM - marketing and created Survey pages for feedback.
• Configured segmentation in OBIEE 11g.
• Created marketing segments in OBIEE for e-mail and mail notifications.
• Involved in the Peer-Peer Review process from design to implementation.
• Preparation and review of test plan and test scripts and for unit testing, Integration and system testing.
• Participate in meetings with business users to review the requirements and provide suggestions when necessary.
• Project monitoring at various levels with the Team.
• Follow the quality procedures; prepare the quality documentation and Quality control.
• Managing Remedy tickets, scheduling and tracking it to closure to meet SLA.
• Managed security privileges for each subject areas and dashboards according to user requirements.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Created various narrative views, pivot views, chart views of the data returned by the request.
• Embedded content such as links/images and HTML objects to create Intelligence dashboards.
• Implemented drill-down, guided navigation and Dashboard prompts in making interactive and effective dashboards and reports
• Created Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache
• Designed Interactive Dashboards and created dashboard prompts with multiple selections
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
• Involved in creating dimensional hierarchies to support drill downs.
• Perform in depth Data Analysis and implemented Cleansing process and Data Quality

Environment: OBIEE 10 g, OBIEE 11g, Windows Server 2008, Web logic Server, Shell Scripting, Informatica 9.1.

Confidential

Programmer

Responsibilities:

• Maintain and enhance the corporate application using COBOL, VSAM, DB2, File-Aid and CICS.
• Developing and review of source code in COBOL, CICS, DB2, JCL, VSAM, Stored procedures
• Review the code to check for programming standards and format.
• Develop COBOL programs as per the requirements from the clients
• Design unit test cases for the requirement.
• The applications also involved interfacing with People Soft applications that provide us with input data.
• Planning, tracking and preparing status reports for Project management dashboard (PMO)
• Used SQL, queried the DB2 database to browse/edit in the development and as well as in the preparation of the Test data.
• Execute the test cases and check for any deviations from the expected results.
• Fix any defects found after logging the reason for the defect and the possible solution.
• Coordinate with the testing team to complete functional testing of the module.
• Fix any bugs that are reported after doing an impact analysis of the possible fix.
• Developed new online screens using IMS DC and Transform.

Environment: OS/390, JCL, DB2, COBOL, SQL, VSAM, IMS, Transform.