Power Bi Business Intelligence

*

Name Mamatha Kaushik

Technical Skills

ColdFusion, Coldbox-MVC Framework, ASP.net, C#, jQuery,

JavaScript, Python, Informatica PowerCenter, PL/SQL, Oracle, SQL Server, MS Access, PowerShell, OLAP, SAP Business Objects, WEBI, Google Analytics, Power BI, Tableau, Data Science libraries (Pandas, NumPy, Matplotlib, Seaborn) Clearances DoD Secret Clearance

Degree/Education

• BS Business Administration, CDE, Bangalore University

(June 1995)

• BS Computer Science

VVSFGCW, Bangalore University (April 1994)

Total Years of Experience 22 Years

Certification Certified Defense Financial Manager

Summary of Qualifications and Experience

Summary of Qualifications

More than twenty (20) years of experience as an IT professional involved in Project Management, research, design, development and maintenance of web applications.

• Identification and work on system gaps and workflow for automation.

• Sharepoint site content management and design self-serve solutions for the team.

• Data integration, management, and product development experience in FAA’s Air Traffic Organization (ATO) Data Management and Reporting team.

• Software application development and maintenance of DOD Army PPBE Budgetary system.

• Other domains include - Internet Banking System, Portfolio Performance Management System, Hospital Management System, Life Insurance, and Library Information Management System.

Experience working in leveraging business intelligence ERP COTS solutions like SAP Business Objects, SAP WEBi, Tableau, and Power BI for data integration, analysis, reporting and building of dashboards. Experience in implementing RESTful API’s. Data integration experience across multiple platforms, formats and systems (OLTP, OLAP). Experience in development of functional and technical requirement documentation. I have contributed to organizational organic growth by providing ideas for systems integration, process improvement and identifying business and technical development opportunities. Programming skills in ColdFusion, ASP.net, C#, jQuery, JavaScript, Python, Informatica PowerCenter, PL/SQL, Oracle, SQL Server.

2

Professional Experience:

Systems Analyst / Programmer Analyst Lead June 2022 – May 2024 CACI International, Chantilly

• Working as a developer in RM Online Innovations, a RMF certified DOD-PPBE Budgetary system for Army commands, hosted on ARMY Resource Cloud.

• Identify system gaps and work on solutions to resolve them.

• Suggested solutions to reduce operational cost by automation of HelpDesk.

• Work on content management and design of RMOL Sharepoint website.

• Suggests business development opportunities by providing proof of concepts and delivery.

• Identify system gaps, risks and security vulnerabilities within RMOnline and work to resolve cyber threats.

• Build solutions to automate/streamline repeated tasks.

• Work on tasks that involve improvement of screens, data modelling and reports across all modules in RMOnline.

• Creation of database views and use of built-in component for raw data export and ingestion by the Business Intelligence community.

• Work on tasks that involved new look and feel, data integration and reports pertained to Personnel, and Manpower Documentation (TDA) modules. The reporting format being exporting to Excel and PDF for further data ingestion by Business Intelligence community.

• Development of ColdFusion web pages and JavaScripts to support ARMY Budget MACOM, Field, Manpower POM (PBG), Personnel, and Manpower Documentation

(TDA) modules

• Work on enhancements and Software Change Requests geared towards PPBE workflow within RMOnline from Budget Preparation, Schedules, to Phased Obligation Plan (POP), Un-Funded Requirement (UFR's), Funds Authorization Document (FAD) in Execution module and reporting.

• Day to day responsibilities include working on Software Change Requests (SCRs) created for enhancements, maintenance, and development of unit test cases.

• Interact with functional leads and provide customer support and log them for required metrics by upper management.

• Work to resolve issues identified during Fortified scan that identify security issues. Involved in technical design documentation to support enhancements, work with technical writers to produce functional documentation.

• Continue to train and work on new technical and data management skills.

• Technical skills: Sharepoint, Coldfusion, Javascript, JQuery, Oracle, SQL, PL/SQL, HTML

3

Sr. Software Developer/ Manager July 2017- May 2020 CSSI Inc, Washington DC

Client: Federal Aviation Administration

• Manager involved in leading team’s requirement gathering efforts, providing proof of concepts and submission of weekly-monthly activity reports to the clients.

• Handling of timesheet approvals for the team.

• Worked on SAP Business Objects Business Intelligence and BI Semantic Layer to consume data using various RESTful APIs (Report Elements, data providers, documents, SAP BO Universe). Leveraged SAP CMC to validate the security settings, including row level security, for the users groups and folders data from consumed endpoints.

• Developed SAP Business Objects WEBI reports and drill-able dashboards for data analysis and dynamic reporting to meet organization’s business requirements. Used Query Analyzer to build queries and retrieve data from SAP BO Universe.

• Developed and delivered help documentation to the client to support the WEBI reports.

• Used Power BI Desktop as the visualization tool and consumed date from various data sources including Excel, Text/CSV, JSON, SharePoint, ODBC, databases, Web Sites etc.

• Developed presentation slide deck to present ColdFusion API Manager as an authorization gateway for RESTful Web Services. Validated use of various authentication methods including API Key, Basic Auth, OAuth 2.0.

• Implemented handlers, model and views and created RESTful API’s in Adobe ColdFusion ColdBox MVC Framework to access the FAA Runway Safety Tool Risk scores, QA Safety Metric Codes, NAS scores

• Worked on presenting Year-End-Close-Out (YECO) data by working on Oracle views and coordinating ETL jobs to extract, transform and load to new tables in readable schema objects for reporting purposes.

• Installed and configured Adobe ColdFusion API Manager 2016 to use it as an API Gateway.

• Extensively used ColdFusion API Manager Admin portal to configure Data Store, Users Profile, Service Level Agreement.

• Used ColdFusion API Manager Developer Portal to create and publish RESTful APIs.

• Converted SAP QAAWS SOAP services to RESTful Web Services for consumption.

• Made API’s catalog available for Subscribers by publishing to registry

• Tested the consumption of each Published API’s for seamless consumption of data in JSON Format.

• Worked on designing and development of Common Access Tool for managing access requests to Air Traffic Organization Portal tools

• Developed PowerShell scripts to merge multiple data files, consume data from SAP BO RESTful Web Services.

• Developed Python code to unpack and work with columnar storage data, Parquet, Big Data Hadoop files.

• Created system requirement document for enabling SAP RESTful Web Services usage in FAA and proposed portal to house custom application for data catalog.

• Maintained Change Control Board (CCB) documentation.

• Maintenance and enhancements of FAA’s Voluntary Safety Reporting Program (VSRP) - Partnership for Safety websites. Worked on a new look and feel of the websites. 4

• Developed custom dashboard using Google Analytics to report on website traffic statistics.

• Used raw server log files to capture website page hits and other useful information in excel and presented it using pivot tables and charts.

• Configured IIS for serving ColdFusion web pages. Technologies: SAP Business Objects 4.x, Microsoft Power BI, ColdFusion API Manager 2016, SoapUI, Postman, ColdFusion 2016, ColdBox, ColdSpring, Oracle 11, Oracle 12, TOAD, SVN, PowerShell, SQL Server, IIS, JavaScript, Python. Software Developer 3 Nov 2010-May 2017

CACI, Chantilly, VA

Client: DoD Army

• Involved in application design and development for DOD-PPBE Budgetary system RM Online for Army commands including Army National Guard (ARNG), Acquisition Support Center (ASC), AMC, CID, INSCOM and OPMG.

• Developed ColdFusion web pages and jQuery JavaScript scripts in support of Army Budget MACOM, Budget Field, Personnel Management, Accreditation, and Manpower modules within RM Online application. Involved in technical requirements gathering and documentation. Responsible for enhancements and bug fixes in the application.

• Perform routine production support on RM Online application.

• Improvised code of ARNG’s NETDET, Request for Reprogramming, and Request for Realignment, and Turn-In-funds workflows in ColdFusion.

• Worked on enhancements and maintenance of various top-down and bottom-up work flow processes within RM Online. This included areas of FAD import into RM Online to distributions of funds to lower and subordinate commands using ColdFusion and Oracle.

• Wrote queries to derive required drill down reports to display the distributions of appropriated funds. Coded reusable custom components that display reports that helps ARMY clients in preparing Phased Obligation Plan and Requirements for the Execution year and POM years respectively using GFEBS, SOMARDS, and Stanfins data loads.

• Worked on creating jQuery library plugins to extend default UI features and coded interfaces in jQuery to improve end user experience with AJAX asynchronous requests. Also, coded to handle browser dependencies and produce cross-browser compatible HTML, CSS, and JavaScript code. Developed code to interface between JavaScript and Cold Fusion queries using JSON objects.

• Participated in technical documentation of RM Online Security Service Plan for DOD. Worked to standardize the code to match changing browser requirements and fixed security loopholes identified during Nessus security vulnerability scanning.

• Designed interface to automate regression testing using Python scripts to capture testing results in Oracle database and output via HTML and monitor the queue in Selenium distributed environment using Python utility packages.

• Provided inputs on improvements to merit/performance rating tool used by management.

• Provided inputs to business development opportunities by using the PPBE functional knowledge.

5

• Worked on preparing IPR’s for management, validated releases and participated in proposal writing.

• Created tables and Oracle PL/SQL stored procedures to support functionality enhancements within the RM Online application.

• Secured Certified Defense Financial Manager certification from ASMC. Technologies: ColdFusion 9/10, jQuery, JavaScript, AJAX, JSON, PL/SQL, Oracle 11, Selenium, Python, Visio, HTML5

Programmer Analyst Jun 2007- Jun 2008

Jack Henry and Associates, Lenexa, Kansas

• Development and support of Jack Henry and Associates, Internet Banking solution – NetTeller. Converted code from ColdFusion to .NET framework 2.0.

• As part of NetTeller online banking development team, duties included coding for priority bug fixes, enhanced look- and- feel, and single sign-on authentication of users. Experience with Agile and Scrum development methodologies. Performed production support on rotation and interacted with DBA’s, Development team, QA and Customer Support teams as required.

Technologies: ColdFusion, ASP.NET 2.0, C#, JavaScript, IIS 4.0, CSS, SQLServer. ETL Consultant July 2006-June 2007

American Century Investments,

Kansas City, Kansas

• As an ETL developer, worked on various American Century Investment financial tools that was tailored for individual investors and Investment Professionals. Worked to cleanse source data. Worked on Informatica Designer Tools to setup source, target and intermediate transformational mappings. Developed Slowly Changing Dimension Mappings of Type I and Type II to suit the requirement with necessary transformations to implement business rules. Wrote SQL Queries and optimized SQL. Worked with different source systems like Flat Files and Relational Databases and fine-tuned Informatica Mappings, Sessions and workflows.

• Used UNIX Shell scripting for automation of the process, invoking Informatica sessions. Technologies: Informatica PowerCenter 7.x, PL/SQL, UNIX Shell scripting Developer and Tester Feb 2004-Apr 2004

Yashasvi Technologies

Bengaluru, India

• Developed test plans and test scripts for Auto and Home loan application. Performed load testing and defect logging.

Technologies: Test Director, HP WinRunner, LoadRunner and VB. 6

Programmer Analyst Oct 2000-Jul 2001

United Logic, Inc,

Somerset, New Jersey

• Developed in-house portfolio performance management web portal that tracked individual investor portfolio and tools to calculate different financial metrics,

• As an add-on project, performed enhancement of Citizen Bank intranet application from MS Access to Classic ASP.

• Wrote data migration scripts and stored procedures. Developed GUI screens to support user interface.

Technologies: ASP, VBScript, MTS, MQ Series Middleware, MS Access and SQL Server Programmer Jan 1998-Oct 2000

Canarys Microsystems

Bengaluru, India

• Involved in development of Life Insurance application. Developed GUI screens and stored procedures.

Technologies: PL/SQL, Developer 2000 and Oracle

Programmer Feb 1997-Jan 1998

School of Computer Studies

Bengaluru, India

• Development and support of Patient Billing Information Management System. Technologies: Visual FoxPro

Contact this candidate