SUMMARY

• 8 Years of Experience inDataAnalysis, Report Generation, Maintenance of Business Report Processes andDataVerifications and Validations
• Performeddataanalysis and createdreportingusing MS Access, MS Excel, MS PowerPoint,Data Warehouse, JD Edwards to create and managedatareportingprojects.
• Experience withDatawarehouse applications using Oracle, MS SQL Server on windows and UNIX platforms.
• Expertise in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modelling and UML.
• Good experience in Java, Python, RDBMS, PL/SQL, TOAD, Oracle EBS Apps Technical, ETL (SQL Loader), Workflow Builder, BI Publisher, Tableau, DENODO - Data Virtualization.
• Experience working Business Process Analysis, Business system Management and Requirements Management,DataExtraction,DataCleansing,DataProfiling,DataConsolidation, andDataQuality for various businessdatafeeds.
• Hands on experience in Springconcepts - DI/IOC, AOP,Batchimplementationand Spring MVC.
• Experience with Tableau for Data Acquisition and data visualizations.
• Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Datawarehousing, reporting and querying tools,Datamining and Spreadsheets.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Strong Experience inDataAnalysis,DataCleansing,DataValidation,DataVerification, and Identification ofDataMismatch.
• Well versed with various types Software Development methodologies- Water fall, Agile, RUP, Iterative and extreme Programming.
• In depth technical knowledge and understanding ofDataWarehousing,DataValidations, OLAP, SQL Server, Oracle and ETL.
• Written XSLT scripts for various XML needs and used XPath, XQuery fordataretrieval from XML documents.
• Extensive Experience in working as Dual Controller on various Business Projects which requires DualDataValidation andDataConsistency.
• Experienced in developing business reports by writing complex SQL queries using views, macros, volatile and global temporary tables
• Experienced working on large volume ofDatausing Teradata SQL and BASE SAS programming.
• Strong Experience in working on MS Access, MS Excel and MS Power Point
• Experienced inDataModelling, ETL &DataAnalysis experience using DimensionalDataModelling and RelationalDataModelling, Star Schema/Snowflake, Modelling, FACT & Dimensions tables, Physical & LogicalDataModelling.
• Collaborated with the QA team in designing test plans and test cases for the User Acceptance Testing.
• Profound experience in the field ofDatawarehousing and Business Intelligence implementation with expertise in AWS Redshift, AWS S3, AWS Athena, AWS GlueDataCatalog, Informatica, Power center, InformaticaDataQuality (IDQ), Informatica cloud, Business Objects
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts
• Extensive SQL experience in querying,dataextraction anddatatransformations.
• Experience with Relational Databases like Oracle DB2 ESE, MS SQL, Teradata, MS Access and formats like flat-files, CSV files, and XML files
• Well versed in writing queries/Scripts for Data Analysis and QA reporting and testing
• Extensively used V-LOOKUP'S, Pivot tables and Excel functions and worked on creating Pivot graphs, reports and dashboards.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication,

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, California

Sr. Business/Data Analyst

Responsibilities:

• Documented requirements associated change requests with requirements and connected requirements with Use cases in Requisite Pro and created different traceability views.
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
• • Led SQL ServerBatchImplementationETL process
• Conduct review with business people for the efficient use ofdatareporting.
• Performed and evaluated benefits of the new system and generated workflows.
• Utilized Agile Scrum methodology and aggressively worked on every stage of SDLC
• Analyzed Requirements and created Business Requirement Document (BRD), Current business process flow, Future business process flow, Use Cases, Use Case Diagrams, and Activity Diagrams using Microsoft Visio.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams and worked on database features and objects such as partitioning, changedatacapture, indexes, views, indexed views to develop optimal physicaldatamode.
• Extracted large data sets on sales and performed complex manipulations using R/Python
• Gathering and documenting requirements fordatasourcing,datamapping for standardization, key system dependencies, End-user interface &Datareporting
• Analyzed the usage of SAP EDWdatausing the Netezza query history logs for a specific period of time to identify the potential tables that need to be migrated to AWS S3/Redshift.
• Tested the ETL Informatica mappings and other ETL Processes (DataWarehouse Testing)
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed SQL Queries and created group accounts.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Incorporated pivot-tables anddatamodels to display/manipulate useful information.
• Perform importing, cleaning, transforming and validatingdata.
• Involved in using Spring concepts like DI/IOC, AOP,Batchimplementationand Spring MVC.
• Formatting from rawdatainto cleandata, Updating and correcting cleandata, and Input ofdatainto database.
• Reviewed normalized / denormalization schemas for effective and optimum performance tuning queries anddatavalidations in OLTP and OLAP environments.
• Performed various tasks that includeddatamassaging,dataextraction from flat files,datatransformations into various file formats, validations, loadingdataand checking for anydataintegrity errors.
• Maintaineddatamapping information and documented properly.
• Identification of dataflow/workflow issues, as well as finding the source of the issues and resolving them.
• Created customized SQL Queries using MS SQL Management Studio to pull specifieddatafor analysis and report building in conjunction with Crystal Reports
• Helped users by Extracting Mainframe Flat Files (Fixed or CSV) onto UNIX Server and then converting them into Teradata Tables using BASE SAS Programs.
• Conducted UAT (User Acceptance Testing) for multiple iterations by writing Test Cases and signed off the same after approval
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Defect Tracking and reports are done by Rational Clear Quest

Environment: Agile methodology, Requirement Traceability Matrix (RTM), Requisite Pro, MS Office, MS Visio, MS Project, MS SharePoint, AWS S3/RedShift, UAT, Netezza, AWS S3 Cloud, Informatica, Tableau, SQL, Oracle, Teradata, MS Access, MS Excel, UNIX, CSV, BASE SAS, HP Quality Center, Rational Clear Quest, Crystal reports

Confidential

Sr Data Analyst

Responsibilities:

• Designed application components in an Agile environment utilizing a test driven development approach. Created and maintained project tasks and schedules.
• Updated the daily hours spent on each task by creating and updating the tasks on the JIRA Kanban board.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.
• Responsible fordataextraction, transforming and loading (ETL) using tools likeDatatransformation service (DTS) and SSIS.
• Analyzing query results in Excel, creating pivot table/chart reports etc. and sharing them with MDM team members.
• Executed POCs to identify the best storage format in AWS S3 for the extracteddatafrom Netezza.
• Archived the historical Teradata datasets to UNIX server using sas scripts and created them back to teradata whenever required.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Extracteddatafrom the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a singledatawarehouse repository.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis Created source table definitions in the DataStage Repository by studying the data sources.
• Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications.
• Perform descriptive analysis anddatareportingon donor-marketing (SQL & Crystal Reports); Create dashboards and word-clouds (Python, Tableau)
• Validated thedatabetween mortgagedatawarehouse and Baseldatawarehouse on monthly basis by developing numerous test cases/scripts in Teradata.
• Implemented Indexes, Collecting Statistics, and Constraints while creating tables.
• Responsible for E2E solution ofDataMigration which includes Legacy system Analysis, DataMapping, Development, Dry Run/DataValidation and Cutover.
• Used Tableau and Excel to produce report based on some attributes.
• Identifying trends, outliers, and norms in utilization of financialdata.
• Performed DetailDataAnalysis (DDA),DataQuality Analysis (DQA) andDataProfiling on source objects.
• Created Mapping Specification document to outline mappingdatafrom source systems to the targetdatawarehouse.
• Useddataanalysis techniques to validate business rules and identify low quality missingdatain the existingdata.
• Involved in writing complex SQL queries using correlated sub queries, joins, and recursive queries.
• Created dimensional model based on star schemas and designed them using ERwin.
• Skilled in various MS Office tools including MS Visio and MS Project
• Raised several defects and assigned to development team through HP ALM tool.
• Raised multiple defects with the outcome of test cases and followed up with development team until the defects are fixed.

Environment: Agile methodology, Teradata, SQL, Unix, SAS, Macros, Unix Shell, CR/LF, AWS S3, Netezza, Pivot Tables, ETL, V-LookUps, SQL, ODBC, JRA, Requirement Traceability Matrix (RTM),Datamigration, Siebeldatamigration, EIM tables, Oracle, DB2, Informatica, PL/SQL, Erwin, SSRS, MS Visio, MS Project, MS SharePoint, HP AL

Confidential

Business/Data Analyst

Responsibilities:

• Retrieveddatafrom various sources Excel, databases and conducteddataintegration, analysis includingdatacleaning and linear regression and performeddataprofiling anddataquality.
• Used RUP-iterative process to ConductDataAnalysis to find missingdatafields in the application and customize them and extensively used Rational Requisite Pro.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
• Developed and tested Store procedures, Functions and packages in PL/SQL forDataETL.
• Used MS Word & Visio to documentdataflow of the AS IS process and TO BE process.
• Performed GAP analysis to identify the gap between the optimized allocation and integration of the inputs, and the current level of allocation.
• Created visually impactful dashboards in Excel fordatareportingby using pivot tables and VLOOKUP.
• Managed, updated and manipulated report orientation and structures with use of Pivot tables and V-lookups.
• PerformedDataAnalysis andDatavalidation by writing basic queries against the database.
• Responsible for running SQL queries against Oracle database to generate reports.
• Managed the pipeline deals CRM software by updating, filtering new clients, advertising agencies and creating financial reports for every month.
• Followed the AGILE methodology for the entire “SDLC”.
• PerformingDataAnalysis fordatacleansing anddatastandardizing purpose.
• Generated individual customer Reports using salesdataof quantity, sales price, standard cost, allocation budget in dollars and standard margin using VBA and Macros in MS Excel.
• Worked with theDataWarehouse Architect to perform development ofdatamodels and schemas.
• Developed Tableau workbooks from multipledatasources usingdatablending to develop chart, graphs, tables, and provide security using filtering on unwanteddata.
• Worked on loadingdatafrom flat files to Teradata tables using SAS Proc Import and Fast Load Techniques.
• DimensionalDataModeling to deliver Multi-Dimensional STAR schemas.
• Design & Implementation ofDataMart; DBA coordination; DDL & DML Generation & usage.
• Involved in capturingdatalineage, table and columndatadefinitions, valid values, and others necessary information in thedatamodels.
• Involved in complete testing life cycle including creation of Test Plan, Test Cases, collecting test data for various projects and documenting test results.
• Created specific indexes to speed up thedataload and thedataretrieval.
• Worked with several marketing managers and project manager to gather financialdataand requirements and build reports using Teradata SQL.
• Involved indatastructuring anddatamodeling of databases, creating tables, reports and maintaining them in MYSQL.
• Created defects, manage defect reports and defect status in ClearQuest tool

Environment: Pivot Tables, V-Lookups, Rational Requisite Pro, RUP, GAP Analysis, UML, MS Visio, MS Project, MS SharePoint, AWS S3, AWS RedShift, AWS Cloud, Teradata, SQL, Oracle, HIPAA, Facets, Macros, MS Excel, MS Word, Tableau, Informatica, ETL, Informatica Power Center, CRM, Clear Quest.

Confidential

Business Analyst

Responsibilities:

• Prepared Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe prototypes and document them for Business Process Modeling
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
• Coordinated with the data owners and implying the transformation/business rules to test the target data.
• Created the Mapping document to specify, the location of the table in database, conversion rules and business rules.
• Followed the Agile methodology for elicitation and representation of requirements based on interaction with the Project owner, SME's and the development team.
• Write SQL queries using SQL developer and TOAD for understanding of data used for application testing and validation.
• 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.
• Analyzed system requirements and involved in preparation of Test Plans for different modules and documented test cases for various screens of the application.
• Provided test data to all the testers including UAT Business Edge team and UI testing team.
• Coordinated and supported the implementation of Loan DB Schema through various documentations and tools.
• Defined key facts and dimensions necessary to support the business requirements.
• Interacted with users for verifying user requirements, managing change control process, updating existing documentation.

Environment: UNIX, Erwin, MS Visio, Mercury Quality Center, .Net, SQL Server, iRise, MS Access, MS Windows, Team Track, Requisite Pro