SUMMARY

• Pragmatic Senior Business Analyst with 6+ years of experience in Information Systems implementing a variety of projects in Service and Utility domains. Substantial expertise in ERP implementation(SAP and IBM MAXIMO), Software development methodologies (Traditional and Agile) and reporting experience with Cognos and BIRT. Functional and Technical experience in Enterprise - wide Information Technology solution implementation.
• Working as a Lead Business Systems Analyst, Fleet Manager, Project Engineer and Linux System Administrator.
• Extensive knowledge and expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Scrum, Agile (Extreme Programming, Test-Driven Development) and Scrum-Waterfall Hybrid software development life cycle environments.
• Hands on experience writing and documentation skills in creating, modifying and analyzing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirements Specification (SRS), Use-Case Specification document, Functional design document(FDD).
• Detailed understanding of preparation of RACI Matrix (Responsible, Accountable, Consulted and Informed) and Requirement Traceability Matrix (RTM) throughout the process to verify adherence.
• Proven expertise in developing Test Cases, Test Plans, Procedures and Traceability Matrix and documenting defects using HP ALM
• Used JIRA for creating use cases for the technical teams engaged in build, infrastructure and integration and participated in estimation and prioritization of the backlogs.
• Good understanding of reports utilizing SQL and IBM Cognos and developing long term, standardized reporting requirements.
• Developed, maintained regression test cases for Maximo V7.6.
• Quick learner with interest in and ability to master new technologies/tools and self-motivated team member who enjoys sharing new ideas.
• Good knowledge with Impala, Sqoop and Apache Spark.
• Working knowledge of hive queries.

TECHNICAL SKILLS

Project Management Tools: MS Project, MS SharePoint Server, PeopleSoft HR, Oracle Primavera Enterprise Project Portfolio and PeopleSoft Financial.

ERP tools: IBM Maximo, SAP ERP

Requirement Management: JIRA, Rally, HP ALM (application Lifecycle Management), MS Office and using Program Performance Center (PPC).

Testing Tools: HPALM (Quality Center), HP Selenium, CTD (Combinatorial Test Design)

Operating Systems: Windows XP/10,Linux -Red-hat, SUSE- Linux, HP-UX, Solaris and IBM AIX

Databases: MySQL, Oracle, DB MS Access, SAP HANA. PL/SQL. IBM InfoSphere Data Storage.

Languages: SQL, .Net. SAP ABAP(Advanced Business Application Programming)

Reporting: IBM Cognos 11.02, SAP Business Objects and SAP Crystal Reports

Middleware Tools: IBM WebSphere

Big data Tools: Apache Spark, Horton Works

PROFESSIONAL EXPERIENCE

Confidential

LEAD BUSINESS SYSTEMS ANALYST

Responsibilities:

• Gather business requirements using Joint Application Design (JAD) sessions. Develop, analyze and validate business models against requirements artifacts.
• Design Process Workflows for business rules to be implemented using MS Project Server and MS Visio (Integrated Portfolio Management).
• Analyze existing BPM (Business Process Models) using GAP Analysis and develop Decision making points that helped in enhancements.
• Estimate and Prioritize the proposed Development backlog worded as Project Change Request (PCR) format.
• Backlog grooming with Business Units Stakeholders in close collaboration with the implementation partners ensuring that the Acceptance criteria are agreed upon using Atlassian Jira.
• Developed user stories in accordance to the Business stakeholders and in coordination with the Build team which also helped in re-sizing the backlog for upcoming sprint.
• Document project plan using Work break down structure in MS Project Server to identify risks and estimate release dates of sprints and releases.
• Assist Project team at Confidential in developing the Work orders for Capital Projects using Oracle Primavera Enterprise Project Portfolio and in Oracle PeopleSoft.
• Identify Legacy system attributes and their matching field values in new ERP implemented system by developing Data Migration Design Documents (DMDD)s with the transformation logic developed using the business requirements.
• Identify and develop data points, frequencies, triggers and compliance regulations for the external systems to be integrated into the new ERP system (IBM Maximo). Documented the technical, functional requirements and workflows of the 133 Integrations and coordinated the audit evaluation of the artifacts in consensus with the external stakeholders.
• Develop Requirement artifacts for Functional Design Requirements and documenting, evaluating and maintain the lifecycle of requirements in HP-ALM (Application Lifecycle Management).
• Examining all applications in scope for testing and develop in-depth testing scenarios using black box, functional, performance, smoke and automation testing using CTD (Combinatorial Test Design and HP selenium and load runner. As many as 1300 test scenarios were developed for the project.
• Coordinate and evaluate the prototype configuration built in Eclipse IDE for applications running on JVMs in Sprint Retrospective meetings.
• Design and develop Data marts along with the ETL process logics for EDW (Enterprise Data Warehouse).
• Develop OLTP logic working with the Business Intelligence team by analyzing the existing legacy SAP Crystal reports and their mapping in SAP business objects.
• Develop ETL Strategy and evaluating the migration components built in SSIS and SSRS. Using PowerBI evaluated the data in consensus with the stakeholders.
• Develop queries and extract data using PL/SQL developer and MS SQL servers along with developer team which were executed on Oracle DB.
• Develop and Evaluate XML Files, FLAT Files and Error handling scenarios for middleware and Security teams.
• Develop Data profiling requirements and data models using Cognos 11.02 Framework. Analyze current production state of asset Suite- Cognos Integrator and incorporate the new designs into the Maximo-Cognos Integrator.
• Evaluate the data transformed using Cognos reports and also SQL queries and submit the test results for audit.
• Design, Develop and Implement of BI reports and Dash boards (Pie, Line and Combination charts) in IBM Maximo-Cognos and also in Tableau.
• Documentation of requirements and unit tests and results into Reporting artifacts RDD(Reports Design documents) containing Complex queries, joins, unions and interface designs with different prompts, calculations and filters for various kinds of reports that include list-reports, master-detail reports, Cross tab reports, chart reports, Drill down and Drill through reports.
• Develop the ER Models (Entity-Relationship) for the data models that were used for data migration and data-warehouse build.
• Designed the business process for the organization in PeopleSoft Financial module GL-FC90MA and PeopleSoft HR Module HCM91MAX for hiring and creating a new person record in the system.
• Design and develop business process for utilizing Oracle Primavera Enterprise Project Portfolio for creation and implementation of capital outage projects.
• Analyze critical Incidents from Business in Service Now and develop enhancement requirements after GAP Analysis.

Confidential

RESEARCH OPERATION ASSISTANT

Responsibilities:

• Develop the .Net code for developing Inventory management system for CMU owned Vehicles using Visual Basic 2009.
• Build the code for ordering rides in Pair - programming program for students in SAP ABAP.
• Migration of data from University production database - SAP HANA to Oracle DB using SAP NetWeaver 7.1.
• Used Google Analytics for providing the data analysis to help an efficient reorder of the inventory of the car segments (Premium, SUV, Standard, Compact) during vacation periods that would help them improve their customer engagement.
• Used FI-CO modules of SAP ERP for accessing the data and understanding the UI.
• Develop mitigation plan for grouped Service Now Incidents for University and submit to the deployment manager.
• Research and design metrics to measure performance using Bigdata using hive queries.
• Worked on datasets in Scala. Created datasets and loaded then into the DB using different dataset commands.
• Worked on creating distributed Hadoop Eco system on Horton Works to store and process the University data in Hadoop cluster.
• Configured and deployed Spark applications on cluster.

Confidential

DBA Admin/Linux Administrator/Project Engineer

Responsibilities:

• Worked as Linux/DBA Administrator for the project and did patch analysis on new patches for the systems and their impact on various components of the infrastructure (Storage, Middleware and UI).
• Worked as Fleet Manager and had to participate in the daily Change board calls to perform Risk-Analysis on the business impact of the latest patches team has put forward.
• Assisted build team in Risk Analysis of infrastructure risk and impact with the new Virtual servers built for REDHAT servers Versions 5, 6, 7.
• Installation and Configuration of latest patches using Oracle 10g client.
• Developed Unix/Perl shell Scripts to create new CRON Tasks in viEditor.
• Developed the architectural components for SQL database and web applications in the project infrastructure as a team.
• Research on performance improvements and identify and procedures and develop the code changes working along with development team.
• Worked on partitioning of Fact tables and created views to enhance better synchronization of data which improved performance.

Confidential

Linux Administrator/Project Engineer

Responsibilities:

• Assigned as SPOC for the complete offshore, for enhancement and migration of servers in the client infrastructure.
• Worked as migration analyst for Confidential from offshore and handled the migration successfully from offshore.
• Handled process training for New Hires and the existing Engineers
• Received several customer appreciations and management appreciations for showing exceptional commitment in supporting customers in their critical issues.
• Excellent assisting skills to peers and clients.
• Develop shell scripts and Cron Jobs that monitor performance issues.
• Built 2-node and 3-node cluster server infrastructure both in physical and in virtual machines. Tested the systems and introduced them to the development teams for utilization.
• Developed process standardization on Linux Kickstart and Solaris Jumpstart servers for upgrading the patches and created standard operating procedures (SOP)s for the same. These upgrades helped increase the system performance.
• Analyze security vulnerabilities and recommend improvements in network security at Enterprise level.
• Manage LDAP and NFS servers and monitoring and resolving security issues.
• Monitored server performance using SSH,SAR,VMSTAT and IOSTAT which helped the team in preventing resource exhaustion