SUMMARY

• 5+ Years in Data Analysis, System Analysis, Business Requirement Gathering, Data Modeling, Technical Documentation.
• Experienced and comfortable working on various databases like SQL Server, Oracle, Teradata.
• Well conversant with test case design, test case execution, test data preparation, SDLC concepts, Defect Life cycle.
• Expert in using design and management tools like Erwin and Toad, SQL Developer.
• Thorough knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Expertise in software management tools such as Clear Quest, Quality center, HP ALM, JIRA for defect tracking and reporting.
• Good exposure to Object Oriented Programming, Agile Methodologies.
• Proficient in Data Governance, Data Lifecycle, Data Quality Improvement, Master Data Management, and Metadata Management.
• Expertise in extracting, cleaning, transforming, and visualizing data using Python
• Analyzed performance improvement pathways by parallelizing the schedule of Informatica jobs using UNIX Shell Scripting thereby improving time to deliver.
• Proficient in Oracle 11g, Teradata, SQL Server, PL/SQL on UNIX, and Windows platforms.
• Extensive experience in Database activities like Data Modeling, Design, development, maintenance, performance monitoring and tuning, troubleshooting, data migration etc.
• Experience on Cloud Databases and Data warehouses (SQL Azure, Snowflake, Google Cloud Big Query, AWS Redshift).
• Experienced in analyzing Business Requirements Documents (BRD), Functional Requirement Documents (FRD), Test Strategy and Test data preparation, Coordinating User Acceptance Testing (UAT), Preparing Manuals and Training Business Users.
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Excellent Communication, interpersonal, analytical skills, and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

ETL Tools: Informatica, SSIS, SSAS, SSRS

Databases: MS SQL Server, MS Access, DB2, Oracle 18c, 19c, Teradata

Operating Systems: Linux, UNIX, Windows

Programming Languages: C, Visual Basic, and C++, VB 16.0, SQL, Python, R.

Software: Microsoft Office (Excel, Word, PowerPoint and Access), Visio, SQL Reporting

Reporting Tools: Tableau and Power BI

Project Management Tools: JIRA, GitHub, Google Shared Services

Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential - Blue ash, Ohio

Data Analyst

Responsibilities:

• Advocate for the study of interesting data anomalies or patterns that may provide more analytical details about customer behaviours or predicted value to the business by developing SQL queries on several databases.
• Wrote PL/SQL statements, stored procedures and Triggers for extracting as well as writing data.
• Worked on extracting, transforming, and loading data from various databases.
• Used Agile methodology as the Organization Standard to implement the data Models.
• Developed Data Migration, Transformation and Cleansing rules for the Integration Architecture using OLTP.
• Created PL/SQL packages and Database Triggers and developed user procedures.
• Created Mapping Documents for Power BI Reports.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Worked on publishing Power BI Desktop reports created in report view to the Power BI service.
• Worked with real-time databases like MongoDB or Cassandra, utilizing Python drivers and ORM libraries like Django ORM.
• Created Power BI Dashboards(Power View, Power Query, Power Pivot, Power Maps)
• Developed Erwin and Data Mapping, to find, visualize, design, deploy and standardize high-quality enterprise data assets and Transformation and cleansing rules for the Data Management involving OLTP and ODS.
• Involved in writing ang tuning transact-Sql Queries.
• Conducted Design workshops with clients to finalize wireframes, PowerBI Visualizations.
• Created User Stories from the road maps and worked with the product management and scrum teams.
• Created automation scripts for regression and smoke testing for various modules. studied the requirements business objectives.

Environment: PL/SQL, MS SQL 2016, OLTP, ODS, Power BI, Transact-SQL, TOAD, Teradata r15, SQL Assistant.

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

• Defined corporate Metadata definitions for all Enterprise Data Supported databases and performed Data Analysis, Data Profiling and Validity, and Data Cleansing taDeveloped Mapping Spreadsheets as well as Logical and Physical Data Models; defined and developed designs to support departmental and functional Data Marts
• Worked closely with Analytical and Reporting infrastructure teams to ensure operational and analytical data warehouses could support all business requirements for OLAP reporting across the organization
• Articulated content and modelled principles to other modelers and business users
• Developed models to reflect business area-specific data needs
• Supported review, signed-off and adopted models in collaboration with global businesses
• Optimized performance of Python-based systems through code profiling, caching, and tuning of system configurations.
• Created SSIS packages to populate data from various data sources.
• Done proof of concepts using Power BI tools (Power Query/ Power View) for excel.
• CreatedSSISpackages to extract data from OLTP to OLAP system and created alerts for successful and unsuccessful completion of schedule jobs.
• Performed the Database Analysis and maintenance, Data Analysis using different database maintaining applications including TOAD,SQL server, Oracle and DB2.
• Provided database support activities like database backup and restore, performance monitoring ant tuning, review data models, analyze database metrics, and assist with capacity planning, executing upgrades and migrations, implement security and integrity controls.
• Responsible for leading the End-End Database Quality Assurance activities in sending over the medical authorizations into claims source systems across all LOB plans in the USA.
• Implementation of the Database Quality Assurance in Prod/Stage/Test/Dev environments using the SQL scripts.
• Developed and testing the Data Visualization Reports, Dashboards using Tableau.
• Perform the data connection activities, visual analytics using Tableau.
• Report the KPls (Key performance Indicators) to the technical and business teams.
• Review the Technical Requirement Document, Epics, User Stories, Sub Tasks and Defects.
• Prioritizing and analyzing the user-stories, defects, and their level of estimates.
• Design and documents the UML Use Case diagrams using MS Visio.
• Involved in Daily Scrum calls, weekly status meetings, sprint planning, refinements and retrospective meetings, business signoff, production checkout meetings.
• Participate in change management and implementing the special efforts in adapting to the new challenges based on the direction of work.
• Involved in the root cause analysis on the undocumented or unknown lower environment and production issues and explaining them in detail to the business.

Environment: Oracle 11g, Teradata, DB2, MS SQL Server 2012/2008, SQL, Tableau, Rapid SQL, Dbeaver, Power Designer, MS SQL, Tableau, Autosys, Windows, SQL server 2005, TOAD.

Confidential

Data Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for Data Marts.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and assisted in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Performed data analysis and data profiling using complex SQL on various sources systems.
• Used SAS and SQL to perform ETL from Oracle database and creating SAS datasets, SAS Macros, Proc/data steps, and SAS formats as required.
• Created SAS Datasets, Data manipulation, develops data marts for the preparation of reports, tables, listings & graphs.
• Responsible for creating a business process and workflow documentation using BPMN standards Developed and implemented real-time data processing and analysis algorithms using Python and related libraries.
• Design the Test Architecture and the Scenarios for the Automation
• Designed and developed the front-end using HTML, and JSP
• Business data modeling and analysis and a thorough understanding of relational data structures, database star and snowflake schemas and OLAP concepts
• Delivered business requirements, high level, and detailed technical specifications and then lead the development and business teams through design, testing, and implementation phases.
• Preparation of Test Summary Reports for every Test Cycle
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Assisted with the writing of Test Plan for the Financial Data Mart implementation effort
• Performed report validation writing SQL queries using TOAD on an Oracle database
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint and SAS for better visualization of the application
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions
• Extensive knowledge and hands-on experience in SDLC methodologies (Waterfall model and V-model), Software
• Testing Life Cycle, Defect Life Cycle and various types of testing like black box testing, regression testing, smoke, and sanity testing, and functionality testing (positive & negative).
• Provided Business Requirement Documentation (BRD) for the customers after thorough market and technology research and by analyzing current market trends.

Environment: Windows XP, MS Office, MS Project, SQL, HTML, OLAP, SDLC, XML, CRM, Visio UMLAGILE, DNS, Via Voice, PSM, Rational Clear Quest, Rational Clear, Rational Rose, SAS.

Confidential

Data Analyst

Responsibilities:

• Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.
• Wrote SQL targeting performance and recommended to define indexes on the tables as per the need.
• Created stored procedures for reporting/processing data.
• Working with business units to coordinate data scope and format requirements.
• Developed SQL queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Performed data conversions from SQL server to flat file using SSIS.
• Created packages that implement tasks like Execute SQL Task, Data Flow Task etc.
• Created SSIS packages with which data resources are loaded daily to create and maintain a centralized data mart. Made the package dynamic so it fits the environment.
• Providing production support for bug fixes and enhancements.
• Defining, in written form, data and reporting requirements for new projects obtained from business and technical leads.
• Collaborating with various levels of staff including senior management on numerous reporting initiatives.
• Analyzing complex business problems and issues using data from internal and external sources to provide insight to decision-makers.
• Assist in the design, analysis, and development of data architectures for relational databases.

Environment: SQL, MS SQL server 2000, SAP Power Designer, Visual Basic 6.0, and Excel, SSRS, SSIS