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.