PROFESSIONAL SUMMARY:

• Data Analyst with over Six years of major experience in the financial domain.
• Generate reports for all the departments (finance, Operations, marketing, etc.) and Send Reports on Quarterly, Monthly, Weekly and Daily basis to the Management.
• Extensive experience with Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Work with the developers to fix bugs and issues found during Data Reporting to maintain data accuracy.
• Gathered raw data from The Body Shop website and conducted data analysis on R and excel, including data distribution analysis, multiple regression, hypothesis test and Chi - square test to find out significant variables.
• Conducted market research on market landscape, competitor analysis and consumer segmentation of PMP (Project Management Professional) market to find out how the product could be improved to increase sales.
• Interact with the Business, IT, PMO, Risk Management, and Business Intelligence business users for Data Warehouse business rules and process definitions.
• Scope out and document feasibility study for implementing Predictive Analytics for consumer CRM workflow including hardware requirements, database connectivity and data feeds, and identification of key predictive indicators for a pilot.
• Review workflow charts to understand tasks database systems will perform, such as updating and migrating records.
• Create automated reports using MS Excel macros.
• Good hands on experience in Software Development Life Cycle (SDLC) including Requirements, Specifications
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business processsolutions, in line with corporate priorities.
• Gathering business and Technical requirements that would best suit the needs of the technical architecturaldevelopment process.
• Excellent communication skills with good track of working at Client side in and outside US at various locations.

TECHNICAL SKILLS

Process/Model Tools: MS Word, Excel, PowerPoint, Visio, Snagit, Agile Methodology, Scrum, Rational Unified Process (RUP), Rational Rose, Rational RequisitePro, Rational Clear Case, UML, Remedy, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, MS Office2000 & 2003Tools.

Reporting Tools: Crystal Reports and SQL Reporting Services.

Test Tools: Test Director, Win Runner, Regression Test, Load Runner

Operating System: UNIX, Windows NT/2000, Windows XP.

Languages and tools: Java, J2EE, Dotnet, IBM mainframes, Web services (Web2.0), SharePoint, HTML

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Data Analyst

Responsibilities:

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Coordinated with several managers for Financial Data within the Financial Departments.
• Performed numerous data pulling requests using SQL for analysis.
• Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
• Developed Active Reports using active controls and the different decks (e.g.: Static, Data Decks, Data control tabs, Data Drop-Down List, Data Radio Button Group, Interactive Behavior) available in Active Reports.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using the Teradata advanced techniques like rank, row number and etc.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Also developed Ad-hoc reports developed using Oracle, SQL, and UNIX.
• Experienced in using OLAP functions like sum, count, sum and etc.
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• Proficient working in loading data into staging tables via views.
• Created daily and monthly reports using SQL and UNIX for Business Analysis.
• Utilized ODBC for connectivity to Teradata & MS Excel for automating reports and graphical representation of data to the Business and Operational Analysts.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered.
• Experience in Power Point Presentation (Financial Data, Charts) and also Expertise in generating graphs using MS Excel Pivot tables.
• Experienced in writing korn shell scripts for automating the jobs.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
• Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardization data structures, data base design, data warehouses, business intelligence/analytic tools, SQL, ETL tools, and data integration methods
• Reports generated for various departments like Tele Marketing, Mailing, New Accounts by using SQL, MS Access, Unix
• Used the Agile Scrum methodology to build the different phases of Software development life cycle.
• Extracted data from existing data source, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Excel.
• Responsible for data analysis and reporting of EDI feed to engineering teams and Management and Effectively identify errors and issues involving data flow discrepancies, following up with recommendations to improve daily operations.
• Used extensive SQL for data profiling/analysis to provide guidance in building the data model

Environment: Teradata SQL Assistant, Mainframe DB2, SQL *Loader, SQL Server 2008, Oracle 10g, Sequential files, Flat files, SQL, PL/SQL, Shell scripts, UNIX, Windows XP, Crystal Reports Requisite Pro, BIRT designer studio, SAS, Micro strategy UML

Confidential, RI

Sr. Data Analyst

Responsibilities:

• Generated sample data that is representative of Production data and Negative conditions to ensure optimal coverage.
• Execute Test Plans to Test Scripts to validate data integrity.
• Tracked data elements from source through transformations to target and ensure accuracy of data.
• Identified problematic areas on data workflows, data transformations, and data exceptions and tracked them to closure.
• Co-Produced and implemented data sourcing tools, source table formatting, and final report production and end to end process’ for 3 major editions of the Credit Review Direction of Risk Report covering all major sectors of the Commercial, Consumer, and Private Bank (primary report provided by CR Risk Management and distributed to Top Level and Senior Management across the Bank, The Office of the Comptroller of the Currency (OCC), The Federal Reserve Bank (FRB), and Price Waterhouse Coopers).
• Designed and Developed test strategy, test data and test plans for the ETL process Extensive experience in testing of financial services domain, Banking, Mortgage Options and Equities trading models.
• Analyze existing processes to make recommendations for improvement using data mining techniques.
• Identified gaps in historical data feeds and designed one time scripts to clean up data.
• Created automated scripts to monitor and validate data quality on a daily basis.
• Liaise with upstream, downstream teams and stakeholders to understand client business processes.
• Tests were planned and managed using Test Director.
• Developed and executed various TSL scripts using Win Runner for automated testing of individual functionality & Regression Testing of the applications.
• Created and Designed logical database schema for data warehouse (Teradata) environment to prepare for ETL.
• Extensive experience with Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Worked with COBOL Copy Books and converted the record format into Informatica Metadata.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Perform Source-to-Target Data Mapping, Data Lineage Analysis and documentation using the Metadata Repository (MDR) and the business rule spreadsheet (BRS) from the Corporate Data Warehouse (CDW) and the Integrated Operational Data Store (IODS) for financially reported Critical Data Elements (CDEs)
• Prioritized project objectives and validated data initiatives as Agile team scrum master for the Global Data GA team
• I have Work with large amounts of data, Commercial, Financial, Political, Data Collection for outside clients to produce marketing analysis reports. Interpret financial data, analyze results using statistical techniques and provide ongoing reports for the Director of Finance, Departmental Managers and Directors. Design and produce on going weekly and monthly reports with Crystal Reports, Access, Excel and SQL. Implementing Toad or Benthic to combine data from multiple sources.
• Moved the metadata from planning application to Essbase cube.
• Tested the ETL process for both before and after data cleansing process.
• Experience in creating UNIX scripts for file manipulation and profiling.
• Validating the data passed to downstream systems.
• I have checked the data integrity and referential integrity and checked the naming standards, data integrity and referential integrity.
• Requirements and Test Cases were designed based on Use-Cases in Test Director and Continuous Process / Quality improvement based on Rational Unified Process.

Confidential, Baltimore, MD

Financial Data Analyst

Responsibilities:

• Determines cost of operations by establishing standard costs; collecting operational data.
• Identifies financial status by comparing and analyzing actual results with plans and forecasts.
• Guides cost analysis process by establishing and enforcing policies and procedures; providing trends and forecasts; explaining processes and techniques; recommending actions.
• Improves financial status by analyzing results; monitoring variances; identifying trends; recommending actions to management.
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Closely worked with business analysts in the process of requirements gathering for various application specific databases.
• Wrote PL/SQL Stored Procedures, Functions, Views, Packages and Triggers to implement business rules into the application.
• Reconciles transactions by comparing and correcting data.
• Involved in creation of use cases using UML and managed the entire functional requirements life cycle using Rational Unified Process.
• Maintains database by entering, verifying, and backing up data.
• Recommends actions by analyzing and interpreting data and making comparative analyses; studying proposed changes in methods and materials.
• Increases productivity by developing automated accounting applications; coordinating information requirements.
• Protects operations by keeping financial information confidential.
• Maintains technical knowledge by attending educational workshops; reviewing publications.
• Contributes to team effort by accomplishing related results as needed.
• Analyzing current and past financial data and performance
• Preparing reports and projections based on this analysis
• Evaluating current capital expenditures and depreciation
• Exploring investment opportunities and Establishing and evaluating profit plans
• Identifying trends in financial performance and providing recommendations for improvement
• Coordinating with other members of the finance team to review financial information and forecasts and Providing financial models and forecasting.
• Determines cost of operations by establishing standard costs; collecting operational data.
• Identifies financial status by comparing and analyzing actual results with plans and forecasts.
• Guides cost analysis process by establishing and enforcing policies and procedures; providing trends and forecasts; explaining processes and techniques; recommending actions.
• Improves financial status by analyzing results; monitoring variances; identifying trends; recommending actions to management.
• Involved in Data Loading and Data Migration. Used SQL*Loader to load data from Excel file into Temporary table and developed PL/SQL program to load data from temporary table into base Tables
• Reconciles transactions by comparing and correcting data.
• Maintains database by entering, verifying, and backing up data.
• Recommends actions by analyzing and interpreting data and making comparative analyses; studying proposed changes in methods and materials.
• Increases productivity by developing automated accounting applications; coordinating information requirements.
• Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ERwin 7.2.
• Collaborated with the QA team to work on SIT and UAT both, maintained quality procedures, and ensured that appropriate documentation is in place..
• Maintains technical knowledge by attending educational workshops; reviewing publications and Contributes to team effort by accomplishing related results as needed.

IT Business System

Confidential, GA

Responsibilities:

• As a Data Analyst, am responsible for making sure any type of data issues are resolved based on HR department requests. This includes:
• Developing business and system data requirements (business, user and software requirements both functional and non-functional) and establishing traceability to a global business vision.
• Managing the requirements through the ALM/Six Sigma project lifecycle by establishing and maintaining useable business documents and data analysis documents for current and future projects.
• Building the foundation for the development effort by capturing the global business and data context problem, current state, desired future state, objectives, global business needs and impacted user groups.
• Creation and preparation of requirements for the Service Catalog by conducting interviews, document analysis, requirements workshops, qualtrics surveys, business process descriptions, use case, business analysis and workflow analysis. Use of MS Excel, MS Access and MS Project to gather data and prepare business requirements.
• Coordinated database management and collaborated with the research team to identify analytical requirements
• Proactive communication with management, systems analysts and developers in the IT Integration and Production Services department to analyze information, technical and functional requirements and delivering business requirement documents.
• Design and construct relational databases for web applications in SQL server 2005 and Oracle 10g.
• Create Access Form for end users to enter data; Created Pivot tables for gathered info, and chart in Excel for upper management.
• Excel presentations - Create Charts, Format Charts, Work with Illustrations, Share Excel Charts and Save Data in Presentable Formats; Created dashboard in Excel, linking database query and importing data from different sources.
• Perform database backup, performance optimization, and database maintenance.
• Provide technical support for database related problems and troubleshooting back-end issues.
• Participate in the design, execution, and ongoing maintenance of disaster recovery and high availability planning.
• Recognizing strategic implications of problems and issues with the Service Catalog and generation of alternative ideas and solutions
• Process client requests using data mining tools in Visual FoxPro, SQL Server, and MS Access. Design and create custom reports using Active Report Writer.
• Created/verified test scenarios and produced reports/file feeds, used to test business and functional requirements and provided to warehouse QA for quarterly version testing.
• Analyzed claim data errors, implemented accurate corrections and mapped data modifications through multiple levels of Oracle tables to production database, using Microsoft Management Studio and SQL
• Confirmed completion of the data migration via Beyond Compare software to ensure the data structure and all supported file types were successfully migrated.
• Migrated Macintosh hard drives from one server to an instance of manage, a data management system, to support case management.
• Liaised between external vendors, business units and internal software development teams to gather data, create documentation to explain data lineage, including relationships between different data. Compiled and created PowerPoint, Visio, Excel and Word documents and led presentations.
• Manage daily activities, working sessions, issue resolution, and communication across project and support teams in order to deliver projects and enhancements on time, as requested by the customerand Collaborated with data management team to troubleshoot errors within the data or errors in the migration process.