SUMMARY:

• 7+ Years of experience in Data science and Data Analsys.
• Extensive experience in analysing and requirements gathering and writing system functional specifications.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Experienced in different Data modelling algorithms.
• Proficient in Technical and System Writing, System Process Flow, System Process Modeling, System Analysis and Testing various methodologies.
• Expertise in broad range of technologies, including System process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Hands - on experience in SAS & Python and Excel.
• Worked on different databases like Teradata, Oracle.
• Expert In JAVA, JCL, Amazon Web Services (AWS).
• Experienced in migrating data from different databases to cloud based databases.
• Experience in understanding and implementing the Data management.
• Understood Business Objectives/problems and conducted feasibility/cost benefit analysis and came out with alternative solutions.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• In-depth understanding of Development methodologies, including SDLC, SCRUM, Agile, Model.
• Driven Architecture,component technologies, distributed architectures.
• Good understanding and hands on experience with technologies like HTML, XPATH, XML, Java, SOAP Web services.
• Good knowledge in ETL process which is nothing but Extraction, Transforming and Loading of the data.
• Proficient in Quantitative Aptitude and Critical Reasoning.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Strong analytical and problem solving skills.
• Excellent communication and interpersonal skills. Ability to work effectively while working as a team member as well as individually.

TECHNICAL SKILLS:

• Rational Rose Enterprise Suite
• Rational Requisite Pro, MS Visio, Oracle
• MS- Excel, MS- Access, SAS, Java, JCL
• AWS, SOAP UI, GIT, JENKINS
• JUNIT, Java Script, Eclipse IDE.MS Office
• MS Project, MS Publisher, MSRS
• Rational Robot, Performance Studio
• Mercury Win Runner, Load Runner, Korn Shell Script
• C/C++, Java 2, Teradata, SQL, PL/SQL, VB
• Shell Script, Html, Crystal Reports, Micro strategy
• Visual Basic, Access, Excel, MS-SQL Server
• Oracle, Sybase, SQL* Plus, UNIX (Solaris/Linux)
• MS-DOS, Windows 95/ 98/ 00/NT/XP, MS FrontPage
• Dream weaver, Irvin data

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Business Data Analyst

Responsibilities:

• Responsibilities include gathering System requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Proficient in writing packages, stored procedures, functions, views and database triggers using SQL and PL/SQL in Oracle.
• Developed PYTHON programming for extracting data from flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Designed and changed existing data model as per business requirements.
• Performed Data cleaning, manipulating processing a Data hygiene process in PYTHON.
• Developing different data modeling algorithms for predict the future data.
• Functional, non-functional and performance testing of key systems prior to cutover to AWS.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
• Formulated Project goals and objectives, in-scope items and beyond-scope items document.
• Manipulating and extracting different taxation data with SQL, R,Python. Irvin data,
• Analyzing data with MS Excel, R.
• Writing Analyzed data report with Excel.
• Generate the day to day and weekly reports of the analyzed data and send it to the modeling team.
• Created UML diagrams, Data modeling, and process flow diagrams and utilized Microsoft Excel to complete data collection and data mining.
• Designing, updating and managing databases with Oracle, MS Access.
• Clean the data using optimum cleaning techniques.
• Worked on the different tax types data like motor fuel and cigarettes.
• Create different data frames according to the client requirement.
• Knowledge about different modelling techniques like Linear modelling, Decision tree.

Confidential, NY

Data Analyst

Responsibilities:

• Involved in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Involved in sending Report status of all conversion-related data tasks to RPM Data Conversion Lead.
• Worked with RPM Store Readiness team to understand the work required by the Data Conversion Support team
• Recommended for efficiencies/process improvements to streamline overall conversion.
• Participated in rollout planning and strategy meetings to provide input on team role in the process
• Worked with RPM Store Readiness team to understand the work required by the Data Conversion Support team
• Participated as a product owner/user in requirements/design, testing and providing user feedback on data conversion tools
• Developed ETL Test Plans, Test Strategies and Test Cases.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Performed Automated testing using SQL, Quality Center suite of tools.
• Executed Automated scripts daily for functionality testing.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Wrote Test Cases and Performed Manual & Automation Testing like GUI, Functionality, System,
• Integration, Regression, UAT, Localization Testing, Black Box testing and performed Positive/Negative, testing for system validations for mainframes, web based & Mobile applications.
• Support for User Acceptance Testing (UAT).
• Tested the web-based application manually and SQL for Automation.
• Created complex SQL queries to perform & validate the backend testing of the Application.
• Created and executed SQL queries to validate the data to verify the JSP front end correctly displays data.
• Scripted test cases for component and UAT using HP Quality Center.
• Validated response with the XML Schema during Web Service Testing
• Followed the Agile methodology for the entire SDLC with daily scrum and through Sprints.
• Performed Web Service Testing using SOA Test Tool for Functional & Regression Testing
• Extensive querying using Toad to run SQL queries and monitor quality & integrity of data.
• Involved in preparation of System Test Results after Test case execution.
• Performed data validation, accuracy of calculated fields, Accuracy of the data shown, Selection criteria shown, Accuracy of subtotals for the Cognos reports.
• Validated the front end reporting components created using Cognos Reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.
• Performed Sanity, Functional, GUI, Unit, Integration and Regression Testing of the Application at different levels.
• Extensively used Ab Initio Co-op to execute the graphs and verify the logs.
• Tested data migration to ensure that integrity of data was not compromised.
• Actively participated in stand up meetings, story reviews, and retrospectives of the Agile process.

Confidential

Marketing Data Analyst

Responsibilities:

• Extracting data Using R and SQL.
• Combine the different clusters according to the client requirements.
• Create clusters and segments according to the workflows of different products of the clients.
• Club the multiple records based on key fields.
• Clean the data and replace the missing values using optimum cleaning techniques.
• Maintain the datasets in a well-organized and secure manner.
• Worked with different datasets like past and live data which will help the client to take a decision on their products.
• Worked in different client’s locations and worked different databases.
• Performed Data Analysis, Data Conversions, and Data import during implementation phase of the Software Development Life Cycle (SDLC).
• Scheduled meetings with Developers, System Analysts and Testers to collaborate resource allocation and project completion.
• Wrote several complex SQL queries for data verification, data validation, data quality checks.
• Recommend modifications to improve the overall quality of products.
• Perform Data Validation and Data Mapping to ensure the integrity of client data. Also, created Master packages for Automation purpose.
• Used Analytix as a data mapping requirements management tool.
• Worked with data base validation, constraints validation, record counts, source to target validation, random sampling and error processing. Prepared data model to support the data operations and role based mechanisms and access patterns.
• Tested initial and daily loads for various Ab Initio graphs.
• Write SQL scripts for Data extraction and Data Processing for Marketing IT domain and Supply Chain Management.
• Worked with the Deployment Team to ensure the deployment is done correctly and also validated the Business Rules thereafter.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Conducted monthly Risk Assessment meetings to recommend, identify and communicate mitigation plans to the steering committee.
• Worked closely with business experts to resolve application defects.
• Creation of Business and Technical Requirement document for the project.

Confidential

Data Analyst

Responsibilities:

• Extracting pharmaceutical data Using PYTHON and SQL.
• Working with large pharma data using multiple databases.
• Combine the different clusters according to the client requirements.
• Migrating the data from different environment to Cloud based storage.
• Create clusters and segments according to the workflows of different medical products of the clients.
• Club the multiple records based on key fields.
• Clean the data and replace the missing values using optimum cleaning techniques.
• Maintain the datasets in a well-organized and secure manner.
• Worked with different datasets like past and live data which will help the client to take a decision on their products.
• Performed Data Analysis, Data Conversions, and Data import during implementation phase of the Software Development Life Cycle (SDLC).
• Scheduled meetings with Developers, System Analysts and Testers to collaborate resource allocation and project completion.
• Recommend modifications to improve the overall quality of products.
• Perform Data Validation and Data Mapping to ensure the integrity of client data. Also, created Master packages for Automation purpose.
• Prepared data model to support the data operations and role based mechanisms and access patterns.
• Write SQL scripts for Data extraction and Data Processing for Marketing IT domain and Supply Chain Management.
• Worked with the Deployment Team to ensure the deployment is done correctly and validated the Business Rules thereafter.
• Worked closely with business experts to reach the company goals.

Confidential

QA Analyst

Responsibilities:

• Prepare Test Cases and Test procedures based on Business Requirements, Document and execute them accordingly.
• Review and analyze Software Development Life Cycle documents.
• Assist in defect call meetings to discuss status of high severity issues.
• Perform Positive and Negative Testing to ensure requirements were met.
• Create and executing SQL queries to validate backend data.
• Coordinate actively with Technical peers, such as Developers, Project Managers, and Business/User groups.
• Perform Manual Testing and maintain documentation on different types of testing like Positive,
• Negative, Functional, Integration, Cosmetic, Regression, Sanity and System Testing.
• Developed, documented and executed test plans, test cases and requirements.
• Made extensive use of MS Excel to create and maintain documents such as Test Plans, Test Execution and Test Results Documents.