SUMMARY

• Financial Service Industry experience as a seasoned data analyst professional
• Organized, innovative and self motivated individual with strong communication and intra personal skills
• Experience with Relational Database Management Systems including SQL, MySql, Oracle and IBM DB2 UDB, SQL, Toad, DBArtisian, Squirrel
• Strong understanding of the System Development Life Cycle (SDLC) conducting Rational Unified Process (RUP) and Agile methodologies.
• Experienced in Data warehousing (ETL, Mining, Analytics), data migration and data infrastructure
• Experienced in Business Requirements, Functional Requirements, Non - Functional Requirement, Report Specification, Data Requirements, Data Mapping, Use Case Specifications and Unified Modeling Language Models (UML).
• Strong Financial Product noledge of Securities, Equity Securities, derivatives such as interest rate swap, Capital Markets, Securities Trading, Investment Banking, Fixed Incomes, and Mortgage Back Securities such as CMBS, ABS.
• Facilitated in UAT, prerelease testing, and automation using HP ALM, Cucumber, and Zephyr
• Strong noledge on Cucumber framework using Java & Selenium.
• Strong noledge of agile principals and facilitation techniques of all sprint ceremonies
• Facilitated in UML Blueprinting (Sequence and Class Diagrams) using Visio
• Strong noledge of SQL used it for validation of ETL and general testing

TECHNICAL SKILLS

Requirements/Process/Modeling tools: Doors, MS Office Suite, MS Visio, Balsamiq, SnagIt, Rational ClearQuest, DB Visualizer, Toad, Cucumber, MqSQL, HP ALM, JIRA, Rally, SharePoint

Data Analystics: SQL, OLAP Data Warehouse, OLTP Databases, E-R Diagram, DFD Diagram, Rally, SQL Server 2012 Business Intelligence (SSIS, SSRS, SSAS)

Operating System: Windows 95/NT/2000/XP, UNIX, LINUX

SDLC Methodologies: Traditional WaterFall, Agile, Hybrids

Project Management: MS Project (PERT, Gantt Charts), Excel Spread sheets

Business Process Modeling: Use case model, BPMN, Use Case Diagram, Behavior Diagram (Sequence and Activity Diagram) based on UML

Reporting Tools: MicroStrategy, Cognos, Business Objects

Languages: .NET, Java, C/C++, SQL, PERI, Windows 95/98, NT, 2000, XP, Unix, DOS, and Sun Solaris. (Query execution & platform)

PROFESSIONAL EXPERIENCE

Confidential, Reading, PA

Responsibilities:

• Migrated Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS), BCP and DTS utility.
• Created, Configured and Fine-tuned ETL workflows in SSIS.
• Experience in ETL processes involving migrations and importing/exporting data between different sources using SSIS.
• Created Data Flow Diagram (DFD) and Entity Relationship Diagrams (ER-Diagrams) to define requirements specifications for business intelligence reporting in Micro Strategy.
• Performed continuous testing throughout the sprint as and when stories were delivered in local development build using Excel, SQL, and Operational reports UI validations.
• Facilitated the creation of Drill through, Sub, Parameterized and Drill Down reports using SSRS
• Participated in periodic reporting validation with the UAT team using SQL to ensure data reconciliation
• Captured business requirements from different business sectors, created rules associated with new tables being created per dis initiative.
• Facilitated in the creation of write back functionality in SSAS to write the data back into the cube
• Conducted GAP analysis of current and future state workflows within different departments and identified gap remediation needs.
• Identified processes and for creating business process flows per BPPN standards during the release planning sessions.
• Facilitated in sizing of the stories and monitoring of story allocations per team velocity.
• Facilitated in Sprint Ceremonies (Sprint Planning, Sprint Retrospective, Sprint Demo)
• Participated in daily scrum and was responsible for tracking hot topics and impediments.
• Leveraged process flow, detailed workflows, (in MS Visio) and screen mock ups (in Balsamiq) to facilitate in grooming of the stories.
• Conducted continuous grooming session with the team, four times per sprint.
• Documented Acceptance Criteria documents
• Created and managed all stories, acceptance criteria and issues in JIRA.
• Participated in continuous solution design with the team by creating mock ups, sequence and diagrams.
• Performed test execution and, created, linked and managed defects in HP ALM.
• Created test plans and test cases using Zephyr in JIRA

Confidential, Summit NJ

ETL Developer

Responsibilities:

• Worked with focus groups and conducted walkthroughs with the end users and stakeholders to elicit the modification requests from the user to upgrade or modify the specifications for the product.
• Liable for SDLC documentation from the beginning of gap analysis until the end of testing.
• Extracted data from various heterogeneous sources like DB2 and Flat Files
• Lead role with firm central data modelers team in setting up the History and Data mart setup and provided field to field mapping from OLTP to Data Mart setup for reporting and auditing requirements.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Operated requirement elicitation sessions and interviewed stakeholders to get better understanding of business objectives.
• Documented functional requirements using blueprint requirement tool.
• Liable for simplifying meetings with internal and external stakeholders, meeting time and following up on any action items dat have to be further discussed.
• Constructed use cases, sequence diagrams, process flow, data mapping, data information modeling, and gathering business requirements.
• Deciphered business requirement into functional specifications to satisfy the strategic goal.
• Worked with nondomestic technical and development teams.
• To run reports for Business Users, COGNOS series 10.1 was used.
• Communicate with business teams to comprehend and document their KPIs, data sources and correlated solution requirements.
• Defined KPI and its calculation.
• Communicate with Enterprise Architecture and Program management to determine and assess solution vendors dat could halp support processes and requirements.
• Worked in change request processing following SDLC and Analysis Skill center guidelines and standards as well as in change management activities including scope management.
• Plan and manage the requirements gathering process as well develop requirements gathering plans and timelines for the project.
• Made detailed documents for document scope and project charter.
• Elicit and document requirements for enhancements dat gave the product a better value which were related to data sources, and BI/Reporting tools.
• Help locate the SOPs where applicable and planned and coordinated User Acceptance Testing.
• Help sustain UAT testing activities by using TFS as the tool to track the progress of Agile.
• Help in the facilitation of transition to solutions delivery.

Confidential, Jersey City, NJ

Responsibilities:

• Served liaison between project managers, stakeholders, and software development team to gather requirements and documented workflows and results into the Business Requirement Document (BRD).
• Involved in creation of automation framework in Selenium WebDriver using behavior driven approach like Cucumber.
• Involved in developing Ad-hoc reports and complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Details
• Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, functions and stored procedures
• Prepared Functional Specification Document (FSDs) for various business functionalities by translating BRD’s.
• Conducted grooming sessions with the product owner two sprints in advance of the targeted sprint for the story.
• Documented and delivered Functional Specification Document (FSD) to the project team.
• Conducted Joint Application Development (JAD) sessions with business unit owners and technical team to capture business requirements and system behavior.
• Captured and made executive presentations of the issues and risks inherent in as-is process for review by senior management.
• Evaluated task captured through data analysis, application walk through, business process reviews, surveys, and workshops.
• Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.
• Created and applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram in TFS for upstream business flows.
• Conducted walkthroughs with Development Team and facilitated UAT with Business Stakeholders/Users.
• Developed activity diagram (AD), sequence diagram (SD) and object orientated design (OOD) for the software development team.
• Traced and informed business requirement changes through the lifecycle of the project using TFS while maintaining customer needs and maintain a Requirements Traceability Matric (RTM).
• Managed the stakeholder expectations and facilitated clarifications between project stakeholder and technical teams throughout the duration of the project.
• Performed gap analysis between current performance and desired performance (me.e. critical customer requirements).
• Created Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Provided implementation assessment, strategy, and mentoring services for UML and RUP.