SUMMARY

• 14+ years of IT experience in Software Development Life Cycle.
• 10+ years of experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.
• Senior Technologist in developing and delivering end - to-end MSBI solutions.
• Ask about Achievements in every projects saving time and effort for business.
• Expertise in OLTP/OLAP System Study, Analysis and Dimensional Modeling.
• Design Dimensional Model Star schema, Snowflake schema, Facts, Dimension tables and Slowly Changing Dimensions (Type1, Type2, and Type3).
• Develop and deployed Tabular as well as dimensional models in SSAS on-prem/ Azure.
• Extensive experience in Installation, Configuration and Updates of SQL Server.
• Process and Move large amount of data with high degree of parallelism using SSIS.
• Create, Schedule and Monitor SSIS Jobs.
• Extensive experience in Data warehousing tools SSIS, SSAS, SSRS and Data Modeling Tools.
• Expertise in Designing and Deployment of Reports for the End-User requests using Web Interface, SSRS, PowerBI Pro, Spotfire 10.
• Junior DBA activities, back up restore databases, change management, script deployment, grant revoke control user access, system maintenance.
• Experience in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon.
• Data Warehousing experience using ETL, DataStage 7.5 (DataStage Manager, DataStage Administrator, DataStage Designer, DataStage Director), DTS/SSIS
• Batch process to generate 1000’s of reports using subscriptions.
• Packaged and moved the Jobs smoothly between environments like Dev, QA and including production environment.
• Good work ethics with excellent communication and interpersonal skills with a strong attitude towards learning new technologies quickly supporting the project requirements.
• Day to day interactions with the business users and service center directors in understanding and providing automated end to end BI Solutions.

TECHNICAL SKILLS

Reporting: Power BI Pro, SQL Reporting2005/2008R2/2014(SSRS),Spotfire 10,Cognos 8

ETL: SSIS 2008R2, MS SQL Server 2000/2005/2008 R2/2014, SSIS, MS Access, SQL, PL/SQL, DTS, DataStage 7.5 (Designer, Administrator, Manager, and Director), Oracle.

Programming: SQL, PL/SQL, Transact SQL, SQL Plus 8.1.5.

Dimensional Data Modeling: TOAD Data Modeler, Erwin, SSAS, Star Schema, Snowflake Schema, OLAP, OLTP.

Database Tools: SQL Server Management Studio 2005/2008R2/2016, SQL Server 2005/2008/2017 Data Tools, Business Intelligence Studio, TOAD 9.0.1.

PROFESSIONAL EXPERIENCE

Confidential, Houston

Sr BI Developer, Program Manager

Responsibilities:

• 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.
• Perform clean data cuts off of PODS database (Pipeline Open Data Standard) for day today reporting.
• 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.
• 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)
• 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.
• Developed Power BI Dashboards, Reports and KPIs for inter-department data analysis.
• Built data visualizations using Power BI Desktop, Query editor, Power BI Model
• Expertise in cleansing, data analysis, data validation and on technical requirement.
• Troubleshoot, Test ETL data extracts & transforms and implement fixes.
• Develop, deploy, upgrade, migrate databases & its applications to Azure or latest version with and without DMS.
• Migration to Postgres / PostGreSQL and day to day familiarity and use of geospatial datatypes and its functions and test result using ArcMap /PostGIS .
• Created and deployed Tabular / SSAS pipeline components cube for slicing and dicing objects on pipeline.
• Strong "Hands on" building and developing Data marts and BI solutions.
• Manage, maintain and follow existing systems, procedure & processes.
• Designed, developed & continued enhancements on internal reporting platform using SSRS reports and automated full reporting process.
• 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.

Confidential, Delaware

Sr BI Developer / Architect

Responsibilities:

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

Confidential, NY

Sr BI Developer / Architect

Responsibilities:

• Develop architecture / implementation plan for BI projects.
• Design, maintain and enhance all BI components and optimize for reporting efficiency and scale.
• Analyze user needs and create cardinalities, contexts, joins and aliases.
• Work with business users and define dimensions and measures.
• Establish, maintain and administer reporting environment, including scheduling, distribution, user permissions, and updating reports and dashboards
• Evaluated Netezza & GreenPlum appliance for Business Intelligence platform.
• Developed SSIS packages to move large amount of data in parallel from Legacy system to the BI Data mart.
• Optimized the usage of ETL vs ELT approach.
• 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.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Created reports with cascading prompts.
• Batch generate PDF Reports using Subscriptions.
• Involved in testing the newly developed reports vs the pre-migration Reports.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Deployed packages, Reports from a development environment to test environment.
• Developed, managed, and coordinated all user acceptance testing.

Confidential

Sr BI Developer

Responsibilities:

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