SUMMARY:

• 12+ years of Project Management and Business System Intelligence Analysis experience for delivery of technical solutions aligned with diverse work stream areas of focus while adhering to the platform vision.
• Worked within Automotive Battery Manufacturing, Energy, Utilities and Renewable, US & UK based Mortgage Banking companies and expert knowledge within Manufacturing, Energy and Financial Domain.
• Experience in enterprise architecture analysis, client interaction, requirements gathering, workflow designs, functional and behavioral design elicitation, process improvisation, and communication& solution validations.
• Extensive experience in financial, accounting and mortgage servicing SaaS (Software - as-a-service) model-based ERP software systems/suits and managed all ERP related projects, defining functional and technical requirements, as well as the testing and implementation of the ERP projects while collaborating with end-users to establish ERP systems goals.
• Key focus areas included developing/managing BI/DW and Operational Data Stores projects through complete SDLC.
• Data Warehousing and Business Intelligence systems implementation
• Understand and translate business needs into data models supporting long-term solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Worked on Azure Hive/HD Insight (Apache Hadoop Cluster in Azure HD Insight) and using DBeaver as a SQL client tool to query the data.
• Created powerful report visualizations in Power BI (equivalent to Tableau) to replace the existing legacy reports in SAP Business objects through the data ingested via ETL tools such as Talend (equivalent to Data Stage tool).
• Used Python to visualize data in Power BI desktop with the help of Python script editor feature in Power BI that generates supporting Python script binding code based on user selections to create plots on the canvas.
• Strong SQL/Query tools and stored procedure writing experience including Queries, tables etc. Knowledge of working with database client tools such as Toad.
• Source Data Analysis, Data Profiling, Source to Target Data Mapping, Detailed Data BI Requirements and design, Visualization Mapping documentation, SQL Prototyping, High Level Business Requirement, Data Ingestion Details Documentation, Data Modelling, Data Quality, Data Governance & Rules Repositories through Datum’s (LLC)Information Value Management (IVM) platform(Creating data dictionaries, Metrics& KPIs definitions, Glossary, Business Rules, Data Standards),MDM(Master Data Management),MDG(Master Data Governance)
• Expertise researching existing data structures and tables to create cross-functional and mapping documents across old and new application systems, thus pro-actively facilitating in data systems migration project.
• Advanced knowledge Power Pivot and Power BI (Desktop and online services) and other data visualization and reporting tools.
• Experience with using Microsoft analytics Stack (SSAS Tabular, Power BI, Power Query, DAX, SQL and T-SQL) and working with SSAS cubes (Microsoft Azure Analysis Services Web designer), Azure Machine Learning (AML). Understanding of Azure and its data services.
• Experience with DAX Studio to capture DAX queries generated by Power BI and analyzing DAX to better understand performance issues.
• Proficiency in dashboard and scorecard design and development.
• Basic knowledge of Data Mining, Clustering, Statistical Modeling, DAX, M language.
• Database Design. Advanced skill level in relational database, Oracle, MS SQL Server knowledge.
• Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources
• Creation of pseudo-codes/algorithms and field/file logic to help development team in coding and field values computation.
• Client facing for requirement gathering and product analysis.
• Working knowledge of Microsoft Office: Word, Excel, PowerPoint, Visio, Project, Visual Studio Team Services VSTS (Azure DevOps), Office 365, OneDrive, OneNote, Microsoft Teams, SharePoint, Microsoft Azure Storage Explorer, Microsoft Visual Studio, Microsoft SQL Server Management Studio, Microsoft SQL Server Data Tools
• Experience in following:
• Experience in writing functional specifications (use cases, user stories, epics, story points etc.)
• UML
• Creation of wireframes using Mock-up Builder, Visio etc.
• Analyzing and designing functional flow from scratch.
• Test Planning and management.
• Software Design Life Cycle (SDLC) and design methodologies (Waterfall and Agile) & KANBAN
• Test Driven Development (TDD)
• Behavior Driven Development (BDD)
• Accustomed to interacting with international clients & technical teams during all phases of project execution.
• Completed the requisite 21 hours of classroom on Certified Business Analysis Professional (CBAP) course from one of the reputed Endorsed Provider (EEP) of IIBA known as Simplilearn Institute.
• AWS Certified Developer Associate with active license.
• Certified Scrum Master (CSM) and Certified Scrum Product Owner (CSPO) with active license.
• Certified SAFe Agilist (SA) and SAFe Product Owner / Product Manager (POPM)

TECHNICAL SKILLS:

Software Expertise: Waterfall & Agile Scrum Modeling, UML, Business Analysis, Requirements Gathering &Analysis, wireframes, mock-up creations, Project status tracking and dashboard reporting, Project Risk Identification, Mitigation Plan Solution, Stakeholder management/expectation management, swim lane diagrams, system workflows.

Tools: MS Office 2013(Word, Excel, Project, Visio, PowerPoint), Open office Document, UML, SQL Developer, Microsoft TFS (Team Foundation Server), Service Desk Plus, Atlassian JIRA software, Matrikon OPC explorer, IntelliJ, GitHub, Source Control, Putty, FileZilla, WinSCP, Docker, AWS tools, Power BI,SQL developer, Toad, cmder, sublime, Notepad++,DBeaver(to connect to Azure HIVE/HDInsight), Aqua Data Studio, Apache Ambari, SAP, SAP HANA Studio, SAP BOBJ (WebI),Battery Enterprise System (BES) ERP (Progress 4GL),ServiceNOW

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Quickly understood the business issues and data challenges of client's organization and industry.
• Actively participating in product, release and sprint planning
• Regularly updating product and sprint backlogs.
• Identified client organization's strengths and weaknesses and suggesting areas of improvement.
• Created requirements (BRD), specifications, business processes and recommendations related to the proposed solution.
• Developed functional specifications and system design specifications for client engagements.
• Part of the Business Analyst team handling the various US & UK mortgage financial servicing& accounting product suites& ERPs such as LSAMS (Loan Servicing and Account Management System), REAL Servicing, Phoebus and DPR systems.
• Responsible for requirement gathering (Request for Change creation) and Solution Design Phase for existing/new Client requirements needed in the Loan Servicing product suites.
• New Client implementation for Loan Servicing product suites.
• Upgraded Technical documentation utilizing SQL queries to identify and highlight specific fields and tables that were impacted by the code change.
• Lead testing efforts and creating Test Cases.
• Ensured issues are identified, tracked, reported on and resolved in a timely manner.
• Worked with client personnel to identify required changes.
• Communicated with the Development Team and Testing Team for effective transition and understanding of the requirements.
• Participated in UAT testing and functionality testing as per release notes.
• Reported and tracked defects via JIRA and TFS.
• Prepared BUG reports and performing Software Quality assurance activities as per Quality Norms.
• Led team and client meetings.
• Delivered informative, well-organized presentations.
• Understand how to communicate difficult/sensitive information tactfully.
• Mentored junior analysts.
• Performed SQL query commands to prepare reports and data maps.
• Possesses’ understanding in the areas of application programming, database and system design.
• Understand Internet, Intranet, Extranet and client/server architectures.
• Understand how legacy and web-based systems interface with each other.
• Identified critical issues with ease.
• Pushed creative thinking beyond the boundaries of existing industry practices and client mindsets.
• Worked with on-site staff for business process knowledge sharing
• Developed relationships with client personnel that foster client ties.
• Communicate effectively with clients to identify needs and evaluate alternative business solutions with project management.
• Seek opportunities to increase customer satisfaction and deepen client relationships
• Managing client expectations effectively

Confidential

Senior Business Intelligence Analyst

Responsibilities:

• Consolidate, dedupe and merge the operational data and billing functionality for Red Hawk, ASG/Aronson into the MasterMind Business Application
• Create mapping document to translate Red Hawk bill codes to ADT bill codes.
• Gathering requirements involving the mapping of data fields from disparate data sources.
• Documentation of data migration requirements and processes, both functionally and technically.
• Identify opportunities for data quality and integrity issues.
• Monitoring and collecting data metrics and defect information during all phases of testing and updating requirements and defects based on issues identified.
• Assisting in the thorough articulation and documentation of defects or other issues identified in all testing phases.
• Soliciting requirements and documenting detailed specifications, including swim lane diagrams, flow charts and related graphical representations of processes.
• Participating in root cause analysis, and documenting findings.
• Worked with key business stakeholders to document and validate business objectives and requirements.
• Managed communications and coordinate discussions between Product Managers and business stakeholders
• Worked closely with Product Manager to translate and clarify business requirements for technical team
• Participated as an active member of the team on solution design: represent end-user perspective in discussions with Product Managers, Engineers and Admins
• Coordinated testing (with business stakeholders), including drafting test scenarios, facilitating, demos, UAT and sign-off
• Created and coordinated sharing of business requirements and technical documentation
• Provided to key business stakeholders
• Served as first level of support for business users

Senior Project Manager/Business Intelligence Analyst

Confidential

Responsibilities:

• Manage all phases of project to success, including initiation, planning, definition, design, development, testing, and deployment cycles
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Develop data models according to company standards.
• Drive definition of business solution concepts in partnership with IT and business constituents
• Act as an ambassador for promoting management and adoption of BI capabilities by improving decision making processes through the delivery of reliable data and information
• Responsible for the design, implementation and ongoing management of Analytics within the Johnson Controls Power Solutions Business Unit
• Define and advise as required on data analytics model selection and implementation
• Collaborates with the architecture teams to ensure that the data management principles and strategic assumptions are enabling the metric deployment and aligned with the IT strategy
• Responsible for ensuring that the operational landscape for master data enabling the business processes and aligning with the vision of global master data.
• Act as a strategic adviser to Power Solutions leadership on the business impact of regional project and/or enhancement requests on global analytics.
• Act as the Product Owner for the PS Global Business Intelligence Deployment for Category Management Team supporting Sales and Marketing Business of Power Solutions.
• Manage and drive the capture of requirements and design of business metrics, data definitions and data standards
• Ensure alignment of global business metric definitions, data definition governance processes and standards with applicable global and regional business process design(s)
• Lead and facilitate to capture business and technical requirements and define target solution design and strived to meet the agreed release timelines for the delivery of the solutions.

Senior Business Intelligence Analyst

Confidential

Responsibilities:

• Planned successful delivery of business intelligence models.
• Analyzed business process and practices in an effort to focus the design and implementation of information technology solutions that meet customer needs and business initiatives.
• Collaborated on an on-going basis with the Programmer/Analysts.
• Applied advanced analytical skills within functional area.
• Designed the architecture for the BI model with most efficient outputs.
• Designed the VPC client layout for the cloud effort to move data from on-premises into AWS cloud environment.
• Managed and maintained the IAM AWS cloud environment for users and their roles to specific AWS services.

Confidential

Senior Business Analyst Team Lead

Responsibilities:

• Planned successful delivery of Phoebus Phase 1 ‘Soft launch’ on 2nd February 2015.
• Prioritized the subsequent Phoebus Phase 2 project which sought to deliver a limited number of Change Requests (CR’s) and all outstanding pre-live (OSBUAT) System Bugs (JIRA’s) within a limited 90-day window.
• Steered project committee & scrum meetings with all the stakeholders including business and development teams.
• On-going support of ERP implementation and resolve business level issues for the ERP system called Phoebus.
• Planning and performing requirement gathering workshops within different business units.
• Documenting requirements in epics and user stories etc.
• Acted as Product owner and planned sprints and conducted daily scrum meetings to discuss user stories from release backlog, expand user stories into tasks, estimate effort for tasks & determine any impediments.
• Performed Data validation and mapping of fields from Bastion, legacy system to Phoebus, new system.
• Wrote UPDATE, INSERT, and DELETE SQL Queries for data cleansing in various tables during projects testing.
• Extract (Full/Partial) data dump from tables of old legacy AS400 system and analyze and map them to existing fields of the new web-based system.
• Creation of reports using SQL queries for data retrieval.
• Actively scoped requirements for the next phase, phase 3, that will seek to include delivery of all Phoebus software Change Requests (CR’s) and resolution of all outstanding post-live (OSB) system bugs (JIRA’s) required to allow migration of the back books from Bastion (legacy AS400 system) to Phoebus, with Phase 4 solely concerned with the migration of the mortgage cases (Loan/Account numbers) itself.
• Led the meetings with software provider (Vendor’s) SME’s and project managers for understanding the business process, and functionality in detail.

Confidential

Business Analyst

Responsibilities:

• Took part in the preparation of Project plan
• Led meetings with Client SME’s and client managers for understanding the business process, and functionality in detail.
• Responsible for creating the complete business and functional specifications working along with Client Business Analyst team.
• Deployed on client site (Nationstar Mortgage) to transition requirements to the off-shore development team.
• Performed UAT testing and functionality testing.
• Frequently used SQL SELECT commands to query and identify the list of 2nd lien loan accounts for which this project change was implemented.

Confidential

Business Analyst

Responsibilities:

• Responsible for understanding and documenting the Business Process by working with the SME’s.
• Created the complete business and functional specification under Agile environment.
• Collaborate with the Scrum Master and performed UAT testing and functionality testing.

Confidential

Business Analyst

Responsibilities:

• Conducted JAD sessions to define the project and to reduce the timeframe required to complete deliverables.
• Participated and provided updates in daily SCRUM meetings.
• Acted as a bridge between Business (Clients) and the technical team of 25 developers and 9 Test Engineers.
• Acted as a SPOC for multiple clients for OCS web portal implementation
• Defined testability requirements and conducted rigorous tests to effectuate improvement in the product; tested new functionalities to be added to the application.
• Conducted application demonstration and user .
• Environment: IBM AS400 iSeries Systems, RPG (Report Program Generator), COBOL, ILE (Integrated Language Environment), Control Language (CL) Commands, SQL, TELNET

Confidential

Software Engineer

Responsibilities:

• Actively participated in the HAMP implementation and logic building with the business unit.
• Requirement analysis and coordinating UAT with clients.
• Solution designing for Ocwen’s product REAL Servicing.
• Responded to RFIs for Ocwen’s loan servicing product REAL Servicing.
• Designed customized reports for senior management for SLA.
• Interfaced with Ocwen’s mortgage servicing software with financial gateways like Western Union and other third-party applications.
• Responded to customers’ queries as well as troubleshooting of Ocwen’s product.
• Environment: HTML 2.0, Progress 4GL