Data analyst

SARAB A. AlANI

602-***-**** ***********@*****.***

**** ******* ****. *.******** MD 20852

Senior Professional and Expert in building automation tools and sql database developer, with good academic credentials (BS in Computer Science and MTA – Microsoft – SQL server database administration certification ).

who has designed and implemented efficientMicrosoft Office (platforms) primarily using (Tsql, VBA, VB, C#, Java and VSscipt. And who is successfully combined technical expertise with proven skills in leadership, training and diplomacy, troubleshooting and resolving technology and staffing issues.

AREAS OF EXPERTISE

SQL Developer Database

TSQL (designed tables,.stored process, functions, views,triggers)

Automation : Expertise VBA, VB.Net, C#, Python, Java and Java script.

Reporting and Visualization: Reporting with SSRS and Power BI and Dashboard with Power BI

Understand Salesforce and Experience with salesforce lightning and its report developing and

Salesforce Object Query Language (SOQL)

Fargo- Jacksonville FL

Senior Business System Analyst (remote)

10-2021–current

Coding: in delay bases on SSMS to create/develop Stored procedure/tables/function ext and querying to cover the business requirement.

Reporting: creating and develop reports in two ways, using SSRS tool or develop a built effective and attractive Dashboard using Power BI which depends on data source and Mangers/clients end user requirements.

Automation : Created /Designed and developed automation tools to do variety and deferent tasks needed using mainly VB.net, VBA (Access), C#, Python and Java.

Create and update the current Salecforce report and report type and create queries with soql as required.

Work on BRX file and through inspire scalar design and consolidated the outcomes files.

Rosenberg & Associates. LLC (Remote)

Sr. Database Developer/Programmer(D.C. Metro Area)

July 17th2012–Sep 2021

Drive database development and implementation of multiple complex applications.

Design, develop, document, test and debug software applications and utility programs in Microsoft Access and Excel using Visual Basic for Applications (VBA), scripting languages and other tools

Programmed and automated procedures using TSQL, Shellpoint, Vscript, .Net, VB, VBA, XML, HTML, CSS runs under MS Access end user’s database application.

Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations

Administrate all the databases (in SQL server) in our system, providing tuning, backups and restores policy and security

Manage SQL Server and Mysql server databases through multiple product lifecycle environment, from development to production systems.

Configure and maintain database servers and processes, including monitoring of system health and performance, availability, and security.

Refine and automate regular processes, track issues, and document changes.

Developing complex query tuning and schema refinement.

Create automated procedures that transfer and load data (ETL) between different platforms

Administrate all the databases (in SQL server and Mysql) in our system, providing tuning, backups and restores policy and security

Programmed and automated procedures using TSQL, Shell point, Script, .Net, VB, VBA, XML, HTML, CSS runs under MS Access end user's database application.

Design, Develop, debug, test and maintain SQL Server databases, SQL scripts and database objects.(Stored procedures, Triggers, jobs, views and tables).

Create automated procedures that transfer and load data between different platforms

Manage and plan for all the aspects of security, maintenance and develop the end-user system and all other systems and applications in the office.

Maintain and update user documentation and programmers/IT instructions.

Working closely and directly with Owner of the firm and the ED and managers to puttogether a future plan.

Interviewing, hiring andtraining IT and programmer, and assist them for better performance.

Identifying, researching, and resolving technical problems through troubleshooting end-user.

Lead teams to solve complex problems related to the IT department.

Program in T/SQL, .NET, VBA, VB,C#, Shellpoint, VScript, Java, JavaScript, HTML, XML and others language when its need to create solutions for our business needs.

Upgrading and Converting existing databases with new platform and new technology.

Interprets and writes business and functional requirements associated with the design, development, maintenance, and integrity of organizational data and business processes.

Gannett Digital (McLean VA ) March 19th 2012 – July16th 2012

Analyst

Mine data to arrive at specific and crucial information for marketing decision makers.

Run ad hoc queries on consumers, merchants and vendors demographics to assess and improve Marketing.

Analyst data in MS Excel, MS Access and SQL.

Work with large and complex databases containing millions of records to consolidate into one statement.

Determine and collect data to monitor and evaluate operations.

Extract data from several data stores and performed ad-hoc queries.

QEV Analytics company (Washington DC, ) Jan 19th 2012 – Feb 1st 2012

MS Access Database Developer/ Excel Analyst

Create and design a master database (QEV_Analyticsdb) in MS Access (using sql and vba) of all survey questions and results for some of key clients survey.

Generation of trend tables reporting in chronological order the results of identical questions asked over time, and the generation of a catalog of questions ordered by subject matter.

Immigrate the information from SPSS to MS Access database.

Analyst data in MS Excel and built procedure to export to MS Access.

America Traffic Solution (ATS) (Tempe, Arizona) July 27 2011 - Nov 01 2011

Analyst/Access Database Developer

Develop and design an Evaluation System“Scorecard” to evaluate/Analyst the productivity of the ATS agents.

Manage links Oracle to Access by ODBC and using SQL and VBA to create the User Interface forms

Cooperate with Oracle developers staff to provide reports required by managers.

Analyze Data (productions) quantity and quality of ATS agents.

Create and manage tasks that carry out updating the database automatically.

Arizona Refugee Community Center (ARCC), Phoenix, AZ Jan 2008 – Mar 2011

Created and maintained databases using Access, VBA and SQL to control ARCC information

Led and oversaw Center operations and administrative functions under Board of Director supervision

Coordinated and participated in Board of Director meetings and strategic planning sessions, and created, monitored and adjusted schedule and attendance of various community related programs

Exercised budgetary control and submitted regular financial reports to the Board of Directors successfully implementing cost cutting measures decreasing operating costs by 50%

Responsible for successful fund raising events and grant writing raising $28,000 and increasing operating budget by 50% for center benefitting refugees and community which extended life of operations by 1 year

Administered personnel, salary and hiring policies; recruited and trained 70 volunteers

EDUCATION

MTA – Microsoft – SQL server database administration

MBA - New York Institute of Technology (in progress)

BS in Computer Science - Al-Mustansray University, Iraq

Contact this candidate