SUMMARY

• Highly motivated IT professional with MBA and Bachelor in Computer Information System with over 8 years of experience in consulting with different stakeholders to identify and gather business/data requirements, provide technical support to development team with software maintenance, defect triage, remediation of defects and deployment of applications.
• Experience in detailed process analysis and process mapping including current and future state (AS - IS/TO-BE) process. Skilled at performing GAP analysis, Risk analysis with the ability to put technical information into readable and well-structured documents.
• Proficient in preparing business requirements documents (BRD), defining project plans, writing systems requirement specifications and delivering project status report.

TECHNICAL SKILLS

• RDBMS: Oracle 10g/11g/12c, Microsoft SQL Server 2008,SQL Server 2012, DB2 and Netezza
• Cloud Tools: Oracle Financial Management, Oracle Planning & Budgeting, Oracle Business Intelligence and Oracle HCM
• ERP Tools: Oracle Fusion, MM, JD Edwards, JDA, Power Campus and Infosilem
• Project Management Tools: MS Project 2010,Jira, Confluence, Gantt Chart and WBS
• Workflow Tools: MS Excel, MS Word, MS PowerPoint, Erwin, BonitaBPM and Microsoft Visio
• Languages: HTML, SQL, PL/SQL, T-SQL, C, C#, ASP.NET
• Platforms: Windows XP, Windows 7, Windows 8, Windows Server 2008, Red Hat Linux and Centos
• Database Administration: Installation, Configuration, Upgrade, Troubleshooting and Maintenance
• Database Operations: Performance and Tuning, Backup and Restore, Corruption and Recovery, Auditing and Security, Managing login and Permission
• Database Development: Data Modeling, Database Creation, Data Conversion and Loading
• Data Mining Tools: Oracle Report Building, Graphics Builder and Excel Pivot Chart
• Data and Workflow Tools: TOAD, Oracle Enterprise Manager, Aginity, Sql*plus, Data Pump, SQL* Loader, Import/Export, SQL Developer, APEX, Putty, WInSCP and Xming
• Other Tools: Case Diagram, UML, DFD, ERD and Altova

PROFESSIONAL EXPERIENCE

Business Analyst,

Confidential, Laramie

Responsibilities:

• Conduct detail and comprehensive Business Analysis by working with the end users and other key stakeholders to identify the system, operational requirements and propose enhancements.
• Document the current process flow, business requirements and fit gap analysis for different modules of Oracle Fusion and HCM Cloud such as (Procurement, Expenses, GL, AP, AR, Performance Management, Payroll, Time and Labor etc.)
• Deliver Functional and technical specifications for the new solution integrations as a SME for Oracle EBS
• Design and develop the data flow among different systems that allow for integrated data reporting of student, financial, human resources and grant information and other informational sources for a single platform for reporting
• Serve as a technical lead for Enterprise Reporting system, develop and customize Oracle Transactional Business Intelligence (OTBI) and BI Publisher reports in Oracle and HCM Clouds
• Conduct User Acceptance Testing (UAT) and collaborate with QA team to develop the test plans, test cases and test data to be used in testing
• Handle SRs in Oracle dashboard and provide technical support to end users by corresponding with Oracle support group

Functional Business Analyst,

Confidential, 

Responsibilities:

• Implemented SDLC which include Waterfall methodology with requirement specifications phase and development phase.
• Worked with SMEs and technical ream to elicit functional requirements and translated them into technical requirements and design definition.
• Created and maintained system use case and UML diagrams, design use cases, software requirement and test cases for Scheduling System and Degree Requirement projects.
• Involve in meetings with clients to gather the necessary requirements, along with the formulation of the business process specifications to understand the complete application functionality.
• Created Business Work Flow Diagram using MS. Visio, defined and documented business process management for Scheduling and Degree Requirement setup Projects.
• Formulated and documented business requirements, translated them into detailed specifications.
• Identified and translated stakeholder requirements into different tangible deliverables such as functional specifications, use cases, user stores, business process diagram, graphs, dashboard and data flow diagram.
• Conducted GAP Analysis on the “Current” system and worked on the documentation of the requirements of the future Target” system.
• Design and gather project scope, project assumptions, business risks and high level descriptions of business processes by collaborating with different key stakeholders.
• Conduct meetings to identify project roadblocks and measure progress.
• Gather and document the AS-IS process from various departments, existing documentation and detail system analysis.
• Create Business Work Flow Diagram using MS. Visio, defining and documenting business process management for Scheduling and Inquiry projects.
• Prepare test case scenario and document test outcome
• Developed complex SQL Scripts to retrieve data from Power Campus.

Data Analyst,

Confidential,

Responsibilities:

• Implemented SDLC, Agile (SCRUM) methodology for the developing life cycle and followed the standard process in the application and elicited requirements from end users.
• Interacted with business representatives and subject matter experts to analyze, collect and document clear and concise mappings and data quality rules enabling the development of complex data transformations.
• Created and defined XML Message Schemas (XSD) and provided data mapping into XML structures.
• Developed Data mapping specifications using Microsoft Excel Tables and customized pivot table reports for viewers with different information requirements.
• Prepared and documented all data mapping documents from DB2 to MDR and from MDR-Netezza for BI Reporting.
• Queried the databases, built and executed complex SQL queries for data extraction, Transformation and Loading (ETL).
• Translated and identified data requirements, used in depth knowledge of data content and generated data mappings to enable data integration.
• Defined the source and target data mappings, business rules and data definitions.
• Supported ETL team through implementation of Data integration.
• Identified data inconsistencies between source and target data, applied transformation logics, rules and formats.
• Extensively involved in Data Profiling and Data Explorer.
• Documented Metadata in an Excel spreadsheet that serves as a consistent enterprise level standard at FGL.
• Worked with Solution Architect and Data Architect to provide input into the Enterprise Data Model in support of Master Data Management and Data Governance.

Database Developer,

Confidential,

Responsibilities:

• Installed application server, report server and Database Server.
• Analyzed business requirements and provided accurate technical work estimate.
• Designed logical and physical data model, Storage Capacity Management as well as Backup and Recovery.
• Successfully migrated data between different heterogeneous sources such as fate file, excel and SQL server 2012 using SSIS, BCP and Bulk Insert.
• Extensively used SSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, conditional Spilt, SQL task, Script task.
• Designed and developed complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, analysis reports and data reports.
• Developed front end using MS Access to enter data and to view report and established ODBC connection with the SQL Server 2012.
• Estimated development time and prioritized different tasks and accomplished workload efficiently through MS Project.
• Provided end user manual document.

Assistant Manager,

Confidential, Texas, USA

Responsibilities:

• Installed and purchased different computer peripherals such as desktop, laptop, printers in local intranet.
• Tracked and updated inventory.
• Prepared reports regarding sales volume, merchandising, developed and recommended marketing and sales strategies.
• Maintained awareness of market trends in the retail industry and monitored what local competitors were doing.
• Managed staff and assigned duties, determined staffing requirements,, recruited and trained staffs.
• Recruited, hired, trained and supervised staffs.

Businesss Data Analyst,

Confidential,

Responsibilities:

• Gathered requirements by interviewing stakeholders, business partners and end users. Deliverables: Business Requirements Document (BRD)/Software Requirements Specifications (SRS), Functional Specifications Document (FSD) and User Interface Specifications Document (UISD).
• Conducted GAP analysis and identified pain points and proposed process improvements
• Engaged with cross functional teams and documented in the Requirements Specification, Design Specification and Test plan documents reflecting the business needs.
• Used MS. Visio for model diagrams and Ms. Office package for Documentation and UML for class and visual modeling.
• Prepared ETL Mapping documents for every mapping and data migration document for smooth transfer of project from development to testing environment and then to production environment.
• Prepared and used test data/cases to verify accuracy and completeness of ETL process.
• Consulted with users, management, vendors and technicians to assess computer system requirements.
• Developed computer information resources, providing for data security and control, strategic computing and disaster recovery.
• Used SQL for retrieving and manipulating database for data validation and data integrity.
• Collaborated with cross functional team members to understand user requirements.
• Extensively used TOAD to retrieve, analyze data, fix errors and develop.