Business Analyst Resume
5.00/5 (Submit Your Rating)
Rockville, MD
TECHNICAL SKILLS:
- Business workflow automation with VBA (MS Office suite)
- Full stack E - commerce deployment (LAMP stack + Magento Enterprise, database migration)
- Server Administration (DNS, Nginx/Apache configuration), log analytics (Munin, Graylog, NewRelic), cloud data backup and integrity (duplicity, DAR, Duplicati, rsync)RDBMS: *SQL, SQLite - query writing for business reports, query profiling and optimization, database replication; DB Front-ends: HeidiSQL, MySQL Workbench
- Multi-format data mining (XML, JSON), web APIs; data cleaning & normalization, business intelligence via Tableau, Sisense BI, etc.
- Programming Languages: Python, SAS 9.x, VBA
- Operating Systems: Windows NT/XP/7/8/10, Windows Server 2008/2012, CentOS/RHEL 5.x, 6.x
- Wireframe, prototyping and project management tools: Axure, Lucidchart, Visio, Gliffy
- Team collaboration and issue tracking tools: JIRA, Confluence, Codebase, Oracle Projects Portfolio
- Office/Productivity Suites: Microsoft Excel/Word/PowerPoint/Publisher, LibreOffice
PROFESSIONAL EXPERIENCE:
Confidential, Rockville, MD
Business Analyst
- Transforming current and desired business logic into functional requirements and deliverables for software development projects
- Acting as subject matter expert on best Ecommerce backend design practices, database design
- Used Codebase HQ to manage project teams, resolve and delegate tickets, keep track of deliverables, led discussion with team SMEs and stakeholders to prevent scope creep and development delays
- Prototyping wireframes of new company web properties and features in existing ones; working with front - end developers to ensure consistent UX design patterns and best practices are being met
- Developing unit and feature tests for new applications and data management endpoints - ensuring proper operation and data integrity
- Using Confluence to organize and track issue logs, create detailed project documentation
- Led development in website search replacement - performed research, query optimization and data normalization to ensure relevant results for end users, designed indexing schema
- Project lead for integrating 3rd party marketplace order data into website backend automatically as well as order processing and shipment tracking using Amazon MWS and UPS APIs
- Project lead for Ecommerce industrial supply website based on stakeholder requirements and best competitor practices: UI prototyping (wireframe design), UML database modeling to accommodate modern backend features, SQL query design and scaling performance testing
- Automated monthly marketing outreach to 320,000 users based on their product preferences, increasing response rate and conversions by specific segment targeting by up to 70%
Confidential, Silver Spring, MD
Business Analyst
- Project lead for vendor billing and management system upgrade to handle increased order quantities
- Developed, documented and revised system design procedures, test procedures, and quality standards for software development
- Developed a data integrity and disaster recovery plan to ensure high availability and continuous operation by moving backups off-premises to multiple redundant cloud servers
- Managed IT infrastructure migration from a legacy VPS to several dedicated servers reducing IT costs and improving site speed and responsiveness
- Consulted management regarding budget planning and analysis; Reviewed operating budgets for trends that could affect business needs and operations
- Project manager for outsourced projects: end-to-end from requirements gathering to deployment, communication with team lead, ensuring delivery and preventing cost overruns.
- Ensured timely communication between management and engineering team by keeping a log on key meetings, deliverables, notes and changes to development specifications
- Implemented changes to workflow process to meet dynamic business and marketing requirements - deployed framework packages ahead of schedule to meet the promotional deadlines and requests from the sales team
- Developed an internal customer service training manual, conducted internal training sessions