SUMMARY:

• Around 7+years of IT professional experience in Software industry with Data Analyst and good working knowledge of ORACLE disciplines, tasks, resources and scheduling in domain strong analytics.
• Strong experience in Business and Data Analysis, Data Governance, Data Profiling, Data Migration, Data Mining, Data cleansing, Data Conversion, Data visualization, Data Quality, Data Integration, Master Data Management, Metadata Management Services and Configuration Management.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint
• Expert in writing T - SQL, working on DTS, SSIS, SSRS, SAS, Data Cleansing, Data Scrubbing and Data Migration.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Well Versed with advance concept in Excel. Worked with VLOOKUP, Index, Match, IF Statements, Pivots and creating complex formulas
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Definitions and Data Formats.
• Worked in a Business process re-engineering environment as per system needs.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, T- SQL Joins.
• Hands on experience using query tools like TOAD, Sybase SQL Developer, PLSQL developer, TeradataSQL Assistantand Query.
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Worked on Waterfall and Agile methodologies.
• Used most of the SQL Functions including character functions, number functions, date functions and conversion functions
• Queried various joins and sub queries.
• Coordinated various teams and projects as a scrum master.
• Widely used Case expressions in SQL queries.
• Extensive experience in working with databases including Oracle 10g/9i/8i, MS SQL Server 2008/2005/2000/7.0
• Extensive experience in writing SQL to validate the database systems and for backend database testing on web based systems.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Created Data Mapping document after each assignment and wrote the transformation rules for each field as applicable.

TECHNICAL SKILLS

Operating Systems: Windows XP/Vista/7/8/10, UNIX, Linux, MAC OS

Languages: T-SQL, Pl/SQL, Perl, Python, Unix Shell Scripting

Web & Interface Technologies: HTML, XML

Database: Microsoft SQL Server 2008/2012/2014, MySQL 2005/08/10, IBM DB2 8.x, Oracle 9i/10g, Teradata V2R6, Sybase 12.3, SQL Server 2000/2005, Netezza NPS 8050

Scripting Languages: HTML, CSS

Reporting tools: SQL Server Reporting Services (SSRS), Tableau, Crystal Reports, Business Objects, Micro Strategy

Data Modelling: Erwin 3.5.1/4.x, Designer 2000Microsoft Suite Data warehousing

Webservers: MS Visio, MS Word, MS Excel, MS Outlook, MS Access Database, MS Power pointSSIS, Informatica 8.6/7.1/6.2/5.1 (Power Center/ Power Mart), Data Mining, DataMart, OLAP, OLTP, TOAD 7.5.2, Data Profiler, IBM Infosphere Java WebServer2.0, Web Logic 6.0.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida

Business Data Analyst/ ETL Testing

Responsibilities:

• Using Business Analyst skills to include gathering and documenting requirements, data analysis/research required.
• Using the Investment Data Reporting/ Micro strategy.
• Mainly to re-platform 600 legacy reports.
• Handling different sets of data in different stages.
• Worked on Master data Management related to different products and forms.
• Writing requirements mainly Functional requirement document and its technical specifications and data validation rules.
• Understanding the need and interpreting the data.
• Conducting meeting to discuss upcoming issues with developers and testers.
• Understanding the project in platforming from legacy systems (Business Objects) to Micro strategy platforms.
• Worked in Agile methodology with 15 days as Sprint.
• Meetings with team regularly as daily scrums, sprint planning and some war sessions to handle high priority issues.
• Currently the team is using DST HiNet, Business Objects Reporting, and Eagle (legacy systems).
• Worked independently, communicate with business users, gather requirements, writing functional specs, client/operational reporting, and high-level industry knowledge.
• Data Analysis, SQL (to query and analyze data), and Data Knowledge is the main day-to-day work process
• Worked with Micro Strategy Dashboards

Environment: Oracle Databases, MS-Office 2013, Phyton, DB-Visualizer, UNIX, HiNet, Hp-ALM, Informatica, Unix, MS Outlook, Symphony, Business Objects, MicroStrategy SharePoint, Rally-Agile.

Confidential, Virginia

Business Analyst

Responsibilities:

• Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Performed Business Process mapping for new requirements and for the purpose of business process re-engineering.
• Performed Data Validation with Data profiling and data handling.
• Documentation work on BRD, User guides.
• Documenting on AS-IS and TO-BE statements and performed GAP analysis.
• Worked on creating UML modelling.
• Created models for calculating cost and capacity of the teams in an organization.
• Conducted Grooming session with the business team to provide the requirements also did an in-depth analysis of the requirements
• Experienced in creating the Tableau Dashboards.
• Worked on Master data management for different clients and their accounts.
• Applied forecasting methods to see the trend and analyses based on them.
• Checked for Outliers and done forecasting in Tableau by using RScripts.
• Involved in Data Extraction from Toad using SQL assistant.
• Worked with Micro-Strategy data visualization.
• Was handling training sessions using webinars to demonstrate newly developed software application for the users and client.
• Used SAS technologies for business intelligence and reporting purposes.
• Designed reports in word, Access, Excel using advanced functions not limited to VLOOKUP, pivot tables, formulas.
• Used SQL to validate the Data going in to the Data Warehouse.
• Tested the ETL Data Stage staging and other ETL Processes (Data Warehouse Testing)
• Created User stories to Jira, stacked up the backlog, added the actors, plugged in the requirements.
• Conducted Scrum meeting and made sure the scope of the Sprint is set to right level.
• Creating complex data analysis to troubleshoot issues related to Risk Management, AML, KYC, and compliance issues.

Environment: Toad for Oracle 11, MS-Office 2013, SharePoint, MS Outlook, Hadoop, Skype for Business, Tableau 10.2, R, SharePoint, Repository Intake Tools, Reporting Intake Tool, Jira-Agile, Python.

Confidential

Data Quality Analyst

Responsibilities:

• Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Conducted JAD sessions to allow different stakeholders such as editorials, designers, etc.,
• Performed Business Process mapping for new requirements.
• Performed Data Validation with Data profiling and data handling.
• Experienced in creating the SSIS packages, DTS packages.
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant.
• Designed reports in Access, Excel using advanced functions not limited to VLOOKUP, pivot tables, formulas
• Used SQL, PL/SQL to validate the Data going in to the Data Warehouse.
• Creating complex data analysis to troubleshoot issues related to Risk Management, AML, KYC and compliance issues.
• Evaluating data mining request requirements and help develop the queries for the requests.
• Conducted UAT (User Acceptance Testing) for multiple iterations by writing Test Cases and signed off the same after approval
• Hands-on experience in Manual Back End Testing using SQL.
• Used Erwin tool for logical, physical and conceptual modelling.
• Worked on Metadata Management and its processes.
• Responsible for creating the Requirements Traceability Matrix.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested the ETL Data Stage staging and other ETL Processes (Data Warehouse Testing)
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Tested several UNIX Korn Shell scripts for ETL data loading
• Verified Informatica sessions, worklets and workflows in QA repository.
• Extensively used SQL queries to check storage and accuracy of data in database tables with relational databases.

Environment: Oracle 11g, SSIS, SQL Server 2005, RDBMS, Oracle 10g, Erwin, Informatica Power Center 9/8.5.1 (Workflow Manager, Workflow Monitor), QTP, Congnos, Business Objects, UML, SSIS, Excel, PowerPoint, Tableau Test Cases, Assistant, Teradata V2R6, Teradata SQL Assistant, IDQ, Unix, Quality Center, TOAD, HP Quality Center 10, Agile

Confidential

Data Quality Analyst

Responsibilities:

• Worked on Requirement Analysis, Asset management, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Prepared Business Requirement Documentation and Functional Documentation.
• Primarily responsible for coordinating between project sponsor and stake holders.
• Performed Business Process mapping for new requirements.
• Designed reports in Access, Excel using advanced functions not limited to VLOOKUP, pivot tables, formulas.
• Training associates on the software application, tools and work proceedures.
• Used SQL to validate the Data going in to the Data Ware House
• Creating complex data analysis queries to troubleshoot issues reported by users
• Evaluates data mining request requirements and help develop the queries for the requests.
• Running defect logging systems and documenting it.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Analyzing Business requirement specifications and identifying the source data and transformations that needs to be applied in the process of moving data to target database
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application. Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.

Environment:Informatica Power Center 8.6(Repository Manger, Designer, Server Manager), Oracle 10g, IDQ, Requirement traceability Matrix (RTM), Excel, QTP, PowerPoint, Assistant, Teradata V2R6, Teradata SQL Assistant, TOAD, Business Objects, MS Excel, MS Project.

Confidential

Project Analyst

Responsibilities:

• Designed reports in Excel using advanced functions not limited to VLOOKUP, pivot tables, formulas.
• Used SQL to validate the Data going in to the Data Ware House
• Performed Teradata SQL Queries, creating Views by following Teradata Best Practices.
• Prepared Business Requirement Documentation and Functional Documentation.
• Primarily responsible for coordinating between stake holders, developers and testers.
• Conducted JAD sessions to allow different stakeholders such as editorials, designers, etc.,
• Creating complex data analysis queries to troubleshoot issues reported by users.
• Evaluated data mining request requirements and help develop the queries for the requests.

Environment:Informatica Power Center 8.6(Repository Manger, Designer, Server Manager), SSIS, Oracle 10g, HP Quality Center 9.2, Requirement traceability Matrix (RTM), XML, Excel, PowerPoint, Teradata V2R6, Teradata SQL Assistant, IBM DB2, OLAP, OLTP, Business Objects, MS Excel, MS Project.