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.

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: 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

Confidential, Boston, MA

Data Analyst

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

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

Axiom Law Services

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

Confidential

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

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

Responsibilities:

• 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.

Technical Writer

Confidential

Responsibilities:

• 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

Confidential

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

Responsibilities:

• 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:

• 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.