IT Highlights

• Complete C projects using Object-Oriented Design
• Utilize SDLC in the completion of IT Projects
• Implemented For loops, local/global variables, if/then statements
• Created database of an automotive dealership using SQL and SQL Server to track/update inventory, customer info, sales, and other relevant data
• Track and coordinate projects using Microsoft Project and WBS

PROFESSIONAL EXPERIENCE

Confidential

Data Specialist

• Analyze large data sets using MS Access through queries, macros, and forms.
• Update records by editing records, appending rows, deleting rows, and creating records to new tables with MS Access.
• Documented processes in the form of SOPs to gather steps to analyze data with queries, macros, conditional statements, and functions in MS Access.
• Create charting of datasets in Tableau of various views, crosstabs, and chart types.
• Use MS Project to enter, edit, and update entries related to new pilot website as a co-Program Manager. Updates include tracking and adjusting resources, durations, start dates, end dates, cost, lead, alternates, and WBS.
• Create requirements, interface with IT development team, track burn rates, and provide customer service to website users.
• Update content, links, and articles in article manager, category manager, menu manager, and media manager of current pilot website which will go live soon. Changes and content were updated within Joomla CMS.
• Develop storyboards and scripts of recorded training videos by capturing links, steps, text tips, and implementation of business rules in motion using Adobe Captivate. Recordings were edited of mouse navigation, transition, timing, and other relevant content so audience may follow and implement daily tasks to website currently in pilot phase.

Confidential

Data Modeler

• Gather data via ODBC connection for analysis and presentation PowerPoint . The SQL data is isolated using requested variables and conditional statements and, or . Also, SQL keywords such as where, distinct, insert into, update, like, are used to filter the data more specifically.
• Analyze unstructured and structured raw data sets to ensure, format, integrity, splitting fields, derived values are broken correctly to provide data for bath uploads are met for ETL tasks.
• Maintain list of dirty values and associated correct values to make correct adjustment changes.
• Download, observe, and analyze uploaded data sets to ensure fields are occupied with correct values as determined by Data Dictionary in ETL analysis. Data is exported to Excel and fuzzy logic is used to determine those records of which have errors.
• Use wildcards to gather data which may not be refined and/or as a search function. In addition, use joins to find entries in other tables.
• Write syntax for stored procedures and triggers to perform specific actions or to gather data meeting specific criteria.
• Copy, upload, index, and parse SQL data bi-monthly for analysis in Linux on both production and development side for relevant end users.
• Formatted and/or transformed SQL data in Excel and PowerPoint slides with relevant bullet points and charting to populate findings/reporting to Management
• Analyzed gathered data using SAS, Excel utilizing proprietary macros, pivot tables, and various functions , and TS level internal software. Look for trends, deviations, and anomalies of whether data points are valid and if they are not valid what would be needed to pass graphically and other various checks .
• Attended and completed Pearson CLO-001 Comp TIA Cloud Essentials class. In addition took and passed exam to receive certification. Took class in preparation of future big data cloud implementation within organization.
• Update, make entries, and changes to both SharePoint and JIRA websites of both individual and team-based projects for reading and analysis by other members of organization.
• Once a month, audit all of our data, test it graphically, and make necessary changes to ensure the integrity of our data historically and moving forward is reliable for not only future issuance of passports, but to also handle projects, and requests.

Confidential

Data Analytics/Consultant

• Analyze large data sets by querying/writing syntax to analyze data gathered from servers using COGNOS and/or SPSS to create reports, presentations, and deliverables to internal and external stakeholders.
• Work with clients to define scope , plan, initiate and execute related projects to apply statistical concepts/ models to answer what if, predictive, and forecasting scenarios for analysis and decision-making.
• Communicate with Management to gather requirements of data to be analyzed and created in both Excel and PowerPoint. Utilize pivot tables, vlookup, sumif, macros, if, and getpivot to gather, format, and present data including .pdf files to stakeholders.
• Accessed large data sets from multiple internal sources ODBC, EDW using various programs/languages SPSS, COGNOS, Excel, and SQL
• Analyze/transform data in SPSS via select cases, recode and compute variables, frequency tables, crosstabs, etc.
• Experienced in creating dashboard views, exporting data, altering dimensions, and updating query pulls with web analytics package: Visual Sciences.
• Use data gathered from Visual Sciences to project growth, totals, and historical data for analysis and predictive analytics presentations and monthly reporting.
• Utilize SharePoint for collaboration of tasks, projects, documents, and creation of surveys. Also, updated site with latest version of formatted documents.
• Identify and created varying types of surveys depending on structured and open-ended questions as they relate to studies involving team members and individuals involved in study.
• Maintain and create communities within SharePoint as they relate to relevant users for content, information, and updated relevant attachments.
• Ensure that SharePoint website integrity is maintained for enterprise content and management so that all stakeholders can acquire in a timely manner needed attachments to complete both short and long-term taskings.
• Update as needed to the SharePoint website the grouping of SharePoint sites so that internal stakeholders may gain further insight and points of contact of the appropriate contacts for follow-up for tasks and to ensure no single point of failure regarding projects with ambitious deadlines.

Confidential

Senior Budget Analyst

• Programmed changes to Home Webpage and Program Build websites. Electronic files and attachments for perusal, analysis, and PB projects were updated as needed within hour as needed using knowledge of web development, HTML, and Dreamweaver.
• Experienced working with disparate data sources in various formats e.g., Excel, delimited text files, and database exports .
• Imported multiple large data sets from EDW into Excel and rearrange columns of data to conduct analysis via filtering and pivot tables to show clients and colleagues the before budget request and after end of respective fiscal year changes in Base, OCO, and Programmatic Changes in order to write justifiable text of significant changes in CBJB/CJB.
• Created and verified biennial budget exhibits for entry into SNaP, BIRD, Contractor FTE databases. Maintained established relationships with Senior Supervisors and participated in meetings with point-of-contact for changes, requirements, and updates were identified.
• Balanced and verified both pay/non-pay and manpower figures for Narratives, Program Manager's Statement, MSA Major System Acquisitions in POM BES/IPBS Intelligence Program Budget Submission and CJB/CBJB Congressional Budget Justification Book during the PPBE process. Identify and bring to attention of stakeholders of errors in balancing from FY04-Present in the millions.
• Forecasted, generated, and interpreted financial reports for decision-making, validation, and potential alternatives of funding and continued operations. Pivot table/charts and PowerPoint reports were created for management for analysis, scope of options, potential impacts, and alignment with short and long-term goals of creating a budget based upon Zero-Based Review.
• Incorporated and interpreted Scenario Manager, Goal Seek, and Solver to determine Best/Worst Case result, Goals, and complex issues to determine outcomes, their impact, and brain-stormed alternatives to resolve matters of creating the future budget for long and short-term goals with limited funding request as outline by overseers.
• Implemented Excel's Analysis Toolpak to utilize Trendline types linear, logarithmic, and polynomial, moving average, power, and exponential to determine the integrity and validity of numerical data as provided by various Investment Portfolios to determine if funding request justified data provided to the warfighter in relation to effectiveness.
• Retrieved and computed FY00 to present FYDP pay, nonpay, OCO with query reports and fiscal guidance for close of budget year within 3 working days. This 47 increase in completion time allowed narrative writers to provide more in-depth and detailed project justifications and review.
• Calculated and verified OCO Overseas Contingency Operations dollars and justifying text to both internal stakeholders and overseers in a truncated timeframe to meet ambitious submission date for BIRD, OP-5, and SNaP entries.
• As an Administrative Super User, provided relevant access to GUI-based PB Homepage to stakeholders in order complete narrative and dollar adjustments for completion of PB and Basis of Estimate projects.
• Participated, brain-stormed, and tested improvements to GUI-based PB Homepage by suggesting and testing improvements during JAD/Requirements gathering meetings.
• Trained colleagues within office on new features and functionality of Office 2007 pertaining to projects, required submissions, and tasking for Chief and Deputy Chief to improve effectiveness and efficiency.
• Conducted training sessions via VTC to stakeholders at various field sites on IE GUI-based Program Build tool to create and fund budgeting requests for upcoming Program Build. PowerPoint informational session was followed by live demonstration and question answering session.