Senior Data Analyst/technical Design Lead Resume
SUMMARY
- Expert analyst and solution lead with more than 20 years of experience developing Web, client, and mobile solutions utilizing leadership, analytical, and development skills across various industries (financial, retail, manufacturing, government/DOD, insurance, and aerospace).
- I specialize in business, systems, and data analysis, project management, Agile development (Scrum Master/PO/BA), database development, and also have extensive experience in master data management and data quality efforts.
- I am frequently called upon to assess solutions for and/or rescue projects which get behind or need a push over a hurdle and excel in high pressure projects with aggressive deadlines.
TECHNICAL SKILLS
Agile: (Scrum - Scrum Master, Product Owner, BA; IEEE), Waterfall (RUP, Custom)
Data Profiling and Analysis: IBM InfoSphere, Data Discovery, Information Analyzer, Power BI
Database: SQL Server, DB2, IBM Cloudant, MySQL, Oracle, Access
Conversion, Stylesheet, Markup: XML, XSLT, XSL-FO, CSS, JSON
Diagramming, Visualization: LucidChart, Visio, Moqups, Tableau
Configuration Management: SharePoint, CVS, Visual Studio, Subversion
Programming: Cold Fusion, Java Script, Visual Basic
Standards: CMMI, ITIL
Project Management/Collaboration: MS Project, JIRA, Confluence, Visual Studio
PROFESSIONAL EXPERIENCE
Confidential
Senior Data Analyst/Technical Design Lead
Responsibilities:
- Supporting the implementation of a new loyalty card program for Confidential, defined the technical design requirements related to the integration of various systems with Confidential databases.
- Developed technical requirements documents including: database interaction diagrams, data flow diagrams, system interaction schemes, data mapping (source to target) matrices, test plans, etc.
- Worked with development, ETL, IT, QA, PM, and business stakeholders to ensure technical requirements met both business and technical needs.
- Helped troubleshoot data content issues related to ETL process testing.
- Led design review sessions with architectural review boards and security teams. Managed the technical design schedule, estimated hours and resources, provided status reporting etc.
- Achieved a 100% design approval rate on all integrations.
- Recognized by the IT and architecture teams for providing outstanding technical design presentations and simplifying the review process.
Senior Business Analyst
Confidential
Responsibilities:
- Supporting the implementation of a new loyalty card program for Confidential, worked with the business teams to 1) define and document business requirements and develop Business Requirement Definition documents and 2) develop the functional requirements supporting the business needs and develop Functional Requirement Definition documents.
- Led BRD approval meetings with stakeholders to facilitate feedback, refine requirements, and move requirements to the functional definition stage.
- Developed the Functional Requirements needed to meet the business goals.
- Worked as a solution/data architect with Confidential vendor contacts, IT, and operational teams for each integration system to define and document data, communication and technical constraints and needs.
- Led FRD approval meetings with vendors, architecture, development, and QA teams to ensure all functional requirements were feasible and understood.
- Managed the business and functional requirements schedule, estimated hours and resources, and provided status reporting.
- Achieved a 100% approval rate on all integrations. Based on the success of this effort, was nominated to lead the technical design effort.
Confidential
Senior Business Analyst, Scrum Master
Responsibilities:
- Requirements gathering and elicitation (researched existing systems across multiple business units, facilitated meetings and discussions with stakeholders, developed the product backlog and sprint backlogs).
- Solution design, architecture, and estimation (worked with development and management to quantify a solution for the client).
- Requirements development (functional specifications, use case scenarios, wireframe diagrams, etc.).
- Scrum master - led daily scrum meetings, served as a focal point between the client and development teams, served as the product owner and BA, managed requirements in version control.
- Developed 35 user stories, 60+ use case scenarios and more than 25 wireframes in less than 45 calendar days.
- Helped deliver a complex financial learning portal serving thousands of users in approximately 3 months.
Confidential
Senior BA/Data and Master Data Management Analyst
Responsibilities:
- Working closely with senior data management, BI, and IT leadership and various Confidential teams, analyzed existing business processes and legacy systems related to Confidential and competitor locations (retail stores, distribution centers, and corporate facilities) to identify a standard business glossary, data models, use cases, and work towards MDM implementation.
- Developed MDM location data model, business process workflow diagrams, entity relationship diagrams, and a business glossary attribute template identifying legacy data fields to master data management attributes and terms.
Database PM/Team Lead, Solution Architect
Confidential
Responsibilities:
- Performed database modeling, design, and development related to the complete upgrade of the existing client consumer facing Web site.
- Scoped and identified DB requirements, estimated resource and schedule needs, developed the project plan, schedule, etc., identified risks and related mitigation plans.
- Assigned and monitored progress, led daily/weekly/ad hoc status meetings and provided ongoing status reports.
- Led a team of 10+ developers and oversaw implementation of database structures, models, modules, and data feeds.
- Created JSON schemas and files and data flow diagrams, developed data clean-up specifications used to create automated data update scripts, reviewed test plans and quality feedback to provide issue/defect resolution.
- Created requirements documentation, data flow diagrams, system integration and data feed requirements, JSON data schemas, JSON data files, entity relationship diagrams, test plans, sample data profiling reports, testing results, go live run book, and many other integration and architectural diagrams and supporting documents.
- Met a very aggressive deadline (< 6 months). Implemented the first NOSQL database and JSON data transfers at Confidential .