Resume

Sign in

Data Sql Server

Location:
Chicago, Illinois, United States
Posted:
August 24, 2018

Contact this candidate

Resume:

Fareed Mohammed

SQL Server/ Power BI Developer

269-***-**** ac6sjb@r.postjobfree.com

PROFESSIONAL SUMMARY:

Having 4+years of experience in multiple projects as SQL Server / ETL Developer and Business System Analyst in design & development of Database and implementation of the Project in LIVE.

Extensively worked on SQL Server, Netezza and Oracle databases

Strong experience on T-SQL and query optimization, developing ETL strategies.

Designed and created databases, tables, views, store procedures and triggers.

Experienced in writing complex TSQL Queries involving various tables using SQL joins and writing Sub Queries. Experienced in writing complex-SQL Stored Procedures and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.

Lead data mapping discussions with stakeholders, with little supervision.

Create detailed current & future state documentation (databases/tables/data elements) and data architecture diagrams.

Lead discussions to identify use cases and requirements for future state – both short and long-term.

Plan out a project to move us from current to future state data architecture.

Experience and Understanding of where leading industries are heading in data strategy.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.

Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Used Power BI for developing reports, data marts, KPI’s and charts.

Developed Power BI Reports and Dashboards from various sources.

Experience in assigning row level security for dataset in Power BI Desktop.

Experience in creating Dashboards from various sources with new Q&A feature in Power BI service.

Experience in implementing Incremental refresh for dataset in Power BI Premium.

Experience in designing various bookmarks and buttons in Power BI desktop.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert

Developing reports on SSRS on SQL Server (2008/2012/2015). Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Expertise in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert, and Merge Join.

Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum and Software Testing Life Cycle (STLC).

Well versed with agile ceremonies and able to manage all Work with stake holders, Product Owner, Product owner delegates for effectively scoping/user stories.

Focused troubleshooter and a team player with excellent interpersonal and communication skills. Ability to work cohesively with developers, other team members, and testers.

Analysis and evaluation of customer business problems and the development of solutions to meet business requirements and Good experience in agile projects as Business Analyst.

Act as the primary interface between business unit end users and systems development/applications and programming areas.

Analyze business systems and / or business processes to identify user needs, document requirements, and address operations/process issues/improvements to accomplish business. Requirements gathering and JAD analysis. Functional testing of the product and POC.

Software Skills

SQL Server, Netezza, Azure, SQL Management Studio, MS Visual Studio 2017, MS Office, SSRS, SSIS. Power BI, Windows10.

Eclipse, Dreamweaver, MySQL, MS SQL Server, MS Access, Jira, Netezza.

Familiar with Visual Studio, MS Windows, Microsoft Word, Microsoft Excel, Microsoft Project, Microsoft Power Point.

Familiar with Linux operating system.

Education

Master of Science in Computer Engineering

Chicago State University, Illinois January 2015 - May 2016

Work Experience

Nutrien, Fort Collins, CO

MS BI/ Power BI Developer

Environment- Microsoft Visual studio 2017, Microsoft SQL server 2017, Power BI 2017, Microsoft Data Tools 2017,

Microsoft Office 2017, Netezza

April 2018 – Present

Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.

Proven ability in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and ETL package design.

Experience in SSAS (SQL Server Analysis Services) in SQL 2008 and SQL Server 2017

Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2017 Analysis Services.

Creating Measures and Calculated columns using DAX commands.

Created SSAS Models from various sources like Netezza and SQL server.

Lead Data Mappings discussions with Stakeholders and completed the ERD of the tabular model.

Able to get hands dirty with data, manipulate and research to make sure ERD diagram works well.

Created detailed current and future state documentation and Data architecture diagram and uploaded on Jira.

Lead discussions with Stakeholders to identify use cases and requirement for future state both short term and long term.

Deployed SSAS model on Azure cloud and created Power BI reports.

Used Power BI for developing reports, data marts, KPI’s and charts.

Developed Power BI Reports and Dashboards from various sources.

Assigned Row level row security for Dataset in Power BI Desktop.

Created Bookmarks and linked those bookmarks with Buttons in Power BI Desktop.

Created Workspace in Power BI service and published reports in that workspace.

Used GITHUB to sync, pull, push and commit project code and Power BI reports.

Flexan LLC, Chicago, IL

SQL Server/ MS BI/ Power BI Developer - Chicago, IL

Environment- Microsoft Visual studio 2017, Microsoft SQL server 2017, Power Bi 2017, Microsoft Data Tools 2017,

Microsoft Office 2017, Crystal reports.

September 2017 – March 2018

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.

Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Created SSIS packages to Extract, Transformation and Load ETL user data and other data from OLTP to OLAP.

Used SSIS for each loop to implement data updates from various sources to data warehouse

Performed ETL process to load data from various source into upgraded database using SSIS 2016.

Used Conditional Split, Data Conversion, Derived Column, Merge Join, Sort and Union All in different SSIS packages based on requirements.

Made use of Aggregate, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Multicast, Sort and Union All in different SSIS packages based on requirements.

Creating reports for Sales team and providing inputs to Mike Huiras (Vise president of Sales) about the sales compared to present with previous YTD and then comparing it with YTD budget.

Creating Crystal reports for new ERP system.

Creating Sales report every week to keep track of Sales MTD present with MTD previous year and then comparing it with MTD present with Budget.

Lead discussions with VP of Sales to identify use cases and requirement for future state both short term and long term for Sales report.

Performing posting for every month end postings and creating reports for Finance department.

Creating Scarp reports and helping the Scrap team to understand the data and helping them to bring down the scrap percentage but comparing it with previous months scrap reports.

Assigning new users to the network and responsible for setting up new accounts and linking it to the active directory and helping them with the access to Flexan network and mapping drives requested by higher manager.

Creating SharePoint site and allowing access to user to the site with read only or full access as requested by Project manager.

SQL Server/ MS BI Developer - Dovenmuehle Mortgage, Lake Zurich, IL

Environment- Microsoft Visual studio 2016, Microsoft SQL server 2016, Microsoft Data Tools 2017,

Microsoft Access 2015, Windows 10

January 2017 – September 2017

Created databases for MS SQL Server 2017, MS Access.

Lead Data Mappings discussions with End users and was able to use Visio for creating ERD.

Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.

Extensive experience in Installation, Configuration and Updates of SQL Server.

Created SSIS packages to populate data from various data sources.

Experience in BI Development and Deployment of SSIS packages from MS-Access, Excel.

Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server

Created ad-hoc reports, drill down, and drill through reports using SSRS 2015.

Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.

Created multiple reports using SSIS.

Marvelous Technologies, Park City, IL

SQL Developer – Marvelous Technologies, Park City, IL

Environment- Microsoft SQL server 2015, Microsoft Data Tools 2015, Microsoft Access 2014, Oracle, Windows 10

July 2016 – December 2016

Analyze functional specifications and prepare technical specifications accordingly.

Create SQL scripts and programs on enterprise databases to extract, transform and load data.

Write SQL queries to perform data reconciliation between source system and data warehouse.

Created databases for MS SQL Server 2008, MS Access.

Develop, design and maintain the ETL code.

Global Logic Technologies/ Rane Brake Linings LTD

SQL Server Developer /Business Analyst

Environment- Microsoft Visual studio 2008, Microsoft Visio, Microsoft SQL server 2008, Microsoft Office 2010, Microsoft Data Tools 2008, Agile Methodology.

August 2012 – September 2014

Created databases for MS SQL Server 2008, MS Access.

Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.

Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.

Created T-SQL triggers and Stored procedures encompassing business rules.

Created ad-hoc reports, drill down, and drill through reports using SSRS 2005/2008.

Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Involved in migration of SSRS from SQL 2005 to SQL 2008.

Tested to optimize the Stored Procedures and Triggers to be used in production.

Monitored performance and optimized SQL queries for maximum efficiency.

Imported data from text files and excel spread sheets into SQL Server database using SSIS package.

Worked on various SSIS packages.

Define, plan, coordinate and obtain information requirements to support and launch new products and software releases

Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.

Developed flow diagrams for Business process of the company. Analyzed, prioritized and managed the requirements using Jama Contour.

Conducted JAD sessions with Product team, SME for open and pending issues and participated in the identification, understanding and documentation of business requirements..

Interface with internal business users as well as various IT development groups so the needs can be clearly understood, expectations managed and change initiated

Act as the point of contact between the business units and IT

Perform analysis for business applications

Develop and implement plans to suite business plans and objectives



Contact this candidate