Experienced business intelligence professional well-versed in mining data, developing database objects and generating reports. Detail-oriented and systematic with excellent follow-through and a superior work ethic. Great Knowledge base of Enterprise File Transfer tools, Application Packaging tools and Active Directory related role based permissions. Excellent communication, project management and problem-solving abilities with reputation for resolving problems and improving customer satisfaction.
Overview
8
8
years of professional experience
Work History
Business Intelligence Developer
Hallmark Global Technologies Inc
Hauppauge, NY
07.2021 - Current
Experience in developing Custom Reports Linked, cascaded and parameterized reports and worked on Drill Down and Drill-through Reports and Sub Reports using SQL Server Reporting Services (SSRS)
Solid Windows-based frameworks organization abilities in a Cloud or Virtualized environment
Create the FTP/SFTP tasks based on the gathered information and create tasks using MOVEit application
Use PowerShell scripts to automate multi step logics and schedule the jobs
Establish the host connections using the Port Open Requests and the Firewall requests by having necessary approvals
Create the GRID and use the MOVEit central process and DMZ to communicate between ExxonMobil and XTO networks
Use Go anywhere application to create the PGP keys based on rolebased access
Use the FTP and SFTP channels to connect to the host and create the task using the secure connections
Experience in .MSI and worked with various applications for Software Packaging
Also worked on unattended install methods like silent install using Install Shield Admin Studio, SMS
Experience working on Wise Package Studio 4.x/5.x/6.x/7.x, Install Shield Admin Studio 5.x/6.x, Wise for Windows Installer and SMS Installer
Strong knowledge of Windows Registry system, File System, Security
Experience in working on Custom Actions and used VB Scripts, WMI Scripts and Wise scripts to customize the applications
Worked with Batch Files to create Silent Installs and permissions
Worked on Debugging tools like Filemon, Regmon, Procmon and Dependency Walker to assign permissions and missing files
Worked with ORCA to edit the MSI tables, Merge Modules and created Transforms (MST)
Experience in System Analysis, Design, Development and Quality Assurance testing of Web applications, Client/Server applications and GUI applications
Excellent communication, Project Management and interpersonal skills
Creating, deploying and monitoring the Azure Data Factory Pipelines
Used Azure DevOps to deploy the Data Factory pipelines from Dev to Test and Production and created User Stories under different Features and helped in PI planning meetings
Created Linked Services, Triggers, Datasets and Data Flows as needed for the ADF Pipelines
Design, deploy, and maintain various SSRS Reports using SQL Server Data Tools
Created Custom Reports for Accounts department including Job Cost and Billing using SSRS 2017
Converted Crystal reports into SSRS 2017
Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2017
Designed different kinds of reports like Linked, cascaded and parameterized reports and worked on Drill Down and Drill-through Reports and Sub Reports
Created new database objects like Tables, Views, Stored Procedures, Functions, Indexes and Views using T-SQL
Prepare technical documentation of the newly created jobs or existing jobs and changes, to make it easier to our internal On-Call support member to figure out any production issues.
Electronic File Transfer Specialist
ExxonMobil
, TX
07.2017 - 06.2021
Responsible for data communication and integrations, security and automation solutions that provide efficient and cost saving solutions to business needs
Implementing tasks for XTO which automate business process to retrieve timely data from
Field operations and providing a cost savings
Migrating and updating XTO Financial processes to use a different vendor modifying and implementing new requirements
Production support Activities, troubleshooting, High Availability & Disaster Recovery
Move files to and from the trusted network to/from the DMZ using a combination of
MOVEit Central, MOVEit DMZ, MOVEit Freely and PowerShell
Monitor tasks that runs every second and also support them during the failure
Upload, download, push and pull files and resources of virtually any name across any languages via Moveit
Updating and implementing new PGP Keys each year used for encryption, decryption and digital signatures for secure financial transfers
Secure binary file transfers which were initiated using SFTP
Other technologies used: PowerShell ISE, Slack, Github, Remote Desktop Connection Manager, Notepad++, CyberArk, Active Directory, Windows Server 2012, Windows Server 2016, Windows Server 2019
Automate multi-step logic-based workflows and implement business process rules and create scripts.
Application Packager
XTO Energy
Fort Worth, TX
06.2014 - 06.2017
Repackaged application to Windows Installer format (MSI files) using Wise Package Studio 5.6, Install shield Admin Studio 2013, and Install shield Editor
Implementing tasks for XTO which automate business process to retrieve timely data from
Field operations and providing a cost savings
Configuring vendor supplied MSI using ORCA to create transforms (.MST) according to the client requirements
Admin Rights Remediation’s of the packages by applying Shims using Application Compatibility Tool Kit
Used Filemon, Regmon and Advanced Registry Tool for monitoring the files and Registry Keys Accessed by the application as part of troubleshooting
Expertise on writing VB Scripts for the application installations and editing the Registries and creating custom actions
Good Knowledge on how to apply Shims and give permissions to Files, Folders and Registries to remediate the applications
Checking the application mitigations by using Standard User Analyzer and Application Verifier
Experience on PowerShell scripting for the application installations
Experience on Admin Rights Remediation project for the applications that are having compatibility issues
Advertised and managed packages and collections in SCCM environment
Performing Quality Analysis of packaged applications done by other packaging engineers
Creation and Implementation of Transforms (.MST) and Patches (.MSP) within a package
Performed extensive package testing on VMWare Workstation 5.0.
Kroger
Cincinnati, OH
12.2013 - 05.2014
Created MSI application packages using Wise Package Studio 4.0
Created packages for vendor developed applications
Worked with VMWare to image/reimage the XP boxes
Used Filemon, Regmon to debug runtime errors in a locked down environment
Worked on various scripting tools like VBScript, and Wise Script to meet certain customizations required by some applications
Worked on VB scripting to customize the applications
Worked on various technologies like transforms, setup capture, conflict solving
Worked with SCCM for software distribution
Hands on Experience with IEM packaging
Involved in development work, integration of products into the current environment, testing and debugging.
Education
Masters in Business Administration -
Master’s - Information Technology
Master’s - Sciences
Bachelors - Sciences
Skills
Business Intelligence Analysis
undefined
Timeline
Business Intelligence Developer
Hallmark Global Technologies Inc
07.2021 - Current
Electronic File Transfer Specialist
ExxonMobil
07.2017 - 06.2021
Application Packager
XTO Energy
06.2014 - 06.2017
Kroger
12.2013 - 05.2014
Masters in Business Administration -
Master’s - Information Technology
Master’s - Sciences
Bachelors - Sciences
Similar Profiles
Dharani Tej RushyasrungaDharani Tej Rushyasrunga
Account Manager at Hallmark Global TechnologiesAccount Manager at Hallmark Global Technologies