Post Job Free
Sign in

Business Analyst Office Administrator

Location:
Bloomfield, CT
Posted:
April 25, 2024

Contact this candidate

Resume:

Syed J Bukhari

U.S. Citizen

860-***-****

Currently Residing in CT

DOB: 2/6/84

Skills

Software/Languages: Bloomberg, PAM for Securities, PORTIA, Advanced Microsoft Access, Advanced Excel, PowerPoint, Advanced Outlook, ArcGIS, VBS, VBA, SQL, Java, VB6, Matlab, SAS, Quality Center 11, ALM, QTP 9.2, VMware, Oracle Server, SQL Servers, SAP CRM, Cisco VPN, UFT 12, Load Runner 12, SOAP UI, MS Lync, SAP CRM, HP ALM, SharePoint, SalesForce.com, Silverlight

Operating Systems: Windows XP, Vista, OS IX, X

Experience

250 Farmington Ave LLC - Hartford, CT 8/2015- Current

Office Administrator

Redesign office administrative procedures to modernize functions, eliminate redundancy and expedite workflow

Launch an employee-of-the month award program to increase motivation among staff

Maintain contact with customers and agents

Deal with real estate agents nationwide

Resolve administrative problems by preparing reports and analyzing data

Maintain supply and inventory of office relates merchandise

Manage front desk area

Type documents and correspondence

Girl Scouts of America, Hartford, CT 6/2017-7/2017

Assisted with data entry of required data

Participated in team meets to ensure work gets done appropriately

Analyzing the data is correct with the migration into SalesForce

Cigna – Bloomfield, CT

2/2015 – 8/2015

Sr. Business Analyst

Assisted in preparation and conduct of Quality Assurance testing of new or modified applications/systems across multiple computing environments (e.g. host based, distributed systems, client server)

Participated in the analysis and development of new or revised QA procedures and processes.

Assisted in preparation and conduct of QA reviews and the development of test plans and test scripts.

Ensured the full application of all relevant QA protocols, processes and procedures

Provided help desk support to client and IT technical staff in resolving QA process and procedure questions and required documentation.

Documented, tracked and verified defects and fixes in assigned applications

Assigned to somewhat complex problems that can influence internal clients

Participated in the review of QA procedures and processes and the development of QA metrics for assessing the quality delivered application software or systems.

Assisted in design and implementation of QA software and systems and the development of effective testing plans through consultation with clients and IT technical staff.

Participated in the development of special testing requirements and procedures in review of new or modified QA software.

Required analysis of business requirements and design specifications to support test scenario and script development.

Responsible for supporting all aspects of business user acceptance testing of enhancements, new functionality and regulatory mandates for a Cigna medical benefit summary application throughout the entire System Development Life Cycle.

In addition to test execution, this role included documentation, communications, status reporting, defect reporting and coordination of testing activities across business testing teams and/or IT support teams as necessary.

Responsible for triaging any failed issues that may arise from the testers along with coordinating testing efforts in multiple locations, track progress and manage workload within or across teams.

Knowledge of Force.com/Cloud technology

Developing test scripts with strong Microsoft Excel skills incorporating the different scenarios to be covered for the overall UAT testing.

Expert knowledge of enterprise test tracing software for documentation, execution and defect management with the ability to utilize test system reporting functionality.

Ericsson – Bellevue, WA

4/2014 – 1/2015

Sr. Business Analyst – Contract

Collaborated with Developers, System Architects, Application owners to understand performance and scalability requirements for all applications and business work-flows.

Assisted in creating comprehensive test strategy for performance testing needs.

Designed and executed stress and load testing using Load Runner for critical business flows and applications.

API Testing

Video Asset testing

Regularly reviewed and interpreted QA results and findings with limited support from senior QA

Ensured the full application of all relevant QA protocols, processes and procedures

ALM/Quality Center experience

Used “out-of-the-box” ingenuity in applying analytical techniques and organizational skills to identifying and evaluating alternatives and to developing recommended approaches to resolving quality assurance issues and problems

Developed VB script function libraries and Descriptive programming by using Quick Test Professional.

Developed test scripts for Data driven testing using parameterization in QTP/UFT by using Excel sheet for test data and Database Queries based on the functionality.

Writing SQL Queries using Oracle, SQL Server and TOAD in validating data into Data Warehouse and other databases.

Recorded script in HP Unified Functional Testing 12.0 and demonstrated to client for automation demo - Automated the billing process for various scenarios within SAP CRM and WSIL

Created tracker to facilitate with activities updates and avoiding overlapping of work.

First Tennessee Bank – Memphis, TN

1/2010 – 12/2013

Business Analyst

Experienced with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

Ensured the full application of all relevant QA protocols, processes and procedures

Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.

Analyzed the requirements, design documents and wrote test cases to cover all the requirements. Met with the project development team and finalized` the test case documents.

Analyzed Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables.

Analysis of ETL Mappings based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables.

Used SAS to connect to QA databases to verify the integration of data.

Automated web services testing suites using Soap UI tool.

Created test suites for functional testing, integration testing, regression testing and sanity testing.

Wrote SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.

Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle.

ING IM – Hartford, CT

4/2008 – 12/2009

Sr. Accounting Analyst/Business Analyst – Contract

Ensured the timely receipt of securities market data, accounting, and operational data and the appropriate use of that data in the GAV valuation processes by strictly adhering to procedures. Strong focus was on availability of quality market prices.

Responsible for pricing Credit Default Swaps and Interest Rate Swaps along with nightly equity retail pricing.

Reflected strong, advanced knowledge of Excel, specifically Pivot Tables, V-lookup, and complex formulas.

Developed a price challenge log for any price challenges sent over to the vendors.

Completed steps on nightly check lists with attention to detail and diligence necessary to produce accurate and timely valuations

Provided financial data modeling for the various securities data analysis.

Provided Data analysis which required pointing out securities with differences in prices in different pricing tiers and then sorting it for the backend database admins to hardcode the corrected results.

Gathered and analyzed available information to resolve problems

Effectively communicated within and outside the unit to ensure accuracy and efficiency of operation, Financial statement packages emanated to the accounts bearers externally

Education

Central Connecticut State University

Bachelor of Applied Science – Finance Investments – 2014

CCSU – Coursework in DBMS_SQL, MSSQL 2016

SDLC Agile Training 2012



Contact this candidate