We provide IT Staff Augmentation Services!

Bi Data Analyst/sql Developer Consultant Resume

San Ramon, CA

SUMMARY:

  • IT professional with 6+ years of extensive experience in Data Warehousing, Data architecture, design, BI development and programming
  • Working towards Microsoft Certification (MCSE) on SQL 2016 BI Development
  • Created database Schema (DBs and tables), stored procedures, triggers and functions in SQL Server
  • Worked as an ETL developer using SSIS and Report Developments using SSRS, testing and bug fixing
  • Experience includes tuning T - SQL (DDL and DML) queries to improve the database performance and Query Optimization/performance tuning
  • Contributed and supported in multiple segments of Software Development Life Cycle (SDLC) from business requirements to post implementation support and reviews. Experienced in Process and Documentation that are required in SDLC life cycle
  • Worked in different roles of Agile/Scrum software development methodology
  • Good experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as SSMS, Erwin Data Modeler as well as MS Visio
  • Designed and developed ETL and Data flow maps using DTS, BCP, Bulk Insert, SSIS
  • Designed and managed data connections and exporting views to Tableau server
  • Developed Tableau dashboards with interactive views, trends and drill downs
  • Worked as part of Tableau configuration team performing the role of a Tableau Admin to add new users and user groups
  • Redesigned and migrated the custom SQL queries implemented in Tableau in source data warehouse to improve and optimize performance
  • Migrated data pipelines and redesigned visualizations from Tableau to PowerBI based on individual user requirement and reporting needs
  • Created and exported views from SQL server to build interactive dashboard in PowerBI
  • Utilized DAX and M language to create complex PowerBI measures, calculated columns
  • Gathered and imported data from Google Analytics to import and visualize in PowerBI as part of consolidated reporting

TECHNICAL SKILLS:

Data Modelling: ERwin Data Modeler, SQL Server Management Studio, MS Visio

ETL Tools: SQL Server Integration Service (SSIS)

Databases: MS SQL Server, MySQL, Oracle, MS Access

BI tools: Tableau, PowerBI, Google analytics, Domo, SAS Visual Analytics, MicroStrategy, Qlik

Languages: SQL, DAX, M Language, Data Analysis in R and Python, HTML, Asp.net, C#, C++

Other tools: Advanced Excel, Marketo, Salesforce, Confluence, JIRA, MS Project

PROFESSIONAL EXPERIENCE:

BI Data Analyst/SQL Developer Consultant

Confidential,San Ramon,CA

Responsibilities:
  • Worked on ETL architecture, Data Warehouse Design, Dimensional Models, creating ER diagrams
  • Worked on database and table designing and implementation as well as related ETL processes
  • Ensured the implementation of the quality standard and processes in project deliverables
  • Created workflows and tested mappings and workflows in development, pre-production and production environment
  • Involved in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping
  • Designed Fact & Dimension Tables, conceptual, Physical & Logical data models using ERwin and Erwin methodologies like Forward & Reverse Engineering
  • Documented the business requirements for reporting from each user and created views that can be imported into BI tools
  • Created SSIS packages to enable data flows that utilize SQL queries to pull the data needed
  • Deployed SSIS packages onto an Integration Server and enabled the ETL process to run automatically on scheduled intervals
  • Created and imported views from SQL server and built custom interactive dashboards based on user needs for filtering, pattern detection and reporting requirements
  • Improved performance of the application by identifying bottlenecks and making relevant modifications to the code across modules
  • Moved complex custom SQL queries in Tableau to views inside the database to improve and optimize performance
  • Migrated the data pipelines from SQL server from Tableau to PowerBI as part of BI tool migration
  • Re-designed the visualizations in PowerBI based individual user requirements and needs
  • Scheduled timely refreshes of data to provide updated PowerBI dashboards as needed

Environment: SQL Server, ERwin Data Modeler, SQL Server Management Studio, SQL Server Integration Services, DOMO, Tableau, PowerBI, Agile, SDLC

Teaching Assistant

Confidential,Denver,CO

Responsibilities:
  • Work involved research analysis, creating dashboard, ad-hoc reports, scripts and configuration of the BI tools such as SAS visual analytics and its databases along with creating and testing different reports and dashboards.
  • Developed analytical dashboards including bar chart, map chart, Pareto charts, straight tables, cyclic groups, dynamic drill down and trend charts.
  • Implemented and analysis of google analytics on the website
  • Gathered and imported data from Google Analytics to import and visualize results as a part of consolidated reporting
  • Updating and managing MS Sql Server database to in corporate the changes as necessary

Environment: MS Sql Server, SAS visual analytics, Google Analytics

Software Developer/ SQL developer

Confidential

Responsibilities:
  • Adapted different phases of SDLC, requirement gathering, design and development, testing, implementation and support for development of project, participated in sprint planning, adapted Agile methodology.
  • Interacted with users of the system to understand the planning approach and implemented the changes as per their needs
  • Implement three tier architecture using C# and Asp.net, validating scripts using validation controls and JavaScript, JQuery
  • Contributed and supported in multiple segments of Software Development Life Cycle (SDLC) from business requirements to post implementation support and reviews. Experienced in Process and Documentation that are required in SDLC life cycle
  • Worked in different roles of Agile/Scrum software development methodology
  • Created database Schema (DBs and tables), stored procedures, triggers and functions in SQL Server
  • Worked as an ETL developer using SSIS and Report Developments using SSRS, testing and bug fixing
  • Experience includes tuning T-SQL (DDL and DML) queries to improve the database performance and Query Optimization
  • Designed and developed ETL and Data flow maps using DTS, BCP, Bulk Insert, SSIS

Environment: MS Visual Studio, SQL Server Management Studio, MS Sql Server, ETL, SSIS, Agile, SDLC

Hire Now