PROFILE SUMMARY:

• Diligent BI consultant with around 6 years of experience in development and maintenance of ETL frameworks and reporting applications.
• Experience of facilitating business requirement gathering sessions and translating the business requirements into system / technical requirements.
• Extensive experience in database design, normalization, selective de - normalization, conceptual, logical and physical data modeling using Erwin.
• Hands on experience working on ETL and data integration in developing ETL mappings and scripts using SSIS
• Proficient in working with report snapshots, linked reports and used report manager for deploying reports in SSRS.
• Focused individual with keen observation skills along with superb analytical and communication skills.

TECHICAL FORTE:

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Reporting Tools: SSRS, Power BI, Excel Power BI

Cloud Experience: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share).

ORGANIZATIONAL EXPERIENCE:

Confidential, Seattle, WA

SQL BI Consultant

Responsibilities:

• Analyzed business requirements and wrote functional specifications for the proposed application.
• Utilized agile methodology for the implementation of the project and provided technical and functional support to the project team
• Collaborated with Project Manager to determine the best possible reporting mechanisms.
• Created project plans in accordance with project management framework standards and procedures.
• Coordinated with different team members for successful data migration and progress update.
• Wrote complex SQL queries utilizing scalar and table variables to extract specific patient data.
• Wrote different types of T-SQL triggers such as AFTER, and INSTEAD OF to monitor and audit DML operations.
• Employed SQL Profiler for identification of deadlocks, blocking transactions.
• Examined and evaluated data structures of the source/legacy systems, analyzed data quality and performed data cleanups.
• Conceptualized the ETL process along with accessing, manipulating, analyzing and interpreting information from multiple sources.
• Performed data cleansing enrichment and mapping tasks per data maps utilizing transformations.
• Debugged exceptions in SSIS packages utilizing event handlers and redirect error outputs.
• Automated the execution of SSIS packages utilizing SQL Server Agent jobs and proxy accounts.
• Wrote SQL-based tests and audit scripts to validate SSIS packages and data loads.
• Created complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Performed daily reports, checks and procedures as well as generating SQL based ad-hoc reports as needed.
• Developed SSRS reports such as linked, sub reports, parameterized and cascading parameterized reports.
• Wrote expressions to calculate, group, filter, parameterize, and format SSRS report contents.
• Created multiple dashboards with Microsoft Power BI utilising filters, and DAX expressions.
• Facilitate monthly meetings with clients to document requirements and explore potential solutions.
• Utilized Team Foundation Server (TFS) as version control software tool for cross collaboration.

Tools: & Environment: SQL Server 2016, SSDT, T-SQL, SSMS, MS Excel, Erwin, TFS, DTA, SQL Profiler, SSIS, Windows Server, SSRS, Power BI

Confidential, Columbus, IN

BI Developer

Responsibilities:

• Gathered business-user requirements and understood the requirement in discussion with the stake holders and product managers.
• Collaborated with the business users and reporting team to understand and document reporting requirements.
• Applied advanced sampling and data analytic techniques to help with strategic initiatives, roadmaps and process models.
• Conducted dimensional modeling with Erwin along with designing and building relational data mart.
• Wrote complex SQL queries utilizing scalar and table variables to process user inputs.
• Configured isolation levels, locks and transactions to avoid blocks/deadlocks.
• Wrote complex T-SQL stored procedures and functions to perform data profiling, data cleansing, and incremental loads.
• Optimized SQL queries with execution plans, SQL Profiler, and DTA to improve performance.
• Conceptualized the ETL process along with accessing, manipulating, analyzing and interpreted information from multiple sources.
• Designed and developed SSIS packages for data profiling and data cleansing utilizing fuzzy transformations.
• Automated the ETL process with SSIS package execution schedules utilizing SQL jobs.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel and line better business analysis.
• Utilized different type of slicers available in Power BI for creating reports and dashboards.
• Developed drill through, drill down, linked, sub and parameterized reports for enhanced business analysis.
• Established an interface to organize reports, sort data sources, schedule report executions and track report history.
• Optimized reports by modifying embedded queries and/or altering stored procedures.
• Successfully enabled snapshots, subscriptions and report caches to improve response times and reduce traffic to the report server.
• Employed TFS for version control and change management of BI solution for cross-functional communications.

Tools: & Environment: SQL Server 2016, T-SQL, SSIS, SSAS, SSRS, SSMS, SSDT, Power BI, TFS, DTA, Erwin, SQL Profiler.

Confidential, San Diego, CA

MSBI Developer

Responsibilities:

• Gathered business requirements from end users via JRD sessions.
• Conceptualized and designed a dimensional model for analyzing patient claims with Erwin.
• Wrote T-SQL queries for the Application Team and Reporting Team to utilize in development process.
• Created data mapping documents for the data migration process.
• Optimized the performance of queries with modifications to the existing T SQL code and indexes.
• Designed stored procedures, functions and triggers for data retrieval/updates in the database.
• Contributed in developing a multitude of database objects utilizing T-SQL (tables, procedures, functions).
• Implemented indexing strategies to improvise performance (covering indexes, indexed views and index defragmentation).
• Created packages to cleanse data with fuzzy lookups/groupings, derived columns and condition splits.
• Successfully monitored and configured SSIS packages for dynamic execution and deployment of packages to the testing environment.
• Developed SISS packages to extract, transform and load data from OLTP servers and other sources to the OLAP database.
• Designed usage-based optimizations for better query performance in SSAS as per the business requirements.
• Designed and deployed reports with drill down, drill through, drop down menu option, parameterized and linked reports using SSRS.
• Incorporated report deliveries and backup schedules with subscription configurations and snapshots.
• Created a multitude of reports and dashboards with SSRS for claim status analysis.
• Dispatched on-demand and scheduled reports utilizing SSRS for analyzing department performance.
• Optimized SSRS reports with snapshots, caches, execution log views, embedded queries and stored procedures.
• Utilized Team Foundation Server (TFS) for the version control and project co-ordination.

Tools: & Environment: SQL Server 2012, T-SQL, SSDT, SSAS, SSRS, SSIS, SSMS, MS Excel, TFS, DTA.

Confidential, Escondido, CA

ETL/SSRS Developer

Responsibilities:

• Worked with the business users to clarify business requirements pertaining to the database application.
• Implemented business logic within OLTP system utilizing complex stored procedures, functions and triggers.
• Enhanced the functionality and performance of pre-existing physical database.
• Manipulated input data from other applications with stored procedures and functions (utilizing within procedures).
• Analyzed stored procedures with parameter sniffing issues and optimized them with proper mechanisms.
• Designed SSIS packages in order to migrate the data from SQL Server to the staging area.
• Redirected data with anomalies from the legacy system to other destinations utilizing derived column, lookup, fuzzy lookup and conditional split transformations.
• Contributed in designing dynamic SSIS packages to transfer data across multiple platforms utilizing variables and expressions.
• Resolved SSIS package errors utilizing error logs, breakpoints, checkpoints and data viewers.
• Built SSAS cubes on an existing data mart for slicing and dicing data from different perspectives as per the business requirements.
• Collaborated with business analysts and developers to identify requirements and design the reporting application.
• Developed reports to present provider details with drill down and parameter functionality.
• Deployed SSRS reports to SharePoint server and resolved deployment issues.
• Optimized reports with modifications to embedded queries and/or stored procedures.
• Generated on-demand reports for business analyses and management decisions with SSRS.

Tools: & Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSMS, SSDT, SQL Profiler, DTA, Windows Server, Erwin.

Confidential, Raleigh, NC

DWH Developer

Responsibilities:

• Defined functional requirements by collaborating with development team in JAD sessions.
• Created staging environment with de-normalized structure to load data from OLTP.
• Developed strategies to load data to Type 2 and Type 3 SCDs (slowly changing dimensions).
• Created views with indexes with higher granularity levels to improve response time for reports.
• Modified temporary tables, indexes and lookup techniques to optimize stored procedures.
• Created functions to provide custom functionalities according to the requirements.
• Designed stored procedures to perform index maintenance and data profiling for loading data marts and generating report datasets.
• Extracted and loaded data from multiple sources such as Excel and SQL Server to the staging area.
• Monitored runtime events for better troubleshooting and debugging of packages with loggings.
• Implemented parameters to configure package properties for dynamic executions
• Queried multidimensional cube data with MDX scripting in SSAS.
• Successfully delivered reports with subscription functions in SSRS.

Tools: & Environment: SQL Server 2008/R2, T-SQL, SSIS, SSRS, SSMS, BIDS, MS Visual Studio, MS Excel, TFS.

Confidential, Amherst, NY

Database Developer

Responsibilities:

• Analyzed business requirements, system requirement specifications and documented functional requirements.
• Designed and implemented clustered and non-clustered indexes on tables ensuring the efficiency and latency of queries.
• Created stored procedures and functions to implement the business logic for interfacing with parameterized reports.
• Conceptualized critical staging procedures to load data marts and report databases with multiple features.
• Established error redirection in packages for closely monitoring failed records.
• Created design specification documents for the new reports developed through SSRS.

Tools: & Environment: SQL Server 2008, T-SQL, SSMS, BIDS, SSIS, SSRS.