SUMMARY

• Overall 7+ years of Experience working as a SQL/BI Developer over various industry domains.
• Experienced in Database Development, Administration, Data Analysis and System Analysis.
• Design, Development and Support of MS SQL Server 2008,2012,2016,2019 in Production, Testing and Development environments both physical and virtual.
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, and preparing High level and Low level design documents.
• Hands - on experience in monitoring SQL Server Performance tuning in SQL Server 2008,2012,2016,2019 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Knowledge of Relational Database Management systems.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ DE normalization Techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks
• Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.
• Having experience in Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
• Good Knowledge working with Facts, Dimensions, Multi-Dimensional Cubes.
• Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
• Experience in Data Modeling using Erwin Design Tool
• Knowledge of Networking Concepts and Object Modeling Technology.
• Good interpersonal, Analytical and Communication skills.

TECHNICAL SKILLS

Databases: SQL server 2017, 2016/2014/2012/2008 R 2/2008/2005/2000 , MySQL, MS Access, Oracle, Sybase

Programming/Query Languages: SQL, PL/SQL, PowerShell, VBA, C++, HTML, C# and Visual Basic for Application

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, DBCC, SQL Server Profiler.

BI Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), MDX, SQL Server Integration Services (SSIS)

Design Tools: Microsoft Office, MS Visio

Operating Systems: Windows NT/98/2000/XP/ 2008/ 2012/2016/2019

Packages: MS Office 2007, MS Office Excel, MS Power Point

Administering Database Engine: Security, Managing SQL Servers, Managing Large Databases, Linked Server, High Availability, Importing Exporting Bulk Data, Backing up Restoring, Deploying Application

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

SQL BI Developer

Responsibilities:

• Gathered functional requirements, analyzing and writing the technical specifications.
• Build logical data models that describe all the data and relationships between the data.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Maintained and enhanced SAS-based tool to create disaster recovery files
• Validated change requests and made appropriate recommendations. Standardized the implementation of data
• Modifying Stored Procedures to improve performance.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2012/2016/2019 Analysis Services (SSAS) and Reporting service (SSRS).
• Experience in debugging Stored Procedures using Visual Studio Tool by setting breakpoints.
• Created complex Stored Procedures, Tables, Views, SQL Joins and other statements to maintain referential integrity and implemented complex business logic.
• Built and published customized interactive reports and dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Power BI.
• Effectively used data blending feature to identify relevant socio-economic parameters using correlation analysis.
• Conducted Exploratory Data Analysis to identify hidden patterns in data.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the Dimensions and Cubes in Analysis Services.
• Used SAS, SAS Macro, Dialog Manager and list to update and build menu-driven query tools to create SAS reports from an accounting database.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2016.

Environment: Power BI, MS SQL Server 2008/ 2012/2016/2019 , SPSS Modeler 18.2, MS Solver, Minitab-Statistical tool, Azure ML Designer, MS Access.

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Designed the database objects to serve business needs.
• Created SSIS (ETL) packages with .NET Framework Data Provider connection, involving Control Flow and Data Flow Tasks, wrote SQL stored procedures implementing logic and data cleansing, Event handling.
• Optimized the performance of SSIS package and SQL stored Procedures for better package execution.
• Using SSAS created Data source, Data Source views (Star Schema), Named Calculations, de ned relationship between the tables.
• Created Dimensions, attributes, relationship between attributes and hierarchies, measures, and measure group.
• Created and processed complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, raised change requests by making changes to the SSAS cube as per the requirement.
• Created dashboard style of layouts using different components of SSRS like List-boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, and bookmarks.
• Developed several BI applications using the SSIS platform connecting to and integrating data from several databases using an ETL load script and standard expressions for calculated dimensions on charts and tables.
• Involved in creating Data Mining structures, mining models, de ning Data types, content types using Data mining wizard also wrote Data mining expressions.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.
• Collaborated with different stakeholders from Infiniti Retail to understand client’s businesses, their operational and manufacturing strengths.
• Recommended new product lines based on data driven analysis.
• Responsible for introducingproductsin new categories and increase in overall portfolio.
• Created Key performance indicators (KPI’s), Partitions, Aggregations serving the business need.

Environment: SQL Server 2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#,SQL Server Analysis Services (SSAS), Microsoft Visual studio 2010,IIS, VB.Net, Erwin

Confidential, Minneapolis, MN

SQL Developer

Responsibilities:

• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogeneous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted, transformed and loaded data into a data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and scorecards reports (SSRS) according to business requirement.
• Created reports by dragging data from cube and wrote MDX scripts.
• Used SSIS 2008 to create ETL packages( dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
• Use GitHub for better visibility of code changes and push said changes to the master branch.
• Work on MS Access Applications and Internal Applications for Recurring Enhancements to Codebase Applications.
• Creating the power shell scripts in order to run the automated jobs in multithreading
• Automate the Import/Export Process Using PowerShell.
• Efficient in understanding the requirements and established connections to SQL tables, VBA applications and PowerShell scripts.
• Monitor and tune SQL Scripts along with Creating upgrade scripts for production environments using Database management tool SSMS.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan. Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, indexes, Triggers

Environment: Power BI, MS SQL Server 2008/2012/2016 , SPSS Modeler 18.2, MS Access.

Confidential

Data Engineer

Responsibilities:

• Extract, transform and load (ETL) the data from source applications systems into the data warehouse.
• Generated different types of Reports like Tabular, Matrix, Charts, Drill Down and Drill Through reports usingSSRS.
• Deployed reports, created report schedules, subscriptions, securing reports.
• Identified the Data Source and defining them to build the Data Source Views.
• Worked on Database Maintenance Indexing, Rebuild and Reorganize.
• Worked in a quality assurance team and focused on links related to disengage events.
• Analyzing the root cause for which the SDC (Self Driving Car) is stopping.
• Reviewing the Triages based on the Disengage policy.
• Worked on different workflows so called Traffic lights, School Bus, web-wiz simulation.
• Acting as a team player to achieve a target and being an exceptional contributor for the team.
• Define and scope projects with quantifiable goals and baseline data.
• Collaborate with engineering and product stakeholders to influence process improvements.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.

Environment: Power BI, MS SQL Server 2008/ 2012 SSIS Tester SPSS Modeler 18.2, MS Access.

Confidential

Data Engineer

Responsibilities:

• Migrated hundreds of Physical Machines to Virtual Machines
• Conduct System Testing and functionality after virtualization
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Work with App Teams on creating a productive Development, Test and Production environment for App Databases.
• Make recommendations for File Group Creation and Placement, Right Data types for the Structures created.
• Creating upgrade scripts for production environments. Responsible for installation of SQL Server Packs and Hotfixes.
• Developed SSIS Packages for Snapshot, Incremental, Historical Changes (SCD Type 2) Data Loads.
• Experience in query optimization & performance tuning.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.

Environment: Power BI, MS SQL Server 2008/2012/2016 , SPSS Modeler 18.2, MS Access.