Data Analyst
Resume:
SAI KRISHNA
***************@*****.***
A highly-accomplished Data Analyst and a Data Modeler with 4+ years of IT experience specialized in Software development life cycle (SDLC), designing and developing of database and data models.
Extensive experience in Relational and Dimensional data modeling for creating logical and physical design of database and ER diagrams using data modeling tools like ERWIN and ER studio.
Strong knowledge in using Erwin r9.7, r9.5, ER-Studio & Power Designer 16.5 for developing conceptual logical/physical, relational and multi-dimensional modeling, Data Transformation (ETL) and reporting.
Expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources.
Have knowledge with ETL Tools like INFORMATICA and IBM infosphere.
Experienced in SSIS, SSRS in solving business problems and managing reports in organization.
Good knowledge in Database programming PLSQL&SQL, SQL Server2012/2008/2005 ORACLE 12c/11g/10g/9i, DB2, TERADATA 14.0, NoSQL Database tuning and query optimization.
Experienced in Data loading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS).
Excellent knowledge in creating databases, tables, stored procedures, DDL/DML triggers, views, user-defined data types, effective functions, cursors and indexes using T-SQL.
Provided Strong Support to the reporting team using data virtualization tools like Tableau, Power BI, etc.
Strong hands on experience implementing dash boarding, data visualizations and analytics using Tableau Desktop and Sever.
Experienced working with agile and waterfall methodologies.
Have a good exposure in overall SDLC including Requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies and Microsoft SQL Server database management.
Exceptional communication and presentation skills and established track record of client interaction.
TECHNICAL SKILLS
Programming Languages- C, C++, Python, SQL, T-SQL, PL/SQL, MATLAB,R programing.
Database Systems -SQL Server 2012/2008/2005, NoSQL, MS Access, Oracle 11g/10g/9i, Teradata, MYSQL.
ETL and Reporting Tools-SSIS, SSRS, informatica 8.6/7.1/6.2, IBM Infosphere, Data Stage, Crystal reports, Tableau, x Celsius, QlikView.
Data Modeling Tools -Power Designer 16.5, Erwin9.3, 9.5,9.7, ER/Studio, UML 2.x, Erwin, MY SQL Workbench.
Bug Tracking Tool- IBM ClearQuest, Jira.
Operating Systems-MS Office Suite MS Word, MS PowerPoint, MS Excel, MS Access UNIX, DOS, Microsoft Windows 8.1/7/vista/7.
Methodologies-Waterfall & Agile.
Work Experience
ROLE : Data Modeler/ Data Analysis
CLIENT: Blue Cross Blue Shield,Durham,NC SEP 2018 to Present
Responsibilities:
Performed forward engineering in Erwin tool to generate schemas and implement them in DB
Collected external data sources and stored the data into MySQL
Built and automated KPI reports, data monitoring, forecast reports and product quality reports using SQL, Python to reduce reports preparation time
Developed a Conceptual model using Erwin r9.7 based on business requirements
Worked on ER-studio to develop physical and logical models after retiring ERWIN
Create, maintain and publish logical and physical data models using ER STUDIO, GitHub, Neo4j
Worked with business owners and took the lead to create METADATA definitions for 50,000 columns and deployed it in PRODUCTION for business and company use
Collaborate with business users and architects to understand Business and Technical requirements
Collaborate with data integration analysts to resolve data issues and translate business concepts and solution architecture into data models that reflect user needs
Created data narratives and data functional design document, artifacts used by the developers as a source on how to use the data model
Reverse engineer data structures to data models for data mapping and establish Data and Conceptual Flows
Designed the Data Marts using Ralph Kimball’s dimensional data modelling technique.
Provided Strong Support to the reporting team using data virtualization using Tableau.
Designed and Developed Dashboards using Tableau for various ROI metrics
Automated monthly excel reports into Tableau Workbooks and Dashboards
Designed Dashboards using Filters, Parameters and Action Filters
Produced standard monthly reports using Tableau
Expert knowledge in Microsoft Excel, Microsoft Access, PowerPoint, and Tableau
Established the connection between legacy system using MySQL and SQL Server
Migrated data from legacy system to SQL Server and completed 99% records mapping
Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages
Formulated procedures for integration of R programming plans with data sources and delivery systems
Prepared and facilitate weekly PMO meetings; captured meeting decisions and content into Excel based tracking logs
Submitted Statements of Work into Contracts database
Responded to all incoming questions and inquiries related to JIRA applications
Prepared projects, dashboards, reports and questions for all JIRA related services
Involved in documentation of Data Mapping and ETL specifications of data warehouse designing and developing conceptual models using Workbench and ERWIN designing tool as per requirements and demonstrated to business.
Documented the complete process flow to describe the program development, logic, testing and implementation
For good efficiency and better performance tuned several SQL Queries
Created DDL scripts for implementing Data Modeling changes
Performing product development process in agile sprint methodology and even involved in project management to deliver the sprints with deadlines
Environment: Erwin 9.5, Tableau, MYSQL, R Programming, Workbench, MS Excel, MS Visio, Oracle11g, SQL developer, Jira, GitHub, crystal reports 9.
ROLE :Data Analyst/Data Modeler
CLIENT:Magellan Health,Glen Allen,VA NOV 2016 to NOV 2017
Responsibilities:
Mapped business needs/requirements to subject area model and to logical enterprise model& developed many Subject areas from the scratch.
Created Data Base Design of Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
Validated the business data objects for accuracy and completeness.
Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
Developed the data warehouse dimensional models &schema for the proposed central model for the project.
Extensively used Star Schema methodologies in building and designing the logical data model into ER/ Studio.
Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.
Designed and develop Tableau visualization solutions.
Worked on generating various dashboards in Tableau server using various data source.
Installed upgrade Tableau server and server performance tuning for optimization.
Administered user, user groups, and scheduled instances for reports in Tableau.
Worked on the Snow-flaking the Dimensions to remove redundancy whenever required.
Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
Managed the extraction, transformation, and population of data files and databases (MS SQL Server 2008, Excel, and Access)
Gathered business requirements and conducted a series of meetings with business users.
Designed and implemented basic PL/SQL queries for testing and report/data validation.
Used Data warehousing for Data Profiling to examine the data available in an existing database and created Data Marts.
Ad hoc reporting, data analysis and troubleshooting for various business groups.
Responsible for understanding the design and structure of different databases and writing ad-hoc queries for data mining using different data mining tools.
Environment: SQL Server 2008, Oracle 10g, Teradata 14.0, Erwin 9.5, Windows, MS office, MS Access, Visio, Informatica, Share Point, MS Outlook, MS Project, PL/SQL, MS Excel, MS Word, HTML, ER/Studio
Environment: Erwin7.x, Oracle 8i, Tableau, SQL Server 2008, ER/STUDIO, informatica, TOAD and UNIX.
Client: Sysgee Solutions, Hyderabad,Ind
Role : Jr. Data Analyst Jan 2013 to Jan 2015
Responsibilities:
Worked in close association with the Business Analysts and DBA’s for gathering requirements, business analysis, and testing and project coordination.
Interacted with end users and acquired the reporting needs.
Defined best practices for Tableau report development.
Prepared Dashboards using calculations, parameters in Tableau.
Created all documents and maintain accuracy of information and preparing SOP.
Responsible for Developing Dashboard and preparing ad-Hoc Reporting.
Used Erwin to create tables using Forward Engineering.
Reviewed the data model with the functional and technical team.
Assisted the ETL staff, developers and end users to understand the data model.
Maintained a change log for each of the data models created.
Created SQL codes from data models and interacted with DBA's to create development, testing and production database.
Added database objects (like indexes, partitions in oracle database) for performance.
Checked to see if the data models and the databases are in sync.
Environment: Erwin7.x, Oracle 8i, Tableau, SQL Server 2008, ER/STUDIO, informatica, TOAD and UNIX.
EDUCATION:
MASTERS IN COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (U.S.A) APRIL 2015- DEC 2017
BACHELORES IN COMPUTER SCIENCE ENGINEERING (IND) MARCH-2014
Contact this candidate