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 teh source, destination, and business rules
• Extensive experience in working wif data feeds from several data vendors including Bloomberg and Reuters for market & data management
• Extensive experience in assisting project manager wif 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 teh 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 wif financial securities and metrics such as VaR, Yield, YTM, Duration
• Understanding of financial protocols such as FIX, FpML, XML, and SWIFT
• Experience wif 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 teh 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 wif development team and business, monitored teh open defects status, re-tested fixed defects, and generated reports
• Experience in managing Requirements Traceability Matrix (RTM) to ensure effective tracking between teh business requirements and test deliverables
• Proficient in advanced MS Excel skills, wif 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 teh 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 wif 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 teh 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 wif key stakeholders to design, develop and deploy process redesign, and tool implementation, where needed
• Communicates wif Business partners and act as liaison between wif developers, testers, and implementation specialists
• Supports teh resolution of data, information and processing challenges that are having an adverse impact on teh operational environment and/or business performance
• Leads teh 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 teh 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 teh 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 teh 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 teh gaps between existing functionalities and proposed system; documented teh required enhancements to meet teh user requirements
• Acted as a liaison between business end users and teh technical team to manage overall project communication, resolve discrepancies, and coordinate resources
• Organized JAD sessions wif QAs, Developers, and business partners to analyze & verify teh functionalities against user requirements for completeness & feasibility and to evaluate system development time / cost
• Collaborated wif 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 teh process flow of teh application
• Created Requirements Traceability Matrix (RTM) to track teh status of requirements through their bi-directional association wif test cases & deliverables for change impact analysis
• Extensively involved in defect tracking and management - open defects, prioritizing defects, assign to teh 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 wif 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 teh 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 wif Bloomberg & Markit to map teh market / data feeds - created Data Mapping document and assisted ETL team to setup teh 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 teh expected system
• Designed and created several GUI mock-up screens as per teh business requirements working closely wif 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 teh business users and teh technical team to review routine project activities, identify & eliminate teh project complications, and ensure streamlined application development
• Performed GAP Analysis to identify redundancies in existing business processes and document respective enhancements in teh system as per teh priority
• Performed teh requirements analysis by facilitating teh JAD sessions involving business users, SME and technical team eliciting & uncovering cross-functional implications and resolving teh discrepancies
• Assisted Data Modeling team for designing conceptual, logical, and physical data models, creating Entity Relationship (ER) diagrams documenting teh data objects, association, and database dependencies
• Collaborated wif 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 wif defect tracking tools to track teh open/fixed/closed bugs during teh development of teh 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 wif increased efficiency; integrated web applications wif mainframe systems
• Followed Agile SCRUM, documented teh business requirements and business rules in teh BRD and created teh FSD by transforming teh 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 teh client and teh team to build teh reporting system, communicated effectively wif teh technical team, assured that all artifacts are in accordance wif 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 teh system behavior
• Designed and implemented complex SQL scripts for data validation testing and back-end testing
• Assisted teh 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 wif database design team to assist in Data Modeling for development of conceptual, logical and physical data models to interpret complicated Entity Relationships
• Assisted teh QA team wif teh 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 teh Requirements Traceability Matrix for reviewing and tracking requirements
• Managed teh 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 wif teh appointed distributor as well as wif appropriate contacts in teh category teams
• Facilitated client meetings to gather all requirements, formulated business process specifications and application functionalities in order to understand teh value proposition(s) of teh project
• Performed GAP analysis to analyze and document teh differences between existing business processes and future business process
• Contributed towards teh strategic and day-to-day running of teh distributor business
• Provided analytics & insights to drive business performance and inform pricing & investment wifin 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 teh 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 wifin 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 teh project