5. Provide regulatory compliance reports for PHMSA (Pipeline and Hazardous Materials Safety Administration), FERC (Federal Energy Regulatory Commission), Texas Railroad Commission, Advalorem Tax data delivery and other on demand reports.
5. Perform clean data cuts off of PODS database (Pipeline Open Data Standard) for day today reporting.
5. Closely work with internal Department of Transportation team, Finance, Tax team, regulatory compliance teams, and Pipeline Integrity Engineers to iteratively develop robust automated reporting needs.
5. Designed and developed end to end BI Automation including ETL and reports using MSBI suite (Azure,T-SQL /SSIS/SSRS/SSAS/PowerBI Pro/Power pivot)
5. Strong understanding of enterprise database and report development. Proficient in the primary technologies supported, including: SQL Server views, stored procedures, functions, and create reports serving business.
5. Developed Power BI Dashboards, Reports and KPIs for inter-department data analysis.
5. Built data visualizations using Power BI Desktop, Query editor, Power BI Model
5. Expertise in cleansing, data analysis, data validation and on technical requirement.
5. Troubleshoot, Test ETL data extracts & transforms and implement fixes.
5. Develop, deploy, upgrade, migrate databases & its applications to Azure or latest version with and without DMS.
5. Migration to Postgres / PostGreSQL and day to day familiarity and use of geospatial datatypes and its functions and test result using ArcMap /PostGIS.
5. Created and deployed Tabular / SSAS pipeline components cube for slicing and dicing objects on pipeline.
5. Strong "Hands on" building and developing Data marts and BI solutions.
5. Manage, maintain and follow existing systems, procedure & processes.
5. Designed, developed & continued enhancements on internal reporting platform using SSRS reports and automated full reporting process.
5. Self-learning: Azure Machine Learning and trained few models using rapidminer tool.

Junior DBA activities, back up restore databases, change management, script deployment, grant revoke control user access, system maintenance.

5. Small Business - Deposits

   The project is to develop a reporting platform for small business banker department to report on deposits made to all accounts by bank of Americas’ small business customers by region by market by branches by customer by month for rolling 13 months.

   Small Business - Sales Performance

   This project is to develop a reporting tool for analytics department to report and track of sales associates in each branch. It is also used to determine their goals vs actuals per quarter. This involves development of a process to extract source data from various systems and includes the services rendered by Small Business Banker.

   Responsibilities (Sr BI Developer)

6. Design, maintain and enhance all BI components and optimize for reporting efficiency and scale.
5. Understand business users to define dimensions and measures.
5. Extract data from Teradata, DB2 & flat files for Business Intelligence platform.
5. Establish, maintain and administer ETL environment, including scheduling, distribution, and permissions.
5. Developed SSIS packages to move large amount of data in parallel from Teradata, DB2 system to the BI Data mart.
5. Optimized the usage of ETL vs ELT approach.
5. Tested the newly developed reports.
5. Evaluated Report Performance upon completion of the reports and validated output data.
5. Deployed packages, Reports from a development environment to test environment.

Developed, managed, and coordinated all user acceptance testing.

Healthfirst Spectrum Care Plan

The project is to batch generate CCMS Care Plan reports for the Medicare SNP Members using standard Member Summary Report components. In addition, support Meaningful Use on behalf of providers, by sharing the Care Plan information with the providers.

Responsibilities (Sr BI Developer)

5. Develop architecture / implementation plan for BI projects.
5. Design, maintain and enhance all BI components and optimize for reporting efficiency and scale.
5. Analyze user needs and create cardinalities, contexts, joins and aliases.
5. Work with business users and define dimensions and measures.
5. Establish, maintain and administer reporting environment, including scheduling, distribution, user permissions, and updating reports and dashboards
5. Evaluated Netezza & GreenPlum appliance for Business Intelligence platform.
5. Developed SSIS packages to move large amount of data in parallel from Legacy system to the BI Data mart.
5. Optimized the usage of ETL vs ELT approach.
5. Created customized report for different type of reports standardization of report formats, filter options, page break options, and output options; as well as additional flexibility in terms of report data selection.
5. Created complex reports using union queries, conditional formatting and prompting, drill-through.
5. Created reports with cascading prompts.
5. Batch generate PDF Reports using Subscriptions.
5. Involved in testing the newly developed reports vs the pre-migration Reports.
5. Evaluated Report Performance upon completion of the reports and validated output data.
5. Deployed packages, Reports from a development environment to test environment.

Developed, managed, and coordinated all user acceptance testing.

Uniform Benefit Summary Reporting

The project is to develop an end-to-end BI solution to serve new set of Uniform Benefit Summary Reports as Patient Protection and Affordable Care Act (PPACA) required that the Secretary of Health and Human Services develop standards for a report for individuals and group health insurance. And all health insurance issuers offering group health insurance coverage to provide enrollees and potential enrollees an accurate summary of benefits and coverage explanation. The report was required by Federal law that this document provides consumers an easy way to compare policies and understand their coverage.

Responsibilities (Sr BI Developer)

5. Developed BI procedures to ensure conformity, compliance with HIPAA standards and to translate business rules and functionality requirements into BI Solutions.
5. Involved in creation/review of functional requirement specifications and supporting documents for business systems.
5. Experience in database design process and data modeling process.
5. Designed Dimensional Data Model to implement the consolidated view of Members and Claims using data modeler.
5. Designed a high level architectural model for the ETL implementation of Insurance Claims, Membership Coverage and Status Tracking for the developers.
5. Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
5. Documented and Maintained Data Dictionaries with the updated Data Model Enhancements.
5. Involved to planning and designing SSAS 2008 Cubes and building attribute relationships for optimal performance of Hierarchies and Fact Dimensions.
5. Implementation and delivery of BI platform solutions to develop and deploy ETL, analytical, reporting using SSAS, SSIS/DTS, SSRS.
5. Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
5. Experience in Performance tuning.
5. Developed SSIS Packages and Stored Procedures to feed data for the new system.
5. Performed break fixes & manual processing of ad-hoc loads as per request.
5. Created / scheduled SQL server jobs and maintenance activities of Database.
5. Developed queries for data analysis and analysis on the defects raised by end-users and fixing the defects.
5. Managed and coordinated all user acceptance testing.
5. Created customized report including, filter options, page break options, output options as well as additional flexibility in terms of report data selection.
5. Created complex reports using union queries, conditional formatting and prompting, drill-through.

Assisted users in troubleshooting their queries.