We provide IT Staff Augmentation Services!

Business Analyst Resume

SUMMARY

  • With several years of Business Analysis, Relational Database Management, database development and support experience with a strong technical background who possesses self - discipline and the ability to work with the minimum of supervision.
  • A Senior Business Analyst who can play a key role throughout the system development / support life cycle of a project to ensure that quality solutions meet business objectives, a quick learner who can absorb new ideas and can communicate clearly and effectively.

TECHNICAL SKILLS

  • Oracle and SQL Server Database Administration
  • UltiPro Core HRIS
  • Cognos BI reporting
  • Oracle PL/SQL and shell scripting
  • SQL Development
  • Oracle Forms/ Reports expert
  • Database Backup & Recovery
  • SQL Server 2012 SSRS
  • SQL Server Backup & Recovery
  • Database Auditing
  • Data Load and data integration
  • IT/ IS Trouble Shooter/Problem Solver
  • Business Information Management
  • Disaster Recovery using DB tools
  • Oracle Data Guard, Data Refresh and Replication expertise

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential

Responsibilities:

  • Supporting UltiPro Core HR application and Cognos BI Reporting
  • Providing quick and efficient solutions to HRIS users and project teams
  • Proving data integrity solution to project teams to move UltiPro Core HR data to Portal application
  • Developed more than 100 very complex HR reports and BI Alerts using IBM Cognos
  • Updated various BI Alerts, produced dashboards and propose advanced trainings to the users for developing BI dashboards and using Advanced MS Excel
  • Developed risk metrics reports for risk management reports on higher management request
  • Using Z process to improve process and data quality
  • Propose Jot Forms for HR form sharing and prepare an architecture to integrate an offline database with UltiPro Cloud
  • Develop various HR processes (proposed but not yet implemented)
  • Developed a VBA application to track project tasks, few paper based forms are computerized, Employee photo tracking

Lead Technical Analyst

Confidential

Responsibilities:

  • Developing Merchandising ERP modules (Oracle Forms 11g), enhancements, resolving defects
  • Retrofit Oracle Forms and PL/SQL procedures on daily basis for different clients across Canada and US.
  • Enhancement of EDI interfaces in Forms 11g in Merchandizing ERP, developing new Data models, documentation
  • Involved in Data Integration, Impact Analysis during upgrades, Support in development of data sources from Merchandizing application to third party reporting tools
  • Using SQL Server as Hub and Spoke technique for data conversion, designing some interfaces in MS ACCESS 2013 and 2016 for data conversion
  • Creating SSIS packages for database load and also using MS ACCESS (VBA Scripting) for data load
  • Recently developed Data Load application in Oracle Forms 11g
  • Technical Analyst at various projects, involve in database administration support, impact analysis and implementation
  • Working with Complex ERP tools (Documentation, QA, Process mapping)
  • Developing a Test Manager Application in MS Access 2016 for managing software testing teams
  • Developing Reports using VBA interface, SSA SSRS. Also involved setting up SSRS (services)
  • Working with Toad, Golden, SQL Developer, PL/SQL Developer, etc.
  • Implemented Oracle 12c with Forms 12c and Weblogic serer 12c internally for test purpose (Not used as Cloud database or advanced options of Oracle 12c)
  • Designed and developed CSV data load tool in Oracle Forms with FTP and history options
  • Analyzing cases and defects and providing a solution to client end
  • Provided a solution for Database Materialized view update
  • Working with a lot of tools including PVCS version control, Golden, SQL Developer, PLSQL Developer, VirtualBox and many internal tools
  • Preparing Business Development Records (BRDs)
  • Providing advanced level support to developer and clients in SQL
  • Data Modeling training to new hires

Database Administrator

Confidential

Responsibilities:

  • Developing Financial Applications Using MS Access, SQL Server 2012 Stored Procedures
  • Installed and managed SQL Server 2012 Failover Cluster
  • Created and managed partitions for tables and indexes
  • Developed backup and recovery strategies
  • Working with SQL Server 2012 SSRS, creating complex reports
  • Daily, Weekly (Partial), Monthly Full backup implemented
  • Involve writing complex stored procedures for financial packages
  • Designed and Developed Daily Debit Application (Mainly SQL Server Stored procedures dependent)
  • Effectively using Informatica cloud for data sync and replica tasks
  • Connecting Salesforce Data with SQL Server 2012 using Informatica Could
  • Developed DWH infrastructure model and user requirement collection matrix for BI
  • Recently developed complex financial applications and configure SQL Server Database Servers
  • Connecting Cloud data using Informatica and SQL Server, making user interface using MS Access
  • Excessive use of MSSQL Server Enterprise Manager
  • Created Enterprise Information Infrastructure model, currently developing physical databases for the same
  • Used Solarwind for SQL Server Performance Tuning Issues
  • Worked on SQL Server Cubes and Dimensions, Use VBA scripting as well of complex data extracting into Views for complex reporting
  • Amortization Application development using VBA scripting and reports generated in SQL Server 2012 SSRS
  • Many views created in SQL Server 2012 and linked with Informatica cloud for Salesforce

DBA and Developer

Confidential

Responsibilities:

  • Maintain Database Labs of 80 computers for more than 1000+ students and 360 Staff
  • Contributed in HRIS in-house ERP system, supported Biometric data load process at least for five years
  • HRIS process development, Module testing, impact analysis
  • Installation/ Upgrade/ Consultation services, training, Implementing Database Security (Technical, Physical and Procedural)
  • Implemented database replication using Database links. Provided a parallel database environment based on distributed database environment for developers
  • Worked intensively on Archive logs, planned flashback recovery, RMAN, make ready scripts for point in time recovery techniques
  • Performance Tuning Oracle Server for better Memory and I/O Performance using Oracle Enterprise Manager (OEM)
  • Work with SQL Server 2008 to collect biometrics data into daily attendance and payroll application.
  • Planned SQL Server 2008 transactional replication for disaster recovery, provided hints to IT support team for RAID 5 implementations
  • Creating Application repositories in database by creating database objects (Tables, Indexes, Packages, Procedures, Functions, Public Synonyms and Triggers, etc.)
  • Designed and Developed Database GUI based database auditing application with various parameterized reports.
  • Oracle DBA and Developer responsibilities + MSSQL Server 2008 Administration for Backup & recovery for attendance data
  • Database Auditing, Security and Performance monitoring, creating databases using Data Guard and Database Links
  • Oracle Development Using Oracle Developer and APEX, Developed Reporting Tools, Visitors apps, Library Search Tool, HRIS
  • Developer Team/ User Support for Connectivity, installation, configuration tools
  • Designed and implement various backup strategies including full database backup (offline/ online), Scheduled backup using RMAN and IMPDP and EXPDB
  • Installation of Oracle E-Business Suite for Training purposes
  • Heavily used Oracle Enterprise Manager 11g for database complex tasks including Query Analysis, data guard, replication, etc.

Hire Now