SUMMARY:

• A dependable Data Analyst with skill sets for identifying business needs and solutions.
• Proficient with SQL, Excel and data sets manipulations and tools with focus on client satisfaction and profitability.
• Am passionate about acquiring newer skill sets and tools for challenges within the dynamic IT/Tech industry without compromising on quality, with a resolve to exhaust my participation in projects and deliver on stakeholder needs.
• Data Analysis, Data Validations, Auditing & Reporting.
• Business Analysis, Quality Assurance & Testing.
• Business Requirements Elicitation, Gathering, Translation & Documentation.
• Data Representation & Presentation.
• Writing User Stories, Test Cases, Use Cases and Defect/Bug Tracking and Logging.

KEY SKILLS:

• Strong Analytics
• Critical Thinker
• Detail Oriented
• Agile Compliant
• Multitasker
• Excellent Communication
• Modeling techniques and methods
• Team Player
• Fast Learner
• Problem Solver

TECHNICAL SKILLS:

MS Office: Excel, Word, Outlook, PowerPoint, etc.), MS Dynamics AX, Pivot Tables, Visual Studio 2015, SAP, Tableau and PowerBI for visualization, etc.

Web Technologies: HTML, XML, etc.

Programming Languages: Visual Basic, etc.

Databases: MSSQL 2006, 2008, 2014…., MySQL

Operating Systems: Windows XP…10. Data Mining, ETL, Modelling and Validations.

WORK EXPERIENCE:

Confidential, HOUSTON, TX

Data Specialist Analyst

Responsibilities:

• Designing, creating and maintaining database objects such as data files, tables, clusters, indexes, views, sequences, packages, procedures etc.
• Responsible for designing, developing, and optimizing company database.
• Constantly providing support for test and company production database environments to include problem identification, reporting, tracking, analysis, and resolution.
• Constantly monitoring the SQL database performance and space utilization.
• Establishing, maintaining, and monitoring database backups, Database security, user - role assignments, and individual logins per company security policies and procedures.
• Ensuring all database servers are backed up in a way that meets the business's Recovery Point Objectives.
• Writing queries, maintaining, and validating datasets and data integrity that support various projects.
• Creating frameworks, snapshot reports, updates, and visual reports on major milestones and timelines on projects.
• Ensuring data changes, updates and exceptions are documented throughout projects’ life cycle.
• Communicating project updates and reporting to team members at all levels continuously.

Confidential, HOUSTON, TX

Merchandising Systems Data Analyst

Responsibilities:

• Prepared source data using MS Dynamics AX to compile, sort and validate files for upload into database.
• Established entry priorities before data is uploaded into the systems database.
• Processed source documents by reviewing datasets for deficiencies and or discrepancies.
• Maintained the Stock Keeping Unit data requirements by following guidelines, techniques and procedures.
• Verified and validated the uploaded SKU data by reviewing, updating or reentering data as approved.
• Maintained record of completed work for each event and routing/filing source documents after data entry.
• Retrieved data from databases for use as appropriate and or designated.
• Conducted data audit analysis on uploaded data to identify inaccuracies and or inconsistencies, daily.
• Investigated and responded to inquiries concerning SKU data as requested or project-related.
• Provided feedback to reduce errors and improved system processes and performance.
• Delivered status of SKU and updated costs for internal and field operations.
• Maintained cross reference files essential for inventory import, reporting, and market conversions.
• Researched invoice cost discrepancies for Accounts Payable and proffering solutions to resolve same.
• Provided SKU data reports to senior management and internal departments as needed.

Confidential, HOUSTON, TX

Junior Data/Business Analyst

Responsibilities:

• Assisted with creating the BRD through requirement elicitation
• Translated requirement data to user stories, use case scenarios and process flows.
• Ensured that wireframes created by design team for the application captured all requirement for good UI.
• Engaged independent and group stakeholders/users to gather requirements and documented meeting minutes.
• Assisted with data analysis, cleaning, validation and readiness for developers use.
• Assisted with UAT on components and whole application for functional and nonfunctional attributes.
• Tested requirements using various browsers, desktop and online to ensure all functionality meets requirements.
• Helped team prioritize issues/bugs found during testing using the Version One bug tracking system.
• Created new user accounts in application for new customers to ensure application functionality
• Responded to client and users calls and emails about website questions

UAT Specialist

Confidential

Responsibilities:

• Performed UAT test, wrote Test Plans, Users Stories, Acceptance Criteria, Test Scenarios and Test Cases from BRDs.
• Created user acceptance testing, systems testing, unit testing, regression testing, stress testing.
• Under supervision and direction, I provided developers with detailed defect reports for corrections.
• Understudied the Internal Technical teams (PM, BA and QA/Testers) on delivery of quality software solutions
• Tracked, identified, recorded and reported defects as identified through the Version One bug tracking system.
• Ensured proper documentation and authentication with appropriate sign-offs throughout the SDLC process.
• Performed tests like component, integration, system, regression, user acceptance, black and white box testing.
• Manually tested components of applications to ensure its purpose and functionality meet stakeholders needs.
• Recorded and migrated scripts on Firefox, Internet Explorer and Chrome browsers for Automation Test runs.
• Performed Regression testing on already fixed defects, to avoid re occurrence prior to deployment.
• Assisted BAs in creating the BRDs after elicitation from Product Owners and SMEs.

Confidential, HOUSTON, TX

Administrative Assistant

Responsibilities:

• Provided staff analysis support regarding hiring and separation in HR and the Budget depts.
• Managed the Form 5, Organizational Management and Justification form for new hire positions.
• Updated weekly report regarding hiring, promotions and separations.
• Worked with total confidentiality in discharge of my duties.
• Monitored department budget/internal funding and prepared administrative financial reports.
• Updated reports to track budgetary expenses and spending.