We provide IT Staff Augmentation Services!

Sr. Sql Bi/data Analyst Resume

San Francisco, CA

PROFESSIONAL SUMMARY:

  • Around 8+ years of experience in Data Analyst and Data Modeling, Data Development, Implementation and Maintenance of databases and software applications.
  • Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
  • Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
  • Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
  • Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, Data Vault Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
  • Experience in checking data quality using SQL/Integration Services, identifying errors and error patterns, and suggesting some data cleansing mechanisms.
  • Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and Agile methodology.
  • Strong experience in design and developing ETL using SQL Server Integration Services (SSIS).
  • Experience in Installing, Managing, Monitoring and Troubleshooting SQL Server.
  • Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
  • Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS)
  • Experience in working with large databases in SQL, Oracle, and Teradata.
  • Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS.
  • Extensively worked on Data Profiling concepts to maintain the data quality and data reliability
  • Extensively worked on Data Cleansing or Data Scrubbing concepts to validate the corrupted data
  • Expertise in generating reports on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services, Crystal Reports, MS Excel, Power BI and Tableau.
  • Solid hands on experience with administration of data model repository, documentation in Meta data portals in such as Erwin, ER Studio and Power Designer tools.
  • Experience in Big Data Hadoop Ecosystem in ingestion, storage, querying, processing and analysis of big data.
  • Good knowledge about creating cloud based solutions and architecture using Amazon Web services (Amazon EC2, Amazon S3, and Amazon RDS) and Microsoft Azure.
  • Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
  • Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, Excel, CSV, MS access and flat files.
  • Very good Self-motivated, smart working Professional with good organizational leadership.
  • Ability to work in-groups as well as independently with minimal supervision.
  • Good team player, strong interpersonal, analytical and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Databases: MySQL, MS SQL Server (2008.2008R,2012,2014, 2016), Oracle (10g,11g,12c), MS Access, IBM DB2, Mongo DB

SQL, T: SQL, PL/SQL, R, SAS, Python, UML, Java, HTML, CSS

Tools: SQL Server Management Studio (SSMS), MS Visual Studio (2013/2015/2017 ), Eclipse, SQL Server Profiler, Power BI (Desktop, Server, Mobile), MS Excel, MS Word, MS Project, MS Visio 2016, SQL Plus, Tableau Desktop.

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) Import Export Data, Alteryx

Waterfall, Agile, Business Analysis, Object: Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling.

Machine Learning: ANOVA, Regression (Linear, Logistic, Polynomial, Decision Tree, Random Forest, Support Vector), Na ve Bayes, K-NN, Clustering (Hierarchical, K-Means)

Big Data Technologies: Hadoop, Pig, Hive, Oozie, Flume, Impala, Avro, Kafka, Spark

Operating Systems: Windows Server 2003R2/2008R2/2012, Windows (XP,7,10), Unix.

WORK EXPERIENCE:

Confidential, San Francisco, CA

Sr. SQL BI/Data Analyst

Responsibilities:

  • Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
  • Wrote SQL queries (aggregates, conditional statements, sub queries) and analyze large data sets resulting in problem resolutions and improvement recommendations.
  • Capable of performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata
  • Developed normalized Logical and Physical database models to design OLTP system
  • Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r9
  • Developing SQL database and BI solutions using T-SQL, SSIS, SSRS, SSAS, MDX, query performance tunings, database development, implementation, support of data, and underlying data models.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
  • Design and development of Datawarehouse to accommodate upcoming update or incremental data sets.
  • Designed SSIS packages to import data from multiple sources to control upstream and downstream of data into SQL Azure database and used Microsoft Azure date storage, Azure Data Factory and Data Lake.
  • Wrote SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
  • Created Claims and Enrolment OLAP Cubes for various measure groups and dimensions for analysis of Per Member/Per Month cost to meet the business answers for the client needs using SSAS.
  • Identified data patterns by designing corresponding machine learning algorithms using Python or SAS.
  • Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from the database
  • Deployed and uploaded SSRS reports to SharePoint Server for the end users to look at them.
  • Performed job scheduling to ensure execution of certain jobs and daily updates.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS, developed and maintained enterprise reporting (SSRS Reporting Service) based on specifications and business needs and modified existing reports as needed.

Environment: MS SQL Server 2014/2012/2008 , Visual Studio 2010/2012, Erwin r9, MS Excel, MS Visio, Rational Rose 7, Tableau, Reporting Services (SSRS), Power BI, Integration Services (SSIS), Python/SAS, Analysis Services (SSAS), T-SQL, Microsoft Azure, Excel, Agile Methodology.

Confidential

Data Modeler/Analyst

Responsibilities:

  • Worked with Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications
  • Worked with Business users during requirements gathering and prepared Conceptual, Logical and Physical Data Models.
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Gather all the analysis reports prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development .
  • Wrote complex Queries, Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
  • Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
  • Created SSIS packages to Export data from text files/CSV files to Teradata SQL Assistant Database.
  • Used various SSIS tasks such as Conditional Split, Derived Column, Lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server.
  • Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
  • Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
  • Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
  • Created SSRS Data Model projects using Microsoft Visual Studio and using Report Builder for report server to create reports.
  • Created customized reports using various chart types like Text Tables, Bar, Pie, Tree Maps, Heat Maps, Line Charts, Pivot Tables, Combination Charts in Excel and Tableau.
  • Created and published Tableau reports utilizing complex calculated fields, table calculations, filters and parameters.
  • Developed and maintained system documentation, diagrams and flowcharts.

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, T-SQL, MS Office (Word, Power point, Excel), ETL, Microsoft Visual Studio, Tableau, TFS, ERWIN, SharePoint, Agile Methodology .

Confidential

Data Analyst

Responsibilities:

  • Developed and managed Stored Procedures, Triggers, Functions, Indexes, Views, and Joins using SQL for tuning the customer transaction data.
  • Created a highly complex multifunctional application using MS Access to support a team of people.
  • Profound knowledge of MS Access programming with VBA.
  • Worked with business users, programmers, testing staff, and database administrators to develop database requirements, test plans and database schemas to transition MS Access database to SQL Server.
  • Migration on Access tables to SQL Server using SQL Server Migration Assistant (SSMA).
  • Created packages using SSIS (SQL Server Integration Services) to perform ETL (extract, transform, and load) operations by importing and exporting data, cleaning data, adding new variables and deploying it in form of SSRS reports.
  • Use advanced Excel functions, power and regular pivot tables, pivot charts, and other functions to conduct data extraction and analysis to make data-driven decision.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Desktop
  • Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: T-SQL, SQL Server 2008/2012/2014 , MS Access 2010/2013, VBA, SQL Server Management Studio (SSMS), SSIS, SSRS, ETL, Data Mining, MS Excel, SQL Server Migration Assistant (SSMA), Tableau

Confidential

Technical Analyst

Responsibilities:

  • Upgraded to latest version from SQL Server
  • Wrote various Stored Procedures for the purpose of application development
  • Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
  • Maintained disaster recovery and database maintenance plan
  • Worked on replication of data (Transactional method used)
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Performed job scheduling and alerts
  • Created database objects for improving the performance
  • Fine-tuned Procedures, Functions and Triggers for optimum performance
  • Involved in creating SQL reports
  • Involved in the SQL Query Performance Tuning
  • Designed and implemented user log in and security
  • Resolved any deadlocks issues with the databases/servers on a real-time basis.
  • In-Depth working knowledge of ODBC.
  • Created many complex Stored Procedures and user defined functions.

Environment: MS SQL Server 2008/2012, T-SQL and Windows XP

Confidential

Software Developer

Responsibilities:

  • Gathering and analyzing the end user requirements
  • Design of user interface screens according to the low level design documents
  • Coding in VB6.0, unit testing, integration testing
  • Writing SQLs to use in application development
  • Writing database stored procedures and triggers to as specified in low level design
  • Reporting to project manager

Environment: Visual Basic 6.0, Visual Source Safe, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft word.

Hire Now