SUMMARY

• An energetic self - motivated and result oriented IT professional looking for an opportunity to work in a challenging environment where I can utilize my knowledge, skills in effective contribution to the success of the organization and for the improvement of my personal skills.
• Around 8+ 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.
• Good knowledge on EDI 837 transactions for electronic submissions of claims information.
• 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, Teradata SQL Assistant and 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 2000
• Microsoft Suite: MS Visio, MS Word, MS Excel, MS Outlook, MS Access Database, MS Power point

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Business Data Analyst

Responsibilities:

• Working in Telecom Domain and understanding the various areas of business and understanding their needs.
• Users for our data warehousing projects are Business Intelligence, Product Intelligence, Internal requestors within data warehousing.
• Being in Data warehousing segment would be coordination various teams like, Business Intelligence and Data source teams.
• Data source teams would be internal to Charter or sometimes the third-party vendors who would provide service for us.
• Prominent work experience in Service now ticketing system and its features
• Worked in various aspects of Service Now user role and created tickets to the appropriate groups
• Closely working with BI, Data source, QA, Prod-ops team, Infra team, Framework team and DBA teams
• Gathering Business requirements from Business Intelligence team on their reporting needs.
• Investigating the Data source teams for BI data needs and finding the possible best approach in ingesting data sets as per requirements.
• Working on process improvisation planning and providing suitable evidences for it.
• Co-ordinating both Data source team and Business Intelligence team to align the requirements.
• Analyzing the data elements and working on transformations needed.
• Preparing data mapping document i.e. Technical specification document.
• Working on different documentations like BRD, User Guides and presentations.
• Presented technical and business solution for various Architectural Reviews for the projects if there are any deviation in the project.
• Maintained Jira for tracking the issues and following up with the concerned teams and associated members.
• Actively took up various KT sessions for the new joiners on understanding them the existing process.
• Identified different approaches in various Business cases.
• Working on story boards in Jira and conducting Sprint planning meetings.
• Reviewing various projects from intake projects and checking if there are any impacts on our present workflows in the near future.
• Working on evaluating efforts needed for a particular project and setting project timelines.
• Working on various and analysis and data validations needed in a broader perspective.
• Reviewing the completeness of work and validating the results before handling over to the users.
• Working on Tool upgradation planning and its validations.

Environment: Oracle, Teradata, Big Data, Hadoop, Hive, Spark, Ambari, Kafka, Ping DSB, Json, No-SQL, UNIX, SQL Server, HP ALM, JIRA, Podium - Bigdata ETL Tool, Talend, Salesforce, One Automation, Tableau, MS-Outlook, Skype, Share Point, Service Now, MS-Office, Adobe, AWS.

Confidential, Tampa, Florida

Business Data Analyst

Responsibilities:

• Using Business Analyst skills to include gathering and documenting requirements, data analysis/research required.
• Working in Financial Data Regulatory Reporting team.
• Mainly to re-platform legacy reports.
• Handling different sets of data in different stages.
• Writing requirements mainly Functional requirement document and its technical specifications and data validation rules.
• Understanding the need and interpreting the data and normalizing it.
• Conducting meeting to discuss upcoming issues with Businesspeople, developers and testers.
• Understanding the project in platforming from legacy systems (Business Objects) to Micro strategy platforms.
• Working in Agile methodology handling two projects.
• Extensively worked on Data warehousing and reporting platform.
• Worked on building DataMart for mortgages and credit cards database from existing legacy databases.
• Meetings with team regularly as daily scrums, sprint planning and some war sessions to handle high priority issues.
• Currently the team is using Pearl, Genesis, Ab Initio Reporting, and Eagle. 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
• Working with Reg Insight Dashboards.
• Worked on data migration from legacy systems to cloud based AWS.
• Working with HP ALM for requirement logs and defects logs.

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

Confidential, Richmond, Virginia

Role: Business Data 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.
• Worked on Business Intelligence side of analysis and reporting.
• 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.

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

Confidential

Data 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 into 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, Cognos, 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 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 procedures.
• Used SQL to validate the Data going into the Data warehouse
• 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

Business Analyst

Responsibilities:

• Designed reports in Excel using advanced functions not limited to VLOOKUP, pivot tables, formulas.
• Used SQL to validate the Data going into the Data Warehouse
• 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.