We provide IT Staff Augmentation Services!

Data Engineer/data Analyst Resume

Redmond, WA

PROFESSIONAL SUMMARY:

  • Over 10 years of professional experience in Data Warehouse, ETL, Data Analytics / Business Intelligence across Financial, Transport, Technology, Pharmaceutical, HealthCare and Retail domains
  • 6+ years of design, development and administration experience of multi - terabyte data mart and Data warehouse/ Business Intelligent system
  • Well versed experience in Data Modeling, Database Architecture and Software Development Life Cycle (SDLC) based on functional requirements and system design
  • Widespread understanding of SDLC Methodologies like Waterfall, Agile/Scrum
  • Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML
  • Configuring and Administering SQL Server Database ( 2012/2014/2016 ) and BI services
  • Expertise in implementation of architecture design, ETL, data modeling, reporting, data validation, and dashboard development on large datasets
  • SQL DBA activities include but not limited to Installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases
  • Excellent knowledge on Dimensional Modeling concepts like (Star Schema, Snow Flake Schema) and Kimball/Inmon methodologies
  • Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME’s to obtain domain level information of projects
  • Hands on experience on developing and managing multi-tier applications using SQL Server, C#.Net and ASP.Net
  • Extensive experience in Data Analysis, including profiling, cleansing, transforming and confirming
  • Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using Tableau
  • Strong Experience in writing, debugging, fine-tuning and optimizing complex Stored Procedures, Functions, Cursors and Triggers in SQL Server by analyzing the Query Execution Plan and using the Profiler
  • Experience in Extraction and Migration of data from various data sources like Excel, MS Access and Oracle to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities
  • Responsible for migrating on premise SQL Server database to Azure SQL database
  • Implemented Incremental ETL to handle high, historical and incremental volume of data, resolved Circular Loops, Synthetic Keys
  • Working Experience on SQL Azure and Windows Azure Platform
  • Medium level of proficiency in Unix shell scripting
  • Designed and implemented different tabular reports using Power BI
  • Good knowledge about software development in Python (libraries used: Beautiful Soup, numpy, scipy, matplotlib, python-twitter, Pandas dataframe, network, urllib2, MySQL dB for database connectivity)
  • Strong Experience in data cleansing and analysis, using Excel Pivot Tables, Formulas (v-lookup and others), Data Validation, Conditional Formatting, and Graph and Chart Manipulation
  • Team oriented individual with a result driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management

TECHNICAL SKILLS:

Design Methodologies: UML, OOP, SDLC

Data Modeling: Erwin 9.5/8/7, MS Visio 2010/2014, ER Studio, Oracle Designer, SAP power designer 16.0/16.5

RDBMS: SQL Server, Oracle 9i, MYSQL, MS Access, MS Excel, OLTP/OLAP

SQL Server: SQL, T-SQL, MDX, Backup and Recovery, PT, DTS, SSIS, SSAS, SSRS

Cloud Computing Tool: Microsoft Azure (IAAS, PAAS, SAAS), Azure Networking, Azure Storage, Azure Webapps

MySQL: SQL, Backup and Recovery

Database Tools: Microsoft SQL Server 2008/2012/2014, Oracle 9g/10g/11g, PL/SQL, MS Access, Teradata

Operating System: Windows 3.x/9x/ME/NT/2003/XP, MS DOS

Programming Language: C/C++, Java, Python, Visual Basic, Crystal Report, Power BI, HTML, XML, C#.NET, IIS

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Data Engineer/Data Analyst

Responsibilities:

  • Involved in analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment
  • Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
  • Performed data analysis and data profiling using complex SQL, MDX and DAX on various sources systems including Teradata
  • Working with the development team to design and develop high performing data solutions which satisfy the BI requirements
  • Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
  • Created customized reports using various chart types like text tables, bar, pie, Heat maps, line charts, Area charts, scatter plot, dual combinations charts in Tableau
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using SQL Server 2016 Integration services ( SSIS )
  • Manage and support SQL Server databases that include but not limited to- writing complex SQL queries, stored procedures, functions, triggers, managing permissions etc.
  • Responsible for monitoring, troubleshooting & resolving SQL Jobs (Database processing & tabular cube processing)
  • Obtained information from disparate sources, including production and ad hoc systems, linking and analyzing the information, performing data integrity checks and exploratory data analysis
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
  • Involved in optimizing the existing data models and load scripts to improve the performance
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power View and Power BI
  • Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs
  • Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports
  • Acted as a liaison between the development team and the management team to resolve any data conflicts in terms of requirements

Confidential, Redmond, WA

BI Engineer/ Data Analyst

Responsibilities:

  • Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality
  • Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards
  • Implemented BI and other reporting requirements for business management based on priorities
  • Using Tableau Desktop created Interactive-reporting dashboards by combining multiple views
  • Participate in Change Management, Problem management activities using Service Now tool before implementing database changes in production and development activities
  • Developed database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
  • Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards
  • Responsible for creating the staging tables and source to target mapping documents for the ETL process
  • Designed and deployed SSIS packages in production environment to implement business logics
  • Partnered with database administration for installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery of SQL servers
  • Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector
  • Involved in designing and building enterprise level web applications to consolidate and integrate various data sources and software applications by using ASP.NET, multiple Data sources synchronizing, Microsoft SQL server 2012/2014
  • Created impactful dashboards in Excel with pivot tables and advanced formulas to identify key metrics and transform raw data into meaningful and actionable information
  • Worked on Performance testing of Dashboard and data validations using independent queries and raw data analysis
  • Published views and dashboards in Tableau Server for auditor review
  • Perform day to day Database Maintenance tasks -- Database Monitoring, Backups, Space Management, and Resource Utilization
  • Manage and resolve trouble tickets for database-related issues submitted by customers and fields

Confidential, Bellevue, WA

SQL DBA/Service Engineer

Responsibilities:

  • Set up/Install/Configure SQL Server 2008 on standalone as well as clustered environments
  • Involved in creating database objects, including tables, clusters, indexes, views, sequences, packages and procedures
  • Monitoring and troubleshooting the production servers with Replication and Log Shipping
  • Set up traces and Profiler to troubleshoot performance issues and tune database objects
  • Create and implement an instance Health Check Monitor Alerts to Analyze Deadlocks and diagnose issues on the server
  • Developed policies and procedures for ensuring the security and integrity of the database and applications
  • Implemented build, deployment processes and scripts using Octopus with development teams
  • Providing the Design/Operational Specs for enhancements in system wrt to new features, optimizations, monitoring, etc.
  • Providing 24*7 Tire 2/Tier3 support to production environment and responded to alerts in a timely manner
  • Resolve the tier 1 issues and escalate through appropriate channels for tier 2 and above.
  • Integrated various external database systems and with numerous other databases using linked servers, DTS, and SSIS packages
  • Automate the task of data transfer between different data centers efficiently using batch scripting
  • Migrate existing data into the Power BI and create reports in preview portal utilizing the SSAS Tabular

Confidential, Galloway, NJ

Sr. SQL Server Developer

Responsibilities:

  • Coordinated in requirements gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project
  • Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
  • Implemented Forward engineering to create tables, views and SQL scripts and mapping documents
  • Worked with Business Analyst during requirements gathering and business analysis to prepare high level Logical Data Models and Physical Data Models
  • Developed and maintained T-SQL stored procedures, functions, triggers and scripts, which were integral to the client’s account
  • Developed indexed generic views to facilitate easy user interface and enforce security on critical customer information
  • Responsible for maintenance, Backup & Recovery, testing, alerts (job failures, database & server capacity, etc), and database integrity checks
  • Experienced in data migration and cleansing rules for the integrated architecture (OLTP, ODS, DW)
  • Administer and maintain end user accounts, permissions, and access rights for security systems as appropriate
  • Responsible for performance monitoring, Performance Tuning, security, and finding and fixing data integrity issues within the database
  • Actively involved in design and develop .NET web components and user controls using ASP.NET, C#, and AJAX
  • Responsible for integrating the work tasks with relevant teams for smooth transition from testing to implementation phase

Confidential, Cleveland, OH

Programmer Analyst

Responsibilities:

  • Worked with Business Analyst for requirements gathering, business analysis and project coordination
  • Created the best fit Physical Data Model based on discussions with DBAs and ETL developers
  • Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model
  • Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin
  • Worked on Slowly Changing Dimension tables
  • Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose
  • Extensively used Star & Snowflake Schema Methodologies and created the data source views (DSV) and cubes using the identified fact and dimension tables
  • Created Classes, Dimensions and Measures objects according to business requirements
  • Designed and created complex MS OLAP Cubes, including application of dimension maps spanning multiple fact types within the same cube
  • Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements
  • Made modifications/and added new MDX and XMLA Queries to cubes
  • Developed an automated process that compares the results of the existing Profile Reports with the data extracted from the MDA Cube
  • Create calculated measures using DAX and then develop Power View reports and host it on share point

Confidential, Baltimore, MD

SQL Developer

Responsibilities:

  • Involved in designing the physical databases model on SQL Server 2005 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system
  • Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application
  • Worked with development teams in the design of physical databases and in modification
  • Created Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS
  • Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environment
  • Generated some wrapper code in C# to get better maintainability.
  • Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
  • Participated in security, auditing, configuring, documenting, enhancement & corrective changes, emergency changes
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance

Confidential

Jr. SQL Developer

Responsibilities:

  • Involved in different stages of Project Life Cycle
  • Actively participated in gathering Business Requirements and System Specifications
  • Created new Databases, tables, established relationship among tables in a database
  • Created stored procedures and functions to support efficient data storage and manipulation
  • Created views to display required information on user interface, and triggers to validate consistent data entry into the database
  • Defined Constraints, Indexes
  • Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, indexes and constraints on existing databases
  • Experienced in Designing the web modules and interface using Visual Studio and Asp.NET 1.1 for Corporate Management System
  • Implemented batch processing using Jobs and SQL scripts
  • Migrated data from Flat files to SQL server 2000 using DTS
  • Scheduled Jobs using SQL Server Agent
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
  • Supports day to day operational duties for the database platform such as service requests, backups, user administration and system troubleshooting

Hire Now