OBJECTIVE:

Utilizing and expanding my knowledge as a Financial Analyst or Senior Data Analyst using T - SQL, SSRS, Excel and Access.

SUMMARY:

• T-SQL Server 2012, SQL 2014 - Stored procedures, Triggers, Views, Indexes, Backup, Restore, Database Security, Functions, DML, Writing SELECT, UPDATE, DELETE, and INSERT statements with multiple table joins.
• Creating, modifying and executing SSIS packages to load clients’ raw data from Excel to SQL Server.
• Develop ETL/SSIS Imports and Exports that meet provided specifications. SSIS Control Flow, Data Task, SQL Tasks, Data Conversions.
• Delivering reporting solutions in SSRS based on criteria, cascading parameters and drop-down lists for end users.
• Certified Microsoft Office Specialist, Data Analyst having expertise in analyzing the data using MS Excel (V-lookup, H-lookup, pivot tables, what-if analysis, scenarios, link cells, charts), MS Access.
• Highly skilled in writing SQL, with in depth experience creating databases, queries, designing tables and reports.
• Advanced proficiency in MS Office applications (Outlook, Word, Excel, PowerPoint, Visual Basic).
• Understanding and performance of normalization, database creation and indexing.
• Superior spoken and written communication skills; articulate and professional.
• Managing my relationship with exterior customers/clients with excellent phone presence and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

SQL Developer/Data Analyst

Responsibilities:

• Creating SQL Stored Procedures and User-Defined Functions using T-SQL for financial data fragments in Documents for Stakeholders.
• Developing parameterized reports through SSRS with SQL queries and stored procedures for easier access by users.
• Analyzing the data and performing ETL in setting up SSIS packages for data integration.
• Creating the databases and tables as well as verifying data integrity via analysis.

Confidential, Lawrenceville, GA

Data Analyst/SQL Developer

Responsibilities:

• Writing complex queries, stored procedures and functions.
• Capturing data and building reports for clients in SSRS and creating stored procedures using T-SQL daily.
• Comfortably interacting with the clients via a phone and email for detailed information of their data ensuring their data needs are met and training the clients on how to use our data scrubbing application.
• Responsible for the creation of databases with Primary, Foreign keys and Unique constraints for new clients.
• Researching and discovering data-related issues, providing reports to the client as well as resolving the issues.
• Importing the clients’ data onto our SQL production database subsequent to the data analysis.
• Migrating database objects between various environments including staging and production.

Confidential, Atlanta, GA

Data Analyst, Developer

Responsibilities:

• Extracting data from SQL and providing data analysis in the form of graphs, pie charts, bar charts for Assets and transactions.
• Responsible for monthly financial and accrual reports for the VP of finance in SSRS.
• Building SSIS packages for various tasks including data integration for Databases, Access, text/csv and Excel files to SQL. Setting data key constraints, testing for duplicates.
• Writing stored procedures in SQL.
• Created an Analysis tool using Excel Power Pivot loading millions of rows of data to Excel from SQL.

Confidential, Roswell, GA

SQL Developer

Responsibilities:

• Developing SSIS packages from scratch to be used in job steps for automated data jobs in job activity monitor.
• Writing T-SQL code for stored procedures, managing tasks and meeting deadlines in response to ad-hoc requests.
• Working with billing databases such as invoices, purchase orders.
• Migrating data to/from staging table in SQL from multiple data sources including Oracle, Access, Excel, CSV flat files and other SQL servers. Experience in ETL processing using SSIS for design, testing and deployment of packages
• Creating and modifying reports in SSRS by gathering criteria and requirements from accounting managers.
• Performing light DBA administrator duties in trouble shooting and solving server issues.
• Creating stored procedures that are used in SSIS packages and SSRS reports.
• Scheduling jobs that generate automated data loading and daily reports for accounting databases.
• Testing existing SSIS packages and SSRS reports for database upgrade.

Confidential, Atlanta, GA

Data Analyst, Jr. SQL Developer

Responsibilities:

• Scripting in T-SQL from tables in the student database, developing test procedure cases.
• Convert Access databases to SQL design tables, import data and developing constraints and indexes ensuring data integrity.
• Transporting data between SQL servers using SSIS.
• Generating reports using SSRS in Visual Studio.
• Use Database Engine Tuning Advisor and monitoring tools for database analysis.
• Make recommendations based on data trends and analysis.
• Exposure to database administration principles and practices including security, permissions and alerts.

Confidential, Norcross, GA

Data Analyst

Responsibilities:

• Extract, manipulate and analyze data and create reports using T-SQL.
• Liaison with IT on Business/Accounting needs.
• Used Excel in setting up pivot tables to create various reports using a set of data from an SQL query.

Confidential, Atlanta, GA

Database coordinator, Accounting Assistant

Responsibilities:

• Designed database in Access from data in Excel linking them so any changes in Excel are automatically reflected when the linked table is viewed or queried in Access.
• Created data validation rules for entering data and importing data from Excel spreadsheets.
• Set up Excel tables of data to organize and maintain data for vendors, products, clients, members and staff.