SUMMARY

• Passionate and result oriented Business Systems Analyst with 8+ years of extensive experience with authoring Business Requirements Document (BRD), Functional Specification Documents (FSD), Software Requirement Specifications (SRSs), Use Case documentation, High level and Low - level documents (HLD/LLD), Business Rules Spreadsheet and Data mapping document.
• High experience in tracing requirements throughout the development process and verifying to Requirement Traceability Matrix (RTM).
• Experienced with extensive client interactions and converting business functionalities to Service Oriented Architecture (SOA) models across IT environment. Worked in Three-tier architecture, Ajax, Web Services (SOAP, WSDL), Client-Side Validation and Server-Side Validations.
• Certified Scrum Master (CSM) with proven ability to work with self-organizing and cross-functional teams in a wide spectrum of finance and banking sectors. Have hands on Experience on Waterfall, Agile, Scrum and Hybrid of Waterfall and Agile methodologies.
• Extensive years of in Business process re-engineering, business process improvements, Data Reports Analysis accompanied by active participation in discovery sessions, interviews, prototyping, document-reviews, plan setup, plan configuration with customers.
• Have extensive experience with the entire Software Development Life Cycle (SDLC) that included Requirement Elicitation, Gathering, Analysis, Design & Development and change management
• Got excellent interpersonal skills with ability to interact with end-users, Subject Matter Experts (SME’s) and Project Stakeholders.
• Organized and facilitated Joint Application Design (JAD) sessions and interviews, brainstorming sessions, written correspondence, questionnaire, focus group, implementation requirements, project status report and resolving issues/conflicts.
• Proficiency in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and transforming them into functional specifications.
• Experience in conducting GAP, Impact, SWOT, Cause and effect analysis, Root cause, Cost Benefit analysis, Feasibility studies, Risk Analysis, and As-Is and To-Be business analysis.
• Strong skills in building process models, data flow diagrams and entity relationship diagrams.
• Well acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity charts, Sequence diagrams, ER diagrams and Data flow diagrams (DFD’s) using Rational Rose and MS-Visio thus assisting development team in preparing Business Process Model.
• Facilitated Sprint Ceremonies (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) for Agile Scrum Methodology as Scrum Master.
• Extensively used tools like CA Rally & Jira to document user stories that kept teams focused on the highest value features.
• Experienced in writing User stories and handling the Requirement Churn. Efficient in performing, prioritizing and efficiently analyzing techniques such as Planning Poker, MoSCoW and T-Shirt Sizing.
• Excellent understanding of concepts like Data warehousing, data structures, Schemas, Data Marts, Data-Entity Relationships and User Administration. Worked with data warehouses for migrating data from OLTP’s to OLAP cube using ETL tools such as Informatica power center and SSIS.
• Collaborated in various types of testing like Functional (Black Box) testing, Regression testing and User Acceptance Testing (UAT). Accompanied with expertise in developing Test Plans & Test Case Scenarios, Test Logs and Test Objectives in manual and automated test environments. Excellent Communication, problem solving, public speaking, critical thinking, conflict resolution, facilitation and documentation skills.
• Good Understanding of Project Management activities, proficient with Project Management Tools, testing tools and defect reporting tools.
• Helped strengthen relationships with the customers, teams, and senior management through different layers of portfolio and program leading resulting in greater customer and teams' satisfaction.
• Provided leadership direction and coaching to the agile program and scrum teams, established cross-value stream coordination and collaboration.
• Strong team leadership and a unique ability to develop and maintain collaborative relationships with cross-functional groups at the highest level. Detail oriented, organized and results driven.
• Developed strong stakeholder relationship, managed customer expectations and client communication.
• Knowledge and experience with widely successful Agile techniques: User Stories, Velocity, Story Points, Backlogs, Burndown Charts, TDD, Pair Programming.
• Analytical and influential with the ability to resolve resource, team, project and process conflict by actively performing root cause analysis and decisively diagnosing and implementing resolutions
• Mentored organization to encourage transparency, and engage in conflict resolution.
• Experienced in Business process re-engineering, Business process improvements, Historical Data Reports Analysis.
• Analyzed source systems, business requirements, and developed User and Functional requirements.
• Experienced in conducting Joint Application Development (JAD) sessions, Focus-groups, interviews and requirement workshops with business to gather requirements.
• Knowledge of functional organizations, matrix organizations and projectized organizations along with understanding of projects like new initiatives, OPEX, CAPEX, In-house projects, vendor built projects and COTS.
• Excellent in performing Impact Assessment, Cost-Benefit Analysis, Gap Analysis, SWOT Analysis to check the compatibility of the existing system infrastructure with new Business Requirements.
• Worked with QA team to design and execute test plans and test cases for User Acceptance Testing (UAT) using HP Quality center (HP QC).
• Extensive knowledge in handling Data Mapping, Data Modeling, Process Modeling, and UML methodology as a business analysis methodology for application functionality designs using IBM Rational Rose, MS Visio and in Oracle PL/SQL, SQL including writing queries, stored procedures, functions and triggers.
• Proficient in using Business Intelligence reporting tools like SSRS, Tableau, Cognos, Spotfire, Qlik view for OLAP.
• Implemented all stages of development processes including extraction, transformation and loading (ETL) data from various sources into Data warehouse and Data Marts using Informatica Power Center Designer, Repository Manager, Workflow Manager and Workflow Monitor.

TECHNICAL SKILLS

Business Skills: Business Process Analysis, Business Process Improvement, HLD, LLD, Use Case Modeling, JAD Sessions, Risk Analysis, Requirements Workshops, GAP Analysis, Document Analysis, Impact Analysis, Change Management.

SDLC Methodologies: Waterfall, Agile Scrum, Waterfall-Scrum Hybrid, SAFe, XP, Kanban

Documentation Tool: Microsoft Word, Microsoft Excel, Microsoft Project

Collaboration Tool: Microsoft SharePoint, Confluence, HP ALM

Designing Tool: ARIS,Visio,iRise, Azure, Balsamiq

Req Management: JIRA, HP ALM, CA Rally, Version One, TFS, MS Project Server

Testing Tools: HP QC, HPALM, HP QTP, Load Runner, Bugzilla, JIRA, Cucumber, Gherkin, XSLT, Swagger

IT Service Management: BMC Service Desk (Magic Ticketing), Service NOW(SNOW)

ETL tools: Informatica Power Center, SAS, SSIS, SSAS, SSRS, Tableau, PowerBI

Databases: Microsoft SQL, Oracle, DB2, MS Access

Data Warehousing: ER Modeling, Dimension Modelling, Data Marts, OLTP, OLAP, Data Profiling, Data Mapping, Data Mining, Data Validation, Star schema, Snowflake Schema

Reporting Tools: OBIEE, Tableau, IBM Cognos, Power BI

Languages: Java, C, JavaScript, HTML5, CSS, XML, JSON, PL/SQL

Operating Systems: Windows, Mac OS, Linux

Project Skills: Domain SkillsValue-Added Leadership Skills

Resource Management: Financial ServicesCross-Functional Supervision

Requirements Gathering: Banking Services Team Building & Mentoring

Business Analysis: Client Relations & Presentations

System Migrations/Integrations: Business & Strategic Planning

PROFESSIONAL EXPERIENCE

Confidential, Manhattan,NYC

Sr.Business Systems Analyst

Responsibilities:

• Analyzed business functions and Use-Case modeling to capture and document system requirements.
• Conducted stakeholder interviews, JAD and brainstorming sessions to elicit end-user requirements from Operations team and Vendors to the further development of a Coordinated Assessment and Placement system that will develop new functionality and interfaces between many systems.
• Partnered with PM/BA and provide guidance in requirements elicitation and documentation.
• Created Activity workflow diagram,System design diagram,Business process diagram under the Agency BPMN by utilizing ARIS and MS Visio.
• Created screens and navigation for the Case Management System using HTML,CSS,Javascript and iRise.
• Worked with project stakeholders to understand and document business process and business requirements and highlight gaps between current and desired system state.
• Prepared business requirements after reviewing with stakeholders and obtaining their sign-off.
• Designed and prepared functional system requirements, after reviewing with business and technical teams to ensure design meets business and technical requirements.
• Prepared technical specifications in collaboration with the development team.
• Scheduled and facilitated project team meetings as needed.
• Responsible for ensuring any issues that arise from testing or implementation are escalated and resolved appropriately.
• Prepared business use cases to validate system requirements and to assist in UAT case preparation and UAT testing initiatives.
• Sound knowledge of test management tool HP Quality Center, HP Application Lifecycle Management
• Created test plans, test cases using HP QC.
• Used HP Quality Center for creating and executing test cases, for defect tracking and for generating reports.
• Logged and tracked the defects using HP Quality Center. Created an error repository and managed the testing process with the QA team
• Performed quality control review of project lifecycle process and project documents such as Business Requirements Document (BRD), Functional Specification Document (FSD) and other project related documents for compliance to the Agency's Procedures and Policies.

Environment: Scrum-Waterfall Transition, ARIS BPM, iRise Prototyping, Oracle SQL, Microsoft SQL Server 2008, MAPPER Mainframe,HP QC,HP ALM, JIRA, JIRA Service Desk, MS Excel, MS Word, MS Access,MS Visio, MS Outlook, SharePoint, SSMS, SoapUI, REST, XML, Tableau, Mock-up Screens, HTML, CSS, Javascript

Confidential, Warren, NJ

Sr. Business Systems Analyst

Responsibilities:

• Documented Business and System Requirements Documents by interviewing the business users and conducted JAD sessions to gather requirements.
• Assisted Project Manager in tracking and creating project budget, status reports and timelines and in creating Work Breakdown Structures (WBS).
• Conducted Cost benefit analysis of the two interfaces that we planned to deploy as part of the project requirement.
• Responsible for efficient resource utilization, managing dependencies and resolution of conflicts.
• Responsible for identifying requirements for large mobile app data consumption and real-time fraud detection by moving to IBM z13 Mainframe
• Implemented IMB Maximo with Tivoli Service Desk with key asset and service management components.
• Tracked and managed IT assets throughout the asset life cycle more efficiently.
• Managed procurement, budgeting and contracts more effectively.
• Assisted in controlling IT costs and more accurately plan for future IT needs. Integrate with additional asset and service management components from IBM and other vendors.
• Interpreted API specification for all integrations from IBM Websphere Portal, V8 API specification through which developers could drag and drop their portlets and/or portals.
• Collaborated with development team to on board third-party developers on a cloud platform utilizing end to end IBM Middleware solutions such as IBM Websphere and IBM Datapower to provide single multi-channel gateway for security, control, integration and optimizations of web, mobile API’s, SOA’s and manage cloud workloads.
• Utilized IBM Bluemix to combine strengths of IBM’s middleware software tools to offer DevOps in the Cloud. Enabling developers with tools including IBM Watson API’s and services for social, mobile, security and internet of things.
• Unified Enterprise content by integrating and documented lifecycle capabilities including versioning, security and records management by using IBM Case Manager 5.2.0
• Create process maps to manage logic for execution of a task in IBM Case Manager. Used IBM Case Manager to track all the tasks in the context of its case.
• Used Case Manager Builder to collaborate and contribute to solution creation and refinement to design case types, case properties and tasks with the corresponding workflows for case workers to process and define business rules for automated decision making.
• Audited configuration stores audit configuration settings for tracking the history of cases.
• Used the Timeline Visualizer widget, it is necessary to configure auditing and a case history store to track the history of the cases.
• Tracked Case migration and deployments. Provided a framework in which the tasks that are related to a case can be started and tracked together in the context of the case.
• Understood the WSDL file to determine the operations that web service provide to in corporate the XML request and response format for data mapping and data governance for data migration to data marts.
• Responsible for data mapping with XML and RESTful APIs to integrate with different web services.
• API documentation (JSON documentation & XML documentation) using Swagger
• Processed large Excel sourcedatafeeds for Regional Server Consolidation and loaded the CSV files into Oracle Database with SQL Loader utility.
• Developed the best practices and standards forDataGovernance Processes.
• Performed theDataAccuracy,DataAnalysis,DataQuality checks before and after loading thedata.
• Performed in depth analysis ofdata& prepared periodic reports using MS Excel.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Performed the physical database design, normalized the tables, worked with De-normalized tables to load thedatainto fact tables ofDatawarehouse.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment
• Verified whether the front-end values are correctly storing in the back-end database by writing SQL queries.
• Conducted database testing by executing SQL queries to check data in database.
• Involved in debugging and trouble-shooting of database objects
• Used Tableau to generate internal reports to study and analyze the planned interfaces.
• Presented project status reports, team performance, timeline to Senior Management.
• Assisted the project manager in maintaining project charter, risk charter and communication management.
• Facilitated time-boxed Scrum ceremonies like Sprint Planning, Daily Scrum, Sprint Review and Retrospective meetings.
• Helped negotiating commitments and assured parallel understanding of requirements and deliverables amongst all stakeholders in Sprint Planning Meetings.
• Created User Stories and led the Planning Poker game to estimate them in Sprint Planning and Backlog Grooming.
• Reviewed Sprint Burn down and Release Burn Down Charts to maintain team’s velocity.
• Timely assured development team had necessary resources to perform to their potential, tracked and removed impediments.
• Used Agile Scrum Methodology for the iterative development of the application and facilitated bi-weekly sprints and daily stand up meetings.
• Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which features met the definition of Done (DoD) using the acceptance criteria.
• Helped resolve team and organizational level impediments.
• At the end of each sprint conducted Sprint Retrospective meetings such as ORID, Sailboat, Mad, Sad, Glad techniques so each stakeholder can freely express their opinions and suggest improvement measures.
• Helped the Product Owner to Prioritize the Product Backlog items using MOSCOW technique for developing Sprint tasks by taking suggestions from team.
• Used JIRA for drafting user stories, allotting tasks, backlog management, issue tracking, user story maps and generating reports.
• Maintained the Task Board that was referred to during the daily stand-ups that helped the team track the stories To Do, Work in Progress, Done and Accepted.
• Reviewed and approved test scenarios and results of test cases.
• Used JIRA for manual testing, defect tracking and monitoring the status of the issues, closing defects etc.
• Conducted Integrationtesting, web servicesAPItestingusing Swagger.
• Involved in defining Test Scenarios for the applications and performing manual testing in QC.
• Used Quality center to track defects in the application.

Environment: LeSS, JIRA, JIRA Service Desk, IBM Websphere, IBM Datapower, IBM Case Manager, MS Outlook, HP ALM, HP QC, Load Runner, SharePoint, MS Visio, XML spy, SQL Server 2012, SSIS, SSAS, SSRS, SoapUI, REST, XML, Swagger, Tableau, Mock-up Screens, HTML, CSS, jQuery, Team Foundation Server (TFS)

Confidential, O’Fallon, MO

Business Systems Analyst

Responsibilities:

• Responsible for continuous process improvement and for identifying and maintaining a clear and measurable Development Process that is deployable throughout the enterprise-using Scrum.
• Analyzed prior documents and Gathered Business Requirements, analyze data/workflows. Defined the scope, financial projections and Cost/benefit analysis. Progressed from Problem Statement to well-documented designs.
• Conducted various requirements gathering through research, formal-informal sessions, JRP sessions and JAD sessions with SMEs (Subject Matter Experts), Teams, and Stakeholders.
• Assisted Project Manager in creating proposals and project budget allocations and worked on Project Charter and Work Break down Structure using MS Project.
• Prepared Business Requirement Documents (BRD) and Functional Requirement Document (FRD). Decomposed BRD into User Stories by conducting a story writing session with product owner and user Acceptance Criteria for PSPI (Potentially Shippable Product Increment).
• Incorporated Scrum events Backlog refinement, Sprint Planning, stand up meeting, Sprint Review and Sprint Retrospective.
• Helped to prioritize user stories using MoSCoW and Planning Poker techniques.
• As Scrum master facilitates Sprint Planning meeting, tracked team velocity and Sprint progress using Sprint Burn Down Chart and Product Burndown Chart by using Rally.
• Engaged Scrum teams and programs SME’s to understand communicate status, priorities, risks and issues.
• Managed and monitored various scrum events through agile delivery process, worked closely with project manager, product owner and stakeholders to ensure their expectations are met.
• Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively used Rational Rose and MS Visio for UML.
• Assisted Project Teams in preparing Software Requirement Specifications (SRS), Software Design Documents (SDD), User Interface Design, designing of Application Architecture & Database Modeling.
• Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams and I also handled requirement churn.
• Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project comply with Business Requirements.
• Supported scrum team by resolving impediments such as the offshore testing team impediment.
• Analyze Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements.
• Establish Incident Reporting and Change Control procedures using ClearQuest.
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision-making support.
• Designed star schema with dimensional modeling, created fact tables and dimensional tables.
• Involved indataanalysis,datadiscrepancy reduction in the source and target schemas.
• Worked with developers and DBA to support database design and modifications; analyzed database structure and created new functions, triggers, stored procedures, views, tables, andSQLscript in alignment with requirements.
• Designed and developed the star schemaDatamodel, Fact Tables to load theDataintoDataWarehouse.
• Experience in Extraction, Transformation and Loading (ETL) using SSIS.
• Developed reports using Business Intelligence and reporting tools like SSRS (SQL Server Reporting services)
• Created PL/SQL Stored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.
• Extensively involved in data mapping, logical data modeling, creating class diagrams, ER diagrams and used SQL queries to filter data within the Oracle environment
• Worked with data architects in the design of database schemas for data migration.
• Installed and configured SSRS - SQL server Reporting services and SSAS - SQL Server Analytical Services
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Used Salesforce CRM including the sales and marketing cloud, forecasting and trend analysis for budgeting and managed workflow rules and data validation.
• Salesforce used for front end CRM stream lining the business process by providing superior customer support.
• Involved in Physical and Logical design and Schemas for databases of new application. involved in creating data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied while working with SQL server Integration services (SSIS).
• Logged and tracked the defects using HP Quality Center. Created an error repository and managed the testing process with the QA team
• Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application.
• Proven record of Team Management and Leadership skills.

Environment: SAFe, CA Rally, SharePoint 2010, Microsoft Office, Selenium, Salesforce CRM, SQL Server, SSIS, SSAS, SSRS, MS-Visio, Windows 7, HTML, CSS, JavaScript, JAVA, Apache Tomcat, Amazon Web Services (Amazon EC2, S3, AWS Lambda, Amazon Aurora, Amazon Redshift, Amazon QuickSight, AWS Identity & Access Management)

Confidential, Boston, MA

Systems Analyst/Data Analyst

Responsibilities:

• Involved in Business process reengineering (BPR) by conducting Process modelling, SWOT analysis, Document analysis, and GAP analysis to analyze As-Is business process and the To-Be system.
• Conducted multiple Interviews, Brainstorming, Requirements Workshop and JAD sessions with business owners, development teams, SAS analysts, DB admins, financial analysts, and Subject matter experts to elicit requirements regarding scenarios, business rules & regulations, and reporting requirements.
• Created Business Requirements Document and System Requirements Specifications (SRS) for functional, non-functional, Data, and GUI requirements in coordination with the Product Owner, Development team and gained key requirements to support sustainability.
• Used UX Pin to create Software Wireframes, Prototypes, mockups simulating key aspects of the final product.
• Created modelling UML diagrams, flow charting process flows like BPMN using Lucid Chart, MS Visio.
• Used SharePoint as document storage collaboration platform for document management.
• Helped defining and validating the current data definitions, which served as an input for Data Modeling definitions
• Performed Data Profiling, Data cleansing, de-duplication, address validation using IDQ to maintain one copy of customer data as part of KYC
• Created source to target mapping document, data mapping, data migration for aligning with the data source and target database.
• Responsible for identifying data sources from omni channel touch points, internal systems, external systems, silos on legacy systems, third party systems, social media, clickstream for the Enterprise Data Hub (EDH) using Cloudera.
• Gathered requirements on the different frequencies of data ingest (Batch/streamed real-time/part- time) from Flume collectors to be loaded on HDFS using Apache Flume.
• Worked on querying data and creating on demand reports and involved in data validations and performed Sentiment Analysis for Social Media data Analysis & used Sqoop to transfer data from RDBMS to HDFS. Used SQL queries to build reports and data retrieval purposes.
• Created scenarios and iterations to be run using Impala (Hadoop service) to produce more precise insights.
• Elicited and wrote requirements for reporting on potential illicit activity that includes.
• Elicited requirements and assisted in the development of alerts-score based triage criterions, case packaging and the requirements for UI & report elements of the Investigation Manager module.
• Elicited and documented requirements for data optimization and packaged data management schema for the consumption of SAS Analytics engine.
• Responsible for creation of ER diagrams like Conceptual and Logical diagrams and Collaborated with database developer in developing physical diagram for Knowledge Center that stores Alerts.
• Elicited and documented Risk Scenarios for Alerts and Risk factors for each Alert with the SMEs.
• Elicited requirements for Business rules such as Routing rules and Suppression rules for Alerts.
• Collaborated with development team in developing business scenario simulation algorithms using Apache Spark, Apache HBase, and Oozie and automation of workflows using Apache Mahout.
• Acted as a liaison between Hadoop Administrator and Developer in setting up the nodes and clusters of Hadoop eco-system with the help of tools like Cloudera Manager and services like Zookeeper and YARN.
• Worked closely with UI team in developing the web application and validated XML, HTML. Learned more about Java script frameworks like Angular Java Script.
• Assisted Web services team in designing REST API’s and configuring WADL.
• Involved in validation of HTTP requests and response of Web server by using stubs.
• Assisted in configuring dash boards and reports in SAS Visualization.
• Assured Quality Assurance of developed software by identifying Test Scenarios, creating Test Plans. Tested various modules by performing UAT, tracked defects by documenting them in JIRA and communicated with the team for resolving the defects.
• Maintained and Managed all the deliverables, artifacts, timelines and dependencies using JIRA for Project Management.
• Conducted Story writing sessions, Product Grooming sessions and Coached teams to write effective User stories using INVEST criteria, and tasks using SMART criteria, defined Acceptance criteria, and Definition of Done.
• Collaborated with the Product owner and Development team to prioritize the Product Backlog Items (PBI’s) using various techniques that carry business value like Moscow, estimate the User Stories using relative units like Planning Poker.
• Created Task Board to segregate to-do tasks, in progress tasks and done tasks. Tracked team progress daily through Standup Meeting towards sprint goal, identified and solved impediments, ensured transparency of artifacts created and to be created.
• Worked with Change Management procedures which included modifications and enhancement, analyzed, documented and processed required Change as per the standard procedures for approval/denial decisions.
• Collaborated with the team to verify and validate the PSPI developed with the definition of done and acceptance criteria during sprint review meeting to calculate velocity and move the incomplete user stories back to product backlog.
• Coached scrum team to be self-organizing, transparent, cross-functional and accountable.
• Conducted Sprint Retrospective by providing a comfortable environment to the team and carefully diagnosed the process followed during sprint cycle, discussed new ideas if any and resolved issues identified.
• Documented all workshops, retrospective and other ceremonies note in Confluence.

Environment: Waterfall Scrum Hybrid, JIRA, Confluence, MS Project, MS Visio, UX pin, Lucid Chart, Informatica, Big Data Hadoop (YARN, Sqoop, Flume, MapReduce, Hive, Pig, Impala, Apache Mahout, Hadoop Distributed File Systems (HDFS), HBase, Spark Streaming), SAS Financial Crime Suite, SAS Base and Data Loader, SQL, HTML5, XML, CSS3, Angular JS, RESTful API, AJAX

Confidential

JAVA Developer/Data Analyst

Responsibilities:

• Assisted in defining the initial common terminology to be used throughout the project lifecycle.
• Worked with the entire Mortgage Business Applications including Loan Origination System, Loan Processing System, Loan Underwriting System, Loan Closing System, and various other internal system interfaces.
• Exposure and some development of the following: Enterprise Java Beans, Servlets, JSP, JSF, JavaScript, JQuery, Oracle, HTML, and CSS.
• Gathered Business Requirements, and analyzed data/process flows. Defined the scope, financial projections and cost/benefit analysis. Ensured progression from Problem Statement to well- documented Designs.
• Evaluated and solved trouble tickets by coordinating with DBAs, Help Desk and my junior Java team.
• Used commons and log4j logging framework
• Created an AS-IS workflow to better understand mechanics of the existing system and conducted Gap Analysis.
• Developed Wireframes, Prototypes of the new information processing application using MS Visio.
• Facilitated collection of functional requirements from system users and prepared Business requirement documents (BRD)
• Reviewed Design documents, Requirements analysis specifications with Project Lead, Business Owners and the Technical Lead.
• Identified and documented issues, risks and gaps (descriptions, impact) and provided recommendation and alternatives to develop the application to meet the user requirements.
• Developed and executed test cases for systems testing and User Acceptance Testing.
• Played a major role in Change Management during the testing lifecycle.
• Helped Data Architect to understand the business requirements to create the Database Models and resolve the Data Migration issues.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data system by performing different kinds of transformations using SSIS
• Worked on all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults and Check, Unique, etc.)
• Written T-SQL procedures for processing business logic in the database. Tuned SQL queries for better performance
• Involved in creating and visualizing dashboards using Tableau Desktop
• Made use of SQL queries and MS Excel to perform a detailed analysis on the existing human resource data, identified issues and worked with the technical team to find issue resolution
• Monitoring SQL Server Jobs and managing daily and monthly data loading processes depending on the frequency of source data
• Documented system requirements and business requirements and created Requirement Traceability Matrix (RTM). Performed the requirement analysis, impact analysis and documented Business Requirements Document (BRD) and Functional Specification Document (FSD) using Microsoft Visio and Microsoft Suite

Environment: Waterfall, Scrum, SQL Server, SSIS, SSRS, SSAS, Tableau, UML, CRM, Rational Rose, MS Project, MS Visio, IBM WebSphere, Test Director

Confidential

Junior Java Developer

Responsibilities:

• Identify research, analyze, define and document business processes.
• Conducted interviews with project managers, SMEs, business users to collect requirement and business process information.
• Created, Maintained, Mapped and Updated Requirement Traceability Matrix (RTM) to ensure all requirements are defined for a system and tested in the test protocols.
• Created low fidelity diagrams like Wireframes showing markups for web pages.
• Created process flow diagrams for better process identification and clarity for development team.
• Worked with the developers closely to magnify success scenarios of Primary and Alternate flows.
• Developed PowerPoint presentations for monthly meetings with upper management.
• Responsible for the development of web and business tier components usingJAVA, J2EE, JSP and XML
• Teamed up with the credit allocation department to perform market survey and learn client requirements to assist the technical team in Software development.
• Assisted Engineers in coming up with technical documents Functional design documents.
• Assist in selecting the technology for the application based on Cost-Effectiveness and Quality with an eye towards the future.
• Extract, transform and loading the data from different sources using different transformations and control flow tasks.
• Used control flow tasks like for loop container, for each loop container, sequence container, execute SQL task and data flow task.
• Creating package configurations, loggings, check points and break points in SSIS
• Written Stored Procedures, Functions, Indexes, joins and Views by using T-SQL
• Developed SSIS packages to transfer flat files from Staging server to data base server
• Processing of System flat files from feed hub to new SQL Server 2008 database
• Involved in performance tuning activities of SSIS packages
• Diagnose and correct errors within Java/HTML/PHP code to allow for connection and utilization of proprietary applications.
• End user support and administrative functions to include password and account management.
• As per client requirements generate the reports in the form of Table and Matrix.
• Writing SELECT queries to get required data and using DML, DDL statements to perform required activities.
• Used for SharePoint content management and document management.
• Used UML to prepare Use Cases from the gathered requirements and created diagrams using Rational Rose.
• Assisted in preparation of UAT test plan, Test Cases, Testing Cycle schedules, Test Scenarios and implemented them with QA team.

Environment: Waterfall, UML, SQL Server,, J2EE (Servlets, JSP, JSTL), MS Office (word, power point, excel), MS Project, DB2, Mockup Screens, SharePoint