| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLEPROFESSIONAL 7+ years of overall IT experience in database development and DatabaseSUMMARY system Microsoft SQL Server. Administration, Design, Development, andSupport of MS SQL Server 2022/2019/2016/2014/2012 and DevelopmentEnvironments. Extensive knowledge in ER Diagram and design of logical and physical datamodeling using Erwin tool and Visio. Expert in planning, modeling, designing, developing, implementing,administering and maintaining Microsoft SQL- Server, Visual Studio2019/2018. Designed and implemented database schemas, tables, and indexes usingDDL commands to optimize performance and ensure data integrity. Developed complex SQL queries, stored procedures, and triggers to supportbusiness applications using DML. Highly proficient in the use of T- SQL for developing complex StoredProcedures, indexes, Tables, Views, User Defined Functions, RelationalDatabase models, Data integrity and SQL joins. Extensive experience in designing de-normalized data warehouse includingStar 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 innerand outer joins, stored procedures. Expertise in designing SQL Server SSIS packages to import and transformdata between databases and external data sources. Data Mapping based on business requirement for ETL with source to targetdata mapping with physical naming standards, data types, domaindefinitions, and corporate meta-data definitions and worked on DataConversion using SSIS. Extensive experience in implementing event driven Error handlings andpackage logs. Expert in creating Dynamic SSIS Packages with Parameters, local andenvironmental variables, XML configuration and check points. Expert in creating data visualizations such as dashboards, parameterizedreports, drill down reports, and interactive reports using SQL ServerReporting Service. Hands on experience on developing Page level Reports, Dashboards, andStories Using Microsoft Power BI. Strong interpersonal & communication skills, Competitive analytical,logical, and problem-solving skills, Strong management, administrative andleadership 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) packagedesign, constructing, and deployment. Performed Data Scrubbing, Data Staging and Data Validation in preparationof pushing data to production environment.SKILLS Databases: SQL Server BI Tools: SSIS, SSAS, SSRS,2022/2019/2016/2014/2012, Tableau, Crystal Reports, DTS,Oracle, DB2 BCP, MS, Power BI, Alteryx Languages: SQL, T-SQL, T-SQL Programming (DDL,PL/SQL, .Net (C#, VB), XML, DML, DCL, TCL) (StoredDMX, MDX Procedures, Cursors, Functions, Operating Systems: Windows Triggers) Data ModelingServer2008/2003, Linux/Unix Other Tools: Erwin, JSON,Service, JIRA, Get Hub, SVN,Agile MethodologyWORK HISTORY BI(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 destinationtables by performing complex transformations using SSIS/DTS packages. Assisting end users with problems installing the power BI desktop, installingand configuring the personal and on-Premises gateway, connecting to the datasources and adding the different users. Extensively worked in creating ETL SSIS packages both design and code toprocess data to target databases. Created different Power BI reports utilizing the desktop and online service andschedule refresh. Use Tableau Desktop, Power BI or Alteryx to develop dashboards for variouspurposes, functionalities and best practice measures to suit the requirement andneeds of the business. Created Complex ETL Packages using SSIS to extract data from staging tablesto partitioned tables with incremental load. Handled Tableau admin activities granting access, managing extracts andInstallations Created packages in SSIS with error handling and worked with differentmethods of logging in SSIS Developed, Maintained, and Monitored all import/export and DataTransformation into the Staging and Production environments. Used ETL to implement Slowly Changing Dimension to maintain historicaldata in Data Warehouse. Performed efficient tuning of SQL source queries for data load/ Usage of storedprocedures for performance. Migrate existing legacy reports into Tableau while building new reports fromour Created extensive dashboards using data blending. Experience in report writing using SQL Server Reporting Services (SSRS) andcreating various types of reports like Tabular, Matrix, Drill Down, DrillThrough and web reporting. Designed different kinds of reports from scratch depending upon therequirements 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 transformationinside edit query and clean-up the data. Worked extensively on system analysis, design, development, testing andimplementation 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, MSExcel 2016.ETL/SSIS/SQL Developer Core Logic - Columbus, OH Oct 2021
Jan 2022 Extensively worked in creating ETL SSIS packages both design and code toprocess data to target databases. Created and optimized stored procedures, functions, and scripts using DML tosupport business logic and data transformation. Designed and maintained database schemas using DDL, ensuring scalabilityand performance. Created Complex ETL Packages using SSIS to extract data from staging tablesto partitioned tables with incremental load. Strongly worked in debugging and troubleshooting the technical issues whileimplementing the applications. Created packages in SSIS with error handling and worked with differentmethods of logging in SSIS Developed, Maintained, and Monitored all import/export and DataTransformation into the Staging and Production environments. Experience in providing Logging, Error handling by using Event Handler, andCustom 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 destinationtables by performing complex transformations using SSIS/DTS packages. Used ETL to implement Slowly Changing Dimension to maintain historicaldata in Data Warehouse. Performed efficient tuning of SQL source queries for data load/ Usage of storedprocedures 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 tovalidate consistent data entry into the database. Experience in report writing using SQL Server Reporting Services (SSRS) andcreating various types of reports like Tabular, Matrix, Drill Down, DrillThrough and web reporting. Designed different kinds of reports from scratch depending upon therequirements of the markets, vendors, providers and scanners. Documented all the work and all the process of integration and reportingservices for further references Worked extensively on system analysis, design, development, testing andimplementation 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, MSExcel 2016.ETL/SQL/SSRS/SSIS Developer GEICO, Chevy chase, MD Mar2019 Sep 2021 Wrote several SQL Scripts such as finding long running queries, blockingsessions, archiving data from production to archive server and populatingreporting data. Used various SSIS tasks such as Conditional Split, Derived Column etc., whichdid Data Scrubbing, including data validation checks during Staging, beforeloading 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, tomaintain Historical Data in Data warehouse. Leading and mentor the efforts of data quality completeness initiative forInformatics based ETL architecture. Performed assessment of the Atomize system in order to find whether ETL bestpractices were followed or not and submitted the recommendations ofimprovement. Created Error and Performance reports on SSIS Packages, Jobs, Storedprocedures and Triggers. Developed and designed cubes with calculated members, Design Dimensionsand using the MDX expressions for the various calculated members, actions andKPI. 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; controlthen connects to the database and fetches records from DB. Implemented OLAP Cubes, Facts, and Dimensions for providing summarizedand aggregate views of large sets of data and used Multi-DimensionalExpression (MDX) to access them. Involved in Designing and deploying cubes in SSAS environment usingSnowflake and Star Schema Designs for the operational data Created Sub-Reports, Drilldown-Reports, Summary Reports, and ParameterizedReports in SSRS. Administrated the created Reports by assigning permission to the valid user forexecuting 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 DiagnosticManagerMS SQL Server (SSRS/SSIS/SSAS) / BI DeveloperJ.P. Morgan Chase, San Mateo, CA Apr 2017 Feb 2019 Designed and deployed reports with Drill Down, Drill Through and Drop-downmenu option and Parameterized and Linked reports. Wrote PL/SQL Stored Procedures, Functions, and Packages to implement BusinessRules. Created reports to retrieve data using database code objects, such as StoredProcedures, views, functions and multiple T-SQL queries. Assisted in the development and maintenance of SQL databases, includingcreating tables, views, and indexes using DDL. Wrote and optimized SQL queries for data retrieval and reporting purposes usingDML. 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 usingslowly changing dimension. Developed Complex SSIS Packages to load data into Staging, ODS, and DataWarehouse systems. Developed SSIS packages using Lookup Transformations, Merge Joins, FuzzyLook Ups, and Derived Columns with Multiple Data Flow tasks. Involved with full development cycle of a Data Warehouse, including requirementsgathering, design, implementation, and maintenance. Generated test data and tested database to meet the functionalities deliverables inthe project documentation and specifications. Agile methodology was used throughout the project, performed pivotal role inplanning and developing as well as aligning with the assigned sprints. Developed logical and physical model using Erwin and implementing them toSQL server. Used Execution Planer and Database Engine Tuning Advisor to optimize queries andenhance the performance of databases. Responsible for performance tuning, optimizing the queries, removing redundant andinconsistent data, joins from the database tables and normalizing them. Used Team Foundation Server (TFS) to provide a set of collaboration tools thatwork 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, ERWINEDUCATION Bachelors Degree in Mathematics minor in Information system. |
