| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLEBusiness System AnalystProfessional Summary A tech savvy and data-driven Business Systems Analyst with a solid 6+ years experience in the IT industry and a flair for adapting quickly to fast pace business environments by adopting a pragmatic approach in improvising on solutions and resolving business issues. Cross functional improvement with focus on cost reduction using Lean manufacturing. Implemented Lean Manufacturing Principles at ACME independently, participated in lean process companywide adoption and training Proficient understanding of Software Development Life Cycle (SDLC) methods - Waterfall, Agile- Scrum Framework, Kanban. Expertise in working and building reports, working analysis of various requirements, ensuring compliance to set standards and business operations strategy. Proficient in Oracle Time & Labor module implementation, configuration and administration. Strong understanding of time and labor management best practices and compliance requirements. Thorough knowledge of developing Use Cases, conducting Gap Analysis, SWOT analysis, Cost-Benefit Analysis, and Risk Analysis. Extensive work with Business Process Models (BPM) techniques such as (Unified Modeling Language) UML for integrating new systems. Developed work products and deliverable for Business Process Analyst (BPA) for new child welfare and eligibility payments systems. Implemented and configured TCP timestamps to enhance network performance and reduce latency by 20% Successfully identified the values from users perspective. Map the value stream. Create flow in process steps. Used pull system as a part of Lean analysis. Conducted business value and SWOT analysis aided by strong knowledge of product market. Data-driven, passionate to analyze and interpret insights, translating into high-level business requirements. Successfully managed multiple concurrent projects, working independently under minimal supervision and engaged with stakeholders to update them on clients feedback. Proficient in TCP/IP Networking protocols including TCP timestamps (RFC 1323) Analytical and solution-oriented leader with eye for detail & strong problem-solving analytical skills. Excellent inter-personal and communication skills (verbal and written) to articulate complex problems and solutions. Proficient in Time Capture, Attendance tracking, Labor Costing Integration, Analytics and Reporting for OTL( Oracle Time & Labor)Experience in using the Step Tracking Tool for querying events in a tracking layer by stepping through the features in chronological order.Developed custom reports and dashboards using Oracle BI Publisher to provide actionable insights into workforce dataEducation Southern New Hampshire University, USAMaster of Science GPA: 3.8/4 JNTUH Bachelor of Engineering: Computer Science EngineeringTechnical Skills Statistical Tools: Tableau, WEKA, MS Excel, Google Analytics, Atlassian JIRA, Confluence Languages (Coding): SQL (Oracle, MySQL, Microsoft SQL Server Management Studio (SSMS)), Python, R Process Mapping Tools: MS Visio, Erwin, Draw.io, SnagIt, Lucid Chart Business Applications: Sales force, MS Office Skills: MS PowerPoint, MS Word, MS Project, MS Access, MS Outlook Process Management: SDLC, Agile Scrum and Kanban, Waterfall, V-Shaped, Hybrid, lean Six Sigma IDE: Jupiter, Eclipse, R Studio Configuration Management: Perforce, Tortoise SVN Networking Fundamentals: Ethernet and Serial Technology, Routing Protocols, Switching,, IP Security, LAN, W-LANKey Skills IT Software Project Management and Tracking Systems Design and Integration Process Analysis and Reengineering Test Cases and User Acceptance Testing Requirement collection, Data Mining & Data Analysis Business Case, Use Cases & Workflow documentation Technical Writing/Communication Change Control Management and Project ReportingProfessional ExperienceBusiness Analyst Travellers Insurance Jan 2022 Present Created ER Diagrams, RDBMS Tables in SQL Server Management Studio (SSMS). Created process mapping diagrams with MS Visio. Conducted Joint Application Development (JAD) sessions, created dashboards and scorecards for project plan, and performed requirements analysis, and data mapping. Worked on Survey Creation, Data collection, Data Analysis, Segmentation and targeting, Integration using Qualtrics. Developed ad hoc analysis reports using Tableau and Excel to present key insights, progress, raise issues, check trends, and usage patterns. Managed configuration, customizations, and integrations of OTL with Oracle HRMS and payroll systems. Evaluated business process, performed gap analysis, and recommended improvement and corrective actions for quality controls efficiency. Managed customer inquires and issues promptly to minimize interruptions to business processes. Communicated with developers and subject matter experts to establish the technical vision and analyze tradeoffs between changes in product screens, usability and performance evaluations. Drive business units on their assumptions to ensure business goals achievement. Troubleshoot network issues using TCP timestamp analysis and resolved packet delay variations (PDV) affecting real-time applications. Developed system approach documentation (SAD) including scope document, application design, process re-engineering plans and impact analysis using the software development life cycle (SDLC) processes and project methodologies like Agile, Waterfall, and Hybrid. Conducted presentations to the management and training workshops for the clients. Conducted walkthroughs with end users, developers, managers, and other analysts. Involved in the budget analysis, proposals, and financial reporting processes. Developed work products and deliverable for Business Processing Modeling (BPM) for new child welfare and eligibility payments and claims system. Developed documentation used to create the AS-IS and TO-BE process models for new child welfare and eligibility payments and claims system. Chaired and conducted JAD sessions with business and technical teams. Led XM discovery initiatives to gather customer feedback and insights resulting in 25% increase in customer satisfaction. Vast experience of working in data management including data analysis, gap analysis and data mapping. Developed and implemented strategies to mitigate customer escalations. Ensuring minimal impact on project timelines. Worked extensively with Erwin, Visio and ER Studio for Dimensional Modeling and Data Migration projects. Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy. Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary. Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes using HP Quality center. Extensive experience in User Acceptance Testing UAT, functional testing, system testing, and defect tracking using various tools. Coordinated and prioritized outstanding defects and system requests based on business requirements. Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements. Experience with SQL, PL/SQL, and Performance Tuning. Utilized XM tools such as Qualtrics to conduct surveys and interviews. Participated in integration of Qualtrics with CRM (Customer Relationship Management) software, ERP systems and analytics platform. Excellent experienced in data Extraction, Transformation and Loading ETL using various tools such as SQL Server Integration Services SSIS, DTS, Bulk Insert and Bulk Copy Program utility, SQL Replication and Log Shipping. Experience is Data Visualization, Statistical analysis, and text analytics from collected data using Qualtrics. Worked extensively in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and database Engine Tuning Advisor. Led the implementation of Sales force CRM, resulting in 20% increase of sale efficiency. Optimized customer service workflows through CRM automation, reducing response time by 30% Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators. Experience in Data Exploration, Text analysis, Bench marking, Integration of data using the XM (experience Management) discover programs. Excellent technical, time management, communication, interpersonal and presentation skills.Business Systems Analyst HCL,TX Dec 2019 Dec 2021 Delivered $20000 annual saving in contracted labor expenses by building project documentation database using Agile Methodologies. Research and gathered data, conducted data analysis for documenting business requirements (BRD) and functional design requirements. Acted as a liaison between stakeholders and programmer teams to develop strategies for project planning, milestones, and deliverables. Authored technical specifications, test cases, and testing scripts documentation with quality control teams to conform to end users need. Experienced in CRM customizations, configurations and data migrations. Used XM methods like VoC (Voice of customer), VoE(Voice of Employee) and VoM (Voice of Market). Saved 30+ person-hours bi-weekly with the creation of automated bug-tracking reports, dashboards, and templates using data visualization in Tableau. Played a pivotal supporting role in technology enhancements efforts by developing business cases, user stories, test plans, test cases. Proficient in handling customer escalations and inquiries with tact and efficiency. Successfully resolved a critical customer issue preventing project delays and preserving client satisfaction. Developed surveys, product design template, authoring business cases, user stories, test cases, gap analysis and swim lane diagram for workflow analysis. Decomposed high-level business and user information into details, abstract up from low-level product information to a general understanding to distinguish user requests from the actual underlying needs, prioritize stories and groom product backlog. Performed gap analysis by comparing the existing system with the proposed system and documented new prerequisites and features. Experience with integration of OTL with Oracle HRMS, Payroll and other ERP systems. Ability to analyze and troubleshoot OTL issues ensuring system reliability and accuracy. Conducted training workshop on PX, BX, XD, Closed loop Feedback, Agile Experience Management based on XM and provided structured approach to gather, analyze and act. Created EDI documents for EDI maps to generate requirement documents, and logical design documents for EDI transactions and code sets. Developed database objects like Tables, Triggers, and Indexes using T-SQL Management Studio. Designed SSIS Packages to transfer data between servers, load data into database on SQL Server 2005 environment and deploy the data. Proficient in Sales force, Microsoft Dynamics CRM and Zoho CRM. Created packages using SSIS from heterogeneous sources like Access Database, Flat Files, Excel and CSV, SQL Server database sources handling Outbound Member Files, Inbound Claims File and Inbound Provider Files. Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping and Metadata. Implemented a new CRM strategy that increased customer retention by 15% within six months. Implemented Oracle Time & Labor (OTL) module to automate time tracking and streamline payroll processes for a workforce of 1000+ employees. Provided end user training and support resulting in 35% reduction in payroll processing time. Experience in calling a Web Service, through SSIS Package through the transformation, and wherein you declare a variable with its URL link. Created Master child packages as an ETL strategy to populate dimensions and facts. Configured SSIS packages to incorporate slowly changing dimensions for tracking historical data. Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server. Created Data profiling stored procedures using dynamic SQL as well as generating complex scripts to schedule various maintenance tasks.Business Analyst /India Sep 2017 April 2019 Developed documentation database for Web Applications Firewall (WAF), a Software-as-a-Service (SaaS) on-cloud business solution. Facilitated product release using an Agile environment for software development. Used Scrum frameworks for sprint planning, retrospective, demo/review, and daily stand ups meetings on a 2-week cadence. Used JIRA for update request and change management. Provided support to the development team in defining Definition of Done (DOD) and Minimum Viable Product (MVP) for the system. Resolved customer interruptions maintain project continuity and ensuring on-time delivery of key milestones. Managed and maintained instructional materials like release notes, user guides, and other technical documentation in the database. Assisted and provided first level support in resolving critical operational control and functionality issues; Identified potential roadblocks, recommended improvements, and worked in coordination with project team. Participated in the creation of Business Process Engineering Workflow Diagrams with Stakeholders, Product Owners, vendors involved throughout the Business Solutions and System Development Lifecycle (SDLC) and Product Life Cycle (PLM), Application Life Cycle Management (ALM). Managed strategic site redesign to improve brand messaging, engage new users, and improve conversion. Resulted in 8% increase in visit duration, and 3% decrease in bounce rate.KEY Academic ProjectsData Management Designed Relational Databases (RDBMS) for Universal Furniture Outlet to capture its data. Designed a database, including the Entity-Relationship (ER) Model and normalization. Created and modified tables using Oracle. Wrote SQL Queries including group functions, table joins, nested queries, and views.Data Mining Case status of an H-1B application. Gathered 5 million records, performed pre-processing, handled data errors, and balancing of the skewed data sets. Employed WEKA tool for analyzing data using attribute selections, classifier algorithms ZeroR, OneR, Nave Bayes, J48. Compared results showed that J48 was the rightest algorithm for analyzing data giving an accuracy rate of 66.77%.Project Management Planned a computer-controlled conveyor belt that positions the items on it with a specified accuracy. Created a project schedule using MS Project and WBS determining total project duration using the Network Diagram. Prepared risk assessment form, risk response matrix, estimated project cost - schedule baseline, and cash flow table. Wrote a closing plan for the project; reporting the performance of the project to senior management for four quarters.Analysis and Design Designed a Time Attendance and Access Control System (operating modes - biometric, cards, PIN). Drafted system request, performed feasibility analysis by considering functional and non-functional requirements. Created use-case diagrams, activity diagrams using MS Visio, Draw.io and Snagit. Prepared use-case descriptions MS Word and evaluated effort estimation |
