We provide IT Staff Augmentation Services!

Ms Sql/bi Developer Resume

2.00/5 (Submit Your Rating)

Alpharetta, GA

SUMMARY

  • 9 years of experience in Database Design and ETL Development of MS SQL Server
  • Experience in all phases of the Software Development Life Cycle (SDLC).
  • Data analysis, documentation, and error handling.
  • Selecting the appropriate AWS service based on data, compute, database, or security requirements
  • Migrating from On - Premise Infrastructure to Azure, hosting theSQLdatabases application onMicrosoft Azure.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.
  • Migrate between two version of the MS SQL server
  • Worked wif business users and development staff to understand/determine requirements, collaborated wif application developers for delivering the requirement on time and wif scalability.
  • Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization.
  • Strong RDBMS concepts and experience in creating and maintaining Stored Procedures, Views, Functions, Triggers, Indexes, and Constraints.
  • Experience in SSIS\SSRS\SSAS.Wide experience in building static, dynamic and interactive reports using BIDS and Report Builder.
  • Experienced wif full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
  • Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.
  • Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
  • Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS.
  • Experienced in designing Star, Snow flake Schemas and OLAP cubes.
  • Experienced in migrating data from one SQL Server version to another.
  • Experienced in database server performance tuning and optimization of Complex SQL queries.
  • An excellent team player & technically strong person who has capability to work wif business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
  • Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/ 2008/2008 R 2/ 2012/2014/2016 , PostgreSQL

Database/ETL Tools: SSIS/IBM DataStage, SSAS, SSRS, NetSuite

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

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

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2008, 2008R2, 2012 and Mac

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

MS SQL/BI Developer

Responsibilities:

  • Worked wif business users and stakeholders to gather or refine requirements
  • Deployed database objects from development/testing environment to production environment.
  • Worked on Dbeaver/PostgreSQL, Coding and debugging.
  • Supported end users to resolve issues and assisted users on existing database applications.
  • Worked wif Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
  • Debug PostgreSQL, working on allocations and aggregation.
  • Worked on source control Bitbucket, git wif Bash
  • Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services
  • Working on AWS redshift
  • Checked the SQL Server is online and that still has connectivity wif the front-end applications and functionality, making sure a 24/7 availability. Collaborated wif multiple application owners addressing various issues
  • Monitored growth of database objects for capacity planning.
  • Created Documentation for steps need to be taken while upgrading the SQL server 2008/2008R2 to SQL server 2012, which includes in-place, side-by-side and standalone migration.
  • Worked wif business users and stakeholders to gather or refine requirements
  • Deployed database objects from development/testing environment to production environment.
  • Supported end users to resolve issues and assisted users on existing database applications.
  • Worked wif Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
  • Experienced SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
  • Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services
  • Developed periodic SSRS reports in BIDS used to generate daily, weekly, monthly, and quarterly reports
  • Checked the SQL Server is online and that still has connectivity wif the front-end applications and functionality, making sure a 24/7 availability. Collaborated wif multiple application owners addressing various issues
  • Monitored growth of database objects for capacity planning.
  • Created Documentation for steps need to be taken while upgrading the SQL server 2008/2008R2 to SQL server 2012, which includes in-place, side-by-side and standalone migration.
  • Successfully migrated databases from SQL Server R2/2012, SSIS packages, SSRS reports, multiple databases along all database objects like stored procedures, logins (orphaned users and after migration worked wif application owner to redirect\point their application to the new migrated server)
  • Enhanced the old logical and physical database design to fit new business requirement and implemented new design into SQL Server 2012.

Environment: SQL Server 2005/2008/ R2/2012, BIDS, Visual Studio 2005/2008, T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, SSMS, Report Builder 2.0/3.0, Dbeaver 21.2.0.2021

Confidential, Blue Bell, PA

SQL Developer

Responsibilities:

  • Worked wif business to gather requirements and create technical documentation for implementation
  • Supported both transactional and OLAP applications
  • Worked on creating different financial reports for finance and enterprise teams also used Power BI Premium
  • Selecting the appropriate AWS service based on data, compute, database, or security requirements
  • Migrating from On-Premise Infrastructure to Azure hosting theSQLdatabases application onMicrosoft Azure.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.
  • 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.
  • Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance, used SQL Profiler, and Query Analyzer to debug, troubleshoot, monitor, and measure SQL statements and stored procedures
  • Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance.
  • Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, Web Services) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
  • 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
  • Worked on in report writing using SQL Server Reporting Services like Sub-Reports, Drilldown-Reports, Summary Reports, Parameterized Reports Cascading parameter report, Tabular report, Matrix report, Chart report, Pie Charts and column report.
  • Experience in making DAX queries in Power BI desktop.
  • Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
  • Experience in connecting to different data sources, importing data and transforming data for Business Intelligence.
  • Excellent in analytical thinking for translating data into informative visuals and reports.
  • Adept in developing, 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.

Environment: SQL Server 2014/2016, BIDS, Visual Studio and data tools 2017, Microsoft Azure, SSIS, SSRS, SSAS, Windows Server 2014, Tableau, Power BI, Navision, Oracle, AWS

Confidential, Atlanta, Georgia

SQL/BI Developer

Responsibilities:

  • Worked wif business to gather requirements and create technical documentation for implementation
  • Selecting the appropriate AWS service based on data, compute, database, or security requirements
  • Migrating from On-Premise Infrastructure to Azure, hosting theSQLdatabases application onMicrosoft Azure.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.
  • Supported both transactional and OLAP applications
  • Worked on creating different financial reports for finance and enterprise teams.
  • 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.
  • Collected 2 years of Python experience
  • Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance, used SQL Profiler, and Query Analyzer to debug, troubleshoot, monitor, and measure SQL statements and stored procedures
  • Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance.
  • Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, Web Services) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
  • 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
  • Worked on in report writing using SQL Server Reporting Services like Sub-Reports, Drilldown-Reports, Summary Reports, Parameterized Reports Cascading parameter report, Tabular report, Matrix report, Chart report, Pie Charts and column report.
  • Experience in making DAX queries in Power BI desktop.
  • Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
  • Experience in connecting to different data sources, importing data and transforming data for Business Intelligence.
  • Excellent in analytical thinking for translating data into informative visuals and reports.
  • Experience in implementing row level security on data and worked on security layer models in Power BI.
  • Adept in developing, 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.
  • Experience in integrating Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation. Also, one must be experienced in developing custom visuals for Power BI.

Environment: SQL Server 2014/2016, BIDS, DataStage, Visual Studio and data tools 2017, Microsoft Azure, SSIS, SSRS, SSAS, Windows Server 2014, Tableau, Power BI, Navision, Oracle, AWS

Confidential

SQL Developer

Responsibilities:

  • 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.
  • DataStage development reliable and advances features
  • Collected 1 year experience wif Linux
  • Collected 2 year of Data sense experience
  • Worked wif NetSuite in cloud based business
  • Work on Power BI embedded and Azure as well as Power BI Premium.
  • Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.
  • Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
  • Extracted data from various sources like SQL Server, Flat files, XML and Web services from Client servers and through FTP.
  • Set up ETL Jobs using SSIS to run on a daily basis in SQL Server Agent.
  • Configuring SSIS packages using package configuration wizard to allow Packages run on different environments.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Created SSRS Parameterized, Drill Down, Drill Through, Sub, Chart, Dashboard and Scheduled Reports, wif expressions to Calculate, Group and Filter data; some wif XML data sources and custom VB.NET code etc.
  • Generated multiple reports from SQL Server Database (OLTP) and multidimensional data model OLAP.

Environment: MS SQL Server 2014,2012,2008 Microsoft Visual Studio 2010, MS Access, MS Excel, MS Visio, SQL Server Profiler, Windows Server 2008.

Confidential

MS SQL/ETL Developer

Responsibilities:

  • Worked closely wif SME’s end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.
  • Involved in the logical and physical data models of databases and prepared test cases for existing solution 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.
  • Collected 2 years of Python experience.
  • 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
  • Collected 2 years of Data Sense experience.
  • 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 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 wif 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 Developer

Responsibilities:

  • Worked wif business users and stakeholders to gather or refine requirements
  • Deployed database objects from development/testing environment to production environment.
  • Supported end users to resolve issues and assisted users on existing database applications.
  • Worked wif Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
  • Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services
  • Developed periodic SSRS reports in BIDS used to generate daily, weekly, monthly and quarterly reports
  • Checked the SQL Server is online and that still has connectivity wif the front-end applications and functionality, making sure a 24/7 availability. Collaborated wif multiple application owners addressing various issues
  • Monitored growth of database objects for capacity planning.
  • Created Documentation for steps need to be taken while upgrading the SQL server 2008/2008R2 to SQL server 2012, which includes in-place, side-by-side and standalone migration.
  • Successfully migrated databases from SQL Server R2/2012, SSIS packages, SSRS reports, multiple database along all database objects like stored procedures, logins (orphaned users and after migration worked wif application owner to redirect\point their application to the new migrated server)
  • Enhanced the old logical and physical database design to fit new business requirement and implemented new design into SQL Server 2012.

Environment: SQL Server 2005/2008/ R2/2012, BIDS, Visual Studio 2005/2008, T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, SSMS, Report Builder 2.0/3.0

We'd love your feedback!