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.
• Develop ETL/SSIS Imports and Exports that meet provided specifications. SSIS Control Flow, Data Task, SQL Tasks, Data Conversions. SSIS package data sources include Excel, csv files, text files, Access, Oracle.
• 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.
• Creation of databases, data modeling, primary keys and foreign keys for data integrity.
• Possessing a passion for data from the technical/programming side to working with the business people.
• 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, Marietta, GA

SQL Engineer

Responsibilities:

• In charge of MySQL queries and reports on daily basis for backend of Remediation Team interface application.
• Creating SQL views linked to relational databases and tables in RiskVision providing data for Remediation staff.
• Loading vulnerability scan results from Nessus, Trustwave/TrustKeeper and Penetration Testing into RiskVision.
• Data research and verification using VLOOKUP.

Confidential, Atlanta, GA

Consultant

Responsibilities:

• Designing relational databases, building tables for incoming data from Access and Excel tables and worksheets.
• Migrating data from MS Access/Excel to SQL via ETL/SISS packages built from scratch.
• Analyzing data, verifying and adding constraints (Primary and Foreign Keys, etc..).
• Creating views and stored procedures using T-SQL.
• Data Analysis, developing queries and building SQL stored procedures from scratch.
• Createdcustomizedbusiness reports using SSRS reporting including creation of data sets and SQL calculation formulas in queries.
• Working with multiple data sources and creating meaningful information in the form of reports and simple Dashboards. High level data analysis and creating metrics using Pivot Table
• Using Excel VLOOKUP to update thousands of rows of data from different sites.
• Building and using Pivot Tables and charts to provide metrics and updates to upper management.

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 via 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.

Confidential, Lawrenceville, GA

Data Analyst/SQL Developer

Responsibilities:

• 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 to our SQL staging & production database via SSIS subsequent to the data analysis.

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.
• Gathering requirements and documentation for the VP of finance SSRS reports.
• 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 T-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.
• 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 and generating reports using SSRS in Visual Studio.
• Use Database Engine Tuning Advisor and monitoring tools for database 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.