Nasir Gondal                                                                                                  

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.

EDUCATION

·         Master of Business Administration (MBA) from Newport University, Salt Lake City, Utah.

·         Bachelors of Commerce.

PROFESSIONAL EXPERIENCE

Bank of America                                                                                                                        09/16 – 03/18

Business System Analyst/Data Analyst (Contract)

·         Worked on BAC-Mortgage Hub (BMH) 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 (Deficiency Tracking System DTS) 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).

·         Created Agile User stories to add to product backlog. Worked with Scrum Master and participated in daily scrum meetings/sprint review and sprint retrospective meetings.

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

Riverbed Xirrus Inc.                                                                                                                        1/14- 8/16

Business Data Analyst/ SQL Developer (Contract)

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

Bank of America                                                                                                                          08/13 – 1/14

Business Data Analyst/Quality Assurance Tester (Contract)

·         Worked on Lynx data ware house/Reporting Repository for Bank of America 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.

Advantage Sales & Marketing                                                                                                    01/13 – 08/13

Business Intelligence BI Analyst (Contract)

·         Supported Advantage 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.

Bank of America                                                                                                                        03/10 – 10/12

BI System Data Analyst (Contract)

Worked on projects for Bank of America supporting Operational Data Store /Data Warehouse/Reporting Repository Phoenix-ODS, Non GSE-Portfolio Department and Post Closing department.

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

Sony Corporation                                                                                                                      11/09 – 01/10

Business Analyst (Contract)

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

Verizon Communication Inc.                                                                                                     02/08 – 08/09

BI Analyst/Administrator Asset Management (Data and Voice) (Contract)

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

General Electric Co. (GE)                                                                                                           11/01 – 12/07

Business Analyst

·         Responsible for identifying, documenting and improving business process activities to meet the goals of the business.

·         Analyzed complex business problems and proposed solutions using process and system automation

·         Created MIS reports for senior management (VP Operations). Over a five year period, managed the systems and processes necessary for data mining and MIS report generation as the business realized rapid growth from $30 Million per month to $3 Billion per month of sales.

·         Analyzed Data in MS Excel and MS Access. Using custom reports, forms, queries, functions, formulas, pivot table, charts, vlookup, text functions, complex statistical analysis 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.

Countrywide Home Loans                                                                                                          04/01 - 10/01

Collateral Analyst (Contract)

·         Responsible for reviewing collateral files to ensure accuracy, locate deficiencies and take remedial actions.

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

      Crystal Reports                                                                  

·         ASP.Net     MVC                                                    

·         HP Quality Center

·         Team Foundation Server (TFS)

·         SharePoint Server

·         EDI 850 & EDI 810

·         Tableau software

·         Expandable ERP System