Sql Bi Consultant Resume
Seattle, WA
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.