| Candidate Information | | Title | Sql Server Business Intelligence | | Target Location | US-DC-Washington |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePROFESSIONAL SUMMARYMicrosoft certified Over 6 years of professional experience in development, implementation and administration of database systems using MS-SQL Server 2022/2019/2016/2014/2012 R2Experience in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using Bulk Copy Program (BCP).Experienced in creating Ad hoc reports and reports involving complex data sets and to query the database for Business Intelligence.Experience in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, and Drill-through and Cascading reports using SSRS.Experience in creating and managing fragmentation of Indexes to achieve better query performance.Experience in Performance Tuning and Query Optimizations using different database third party tools like Solar WindExperienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.Experience in optimizing the database by creating various Clustered, Non-clustered indexes.Expert in creating Chart reports, Drill down and Drill through Reports by passing parameters in SQL Server Reporting Services (SSRS).Experienced with converting excel and Crystal reports to SSRS reports and migrate crystal reports to higher versions.Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).RDBMS experience, including SQL programming, data analysis and data verification and validationDesigned and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports using TableauSelf-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.TECHNICAL SKILLS:Programming SkillsT-SQL, C, HTML, XML, JavaScript, ASP.NET, VB, C#DatabasesMicrosoft SQL 2019/2016/2014/2012, My SQL, SYBASE, MS ACCESSBI and ETL ToolsSQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Pervasive Data Integrator, Adept SQL diff, Oracle SQL, Microsoft Visual Studio 2019/2018Reporting ToolsMicrosoft SQL SERVER 2022/2019/2016/2014, Reporting Services (SSRS), Report Builder, Report Builder, Crystal reports 10, ProClarity, TableauDatabase Design Tools and Data ModelingMS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tablesOperating SystemsMicrosoft Windows, UNIX, LINUXTools and UtilitiesBusiness Intelligence Development Studio (BIDS), Visual Studio 2019/2018, Share Point 2013, Team Foundation Server (TFS), Microsoft Word, Excel and PowerPointVersion Control ToolsVSSEDUCATIONBachelors DegreePROFESSIONAL EXPERIENCEREI Systems, Virginia Jan 2022 - Till DateETL/SQL/SSRS DeveloperResponsibilitiesCollected, reviewed analyzed and created business systems and user needs documentation, including workflow, program functions and steps required to develop or modify application programs.Created visualization dashboards and reports with SQL Server Reporting Services (SSRS), Power BI and Tableau.Assisted in developing and maintaining business & financial reports and IT work/databases which was required to support the various lines of business and specific projects.Consulted with IT Personnel to determine business, functional and technical requirements for specified applications.Developed effective reporting tools for the business unit and completed existing projects from original concept through final implementation.Organized chart-holding facilities and assisted in training staff. Assisted various projects from start to finish through the SDLC process.Participated in Code Reviews, System Testing and UAT followed by production verification, post production testing and support.Facilitate the creation of complex statistical statements on healthcare data that measures various aspects of healthcare services, consumer episodes, and operational events.Involved in defining the source to target data mappings, business rules and data definitions that are used as source by ETL developers.Created data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and validating them with data present in Source systems.Revisiting created Data Mapping documents in case of any Mappings or Transformation logic changes.Conducted sessions and worked alongside with the Business analysts to create technical specifications and mappings for Business Data Glossary and reports.Involving in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.Generating Corporate Reports for Management Committee using SQL Server Reporting Services (SSRS) and Excel.Created tables using T-SQL queries to store the data and also creating database objects like functions, stored procedure, Clustered and Non-clustered Indexes using MS SQL Server.Experience in Data Analysis and Data Profiling using SQL and Excel on large volume of data sets like Tera data, Oracle, Flat files, SQL Server.Experience in creating data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and comparing them with source Data Profiling Results.Environment: MS SQL Server 2019/2016/2014, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL,Data Group USA, Alexandria, VA Nov 2018 - Dec 2021SQL \ETL DeveloperResponsibilities:Performed database backups and restore from Production server to test server as refresh backup as part of testing whether backup is restorable or not.Used the SSIS to migrate databases such as Excel files, flat files, and SQL Server database to centralized IT destination.Involved in designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSISCreated SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, and Partitions using SQL Server Analysis ServicesTransferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL ServerWorked on several drilldowns, parameterized reports and on reports that call sub reports using SSRS.Created many complex databases code objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve the query performance.Experience with logical and physical data modeling, data warehousing, data querying languages and data strategyCreated various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing.Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.Coordinated and attended everyday standup/scrum/Agile meetings and weekly Sprint meetings to evaluate completed workEnvironment:MS SQL Server 2019/2017, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Office and ETL Developer.New Market International Inc - Portsmouth, NH Sep 2016 Oct 2018SQL/SSRS Server DeveloperResponsibilities:Identifying and troubleshoot business process or data quality issues that show up in the reports and subsequently communicate to resolve and eliminate problems.Setup data for appropriate testing, conduct timing and capacity testing to ensure production support capability.Stored Procedures were used at DFT level to incorporate error handing in SSIS packages.Incorporated Incremental way of loading data in almost all packages by efficiently using Staging and Target DatabasesCreated HTML reports by using Report Builder which sends error records and corresponding counts to Production support team. Final Error report will be embedded in the body of e-mailWorked as a SCRUM master for some Sprints and coordinated with team members about their duties. If they had barriers helped in resolving them by communicating to Business owners or SME's (Subject Matter Experts)Extensively used File Processing methodology in a SSIS package if an interface depended upon Flat Files, EXCEL files, CSV files. Script Components played an important role in this taskWorked for Inbound and as well as Outbound Interfaces by SSIS packages (Microsoft SQL server).Environment: MS SQL Server 2016/2014, MS Business Intelligence Development Studio(BIDS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting services(SSRS), MS SQL Server Analysis Services (SSAS), MDX, ETL, T-SQL Visual Studio 2017/2014 Report Builder 3.0, MS SQL Profiler Erwin Visual Source Safe, Sales Force. |
