Ahsan Bashir

Business Systems/Data Analyst

**** ****** ****** *****

Springfield, VA 22153

United States

Primary Phone: 571-***-****

Email: adua9m@r.postjobfree.com

Work Authorization: US Citizen

Security Clearance: US Public Trust

Qualifications

Completed Education:

Bachelors of Science in Industrial and Systems Engineering/Minor in Business

Virginia Tech, Blacksburg VA USA

In Progress Education:

Masters in Data Analytics

Boston University, MA USA (2022-2024)

Certifications:

Oracle Certified Associate (OCA) - September 2013

Exams:

1Z0-051 Oracle Database 11g: SQL Fundamentals I

1Z0-052 Oracle Database 11g: Administration I

OBIEE Certified Implementation Specialist - October 2017

Profile

Ahsan is an experienced business system analyst who started his professional career in the Public Sector working as a Consulting System Analyst for Accenture. While working as a Business System Analyst for most part of his career, Ahsan has had exposure to diverse technical and functional capabilities such as Oracle BI, Oracle DB, Salesforce, Informatica, SAP ABAP Development etc., during his engagement on multiple Federal Clients'. Ahsan has diverse set of skills that enabled him to design and optimize business processes across multiple industries. More recently, Ahsan has worked as a Business Systems Analyst for a federal client dealing in conventional financial securities as well as crypto currency.

Selected project experience

Ascella Tech: Business Systems Analyst

Client: Securities and Exchange Commission (SEC)

April 2017 – November 2022

Ascella stood up a proprietary system called NEAT to allow SEC examiners to conduct compliance exams’ analysis. Worked as a Business System Analyst to continuously gather requirements from the stakeholders to create the first version of the software and then consistent upgrades to the analysis features. Collaborated with Dev and QA team to translate functional requirements into technical requirements, test cases and use case mapping. Supported and executed close partnerships with stakeholders to ensure seamless implementation and integration of the enhanced features. Provided support on all the system components such as database, cloud integration, report generator. Facilitated all the scrum events such as sprint planning, daily scrum, sprint review and sprint retrospective. Created testing artifacts for pre and post testing activities and took active part in testing.

Also worked as a data analyst where I was also the user of the NEAT system in order to understand and better facilitate the types of analysis being conducted. Regularly staged trade blotters with hundreds of thousands financial transactions’ and conducted analysis to generate conclusive reports to aid SEC examiners in their daily mission.

Created payroll dashboards in OBIEE and migrated Hyperion reports to OBIEE as part of support for Office of Financial Management.

Started the initiative of verifying crypto currency assets (on chain and off chain) by monitoring information held in hardware and software wallets. Provided continuous support in technical tasks such as creating SQL scripts, excel macros to automate reports consolidation etc. Managed a team of peers in delivering continuous exam support to client.

AOL: Systems Analyst, CTC Contractor

July 2015 – October 2016

Ahsan has worked as a Technical Systems Analyst to ensure OTC contracts’ data migration between different systems. Primarily working on EDX interface, Ahsan has developed expertise in understanding data residing in the EDX Oracle staging tables and have also gained familiarity with that data’s representation in MPS (upstream) and SAP IS Media (Downstream) systems. Ahsan mostly worked with Oracle RDBMS, making API calls via REST client, SAP IS billing system, Zendesk and Service Now ticket management systems and JIRA.

Responsibilities include:

Review failures for each country (8 across Europe and America along with Japan) on daily basis and open Zendesk, Service Now tickets as required and follow up with resolutions.

Interacted regularly with the technical teams across different business units to ensure consistent delivery approach for the invoice/contract generations.

Run biweekly queries to identify SAP PI (posting job) issues.

Provide production support research, analysis and resolution for the assigned tickets.

Create/Update SQL scripts for any assigned project improvement tasks e.g. Reconciliation between MPS and EDX

Run MPS to EDX Reconciliation query every week day and conduct analysis and resolve any contracts not found in either systems.

Production Support documentation detailing process to identify, validate and resolve different types of Production Support Failures

Fannie Mae: Business Systems Analyst, Accenture Contractor

January 2015 – July 2015

As a key goal of the Federal Housing Finance Agency (FHFA) Strategic Plan for Enterprise Conservatorships, FHFA is developing a new securitization infrastructure to align and improve the business practices of Fannie Mae and Freddie Mac. This new securitization platform is called Common Securitization Platform (CSP).

As part of the Enterprise Data Infrastructure (EDI) System Analysis group, ahsan conducted thorough system analysis between different source systems that were feeding data to the target (CSP). Accenture built the Interface Data Store (IDS) to store all the data coming from different sources before vending out the required information to CSP. Responsibilities included:

Work as a System analyst within an Agile scrum team to create Source to Target Mapping (STTM) deliverable for consumption by developers and testers.

Review, understand and validate logical and physical data models using ER studio.

Work on multiple interfaces for System Analyst activities to deliver Loan and Pool level data.

Conduct impact analysis on downstream source systems/applications due to change of source system data transformations.

Using IBM Rational DOORS, ensured optimized requirements management, communication, collaboration and verification throughout the organization.

Lead the System Analyst resources on different scrum teams for collaborative delivery.

Delivered Solution Specification and Interface Control Documents for different interfaces.

Took Informatica Development training and assisted lead Informatica Developers in creating the mappings, transformations and workflows.

Created Landing tables to dump source data before storing them in the base tables in the oracle database.

Consistently demonstrated sprint work to internal and external stakeholders.

Conducted backlog grooming session and kept the Business and Tech STTM in sync.

Assisted System Test teams with executing UAT and creation of scripts.

HSBC Bank: Technical System Analyst

October 2013 - October 2014

HSBC had implemented Detica's Norkom (AML Application) Case Management solution to support its Anti Money Laundering and Fraud Alerts.

Ahsan worked as a technical team lead for implementing that solution. Worked with offshore technical team and onshore functional/technical stakeholders to define the business requirements and the eventual technical design blueprint. Engaged other Norkom (solution) SMEs as well as product support team (from the vendor) to customize the solution to fit the enterprise strategic objectives. Adhered to FINCEN regulatory parameters to customize the solution for federal reporting requirements. Also configured the Norkom solution hands on to present as a Demo application to internal and external stakeholders. Mentored junior technical staff by transferring the development knowledge for in house development. Worked consistently with the vendor technical team to estimate the effort required and the ultimate costing of their consulting services. Worked with Data Modellers to define the schemas based on the enterprise's domain and organizational units.

BAE Systems Detica Norkom: Technical System Analyst

October 2012 - September 2013

Detica NetReveal implemented Case Management solution to create custom screens and workflows in order to upgrade the existing 5.7 system to 6.5 version using just the Framework as well as EIM vertical (for reference only).

Ahsan was responsible for implementing custom screens and workflows for the Experian Upgrade project. Using existing screens and workflows as a reference to build new screens and workflows from scratch, to meet client specific customizations. He was also responsible to create and deliver the final Packaged Software Build to the QA as well as to the client. Responsibilities included:

Scoping the Solutions Document to describe the changes to be implemented between the older legacy customizations and the new solution being deployed.

Working closely with the client to gather requirements for the service and to determine integration points with the existing service. Created Requirements Traceability Matrix documentation.

Conducted Gap analysis to identify the steps needed to get to the desired solution state.

Creating complex queries involving views, tables while keeping the performance impacts in consideration.

Carrying out all screen and workflow implementations from the solution’s design documentation to ensure client requirements and customizations are met according to the requirements.

Providing technical expertise in the related areas to the customer during client sessions.

Developing all technical changes that deviated from the standard product

Conducting Unit Tests on all the Developed Objects to validate the custom changes implemented during the development.

Working with the engineering team for the product specific issues and remedies.

Working with the QA team to timely resolve all the issues in order to ensure a quality solution delivery to the client.

Creating and delivering fully Functional Build after Unit and Smoke testing. Implementing the code to the QA as well as client’s environment using proper methods and communication and regularly checking in code in SVN to ensure Software Version Control.

In addition to building upon the information in an existing Solution Document for the previous version, Ahsan utilized his Technical Writing and Image Editing Skills to create screenshots of the 16 screens (Total 64 screens including the sub-screens) as they would look like in the 6.5 environment, without having any related example to look at. Being on his first project with Detica, Ahsan was able to start contributing right away without much product specific training under his belt, and proved to be a quick learner as he went along. Effectively participated in client meetings and presented and addressed client’s questions and DeticaNetReveal (DNR) Solution’s aspects in clear and concise manner. Ensured regular Code and Configuration Check ins using Apache Subversion (SVN) software versioning and revision control system. Assisted senior technical lead in bringing up and maintaining the application servers (weblogic, jboss).Created custom installation guides to deploy all the new functionality and assisted Technical Lead for installation during the System Integration phase. All the Code was developed on time with no issues and Client was very happy with the level of service provided through all phases of the project.

Accenture: System Analyst

Client: United States Department of Agriculture (USDA)

March 2012 – September 2012

Ahsan was working as a functional consultant for SAP Advanced Business Application Programming (ABAP) Development.

While on the project, Ahsan:

Worked as part of Application Development team to plan,design, and test RICEFW objects and enhancements for a mission-critical SAP Financial Management System.

Monitored and tracked development team activities and raised issues as appropriate.

Leveraged object oriented and ABAP programming best practices to set the technical basis of the solution.

Created technical designs deliverables, unit test plans and captured screenshots to document testing details.

Peer reviewed technical designs for quality (consolidation, formatting and proof reading) and provided technical and functional expertise.

Understood and strictly utilized development standards and naming conventions.

Managed a team of 5 sub-contractors for the timely delivery of the Technical Design Deliverables.

Acted as the Application Development team’s communication lead for the internal and external project wide communications.

Demonstrated strong Analytical and organizational skills to for day to day issues and tasks.

Components Used: SAP ABAP, Microsoft Office, Team Tracker.

Accenture: System/Data Analyst

Client: United States Department of Education

August 2010 – February 2012

Ahsan was working as an Interface Operations Reporting Analyst for the Financial Management System (FMS) that interacted with the main Common Originations and Disbursements(COD) system for Federal Student lending. While on the project, Ahsan:

Conducted analysis on daily input data stream from FMS to make sure all the data has been correctly applied to the COD system and there is no discrepancy between FMS and COD.

Resolved all the related production issues in a timely manner as described in the Service Level Agreement (SLA)

Completed assigned deliverables (Standard Operating Procedure documents for the interface processing)

Delivered daily deliverables to the client and employer’s upper management.

Automated the manual process of generating the System Balancing Reports’ email to the client (twice a day) by creating the complex SQL queries.

Generated ad-hoc reports as per client’s requirement for issue identification and analysis.

Attended daily client conference call meeting and presented the status of rejects and any outstanding issues.

Trained new joiners on FMS interface processing and how to research different issues based on the Standard Operating Procedures.

Participated in project wide functional and technical training.

Components Used: SQL, DB2,Team Tracker, Microsoft Office.

Accenture: System/Data Analyst

Client: United States Department of Education

September 2009 – July 2010

Ahsan was working as a Data Integrity Analyst for the Production Operations team and ensured data and referential integrity between IBM Mainframe and IBM DB2 database’s tables containing customer’s data. While on the project, Ahsan:

Assisted in creating Data Integrity SQL scans to be run on daily and weekly basis in order to identify any customers appearing twice in the COD system or are linked to multiple accounts.

Supported Data Integrity related tasks in the two annual Releases and monthly Service Packs which included researching the assigned incident tickets and creating the Post Implementation Verification (PIV) plan to execute on the implementation date to ensure effective client service delivery.

Use VB.net to import, parse and upload multiple text files to the data warehouse.

Components Used: VB.NET, SQL, Mainframe, DB2, Microsoft Office, Team Tracker.

Accenture: Testing Analyst

Client: United States Department of Agriculture (USDA)

May 2009 – September 2009

Ahsan was working as an Application Tester. While on the project, Ahsan:

Tested functionality of different forms of the Client’s application for the system test environment. Logged any issues in the Rational ClearQuest incident management tool and followed through with its resolution.

Communicated any issues to the developers and provided input to correct the code.

Components Used: Rational ClearQuest, Microsoft Office.

Accenture: Technical System Analyst

Client: Office of Personnel Management

August 2008 – April 2009

Ahsan was working as a junior Oracle DBA Analyst for Oracle 10g database implementation. While on the project, Ahsan:

Created high quality Technical design deliverables.

Assisted Senior DBA personnel in creating new environments for Development and Testing from Production.

Performed day-to-day database administration and ensured integrity, Security and availability of the database

Components Used: Oracle 10g, Visio, UNIX, SQL, Microsoft Office.

Contact this candidate