We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

SUMMARY

  • SQL BI Developer with CRM experience for around 7 years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2008/2012/2014/2016/2017 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance.
  • A Smart working, Motivated, Detail - Oriented team player with excellent communication, interpersonal and problem-solving skills.
  • Expert in writing T-SQL, working on DTS, SSIS, Data Cleansing, Data Scrubbing and Data Migration.
  • Experience in installation, upgrade and configuration of MS SQL Server database.
  • Proficient in writing complex queries and stored procedures in SQL Server 2008,2012, 2015,2017
  • Proficient in data migration from SQL Server 2012 to SQL Server 2017.
  • Migrated SQL server 2017 tables into CSV files using SSIS packages.
  • Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
  • Experience in writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.
  • Excellent T-SQL (DDL & DML) development skills to write complex queries involving multiple tables, great ability to develop and maintain Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models.
  • Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, developing reports using MDX and T-SQL.
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
  • Experienced in Agile development mythology like SCRUM.
  • Transformed database objects from one server to others server using SSIS.
  • Created stored procedures to build the Fact tables in the data mart.
  • Excellent working experience in CRM 2015/2016. Good knowledge of workflows and processes.
  • Capable of forming and maintainingpositive and productive working relationshipsin internal/external and team environments.
  • Strong communication skills, systematic approach, and quick adaptability to new technologies and new working environment.
  • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
  • Migrating data into Microsoft Dynamics CRM Environments using SSIS KingsWay.
  • Experienced in configuring and maintaining Report Manager, Report Server and Report Builder for SQL Server Reporting Services (SSRS).
  • Facilitate the transformation of volumes of data into end-user excel workbooks and reports.
  • Extracting huge volume of data from database to csv and text files using SSIS packages with various transformations.
  • Design, develop and maintain T-SQL database objects including table schemas, stored procedures, views and triggers for OLTP environment.
  • Experienced in configuring and maintaining Report Manager, Report Server and Report Builder for SQL Server Reporting Services (SSRS). CreatedPowerBIVisualizations and Dashboards as per the requirements.
  • PublishedPowerBIDesktop reports created in Report view to thePowerBIservice.
  • Experienced in extracting transforming and loading (ETL) data, from different Heterogeneous Data sources like MS Access, Flat File, Excel and Oracle, to MS SQL Server using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
  • Created store procedures and views and embedded in reporting tool to create reports.
  • Well versed with diverse types of reports such as Drill down, Snapshot, Cached, Drill through, Parameterized, cascaded parameterized, Linked, Chart, and Sub-reports using SSRS.
  • Analyzing data from Microsoft Dynamics 365 to validate the data in the SSIS package. Involved in gathering Schema names of the attributes in the entities to provide mapping for data upload.
  • Work with Metadata Schema to synchronize the fields between the SSIS Package and the destination data sources.
  • Involved in all phases of the Project life cycle and also data migration into various instances of the Confidential Microsoft Dynamics 365 servers.
  • Proficient knowledge ofData Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
  • Hands - on experience in Azure Cloud Services (PaaS & IaaS), Storage, Web Apps, Active Directory, Application Insights, Logic Apps, Data Factory, Service Bus, Traffic Manager, Azure Monitoring, OMS, Key Vault, Visual Studio Online (VSO), Cognitive Services (LUIS) and SQL Azure.
  • Designed and developed Cloud Service projects and deployed to Web Apps, PaaS, and IaaS.

TECHNICAL SKILLS

Database Tools: SS Management Studio (2008/2012,2014,2017), Query Analyzer, Data Profiling, SQL Profiler, Index Tuning. Wizard, SQL Server Integration services (2008,2012,2014,2016), SQL Server Reporting services (2008,2012,2014,2016), Visual Studio (2008,2012,2013,2015,2017), Upgrade Wizard, Databases Maintenance Plan Wizard, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio, SQL CMD, KingsWay, Team Foundation Server- Visual Studio 2017, Microsoft Dynamics CRM 365. System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Database Engine Tuning Advisor

Languages: T-SQL, C, C++, VB.NET, PL/SQL, C#, XML, HTML

Operating Systems: Windows Server 2003, Windows XP, Windows 7 Professional, Windows 8 & 10

PROFESSIONAL EXPERIENCE

Confidential

SQL BI Developer

Responsibilities:

  • Used SQL server Data profiler to understand the application flow and fix issues.
  • Migrated Data from Access Database to Excel and gathering requirements and Loaded in SQL Server.
  • Developed unit test plans for SSIS packages.
  • Expert in writing T-SQL, working on DTS, SSIS, Data Cleansing, Data Scrubbing and Data Migration
  • Analyzing, modified, Data Cleansing on SQL Database and wrote complex TSQL statements and Migrated data into Excel files.
  • Designed ETL packages dealing with different data sources SQL Server and Excel Files and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)Modified existing SSIS packages to meet current business needs
  • Involved in Development and Support Phase of the Project
  • Involved in various crucial changes in the application
  • Involved in the design development processes of several modules.
  • Proficient in writing complex queries and stored procedures in SQL Server 2017
  • Developed custom aspx pages, CRM Workflows, Plug-ins .
  • Store procedures, User defined functions, Views, T-sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views.
  • Using aggregate strategies to aggregate data, sorting and joining tables.
  • Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Migrating data into Microsoft Dynamics CRM Environments using SSIS KingsWay.
  • Created a SQL reporting services (SSRS) and SSIS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
  • Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
  • Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
  • Using SSRS delivering enterprise, Web-enabled reporting, create reports that draw content from variety of data source.
  • Created SSRS reports against Team Foundation Server Database.
  • Analyzing data from Microsoft Dynamics 365 to validate the data in the SSIS package. Involved in gathering Schema names of the attributes in the entities to provide mapping for data upload.
  • Created indexes on tables, views to improve the performance of queries.
  • Developed flowcharts for complex stored procedures.
  • Work with Metadata Schema to synchronize the fields between the SSIS Package and the destination data sources.
  • Involved in all phases of the Project life cycle and also data migration into various instances of the Confidential Microsoft Dynamics 365 servers.
  • Provided quick solution to Azure teams for self-servicing data maintenance operations, which uses SQL Master Data Services.
  • Configured and setupSQL Server Master Data Services (MDS)for self-serving data maintenance across different teams.
  • Deployed the toolsMicrosoft Azure Cloud Service (PaaS, IaaS), and Web Apps.
  • Used SQL Azureextensively for database needs in Customer Lookup & //AzNot.
  • Migrated the Azure CXP Tools to HTTPS based authentication using SSL encryption.
  • Improved application performance usingAzure Searchand SQL query optimization.

Confidential

SQL BI Developer

Responsibilities:

  • Involved in the analysis of the requirements and gathering requirements for closed loop project.
  • Involved in creatingSSISpackages to migrate large amounts of data.
  • CreatedDatabases,Tables,Cluster/Non-Cluster Index,Unique/Check Constraints,Views, Stored Procedures.
  • UsedSQL Server Agentfor schedulingjobsandalerts.
  • Migrated data from Access database, DB2 and Ad abase to SQL Server with incremental Load.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)Modified existingSSISpackages to meet current business needs.
  • Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
  • Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources
  • Supported technical team members in installation and configuration of all SQL servers.
  • Created Systems for capturing data in flat file destination, sending the error data in flat file attached to the corresponding mail ids using send mail task and correcting error data.
  • Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups.
  • Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
  • Designed ETL packages for different data sources (XML, SQL Server and Flat Files). Created indexes for the fast retrieval of data from the database.
  • Defined Indexes, Views, Constraints and Triggers to implement business rules.
  • Involved In writing Complex T-sql Queries.
  • Backing up master & system databases and restoring them.
  • Worked on Query Optimization through query Analysis and Index Optimization.

Confidential

SQL BI Developer

Responsibilities:

  • Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers.
  • Creation of Clustered and Non-Clustered Indexes for Query Performance and Generate variousreports using complex stored procedures.
  • Exceptional communication skills in requirement gathering and design strategies for databasemanagement system.
  • Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Created stored Procedures for slowly changing dimensions type II
  • Created dimensions and fact tables that provided with Primary Key and Foreign Key to buildPower BI reports
  • Worked with transferring the data using SSIS (SQL Server Integration Services) packages.
  • Used MS Excel, CSV files as data source and copied data to the target.
  • Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which weredeveloped to update the database.
  • Created SSIS packages to import the data into SQL server.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Involved in Troubleshooting of the already existing SSIS packages.
  • Managed server related issues.
  • Developed unit test plans for SSIS packages.
  • Designed reports in Power BI.
  • Provided documentation and Runbook for Power BI reports and SSIS packages.
  • Support the front-end team with SQL queries for reporting purpose.
  • Used CRM 2015 to capture all the accounts and contacts. Created workflows and processes to automate process.
  • Create the Functional Design document
  • Created SSIS Packages to migrate slowly changing dimensions
  • Used OLAP Processing Tasks for automatic processing of OLAP Databases.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • Worked on ProClarity to create OLAP data sets and queries are created directly from the Unified Dimensional Model.

Confidential

SQL BI Developer

Responsibilities:

  • Experience writing complex T-SQL Queries.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2012/2014.
  • Used SQL server Data profiler to understand the application flow and fix issues.
  • Database and Log Backup, Restoration, Backup Strategies, Scheduling.
  • Involved in testing and debugging stored procedures.
  • Defined Views, Constraints and Functions to implement business rules.
  • Expert in creating SSIS packages by using For Each Loop Containers that migrate data from bulk of flat files to SQL Server.
  • Designed ETL packages for different data sources (XML, SQL Server, Flat Files, Excel Files). Created indexes for the fast retrieval of data from the database.
  • Migrating SQL Server database from 2008/2012/2014.
  • Upgraded existing SSIS packages (2008/2012/2014 ).
  • Created SSIS packages with complex transformations.
  • Maintaining and Troubleshooting Existing Packages.
  • Experience with Microsoft office.
  • Store procedures, User defined functions, Views, T-sql scripting for complex business logic.
  • Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.
  • Experience in Performance Tuning and Query Optimization.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player
  • Experience in creatingViews, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scriptsand numerousstored proceduresconsumed at various stages ofmigration/cleansingprocess,reportsordata validation.
  • Proficient in writing complexT-SQL (DDL, DML),newfeatures likeCTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL,Physical, logical database designand Performance tuning.
  • Expertise inPower BI, Power BI Pro, Power BI Mobile.
  • Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
  • Extensively usedJoins and Sub-Queriesto simplify complex queries involving multiple tables.
  • Generated ETL Packages tasks daily using SQL Server Agent jobs by scheduling and also manually configured.
  • Experience in configuration and maintain Report Manager andReport ServerforSSRS,DeployedandScheduledthe Reports inReport Manager
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, Graphs.
  • Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
  • Deployed the SSRS reports in Microsoft office share point portal server.
  • Used various report items like tables, sub-report and charts, Graphs to develop the reports in SSRS.
  • Worked with a team to suggest automated processes to reduce human errors and also to save time and resources.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
  • Worked on all types of transformations that are available in Power bi query editor.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.
  • Created Power BI reports using time intelligence calculations and functions.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Confidential

Database Developer

Responsibilities:

  • Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
  • Developed stored procedures, views and User Defined Functions using T-SQL statements.
  • Installed and Maintained MS SQL Server 2008/2012.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts
  • Created permanent tables, temporary tables and table variables.
  • Design and develop database architecture
  • Design, develop and test new and existing databases
  • Develop database management systems for easy access, storage and retrieval of data
  • Used Query Analyzer to optimize SQL queries.
  • Responsible for modifying the stored procedures, rebuilding indexes for improving performance
  • Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement
  • Database creation(DDL, DML, DCL), database tuning, SQL tuning, performance planning.
  • Using customer feedback to improve a database.
  • Planning database security measures.
  • Maintaining technical documentation such as test plans.
  • Deploying bug fixes in a timely manner.
  • Resolving client and internal database issues.
  • Providing technical and backup assistance to computer system users.

Hire Now