| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email : EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEProfessional Summary:MS SQL Server Developer with 9+ years of strong experience in various domains like Financial, Retail and insurance with expertise in MS SQL Server 2019/2017/2012/2008R2/2008/2005/2000 and SSIS, SSRS, SSAS.Comprehensive knowledge & in all phases of the Software Development Life Cycle (SDLC)Proficient in Conceptual, Logical, & Physical ModelingExperience in designing, modeling, developing, managing &administrating database systemsExcellent in enterprise database architecture, security, high availability & performanceWell versed in designing, constructing and implementing operational data stores and data martsProficient in relational & dimensional database modeling also normalization & demoralizationSkilled in creating & managing database objects, stored procedures, triggers, views & UDFsFluent in T-SQL programming language, including store procedures & user defined functions.Expert in creating materialized views using Sub-Queries, CTEs, & JoinsExpertise in designing and implementing both Start & Snowflake SchemasHand on experience in utilizing DDLs, DMLs, functions, variables, temp tables & transaction blocksExperience in Developing & delivering data integration workflow using Agile delivery methodologyWell versed in developing Data Transformation workflows using SSIS packages.Experienced in designing & implementing data flow processes to integrate data from various heterogeneous data sources like Access, Excel, & flat filesWell versed in designing dynamic SSIS packages using variables, parameters & expressionsProficient in creating dynamic SSIS Packages to refresh slowly changing dimension tablesSkilled in creating and maintaining a slowly changing data flow process for enterprise data warehouseExcellent in developing SSRS reports with functionality such as Drill Down, Drill through, &Parameters Well versed in creating ad hoc reporting Data Model using Power BIExpert in building visualizations in Power BI Desktop and Power BI ServiceHands on experience in deploying Power BI reports to app workspaceExcellent in managing Power BI workspace users and configuring getaways for data refreshEffective in problem solving skills, and ability to analyze existing systems and ascertain users needs, and translate into clear proposals and plansAbility to work multiple projects with multiple deliverablesWork with Agile team to develop BI platform dataflow, visualizations & interactive dashboardsExcellent communication with multifunctional teams, programmers, and technical staff at all levelsPROJECT METHODOLOGYAgile methodology with Multiple Sprint CyclesCustomer focused & Rapid deliveryAdaptive to changes in technology & requirementsHighly collaborative with Daily Scrum meetingsClient: Charter Communication, Charlotte, NC September 2022 PresentRole: MSSQL DeveloperResponsibilities:Develop high-quality database solutions.Design, develop, and maintain efficient, reusable, and reliable SQL code. Use T-SQL to develop and implement procedures, functions, triggers and views.Analyze existing SQL queries for performance improvements. Identify and resolve performance issues in SQL queries and database processes. Optimize SQL queries and database structures for better performance and scalability.Plan and execute data migration tasks, including data cleansing, validation, and transformation from various sources into SQL Server databases.Research required data.Implement and maintain database backup and recovery strategies. Perform regular backups and ensure data can be restored in case of failures.Work closely with software developers, business analysts, and other stakeholders to understand application requirements and ensure seamless integration with databases.Build appropriate and useful reporting deliverables.Use version control systems to manage database scripts and schema changes, ensuring version history and collaboration among team members.Investigate and resolve database-related issues reported by users or automated monitoring systems. Provide timely and effective solutions to problems.Investigate exceptions with regard to asset movements.Tools & Technologies: MS SQL server 2017/2019, SQL Profiler and T-SQL, Windows 2008 server and Visual Studio 2019, Microsoft Office, Source Tree, Bit Bucket, Index Tuning Wizard, Query Analyzer, SQL profiler.Client: Newport group, Charlotte, NC June 2019 August 2022Role: SQL/SSIS DeveloperResponsibilities:Worked closely with SMEs end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions toValidate the solution met requirements. And prepared documentation for same.Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.(used CTE, temporary tables,user defined table types in codes developed)Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, IndexTuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012/2017/2019.Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.Involved in enhancing and deploying the SSIS Packages from development server to production server.Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning AdvisorHighly skilled with Agile/Scrum/Waterfall working methodologies along with phases of Software Development Lifecycle (SDLC)Designed and developed ETL solutions for transformation of data from source transactional systems or other data feeds, into a dimensional database, or other destinationsCreated, Scheduled, Generated and optimized ETL jobsCreated and maintained technical documentation using defined technical documentation templates.Proficient in programming languages such as Python, as well as popular python libraries and frameworks including TensorFlow, PyTorch, Scikit-learn, SciPy, NumPy, Seaborn, Matplotlib and pandas.Contributed to the creation of solid coding techniques and recommended and reviewed coding standards. Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data. Wrote documentation, data warehouse artifacts and data lineage for ETL tools.Tools & Technologies: MS SQL server 2017/2019, SSRS, SQL Profiler and T-SQL, Windows 2008 server and Visual Studio 2019, Microsoft Office, SSIS, Index Tuning Wizard, Query Analyzer, SQL profiler.Client: Rolex, New York, NYDec 2016 May 2019Role: ETL/DataBase DeveloperResponsibilities:Developed & maintained complex SQL stored procedures and functionsWorked with Type 1 and 3 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse conceptsDeveloped Complex SSIS Packages to load data into Staging, ODS, & Data Warehouse systemsDeveloped SSIS packages using Lookup Transformations, Merge Joins, Union all Fuzzy Look Ups, & Derived Columns with Multiple Data Flow tasksCreated XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task Failed Event TypesAutomated SSIS Packages using SQL Server Agent JobsConfigured various event driven e-mail notification process in SSIS packagesCreated audit database to handle SSIS error output and validate dataDesigned visual report solutions, including dashboards using SSRS and/or other data visualization/dashboard toolsDeployed SSRS report to Report Server Web ServiceConfigured report server & report manager for SSRS report deployment and managementDesigned reports with single /multi valued, dependent & Cascading ParametersCreated Report Email Subscription using Data Driven & Time Triggered Report SubscriptionsWrote efficient stored procedures for optimal performanceOptimized SQL queries for improved Reports renderingDeveloped, executed, documented, & maintained appropriate BI documentsWorked with end users & developers to determine requirementsScheduled Jobs and Alerts using SQL Server AgentDesigned full Normalized relational database model for application supportConfigured Database Components to support online transactionsDeveloped Error Handling scripts to adhere Transactional properties (ACID)Created test scripts to evaluate database and application reliabilityDeveloped and maintained complex SQL stored procedures and functionsDeveloped a complete SSIS life cycle creating SSIS packages including building, deploying, executing, and scheduling the packagesCreated SSIS package that refreshes type one and type three-dimension tables using slowly changing dimensions transformationCreated maintenance plan packages for backup and restore operationsDesigned Parameterized Reports for generating Ad-Hoc reports as per clients requirementConfigured subscriptions, snapshots, cache refresh and reports history on report managerInvolved in Normalization and De-Normalization of existing tables for faster query retrievalCreated groups, roles, users and assigned access privilegesDeployed database objects from development/testing environment to production environmentDeveloped and published reports using MS SQL Server Reporting ServicesTools & Technology: Windows Server 2000, 2003, 2008, 2008R2, 2014, 2016, 2017; MS SQL Server; Water fall, Triggers; DDL; DML; 1stNF 3rdNF; Visio; DTSClient: Wadi El-Sundus Petroleum Co.LTD, Addis Ababa, EthiopiaMay 2014 Nov 2016Role: SQL developer/ SSRS, SSIS DeveloperResponsibilities:Understanding the business requirements.Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS.Transformed Complex business requirements into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2012.Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.Experienced in implementation of strong referential integrity and auditing with the use of triggers.Deployed the SSIS Packages to File System based on the requirementsDevelop of complex SQL queries, stored procedures, functions and triggers.Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.Developed Cross-Tabbed and Sub-Reports in 2012.Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2012.Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.Created complex SSIS packages using various transformations.Prepare documentation for ETL process future references.Tools & Technologies: Environment: Microsoft SQL Server 20012/2008R2, SQL Server Reporting Services (SSRS), XML, SQL Server Integration Services (SSIS), Windows Server 2008.Education:Bachelor Degree of Computer Science from Addis Ababa University in 2007.IBM CERTIFICATE On Databases and SQL for Data ScienceBusiness Skills / Technical Skills:MS SQL Server 2019/2017/2012/2008R2/2008, Visual studio 2019/2013/2010/2008 (SSAS/SSIS/SSRS), Microsoft Access 2007/2003, Microsoft Excel (Pivot Table), OLAP and OLTP, Outlook, MS SQL Profiler, SQL Server Azure, SQL server Query Analyzer, Index Tuning Wizard, C#. Net, VB.Net. / Share point, Crystal Reports 10, ADO.NET, Erwin8/3.5, Windows 2007/2005 Advanced Server/Professional, Window XP, MS Access, C#, My SQL |
