OBJECTIVE

• I am looking for Business Analyst / SQL Developer/QA role in Los Angeles, CA or nearby cities only.

SUMMARY

• Ten years of diverse and progressive experience in the finance, communication and public sectors.
• In depth experience in mortgage industry, portfolio management, asset management, administration, accounting, insurance marketing and software.
• Strengths include data analysis, code development, streamline processes and develop ideas.
• Able to increase productivity and work well independently and as part of a team in a fast pace deadline driven environment.
• Highly motivated individual, recognized for providing outstanding results as well as unique and creative perspectives on timely problem resolution.
• Expert leadership, communication and staff development skills.

TECHNICAL SKILLS

• Microsoft Office (Access, Excel, Outlook, PowerPoint, Visio, Word)
• Excel VBA
• Access VBA
• SQL Server 2008,2012,2014,2016 (SSMS)
• T - SQL (Structured Query Language)/ Oracle
• SQL Server Stored Procedures
• SQL Server Reporting Services(SSRS Reports)
• SQL Server Integration Services (SSIS ETL)
• Oracle 11g RDBMS
• Crystal Reports
• ASP.Net
• C# Application
• Expandable ERP System
• Maximo (BAC)
• Nexus (BAC)
• HP Quality Center (BAC)
• Team Foundation Server (TFS)
• SharePoint Server
• Tera Data RDBMS
• Discovery (BAC)
• EDI 850 & EDI 810
• VB.Net-Application

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Working on hybrid data platform with applied logic in C# & C++ applications and sql server/oracle/teradata tables.
• Created sql scripts utilizing windows functions /common table expression's (CTE's)/ sub - queries, sql server functions based on user requirements contained in business change document (BCD)
• Created/Altered and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on environments like dev server data warehouse and reporting using sql server 2012 / oracle 11g/Teradata.
• Designed Data Flow Diagrams (DFD), Entity Relationship Diagrams (ERD), Use Cases, UML & Data Model.
• Created UAT reports and utilized HP Quality Center (HP-QC) and Team Foundation Server (TFS) visual studio 2012 for test management, defects management, and reporting.

Confidential

Business Analyst/ SQL Developer

Responsibilities:

• Created/Altered and tuned T-SQL stored procedures, complex queries, views, tables, and functions in sql server 2012 backbone of Expandable ERP System.
• Worked on EDI 850 and 810 back-end processes.
• Automation of Excel Spreadsheets using VBA with MS sql server data and created Crystal Reports.
• Excellent writing skills in preparing business requirements documents (BRDs), High Level Documents (HLD) and Low Level Documents (LLD) along with Requirement Traceability Matrix.
• Designed Data Flow Diagrams (DFD), Entity Relationship Diagrams (ERD), Use Cases, UML & Data Model.

Confidential

Business Analyst/Quality Assurance Tester

Responsibilities:

• Worked on Lynx data ware house for Confidential supporting secondary marketing department.
• Develop QA test scripts based on end-user requirements created in business use case and pseudo code.
• Created sql scripts utilizing windows functions /common table expression's (CTE's)/ sub-queries, sql server functions based on user requirements contained in business change document (BCD) to independently verify that builds provided by Dev team are as per program change requirement (PCR).
• Created/Altered and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on environments like QA server data warehouse and reporting using sql server 2012 and oracle 11g.
• Created test plans and UAT reports and utilized HP Quality Center (HP-QC) and Team Foundation Server (TFS) visual studio 2012 for test management, defects management, and reporting.

Confidential

Business Intelligence BI Analyst

Responsibilities:

• Supported Confidential & Marketing data ware house.
• Ad-hoc queries on ODS as well as on data marts created on top of ODS.
• Created stored procedures as well as analyzed complex logic in stored procedures to create extended properties for tables as well as column level.
• Analyzed report server database usage by running XML queries against it.
• Created and deployed SSRS reports on data marts using cascading parameters.
• Ran and modified SSIS packages for ETL purposes.

Confidential

BI Business Analyst/System Analyst

Responsibilities:

• Worked closely with project stakeholders, SME and staff to understand the requirements and specifications for new applications along with re-engineering the existing applications.
• Excellent writing skills in preparing business requirements documents (BRDs), High Level Documents (HLD) and Low Level Documents (LLD) along with Requirement Traceability Matrix.
• Designed Data Flow Diagrams (DFD), Entity Relationship Diagrams (ERD), Use Cases, UML & Data Model.
• Use BAC, TFS, HP Quality Center (SIT Quality Assurance testing) to support projects.
• Worked with QA team and testers on System Integration Testing (SIT) test plans. Administered code defects using HP Quality Center.
• Provide technical and procedural support for User Acceptance Testing (UAT).
• Ran daily, weekly and monthly reports in Excel and Access using queries and stored procedures from SQL Server tables (SQL Server 2008 and Oracle 11g).
• Use SQL Server Integration Services SSIS to create packages to Extract, transform, and load data (ETL) into SQL Server.
• Created and deployed SSRS reports on data marts using cascading parameters.
• Converted Access 2007 databases into SQL Server stored procedures.
• Created Excel Spreadsheets Pivot Tables based on SQL Server Stored Procedures.
• Created SQL Server Stored Procedures with complex query logic based on case statements and using input parameters and control of flow statements such as BEGIN...END/ IF...ELSE.
• Automated Excel Spreadsheets using VBA.

Confidential

Business Analyst

Responsibilities:

• Worked on a short project to develop tools to improve functions of Invoice Department.
• Automated Excel Spreadsheets with complex calculations using VBA.
• Invoice Department used SQL Server 2000 and 2005 with forms and reports designed in Access.

Confidential

BI Analyst/Administrator Asset Management (Data and Voice)

Responsibilities:

• Maintained data network and voice equipment inventory for the company’s client sites (hospitals and medical office buildings), nationwide.
• Standardized equipment information for database population.
• Maintained asset data base inventory and performed periodic reconciliation and analysis.
• Insured accuracy of asset inventory database with customer database.
• Download from System Manager (ASP.Net) Inventory tables and match with different sources.
• Ran queries and downloads from MS SQL Server 2005 using T-SQL.
• Created and deployed SSRS reports.
• Analyzed Data in MS Excel and MS Access using structured query language (SQL), custom queries, reports, forms, text functions, formulas, overlays, pivot table, charts, lookup, scenarios, consolidation, macros, Excel VBA programming and Excel statistical analysis.
• Used Crystal Reports.
• Weekly and Monthly SSRS reports for SLA Monitoring and Ticketing reporting based on High, Medium and low priority tickets.
• PowerPoint presentations and graphs based on Excel/Access data along with process flowchart using Visio.

Confidential

Analyst for Loan Funding Dept

Responsibilities:

• Created MIS reports for senior management (VP Operations).
• Analyzed Data in MS Excel and MS Access. Using custom reports, forms, queries, functions, formulas, pivot table, charts, vlookup, text functions in excel, overlay, scenarios, consolidation, macros, solver and Excel VBA.
• Created Power Point presentations and graphs based on Excel /Access data along with process flowchart using Visio.
• Developed efficient processes and automated systems to cut down report generation time from 36 hours to 2 hours.
• This allowed senior management of the business unit to understand the daily business in real time and to adjust resources, and do effective follow up accordingly.