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