Yakub

Demonstrated experience with Microsoft SQL Server.

Demonstrated experience with SSIS.

Demonstrated experience with SSRS.

Demonstrated experience with Power BI.

Demonstrated experience with Tableau.

Gather requirements and business process knowledge to transform the data in a way that’s geared toward the needs of end users.. Export unorganized legacy data into Excel or CSV files and format the data in accordance with the desired form.. Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.. Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions.. Develop, design, and build ETL packages to transfer large amounts of data from legacy systems to SQL server data warehouse.. Troubleshoot issues that may arise and cause the ETL process to malfunction.. Create SQL server agent jobs to automate the ETL process.. Create and publish data models using visualization tools such as Power BI, Excel Power Query, and Tableau.. Write SQL scripts to cleanse incoming data before loading it into the data warehouse.. Create incremental load packages for newly created or modified data to reduce the overhead in the ETL process.. Set up auto-generated emails to inform product owners and other interested parties when data is processed.. Improve already existing processes and ensure the data architecture is scalable and maintainable.. Interacted with developers during testing to identify memory leaks, fix bugs and optimize server settings at web, app, and database levels.. Worked closely with cross-functional teams to deliver projects using Agile methodology ensuring timely and high-quality delivery.. Created and maintained project documentation including goals, development, challenges, and so on.. Participated in CAB meetings to evaluate upcoming changes in the IT environment such as server upgrades and applying server vulnerability patches.

Meet with decision makers, systems owners, and end users to define reporting requirements and goals.. Influence business to understand or clarify the reporting need by providing mock-ups, charts/diagrams, use cases, and data to define and refine the requirements.. Work with end-users to identify and facilitate best practices that enable an appropriate, effective, and efficient use of reporting tools and applications.. Prepare and deliver reports, recommendations, or alternatives for improving processes in reporting systems across the organization based on requirements and standards.. Ability to work on multiple BI tools such as SSRS, Crystal, PowerBI, Tableau, etc.. Follow the governance process and ensure compliance while developing and promoting reports to production.. Provide customer-focused service and support for incidents, service requests, and post-implementation support (hyper-care).. Coordinate and perform in-depth tests, including unit testing and support integration and end-user acceptance testing (UAT), for modified and new reports.. Support delivery of reports in different consumption patterns such as report subscription or on-demand.. Communicate reporting changes, enhancements, and modifications verbally or through written documentation so that issues and solutions are understood.. Research, review, and analyze the effectiveness and efficiency of existing reports and stored procedures and identify ways to improve their performance. Identify, document, and implement reporting best practices that leverage lessons learned.. Design, develop, and implement SQL Server databases, tables, views, stored procedures, functions, and triggers.. Write and maintain complex stored procedures and functions to support various business requirements.. Optimize database performance by analyzing query execution plans, indexing strategies, and database statistics.. Troubleshoot and resolve database-related issues, including performance bottlenecks, data integrity, and concurrency problems.. Collaborate with software developers and system administrators to ensure seamless integration of applications with the database.. Perform database tuning and optimization to improve overall system performance.. Implement and maintain database security, including user access control and data encryption.. Monitor and maintain database backups. Implement and test disaster recovery strategies.. Monitor database performance and proactively identify and resolve issues.

Created dependable data pipelines using SSIS to transfer the company’s outsourced vehicle testing data to the end user.. Used JIRA to track the progress of projects and day-to-day activities.. Created documentation for standard procedures for different aspects of my day-to-day duties and responsibilities.. Optimizing and Performance Tuning SQL Scripts to make reports run smoothly and efficiently.. Built ETL data models using Excel’s power query features to generate reports for vehicle testing that were conducted on yearly basis.. Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, and Matrix reports using SSRS.. Created and maintained SSIS ETL packages to extract data from different systems and load a variety of large-volume data into a data warehouse from different sources like flat files, and Excel files.. Setup batch purge processes for data older than a year.. Used derived table and fuzzy lookup to clean and update dirty data on SSIS.. Used For Each Loop container to enumerate through multiple files on the source data and upload the data to the OLEDB destination.. Scheduled and managed daily/weekly/monthly testing and operational reports based on business requirements.. Data access, transformation, and mobility needs are translated into functional requirements and mapping designs.. Building, and publishing customized interactive reports and dashboards, report scheduling using Tableau server.. Used new job dialog box on SSIS to schedule SQL Server Agent jobs to automate repetitive tasks.. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets.. Developed visualizations and dashboard reports using Qlik Sense and other visualization tools.. Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.. Created visual charts, bar, and line graphs to display projected quarterly and yearly testing schedules.

Connected to daily Sales department leads file & importing the leads into SSIS.. Filtered out leads that don’t meet the qualifying criteria such as non-qualify credit and income.. Loaded the washed “clean leads” into a destination file so that they can be loaded into a CRM system and agents can start calling the leads.. Analyzed customers’ current and past power usage to determine future needs and generate a customized power plan using clean energy solar panels.. Used Multicast transformation tool to enable one copy of a customer leads file to be loaded into a CRM System, and another copy into a customer leads database.. Logged all relevant communications between customers and lead generators in the Customer Relationship Management contact database.. Restructure dates into the correct format using the date function.. Transformed data types from default flat file data type using a data conversion tool before loading into the destination.. Improved ETL performance by following MSDN recommended guidelines.. Collaborated with team members using Team Foundation Server to keep track of project progress.. Generated power consumption and billing breakdown visualized dashboard reports for customers monthly.