SUMMARY

• Over 8 years of professional IT experience as Data Analyst wif solid understanding of business requirements gathering, business process flow, business process modelling and business analysis.
• Experience in interpreting and applying feasibility studies, System Requirements Specification (SRS), Scope Document, Applications Architecture and Request for Proposal (RFP).
• Experience in providing analytical thinking, reporting process improvements, problem solving, time management, decision making and issue resolution.
• Extensively worked on identifying problems, business context to perform analysis.
• Strong experience in Data modelling - Conceptual, Logical/Physical, Relational and Multi-dimensional modelling, Data analysis for Decision Support Systems (DSS), Data Transformation (ETL) and Reporting.
• Extensive working experience in creating Conceptual, Logical and Physical data models using Star Schema and Snowflake schemas.
• Proficient in Data Governance, Data Lifecycle, Data Quality Improvement, Master Data Management, and Metadata Management.
• Experience working wif Data governance team to evaluate test results for fulfilment of all data requirements.
• Expertise in Data Architecture, Data profiling, Data analysis, data mapping and Data architecture artifacts design.
• Excellent SQL skills wif DML, DDL commands and demonstrated ability to write complex queries for purpose of analysing data and/or evaluating how information needs might be translated into back-end database.
• Strong experience in working wif developers for preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Experience working on analytics data to visualize and analyse data and transform as per requirements.
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences and Materialized views using SQL.
• Experience in Data Migration, Transformation, Integration.
• Solid experience in Data Warehousing best practices working wif Metadata, repositories and experience wifin a disciplined lifecycle methodology.
• High ability to deal wif ambiguity and business complexity and communicate complex analysis to leadership.
• Experience in providing multiple solutions to customers/clients due to rapidly changing strategic priorities.
• Extensive experience in Database query tuning, performance tuning.
• Experience in designing ETL Specification documents to load data from source to target using various transformations according to teh business logic.
• Proficiency in database design concepts, architecture and ETL design strategies.
• Experienced in working wif OLTP database, OLAP database and data warehouses.
• Thorough noledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Extensive noledge in performing User Acceptance Testing (UAT), writing test cases and documenting test results while working along wif teh QA team.
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences and Materialized views using SQL.
• Expertise in test data validation wif Multi - dimensional cubes such as SSAS.
• Experienced in performing User Acceptance Testing (UAT) for data verification.
• Well conversant wif test case design, test case execution, test data preparation, SDLC concepts, Defect Life cycle.
• Expertise in software management tools such as Clear Quest, Quality Center, HP ALM, JIRA for defect tracking and reporting.
• Demonstrated ability to identify root causes of problems, consider both teh long and short-term impact of proposed solutions and develop workable solutions.
• Extensively worked on identifying problems, business context to perform analysis.
• Experience in providing multiple solutions to customers/clients due to rapidly changing strategic priorities.
• Expertise in SCRUM Agile Framework and Methodology wif experience in daily stand-up meeting, sprint planning meeting and sprint retrospective meeting.
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning.

TECHNICAL SKILLS:

Languages: Python, R, SQL, C#, HTML, CSS, JavaScript, MATLAB

Python Libraries: NumPy, Pandas, Beautiful soup, Pytables, SciPy, Matplotlib, Python -twitter, Pickle, urlib2

ETL Tools: Informatica Power Center

Reporting Tools: Tableau, Power BI, MS Excel, SSRS

Office Applications/Workflow Tools: MS Outlook, Visio, MS Project, MS-Excel, MS-Access

Defect Management Tools: ClearQuest, Quality Center, HP ALM, JIRA

IDEs: Anaconda, Jupyter and PyCharm

Operating Systems: All versions of Windows, LINUX, Macintosh

Databases: SQL Server 2008/2010/2012 , Oracle, MySQL, PostgreSQL

Development Methodologies: Agile/Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Data Analyst

Responsibilities:

• Created documents like Business Requirements Specification, Technical Requirements Specification.
• Worked wif a diverse IT community to identify project data and detailed data requirements need to source data for teh project.
• Identified teh risks in schedule and marking them in teh Use Cases.
• Performed data profiling and analysed data flows.
• Worked wif teams across teh organization to align on metrics definitions.
• Worked wif Data Engineering team to implement data structures to support ongoing analytics work.
• Thought of ways to allow teams to self-service for their data requests, through Tableau.
• Worked wif various teams to understand their priorities and use SQL to generate insights.
• Worked wif other data analysts and data scientists to prototype and build out data driven products and solutions.
• Assisted in making data-related decisions by performing research and analysis for reporting data.
• Participated in interpreting data quality, data accuracy and developing action plans accordingly.
• Extensively worked on clickstream data to understand teh customer behaviour, page interactions and search/browse history for generating reports and product improvement.
• Assisted in teh measurement of teh problem size to develop baselines and opportunities for improvement.
• Worked as a bridge between teh customer and teh Development team to understand and deliver teh end product at teh right time.
• Provided development and consultation for business plans, programs and initiatives.
• Worked on creating data mappings between 2 different sources.
• Created Data Flows to load data from flat file, CSV files wif various formats into Data Warehouse.
• Worked on data residing in heterogeneous data sources to be consolidated onto target database.
• Designed and developed conceptual, logical and physical data models.
• Created and integrated new and old data models into teh data warehouse using Snowflake Schema.
• Worked on relational database concepts, stored procedures, functions, triggers and scalability analysis.
• Designed and developed weekly, monthly reports related to teh marketing and financial departments using SQL.
• Created Design Fact & Dimensions Tables using ERWIN tool.
• Created a Normalized logical model for teh business to understand teh relationships and at teh deeper level of granularity.
• Forward Engineering teh Physical Model to generate teh DDL scripts. Maintained SaaS Environments
• Planned and created CRQ's for deployment of new applications as needed. Monitor and manage hosted applications on SAS.
• Extensively used JIRA for executing teh test cases, defect tracking and test management.
• Used Tableau for data visualization purposes.
• Worked vigorously on Data Quality by performing continuous data analysis and testing.

Environment: SQL, Power BI, Python, Scikitlearn, R, RStudio, ggplot, TFS, SSAS, T-SQL, Star-Schema, Snowflake, SSIS, ETL, SQL Server Agent, Excel, Macros, SSRS, SQL Server, BI, Tableau, Power BI, Oracle, Agile, Windows

Confidential, Wayne, PA

Data Analyst

Responsibilities:

• Performed data analysis and data profiling using complex SQL and involved in Data mapping specifications to create and execute detailed system test plans.
• Implemented machine learning model wif Python Scikit- learn.
• Worked on relational database concepts, stored procedures, functions, triggers and scalability analysis.
• Configured teh SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Created fact and dimension table implementation in Star Schema model based on requirements.
• Analysed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in data governance, defined data mapping from source to target (for all teh three heritages).
• Handled teh detail execution of data gathering, dashboard implementation and bug fixing.
• Gatheird metadata and created data analysis repository (spreadsheet), which includes following metadata information: data source, hierarchy, fact, dimension, data attribute, data integration, data model, data acquisition.
• Involved in teh Data Mining, Profiling and Data Modelling.
• Developed mappings for Slowly Changing Dimensions of Type1, Type2, Facts and Summary tables using all kinds of transformations.
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Worked at conceptual/logical/physical data model level using Erwin according to teh requirements.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Validated cube and query data from teh reporting system back to teh source system.
• Tested analytical reports using Analysis Studio.
• Identified KPI's like retention rate, site traffic, customer life-time value & online marketing ROI and designed intuitive Tableau dashboard.
• Performed A/B testing to improve teh quality of traffic generated and understand teh factors effecting teh success rate & improved teh site conversion rate by 5%.
• Performed analysis and presented results using SQL, Excel, and Visual Basic scripts.
• Involved in testing teh SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled teh performance issues effectively.
• Communicated wif technical and teh nontechnical teams to listen to teh needs of technical and business stakeholders and interpret them.
• Extensively involved wif data quality and data governance solutions including platforms and supporting data processes.
• Troubleshot production issues and system malfunctions and restore normal functioning.

Environment: Python, Scikit-learn, SciPy, ETL, Informatica Power Center, Star-Schema, Snowflake, Tableau, Power BI, MS SQL, IBM Information Analyser, SQL, SQL Server, SSIS, SSRS, MS Excel, Windows, Agile

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

• Gatheird teh business requirements by conducting a series of meetings wif business users.
• Fostered a culture of having easy access to data and autonomy in obtaining answers.
• Used Tableau as teh visualization tool to analyse data quality and data integrity.
• Created sand used dashboards and reports using Tableau and Medusa.
• Prioritized, analysed and disseminated critical information for data accuracy.
• Created logical data model from teh conceptual model and its conversion into teh physical database design.
• Tuned teh performance of teh queries by working intensively over teh indexes.
• Extensively used Star Schema methodologies in building and designing teh logical data model into Dimensional Models.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Created reports using SQL Server Reporting Services (SSIS).
• Involved in Data mapping specifications to create and execute detailed system test plans.
• Teh data mapping specifies wat data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Used SQL for querying teh database in teh UNIX environment.
• Used Star Schema and Snowflake Schema for data marts/data warehouse.
• Prepared teh Joins/Filter logic documents dat would halp teh ETL design team perform teh Joins on teh tables dat are in teh form of flat files before loading them to FDS or any downstream systems.
• Created documentation and test cases, worked wif users for new module enhancements and testing.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.
• Created job schedules to automate teh ETL process.
• Normalized teh database up to 3NF to put them into teh star schema of teh data warehouse.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Loaded staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Reduced labour intensive manual processes like job entry, approval and invoicing by exposing well-defined SOA interface allowing B2B integration wif Financial Clients.
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of teh data into teh data warehouse.

Environment: Python, Matplotlib, NumPy, Pandas, Seaborn, Plotly, Machine learning, Tensor flow, SQL, Talend, Power BI, MS SQL server, Tableau, Excel, Windows

Confidential

Data Analyst

Responsibilities:

• Evaluated and enhanced current data models to reflect business requirements.
• Created Data Dictionary, Data Mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.
• Created data stories, reports and visualizations using Tableau and Power BI.
• Created database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Designed and implemented data profiling and data quality improvement solution to analyse, match, cleanse, and consolidate data before loading into data warehouse.
• Created ad-hoc, weekly and monthly reports in compliance wif teh client requirement wif Excel.
• Developed ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded teh data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS) and T-SQL.
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs reports using teh SSRS reporting as per teh user's requirements and deployed in report server.
• Used Unix Shell Scripting for automating logs, for user created table backups and for checking daily log.
• Created filters and calculated sets for preparing dashboards and worksheets in Tableau.
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Documented teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.

Environment: Power BI, Tableau, Excel, SSRS, SQL Server, Tableau, Oracle, T-SQL, Teradata, Shell Scripting