Sql Server/bi Developer Resume
FL
SUMMARY
- Over 8+ of experience as SQL Server/Business Intelligence developer in database designing, modeling, and reporting using SQL Server 2016/2014/2 /2000, SSIS, SSRS and SSAS.
- Experience in requirement analysis, designing, coding, testing and evolution phases in a software development life cycle.
- Experience in writing technical design documents and developing testing documents.
- Interacted with project leads, analysts, DBA’s during the SDLC for better results.
- Worked as SME and act as a liaison between the business teams and application teams.
- Expert in writing T - SQL queries using SQL Server Management Studio (SSMS).
- Rich development experience in creating tables, views, triggers, stored procedures, user defined functions and other T- SQL statements.
- Expert knowledge in using data modeling tools like ERWIN and ER diagrams.
- Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
- Experience in extracting and transforming data using SSIS, Import and Export Data wizard.
- Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing ETL Purposes across different servers.
- Expertise in generating reports using SQL Server Reporting Services (SSRS 2005/2008/SSDT/Data Zen), Power BI, and MS Excel spreadsheets.
- Expert in designing enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/SSDT/Data Zen) to generate drill down reports, drill through reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts.
- Good knowledge & experience on Cloud Computing like Azure/AWS
- Experience in Windows Azure, migrating database to Azure
- Experience in creating Ad-hoc reports, data driven subscription reports by using report builder in SSRS 2008 / Data Zen / Power BI.
- Experience in developing cubes using SQL Server analysis services (SSAS).
- Experience in dimensional data modeling using star and snowflake schemas for fact and dimension tables using SSAS.
- Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
- Experience with ETL and BI Reporting, using Microsoft SSIS, SSAS, designing reports using Power BI and SSRS.
- Hands on experience with creating complex data models, reports, and dashboards in Microsoft’s Power BI
- Experience in creating Tabular models to enhance self-servicing BI solutions excellent team player working in various team sizes performing cross-functional roles.
- Highly self-motivated and excellent time management skills. Strong interpersonal and communication skills.
TECHNICAL SKILLS
Databases: SQL Server 2000/2005/2008/2012/2014/2016/2017, Oracle 9i/10g, MySQL
ETL, Reporting, Analysis Tools: SSIS(BIDS/SSDT), SQL Server Import/Export Wizard, SSRS (2005/2008/2012 ), Data Zen, Power BI, Tableau SSAS, Tabular
Operating Systems: DOS, Windows 2000/XP, Windows 7, 8.1, 10, LINUX
Development Tools: T-SQL, PL/SQL, C#, Core Java, HTML, CSS, PHP, JSP
Softwares: MS-Office, Adobe Dreamweaver, Rational Rose, Erwin data modeler, Red Gate
PROFESSIONAL EXPERIENCE
Confidential, FL
SQL Server/BI Developer
Responsibilities:
- Assisted Business Analyst in documenting business requirements, technical specifications and implementation of various ETL standards in the mappings.
- Analyzed existing data warehouse and developed plans and implemented new EDW data warehouse with type-2 data.
- Conducted time trending reporting by analyzing data and helped customers make strategic business decisions.
- Recommended new BI tools and technologies required to gain insights on data helped achieving cost saving.
- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
- Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
- Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
- Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
- Created SSIS packages to extract data to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
- Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling And Logging.
- Enhancing and deploying the SSIS Packages from development server to production server.
- Debugging SSIS packages, Performance tuning on slowly running SSIS Packages.
- Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.
- Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
- Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, and line better business analysis.
- Define, design, and develop interactive dashboards and other automated reporting in Tableau / Power BI, SAS, and Business Objects.
Environment: MS SQL Server Management Studio 2016/2012 R2/2012/2014, SSDT, BIDS, SSIS, SSAS, SSRS, Visual Studio 2019, Power BI.
Confidential, Miami, FL
MS SQL Server/ BI Developer
Responsibilities:
- Collected business requirements from users and translated them as technical specs and design docs for development.
- Created complex Stored Procedures, Triggers, Views, SQL joins, CTE’s and other T-SQL code to implement business rules.
- Involved in implementation of join concepts and replaced sub queries which helped in improving the performance on the servers.
- Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
- Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
- Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
- Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
- Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
- Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
- Deployed different SSIS packages on test and production servers.
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
- Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
- Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008R2.
- Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
- Worked with various SSIS Data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc.
- Used various Control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
Environment: Power BI, SQL Server 2016, SSMS, SSIS, SSRS, SSAS, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira
Confidential, Norfolk, VA
MS SQL Server/ BI Developer
Responsibilities:
- Actively involved in interacting with front end users, project lead, business analyst to gather user requirements and online system specifications.
- Documented the user requirements based on functional specifications.
- Designed Physical data models using Erwin.
- Created database schema and number of database objects like tables, views, stored procedures, user defined functions using SQL Server management studio.
- Involved in writing complex SQL scripts which includes transact statements, database object validation, and exception handling to facilitate functionality in different modules.
- Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.
- Maintained the table performance by following the tuning tips like normalization, creating clustered and non-clustered indexes and collect statistics.
- Upgraded existing packages developed using SSIS 2008R2 to SSIS 2012 packages.
- Transformed the complex business logic and calculations into coding.
- Created ETL packages using heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files, JSON, Sales Force etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
- Used different transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
- Implement ETL and data movement solutions using Azure Data Factory, SSIS.
- Design Setup maintain Administrator the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, Azure SQL Data warehouse
- Created SSIS packages following best practices and standards accordingly.
- Worked on creating a Tabular system from an existing OLAP Multi-Dimensional model.
- Created the dimensional model so that self-servicing BI options can be provided to Business users.
- Generated various reports with drilldowns, drill through, calculated members and dropdowns from the cubes by connecting to analysis server and SQL Server from SSRS.
- Used various report items like tables, lists, matrix, sub report and charts to develop the reports in SSRS and upload into report manager.
- Created POC dashboards for understanding Data Zen vs. Power BIVs Native SSRS.
- Created subscription of reports in different formats like PDF, excel, word etc. to be generated automatically on weekly or monthly basis using SSRS.
- Worked on requirement analysis, coding and testing various modules in a software development life cycle.
Environment: SQL Server 2016/2014/2012/2008, SSMS, SSIS, SSAS, SSRS, ERWIN, MS-Excel, Windows XP, Visual Studio, Git, Source Tree, Red Gate
Confidential, Pleasanton, CA
MS SQL Server/ Business Intelligence (SSIS, SSRS, SSAS) Developer
Responsibilities:
- Involved in gathering the requirements from the benefit coders team.
- Documented the requirements based on functional specifications.
- Implemented Complex Business Logic in T-SQL as per the client requirement.
- Involved into updating procedures, functions, triggers, and packages based on the change request.
- Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
- Greatly involved in performance tuning to optimize SQL queries using query analyzer.
- Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.
- Generated multiple enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included
- Various reporting features such as group by, drill down, drill-through, sub-reports, navigation reports (Hyperlink) etc.
- Created different parameterized reports (SSRS 2005/2008) which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
- Experience with Azure transformation projects and Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory (ADF), SSIS.
- Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
- Implement ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS.
- Created all types of report types like tables, matrix, charts, sub-reports etc.
- Created SSIS packages to move data from source systems to SQL Server destination.
- Worked on dimensional data modeling using star and snowflake schemas for fact and dimension tables.
- Developed OLAP cubes by using SQL Server Analysis Services (SSAS), worked on performance tuning of SSAS cubes.
- Involved in development & deployment of SSAS cubes and monitored full, incremental loads and support any issues.
Environment: MS SQL Server 2008 R2, BIDS, MS Access, Erwin, Red Gate, Source Safe
Confidential
MS SQL Server Developer
Responsibilities:
- Performed review of the business process, involved in requirements analysis, system design documents, flows, test plan preparations and development of business process and work flow charts.
- Performed database design and implementation using SQL Server and data modeling tools.
- Involved in various data transformation and cleaning techniques like cast, convert, trim etc.
- Developed database objects like tables, views, indexes, stored procedures, common table expressions.
- Involved in writing queries with join conditions, correlated sub queries, and nested queries for the business application development.
- Created custom T-SQL procedures to read data from flat files to dump to SQL Server database using SQL Server import and export data wizard.
- Developed procedures and database triggers for the validation of input data and to implement business rules.
- Developed user defined functions based on the requirements and also used various built-in functions.
- Handled errors using exception handling (try, catch) extensively for the ease of debugging and displaying the error messages in the application.
- Involved in adding, validating, dropping the XML schema to the database.
- Developed backup restore scripts for SQL Server as needed.
- Resolved any deadlocks issues with the databases/servers on a real-time basis using transaction and locking strategies.
Environment: MS SQL Server 2008R2, BIDS, TFS.