SUMMARY

• Over 8+ years of in - depth experience in database Design, Modeling, development and maintenance of SQL Server 2016/2014/2012/ 2008 R2/2008 large scale databases.
• Expertise in writing T-SQL queries, Joins, Constraints, DDL, DML, creating clustered and non-clustered Index, ETL Processes including Data Cleansing and Data Migration.
• Experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Good Knowledge in designing Database Models using UML, MS Visio and Erwin.Experience with Microsoft Power Platform, using data connectors, and Common Data Services
• Experience with SQL/Query tools to extract and update data
• Experience using data reporting and data visualization tools including PowerBI and Tableau
• Migrated existing SSRS reports to Power BI and created different reports and dashboards using Power BI.Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

RDBMS: SQL Server 2008/2008R 2/ 2012/2014/2016

Database/ETL Tools: SSIS, SSAS, SSRS,Power BI,Tableau

Reporting: SQL Server Reporting Services (SSRS), Report Builder

Languages: VB.NET, C#, C++, T-SQL

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2008, 2008R2, 2012

PROFESSIONAL EXPERIENCE

Confidential

SQL / Power BI Developer

Responsibilities:

• Experienced in Analyzing and understanding the business requirements, definition and design of the data sourcing and data flows Involved in creating functional and technical specification documents after gathering requirements from business.
• Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.
• Building Analysis Services reporting models
• Developed visual reports, dashboards, and KPI scorecards using Power BI desktop
• Connected to data sources, importing data, and transforming data for Business Intelligence
• Excellent in analytical thinking for translating data into informative visuals and reports
• Able to implement row-level security on data and understand application security layer models in Power BI
• Proficient in making DAX queries in Power BI desktop
• Expertise in using advanced level calculations on the data set
• Responsible for design methodology and project documentation
• Able to develop tabular and multidimensional models that are compatible with warehouse standards
• Adopted, developed, publishing, and scheduling Power BI reports as per the business requirements
• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources
• Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS) or API automation.
• I am experienced in developing custom visuals for Power BI.
• Create SSIS packages to extract data from different sources.
• Responsible for developing, supporting, and maintenance for ETL (Extract, Transform, and Load) processes using SSIS increased performance by 15%
• Aggregate, Derived Column, and Data Conversion Transformations.
• Create indexes on tables; Trace out any table that required any indexes and determine the type of indexes on it.
• Place huge table/non-clustered index on separate file group to improve performance by 40%.
• Worked with more than 20Client/Business Analysts to define data requirements for reporting and data maintenance.
• Interacting with Business Analysts and Developers in identifying requirements, designing, and implementing Database Schema.
• Attend backlog grooming, sprint planning, retrospective meetings, and experience as a scrum master.
• Worked as team following Agile/SCRUM methodology for iterative and incremental development.

Environment: MS SQL Server 2012/2014, SSIS, SSRS, Erwin, Excel, Windows Server, Flat Files, Team Foundation Server (TFS), Jira (Atlassian)

Confidential - Charlotte, NC

SQL/ Power BI Developer

Responsibilities:

• Worked closely with SME’s end users/internal customers to understand project/requirement scope
• Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes
• Involved in the logical and physical data models of databases and prepared test cases for existing solutions and new solutions to validate the solution met requirements.
• And prepared documentation for the same.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed)
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Designed an OLAP system with the help of ERWIN to visualize data structure.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2012/2016.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-users to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Unpivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Developed visual reports, KPI scorecards, and dashboards using Power BI desktop.
• Create, assess, evaluate, and iteratively improve models.
• Develop models to support group functions strategy and business pillar initiatives.
• Understand and utilize the full range of facilitation methods and tools to run effective events
• Prototype emerging technologies involving data ingestion and transformation, distributed file systems, databases, and frameworks.
• Utilized various database concepts, including normalization, indexing, physical and logical modeling, in the creation of SQL queries and performance tuning
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.
• Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.
• Helped to develop backup and recovery strategy for databases on virtualization platforms utilizing Microsoft Azure.

Environment: SQL Server 2016/2012, SQL BI Suite (SSIS, SSRS), T-SQL, Power BI, SQL Profiler, MS Office, Erwin, Windows Server 2016.

Confidential - Irving, TX

MS SQL/ETL Developer

Responsibilities:

• Worked closely with SME’s end users/internal customers to understand project/requirement scope and involved in providing solutions to implement or support production issues.
• Involved in the logical and physical data models of databases and prepared test cases for existing solutions and new solutions to validate the solution met requirements.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed)
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer.
• Working knowledge of MicroStrategy’s Semantic Graph functionality developed MicroStrategy reports from FHIR or Smile CDR clinical data repositories.
• Extracted data from heterogeneous sources and transformed, processed the data using SSIS.
• Scheduled jobs for SSIS packages to run monthly/weekly/daily feeds.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations
• Deployed various types of SSIS Transforms in packages including slowly changing dimension, aggregate, fuzzy lookup, conditional split, row count, derived column etc.
• Used TFS for source code management of developed codes/version control.
• Migrated SSIS 2012 version to 2014 and used a custom created DLL for transfer of files using SFTP connection.
• Debug through C# .NET code to troubleshoot production issues and created unit test methods for validation of codes developed.
• Created Alerts/log entries for successfully completed and failed jobs.
• Collaborated with network operators, application developers, engineering and DBAs to address production issues and enhance end user experience.

Environment: SQL Server 2005/2008/ R2/2012, BIDS, Visual Studio 2010/2013, T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, Windows Server 2008R2

Confidential

MS SQL Server SSIS / SSRS Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.
• Wrote custom T-SQL stored procedures andtriggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc.
• To migrate the old Bills information, Customer Information, Contracts Information and other important data.
• Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Used SSIS to upload amortization schedules sent by the client in . CSV format on to the staging tables, which were used for doing all the calculation.
• Then the data was moved to the core tables and the staging tables were deleted.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Managed Alerts for successful or unsuccessful completion of scheduled Jobs.
• Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical comparisons with SQL database of customer information.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in testing, bug fixing and documentation for the project.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Developed incremental loading using MERGE statement in SQL server 2008R2.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Environment: Microsoft SQL Server 2008/2008R2, MS SQL integration Services 2008, SSRS 2008, SSAS, Microsoft Excel, C#, XML, ASP.NET, MS Office.