SUMMARY

• A highly motivated Data analyst /Microsoft BI Developer with around 5 years of experience in interpreting and analyzing different domains of data for driving business solutions. Extensive experience in SQL Server, Power BI, Business Objects, and Tableau.
• Around 5 years of experience in analyzing, designing, and developing client/server, Business Intelligence (BI) database applications, Requirement Elicitation, ETL, Data visualization, Analytics, Data Integration and related database Platforms in the Parking and oil and gas industry.
• Experienced in developing Statistical models to perform predictive data analysis using R.
• Excellent skills in analytical analysis and proven ability to read and interpret different points of data.
• Experience in analyzing, designing, and developing client/server, Business Intelligence (BI) database applications, Requirement Elicitation, ETL, Data visualization, Analytics, Data Integration and related database Platforms in the Parking and oil and gas industry.
• Proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• Experienced in ETL, data analysis with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.
• Experience in OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Expertise in developing standard and re - usable mappings using various transformations like expression aggregator, joiner, source qualifier, lookup and router.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), AGILE Methodologies.

TECHNICAL SKILLS

Programming and Scripting: SQL,R,T-SQL, PostgreSQL

Database Tools: Microsoft SQL Server 2017, 2016/2014/2012 , 2008 and MS Access.

Data and Analytic Tools: Power BI, Tableau.

Others: Git, Pivot tables, VLOOKUP, SharePoint

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Seattle, WA

Responsibilities:

• Converted parking data into actionable insights by predicting and modeling future outcomes.
• Created interactive dashboards in Power BI to assist end-user decision making.
• Involved in the design and development of user interfaces and customization of Reports using Power BI and designed cubes for data visualization, forecasting reports using historical data.
• Generated various presentable reports and documentation using report designer.
• Analyze data model, write business algorithms using stored procedures and queries, and perform proof of concepts for new data architecture.
• Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detailed analysis and design.
• Collected, reviewed and analyzed quarterly and annual financial asset data.
• Preparing Dashboards using calculations, parameters in Power BI.
• Evaluated data profiling, quality, cleansing, integration and extraction tool.
• Analyze and study the source system data models to understand concept tie-outs such that the integration process into existing data warehouse is seamless and data redundancy is eliminated.
• Performed data analysis on the target tables to make sure the data as per the business expectations.

Environment: SQL,Power BI,SSIS,SSRS,Sharepoint

Intern Data Analyst

Confidential, Seattle,WA

Responsibilities:

• Analysed data from multiple sources,developing reports,providing valuable insights.
• Facilitating data driven making in the oil and gas industry.
• Extracted data using OLTP and OLAP connections.
• Monitored workflow process to enter, create, or change the data.
• Conducted or performed data modeling exercises in support of subject areas and/or specific client needs for data, reports, or analyses, with a concern towards reuse of existing data elements, alignment with existing data assets and target enterprise data architecture.
• Created pivot tables interactive dashboards for measuring the impact of data mapping changes.
• Modified spreadsheets to achieve analytical goals.
• Developed conceptual, logical, and physical Enterprise Data Model based on industry standards.
• Involved in preparing logical data models and conducted controlled brain-storming sessions with project focus groups.
• Generated reports using Microsoft Excel Pivot tables.
• Worked with SQL, Stored Procedures, Triggers,Advanced T-SQL queries
• Rationalized the relationships expressed in the logical data model to the schema of the physical data store (that is, database tables and columns).
• Developed complex SQL queries, and performed execution validation for remediation and Analysis.
• Worked with cross-functional teams to build out data queries that highlight potential issues and changes to check erroneous data.

Environment: Power BI,SQL Server 2012,SQL,MSOffice (Word, Excel and PowerPoint), MS Project, MS Access, CSV files, Erwin, MS Visio

Engineering Data Analyst

Confidential

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from civil engineers and site managers
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.
• Identified entities and attributes and developed conceptual, logical and physical models using Erwin.
• Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing databases.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Used SAP(Structural Analysis Program) for load analysis.
• Creating or modifying the T-SQL queries as per the business requirements.
• Designed and Developed SQL database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.

Environment: SQL, Advanced Excel, AutoCAD, SAP