PROFESSIONAL SUMMARY:

• Over twelve years of diverse and progressive experience in the finance, communication and public sectors.
• In depth experience in portfolio management, asset management, administration, accounting, insurance, mortgage, marketing and software.
• Strengths include system analysis, data analysis, code development, manual & automated testing, sql stored procedures, streamline processes to create efficiencies 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 SUMMARY:

• Microsoft Office (Access, Excel, Outlook, PowerPoint, Visio, Word)
• Excel VBA
• Access VBA
• SQL Server 2008,2012 (SSMS)
• T - SQL-PL SQL (Structured Query Language)
• SQL Server Stored Procedures
• SQL Server Reporting Services(SSRS Reports)
• SQL Server Integration Services (SSIS ETL)
• Oracle 11g/ Oracle 12c PL/SQL
• ASP.Net MVC
• HP Quality Center
• Team Foundation Server (TFS)
• SharePoint Server
• Python scripts for report generation.
• Tableau software
• Expandable ERP System

PROFESSIONAL EXPERIENCE:

Confidential

Data/Report Analyst

Responsibilities:

• Worked on a short contract for Confidential on excel reports based on data in oracle RDBMS.
• Created ad - hoc oracle PL/SQL queries for excel reports.

Confidential

System Analyst/Data Analyst

Responsibilities:

• Worked on a contract for Confidential as a System Analyst (ASP.NET MVC application with Web API Rest Services).
• Worked on Agile User stories to add to product backlog. Participate in daily scrum meetings/sprint review and sprint retrospective meetings. Work along with QA and Dev Team to deliver software in each sprint cycle. Created test scripts with QA team.
• Front-end is a .Net Application and back-end is cloud based Microsoft sql server. Logic is stored in sql server stored procedure and in ASP.Net front-end C# code.
• Created sql server ad-hoc queries/stored procedures/ reports using t-sql scripts & Excel pivot tables, vlookup, match,index functions.
• Used internal application compatible to Jira to track change requests and use another internal application compatible to HP Quality Center to track and log defects.

Confidential

Business System Analyst/Data Analyst

Responsibilities:

• Worked on hybrid data platform/reporting repository with applied logic in C# (.Net) application which also involved writing code in sql server t-sql /oracle pl sql /teradata sql.
• Worked on ASP.Net application currently interfacing with AS400 on back-end for switching over to sql server 2012 environment.
• Worked on traditional System design Life cycle (SDLC) Waterfall as well as Agile Scrum IT projects.
• Participated in SDLC Waterfall (Investigation, Analysis, Design, Development, Testing, Implementation & Maintenance) phases.
• Created business requirements documents (BRD) which contained user requirements. These requirements or specifications were created based on interviews, questionnaires and observations with business.
• Created program change request (PCR) in traditional Waterfall SDLC life cycle. Also created business change document (BCD).
• Worked on data mapping between entities and developed conceptual, logical and physical data models also created entity relationship diagrams (ERD).
• Worked on business process mapping.
• Used Visio & PowerPoint to create functional flow block diagrams and cross functional flowchart for data mapping from upstream systems to BMH. Also used for export of data from BMH to downstream systems.
• Used Visio & PowerPoint for Use Cases (UML), Data Flow Diagram (DFD), Business Process Diagram (BPD), Block/Swim Lane workflow diagram, functional decomposition chart, Decision table.
• Created traceability matrix/ source to target data mapping to show data flow and data transformations.
• Participated in JAD sessions & documented functional requirements.
• Worked on data dictionary to include new data objects and provided data descriptions on table/column level.
• Created/Altered and tuned stored procedures, complex queries, views, tables, and functions on environments like dev server data warehouse and reporting using sql server 2012 / oracle 11g/Teradata.
• Created sql scripts utilizing windows functions /common table expression's (CTE's)/ sub-queries, sql functions based on user requirements contained in BRD.
• 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.
• Automation of Excel Spreadsheets using VBA with sql server data.
• Used Python scripts for report generations.

Confidential

Business Data Analyst/ SQL Developer

Responsibilities:

• Created/Altered and tuned T-SQL(Transact-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 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 Data Analyst/Quality Assurance Tester

Responsibilities:

• Worked on data ware house/Reporting Repository 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 Sales & 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.
• Used Tableau to create data visualization and dashboards.
• Used OLAP cubes for reporting purposes.

Confidential

BI System Data Analyst

Responsibilities:

• Highly analytical and project-oriented BI Analyst offering experience supporting the local teams in the analysis of requirements and development of documents in the Software Development Lifecycle (SDLC).
• 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 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.
• Used OLAP cubes for reporting purposes.