SUMMARY:

• 9+ years of professional experience as Sr. Business Analyst in financial market and banking
• Working paper on predictive analytics selected for presenting at SAS Global Forum 2018 in Denver, using statistical methods and machine learning techniques such as Logistic Regression, Decision Tree Ensemble Learner Classifier, Gaussian Naive Bayes, Gradient Boosted Classifier, and Regression Techniques ed in data science forum for creating impressive Social Network Visualization via TeraData App - center & Gephi, demonstrating key network parameters - Centrality, Betweenness, Closeness, PageRank, Motif, Clustering Coefficient, Degree Distribution, Assortativity, Modularity of Directed & Undirected Networks
• Strong experience in SDLC methodologies Waterfall, RUP, Agile (XP and Scrum), RAD, Iterative, and Incremental
• Demonstrated expertise on Analytics Technologies and Data Structures Computing
• In-depth understanding of Equity Stocks, Corporate Bonds, Muni’s, T-Bills, T-Notes, T-Bonds, Mortgage Backed Securities (MBS), CMO’s, Asset Backed Securities (ABS), CDO’s, Derivatives (Futures, Forwards, Options, Swaps), Credit Derivatives (CDS, TRS, CLN) and Money Market instruments (Commercial Paper, Repos)
• Extensive experience in eliciting, analyzing, prioritizing, and documenting business requirements (BRD); designed, identified, and documented system specifications (SRS)
• Proficient in modeling application applying UML guidelines - use cases, activity diagrams, business process flowcharts, data workflows, interface designs, using MS Visio / Rational Rose
• Strong experience in writing SQL queries for data validation, data retrieval, and data analysis for reporting
• Expertise in building data dictionaries & data mapping capturing the source, destination, and business rules
• Extensive experience in working with data feeds from several data vendors including Bloomberg and Reuters for market & data management
• Extensive experience in assisting project manager with strategic planning, project plan, resource management, scope definition, and project deliverables scheduling
• Proficient in conducting GAP analysis, SWOT Analysis and Cost-Benefit analysis to compare the performance, cost and benefits of already existing and to-be-built application
• Expertise in organizing, facilitating, and leading several JAD sessions to address open issues & system design
• Understanding for analyzing financial risks likes credit risk, market risk, operational risk, interest rate risk, volatility risk associated with financial securities and metrics such as VaR, Yield, YTM, Duration
• Understanding of financial protocols such as FIX, FpML, XML, and SWIFT
• Experience with security data & financial analysis; regulatory compliances such as Basel II, Dodd-Frank
• Proven expertise in assisting DBAs to create ER diagrams (conceptual, logical, and physical) identifying the entities, associations, attributes, and data integrity rules & dependencies, using ERwin
• Experience in assisting QA team to prepare Test Plan, Test Scenarios, Test Cases and Test Scripts and to perform Functional testing, Integration testing, System testing, Performance testing, Stress testing, Smoke testing, Regression testing, and supporting in User Accepted Testing (UAT)
• Expertise in handling defect tracking lifecycle - effectively liaised with development team and business, monitored the open defects status, re-tested fixed defects, and generated reports
• Experience in managing Requirements Traceability Matrix (RTM) to ensure effective tracking between the business requirements and test deliverables
• Proficient in advanced MS Excel skills, with focus on advanced features of spreadsheets such as macros, logical & arithmetic functions, pivot tables, VLOOKUP, and HLOOKUP
• Experience in creating advanced visualization using business intelligence application such as Tableau
• Proficiency in using SAS Enterprise Guide 9.0 to perform data integration, preparation, analytics and reporting, while using process flows to visually organize and maintain multiple projects at the same time
• Proven expertise in designing customizable applications through scalable systems capable of collecting, processing, storing and analyzing large volumes of structured / unstructured data
• Performed satellite mapping of spatial data collected from USGS to merge & dissect shape files from Landsat
• Experience in Social Media Analytics (NodeXL) - network visualization software package for Excel, imported mass tweets using social media data importers, performed advanced network analysis & automation
• Expertise in creating Data Art & Visualizations using Sankey, Sigma, Chord, Tree, Infographic design
• Solid experience in completing projects leveraging enterprise information assets, making efficient & appropriate usage of business intelligence tools - Tableau, KNIME, Frontline Solver, and Oracle Crystal Ball
• Experience in using Graph Theory, Used Map-Reduced Aster functions for Link Analysis

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/Vista/10, UNIX, LINUX

Languages: JAVA, ASP.NET, C#, VB.NET, VB Script, SQL, PL/SQL, CSS, HTML, XML

Databases: MS SQL Server, MS Access, Oracle, Sybase, TOAD, Management Studio

Business Intelligence: Cognos, OBIEE, Business Objects, SSRS, Tableau

Testing Tools: JIRA, Quality Center, QTP, LoadRunner, ClearQuest

Others: MS Project, MS Visio, RequisitePro, Erwin, Tivoli, Autosys, Confluence, DOORS, Wiki, MS SharePoint, iLog, Omgeo, Clarity, GraphML, Edge Lists, Adjacency Matrices, Graph Structures (Edges, Nodes), Statistical Programming (R, Python), Architecture, MapReduce, HDFS

WORK EXPERIENCE:

Confidential, MA

Sr. Business Analyst

Responsibilities:

• Managing end-to-end project iterations - compiling stories and documenting project artifacts in accordance with corporate SDLC policies & guidelines
• Compiling and analyzing stories (iterations) for -
• Back End changes and UI Upload to FTDR Framework
• Logic changes to FTDR framework
• Modification to Lineage / virtual view in Cisco Information Studio
• Assisting ETL team by creating data mapping document from data sources (external feeds) to databases
• Performing SQL queries for data reconciliation, data cleansing, data validation, and ad-hoc reports
• Creating Entity Relationship (ER) diagrams to identify underlying database entities, data attributes, and database integrity constraints
• Developing test plans for QA analysts, and UAT to validate the process flow
• Create, review, and manage Requirements Traceability Matrix (RTM), linking each test case to related business requirement / functional specification
• Manages defect tracking life cycle by identifying and logging defects, evaluating, prioritizing defects
• Participates/Initiates data quality efforts working closely with key stakeholders to design, develop and deploy process redesign, and tool implementation, where needed
• Communicates with Business partners and act as liaison between with developers, testers, and implementation specialists
• Supports the resolution of data, information and processing challenges that are having an adverse impact on the operational environment and/or business performance
• Leads the analysis of current processes and data lineage; recommends solutions and improved data architecture; consults as subject matter expert on impact of systems changes to business processes

Environment: CISCO Information Studio, MS Office Suite 2016, Toad - Quest Software, Toad for Data Analysts 2.6, SQL Developer, Confluence, MS Share Point, Bloomberg, TIBCO Spotfire, MS Visio, Pulse, Lucid Chart

Confidential, MA

Sr. Business Systems Analyst

Responsibilities:

• Managed & implemented system following Agile SCRUM methodology throughout system development
• Prepared the required questionnaire & interviewed business end users and SMEs to gather & analyze business requirements and documented BRD & SRS
• Performed SQL queries for data reconciliation, data cleansing, data validation, and ad-hoc reports
• Designed data mapping document capturing data source, database destination, and applicable business / logic rules to setup the ETL process for data loading process
• Extensively employed UML modeling technique to create Use Cases, Activity diagrams, Class diagrams, Swimlane diagrams, Wireframes, Business Workflows, Screen Mockups, and Dataflow diagrams
• Assisted the Project Manager in developing project plan, project charter, work breakdown charts, managing project resources, ensuring on-time & cost-efficient completion, and monitoring & controlling project
• Conducted GAP analysis identifying & evaluating the gaps between existing functionalities and proposed system; documented the required enhancements to meet the user requirements
• Acted as a liaison between business end users and the technical team to manage overall project communication, resolve discrepancies, and coordinate resources
• Organized JAD sessions with QAs, Developers, and business partners to analyze & verify the functionalities against user requirements for completeness & feasibility and to evaluate system development time / cost
• Collaborated with Data modeling team to create Entity Relationship (ER) diagrams to identify underlying database entities, relationships, data attributes, and integrity constraints
• Assisted testing team in developing test plan, test scenarios, test cases, and test scripts to conduct Functional testing, Integration testing, System testing, Performance testing, Smoke testing, Regression testing, GUI testing, and UAT to validate the process flow of the application
• Created Requirements Traceability Matrix (RTM) to track the status of requirements through their bi-directional association with test cases & deliverables for change impact analysis
• Extensively involved in defect tracking and management - open defects, prioritizing defects, assign to the concerned developers, track status, ensure fixes and summary reporting

Environment: Oracle, AGILE, ClearQuest, MS Visio, Selenium, Open Workbench, MS Project, Tableau, Java/J2EE, HTML, .NET, AJAX, VB Script, PL/SQL, XML, FIX, Omgeo CTM, Global Oasys, FXall, Autosys, SQL Developer, MS SharePoint

Confidential, NY

Senior Business Analyst

Responsibilities:

• Gathered business requirements through interview sessions with business users to document BRD and FSD
• Interviewed Traders, Portfolio Managers, SMEs, Product Sponsors, and Operations to gather / document business requirements, translated requirements to functional specifications for credit derivatives products
• Followed Agile SDLC methodology to design & implement the application
• Extensively performed complex SQL queries for data retrieval, data integrity analysis, data validation testing, reports generation, and to identify data flow break points
• Liaised actively with Bloomberg & Markit to map the market / data feeds - created Data Mapping document and assisted ETL team to setup the data integration process from data source to target data warehouse, using Informatica
• Followed UML guidelines to create Written Use Cases, Use Case diagram, Activity diagrams, Class diagrams, and Sequence diagrams providing effective visual representations of the expected system
• Designed and created several GUI mock-up screens as per the business requirements working closely with subject matter experts, system architects, and development lead
• Assisted Project Manager in preparation of Project Plan, Statement of Work, Responsibility Matrix, Detailed Schedule, Resource Allocation, and Budget Plan
• Acted as a liaison between the business users and the technical team to review routine project activities, identify & eliminate the project complications, and ensure streamlined application development
• Performed GAP Analysis to identify redundancies in existing business processes and document respective enhancements in the system as per the priority
• Performed the requirements analysis by facilitating the JAD sessions involving business users, SME and technical team eliciting & uncovering cross-functional implications and resolving the discrepancies
• Assisted Data Modeling team for designing conceptual, logical, and physical data models, creating Entity Relationship (ER) diagrams documenting the data objects, association, and database dependencies
• Collaborated with QA team to prepare test plan, test scenarios, test strategy, test cases, and test scripts to perform black-box testing, functional testing, system testing, performance testing, stress testing, smoke testing, regression testing, and user acceptance testing (UAT) to ensure application stability and integrity
• Worked with defect tracking tools to track the open/fixed/closed bugs during the development of the system
• Created and reviewed Requirements Traceability Matrix (RTM), linking each business requirement to related functional specification & test cases ensuring back & forth traceability

Environment: UML, MS Visio, Selenium, MS Office Suite, MS Project, MS Access, J2EE, Oracle, UNIX, QTP, SAS Enterprise Guide, JIRA, SQL, MS SharePoint, Quality Center, IBM Tivoli, Confluence, iLog, Wiki, ERWIN, SQL Developer

Confidential, MA

Principal Business Systems Analyst

Responsibilities:

• Analyzed existing processes to create innovative system-based solutions with increased efficiency; integrated web applications with mainframe systems
• Followed Agile SCRUM, documented the business requirements and business rules in the BRD and created the FSD by transforming the business requirements to functional specifications
• Supported development of detailed project plans, work assignments, and target dates, built checkpoints to identify missing and conflicting requirements
• Facilitated JAD Sessions to resolve issues, plan roadmap, mitigate risks and change requests, define user interface design guidelines and finalize system UI
• Acted as liaison between the client and the team to build the reporting system, communicated effectively with the technical team, assured that all artifacts are in accordance with corporate SDLC policies and guidelines
• Employed UML modeling techniques to create Use Cases, Written Use Cases, Activity diagrams, Class diagrams, State diagrams, and Sequence diagrams in MS Visio, to effectively understand the system behavior
• Designed and implemented complex SQL scripts for data validation testing and back-end testing
• Assisted the ETL development team by creating Data Mapping document to map data from various data sources (external data feeds) to targets (databases) and defined set of business rules
• Worked closely with database design team to assist in Data Modeling for development of conceptual, logical and physical data models to interpret complicated Entity Relationships
• Assisted the QA team with the development and documentation of test plan, test cases, and test scripts for performing end-to-end testing, functional testing, integration testing, system testing, GUI testing, regression testing, performance testing, load testing, smoke testing, and user-acceptance testing
• Created the Requirements Traceability Matrix for reviewing and tracking requirements
• Managed the entire Defect Tracking Life Cycle by identifying and logging defects, evaluating and prioritizing defects to ensure a bug-free application

Environment: MS Project, Visual Basic, UML, OOAD, SAS Enterprise Guide, UNIX, Java, J2EE, HTML, MS Access, MS Visio, MS SQL Server, Bloomberg, QTP, JIRA, Management Studio, Confluence

Confidential

Business Intelligence Analyst

Responsibilities:

• Responsible for success of selective Consumer Retail business & played important role in supporting business performance directly with the appointed distributor as well as with appropriate contacts in the category teams
• Facilitated client meetings to gather all requirements, formulated business process specifications and application functionalities in order to understand the value proposition(s) of the project
• Performed GAP analysis to analyze and document the differences between existing business processes and future business process
• Contributed towards the strategic and day-to-day running of the distributor business
• Provided analytics & insights to drive business performance and inform pricing & investment within sales area
• Designed business workflow models via UML techniques such as Use Cases, Activity Diagrams, Swimlane Diagrams, Wireframes, Screen Mockups, Dataflow Diagrams, and Process Workflows
• Performed as operational link between the CD management, our distributor and various Unilever teams
• Generated reporting, forecasts, tracking, insights, content - driving shopper / retail marketing activation
• Ensured promotional activities are optimized and financially attractive
• Monitored and tracked investment to ensure appropriate governance within a defined framework
• Responsible for acting as a liaison between technical and business teams for meeting client requirements and clarifying issues to ensure proper understanding
• Supported analytical and business frameworks as well as a quantitative approach to decision making
• In-charge of recruitment,, retention of workforce of 90+ sales officers for distribution in 5 districts
• Implemented scheme and innovation management. Achieved a growth target of over $1.5 million
• Drafted SQL queries to extract / access data from data warehouse for report validation and testing purpose
• Hands-on marketing analytics experience in areas such as search engine marketing (SEM), email marketing, and customer relationship management (CRM)
• Evaluated performance attribution model across both digital and traditional channels
• Developed and shared weekly and monthly reports outlining campaign performance across digital touchpoints including Paid Search, Digital Display, Social Media, and Email/CRM

Environment: MS Project, Selenium, MS Excel, ROI Application, SAS Enterprise Guide, R Programming, MS Visio, Requisite Pro, Oracle, PL/SQL, Teradata, .NET, UNIX, HTML, XML, QTP, MS SharePoint

Confidential

Research Associate

Responsibilities:

• Prepared Confidential CS Pro data dictionary
• Performed data cleaning
• Validating database tables, data preprocessing, and data aggregations
• Managed Master MS Excel datasheet of the project