| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address
PHONE NUMBER AVAILABLE (mobile)EMAIL AVAILABLEhttp://LINKEDIN LINK AVAILABLEPROFILESenior Software Business/Technical Analyst/Engineer and Database Developer with extensive reporting, development, application and mainframe experience. Background also includes quality assurance testing and system analysis in multi-functional or dedicated environments for contract/permanent work. Over 25 years as contract/permanent IT specialist in manufacturing, medical, agricultural, grocery, banking, automotive, insurance, pharmaceutical and healthcare industries. Astute researcher utilized by upper-level management to achieve successful results on major projects (Meaningful Use, Electronic Funds Application, Data Warehousing, and Data Manipulation of Account Masking).Capable of developing programming talents independently in response to demands of the assignment.Extensive background includes Oracle/SQL Server/Netezza development skills (database and GUI), data warehouse development (table creation, data modeling, data mapping, data mining, key creations and relationships, and stored procedures), mainframe development (COBOL, Progress 4GL, RPG/AS400, Informatica and Informix), Business Intelligence reporting/tools (Business Objects, Crystal Reports, Microsoft Access, MicroStrategy, Cognos Reports, Oracle Reports/ Forms, SSAS, SSRS, SSIS, QlikView, QlikSense, Teradata), SQL development (SQL*Plus and PL/SQL, T-SQL, Visual Studio 2005/2008/2010/2012/2014, Oracle SQL Developer), UNIX scripting, Data Manipulation processes (Extract Transform Load (ETL) procedures, Toad and Erwin usage), Web Development (HTML, Microsoft FrontPage, XML), Quality Assurance (System and Unit Testing), SharePoint 2013/2016, Confluence, CHALK web pages, MS Visio/Alteryx for flowchart/data diagrams, Cisco Webex and MS Teams for Meetings, Remedy, Jira and Silva/ServiceNow/DevOps (Ticket Resolution Applications), SAP and Endeavor for problem-solving purposes.Excellent in communication and/or writing skills including extracting information from stakeholders and holding agile scrum meetings to provide updates on a weekly/bi-weekly basis according to what is preferred by upper-level management.TECHNICAL ADDENDUMSQL Server Development; SQL Server 2005, 2008, 2012, 2014, 2016,2019, SSRS, SSAS, SSIS, SSMS 18.7/18.12.1Oracle Development utilities: Oracle Discover 3.1, Oracle Reports/Forms, Report Development, SQL, T-SQL, SQL*Plus, Data Warehousing and MSRS, Oracle SQL Developer 20.Reporting Methodology: Agile, Waterfall, SDLC, Azure, Scrum Meetings, User Stories, Data StructuresReporting Applications: Tableau 2009, PowerBuilder, QlikView, Qlik Sense, Business Objects, Brio, Microsoft Access 2003, Cognos Reports 9.0, Micro strategy 9.0/2016/2020, Crystal Reports, and Teradata SQL Assistant 20.Databases: Netezza, Informix, Oracle 7.3/8.0/9.0/10g/11G/11I/12C, SQL Server 2005/2008/2012/2014/2022, Teradata.Net 16Mainframe items: COBOL, Informix 4GL, Endeavor/MVS, Progress 4GL, Crystal Reports, GEAC and GEAC PC Link, DEC VAX, VMS, Informatica 8.4/8.6, Tivoli, Six Sigma/DMAIC.Distributed application items: API, ETL, XML, UNIX, Toad, Domino Quickplace, Interwoven Teamsite, Web Development, Java, C#, .NET 4.0/6.0, Visual Basic 5.0, Microsoft FrontPage, DreamWeaver, Adobe Photoshop 5.5, Image Ready 2.0, C++, JavaScript, HTML, Windows NT, Novell, SQRibe Programming, Visual SourceSafe, Platinum Erwin, Visual Basic, WSFTP Pro 7.62, FortiClient VPN, Azure Date Studio, Azure DevOps for Office 2019.MS Office Suite: Microsoft FrontPage, MS Word 2016/2019, MS PowerPoint 2016/2019, MS Excel 2016/2019, MS OneNote 2019, MS Visio 2016/2019, MS Teams 2019, MS SharePoint 2019, MS Lists 2019, WebexOther skills: Data profiling, Data Mining, Data Modeling, Data Analysis, Data Optimization, Application implementations, installations, migrations, and upgrades; Flow Chart creations, creation of Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Technical Documents Designs or specifications (TDD/TDS), WireFrames (report layouts), KOM (Key Operating Metrics), other high-level and low-level documents (HLD/LLD), and Use Case documents for testing, Remedy, Silva (ServiceNow), Jira (Ticket Resolution Applications), Confluence, CHALK, Sharepoint 2010/2013/2016/2019, MDM, Alteryx, and WebEx/MS Teams/Zoom for Meeting creation.CAREER HISTORYPCI Group Charlotte, North Carolina April 2022 PresentBusiness Analyst III, Information Technology TeamWorked with stakeholders of the company to create documentation for multiple projects including providing business requirement documentation for explanation of how software process should perform and created workflow Documentation for a visual view of how the process should function. These documents consist of BRDs, Mock-ups of layout changes, Wire Frames for initial reports/layout forms, and MS Visio documents which would include the workflow of the project for current and future use. Work with management and assist with DevOps ticket management and Team Scrum meeting management. Review processes with stakeholders to correct issues and enhance current processes. Acted as liaison between Software Engineering and other business departmentsWorked closely with SMEs to capture and validate business requirements and with Software Engineers, Software Developers and IT architects to identify technical solutions to ensure that the technical needs of the business units were met.Created queries and reviewed data for data verification and data analyzation efforts using SSMS to assist in answering questions related to any PCI printing issues found.Reviewed current systems to create multiple workflow diagrams for continuously changing systems on a periodic basis such as the FPS2 and PrintReady Application processes to keep them updated when major changes are needed for current processes using Visio to bring visibility to how the processes could be modified to reduce production time.Met with stakeholders for project management of mini projects that involved extensive reporting needs. Also discussed systems that they used to ensure that their needs were being met with how the system currently functioned or whether any modifications were needed in order to enhance their current daily system activities.Managed teams through daily Scrum/Touchpoint meetings utilizing Agile methodology wherever necessary to accomplish the goals of getting the projects done quickly and proficiently.Assisted with audits by gathering information on how Quality Assurance (Testing) processes were being handled by different teams to ensure data accuracy and to document integrity validation.Skills used: SQL Server Management Studio (SSMS) 18, MS Analysis Services 15, SQL Server 2022, MS .NET 6.0, Data Analysis, Business Analysis, Data Management, Project Management, Technical Analysis, requirements gathering and documentation creation (BRD/Wireframes), Azure DevOps for ticket administration, SharePoint 2019, Confluence, MS Teams 2019, MS Lists, MS VisioCharter Communications Charlotte, North Carolina November 2019 February 2022Business Analyst II, Location Intelligence Team (from 03/2021 - 2/2022)Work with stakeholders of the Enterprise Marketing Team to create documentation for business intelligence projects. These documents consist of BRDs, FSDs, KOMs, Mock-ups, and Wire Frames. Work with management and assist with Jira ticket management whenever needed. Perform analysis for issues found in database and assisted with the ad-hoc reports whenever requested.Created Queries and pulled data for data verification and data analyzation efforts using SSMS and Teradata to assist management in answering questions related to any Enterprise Marketing issues found.Updated reports per users request to add additional fields to provide a more current report using ETL to import in additional fields needed along with additional business analysis and data analysis efforts.Used SQL Server to retrieve certain data elements that are housed there which are not found in other systems.Utilized the Star Schema and Snowflake methodology along with Fact and Dimension table knowledge to retrieve data from multiple systems and verify that the data exists or should exist there.Assisted with ticket management using Jira and Kanban boards. Also, I reviewed them to make sure that the latest updates are always available for upper-level management to access for bi-weekly presentations.Ran daily ad-hoc processes to create requested reports to be distributed to users within a 2- hour SLA window using excel for the final results.Reviewing API processes and stored procedures within applications to create data flow diagrams showing how the process performs using different data requests and returning values for results.Creating data flow diagrams for additional stored procedures for more well used processes such as buildings and businesses processes that are used throughout many different other applications.Created CHALK pages for each of the 3 different teams to receive requests from other business users for information that they need to complete their own assignments.Conducting Webex Meeting with stakeholders to assess their Jira requests, do working sessions to correct issues and provide updates on current projects in a weekly or bi-weekly status meeting as requested or needed.Assessing multiple billing systems such as ICOMS, TWC and Brighthouse to review data dumps to answer questions posed by stakeholders about questionable data or data anomalies.Started reviewing data related to MDM (Master Data Management) project to evaluate where the data is that will be displayed in the Microstrategy reports.Used MS Visio and Alteryx as flowchart tools to define the data flow of processes and stored procedures for the purpose of answering stakeholders questions and modifications to those processes whenever needed, required, or requested.Skills used: Oracle SQL Developer 20, SQL Server Management Studio (SSMS) 15/16, MS Analysis Services 15, SQL Server 2016/2019, Teradata 16, Data Analysis, Business Analysis, Data Management, Technical Analysis, requirements gathering and documentation creation (BRD/FSD/KOM/Mock-ups/Wireframes/S2T), Skype for Business 2019, VSTS/Kanban boards, Jira for ticket administration, SharePoint 2019, Confluence, MS Teams, API, ETL, Webex, MS Visio and AlteryxBusiness Intelligence Developer III, BI Services Enterprise(contractor from 11/2019 - 07/2020, permanent from 07/2020 03/2021)Work with stakeholders of the Business Intelligence Team to create documentation for business intelligence projects. These documents consist of BRDs, FSDs, Mock-ups, and Wire Frames. Work with management and assist with Jira ticket management whenever needed. Perform analysis for issues found in database and new Microstrategy reports to be created.Creating Queries and pulling data for data verification and data analyzation efforts using Teradata to assist management in answering questions related to any enterprise issues found.Using SQL Server to retrieve certain data elements that are housed there and not in other systems.Utilized the Star Schema and Snowflake methodology along with Fact and Dimension table knowledge to retrieve data from multiple systems.Worked with data visualization software such as MicroStrategy for report creationUsed ETL to assist with development efforts of current and/or new reports as well as using MicroStrategy as the reporting tool.Skills used: SQL Server 2016/2019, Teradata 16, MicroStrategy 2016/2020, Data Analysis, Business Analysis, Data Management, Technical Analysis, reporting, metrics development, requirements documentation (BRD/FSD/Mockups/Wireframes), Skype for Business 2019, VSTS/Kanban boards, Jira for ticket administration, SharePoint 2019, Confluence, MS TeamsAXA-Equitable, Charlotte, North Carolina October 2018September 2019Business Systems Analyst, CTO Data Group (Contractor)Work with stakeholders to assist with the Lights on or Business as Usual project. Manage teams through daily Scrum/Touchpoint meetings utilizing Agile methodology wherever necessary to accomplish the goals of getting the projects done quickly and proficiently. Work directly with the Data Team providing insight to team members as needed. Created and developed Tableau reports upon request while utilizing the software development cycle in an agile environment. Provided project management expertise to different projects for any new or continuing initiatives in the data area.Held daily SCRUM touchpoint meetings with 3 onshore/offshore teams (~ 40 - 60 people) to review over different projects that are being handled by the team members. Sprint Meetings were held to go through projects to make sure whether they would fall in the current sprint or be moved to the subsequent sprint to allow team members to be consistent with on time project completion. Reviewed current user stories within the Kanban Boards with team members to ensure project planning for accuracy and that it was enforced to project completion. Assisted newer team members with training in the creation of user stories so they would become more proficient in project estimation. Agile methodology was enforced on many projects and re-assessed on several phases of cloud projects to make sure that the projects started and continued to stay on schedule per pre-defined timeline.Created new and modified current Tableau reports for business users to create visualizations that would include data, both graphical and statistical, to show them how their agents were performing and how many customers were being serviced during requested time periods displayed on the reportsAssisted in development activities with previously created Tableau reports for use in training users on mechanical corrections needed in their reports when repetitious requests were being made on a periodic basis, such as showing them how to add additional columns, expand columns, change formats in the current fields and add additional graphs to show their upper-level management the progress that they have made within their areas.Reviewed Silva (ServiceNow) tickets on a weekly basis to ascertain the progress made on them and to assure end users that their requests were being handled in a timely manner.Held bi-weekly meetings for upper level managers through Skype for Business to provide them with presentations utilizing tools such as MS PowerPoint and MS Excel to display the progress done by the teams since the last meeting and presentation.Assisted in a major initiative within the group that would assist the team members in keeping their software up-to-date (Removal of Qualys vulnerabilities - scan occurred on monthly basis and was reviewed to see how many issues had been cleared up within the systems/applications and what the upcoming plan was to continue the clean-up process with the groups, i.e. java patches.)Traveled to other company sites when necessary to attend meetings held by upper level management and for training purposes.Skills used: SQL Server 2012/2014/2016/2019, Tableau 2019, Microsoft Teams, Data Analysis, Business Analysis, Data Management, Technical Analysis, reporting, metrics development, requirements documentation (BRD/FRD/TDD/HLD/LLD), Skype for Business 2019, VSTS/Kanban boards, Scrum Meetings, User stories, Silva for ticket administration, SharePoint 2019, Project Management, Azure, Oracle 12C, PowerBuilder (introduced to), Agile MethodologyDriven Brands, Charlotte, North Carolina July 2017 October 2018Technical Delivery Manager, Information Technology GroupWork with all areas of the company assisting in any capacity needed to retrieve data, modify or create new applications as requested and perform any other requests as needed from the Information Technology basis.Designed and developed Advanced Reporting Solutions using best practices and BICC standards.Managed several projects for integration of the current fleet vehicles with our current brands to allow for additional data manipulation and data retrieval requests that would ensure future reports could be created for Marketing purposes. This also allowed for the purpose of including additional information for tires and brakes to be available whenever needed.Assisted in Quality Assurance on a major company application POS (Point of Sale) System [M.Key] by creating several documents for them to use as testing documentation for each new iteration of the application before it is provided to their clients such as an Issues list Spreadsheet, Word Document and a Base Regression Testing Document for continued testing on current and future iterations of the application for bug fixes, system enhancements and application updates.Developed new and updated existing Qlik applications within the company for specific brands that would provide visualizations to include bar charts, graphs, tables and KPI data models for the brand where they would show current and upcoming trends in their sales as well as any financial highs and lows in their business.Performed data analysis for first-level review on tables provided when new applications/dashboards/visualizations were requested to be created in Qlik.Validated efficiency of data within current data model stream for current and new Qlik reports.Conducted training classes to demonstrate how training documentation and testing documentation functions.Updated and modified current M. Key User Manual to bring it current and validate defined functionality within documentation that it lined up with how application works.Modified the Release Notes for the M. Key system to include any enhancements, bug fixes or modified functionality from the current release.Performed data analysis to assist and correct issues with shop payment retrieval issues.Functioned in Business Analysis capacity when new applications were created or any modifications were needed on current systems/applications by leading meetings for overall scope of new applications within an agile environment, created business requirements documentation, high level/low level documentation and final signoff approval documentation when applications were ready for implementation.Skills used: SQL Server 2012/2014, SSRS 2012, SSAS, SSIS, Data Analysis, Business Analysis, Data Management, Technical Analysis, reporting, metrics development, requirements documentation (BRD/FRD/TDD/HLD/LLD), QlikSense, QlikView, Jira, XML, Visual Studio 2010/2012/2014, Skype for Business 2015, Crystal Reports 2012/2014Lash Group, Fort Mill, South Carolina March 2016 April 2017BI Architecture/Technical Business Analyst II, Client Analytic Advanced ReportingWork with Operations team as a partner to deliver ad-hoc and automated reports using SSRS/SSIS tools in a timely manner. Review the current portfolio of clients and check SSRS reports to see where new dashboard(s) can assist them in retrieving information in a quicker and more precise manner.Designed and developed Advanced Reporting Solutions using best practices and BICC standards.Began incorporating Business Intelligence tools methodology while creating new and current reports.Trained using new BI Tools such as QlikSense, and QlikView as the tools that would become the BI tools to use for all current and future reporting.Did full life cycle project work for each of the reports I worked on including but not limited to requirements gathering (BRD\RRD\LLD\FRD), research, analysis, development, testing (unit and regression), documentation for installation (CAB review change management), and training when necessary.Created, maintained, modified different SSRS Reports through creating and updating stored procedures, updating rdls using visual source safe and creating ADS excel documents to move the reports through the different environments to be tested and installed using TFS (Source maintenance system).Reviewed, modified, and updated SSIS packages for the reports when it was required for the different reports I worked on for the client.Ability to review reports for trends, outliers, quality, data structure, report validity and data details to remove the possibility of recreating the same reports.Ability to work in both Agile with scrum meetings and masters and Waterfall methodology with top to bottom full life cycle development in SSRS environments.Skills used: SQL Server 2008/2012, SSRS 2008, SSAS, SSIS, Data Analysis, Business Analysis, Data Management, analysis, reporting, metrics development, requirements documentation (BRD/FRD/TDD/HLD/LLD), QlikSense, QlikView, SharePoint 2013, XML, Visual Studio 2005/2008/2010/2012, Skype for Business 2015, Crystal Reports 2012/2014, XML, ConfluenceBusiness Analyst, BI Reporting & Data Delivery Team Charlotte, North Carolina July 2015 March 2016Worked with BI Delivery Manager and Operations to analyze and document business processes and requirements. Efficiently and effectively analyzed and translated business requirements into reporting technical requirements for adhoc as well as report automation using SSRS and SSIS. Facilitated meetings and ensured report delivery timelines were met as expected.Designed and developed BI solutions using best practices and BICC standards.Collaborated well with project team, business partners, Reporting Delivery Manager, and senior levelExecutives to ensure that their business needs were being met for all current reports and newly suggested report creation.Reviewed reports for trends, outliers, quality, data structure, report validity and data details to remove the possibility of recreating the same reports.Communicated clearly, effectively and in a timely manner with Operations and IT partners about report updates, milestones and delays whenever noticed.Ensured the full workflow of the reporting request is followed, documented and closed.Planned and managed business requirements, functional requirements, QA and documentation activitiesEnsured adherence to Reporting processes and performance metrics were done in a positive mannerAssessed reporting needs; provided recommendations for enhanced solutions and matched needs to Reporting tools and capabilities including offering suggestions to make the final product user friendly as well as re-usable in other report manner.Ad-hoc query development to support program needs whenever requested by Operations per client needs.Worked with Reporting and Information Technology team members to communicate requirements and ensure delivery of quality Reporting solutions.Skills used: SQL Server 2008/2012, SSRS 2008/2012/2014, SSAS, SSIS, Data Analysis, Business Analysis, Data Management, reporting, analysis, requirements gathering and documentation (BRD/FRD/TDD/HLD/LLD), SharePoint 2010, Visual Studio 2005/2008/2010/2012, Business Objects, Crystal Reports, Skype for Business 2015, Business Intelligence, ConfluenceMcKesson Corporation, Charlotte, North Carolina February 2012 May 2015Technical Implementation Engineer 3Gathered, clarified, & documented requirements for application projects. Worked closely with client sites to do implementations, conversions, installations, testing, trainings, documentation, development and modifications as needed depending upon their needs and where they were currently in their Meaningful Use process. Provided training to several in-house team members as well as client sites whenever requested by manager or other team members on current as well as new applications and processes. Worked on Service orders using troubleshooting methods and other techniques to assist clients with correcting any issues they had with their current software.Was certified in Paragon 12.1 and SQL Server 2012.Worked on new employee documentation to assist all new employees with working on the tasks that was needed to bring a new client live.Was Subject Matter Expert (SME) for several applications such as McKesson Compliance Advisor (MCA) and Clinician Mobile (one of our first mobile applications) which allowed me to learn the major setup for those applications and how to troubleshoot for any issues that has risen using a tablet, phone or other mobile tool.Created necessary documentation for our team applications where there were none currently available and sent to the business documentation team to be added to SharePoint for all team members to access.Modified reports for clients whenever requested and whenever assistance was needed to assist them in being more efficient with upper-level management needs.Worked on special projects for Meaningful Use (Truven Patient Education and Biztalk Rules Engine) which would assist medical professionals in supplying patients with the information that they need before leaving a hospital or medical facility to ensure that they would be able to adequately care for their bodies with the illness or allergy that was pertinent to them. These installs allowed all clients to meet their Meaningful use requirements per governmental standards.Skills used: SQL Server 2012, 2008, SSRS, SSAS, SSIS, Data Analysis, Business Analysis, Server Management, Data Management, Client Management, Adobe 9 and 10, Crystal Reports XI R2, Team Notes, MS Word 2007/2010, Data Warehouse, PL/SQL/T-SQL, Stored Procedures, SharePoint 2010Daimler Chrysler, DTNA, Fort Mill, South Carolina October 2011 November 2011Data Technical Analyst, Used Truck Division - contract (project lost funding)Gathered, clarified, & documented requirements for application projects. Worked closely with SMEs to capture and validate business requirements and with IT architects and developers to identify technical solutions. Facilitated meetings and documented outcomes. Set technology direction in concert with the ADT (Architecture Development Team) and IT standards. Performed business process analysis for AS IS /TO BE processes.Worked on a project to bring order to the current way that the site was organizing their truck sales whether local or international. They currently had several divisions touching the process but even though there was current overlap in group processes there was not enough communication between the groups to leverage from one another to cut back on their current processes being redone between groups. I had to engage my data analysis as well as business analysis skills to gather all of the information between all of the groups and translate them into one document to assist in creating the new integrated process.Skills used: SQL Server 2005/2008, Oracle 9I and 10G, SSRS 2008, SSAS, SSIS, Data Analysis, Business Analysis, Data ManagementTime Warner Cable, LLC. (Spectrum), Charlotte, North Carolina August 2010 August 2011Business Intelligence Business/Data Analyst, Consumer Value Center (CVC) Analysis Team (12-month contract reached contractor tenure limit)Facilitated as well as participated in Requirements Review Sessions with business and/or technical teams. Developed Business, Functional and/or Technical Requirement specifications adhering to standard templates. Developed other supporting documentation such as Source to Target Mapping Documentation, Gap Analysis, Use Cases, Business Logic Flows, Process Flows, and Requirements Traceability Matrix. Provided support for internal projects by identifying, researching, and analyzing the issues or defects related to Work Orders and Subscriptions in order to develop solutions and resolve recurring issues. Wrote the requirements for the development team to correct the issue. Drove and assisted with data analysis to improve operation including uncovering data anomalies and performing research of other forms of key operational data to enable efficiencies and overall data quality. Developed documentation including the use of data modeling to create tables with field information using Informatica to show the relationships, data elements and work flow for tracing data elements from one database through to another. Utilized Cognos Reporting, Oracle Reports/Forms as well as MicroStrategy for creating ad-hoc reports for users and in running reports to gather data to develop more functional reports with drill-down capabilities for end users depending upon the need of the client.Created and manipulated Validation scripts for comparison testing within Regions, Divisions and Corporate to verify data accuracy and availability between all areas including multiple billing systems such as CSG, ICOMS and Hawaii.Did data manipulation and data analysis on different reports that pulled data from ICOMS to modify current reports, create ad-hoc reports and create new reports per the client's need.Created a PowerPoint Presentation and provided training for internal team on Informatica tool, its usage and capabilities.Created all Technical and Functional Documentation related to the Decision Manager Project to assist in the re-architecture of the current datamart.Skills used: Oracle9i and 10G, Oracle Reports/Forms, Informatica 8.6, Mercury Quality Center/Test Director 9.0, WinSQL, Toad 9.6, PL/SQL, UNIX, Cognos Reporting 9.0, MicroStrategy 9.0, Remedy, Aginity Workbench, ETL, Unix Scripting, Netezza 5.0, FTP Voyager 15.2, Data Warehousing, Statistics, Data Analysis, Data Modeling, PeopleSoft HRMs, SnagIt, SQL*Plus, Microsoft Project, Microsoft Access 7.0, Microsoft Office Communicator, Requirements Traceability Matrix for testing purposes, Requirements Gathering, SAS 9.1.5Continuing Education, Greenville, South Carolina September 2008 July 2010Enhanced skills in MS SQL Server 2005 and MSRS Report Designer through online tutorial assistance.Reviewed Informatica ETL capabilities through |
