Business Intelligence Architect Skills

• Included creating process documentation, agile project management techniques, continuous improvement, data warehouse performance improvement and post project mentoring.
• Participated in the design and development of an intricate, comprehensive data warehouse solution to standardize reporting across hospital systems.
• Managed multiple efforts for medium to large clients building enterprise data warehouse and business intelligence solutions.
• Developed and maintained enterprise data warehouses for a variety of lines of business and department analysts.
• Reviewed logical data models and acted as liaison between data warehouse and application development groups.
• Identified data quality was a gap preventing successful implementation of target data warehouse architecture.
• Facilitated regular technical training for the data warehouse / business intelligence staff.
• Helped integrate data warehouses into Business Objects Universes for specialized finance analysts.
• Developed COGNOS Framework Manager Models and supporting Database/Data Warehouse Data Models.
• Developed code review guidelines for ETL applications and Data Warehouse applications.
• Developed SSIS processes to integrate SalesForce data with enterprise data warehouse.
• Performed data modeling for an extensive data warehouse.
• Redesigned and replaced legacy data warehouse ETL/Cube environment.
• Performed Data Warehouse tuning and optimization.
• Customized OBIA ETL mappings and table extensions to design the Star Schema and populate the Data warehouse based on business requirements.
• Experienced in modeling, designing, and developing OLTP databases, Data Warehouses (Dimensional Modeling), and Data Marts.
• Managed multiple BI project enhancements by collaborating with ETL team to integrate new data feeds and fields into Oracle data warehouse.
• Designed data warehouse architecture using dimensional modeling (Star Schema, ETL processes, EDW, and Data Marts).
• Provided guidance to the government client in their effort to consolidate multiple data stores into an integrated enterprise data warehouse.
• Designed and developed complex ETL Processes using Microsoft Integration Services (SSIS) and Stored Procedures to service data warehouses.

Show More

• Conducted interviews with various business users in identifying and capturing business requirements; defined and developed project scope/plan.
• Gathered and translated business requirements into technical specifications using structure techniques and data warehousing methodology.
• Designed the logical data model incorporating a slowly changing dimension to meet all business requirements.
• Collected and documented business requirements for delivering BI content to various areas within Funds Management.
• Performed feasibility studies to translate business requirements into an appropriate technical architecture/design.
• Developed reporting models, frameworks and strategies based on business requirements.
• Collaborated with end-users to analyze business requirements and processes.
• Analyzed business requirements to develop complex business metrics.
• Coordinated with multiple architects that support business requirements.
• Conducted business requirements gathering and process analysis sessions.
• Designed and implemented the security in XI 3.0 as per business requirements for 3100 users.
• Worked with Business Analyst team to ensure business requirements were sufficient to define system needs.
• Developed and lead teams to develop SSRS reports based upon company standards and business requirements.
• Formulated system requirements from the business requirements and implemented Hyperion Strategic Finance (HSF).
• Developed business requirements for the data mart.
• Developed and maintained functional IT roadmap in correlation with business requirements.
• Co-ordinated the development efforts with offshore team, and delivered the reports as per business requirements.

Show More

• Performed as technical owner for introducing Tableau desktop and server as a preferred data visualization tool for analytics.
• Directed implementation of Data Warehousing, Business Intelligence and Predictive Analytics for all internal business systems.
• Placed Data Engineers in business departments to increase analytics maturity throughout the company
• Identified the data, designed the data models required for Advanced analytics which is used for data discovery using Tableau tool.
• Worked closely with executives at client firms to understand requirements and suggest solutions and technology for BI reporting and analytics.
• Developed and enhanced marketing analytics reports for the new product strategy and development group with a focus on business insights.
• Designed & developed data analytics products & platform for micro-markets POS, vending machine & unattended retail.
• Led the OBIA 7.9.6.3 (Human Resources Analytics) customization effort sourced from the following systems:.
• Implemented Procurement and Spend, Order Management, and Financial analytics using Oracle Business Intelligence.
• Performed data mining and data validation of unique visitors for Site Analytics.
• Worked with clients in the implementation of the Business Intelligence Analytics Product.
• Led a Software Vendor Selection process for an analytics and reporting application.
• Rolled out more than 56 end-user reports and analytics in 18 months.
• Designed and developed Financial Analytics and Clinical Analytics commercial software products in use by many medical organizations.
• Designed Healthcare master data sets as dimensions to understand and analyze patient accounting analytics.
• Worked on Inventory management / Item Master analytics and Transportation Analytics.
• Helped architect multi-dimensional security model for Advanced Analytics.
• Architected and managed a BI project solution for a Canadian bank that provides analytics to measure the effectiveness of loan management.
• Worked on Wiley Online Libraries web-logs to collect clickstream data that empowered the business with a robust web-analytics solution.
• Presented a BI roadmap taking the BI capabilities from basic reporting to prescriptive analytics.

Show More

• Designed and implemented a unique metadata driven ETL solution for aggregated facts using partition switching and parallel processing.
• Developed front-end, metadata and ETL specification to support business requirements for reporting across the organization.
• Developed process/guidelines for MUD development, RPD/Catalog/ETL/DAC code deployment and performing full load in production environment.
• Implemented technical database solution including data modeling, data base design ETL solutions.
• Developed Best Practices documentation for ETL and Business Intelligence development.
• Accomplished performance tuning of production ETL/SQL and database operation.
• Coordinated day-to-day ETL progress monitoring.
• Played as an ETL Architect in the Data Acquisition and Data Quality Group at US Air Force Expeditionary Combat Support System.
• Mentored solution, data architects & tech leads on business processes, best design & ETL practices and various BI applications.
• Gained greater exposure to ETL, creating dummy data, writing SQL stored procedures, and reporting in Crystal Reports.
• Analyzed and identified the Tables/Views, Procedures and ETL objects that need to be migrated and prepared necessary documentation.
• Created High Level and Detail Design documents for ETL design specifications, data migration and data scrubbing processes.
• Provided an analysis of the current ETL load strategy and changes required to move to an incremental load.
• Worked with ETL team and DBA to work on efficient data processing and performance on data base.
• Analyzed/modified and extended delivered SDE & SIL ETL mappings, DAC tasks to tailor to the requirements.
• Designed, enhanced and deployed Claims, Referrals and Membership Data Marts adopting Star Schema for ETL/ELT.
• Created complex ETL solutions loading more than100GB of raw data daily/weekly into staging SQL Server DataWarehouse.
• Worked with ETL engineers and DBA s to create data structures that enable efficient report performance.
• Utilized indexing methods and optimized the ETL process using the new features of SQL 2012.
• Implemented a migration process of business intelligence data stores, reports, & ETL programs.

Show More

• Worked as a Business Intelligence Architect/Developer at the Office of Under Secretary of Defense at the Pentagon (Comptroller).
• Served as the Microsoft Business Intelligence architect.

Show More

• Designed and developed Data Quality reports and dashboards to ensure production data maintained the highest level of data integrity and consistency.
• Developed multiple Views and combined them into Dashboards for interactivity by providing Quick Filter and Parameters for further data drilling capability.
• Created executive presentations that defined the current state environment and future state/capabilities for reporting, dashboards and predictive analysis.
• Guided team of junior analysts in developing and documenting reports and dashboards and implementing maintenance and issue resolution processes.
• Developed and maintained monthly dashboards that served as a tool for administrators and clinicians to monitor financial and operational efficiency.
• Deployed MicroStrategy Mobile reporting app for executives to provide interactive dashboards on key performance indicators for various channels.

Show More

• Bridged the gap between corporate finance and information technology divisions to develop agreed upon solutions and assisted in delivering the project.
• Led requirement definition and refinement; then researched, recommended and assisted with the implementation of solutions.
• Led a business strategy effort to assist the adoption of Business Intelligence technology within a large organization.
• Assisted in developing a Classic Application via loading/extracting the metadata and configuring application settings.
• Designed and implemented SSIS templates to standardize logging, notification and database connections.
• Provided technical assistance to offshore.
• Assisted with Property and Casualty data integration initiative from a recently acquired company, Allied Insurance, purchased by Nationwide.
• Assisted in importing and validating historical data from Oracle GL into the target FDM application and reconciliation of the data.
• Saved over $100k/year by creating SSIS packages to automatically import and export data to new expense-reporting and reimbursement system.
• Designed and implemented standard template of SSIS packages to load data from operation databases into ODS, data marts.
• Created several extracting stored procedures in SSIS ranging from other MS-SQL databases, Excel documents and text files.
• Developed Patient Blood Management SQL Server Analysis Services Cube and SSIS Package (SQL Server 2014).
• Created method to extract data directly from BO into SSIS using web services and C#.
• Assisted in the design and development of SQL Server Analysis Services 2016 Clinical and PB/HB Cubes.
• Used object manager to assist with promotion process, from our development environments to production.
• Assisted IV&V team in fulfilling CMS guidelines of DSS/DW checklist for MMIS certification.
• Merged the two sets of data into seamless reporting using SSIS on SQL Server 2008.
• Assisted in developing the current and future consolidation process and defining pain points for resolution.
• Worked with DBA's on creating new aggregates to assist users with reporting requests.
• Assisted clients in creating groups, folders, and categories to simplify maintenance processes.

Show More

• Managed well file business process definition, requirements gathering, architecture solution, foundation system integration for Information Delivery System.
• Created system architectures, managed client relationships and ran several simultaneous projects.
• Designed and Implemented tableau infrastructure architecture using Azure SAML SSO authentication.
• Developed and started implementation of architecture to modernize BI delivery.
• Developed Architecture for all new Business Intelligence delivery.
• Delivered architecture to support various company projects.
• Delivered reusable reporting architecture and security implementation.
• Included architecture and systems analysis documentation.
• Developed the overall system architecture.
• Documented System Architecture, Production Support guides, Source to Target mappings for end to end data integration process.
• Standardized the framework for the web and established the guidelines for data access in compliance with standard architecture.
• Established guiding principles, standards and best practices for business driven data architecture and related technologies.
• Developed a Master Data Architecture (MDA) to track Clinical Study management and reporting.
• Created technical documentation for system builds, installations, and upgrades * Defined and documented requirements and high-level architecture.
• Provided standards across business/technology teams to ensure alignment between business solution definition & systems architecture for the organization.
• Designed and implemented scalable architecture for content management; provided custom training, support, and recommendations.
• Identified, analyzed, and communicated architecture and integrations options and made recommendations to management.
• Served as key business solutions architecture performing BI solution requirements solicitation and documentation.
• Designed client future state data flow, system architecture and redesigned their Planning / Essbase (ASO/BSO) cubes for optimization.
• Architected and designed high available SAP HANA MDC scale out architecture to support multiple business units of Mohawk Industries.

Show More

• Deployed SSRS, Scorecard, and tabular reports to the SPS sites and libraries.
• Developed an Alerts Platform to push reports based on SSRS data driven subscriptions.
• Utilized Power BI, Tableau, SSRS and Excel for data visualization.
• Implemented and maintained SSRS security.
• Worked as SSRS developer, working closely with Business Analysts gathering and clarifying data reporting requirements.
• Deployed and configured SSRS reports to Reporting Server using Report Manager and Configured report subscription for report delivery purpose.

Show More

• Performed extensive data analysis on Tableau PostgreSQL content store to create data models for custom visualization around Tableau server usage.
• Orchestrated operational objectives including identifying business intelligence, reporting and data analysis needs.
• Involved in detail data analysis of data validation, Cleansing, Data consistency and data quality checks.
• Documented to Data analysis and generating the assessment reports for Chevron's stake holder to review.
• Performed detailed unit / system testing / peer review with in-depth data analysis on various projects.
• Used Dashboard Manager and Crystal Xcelsius to visualize and bridge the gap between data analysis to enhance the data presentation.
• Performed data analysis using SQL in Sql server to address the missing data issue and fixed queries for GEMS project.
• Trained end users in understanding the canned reports and how to develop simple ad-hoc reports for their data analysis.
• Developed PL/SQL procedures then performed system/data analysis to port SQL to Informatica mappings and workflows.

Show More

• Designed and built ETL and SSAS Cubes using relational tables, public API's and flat files as sources.
• Developed SQL Server Databases with SSIS, SSAS, and SSRS to support Enterprise and client Data needs.
• Designed and implemented SSAS cubes and data mart for Product Management, Game Development and Accounting/Finance Team.
• Reviewed the SSAS tabs for team and demonstrated the best practice to develop the cubes.
• Created application specific data marts and deployed SSAS cubes on top the data marts.
• Utilized Microsoft BI (SSAS and SSRS) to provide analysis of sales data.
• Created multiple MS SSAS OLAP cubes to support interactive analysis and fast reporting.
• Performed Data Modeling using SQL Server Analysis Services (SSAS).
• Developed solution using Microsoft SQL Server, SSAS, SSIS.
• Created self-service reporting interfaces using SSAS and Business Objects.
• Implemented End-to-End Business Intelligence (BI) stack solution using SSIS, SSAS, SSRS and MDX.
• Designed and Developed OLAP Cubes using SAS EBI, SSAS 2005, MSAS 2000.
• Trained Users on the new Mart and SSAS cube.
• Developed 1.5+ GB SQL OLAP/Cube using SSAS.
• Implemented shared hierarchies (SSAS 2000).
• Designed, developed, configured, and deployed MS SQL SSRS, SSAS, reports and analytics.
• Trained users with SSAS 2005, Performance Point, ProClarity and SharePoint Portal.
• Performed tradeoff analysis and demos of SSAS OLAP and Oracle OLAP Cubes.
• Created the OLAP cube, kpi's and calculated members using SSAS.
• Designed and developed SSAS cube for use in Cross-sell/Up-sell analytics.

Show More

• Developed and personally coded internal IntraNet website based upon SQL-server and ASP web technology.
• Automated numerous regulatory requirements through data extracts and custom SQL reports.
• Developed interactive reporting and analysis delivery platform with SQL Reporting Services (SSRS) and Crystal Reports to support accounting teams.
• Designed an internal ASP.NET web form app in C# & MS SQL Server for creation of lab reports and invoices.
• Developed best practice SQL backup strategies including full transaction log and simple backups to ensure business appropriate time of failure resurrection.
• Coded a Technology Solutions-specific Sales Order Processing (SOP) system based on Visual Basic 6.0 and SQL Server 2000.
• Migrated Pre-Existing Access and SQL 2000 Databases and Data Transformation Services (DTS) Packages to SQL 2005.
• Mentored teams on advanced SQL topics including SQL development and tuning as well as the Microsoft BI Stack.
• Mentored team members for a financial project on how to build cubes in SQL Server Analysis Services.
• Designed and implemented solution using Microsoft Reporting Services, C#, ASP.NET, and SQL Server.
• Added SQL job notification to all BI jobs to notify team of issues and cause of failures.
• Developed the overall SQL Server and Business Objects Integration architecture for the client and process areas.
• Microsoft-certified in SQL Server Business Intelligence (MCITP) and Database Development (MCTS).
• Migrated data, transaction processing, and reporting from legacy Ingres database into SQL 2012.
• Worked on SQL Database replication for creating another database in order to reduce data traffic.
• Created Manhole Inspection System for the Public Service Commission using Visual Basic & SQL Server.
• Administered SQL Server databases that included backups, optimizing, security, and troubleshooting.
• Designed reporting tables in SQL Server to handle complex requirement for GEMS project.
• Devised table and SQL scripts to load test data into Oracle tables.
• Identified performance issues and optimized SQL Server 2012 environment and database solutions.

Show More

• Decomposed business logic for data mapping to be implemented using COGNOS Framework.
• Worked closely with executives and senior management to develop reporting solutions for all business units using Cognos Query and Report Studios.
• Created presentation quality reports into zero-client application with Cognos and Business Object Reports.
• Re-Architected Legacy Cognos Environment reducing operational support issues by 75%.
• Designed and Implemented security solutions for Cognos using Active Directory.
• Managed and maintained Cognos infrastructure for the Rational division.
• Created test plans to verify the accuracy of the information delivered by the Cognos reporting environment.
• Phased out the legacy Cognos solution by providing custom executive Daily Sales reporting through BI Publisher.
• Worked on the Cognos 10.1 and 10.2 upgrade projects in capacity of modeler and report developer.
• Performed administration for Cognos environment, including maintenance, upgrades, and performance tuning.
• Conducted training on use of Cognos suite as well as data structures and usage.
• Designed the Cognos Portal and implemented a Wiki for the Business Intelligence Users.
• Created technical documentation for the IS department on using the Cognos products.
• Performed Cognos 8.2 to 8.3 report migration during final phase of deployment.
• Upgraded Framework Manager Models, Transformer Cubes and reports from Cognos 11.
• Created training manuals for the Cognos products for the end users.
• Integrated Active Directory roles and groups with the Cognos reporting environment.
• Administered Cognos 8 environment for 300 consumers across multiple business lines.
• Designed and developed multiple SDK applications from Cognos and Tableau.
• Created end user documentation on using the Cognos products.

Show More

• Designed a STAR schema data model for handling the OLAP reporting and Ad-Hoc querying needs.
• Designed and taught a one-week training course in OLAP programming for a client company.
• Redesigned large Oracle OLAP marketing analysis system with more than a terabyte of data.
• Provided subject matter expertise to other branches of the firm with OLAP cubes implementations.
• Trained report developers to leverage OLAP data source for the development of SSRS reports.
• Automated the process for building and monitoring OLAP cubes creation.
• Created and maintained OLAP universes sourced from BW.
• Developed OLAP Standard and AD HOC reports.
• Developed multiple Cognos frameworks to simplify end users access to information via OLAP or ROLAP data structures.
• Designed and modeled star schemas to support reporting and OLAP needs.
• Administered OLAP database schema Analytic Workspace User and Temp resources.
• Created database schemas with grants to OLAP_USER and OLAP_ADMIN.

Show More

• Utilized MicroStrategy data blending features to join data at dashboard level to achieve desired performance requirements.
• Created project metadata using MicroStrategy Architect and deliver MicroStrategy prototype reports.
• Developed numerous MicroStrategy attributes, facts, MicroStrategy Intelligent Cubes.
• Implemented and delivered MicroStrategy mobile dashboards via MicroStrategy mobile application.
• Coordinated and performed all MicroStrategy software upgrades.
• Provided expertise in the development of MicroStrategy Dashboards: Resurrected a Sales and Marketing dashboard, made changes for a demo.
• Implemented MicroStrategy 9.4.1 for web and desktop reporting, designed data cubes, dashboards, self-serve, and interactive reports.
• Developed proof of concept dashboards using MicroStrategy to provide the Business options for their Dashboard design.
• Designed the MicroStrategy BI High level & low level documents for developing the data model.
• Contacted MicroStrategy Support, on 10 occasions, following through from problem to resolution.
• Designed and Developed Templates, Filters, and OLAP Reports using MicroStrategy Desktop.
• Played key role in upgrading current MicroStrategy 6.5 application to new 7I version.
• Developed a MicroStrategy training program to roll out for the wholesale businesses.
• Guided and Mentored team members in the migration process of MicroStrategy objects.
• Architected MicroStrategy report and dashboard design specifications for implementation of development best practices with respect to report performance and re-usability.
• Configured all MicroStrategy components like MicroStrategy Desktop, Intelligence Server, Web and MicroStrategy Narrowcast Server on NT Servers.
• Administered MicroStrategy Security for all users, and monitored licenses to comply with MicroStrategy licensing agreement.
• Developed institutional reports using Tableau and MicroStrategy *Functioned as sole MicroStrategy administrator for 18 months.
• Constructed MicroStrategy project and dashboard/reports to aid cyber analysts.
• Implemented Microstrategy security for different business users.

Show More

• Developed PL/SQL stored procedures & packages, Established data retrieval standards through code libraries and conducted code reviews.
• Created, database links, synonyms and materialized views, and maintained, and tuned PL/SQL queries.
• Pushed out custom PL/SQL function from Oracle to BOXI Universe.
• Modified PL/SQL code to ensure data source is correct.
• Created Logical and Physical Data Process using ERWIN Process Modeler and MS Visio to implement with PL/SQL.
• Redesigned oracle database tables and created pl/sql packages to improve application performance.
• Streamlined and implemented Water/Wastewater asset-data-management processes (PL/SQL procedures) that greatly enhanced the management reporting capabilities on Wastewater utility data.

Show More

• Created Java programs in conjunction with Tableau Command Line Utility to automatically generate PDF output from dashboards on Tableau Server.
• Created a silent/auto print solution for web portal users using Active Tree Java PDF libraries and NetBeans IDE.
• Created an automated email daemon to notify clients of available lab results using Actuate and JavaMail API.
• Developed user interfaces using HTML, Javascript, CSS, Server-side includes and Perl template modules.
• Managed various Java SDK jobs scheduled in ASG Zena application for daily / weekly execution.
• Adapted existing Java based data load application for Netezza database thus making first generation of Netezza data warehouse operational.
• Developed using IBM Cognos 8/10 BI framework, Transformer Cube, JavaScript and Red Brick database as the backend tool.
• Customized Siebel Analytics look and feel by modifying or creating style sheets, xml messages and javascript components.

Show More

• Prepared several architectural artifacts that include metadata, partitioning & indexing strategies, data naming standards.
• Conducted gap analysis based on out-of-box metadata/reports and client reporting requirements.
• Managed data lineage and metadata.
• Evaluated new tools and technologies; managed the metadata and designed & developed several Business Objects Universes and Reports.
• Designed and built custom Narrative Views, metadata, and database objects to enable prompt display in excel.
• Provided a mapping of the fields: A document which lists the Metadata mapping from source to target.
• Created Business Objects SDK scripts for manipulating scheduled report recipients, destinations, and other metadata.
• Designed/developed metadata, reports, and dashboards to be accessible by various levels of users.
• Provided data governance support in keeping the metadata repository and the customer-wide system in sync.
• Designed and implemented the data layer for the Metadata Management Tool (MMT).
• Designed & developed custom metadata, reports, & dashboards.
• Developed procedures and best practices for OBIEE metadata multi-user development and change control.
• Worked extensively on Cognos Metadata definition for prompts, metrics and dimensions.
• Performed technical assessment of Metadata and query performance for several Vendors prior to final selection of Cognos BI for extended POC.
• Identified and corrected anomalies in the Micros- trategy project metadata and SQL generation.

Show More

• Established connectivity to Apache Hadoop from Cognos as well as Tableau.
• Trained & implemented rapid prototyping using AGILE/Scrum Master/JIRA methodologies with BIG DATA/HADOOP/HIVE background.
• Developed efficient MapReduce programs for filtering out the unstructured data on a Hadoop framework implemented in Pseudo Distributed Mode.
• Participated in Hadoop cluster development.
• Conducted research and provided recommendations on providing exploratory analysis utilizing hadoop and other big data technologies.
• Used Hadoop HDFS, Python to implement data retention process, monitoring, communication with upstream and downstream application.

Show More

• Provided technical leadership and guidance for Data Warehousing and reporting solutions; enhanced the existing Data Warehousing environment into EDW.
• Coordinated conformed Dimensions between EDW projects.
• Created ETL frame work to extract data from corporate EDW SDI data-mart to provide updated info to external corporate customers.
• Created and modified normalized (3NF) data models to incorporate enhancements and to resolve defects in the EDW.
• Researched all IBM mainframe data source feeds and completed all data mapping to Marketing Analysis EDW worksheet specifications.
• Developed a standard Reference data repository and shared entities used by the EDW and subsequently several other projects.

Show More

• Worked on different data sources such as Oracle, Teradata and Flat files.
• Prepared the semantic layer in Teradata database to be used by BOBJ environment.
• Reviewed performance of OBIEE dashboards, spotfire IL queries; created teradata join indexes, secondary indexes, partition primary indexes.
• Worked on data sources such as Oracle and Teradata Involved in debugging of Mapping and other components like unix scripts.
• Managed a data warehousing project to make SeaWorld presence possible in Teradata data warehousing environment.
• Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.

Show More

• Defined Business Intelligence strategy for enterprise implementation with various technical subsystem components focused on self-service principles with familiar business tools.
• Conducted comprehensive vendor assessment and developed vendor scorecards to evaluate business intelligence software for enterprise adoption.
• Worked closely with application developers to synthesize their requirements into a reusable enterprise data model.
• Developed strategy to incorporate Enterprise Architecture and Information Architecture for inclusion of IT modernization initiatives.
• Created Enterprise Data Model for organization and implemented Master Data Management standards.
• Configured Intelligence Server, Enterprise Manager and server definitions using Linux scripts.
• Developed business case scenarios for enterprise social networking key performance indicators.
• Identified and resolved control gaps in the enterprise business intelligence initiative.
• Presented solutions to clients senior management via PowerPoint and whiteboard.
• Developed Framework Manager Models and created enterprise reports.
• Provided data governance and created enterprise data standards.
• Managed architecture solution for enterprise corporate reporting environment.
• Established enterprise architecture and governance processes.
• Partnered with senior management to create daily report detailing and summarizing sales activity across entire enterprise, encompassing 12 sales feeds.
• Created numerous enterprise analytic reporting solutions implemented in SSRS based on OLAP Cubes as well as OLTP data including interactive reports.
• Installed SAP Integration Kit over the SAP Business Objects Enterprise environment and managed several reporting initiatives over the existing BW environment.
• Implemented RapidDecision (JDE Enterprise One sourced) GL, AR, AP, FA, and Property Management Marts.
• Managed for the functionality, performance, troubleshooting and management of the enterprise-wide SAP Business Objects Enterprise Reporting Program.
• Played a key role in upgrading enterprise data warehousing (EDW) from SQL 2005 to SQL Server 2014.
• Configured SQL Server 2008 Reporting Services and deployed various SSRS projects to meet the enterprise data reporting needs.

Show More

• Planned and scheduled regular backup and recovery operations with mirrored and off line storage hosted off site at disaster recover location.
• Designed, installed, configured, developed, tested and deployed SAS-BI reports and SAS BI applications.
• Implemented the OLAP and Ad-Hoc reporting interface in SAS 9i.
• Created dashboard/reports using SAS suite of tools.
• Developed and implemented a Business Intelligence methodology and standards to run Business Objects/SAS/Essbase projects within Sears.
• Managed the BI team for Business Objects/Essbase/SAS development and support a 20 people team.

Show More

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Prepared Documents of each process involved, Developed complex stored procedure using T-SQL to generate reports using SSRS 2005.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Designed and developed a database to house data from various data sources for all reporting needs with T-SQL proficiency.
• Converted Active script task logic in Script task and T-SQL and produced the desired result.
• Designed and developed a Build Verification Test (BVT) tool to validate the build; using C# AND T-SQL.

Show More

• Installed, configured, serviced, and maintained BI suite and servers on Linux and Windows Server 2003.
• Created folders, groups and users' security levels via Windows AD authentication in Central Management Console.
• Installed and configured 2 OBIEE [ ] environments on Windows Server 2003 virtual machines.
• Installed and configured the Cognos BI environment in a distributed multi server Windows environment.
• Installed and configured PowerCenter 9.0.1 in a Windows-based environment.
• Installed Business Objects Enterprise XI 3.1 Sp4 on Windows 2008 Servers and published reports on to Business Objects Enterprise Server.

Show More

• Designed and lead development of numerous data manipulation processes for various clients CRM applications.
• Developed and provided user-appropriate documentation for various supported business systems including CRM, PSA, LOB, and other systems
• Managed customer support for Onyx CRM, Great Plains, QuickArrow PSA, and N-Able Remote Monitoring Systems.
• Redesigned flows and usage of CRM.
• Developed customer-centric analysis, for a large commercial organization, by relating market and CRM data into a cohesive package.
• Implemented a CRM for a prospect management system with drill-down capability enabling access to data on new business development opportunities.

Show More

• Created Scheduled Data Driven Subscriptions on Report Server in order to deliver reports to different SharePoint locations.
• Designed and developed SharePoint KM architecture environment solution.
• Designed and built administrative dashboard reports using SSRS, SharePoint Server, and Power View.
• Led project to implement SharePoint Farm for highly available reports and development.
• Published briefing books and BI web parts to SharePoint portal.
• Utilized Analytics tools and SharePoint collaboration as aids.
• Streamlined frequent audit requirements by providing FAQ sharepoint site where auditors can collect answers before engaging our team.
• Involved in the planning, development and deployment of SharePoint sites while adhering to iNAVSEA software compliance standards.
• Created multiple Key Performance Indicators (KPIs) for use with SharePoint 2010 dashboards.
• Worked on Open Doc and Integration of BO Reports with Sharepoint and web pages.
• Designed multiple dashboards using SharePoint, Performance Point, and Dundas visualizations.
• Converted many existing .Net applications into SharePoint Team Pages.
• Created implementation roadmap for a corporate reporting solution in Sharepoint that allows users to share data.

Show More

• Created and setup database audit procedure on Linux, AIX Z/OS Platform for SOX'S Compliance.
• Maintained Daily, Weekly and Monthly Production Processes on Linux Environment which were scheduled via Autosys Application.
• Architected, installed, and configured three Weblogic/OBIEE 11g environments on 64-bit Linux, two of which were clustered.
• Developed many reusable shell scripts in Red Hat Linux.
• Administered Linux and Apache servers.
• Installed and administered the Oracle RAC (on ASM), on Linux.

Show More

• Created SSRS reports using MDX queries for reporting financial matrices.
• Converted existing SQL reports to MDX drastically reducing execution times.
• Designed and optimized MDX queries to improve performance.
• Created MDX queries and implemented performance optimization.
• Developed 550+ MDX calculated members for complex financial accounting calculations.
• Provided user-friendly dimension hierarchies and measures displaying cost and revenue calculations using MDX syntax.

Show More

• Ensured the delivery of vital actionable information from multiple source systems including SalesForce.com.
• Performed configuration and change control functions within the SalesForce environment for disparate instances.
• Customized the Salesforce implementation to support Business Requirements, Procedures and Process flows.
• Administered Salesforce Campaigns for New Customers and Customer Retention Programs.
• Worked extensively with Microsoft Office products and Salesforce.com.
• Migrated custom legacy applications into custom Salesforce modules to ensure maintainability and integration in the overall application landscape.

Show More

• Developed executive dashboards in QlikView, enabling to measure the performance of the business with analytical capabilities.
• Advised on costs and benefits for the acquisition of new technologies that included the Red-gate products, Pentaho, and QlikView.
• Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed.
• Designed and developed QlikView Applications that use Clarity and Cogito Data Warehouse (Star) as data sources.
• Implemented Qlikview as BI Presentation layer.
• Participated in build of several in-memory analytical apps using Qlikview 9/10/11.
• Designed and developed multiple Qlikview dashboards for Phreesia Analytic product.

Show More

• Provided mentoring to Clarity report developers as it relates to Web Intelligence (SAP Business Objects 4.1 SP2) report development.
• Architected the Business Objects environment including developing Universes and Web Intelligence Reports.
• Developed 3 brand new Web Intelligence reporting applications and maintenance technical support of 4 existing reporting applications.
• Changed existing Universes using Universe Designer, and redesigned/improved Reports requiring custom SQL in Web intelligence.
• Trained staff of approximately 25 to create web-based information reports using Business Objects Web Intelligence application.
• Created several Web Intelligence reports to help management track and monitor IT/Information Security metrics globally.

Show More

• Modified the clients unix scripts to load offshore databases via load rules/text files.
• Performed Unix programming for radio station.
• Coordinated infrastructure changes (Unix System Groups, Policy Director Administrators) and developers in each project for the upgrade.
• Tuned the warehouse from both the Oracle and Unix perspective, setup of Advanced Replication servers (master-master configuration).
• Developed UNIX scripts to automate deployment of the releases related to different phases of this program.
• Created generic templates for UNIX shell scripts used for automation.

Show More

• Re-architectured Sikorsky Fleet Analytics from OLTP to OLAP.
• Detected a pattern where Data Warehouse calculations were increasingly shifting from regular OLTP to scientific calculations.
• Integrated data mining applications in OLTP databases for predictive analysis & user behavior analysis.
• Composed subject area oriented OLTP Entity Relationship Diagrams.
• Provided leadership in Data modeling for Conceptual, Logical and Physical data Models for OLTP, and OLAP.
• Used Oracle Wait interface extensively to resolve the bottlenecks of many applications for both OLTP and OLAP environment.

Show More

• Developed calculated measures, leveraged as drag and drop KPIs, used in information trending.
• Developed KPIs and other metrics for measuring performance and meeting business objectives.
• Interviewed over 45 key Executives multiple times to design KPIs and metrics.
• Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis.
• Developed dashboards in Tabular Modes to help management identify critical KPIs and facilitate strategic planning in the organization.
• Interacted with business representatives for Need Analysis and to define KPIs for Business and derive functional specifications.

Show More

• Saved VNSNY IT approximately 200k in SAS Mainframe licensing fees on their OS390 IBM systems.
• Evaluated OS390/DB2 Vs HP-UX/Oracle and recommended HP-UX/oracle as the direction for operating system/database environment.

Show More

• Designed data marts and associated data integration strategy to support the Business Objects universes and reporting applications.
• Interacted with Business Users and End Users to know their Business views in developing and modifying Universes and Reports.
• Identified all the reports and Universes in Business Objects system to be migrated and develop a project plan.
• Involved in creating and validating Universes, providing technical support to the users on universe and reports.
• Created universes, classes and objects by retrieving the data from various data sources and connections.
• Maintained and optimized Epic provided universes for Access Log, ED Visits, and Hospital Visits.
• Customized Epic Hospital Billing and Professional Billing Universes (SAP Business Objects 4.1 SP2).
• Created WebI and Crystal reports with universes created from SAP BW data.
• Created complex new Universes, Linked with existing Universes from Data marts.
• Created Business Objects Universes in order to enable self-service reporting.
• Created Linked Universes to save time and improve performance.
• Created and maintained several Business Objects 3.1 universes.
• Developed UNX and UNV universes.
• Architected the Design and Created Universes for Sales, Plant Management and Inventory Reporting.
• Developed PB/HB Universes and Webi Reports.
• Worked on developing 20 universes using BW , RDBMS using secured connections, Row level security , complex calculations.

Show More

• Designed and implemented global mobile broadband wireless devices sale, activation and tacking business intelligence solution.
• Provided application DBA support of all Hyperion application.
• Resolved several database issues by performing DBA role, and provided primary and secondary on-call support activities on a rotational basis.
• Served as DBA and project lead on the deployment and completion of Canon Document Manager application for electronic document management.
• Performed Oracle DBA duties as needed, particularly in the area of performance tuning at the Db server level.
• Viewed and monitored system and DBA tables for troubleshooting database related issues for the clients.
• Facilitated requirements sessions, team status meetings and feedback reviews.
• Developed user stories, use cases and designed UX/UI for Avanti Markets retail kiosk POS mobile payment app with customer/stakeholder feedback.

Show More

• Gathered, reviewed and validated business processes for all touch-points into customer subject area for the scope of the MDM project.
• Engaged in a Master Data Management (MDM) vendor tool selection.
• Designed a Color MDM accurately representing company's proprietary color-related information.
• Participated in MDM product evaluation (Oracle and IBM) and POC focusing on development of governance and compliance issues.
• Designed and developed custom MDM tool with user interface for creating, configuring new rules and correction of data.
• Managed, designed and deployed the global Data Warehouse and associated MDM (Master Data Management) applications.

Show More

• Involved in the creation of DB link to access DB2 data via Oracle Transparent Gateway.
• Sourced data from DB2 production database to provide accurate and timely information distributed via web portal applications utilized globally.
• Performed database migrations, provided ongoing database support including performance enhancement maintenance and end-user education, Performed DB2 installation and configuration.
• Designed and developed a DB2 data cleansing application to enable a customer marketing promotion.
• Configured Access server and admin console to capture HMS's PCF & EC DB2 data store's daily updated data.
• Tuned, solved problems, and made performance improvements for data warehouses in SQL Server and IBM DB2.

Show More

• Developed detailed technical blueprints for the integration of business intelligence solutions; performed tools evaluation and selection for various client projects.
• Evaluated the environment and recommended hardware configurations for development, stage and production environments for all migrations.
• Troubleshooted and evaluated data to certify information is precise and reconcilable to its source of origin.
• Designed a new business intelligence product by conducting market analysis studies evaluating competition and industry trends.
• Evaluated and procured departmental development/test laboratory (hardware and software).
• Conducted evaluation of dashboard and visualization tools such as Business Objects Explorer, Tableau Desktop, and Tableau Server.
• Evaluated potential new hires as part of the hiring process and wrote performance appraisals on a yearly basis.
• Evaluated all company Business Intelligence technology to determine the appropriate approach to take in growing the corporate warehouse.
• Managed evaluations of technical solutions and vendor products to include proof of technology and proof of concepts.
• Advanced WellPoint s Information Management department to evaluate and adopt new Business Intelligence products and services.
• Evaluated tools to replicate SQL Server to AWS and SQL Server slaves in a distributed environment.
• Used Business Objects, Quality center and share point for UAT tracking and resolution.
• Worked with customer team to discuss the requirement and ensure UAT approval for Dashboard.
• Evaluated, compared and integrated new data vendors for use in portfolio management.
• Developed an UAT tool for business users not comfortable with SQL.
• Worked with users in conducting user acceptance testing (UAT).
• Evaluated Database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Used Quality Center Edition of Application Lifecycle Management Tool from HP to execute SIT and UAT process.
• Developed custom lab results Actuate reports in the Chemware Horizon laboratory information system (LIMS).
• Evaluated multiple BI vendors to select the most appropriate toolset.

Show More

• Implemented SQL Server 2012 Change Data Capture features for near real-time ODS Updating.
• Mentored DBA's on deployment and configuration methods for SQL Server 2005.
• Designed ODS, DW & Data mart flexible dimensional model.
• Provided strategic guidance for warehouse implementation, development practices, report distribution methods, performance improvement, and disaster recovery.
• Coordinated across global organizations as required to support data integration efforts to populate a clinical reporting ODS.
• Improved Business Processes by implementing different Business Intelligence methods.

Show More

• Engaged with Product team, Report Writers and QA Team and SME to improve business process.
• Implemented Change Requests and Defects raised by Business Users/QA teams in Data Marts & Reporting Area.
• Performed QA on data and reports reconciling them with spreadsheets used for input.
• Migrated all code from Dev to QA to Prod.
• Participated in the full development life-cycle from developing business intelligence requirements to QA and production deployment.
• Involved in putting together a comprehensive strategy for migration and QA activities

Show More

• Worked with DW developers to model a supporting DataMart using Composite data virtualization software on top of the Netezza data store.
• Improved the throughput of the ELT processes for Netezza by a factor of 100x.
• Imported data and structures used in existing Netezza decision support system.
• Led migration of Oracle data warehouse to Netezza.

Show More

• Implemented database refresh from Production to QA and automated data backup and restoration procedures.
• Developed, audited, coordinated, and promoted procedures during application development life cycle.
• Developed Stored Procedures for Data Import/Export and Data Conversions.
• Created stored procedures for complex reporting scenarios.
• Authored documentation of procedures of a self-service BI model resulting in increased efficiency, reduced costs, and increased speed.
• Completed design documents, document templates for future designs as well as exception and error handling procedures.
• Documented all processes and procedures as they relate to the Emergency Department and Radiology Data Marts.
• Maintained and tuned procedures in three separate environments (development, Quality, and Production).
• Developed dimensional model, tables, attributes, elements and procedures required for application.
• Created and updated Standard Operating Procedures (SOP), including checklist.
• Provided test plans and procedures for the validation of test data.
• Created stored procedures, Functions, Common Table Expressions and Triggers.
• Created Standard Operating Procedures (SOP) in preparation for transition.
• Used Six Sigma Standards for the Documentation of the procedures.
• Designed most of the tables and stored procedures.
• Developed vibrant and visually-rich reporting using SQL Server Reporting Services 2008 for end users with parameterized SQL Queries and Stored Procedures.

Show More

• Tuned various informatica/DB objects and hence improving the overall productivity of project.
• Performed upgrade of Informatica PowerCenter include hardware platform migration.
• Created Informatica mappings and sessions with PL/SQL Procedures/Functions to build business rules to load data and tuned them for optimum performance.
• Learned both Informatica and IBM tools for Data Governance and Master Data Management.
• Installed and configured Informatica and OBIA software on Test and Production servers.
• Worked on Informatica Power Center tools-Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Customized Informatica 8.6.6 mappings and workflows to support client-specific customizations, including an additional source system.
• Worked with Informatica Designer, Repository manager, Workflow Manager and Workflow Monitor.
• Used Informatica to create an incremental (change data capture) load workflow to update the Siperian customer list database.

Show More

• Developed and deployed the portal, automation tools, deployment tools, monitoring tools XI R2 SDK to XI R3 SDK.
• Conducted proof of concept to integrate SAP Business Warehouse (SAP BW 7.1) and SAP Business Objects XI R2.
• Managed and completed Business Objects 6.5 migration to Business Objects XI R2 and XI Release 3.
• Extracted and consolidated data from diverse data sources into a uniform SQL Server 2008 R2 database.
• Worked star schema to combine SFDC and Call Center data on MS SQL Server 2008 R2.
• Managed BI enhancement from SAP Business Objects XI R2 to Business Objects XI 3.1.
• Involved in migration of Business Objects 6.5 to Business Objects XI R2.
• Architected and developed Emergency Department Data Mart (Oracle 11g R2).

Show More

• Developed collaborative working relationships with business units, technical teams and project managers to produce tools and solutions.
• Created improvements that boosted quantitative assessments and analysis of the social network activity for key performance indicators.
• Collaborated with investment managers to build tools for constructing optimal portfolios and monitoring portfolio risks.
• Designed and developed performance dashboards used by senior management to monitor business performance and status.
• Developed architectural enhancement for forecast model including labor hours, dollars, and material quantity.
• Analyzed business and user needs and designed Dashboards to support customer requirements.
• Consolidated multiple silo BO platforms into single technical platform and ecosystem.
• Collaborated directly with user community for detail requirements and issue resolution.
• Developed reports ranging from Operational Customer Statements to Corporate Dashboards.
• Collaborated with peer business groups to adopt data-driven decision-making practices.
• Performed BOE administration and designed and documented security model.
• Created multiple interactive data-driven visual storyboards in Tableau.
• Created Operational dashboards to analyze real-time claim processing.
• Planned, designed, and implemented database (Oracle) applications exceeding Terabyte in size in both Unix and Windows environment.
• Involved in Weekly and Monthly deployment activities Reviewing reports and Universes, Improved report response time by tuning BO queries.
• Collaborated with business users using white boarding sessions to validate requirements and guide them on best way to present data.
• Designed, built and managed an Executive Scorecard and Dashboard solution to support the first-of-its-kind executive reporting for the company.
• Managed the user, groups, repositories and the documents through the BOXI 3.1 Central Management Console (CMC).
• Designed custom dashboards combining prescription, sales, service request, adverse event, and vendor service level agreement metrics.
• Involved in creating Excel Workbook Connections using SQL databases in order to load the data to Excel from SQL tables.

Show More

• Established connection between Business Warehouse, SAP R/3 systems and Non-SAP systems like BECON, ICESTROM and other data sources.
• Analyzed and activated relevant Business Contents and set SAP R/3, Flat Files and BW as source systems.
• Worked on LO extractors for extracting sap R/3 data into BI.
• Configured the Data services to connect to the SAP R/3, BI, and CRM.
• Uploaded master data and transactional data from Flat Files and SAP R/3 to BW system.

Show More