SUMMARY:

• 7+ years of experience as a Business Analyst/Data Analyst with solid understanding of Business Requirements Gathering, Data Analysis, Data Mapping and Business Analysis.
• Imported, managed and tagged requirement documents, and designed project deliverables (Traceability Matrix) using various tools.
• Proficient in creating Use Case diagrams, Sequence Diagrams, State transition diagram, and Activity Diagrams using UML methodology in MS Visio.
• Proficient in using MS Project for scheduling deadlines, resources, and facilities, Rational ClearQuest for Change Management (CM) and Defect Tracking, Rational Clear Case for Configuration & software asset management.
• Diverse experience in Banking, Financial Services and Mortgage. Strong understanding of Capital Markets, Fixed Income, Equities, Risk management (credit risk, Over the Counter (OTC)) Trading, mortgage products, Collateralized Assets (MBS, ABS & CMO), Trading floor applications, Loan Processing Applications and Portfolio Management.
• Developed strengths in all phases of the Software Design and Development Life Cycle (SDLC).
• Good knowledge of Waterfall, Agile methodology and Rapid Application Development (RAD).
• Created and Maintained the Requirements Traceability Matrix (RTM) & Software Requirement Specification (SRS).
• Prepared Business Requirement Documents (BRD), process flows, UML diagrams, business and system use cases and involved in Functional analysis.
• Prepared Functional Specification Documents, AS - ISand TO-BE workflows.
• Experienced in performing Gap analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirement
• Conducted User Acceptance Testing (UAT) and supported quality assurance/database testing process by using database technologies such as SQL, Oracle and Teradata.
• Experience in RDBMS, including Normalization, Stored Procedures, Constraints, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors, Database Objects such as Tables, Schema, Indexed Views and User Defined Functions for data definition, manipulation and access.
• Other domain knowledge includes customer relationship management (CRM) and supply chain management (SCM).
• Good knowledge on Hadoop major Hadoop distributions components like HDFS, SPARK, HIVE, HBASE, SQOOP, KAFKA, MAPREDUCE, PIG Infrastructure Support Environment
• Ability to rapidly learn new concepts and determining priorities, schedule work, and meet critical deadlines within budgetary guidelines.
• Possess excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS:

BigData/HadoopEco system Components: Apache Hadoop, HDFS, Map Reduce, Hive, Pig, HBase, Impala, Sqoop, Oozie, Flume, Kafka, Spark, Cassandra

Operating Systems: Linux (RedHat, CentOs), UNIX, Windows

Programming Languages: Scala,Shell Scripting, SQL, Hive QL, SQLand Python

Databases: SQL Server, DB2, Oracle 9i,10g,11g, MySQL

NoSQL: HBase, Cassandra

Methodologies: Rational Unified Process RUP, SDLC, Waterfall, Agile (Scrum), UML

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

BUSINESS ANALYST

Responsibilities:

• Developed frameworks to address data, analytics, and strategy development needs
• Implemented designs into executable software (SQL, SAS, UNIX, and Business Object, Crystal report) and performed validation testing
• Documented developed tools and provide user training
• Built presentation layers(PL) with large complicated dataset for the reporting and modelling needs (CRA PL, and Home Insurance Scoring Data PL), and documented Metadata for the PLs
• Streamlined the reporting process through tuning SQL and SAS script and automated the daily reporting process
• Completed regulatory reporting, data automation and integration projects for the Fund Administration Financial and Regulatory Reporting Teams
• Implemented the full project life cycle phases including requirements gatherings, development and quality assurance.
• Conducted user interviews at both in-house and client locations for requirement elicitation.
• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Designed an integrated Enterprise Data Warehouse (eGRC) system to support BOA's requirement for Governance, Risk, and Compliance
• Identified, researched, investigated, analysed, defined and documented business processes requirements and Use Case scenarios.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Assisted with UAT (User Acceptance Testing), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
• Worked with development and testing teams to accomplish timely release objectives.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors

Confidential, MN

Business Analyst

Responsibilities:

• Responsible for starting RUP and UML Processes for creation of documentation to use by IT Team.
• Created Requirement Specification Documents based on interviews with End Users, JAD Sessions and analysis of their existent systems.
• Created Use Cases, Use Case Models, Work Flows, and System Specification Document Using RUP Methodology.
• Analysed end-user requirements, their strategies, and their objectives to create Requirement Specification Documents, Use Cases.
• Work responsibilities primarily involved understanding the business logic, designing requirements, communicating them to the developers, generating documentation, designing use cases, creating various diagrams like State Diagrams, Sequence Diagrams as part of project.
• Managed Regulatory Affairs product lifecycle activities for 26 New Drug and Abbreviated New Drug Application (ANDA) products with various dosage forms and packaging configurations.
• Planned, managed, prepared and submitted a full-length ANDA.
• Optimized drug development planning and deficiency tracking systems by adding database and metric functionality that is being utilized across multiple organizations.
• Served as Regulatory representative on cross-functional master change control initiative.
• Trained on eCTD Express and Insight Publisher regulatory submission software systems. Maintained Traceability matrix throughout the project
• Created standards / guidelines for business process modelling, Use Cases, Work Flows, Data Dictionary, and requirements specifications.
• Mentoring end-users on requirements specifications techniques and the software development life cycle.

Environment: SQL, ETL, SSIS, MS SQL server database, Microsoft office suite, XML.

Confidential Jersey City, NJ

Business Analyst

Responsibilities:•

• Perform process analysis and document the business processes for stocks/trade, transaction reports.
• Create detailed user stories and acceptance criteria from high level requirements
• Proactively communicate with the internal and external customers to analyse informational needs
• Interacted with several Investment banks to support UAT testing for them
• Collaborate with developers, SME's to establish technical vision and analyse functional requirements
• Conducted meetings with several Investment banks to resolve their queries on Schemas
• Prepared comprehensive business and functional requirement documentation
• Modified requirements on fixed income securities which contracted with equity securities
• Participated in UAT testing for the portals of investment banks
• Created System test plan so that major functionality is tested
• Develop comprehensive test scenarios as documented in Business requirement document
• Updating unique Trade Identifier (UTI) / Unique Swap Identifier (USI) to process trade reports
• Review/Updated business requirements for Credit, Rates, Commodities, FX and ETD asset classes
• Updating and directing the defects to Risk management team according to the need & priority
• Assisted QA Team in defining Test sets, create test scenarios on HP ALM
• Perform impact analysis using spreadsheet and resolve client issues for various functionalities
• Worked closely with the risk management team/operations team in documenting the systems design
• Actively participated in the UAT transition, retested UAT defects and updated comments in JIRA
• Participated in studying the functions of new system and doing risk analyst of the new functionalities

Environment: Windows Embedded Standard 7, MS Office 2010, MS Access ALM, MS Visio, JIRA 5.2, Altova XML Spy, MS Outlook 2010, QTP