| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLESummaryOver 7 years of experience in developing reporting solutions, ETL development, business intelligence solutions, and enterprise data warehouse development across multiple industries.Expertise in building and managing relational databases, including normalization/denormalization using SQL Server Management Studio (SSMS).Proficient in writing efficient T-SQL query statements tailored to project requirements.Skilled in utilizing features such as Dynamic SQL, Cursors, Views, Stored Procedures, User-Defined Functions (UDFs), Triggers, Indexes, and Temp Tables in SSMS for improved front-end application convenience and reporting purposes.Proficient in performance tuning of query statements using Execution Plan, SQL Profiler, and Database Engine Tuning Advisor.Extensive experience in designing and effectively using tabular charts, donut charts, histograms, and maps with visualization tools like Tableau, PowerBI, MS SQL Server Reporting Service (SSRS), and Excel to provide comprehensive business solutions.Excellent knowledge of MS SQL Server Integration Services (SSIS) for ETL solutions including Data Migration, Data Conversion, Data Validation, Data Management, Reporting, and supporting analysis.Deep understanding of Enterprise Data Warehouses and Data Marts, including OLTP/OLAP, Dimension/Fact Tables, Top-down/Bottom-up models, and Star/Snowflake Schemas using Landing and Staging stages.Strong skills in SSIS Control Flow (Execute SQL task, Foreach Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, etc.).Substantial experience in utilizing Event Handlers, Loggings, Checkpoints, Breakpoints, and Debugging in SSIS. Azure and Cloud Pipe Lines, Google Cloud platform APIsProficient in implementing data loading and transformation dynamically using skills such as Slow Changing (Type 0/1/2/3) and Change Data Capture.Well-versed in Agile/Scrum/Waterfall methodologies and the various phases of the Software Development Lifecycle (SDLC).Effective problem solver with strong analytical skills, capable of delivering credible and concise presentations.Technical SkillsetRDBMS: MS SQL Server 2016/2012/2008R2/2008/2005, MySQL, OracleReporting Tools: SQL Server Reporting Services (SSRS), Excel 2016/2013/2007, Tableau 10/9/8, Power BILanguages: T-SQL, PL/SQL, C++, C#ETL: Server Integration Service (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Data Quality Services, Talend, Azure data factoryData Warehouse/OLAP: SQL Server Analysis Services (SSAS)Development Platforms: Visual Studio 2015/2010/2008, SharePoint 2013/2010, Atom, Jupyter, PyCharmProject Management: JIRA, Slack, TFS, Microsoft Project, Microsoft VisioChase BankJuly 2020 PresentSQL/ETL DeveloperResponsibilities:Gathered requirements, performed logical and physical data modeling, developed fact and dimension tables, configured ETL workflows for populating tables, and created Cubes and reports for analysis.Developed complex SQL queries and optimized databases, tuning long-running SQL queries using SQL Server Profiler and SQL Tuning Advisor.Troubleshot and resolved production ETL issues.Optimized stored procedures, T-SQL, views, and functions for optimal performance.Streamlined and automated regular SQL processes, tracked issues, and documented changes.Developed and automated SSIS packages for Extraction, Transformation, and Loading (ETL) of data from various sources such as flat files, MS Excel, CSV, and MS Access into SQL Server.Created complex database objects like stored procedures and user-defined functions (UDFs).Implemented tables, views, indexes, and triggers in MS SQL Server to support relational and dimensional database models.Developed scripts for data manipulation and ensured data integrity.Designed, developed, and maintained a data warehouse.Created tabular reports using SQL Server Reporting Services (SSRS).Generated parameterized reports and implemented drill-down and drill-through functionality.Deployed reports, established report schedules and subscriptions, and managed and secured reports using SSRS.Sunbelt Rentals September 2015 May 2020Database DeveloperResponsibilities:Gathered and documented project requirements from stakeholders, translating them into functional and non-functional specifications for BI reports and applications, and delivering solutions accordingly.Participated in the data mapping process, identifying and documenting column and table meanings, as well as establishing relationships among them.Extracted data from Electronic Health Records (EHR), Electronic Medical Records (EMR), pharmacies, and other external resources using T-SQL and PL/SQL, leveraging Stored Procedures, User-Defined Functions (UDFs), and Views based on business requirements.Optimized query performance by analyzing execution plans, logs/statistics, and utilizing tools such as SQL Server Profiler and Database Engine Tuning Advisor.Designed and developed ETL packages for full loading and incremental loading, transforming data using lookup, merge joins, derived columns, and building the target data warehouse and data marts based on Star Schema.Implemented ETL packages with breakpoints and error handling mechanisms, leveraging SQL commands in SSIS to send email notifications in case of errors, warnings, or task failures.Developed reporting solutions using SSRS and Tableau, catering to different stakeholders and covering various dimensions such as claims, transactions, appointments, supply, assets, and properties. The reporting solutions included tabular reports, matrix reports, and utilized cascading parameters for Drill-down Reports, Drill-through Reports, and Linked Reports for enhanced security.Collaborated with the QA team to address and resolve issues, ensuring deliverables met project requirements. Obtained feedback and approval from the project manager.Optimized report performance by refining T-SQL queries, eliminating redundancies, retrieving only essential data, and utilizing SQL methods efficiently.Academic BackgroundBachelors Degree |
