SUMMARY:

• Over 7 years of experience in Data Analysis, Business Modeling, Requirement Gathering and Analysis,.
• Excellent understanding of business processes and functionality, experience converting these into functional requirements and system requirement specifications (SRS) and preparing Business Requirements Documents (BRD).
• Strong knowledge of Testing including Java, C#, C, C++, XML, JavaScript, HTML.
• Extensive experience with process modeling using UML Flow Charts, Activity, Use Case diagrams, XML Diagrams, ER diagram using Microsoft Visio and Enterprise Architect.
• Strong working knowledge of SDLC methodologies like Rational Unified Process, Waterfall and Agile Scrum methodologies.
• Conducted Joint Application Development (JAD) sessions.
• Created wireframes and page mock - ups for visualization of GUI design and business processes using different tools and HTML
• Designed and configured objects for Funds Management & Claims Management; Lead and delivered master data conversion and migration from Siebel CRM to SAP CRM
• Created and managed the change requests using Configuration and Change management process and conducted feasibility analysis for those changes
• Experience in Data Analysis, Data Modeling, Data cleansing, preparation of scenario based data and clarification of requirements with SME (Subject Matter Expert).
• Extensively worked on Data analysis and reporting the data using advanced Microsoft Excel skills. Effectively used vlookup, regression, pivot tables, etc to map data to informative reports.
• Write detailed defect reports for bugs found during test execution using Jira bug tracking tool.
• Programming in Java, Matlab, Mathematica, Visual FoxPro, and R using RStudio & RExcel
• Experience with data warehousing techniques like Slowly Changing Dimensions, Surrogate key, Snowflaking etc. Worked with Star Schema, Data Models, E-R diagrams and Physical data Models.
• Proficient in the use of Microsoft Word, Excel (Macros, VLOOKUPS, and Pivot Tables), PowerPoint, Visio, Windows 2000 and Professional, Microsoft Outlook, Microsoft Project, SAS, and SQL .
• Experienced in data analysis, data migration and data modeling activities
• Working experience in SQL, PL/SQL programming, UNIX
• Strong knowledge of software architectures like client-server, n-tier, and service oriented architecture (SOA) and J2EE/ XML and Web-services like WSDL, SOAP etc.
• Bloomberg used for bond set-up & cash flow update, futures characteristics (e.g. Cheapest-to-Deliver)
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector) in Tableau, Oracle OBIEE, Business Objects & Cognos reporting tool.
• Experience in working with Web Intelligence, Business Objects Universe and Crystal Reports from various sources such as Oracle, Teradata, MS SQL Server, Sybase.
• Involved in the upgrade of SAP ECC 5.0 to ECC 6.0.
• Successfully created and matured the use of a Master Data Management (MDM) and Metadata Repository
• Excellent working knowledge of Microsoft Office Tools including MS-Word, MS-Project, PowerPoint, Excel and Outlook.

TECHNICAL SKILLS:

Operating Systems: UNIX, Linux, MS-DOS, Windows 2000/2003

Tools: /Utilities/Methodologies: Enterprise Architect 9.0, MS Visio 2007, MS Project, Snagit 11.0, Balsamiq Mockups 2.2, TOAD 9.0, SQL Developer 3.2, CCM(Trouble Ticket Management), BMC Remedy IT Service Management 7.0, CR Tracker, RUP, Agile, Waterfall, Six Sigma, OOAD, UML, Business, Process and Data modeling, Oracle OBIEE, Business Objects, Cognos, Tableau, Informatica, OOAD, HTML

Testing Tools: Quality center, Clear Quest

Languages: SQL,PL/SQL, Shell Scripting, HTML, XML, C++

Databases: Oracle 9i, MS Access

Software Packages: MS Office 2003/07, MS Project 2000, Adobe Dreamweaver CS5

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

Sr. Data/Business Analyst

Environment: MS SQL Server, Teradata, MS Office Suite, SQL, Microsoft Sharepoint, MS Visio, MS Project 2010, Microsoft Windows 2007, Rational Requisite Pro, Tableau, Vlookup, Hlookup, SAS

Responsibilities:

• Performed Back-End testing with Data Analysis to validate database contents by writing and executing SQL Queries.
• Analyzed and mined business data to identify patterns and correlations among the various data points.
• Conducted data mapping and modeling for reporting data elements.
• Performed Statistical analysis to determine if the desired changes are profitable to the company
• Performed Data Analysis, Business Modeling, Requirement Gathering and Analysis.
• Collect product quality data, audit, create reports and monitor all data for accuracy.
• Manipulating, cleansing & processing data.
• Experience with configuration and Implementing of SAP ECC 6.0,Ehp 5 Net weaver BW 7.3, PI 7.3 (Process Integration), CRM 7.0, SRM, XMII, NWDI, TREX 7.1, BOBJ 3.5, 4.0 and Enterprise Portal
• Study raw data, draw conclusions and develop recommendations.
• Understanding business processes and functionality and converting these into functional requirements and system requirement specifications (SRS) and preparing Business Requirements Documents (BRD).
• Develop a theoretical solution aimed at defect preventions and product improvement. Research and test accordingly and collect data to prove or contradict the theory.
• Analyze and report the data using advanced Microsoft Excel skills. Frequently used Vlookup, Hlookup, Linear Single and Multiple Regressions, Pivot Tables, Macros and other functions to map data to informative reports.
• Use SAS and SQL to perform DML operations.
• Make technical recommendations for Project directions based on business requirements, priorities, and data model and analysis findings with SQL Assistant and PL/SQL Developer interface.
• Utilize the PL/SQL Developer interface to query the databases and profile and examine source data.
• Developed complex queries and packages using PL/SQL for many projects.
• Understood the Business Logic, User Requirements, and test-objectives to develop test scenarios for UAT.
• Communicated and interacted on a regular basis with the development team during the different stages of the projects.
• Expertise with MDM and Data Modeling.
• Use of MATLAB for digital signal processing and developing prediction algorithms to be used for harvesting energy through microcontrollers.
• Utilized Quality Center & JIRA to manage defect tracking, bug fixes, test scripts, and report defect.
• Created documentation and PPT presentations for the end users.
• Used SQL Queries to analyze the data.
• Used 3 sources for yield curves: internal system, fund admin, Bloomberg
• Administered and managed the company SharePoint 2010 environment and developed sites, lists and libraries as well as managed libraries' and sites' permissions.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Used advanced Microsoft Excel for providing prototype of reports prior to actual Tableau implementation.
• Created the POC and prototype Tableau reports and dashboards with the key metrics
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process’ and revenue streams aimed towards problem solving.
• Performed Installation of SAP ECC 6.0 EHP 6 along with the post installation activities.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.

Confidential, San Francisco, CA

Sr. Data/Business Analyst

Environment: MS Visio, Oracle 9.0, Java, J2EE, Java springs, Java Struts, XML, SOAPUI, MS Visio, Snagit, Balsamiq, RUP, Interact Universal Banker, Business Objects XI R3, HTML

Responsibilities:

• Determine the policies concerning credit transactions like interest rates, credit period and loan amount upper/lower limits, along with the finance manager.
• Oversee the preparation of all documents related to extending credit and verify the details for accuracy.
• Performed Gap analysis by identifying existing processes and technologies, documenting the enhancements needed to meet the end state requirements.
• Functioned as the primary liaison between the ETL developers, PMs and Business teams
• Led the JAD sessions and was responsible for the field-to-field mapping activities between the source and target for the subject area
• Proven Execution skills in Leading and Managing Data governance, Data Architecture, Data quality, Data Modeling, Data and MDM (Master Data Management) Initiatives.
• Devised the business transformation logic to be implemented in the ETLs and developed validation scripts for the same
• Was responsible to ensure that standards are followed for missing and default value handling
• Worked with the data modelers to come up with the fact table structures that conformed the business reporting requirement as well as performance requirements
• Used Teradata SQL to Query on large datasets (approx 30 TB)
• Mined data for quality via SAS SQL statements (anomalies, pattern breaks); identify impact; suggest resolution options.
• Supported to large corporate data warehouse (with many data marts) on SAS platform with Business Objects reports.
• Provided leadership over the SAS Physical/Semantic Modeling project phases.
• Came up with Test cases and performed QA and User Acceptance Testing on data processed into the EDW
• Worked as Project point of contact for teams in connecting systems like SAP ECC, BI, WebMethods, Sales Force, Siebel CRM, CHS, and others
• Created models for many upper-level physics courses to represent and describe physical phenomena. Matlab, Mathematica.
• Generated POC ETL scripts using Teradata SQL for giving demo on complex business transformation logic to implement the backout logic
• Handled changes and evaluated the effort and feasibility of accepting adhoc scope or requirement changes.
• Advanced use of Microsoft excel for giving a quick picture of various key metrics to the business users that helped in getting high level view of the data.
• Responsible for identifying and documenting business rules and creating detailed Use Case.
• Conduct User Acceptance Testing.
• Used SQL queries to fetch different dashboard related manual reports and later automated them to cron jobs.
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other.

Confidential, Concord, CA

Business / Data Analyst

Environment: Oracle 9i, XML, MS Excel, MS Access, MS Word, MS Visio, MS Visio, MS Project, XML, SOAPUI, SQL, Agile Scrum Methodology, Informatics 7.1, OBIEE 10.x, Oracle BI, TIBCO BW, HTML

Responsibilities:

• Conducteddifferent sprint meetingsand identified different requirement-gathering sessions with stakeholders to understand the project goals, objectives and requirements.
• Facilitated JAD (Joint Application Development) sessions department stakeholders and team in order to identify and document Business requirements.
• Gathered requirements from business to define scope and prioritize the critical KPIs for business reporting needs and created BRDs for the same
• Educated and consulted the team on writing highly tuned Teradata SQL queries keeping in mind the size of the underlying tables and architecture of the DW
• Worked with Data Modelling team to come up with the aggregate and denormalized table structures for some specific business reporting requirement or/and improve performance of reports
• Worked with ETL teams to deliver the reporting layer composed of the highly tuned and aggregated tables designed from the base tables
• Worked closely with different cross functional teams for the data from online application to different internal applications via XML through the middle layer system.
• Conducted functional testing and database testing for validating whether the data is moving to required fields.
• Prepared custom reports and performed SQL query and data analysis
• Maintained different documents in the project.
• Worked in OBIEE for building answers, Dashboards and custom business reports.
• Engineered requirements around the KPI’s and metrics of internal and field reports to be generated in Oracle BI.
• Conducted SAP CRM and interview to increase the bench strength within the practice.
• Maintained thedefect tracking inHP Quality Centerbased on bugsfound during the testing phases.
• Used SQL to retrieve information from the database and provided manual SQL reports to senior management.
• Developed an As-Is and To-Be matrix to depict the interest calculation for accounts.
• Worked closely with development team to analyze the flow of data from online banking to different other systems through the middleware TIBCO BW middle ware from different application layers.

Confidential, Hoffman Estates, IL

Business Analyst / Data Analyst

Environment: Java, Oracle, Microsoft Visio, MS Visio, MS Project, Informatics 7.1, Business Objects x, Windows XP, SAS

Responsibilities:

• Performed GAP analysis and documented the difference between the current system (As-Is) and the desired target system (To-Be) using Microsoft Visio 2007.
• Prepared the Business Requirements Document (BRD) and Functional requirements Document (FRD) and Created Diagrams such as Use Case, Activity diagram and detailed use cases.
• Created mockups and wireframes using snagit and balsamiq tools.
• Defined/refined KPI's and Queried databases using SQL.
• Created various reports such as 3 way match reports for Purchase Orders, General Ledger balance reports, and Click-Stream analysis reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables, Joining tables and formulas.
• Checked Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using Aggregate Awareness, Contexts, and Aliases in Information Design Tool for the Universe.
• Exported Universes to Repository for making available to Business Objects users and Reports Developers.
• Defined User Acceptance Test Plan and rollout schedule and Prepared User Manual and Release Notes for users.
• Fetched manual SQL reports for the different credit cards and saving/checking account customers post rolled out of the system.
• Worked with internal architects and assisting in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Used SQL Queries to analyze the data and created the processes in To-Be diagram with the flow of data from one system to another.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Validated and verified requirements that needs to be accommodated using SQL queries.

Confidential, McLean, VA

Business Data Analyst

Environment: RUP, HTML, Rational Requisite Pro, Enterprise Architect, XML Spy the editor, Mainframe (COBOL, JCL), SQL, DB2 (QMF), Oracle, Quality Center 8.2

Responsibilities:

• Used Requisite Pro to document requirements, associated change requests with requirements and connected requirements with Use cases
• Requirements gathering and project lead on initiatives to implement Straight-through processing (STP) for the Asset and Funding Trading Desks for data mapping trade tickets on securities and derivatives .
• Used Teradata SQL for firing SQL queries to perform data analysis.
• Participated in Dimensional Modeling sessions.
• Worked on Cost- Benefit Analysis, SWOT Analysis & Feasibility Analysis.
• Was involved in analyzing the data and providing business insights & forecasts
• Prepared detailed Business requirements documents (BRD) and assessment of current OTC derivatives instruction trade management processes for front, middle and back office, data, data attributes and security master database
• Performed Usability Analysis to efficiently investigate and validate, information architecture, navigational structure, visual design, and user interaction
• Prepared project related presentations and provided reports to the higher management
• Developed Use case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams to walkthrough developers and other stakeholders to better understand the business process
• Identified the business critical areas from the user perspective and assessed essential change management scenarios by developing process models for the same