SUMMARY

• A System Analyst with over 5 years of experience in Data Analyst, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Experienced Data Analyst/Business Analyst in IT, Banking and insurance industry. Experienced with different Relational databases like Teradata, Oracle and SQL Server.
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
• Extensive knowledge in RDBMS, Data Warehousing, OLAP and OLTP.
• Very experienced in creating source to target data mapping documents in a data warehouse environment and executing SQL queries in a data warehouse environment In - depth knowledge and understanding of Concepts of Data Warehouse
• Tested data quality for MDM, customer data integration and Match-Merge process
• Business Intelligence, OLAP, OLTP, Star / Snowflake Schemas and Data Modeling (Physical/Logical/ER-Diagrams) etc.
• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
• Experience in testing Business Intelligence reports generated by various BI Tools like Tableau, Cognos Series and Business Objects.
• Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models.
• Experience with designing and verifying databases on DB2, Oracle, Teradata, SQL Server RDBMS using Entity-Relationship Diagrams (ERD).
• Experience writing SQL Queries for Data Validation and Data Integration.
• Good experience of working with the QA methodologies and processes.
• Proficient in developing and executing Test Procedures, Test plans, Test scripts, test result validation, performing functional, usability, stress testing and ensuring that the software meets the system
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.

TECHNICAL SKILLS

Analysis Methodologies: Scrum, UML, Agile methodology, Waterfall methodology, SWOT, Cost-Benefit Analysis, Gap Analysis.

Databases and Tools: MS SQL Server 2008, Teradata, SAP Sybase, MySQL, DB2, Oracle, Hadoop

Operating Systems: Microsoft Windows XP, UNIX

Quality Management: HP ALM, Quality Center, RM Track

Business Modeling Tools: Microsoft Visio, Share Point, Collabnet

Reporting: Crystal Reports, Business Objects, QlikView, Tableau

Project Management: Microsoft Project, Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Wilmington DE

Sr. Business/Data Analyst

Responsibilities:

• Involved in the complete SDLC- (System Development Life Cycle) from Requirement gathering to actual delivery of the Extracts which include all the loan origination and servicing data across:
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Created Extensively involved in Data Extraction, Transformation and Loading (ETL process) from XML to the staging area and from Staging to ODS using Informatica Power Center.
• Designed and implemented complex SQL queries for QA testing and report/ data validation.
• Write complex SQL queries against the target Oracle database to generate reports and compare against legacy Access database reports
• Tested the data acquisition, data transformation and data cleansing approach for the MDM implementation.
• Experienced in Extracting Data from Mainframes Flat File and converting them into Teradata tables using SAS PROC IMPORT, PROC SQL etc.
• Monitored performance, integrity to optimize SQL queries for better efficiency
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period of time.
• All DDM enhancements that are required to support the release, including: new columns, dimension and fact tables, look-up/shadow tables, and subject areas.
• The required data elements from each source system (where the data originates), the appropriate target columns in the DDM for these data elements (to where the data flows), and the transformation rules that are required from the Staging to the DDM (From which reporting is done).
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
• Created SRD (System Requirements Doc) to facilitate the ETL team to develop their SDS (System Design Specification doc)
• Conducted meetings with IT, Testing and business to explain the Source to Target mappings and the business logic so as to be consistent in the final out put/product.
• Analyzed Complex dashboards in tableau using the various sources of data from Excel sheets, Teradata, SQL Server, Oracle databases.
• Created pivot tables in Excel by getting data from Teradata and Oracle.
• Analyze complex SQL queries of in scope reports and identify critical elements, complex calculation logics and capture them in requirements template
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Developed strategies with HPALM (Application Lifecycle Management) for stress testing and UAT (User Acceptance Testing)
• Tested data quality for MDM, customer data integration and Match-Merge process
• Created and managed project templates, use case project templates, requirement types and traceability relationships

Environment: ETL Informatica, Tableau,MDM, MS Access, SQL, PL/SQL, Oracle SQL Developer, Teradata, Teradata SQL Assistant, Erwin, MS Excel, MS Word, Visio, MS PowerPoint, MS Visio, Ms Project 2010, Windows 7, SharePoint

Confidential, Salt Lake City, Utah

Business/Data Analyst

Responsibilities:

• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case.
• Used SQL queries for organizing and abstracting data from MS access databases, created reports, forms on MS Access.
• Tested MDM platform growth towards maturity models
• Captured Data flow diagrams and formatting of the data flowing through interfaces.
• Accumulated system requirements from various departments like accounting, retail, IS (Information Systems) through surveys and interviews.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Created Data mapping, logical data modeling coordinating with data architects, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Involved in Logical & Physical Data Modeling.
• Scripts, and Stored Procedures in Database Servers.
• Test newly developed features to ensure proper functioning prior to release to QA for multiple MDM processes

Environment: SQL, PL/SQL, ETL Informatica, MDM,HP QC /ALM, Agile, XML, Teradata, Teradata SQL Assistant, Visio, Erwin, Windows and UNIX, TOAD for Oracle 10g, MS SQL Server 2008R2, Excel, Access, MS PowerPoint, MySQL, MS Excel, BI Business Objects.

Confidential, NYC

Data Analyst

Responsibilities:

• Conducted several Requirement Gathering Sessions for gaining detailed requirements at various levels of Businesses.
• Participate in developing test plans, including regression tests, for newly developed features in MDM
• Experienced in executing a project following Agile Scrum methodology.
• Initiate and facilitate project kick-off activities. Manage dependencies between the Scrum teams and third parties, release managers, or between the Scrum teams.
• Creating workflow and process-flow diagrams in MS Visio for various projects.
• Experienced in handling transition and hand-overs and tracking required tangibles associated with the deliverables.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Worked as an Interface between the users and the different teams involved in the application development for better understanding of the business and IT processes
• Designed and implemented basic SQL queries for testing and report/data validation.
• Worked closely on system enhancement projects for improving functionality of current systems right from the change request intake form to production.
• Provided analysis, understanding and business perspectives on many maintenance and enhancement issues.
• Escalated problems and issues to Business Owners that required an impact analysis that provided the necessary workarounds required

Environment: SQL, PL/SQL, Oracle,MDM, ETL Informatica, SQL Navigator, Quality Center, XML, Erwin, Visio, Teradata, Visio, AGILE, Erwin, Mainframe systems, MS SQL Server 2008, MS Excel, Windows Server 2008