Summary

Knowledgeable and skilled software development professional accustomed to working with Accounting systems. Skilled at developing, optimizing and reworking systems to meet specific customer requirements. Highly proficient in multiple types of programming languages. Seasoned Software Support Engineer well-versed in supporting users and troubleshooting problems. Bringing remarkable understanding of Accounting/Development operations and resilient nature focused on finding root causes and making permanent improvements.

Astute IT professional with track record of meeting critical deadlines with success. Highly adept at task prioritization and working closely with individuals of all types of personalities. Passionate and driven professional with remarkable analytical and problem-solving skills. Well versed in multiple coding languages including, XML, vb.net, c#, javascript, SQL and more. Proficient with a multitude of office programs such as, SSRS, SSIS, SSAS, SSMS, Crystal Reports, InfoPath, SharePoint, IIS, Excel, Word, OneNote, and more. Able to work from Home and maintain a professional demeanor and outlook with great time management and punctuality. Attentive to client needs and in meetings. In search of a career, not only a job but something I can grow and accel in.

SUMMARY TOOLSET SPECIALTIES

MS SQL Server (2008R2, 2012, 2014,2016), Transact-SQL(T-SQL), Query Analyzer, MS Visual Studio (2005 – 2017), SSIS, SSRS, SSAS, SQL Server Management Studio (SSMS) AKA SQL Server Data Tools (SSDT), Team Foundation Server (TFS), ANSI SQL, MS Access, Data Analysis Management, MS Office(MS Access, MS Excel, MS. Word, MS PowerPoint, MS Visio, Pivot Tables, FTP, InfoPath(2008 – today), SharePoint(2010 – 2016 and 365), JavaScript, VBScript, Visual Basic for Application (VBA), HTML, XHTML, VB.Net, ActiveX Data Objects (ADO), Open Database Connectivity (ODBC), Data Access Objects (DAO), TOAD for SQL Server, REST and SOAP web services, XSLT (Resource files for data), XML, XPATH.

EXPERRIENCE

2019-2020 ProCon Technology ATLANTA, GA

Consultant SharePoint Migration (Aug 2019 – Jan 2020)

Consulted and assisted in updating various Excel Workbooks for the Clayton County eye center.

Reworked VBA code and created new functions to assist with the new UNC paths from the old fileserver to the new SharePoint Server.

Sample VBA I created from scratch.

o

2012-2019 CCBS INC Flowery Branch, GA

LEAD Developer – Business Intelligence and InfoPath Guru (May 2012 – Sept 2019)

Created reporting and analytics solutions to deliver insightful analysis and support high-level decision making to provide trend analysis and interpretations for risk adjustment, financials, and quality management implications.

Created complex SSIS packages to extract, transformed, and loaded data from multiple source systems into SQL Server 2008 – 2014 SQL Server databases oversaw development of increasingly complex SSRS reporting for consumption by the business units, project management, department managers, VPs, and CFO’s.

Automated ETL and monthly status reports that was widely thought to be impossible to be automated due to the complexity of the reports and difficult to manage. Achieved this leveraging SSRS for reporting and subscription.

Updated and tweaked SSAS queries that sourced SSRS cube reports for Vendors, Merchants, Products, Accounting, Purchase Orders and Executive Summaries. Created Excel Pivot reports for Front End.

Created Reporting dashboards for the senior Executives, and for the Sales team

Provided business process solutions to Product Development, Pricing, Digital Content, Wireless, Sales & Finance, and Indirect Business Teams.

Worked in an Agile Scrum environment

Created and updated a plethora of SSRS Vendor reports that included but were not limited to the following: Morisson Hershfield, S&ME Inc, Geosyntec, Little Diversified, Wunderlich Malec Inc, AMEC Foster and Wheeler (before bought by Wood Group) and other various Engineering firms with accounting needs. The SSRS reports were inclusive of accounting data from budgeting, revenue recognition, ETF, Purchase orders, vendor invoice routing, billing, change orders, etc.

Created and updated a plethora of SSRS reports that included but were not limited to the following types: Executive Summaries, Sales, Invoices, Transactions, Fraud, Accounts Payable (AP), Accounts Receivables (AR), Reconcilement, Proof of Concept, and Aging Reports

Created and updated SSRS reports that were parameterized based subscriptions that were emailed, scheduled to be placed on secured file shares, or both.

Created SSRS reports that were parameterized based user engaged interactive solutions that allowed end-users to provide inputs, run, and then save the outputs to multiple file formats such as Excel, CSV, PDF, and the like.

Created and updated SSRS reports that had daily, weekly, monthly, or quarterly frequency run times

Created, configured, and updated shared data sources that were consumed by a plethora of SSRS objects that included the following: Shared Datasets, Embedded Transact-SQL (T-SQL) queries, or Stored Procedures.

Created and updated SSRS parameterized shared datasets that were children to shared data sources, which the shared datasets were sourced from stored procedures. Created ad-hoc SSRS reports as they were requested.

Every report that I created or updated was used in conjunction with Team Foundation Server (TFS) repository.

Spearheaded all requirements gathering and development efforts for Sales and Finance pipeline BI projects.

Maintained GP’s legacy Enterprise Business Unit Billing Application projects and owned reporting initiatives.

Managed daily, monthly, and quarterly billing reconcilements process.

Updated stored procedures and complex SQL-Server Data Warehouse as needed. Utilized SSMS to have written T-SQL scripts against the SQL Server 2008 EDW Managed enterprise-wide ad hoc reporting requests to meet business needs.

Worked heavily with InfoPath to complete various input data needs for users. Encompassing Monthly Revenue Recognition Processes, Purchase(aka Service) Orders (including Change Order and amendments), invoice injections, client contact update forms, open side notes for on going project entry needs and the like.

Learned accounting calculations and understood the debits and credits of the transactional day to day data and need of the accounting production database of BST. Able to understand the terms and know the formulas for things such as Project to Date(PTD), Month to Date(MTD), Effort, Revenue, Costs, Work in Progress(WIP), Backlogs, Effort to Complete or Effort at Completion, Percent Complete, Variances, Rolling Averages both monthly and yearly, Budgets and Yearly Budgets, End of Month and End of Year processing, Workflow Routing for various accept/reject/edit scenarios, and batch processing.

SharePoint usage is also prominent for deploying InfoPath forms as well SSRS reports. Managed subscriptions for SSRS monthly bursts to Project, Department, VP, and Business Unit Managers. Created ETL processes in SSIS that would pull data(CAML query filters and SharePoint adapters) from SharePoint list/libraries for data normalization and pump it back into SQL server.

All of the aforementioned SharePoint, InfoPath, and SSRS work has given me great proficiency with XML, XPATH, XSLT, CAML, and PowerShell.

Familiar with Power BI and Power Apps to utilize and mitigate costly code maintenance/development.

oCreated Dashboards and data input apps as well as live feed data analytics for accountants which would only show their owning or working-companies data based on user access.

Knowledgeable with Active Directory and AD Groups for security access and restrictions.

IIS utilization to manage site/server maintenance and access. Would also bar entry during monthly processes

Created, deployed, and maintained many invoices for billing in SAP Crystal Reports.

Contact this candidate