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