Business Intelligence Developer Resume

SUMMARY:

8 years of experience in Microsoft SQL Server, T - SQL, SSIS, SSRS, Oracle, PL/SQL
Experience in working with large, complex and diverse data sources and destinations
Experience in ETL between Homogenous and Heterogeneous System using SQL tools (SSIS, Bulk Insert, BCP, and XML)
Strong experience in developing ETL solutions for data migration, Incremental loads from OLTP application and customer onboarding
Strong exposure to work in highly volatile production environment with multiple teams such as Application, Planning, Markets, Finance, HR, Identity Management, Forecast and Government agencies simultaneously
Strong experience in developing Linked, Drill Down, Drill through, Parameterized and Matrix reports
Good understanding of Systems Development Life Cycle (SDLC), Requirement Gathering, BI testing, Code promotion and deployment on Development, UAT and Production environment
Expert in creating indexes, Views, complex Stored Procedures, user defined functions, derived tables, CTEs and Triggers to facilitate data manipulation and consistency
Experience with Scrum, Agile and Kanban development methodologies

TECHNICAL SKILLS:

DBMS & RDBMS: SQL Server 2016/2014/2012/2008/2005, Oracle 12c, MS - Access, PI

ETL: SSIS, Alteryx

ETL Data Source/Destination: SQL, Oracle, XML, Flat Files, Excel, API, FTP, OLAP, OLTP

Programming Languages: C#, C, C++, XML with Name spaces, PowerShell

Reporting Tools: SSRS, Crystal Reports, MS Excel

Version Control: GIT,TFS, SVN, Visual SourceSafe 6.0/2005

Education:: Bachelors of Technology (Electronics & Telecommunication), Amity University

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

Designed and implemented ETL process for incremental data loads utilizing OLTP source using Change tracking and Change Data Capture thus providing customer Near Real-Time Reporting Data
Automated BI solution deployments on Dev, QC, UAT and Prod environment using PowerShell as part of TFS build and achieved minimum manual intervention in execution and deployment of data and reporting processes
Designed Data Warehouse based on Start and Snowflake data modeling for reporting and analysis

Confidential, King of Prussia, PA

Implemented ETL process to regulate energy bidding process by generating and publishing Locational marginal pricing files(LMP) used to establish price for bidding based on location and congestion
Developed SSRS reports consuming historical load data to generate precise load curves used for energy forecasting by government and non-government organization
Developed ETL and SSRS dashboard for weather forecast utilizing weather data API, the dashboard data is utilized by Weather forecasting agencies
Implemented ETL process to manipulate same source of data into different set of outputs for Markets and Planning which significantly reduced project cost
Implemented Matrix report to reduce number of pages from 300 to 80 which improved performance and increased number of users accessing the report
Developed Identity management BI process that identifies and reports all unauthorized logins across database servers, thus reducing number of resource hours to track such accounts
Developed Energy distribution zones and Business intelligence process to load historical data from 1997 to 2017 and current data for each zone into Zonal load reports used by Markets and planning team for accurate pricing, distribution
Utilized PI time series data as source in ETL to generate output with 2 seconds of delay for each data point

Confidential, Austin, TX

Created Load balance package to run 42 ETL packages at a stretch in parallel resulting in increased database performance
Implemented and Standardized ETL for data migration, incremental Loads to onboard new customers, reducing go live time by 50%
Redesigned multiple ETL processes and database table relation to load upstream differential data from SQL database backup therefore bringing ETL process run time from 5 days to 1 day
Extensively used Engine Threads for multi tree structure packages under Dataflow tasks
Created Stored Procedures for Historical Data Store (HDS), to retain the snapshot for last 90-day information into the current feed
Configured the Reporting server for 2012 Migration process
Developed SSIS package to generate offline SSRS reports with SSRS web services
Worked with Master Data Service leaf level staging tables and stored procedures with different import types
Performed database backups & restoration, Backup policies, Performance tuning
Prepared POC documents for the design & development of BI solutions(ETL/Reporting)
Created the build plans for the new and existing applications to provide smooth deployment

Confidential

Implemented ETL to migrate billing data to report database
Created BI process to feed data into Billing system
Promoted the SSIS Packages from Development server to UAT and Production
Identified the database tables for defining the queries for the reports using SSRS