Sana Shay

**** * *** **

Palos Hills, IL, ***** advteo@r.postjobfree.com 630-***-****

Summary:

-Design and development on databases using SQL Server . Developing Reports using SQL Server Reporting Services (SSRS),SQL Server Integration Services (SSIS),ZappySys.

Developing SSIS,ZappySys packages and designing ETL processes. Performing optimization onalready existing databases. Designing and developing business reports.

- Solid understanding of the Microsoft BI Stack including SQL Server, SSIS,ZappySys,SSRS and Power BI with 5 years of experience with Microsoft BI tools. Design and build ETL packages using MS SQL stored procedures and Integration Services and PostgreSql .

-Support design and implementationof reportsusing Reporting Services (SSRS).

-Design, develop and support Power BI data sources, reports and dashboards.

-Assist with the development and implementation of a data analytics solution.

-Work with database team to optimize database performance of queries and ETL processes.

Provide end-user support by utilizing interpersonal skills to communicate with and instruct end-users on MS BI products and technologies.

Workedwith Tableau,Solid net, C#, DB, data mart, Azure Ad,Integrations, Azure AD.

-Troubleshoot escalated BI issues including data, ETL and SSRS issues.

-Experience designing, developing and supporting Power BI data sources and reports.

-Proficiency with Microsoft SQL, includingwritingand optimizing T-SQL, stored procedures, functions and views, SSIS,ZappySys/ DTS. Analytical and systematic approach to software testing. Experience with support system processes.

-Demonstrated working experience with current web development techniques and open- source- technologiessuchas.NET Developer, API,ODATA,ASP.NET, C#.NET,VB.NET, Visual Studio, silver light, HTML, WCF, AJAX,MVC, XML,C#, Phython and JavaScript.

Involved in all the phases of SDLC from Software Requirements Analysis Phase to Design, Development Involved in all the phases of SDLCfrom Software Requirements Analysis Phase to Design, Development

-Installed and admin SQL Server, SQL client, IIS, Visual Studio, windows.

-Installed operating systems such as Linux, UNIX, novel.

-A Web designer and implement the technical aspects of websites. Designs the application framework, selects the software and hardware platforms and determines the site navigation. Also analyze net traffic patterns and determine system volume and create web content, wide knowledge, and experience, in various web development languages.

Understanding and implementing the requirements of the client, making communication and interpersonal skills Development and management of the departmental web content management system.

Knowledge of webdevelopment methodologiesand technologies at expert level.

Ongoing new implementation and maintenance and application architecture for different range of web systems.

ASP. Net for Applications Razor view,aspx / Websites with SQL,PostgreSQL Jsonand Oracle.

Softwaredesigns in technologies Visual Basic, SQL,ASP. Net for Applications/ Websites Web User Controls, Data Grid control, Form validation controls and created custom controls.

Writing SQL triggers/ queries and Stored Procedure. SQL Server-SQL queries coding,

Stored Procedures, Functions, and Packages.

Technical knowledgeof various reporting solutions such as Crystal Reports, SQL Reporting Services, and Business Objects..

Create programmingspecifications. ADO. Net, Visual Basic, IIS, ASP. Net a scripting language: Javascript and VB script.

SQL Server, SQL Server DBA in a large database, high transaction production environments. Background in e-Commerce enabled web site design and development. Demonstrated technical knowledge of various application languages (specifically c#, VB.NET, Phython, Visual Basic, and VBA), databases, and database architecture.

Experience in hardware, software, networking, system set-up and troubleshooting. Technical knowledge of PC operating systems and applications .

Skills:

C#.Net,Vb.NET, MS SQL Server, ASP. NET, WCF,, IIS, Java ScriptPhython, Oracle, C#,UNIX SCRIPT SHELL, Database, Lisp, HTML, CSS, XML,Excel, Access, Linux, UNIX,fiddler,JQuery,Bootstrap, PostgreSql

,SQL.Json.

Education:

Master Software Engineering, Strayer University, VA, 2009-2011 Master Computer science, Elmhurst College, Elmhurst, IL, 2003 – 2005 Bachelor computer science, Jordan University, Jordan, 1992 - 1997 Experience:

BMO Harris Bank, Chicago IL Jul 2016-dec 2022

SQL Developer, Web developer, .NET Developer, ASP. NET

SSIS,ETL,SSRS,SSAS, Visual studio .NET,API,ODATA,, ASP. NET, SQL Create a full application for BMO Bank,Web architect Create, update, and maintain site pages for BMO Bank using ASP. Net, SQL, Visual basic. Net, CSS, HTML, JavaScript, and XML/ XSL,ASP. NET, c#.NET, VB.NET, Visual Studio, silver light,

,ZappySys,MVC,Jquery,PostgreSql,SQL.Json,Phython,PowerBI.

•Created SSIS packages,databases,tables,queries,ETL.

•Data Migration,import export database .

•Created Database,queries,stored procedures,.

•Automated and scheduled the execution of ETL SSIS Packages

•Involved in all the phases of SDLC from Software Requirements Analysis Phase to Design, Development, Testing, Integration, Implementation and Maintenance.

•Involved in application enhancement in terms of Speed, improved security, Error Logging, Exception handling, Code Reuse with Object oriented design, Reusable Service Oriented Components and deployment.

•Actively participated in migration of existing application

•Involved in integration of applications and maintained versions using VSS (Visual Source Safe).

•Performed code review and generated reports on code review comments and updates.

•Created Custom Lookup Classes that would cache the data, enabling less database hits.

•Create standard CSS file to make fields look similar across the application.

•Move the business logicand complex mathematicalcalculations from UI layer to SQL Server wherever possible.

•Involved in Coding and integrating the various components of the same. Worked on the technologies like ASP.NET, WCF Services (SOAP, WSDL)

•Produced detailed leveldesign document forcustomer portal.

•Preparing analysis, design documents, estimation, fordifferent componentsand functional modules required by the system.

•Developed business objects using ASP. Net forvarious modules.

Create a web site for the bank hardware to include 400 bank branches, such as laptops, desktops, printers, servers, software, user login, last user logged in, update this data biweekly, to make sure it is up to date such as if they brought new hardware orgot rid of hardware, import and export the selected data to pdf format, word and excel format, ssis,use ssrs reports to reflect the selection.

Sample of the project on YouTube removed from it critical info

http://www.youtube.com/watch?v=dKvE2HZyz20

Here sample of my phone application using C#,asp.net,web services http://www.youtube.com/watch?v=CZtUFhL4BAQ HYPERLINK "http://www.youtube.com/watch?v=CZtUFhL4BAQ&feature=relmfu"& HYPERLINK "http://www.youtube.com/watch?v=CZtUFhL4BAQ&feature=relmfu"feature=relmfu SSRS sample

http://www.youtube.com/watch?v=ViaWmV-94So&feature=related Animation

http://www.youtube.com/watch?v=HRXbPWBZlt0 ASP.NET,SQL,

http://www.youtube.com/watch?v=CZtUFhL4BAQ&feature=related

http://www.youtube.com/watch?v=HRXbPWBZlt0 http://www.youtube.com/watch?v=CZtUFhL4BAQ HYPERLINK "http://www.youtube.com/watch?v=CZtUFhL4BAQ&feature=related"& HYPERLINK "http://www.youtube.com/watch?v=CZtUFhL4BAQ&feature=related"feature=related

AAATOWING, Chicago, IL Jan 2014 – Jul 2016

Created SSIS packages,databases,tables,queries,ETL.

SSIS,ETL,SSRS,SSAS, Python,C#.NET and VB.net Web Developer Create, update, and maintain site pages for Towing using ASP.net,Vb.net, SQL, Visualbasic. Net, CSS, HTML, JavaScript, and XML/ XSL. Coordinate with producers and designers for major site changes. Maintain internal tools for managing site structure, news data.

Gathered requirements to produce Functionaland Technicalspecifications

•Created SSIS packages,databases,tables,queries,ETL.

•Data Migration,import export database .

•Created Database,queries,stored procedures,.

•Automated and scheduled the execution of ETL SSIS Packages

•Engage with the analysis, design, development, testing of the application.

•Developed & maintained Web Forms with ASP. Net and VB.Net.

•Extensively using Datasets, Datatable of ADO. NET to retrieve and manipulate data and display it in an ASP. NET page and user control.

•Using Data Grid, Data List to display data in a customized format in the ASP. NETweb pages.

•Created complex Stored Procedures, Triggers, and Views & Functions using SQLServer.

•Handled all issues regarding database, its connectivity & maintenance

•Handled issues of front-end & applied proper validation, DB Design.

•JavaScript for Client side Validation.

•Handled issues of front-end & applied proper validation.

Environment: Visual Studio .NET,C#.Net, VB.NET, MS-SQLServer, JavaScript, ADO.NET, IIS, HTML, CSS, XML

Web application so that the user answer the dispatch call,take the client info and assign and locate a driver, then put the driver at the bottom of the list and then print the work order.

180 Properties, Chicago, IL Aug 2013 – Jan 2014

Created SSIS packages,databases,tables,queries,ETL.

Developer asp.net/ SQL Developer NET Developer c#.net, vb.net &ASP.NET

Web architect, Create a full application for 180 properties. Create, update, assign work orders, import, export reports and data, and print reports.

Created an MS Access database to collect data systems in order to provide lists, status reports and management overview reports..

Managed alldata related aspects of multiple directory projects through various stages of production.

Provided site personnel with problem resolution and technical Assisted in overall configuration, coordination, maintenance, backup, troubleshooting and the development of specialized application and database procedures.

The business has 50 services and do the services as single service or group services with group price, so user assign the work order either to in house or contractor then both of them can send the order to the other for one of them to decide to take the order, and each can add his comments to the form and then after the work accomplished they be able to print the work order.

Contact this candidate