SUMMARY

• 6 years of IT Experience as a Data Analyst and Business Intelligence Engineer with high proficiency in requirement gathering and datamodelling including design and support of various applications in OLTP,Data Warehousing, OLAP and ETL Environment.
• Experienced in buildingdata integration and workflow solutions, and Extract, Transform and Load (ETL) solutions fordata warehousing.
• Hands on experience in importing, cleaning, transforming, and validatingdata and making conclusions from thedata decision - making purposes.
• Solid understanding of statistical analysis, predictive analysis, machine learning,data mining, quantitative analytics, multivariate testing, and optimization algorithms.
• Well versed in system analysis, ER/Dimensional Modelling, Database design and implementing RDBMS specific features.
• Skilled in visualizing, manipulating and analysing large datasets and also has ability of designing and developing effective reports.
• Proficient with MS Office Applicants, Excel (Pivot Table, Hlook UP, Vlook Up, Count If, etc) and also experienced with Tableau and Python.
• Highly skilled in Tableau Desktop fordata visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Extensive experience in developing Unit, Integration and UAT Test plans and Cases and also has experience in generating/executing SQL Test Scripts and Test results.
• Extensive ETL testing experience using Informatica (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Proven experience in relational and dimensionaldata modelling,data management, metadata and masterdata (referencedata) management and business intelligence tools.
• Experienced in Businesses Analytics, to provide comprehensive predictive analytic, financial performance and strategy management, to improve business performance and predict future outcomes.
• Adept in writing SQL queries fordata extraction, manipulation, analysis, and validation, generating user reports and proficient knowledge of Relational Database Management Systems (RDBMS), andData Warehousing.
• Managed Full SDLC processes involving requirements management, Workflow analysis, sourcedata analysis,data mapping, metadata management,data quality, testing strategy and maintenance of the model.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), AGILE and Waterfall Methodologies.

TECHNICAL SKILLS

Database: Oracle Database, MySQL, NoSQL, Redshift

Methodology: SDLC, Agile/ SCRUM framework, and Waterfall

Analytics Technologies and Packages: Microsoft Excel (Lookup, Pivot, macros), VBA, ASP Solver, RDBMS, Oracle Database, R & Python, Informatica, Teradata, Shell Scripting.

Data Visualization: Tableau, Microsoft Power BI, ETL Processing, IBM SPSS Modeler

Statistical Skills: Data Mining, Statistical Data Analysis, UML Analysis and Design, Business Analysis, Agile methodology, Project Management, Requirement Gathering

Tools: MS Word, MS PowerPoint, MS Project 2016, MS Visio, MS Excel

PROFESSIONAL EXPERIENCE

Confidential - Bentonville, Arkansas

Data Analyst

Responsibilities:

• Analysed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining theData Process Models.
• Prepared documentation for all entities, attributes,data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project
• Created, documented and maintained logical & physical database models.
• CreatedData Stage jobs to extract, transform and loaddata intodata warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project managerdata requests.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Worked onData Verifications and Validations to evaluate thedata generated according to the requirements is appropriate and consistent.
• Proficient working in loadingdata into staging tables via views.
• Perform in depthdata analysis and load customer details from data warehousing to analyse, generate comprehensive reports to decision makers and other affected by the results.
• Developed strategies and loading techniques for better loading and faster query performance.
• Extensively worked on documentation ofData Model, Mapping, Transformations and Scheduling batch jobs.
• Generated the DDL using forward engineering Worked in merging and complete compare of Physical models.
• Used theData Warehousing Life Cycle to identifydata elements from the source systems, performeddata analysis to come up withdata cleansing and integration rules for the ETL process.
• Created advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt chart, Histograms.
• Worked on SQL queries in a dimensionaldata warehouse as well as a relationaldata warehouse.
• Involved in extensivedata validation by writing several complexes SQL queries and involved in back-end testing and worked withdata quality issues.
• Created daily and monthly reports using SQL and UNIX for Business Analysis.
• Expertise in generating graphs using MS Excel Pivot tables.
• Created the POC and prototype Tableau reports and dashboards with the key metrics.
• Designed and developed a comprehensivedata warehouse by extracting, cleansing and transforming unstructured largedata sets from heterogeneous sources.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Extracteddata from existingdata source, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Excel.
• Analyseddata quality issues against source system and prepared adata quality document confirming all the source data quality.
• Experience in understanding user requirements around technicaldata, interaction ofdata between systems and system dependencies.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed PL/SQL programming that included writing Views, Stored Procedures, Packages, Functions and Database Triggers.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management end of day feeds.
• Conducted JAD (Joint Application Development) Sessions and RAD (Rapid Application Development) Sessions with stakeholders.
• Used SQL queries and tools to optimize customizations of database operations
• Strong written and interpersonal communication skills Proven business analysis skills, including business and functional specification development Experience in database skills.
• Understanding and articulating business requirements from user interviews and then convert the requirements into technical specifications
• Created several types ofdata visualizations using Python and Tableau.
• Data wrangling and scripting in Python, database clean up in SQL, advanced model building in R/Python, and expertise indata visualization and Tableau dashboard development.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML
• After successful development and testing of the product, participated in product release and deployment to end-user.
• Identified internal and external system requirements, design and configuration set-up also created User Documentation and conducted a training class.
• PerformedData Profiling of the current state ofdata in theData Warehouse by doingData Analysis using SQL Queries and Microsoft Excel, finding Gaps inData and formulating solutions for the same.
• Collects requirements from department managers and users for enhancements. Acts as liaison between clients and development.
• Helped to resolve critical control and operational weaknesses, identified problems, recommended improvements and worked in collaboration with middle office, Risk and Finance to implement issue resolutions.
• Forecasted company's expense accounts and assist in vendor contract renewals and invoicing.
• Collaborated with stakeholder groups across the organization to ensure business and technology alignment.
• Optimized business performance by designed/ implemented business algorithm to evaluate efficiencies of operations.
• Reported to business and reporting manager as necessary with status. Assisted Management Team with necessary updates on projects.
• Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access
• Designed theData Warehousing ETL procedures for extracting thedata from all source systems to the target system.
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing AGILE methodology.

Environment: Business Analysis, Tableau, Python, R programming, ETL processing, SQL, PL/SQL, MS Office Suite, AGILE Methodology, UML designing.

Confidential

Data Analyst

Responsibilities:

• Worked withData Architect and SMEs in identifying the solution for reporting issues found while comparing existing data model in ISR and that developed for ASM.
• Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams,data models, and use-case realizations using RUP tools in Agile.
• Actively involved in analysing the order management and supply chain management process, managing inventory process and documenting the process.
• Collected business requirements to set rules for properdata transfer fromData Source toData Target inData Mapping, ETL tools like Informatica for loadingdata into the staging tables in the database.
• DevelopedData Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW) also developed data mapping documents between Legacy, Production, and User Interface Systems.
• Documenteddata content,data relationships and structure, and processes thedata using Informatica Power Center Metadata Exchange.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writingdata and Turned SQL queries to make use ofdata base indexes and analysed thedata base objects.
• Involved in designing logical and physicaldata models and wrote Business and technical metadata as well as prepared source to targetdata mappings documents in excels.
• Coordinated with data owners to discuss the sourcedata quality issues and resolving the issues based on the findings.
• Facilitated meetings with business users,data architects,data modellers, business analysts, QA and multiple delivery teams to define thedata quality and profiling requirements.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modelling Language) methodologies
• Identified/documenteddata sources and transformation rules required populating and maintainingdata warehouse content.
• Analysing and building proof of concepts to convert SAS reports into tableau or use SAS dataset in Tableau.
• Used SDLC (System Development Life Cycle) methodologies like RUP and Agile methodology.
• Created business requirement documents and integrated the requirements and underlying platform functionality.

Environment: Data Analysis, Data Mapping, ETL Informatica, Tableau, Agile methodologies, SQL, PL/SQL, SDLC, UML methodologies.

Confidential

Data Analyst

Responsibilities:

• Conducted logicaldata analysis anddata modelling JAD sessions, documenteddata -related standards and Involved in gathering user requirements along with business analysts.
• Played key role inidentifying the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Responsible fordata validation across the risk management systems and create requirements document with end-to-end traceability.
• Generating responsiveness, turnaround time related metrics and performance dashboards to the management on a weekly basis.
• Worked with Internal modelling team fordata analysis and profiling.
• Conducting DataMining andDataModelling by collecting, cleansing and providingdata modelling and analysing the structured and unstructureddata.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Created SRD (System Requirements Doc) to facilitate the ETL team to develop their SDS (System Design Specification doc).
• Visualizedata insights usingdata visualization tool Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-Down menu option and Parameters using Tableau.
• Applying Software Development Lifecycle and methodologies like Waterfall, Agile and Scrum approach.
• Determine and create custom content types (metadata). Apply permissions to content and manage permissions within the site.
• Demonstrate exposure/experience indata profiling, cleansing anddata wrangling techniques.
• Excellence indata structures, programming and Demonstrated experience in understanding of complexdata.
• Perform initial analysis to assess the quality of thedata and conducting further analysis to determine the meaning of thedata.
• Worked with DBA in converting the logical models to physical.
• Created Designs for the various reporting requirements and Released the reports through UNIX shell scripting every month based on requirement
• Conducted Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports.
• Involved in creating various documents such as Use case, Business and Functional Requirement Specifications. Well versed in Project Management skills like MS Project for project planning and scheduling. Able to process newdata quickly and communicate it effectively to lay individuals.