SUMMARY

• Innovated Business Intelligence (BI) software, leveraging ETL to extract content and load into a SQL/Oracle database or PowerPivot, added full - text search capability, delivering actionable Analytics.
• Trained for Oracle and manager for major organization-wide Web Portal with SQL-Server. Skilled in PL/SQL, Java, C#, ASP.NET, VB, XML, Perl, PowerShell, JavaScript, HTML.
• Developed Automation and Business Process Improvement (BPI) software, incl. automated routing 3K+ business critical multimedia files, account creation and 100K+ interactive CMS paths for 4K+ users and text processing.
• Set up and directed $1M technical resource centers including 4 computer laboratories, up to 70 PCs & 20 MACs, supporting up to 15K+ users.
• Managing and analyzing LOB databases, development of database driven websites, web spiders, inventories and repositories in .Net and SQL.
• Analytical, Structured, Detail-oriented, Procedural, Systematic.
• IT Project Management, Requirements, Systems analysis and integration, Testing, Reporting, Documenting & Training.
• Self-starter, Strategic, Author of professional blog with 1250 articles and 200k+ visits, Highest rating for Leadership in last Annual Review.

TECHNICAL SKILLS

Data analytics: Excel, with advanced worksheet formulas etc., Power Pivot, Power Query, Power View, Power Map, macros)., SAS

Databases: ORACLE SQL and PL/SQL, MS T-SQL, XML.

Text analytics: NLP dkPro (Stanford CoreNLP, openNLP, UIMAfit, mate-tools, sfst), NLTK; Corpus linguistics WordSmith Tools, Voyant.org, AntConc; TEI, Unicode;

Programming: Java, C++, C#, .Net, MS-Exchange SDK, MS-Media Encoder SDK, Resharper, MS-Enterprise Library, ASP.NET, VBA.

Scripting: Bash scripting, PowerShell, VBScript (including for HP ALM/UFT), AutoIT, Perl, Python, JavaScript.

IDE: Visual Studio, Eclipse, Maven, Source Control Git. Groupware MS-SharePoint, MS-SharePoint Designer, MS-Exchange (EWS, Calendaring, Resource Scheduling). SDLC and Testing Atlassian Confluence, Jira, Jenkins. MS-TFS (Team Foundation Server), Git. HP ALM with QC and UFT.11.53/12, Testing Anywhere 9.2/4.

Business Analysis Tools: UML MS-Visio, PlantUML, Graphviz.

Project Management Tools: Redmine, MS-Project. CMS Drupal, WordPress, Joomla.

Office: OneNote, PowerPoint, Word (with MS-OpenXML SDK, PowerTools for OpenXML, macros, forms, content controls, building blocks, styles, templates, document variables, fields, protection, indexing, glossing, master and reference documents, custom dictionaries and add-ins, reference managers like Zotero), LaTex, Doxygen, Google-Apps. IT service management ServiceNow, IBM Tivoli Endpoint Manager (TEM), BMC Service Desk Express, MS-Active Directory, Symantec Ghost, Faronics-Deepfreeze, MS-Steadystate, Sysinternals. Platforms Windows (all), Mac OS X, incl. Server, OS/2, Linux (Debian, OpenSuse, Google-Android).

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Richmond, VA

Responsibilities:

• Supporting and updating several dozen large financial models and data-driven Excel, Word and Outlook automation tools for the underwriters, using Microsoft Office 2016 VBA, Ribbon XML and Teradata SQL.
• Static code analysis and code documentation.
• Reengineering existing financial models using Power Query for ETL and PowerPivot for analysis.
• Developing new features for credit data analysis.

Office developer

Confidential, Chicago, IL

Responsibilities:

• Developing ISIWriter Word ribbon add-in for ensuring compliance with FDA regulatory documents, using Visual Studio 2016, Microsoft Word 2013 and 2016, Excel 2016.
• Gathering software requirements from regulatory SMEs and writing functional and technical specifications.
• Developing new ISIWriter Word ribbon add-in, using C#/VSTO, to automate document formatting (Captions, Citations, Document Layout, Equation tools, Formatting Tools, etc.) and compliance Document Checker.
• Integrating ISIWriter with Enterprise Document Management Software and Workflows (SOLID4, solid3, eDocsDM).

Office Developer

Confidential, Chicago, IL

Responsibilities:

• Gathered contract requirements form financial and legal SMEs.
• Developed VBA automation tool to analyze, inventory and cleanse financial contract intake, using MS-Word and MS-Excel 2010 and 2013 (listobjects, pivot tables, Office interop, T-SQL and DAO).
• Debugged Ribbon add-in accessing contract blob elements from SQL Server, using C#, VSTO, T-SQL and Visual Studio 2013.

Data Analyst, Federal Employee Program

Confidential, Washington, DC

Responsibilities:

• Reviewed processes, created documentation and workflow diagrams; evaluated production processes. For 9000+ spreadsheets of health care cost and performance data and 60+ VBA tools which are running the $0.25bn health-care incentive program due in May and Jun, added auditing, inventorying and documentation automation through VBE extensibility, industry-standard tools and custom programming. Generated spreadsheet documentation for audits.
• Developed methodologies, approaches, and concepts to solve business problems and answer analytical questions. Refactored spreadsheet formulas, introducing structured references, conditional formatting, index/match for vlookups, and PowerPivot data model for relations, PowerQuery and M language for ETL. Automated several ETL processes using VBA and MS Query. Improved validation and reporting using formula generation with structured references and Pivot tables.
• Delivered technical analysis to the Plan Incentive Program. Provide analytical support to the FEP Incentive Program. Consolidated code in a departmental add-in with Ribbon interface, refactored, parameterized and implemented other OO programming principles.

SDET

Confidential, Rockville, MD

Responsibilities:

• Using Excel PowerBI, PowerShell, XML, VBA, OneNote, documented, for migration to Selenium, a Testing Anywhere-based automated software testing infrastructure, comprising 750 Testing Anywhere scripts, 6 servers, 1.3Mio test artefacts, for the ClientLetter (Windows&Web) DOCCM product,
• To generate a documentation store, using Excel, VBA, AutoIT, and PowerShell, programmatically extended Testing Anywhere infrastructure with automated code exporter, for improved code analysis and source control in Git, with a searchable test results archive, based on 250 daily notification files, and test result statistics, and with config tool and job queue.
• Using Testing Anywhere script and PowerShell, programmed automated software tests and managed test runs for daily build and rapid releases (smoke and regression, functional and interface testing), including automation troubleshooting, defect tracking, result reporting for Client Letter (both Windows and Web versions). Debugged the Testing Anywhere legacy codebase.
• Using Atlassian Jira & Jenkins, Slack, participated as automation test engineer in SDLC of a geographically distributed team (sprint planning, burn down charts, backlog tickets) of an RTF-based document composition DOCCM product line with SQL Server/ORACLE back ends running on Windows Server 2012, SQL Server 2008, SSMS, Windows 8, Apache Tomcat with Zookeeper an ActiveMQ.

VBA Developer

Confidential, Washington, DC

Responsibilities:

• Document and noledge management and technical writing for a multinational financial organization with a $0.75trillion balance sheet and active in over 180 countries.
• Working with users and IT, administering and improving 800 templates for Fund accounting and financial research and reports (including asset price lists, interest and tax rates and other market data) and 7000 publications. Managing software rollouts and upgrades from Office 2007 to Office 2013/2016/Office 365.
• Developed fund-wide template usage tracking interface in PowerPivot. Documented template infrastructure in Excel and PowerShell.
• Code behind analysis and refactoring and front end-Word feature inventory and redesign with Aivosto, MZ-Tools and Rubberduck and my own VBE extensibility and VBA code. Developing a team source and version control infrastructure in MS-TFS (Team Foundation Server) and Git. Developing automated software testing using HP ALM/QC QTP/UTF.
• Documented configuration and installation of a Digital Signage Product for a government client (DOE).
• Reconfiguration of a SAAS product for implementation in the offline data center of a government client.

Technologies: MS SQL-Server 2012, Windows Server 2012R2 (Schedule Task), Excel, PowerShell, video transcoders.

Information Analyst/ Tech Writer

Confidential,Davidson, NC

Responsibilities:

• Driving the specification and implementation of the documentation infrastructure for Confidential . The infrastructure comprises tools and services for maintaining a single-source for technical documentation, including: document generation and data extraction, Office GUI customization, user-driven and automated document composition, document transformation, including to HTML5 for Wiki and integration with Doxygen, WordprocessingML programming, reference library setup, integration and management, m editor review and authoring, semantics and metadata research and readiness for HTML5 and SharePoint.
• Delivering MS-Word templates and styles for code documentation of Fortune 50 retailer, MS-Word templates for resume of HR, project status reports and client documentation of PMO, MS-Excel spreadsheets for project and software documentation, documentation on Confidential ’s documentation infrastructure; internal multimedia training materials and reference document collection.
• Delivering UML diagrams for Confidential 's POS thin client software for a Fortune 50 retailer and for Confidential ’s credential GIT and SSO architecture for end users, system admins and architects.
• For Confidential 's POS thin client software for a Fortune 50 retailer, documented C++ application, using Doxygen and Eclipse CDT.
• Day-to-day management of ongoing client projects in telecommunications and retail, including daily standups, status reporting to the client and coordination of resources.

Information Analyst

Confidential,Charlotte, NC

Responsibilities:

• To gain learning analytics insight for decision support, analyzed student enrollment, assessment, resource utilization (classroom, computer), using MS Self-Service BI.
• To plan, monitor and troubleshoot center usage, introduced, designed, programmed in VBA, set up, maintained, analyzed and produced reports from numerous databases of 15k p.a. 15k customer contact and order data p.a. with ETL from institutional information systems (Report Express), 3k p.a. assessment, inventories (of 12k digital assets, with ETL, hardware and software) and (application, issue, usage) log data, designed utilization dashboard reports using calendar analytics for over 100 bookable resources.
• Defined, architected, developed and tested automation software for computer testing center and help desk management, LOB document generation using text parsers and machine learning, image and text-to-speech generation.
• Defined, architected, developed and tested systems integration software to automate ETL of data collected in the Confidential into the MS-Exchange system, using C#, MS-Exchange Web Services, MS-Enterprise Library, emitting XML exception data for root cause analysis during debugging, and XML configuration data to enable customization, planned and executed test cases, UAT.
• While directing Confidential upgrade project, managing governance and supervising 25 part-time functional resources and 1 full-time Business Analyst, elicited and analyzed SME business and functional requirements, identifying and managing technical interdependencies for seamless integration with existing infrastructure, identified and scheduled deliverables, defined roles and responsibilities of team members, working with central IT and programmers and Project Manager, negotiated key SLAs.

Information Analyst

Confidential, Baltimore, MD

Responsibilities:

• Oversaw center maintenance and enhancement, supervising software and hardware upgrade in 25-seat computer lab and managing 12 part-time staff members. Managed media servers, media libraries, and digitization offices.
• Leadership and stakeholder management when introducing to business partners on communication / collaboration tools (network shares, MS-Exchange Calendaring/Scheduling, MS-SharePoint, Web publishing, Communicator, Content Management System (CMS), WebDAV).
• Improved staff/client collaboration by creating a helpdesk with an online noledge base (bulletin board, wiki), an online staff and client training website with online documentation, a staff training and performance tracking system
• Set up and did web analytics and data cleansing/ETL on a Web Portal in C# dat me developed, tested and administered, an OLTP groupware with FTS for collaboration, on IIS and a SQL-Server backend.

Information Analyst

Confidential

Responsibilities:

• Managed project to upgrade the City of London conference interpreting facility using requirements gathering and IT Financial Management through market analysis and vendor comparison.
• Managed project to digitize and provide documentation for existing software system, including authoring training to end-users, defining, architecting, developing and testing an assessment collection software and system-integrating it.
• Using MS Self-Service BI, analyzed requirements, based on self-developed Excel VBA application.

Information Analyst

Confidential

Responsibilities:

• Hired as founding manager of a Confidential to introduce e-Learning into the school. Developed internal and external proposals for Centre growth and expansion in line with organizational strategic goals, conducting feasibility studies including resource utilization. Risk Management for copyright and licensing compliance, policies, regulatory requirements, and accessibility. System-integrated LOB software and digitized LOB documents. Supervised 2 staff (AV technician & Support Engineer).
• Planned, tracked and managed SDLC for new software, creating a Project Management Plan and other artifacts. Risk assessment on project delivery, implementing procedures for mitigation including timeboxing.
• Defined, architected, developed and tested ETL automation softwares for content system to upstream 100k+ requests and 4k p.a. student records from central student information system, downstream 30k datasets to Excel and file system, in order to develop an e-repository of materials.