| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARY7+ years of overall IT experience in database development and Database system Microsoft SQL Server. Administration, Design, Development, and Support of MS SQL Server 2022/2019/2016/2014/2012 and Development Environments.Extensive knowledge in ER Diagram and design of logical and physical data modeling using Erwin tool and Visio.Expert in planning, modeling, designing, developing, implementing, administering and maintaining Microsoft SQL- Server, Visual Studio 2019/2018.Highly proficient in the use of T- SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.Extensive experience in designing de-normalized data warehouse including Star Schema, Snow Flake Schema and data flow diagrams.Extensive experience in creating and using Stored Procedure, Views, Triggers, schemas and Complex queries on SQL Server Management Studio.Experience in writing complex SQL queries involving multiple table's inner and outer joins, stored procedures.Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.Data Mapping based on business requirement for ETL with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta-data definitions and worked on Data Conversion using SSIS.Extensive experience in implementing event driven Error handlings and package logs.Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SQL Server Reporting Service.Hands on experience on developing Page level Reports, Dashboards, and Stories Using Microsoft Power BI.Strong interpersonal & communication skills, Competitive analytical, logical, and problem-solving skills, Strong management, administrative and leadership skills to work in team.Expert ETL design, Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.SKILLSDatabases: SQL Server 2022/2019/2016/2014/2012, Oracle, DB2Languages: SQL, T-SQL, PL/SQL, .Net (C#, VB), XML, DMX, MDXOperating Systems: Windows Server2008/2003, Linux/UnixBI Tools: SSIS, SSAS, SSRS, Tableau, Crystal Reports, DTS, BCP, MS, Power BI, AlteryxT-SQL Programming (Stored Procedures, Cursors, Functions, Triggers) Data ModelingOther Tools: Erwin, JSON, Service, JIRA, Get Hub, SVN, Agile MethodologyWORK HISTORYBI(SSRS/Tableau/Power BI/SSIS) Developer Atrium Health - Charlotte, NCFeb 2022 until now.Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.Assisting end users with problems installing the power BI desktop, installing and configuring the personal and on-Premises gateway, connecting to the data sources and adding the different users.Extensively worked in creating ETL SSIS packages both design and code to process data to target databases.Created different Power BI reports utilizing the desktop and online service and schedule refresh.Use Tableau Desktop, Power BI or Alteryx to develop dashboards for various purposes, functionalities and best practice measures to suit the requirement and needs of the business.Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.Handled Tableau admin activities granting access, managing extracts and InstallationsCreated packages in SSIS with error handling and worked with different methods of logging in SSISDeveloped, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.Migrate existing legacy reports into Tableau while building new reports from ourCreated extensive dashboards using data blending.Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting.Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.Created different visualization in the reports using custom visuals like bar chats, pie charts, line charts,cards, slicers etc also using different transformation inside edit query and clean-up the data.Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).DAX expressions, analysis and business forecasts.Environment: MS SQL Server 2019/2016/2012, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Windows Server, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2019/2017, MS Access, Crystal Reports 2013, MS Excel 2016.ETL/SSIS/SQL Developer Core Logic - Columbus, OH Oct 2021 Jan 2022Extensively worked in creating ETL SSIS packages both design and code to process data to target databases.Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.Strongly worked in debugging and troubleshooting the technical issues while implementing the applications.Created packages in SSIS with error handling and worked with different methods of logging in SSISDeveloped, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.Created views to display required information on user interface, and triggers to validate consistent data entry into the database.Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting.Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.Documented all the work and all the process of integration and reporting services for further referencesWorked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).Environment: MS SQL Server 2019/2016/2012, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Windows Server, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2019/2017, MS Access, Crystal Reports 2013, MS Excel 2016.ETL/SQL/SSRS/SSIS Developer GEICO, Chevy chase, MD Mar 2019 Sep 2021Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.Leading and mentor the efforts of data quality completeness initiative for Informatics based ETL architecture.Performed assessment of the Atomize system in order to find whether ETL best practices were followed or not and submitted the recommendations of improvement.Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.Created an ActiveX control in .Net that will be used in Visual FoxPro front end. Visual FoxPro front end will pass few parameters to an ActiveX control; control then connects to the database and fetches records from DB.Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational dataCreated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.Administrated the created Reports by assigning permission to the valid user for executing the reports.Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.Tools & Technologies: SQL server 2019/2016/2014, Windows 2010/2011, T-SQL, Microsoft Share point Portal Server, Fumigant Log Explorer, VSS, SQL Diagnostic ManagerMS SQL Server (SSRS/SSIS/SSAS) / BI DeveloperJ.P. Morgan Chase, San Mateo, CA Apr 2017 Feb 2019Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.Developed SSIS package to load data into dimensions and fact tables using slowly changing dimension.Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.Agile methodology was used throughout the project, performed pivotal role in planning and developing as well as aligning with the assigned sprints.Developed logical and physical model using Erwin and implementing them to SQL server.Used Execution Planer and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.Used Team Foundation Server (TFS) to provide a set of collaboration tools that work with the existing IDE or editor, to work effectively on the project.Environment: MS SQL Server 2019/2016/2014, Visual Studio 2018, COM/COM+, VC++, C#, My SQL, Windows 2011, Windows XP, T-SQL, VB.NET, ADO.NET, ASP.NET, Visual SourceSafe, XML, MDM, Crystal Reports, SSRS, ERWINEDUCATIONBachelors Degree in Mathematics minor in Information system. |
