Saravana Kumar Loganathan
312-***-**** *********@*****.***
4+ years of experience in Information Technology with expertise in Business Analysis in Retail, banking, marketing, sales domain. Excellent project management skills and capabilities in understanding IT business needs, business domain knowledge, formulating business goals and ensuring that projects meet design standards at delivery.
PROFESSIONAL SUMMARY
Experience in gathering requirements, developing and implementing Enterprise Performance Management using Oracle ERP, Oracle Financial Management, Data Integration Management, Financial Data Management, Financial & Interactive Reporting
Experienced in maintaining the Multi-Dimensional Databases using OLAP server, maintaining metadata and data loads for Financial Reports, oracle Essbase Spreadsheet. Experience on big data tools like Hadoop, Azure Data Lake, AWS Redshift.
Involve in creation of Test data for the automation test cases and to process the payroll via Excel sheet and SAP.
Proficient in SQL, demonstrated experience in Teradata and Big Data, knowledge of ETL and data warehouse concepts
Experienced in creating Data Visualization techniques by using Tableau and Advanced Excel tools, efficiently connect to data sources in integration environments, perform Data Analysis, trending, create reports, charts, graphs and dashboards
SKILLSET/TOOLS:
Requirements Elicitation Tools: Office 365, MS Visio, Axure, HP ALM, SharePoint, Salesforce, Confluence
Project Management/Methodologies: MS-Project, Rally, Atlassian Jira, AGILE – Scrum, Waterfall, Storyboard Mapping
Technologies & Analytics Tools: Advanced Excel, SQL, Tableau, ETL, Web services, R, Python, SAP Business Objects
Databases: MS Access, Aurora, DB2, Oracle, MS SQL Server, Teradata, Big Data
EDUCATION DETAILS:
Master’s from DePaul University – Mar 2018, Chicago
Bachelor’s from Information Technology – Hindustan University – May 2013, India
PROJECT PROFILE:
Bracket Global Pharmaceutical– Feasterville-Trevose, PA Business System Analyst Mar 2019 to May 2019
Worked on Smart supplies PMD, LDP, Master control Warehouse application for clinical trials.
Track bugs in Quality Center/ALM and reporting the defects to the developers for Modification Request.
Utilized Confluence to document high level business requirements, functional user stories, test cases, test scenarios in order to maintain end to end requirement traceability. Involved in Functional testing, Regression testing, Integration testing, UAT
Prepare BRD and FRD for the gathered requirements. Involved with writing test cases and execution of tests phases.
Maintain analytical worksheets, creating and development of dashboards, generating reports using Tableau.
Design, implement and validate 21 CFR Part 11 compliance strategies for LIMS.
Write SOPs for the training manual, maintenance to comply with 21 CFR Part 11and GLP requirements.
Assign tasks to work on Test Specifications (IQ, OQ, PQ), Application Design Specifications and Operational Handbook.
Execute the test cases using Quality Center based on the test plan and in accordance with Good Documentation Practices (GDP) and documented results as part of IQs, OQs and PQs.
Coordinate and track all projects for seamless releases using Project Management System JIRA.
Cloud Big Data Technologies, Texas Business/Data Analyst Aug 2018 to Feb 2019
Worked with developers, testers, and business users, stakeholders at various levels at different stages of the SDLC. Created test plan and test cases for user acceptance testing.
Built regression models and comparing performance metrics. Assisted in data mapping and integrated large dataset from old legacy system. Knowledge in piloting management approaches, testing before getting to processes for data storage and access.
Generated reports using python for Business users. Implemented data Cleaning through Python Pandas and NumPy.
Implemented various workflows within SharePoint to improve business processes. Maintaining web applications in SharePoint.
Collaborated with data engineers and operation team to implement ETL process, wrote and optimized SQL queries to perform data extraction to fit the analytical requirements. Used custom SQL level to pull the data in Tableau desktop and validated the results in Teradata SQL Assistant. Built multiple linear regression models and compared their performance metrics
Perform data Integration, data mapping on the source data from different databases like Oracle, SQL Server, MS Access and load it to Teradata. Working experience on slowly changing dimensions and creating SSIS packages and Informatica data mappings.
Assess machine learning, statistical analysis libraries (including regresses, classifiers, statistical tests, and clustering algorithms).
Creating reports for reporting applications that allows user to discover data, perform analysis using SAP business objects
Worked on various Testing types such as Integration, System, Functional, Regression, Sanity, Smoke, Mobile, User Acceptance Testing (UAT) and Performance Testing. Developed localization APIs which stores the translated data in Azure and SQL tables
Maintained analytical worksheets, creating and development of dashboards, generating reports using Tableau.
Built regression models, comparing performance metrics. Assisted in data mapping and integrated large dataset from old legacy system. Knowledge in piloting management approaches, testing before getting to processes for data storage, access.
Centene Corporation, Chicago Data Coordinator Analyst May. 2018 to Jul. 2018
Responsible for configuring Data Loader, uploading data in CSV files into salesforce, checking for data integrity.
Developed data models, algorithms to implement machine learning solutions. Performed statistical analysis to identify changes in data patterns. Validating data quality in the data warehouse, data transformation using ETL, data modeling in data marts.
Data profiling by writing SQL queries. Experienced in creating UNIX scripts for file transfer and manipulation. Developed an algorithm using R. Generated SQL scripts and deployed Medicaid, Medicare databases including configuration.
Implemented Security in Web Applications using Azure and Deployed Web Applications to Azure.
Used custom SQL to pull the data in Tableau desktop and validated the results in Teradata and snowflake database.
Created views using tableau Desktop and server that were published to internal team for review and further data analysis and customization using filters and actions. Created custom objects, fields- Leads, Dashboard, Sales using tableau.
Import data from proprietary database into Hadoop eco-system. Using Sqoop commands extract data from Hive table to oracle database. Generated reports and implemented data Cleaning through R and Python.
Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation. Knowledge of Facets support systems used to enable inbound/outbound HIPAA EDI transactions supporting HIPAA 834, 835, 837 270/271 transactions.
Converted the XML files into X12 and X12 to XML files on GIS for sending and receiving the EDI files
Wrote SQL queries to retrieve related data to support statistical analysis. Used Tableau for SQL queried data, and data analysis, generating reports based on data using SSRS. Conducted data mining, data modeling, and statistical analysis.
Performed data analysis by using Hive to retrieve the data from Hadoop cluster, SQL to retrieve data from Oracle database and used ETL for data transformation. Used Teradata for handling data migration from OLTP Source Systems to OLAP Target Systems.
Experienced in data migration & transformation from existing data stores to Hadoop. Developed Py-Spark modules for predictive analytics in Hadoop on AWS. Designed and implemented system architecture for Amazon EC2 instances.
Infocepts – Mc Clean, VA Sept 2017 to Mar 2018
Business System Analyst
Project: Our project was to design and develop an Enterprise Reporting System for financial services, to support the portfolio management and performance analysis of the Credit Card business with various reward offerings and to design a web-based end user interface, which involve OLAP reporting system implemented in Business Objects to provide business intelligence capability.
Used MS-Visio for flow-charting, process model, architectural design of the application and used SharePoint for sharing the documents related to the project. Also, used Storyboards as one of the requirements elicitation technique.
Involved in daily Team meeting to keep track of defects, provide updates on testing progress to Team Lead by importing requirements, creating test cases scenarios, validating and generate reports using Quality Center (QC).
Conducted Agile-scrum meetings, requirements gathering, writing user stories from Pain Points. Maintaining JIRA board for issue tracking and user stories. Also, conducted JAD Sessions periodically with stakeholders at various phases of the (SDLC).
Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP.
Worked on unit testing, Integration testing, System testing and Restful Web Services associated with a Flask Application.
Performed Test-driven automated testing with Selenium Web driver pulling test data from the excel sheet.
Managed and organized team activities, by assisting in the test case distribution, reviewing QA reports as a Team Lead.
Coordinated activities between Test Team and Project Manager. Performed code scripting with unit test as test module.
Automated regression test cases for website and generated execution reports to validate the results.
Expertise in writing Test strategy, Test Plan Preparation, Test Case Design, Test Tool usage, Test execution, Defect Management and Tracking. Developed extensive reports using Excel VBA macros, SAS macros, user defined python and R functions.
Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within tableau Desktop.
Responsible for facilitating the identified risks, and issues, by tracking these through the SDLC using Agile Scrum, scheduling team meetings. Designed and developed project document templates. Developed and maintained RTM for system requirements.
Worked on Gap Analysis to show current/proposed functionalities for the Data Migration Project, assisted development team to understand the TO-BE process by creating Data Flow Diagrams to defining the Business Process Model, Data Process Model.
Building API in HTML based on the requirements. Worked on the Data Modeling, Entities and Attributes of the Data points.
CSSCORP: Chennai, India Feb 2014 – Mar 2016
Business Analytics: The project was to integrate our payment processing systems with Third party platform, the peer-to-peer (P2P) payment feature, into banking application that allowed users to send real-time payments. The App which allowed our customers to use their existing contact information on their mobile device to securely transfer money or request money in real time processing.
Translated stakeholder’s business requirements into technical specifications. Created functional requirements, requirement traceability matrix, use cases, business process modelling. Expert in developing the V-lookup, H-lookup functions, Pivot Tables
Worked with LOB Risk Coverage Officer for high risk products such as cash vault, third party depository services. Managed testing process, schedule batch tests, log and track defects using QC.
Meeting business user to understand the requirement & worked in Agile Iterative sessions to create new data lake for client.
Performed technical analysis by employing effective interviewing skills to recommend solutions for the software applications.
Experienced in the use of BPM tools for Workflow Management, business process improvement, Business Process Optimization.
Designed the test scenarios and carried out both the SAP unit testing, systems integration testing and User Acceptance Testing in web .Net applications. Implemented Agile Methodology for building an internal application.
Worked with UI/UX designers and developing backend UI using HTML and JavaScript for mobile application.
Utilized ETL based Data warehouse for staging, data integration and combination of dimensions using Star Schema
Created tableau dashboards using stack bars, graphs, scattered plots, Gantt charts using show me functionality during POC.
Determined profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
Data migration from legacy systems to Oracle EBS. Implementation and support of Oracle EBS general ledger Operations.
Data mapping, integrated large sets of data from old legacy system to implement merchandise optimization software. Participated in daily scrum meeting with the development team. Data profiling & validation by writing complex SQL queries.
Collaborate with information technology, business management to establish a strategy of new CRM to meet business needs.
Converted the SQL Procedures to Informatica data mappings. Analyzed large datasets, gathered inferences using MS SQL to consolidate extensive analytics report. Advanced- level excel skills V-lookups, Macros, Conditional formatting, Pivot Tables.
Perform data Integration, data mapping on the source data from different databases like Oracle, SQL Server, MS Access, load it to Teradata. Working experience on slowly changing dimensions and creating SSIS packages and Informatica data mappings.
Used queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running queries in Teradata SQL Assistant. Utilized T-SQL in a daily basis in creating customs view for business data analysis.
Created tables, triggers, stored procedures, SQL loader in relational database SQL. Extracted financial datasets using Python & SQL to build complex reports. Reviewing report requirements for cogno’s reports with Datawarehouse/ETL.
Analyzed and model Test plans, Use Case Model cases & Test procedures for Agile delivery of the new sub-system.
Involved in loading data from RDBMS and web logs into HDFS using Sqoop and Flume. Used Hadoop ecosystem components like Hadoop Map Reduce, HDFS, HBase, Hive, Sqoop, Pig.
Zoho Corporation (Balaji LTD): India Jun 2013 – Dec 2013
Business Analyst:
Project: Data migration project, Project was based on analysis of complex business requirements, create data models using SSIS and creating complex stored procedures to use in their report datasets, and creating SSRS Reports. Enhancing data quality, data integration.
Design and Implement Database Schema, import data and build stored procedures on SQL Azure.
Performed Back end testing-using SQL queries, generating reports to ensure data integrity, validate the inserted, updated data.
Executed manual test cases that involved Accessibility Testing, Compatibility Testing, Ad hoc testing in various deployments.
Migrating Order Management and converted items from legacy warehouse management system to Oracle Inventory.
Responsible for testing functionality of Oracle ERP Application. Worked According to the rules for GAAP.
Integrated applications with the Warehouse Management System. Tracked the progress of project following Agile.
Worked with Team Lead/Project Manager to prioritize and work through backlog items for each Sprint - determine backlog
Document Requirement Traceability Matrix in Excel sheet for traceability of requirements to test cases. Very closely involved in all phases of SDLC from gathering requirements to testing. Participated in daily scrum meeting with the development team.
Gathered requirements for the web-based application. Created user work flows for that application. Performed technical analysis by employing effective interviewing skills to recommend solutions for the software applications.
Meeting the business user to understand the requirement & worked in Agile Iterative sessions to create new data lake.
Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within tableau Desktop.
Interfaced with business partners for the business process improvements by conducting As-Is, To-Be, GAP analysis. Conducted SWOT, Cost/Benefit analysis, root-cause, risk analysis in agile environment, assisted with overall project co-ordination.
Prepared test cases, test plans, logged defects as test specification documents. Maintaining burndown charts, sprint backlog, OFI. Conducted UAT, unit testing. Handled change management. Provided post-implementation support to stakeholders.
Performed a key role in preparing software requirement specification (SRS), user interface design, designing of application architecture and database modelling in project teams. Developed use cases, workflow and screen mock-ups.
Migrating data from Teradata to AWS cloud, experienced in maintaining meta data loads in AWS/Hadoop Eco systems.
CASE STUDIES:
Pinnacle Rental Case – Business Process Modelling Jan. 2018 to Mar. 2018
An Objective of the case study is to implement a new information system that can automate the billing process and retain data of the rented items. The new system also includes development of a web-based application.
RBC Bank - Credit Risk Modelling – Business Analysis Process Aug. 2017 to Nov. 2017
Designing the treasuries portfolio monitoring software and loan servicing module for its asset’s portfolio. Credit risk analysis from both borrower and lending facility being proposed to assign a risk rating and analyzing the pre-payment patterns.
CERTIFICATIONS:
Big Data using Hadoop & Spark, DePaul University Nov 17
SQL for Data Science - DataCamp Certification Apr 18
Business Statistics and Data Analysis Using Excel – Coursera – RICE University May 18