A. YEMANE

***** ***** **** ****, *** ***, Rockville, MD 20853

Phone 240-***-**** • Email – ac617s@r.postjobfree.com

Business analyst with over four years of experience. Analyzed business operations and support business solution software. Possess B.S in information management system and have good understanding of business and information technology. Familiar with project management, database management, feasibility study, risk management, business planning, decision making, security, problem solving, documentation, consulting, quality testing, performance management, business planning, IT strategy and customer service.

SUMMARY OF EXPERIENCE AND SKILL

Analyzed, coordinated with user and team

Performed analysis and meet with developer to determine most effective solution.

Improve accuracy and efficiency of business process

Liaison between business users and technical team

Documented business, functional and technical requirements

Collaborated with technical team to meet cost and time estimate

Interviewed clients and client services for system enhancement requirement

Wrote SQL query to analyze, research test, validate, trouble shoot and create report

Created Visio/UML work flow diagram and wrote requirement procedures

Participated in agile sprint meeting, backlog grooming and scrum meeting

Performed analysis to determine for best automated solution

Analyzed and documented data flows of internal and external data source

Facilitated meetings with client to document requirements and explore solutions

WORK EXPERIENCE

Johns Hopkins, Colombia, MD

Business Analyst March 2017 – present

Gathered software requirements and translate into tangible deliverables

Wrote software requirements and maintain business requirements and align them with technical and functional requirements

Facilitate meeting with client to gather requirements and explore solutions

Conduct functional, regression, and user acceptance testing(UAT)

Analyzed input into developing and modifying system to meet clients need and business specification to support this modification.

Identify errors in the data and ensure accurate business requirement

Managed on SQL quires complex stored procedures (parametric, none parametric), DDL, MDL Quires (update, truncate, delete, create), creating temp tables and CTE, joins (inner, left, right, outer), performance tuning, troubleshooting

Experienced in Data Warehouse building on Multi-Dimensional Model using normalization principles to change the relational database design into Fact tables and Dimension tables based on Snowflakes and Star schema integrity.

Proficient in Data Warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture).

Experienced with JIRA, HP ALM

Experienced with agile development methodology

Experienced with full SDLC and EPLC process

Accenture, Arlington, VA

Business Analyst October 2014 – February 2016

Interview client for system enhancement requirement

Perform analysis and create Visio workflow diagram

Wrote statement of requirements and review with client

Analyzed and coordinate with vendor, client and team

Managed in agile sprint and planning

Wrote SQL to analyze research test, validate data

Documented functional, technical and business requirements

Collaborate with technical and development team to determine most effective solution

Deliver high performance cost effective solution

Identified existing business process weakness and develop solution

Troubleshoot process gaps and conducted process implementations

Identified system gaps and assessing the impact of proposed changes to existing automated system

Celerity Systems Inc. MD

Database Developer June 2013 – September 2014

Extensively worked on coding SQL queries, complex stored procedures (parametric, non-parametric), DDL and DML queries (update, truncate, delete, create), creating temp tables and CTE, joins (inner, left, right, outer), performance tuning, troubleshooting

Experienced on database design, relational integrity constraints, OLAP (Analytical processing), OLTP (transactional Processing), and normalizations (first to forth level)

Experienced on SSIS Package building, high level design of ETL packages by integrating data from heterogeneous sources (OLE DB, Access, Excel, flat file, Oracle, XML, Raw file) to different destinations.

Proficient experience on the development, implementation, administration and support of ETL processes for Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008R2/2012.

Experienced in Data Warehouse building on Multi-Dimensional Model using Normalization principles to change the relational database design into Fact tables and Dimension tables based on Snowflakes and Star schema integrity.

Proficient in Data Warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture).

Proficient in tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance, Backups and recovery, Installing and configuring SQL Server and high availability and disaster recovery solutions like Mirroring, Log Shipping, Replication and Failover Cluster.

Highly motivated, dedicated, well organized, interpersonal communicational skills and goal oriented

ADDITIONAL SKILL

Programming language: C, JAVA, PHP, HTML, CSS

Microsoft: Visio, Project, Word, Excel, Access, PowerPoint

Database: My SQL, SQL, SQL server 2005, Microsoft access

Certification: A+

Familiar with agile development methodology

EDUCATION

University of Maryland University College

BS. in Information Management System May 2018

Montgomery College, Takoma Park, MD

A.A in General Studies May 2015

Contact this candidate