Sr. Bi Developer/sql Developer Resume
Charlotte North, CarolinA
PROFESSIONAL SUMMARY:
- Over 6years of Professional experience in Information Technology and over 6 years in database design, development of MS SQL SERVER 2000/2005/2008/2008 R2/2014 with Business Intelligence tools SQL MS Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS).
- Strong working knowledge of Microsoft SQL Server with skills in query writing and performance tuning.
- Strong working knowledge of Data Visualization in SSRS.
- Execute data mining techniques for advanced analysis of data and report generation.
- Experience in Installing, Upgrading, managing, configuring, migrating and troubleshooting MS SQL Server
- Worked extensively on TSQL Code, including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.
- SQL performance tuning by modifying SQL or adding/changing indexes.
- Conducted research to collect and assemble data for databases .
- Hands on experience in publishing and sharing workbooks, data sources with user filter to tableau server, setting schedules.
- Experience in using Python and its many useful libraries including Pandas used for data reshaping, aggregating, joining disparate sources, etc. for ETL.
- Involved in different kinds of Data Model Instance and they are Conceptual Design, Logical Design and Physical Design.
- Creating Exception Report after comparing Data source and destination.
- Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
- Experience with large - scale relational databases
- Experience in writing SQL Queries, TSQL, Stored Procedures, Views, Functions, Indexes, and database Triggers.
- Experience in designing and developing SSIS packages for loading data from Oracle, text files, Excel, Flat files to SQL Server database.
- Good understanding of developing Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.
- Expert in creating packages for migration of the data from one source to different destination using SSIS and Handling error with Event handler using SSIS
- Experience in the design, development and implementation of RDBMS using MS SQL and using oracle 8i/9i as well.
TECHNICAL SKILLS:
Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 7, Windows 8, Windows 10
Databases: SQL Server 2014/2012/ 2008 R 2/2008/2005/2000 , MS Access, ORACLE 10g/11g, MySQL
BI Tools: SSAS, SSIS, SSRS, POWER BI, Cristal Report, Tableau
Languages: SQL, T-SQL, PL/SQL,C#, HTML, XML, Python, C, C++
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, North Carolina
Sr. BI Developer/SQL Developer
Responsibilities:
- Working extensively in Power BI report creating tabular cube, creating data model for Power BI Report, Validating data quality of the report.
- Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
- Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
- Review reporting outputs for transparency, consistency, and accuracy.
- Perform Administration of SQL Server database engine, SQL Server Integration Services, and SQL Server Reporting Services.
- Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
- Created python data pipelines to load data dynamically from a data folder to MS SQL server using multi threading process which reduced the data loading time.
- Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
- Designed python task in SSIS with advanced data manipulation using pandas data frame.
- Involved in reviewing business requirements and analyzing data sources form Excel for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
- Developed Stored Procedures for the Datasets to build the reports for the client requirements.
- Created SQL Joins, sub-queries and other SQL code to implement business rules.
- Performance tuning, and optimization of procedures and queries.
- Worked with the use of Data Modeling Standards for all projects requiring a standard means of defining and analyzing data within an organization, to manage data as a resource, for the integration of information systems, for designing Databases/Data Warehouses.
- Designed and developed SSIS Packages (.dtxsfiles) to import and export data from MS Excel, SQL Server, Oracle and Flat files.
- SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
- Created Schedules and Extracted the data into Tableau Data Engine.
- Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models.
- Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
- Developed packages in SSIS with error handling.
- Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services.
- Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
- Implemented cell level security in cubes to restrict users of one region viewing data of another region using SSAS.
- Used Power BI Power Pivot to develop data analysis prototype and used Power View and PowerMap to visualize reports.
- Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.
- Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
- Experienced in participating meetings with business users to gather the requirements.
- Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
- Involved in generating Forecasting/Predictive models using R and Python.
- Worked with development teams in the design of physical databases and in modification.
- Involved in the process of Data Modeling which includes professional data modelers working closely with business stakeholders, as well as potential users of the information system.
- Participating to create Star Schema, Snow Flake Schema using the concept of data modeling with Team.
- Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table and Lookup Table.
Environment: MS SQL Server 2014/2016, MS SQL Integration Services 2014/2016, SSAS Cubes, MS Access, Crystal Reports, SharePoint 2013, MS Excel Power Pivot, Spotfire, SQL Server Agent, Power BI, Visual Studio 2015, PL-SQL, T-SQL, Oracle Toad 10.5
Confidential, FL
SQL Server BI Developer
Responsibilities:
- Created User Defined Functions, Views, stored procedures as per business requirements
- Optimized the performance of queries with simplifying queries like removing unnecessary columns, eliminated redundant and inconsistence data
- Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the other using FTP tasks
- With the help of visualizations in Power BI, created various visualization like Pie charts, Bar graphs, Tree maps etc., that will helpful easily to understand the data.
- Performed Normalization and De-Normalization techniques from both OLTP and OLAP system in creating Database objects
- Used control flow tasks like For Loop Container, For each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks
- Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, Lookup Table.
- Have worked on Power BI power pivot to develop data analysis prototypes.
- Proficient in creating power BI Dashboards and Visualizations.
- Worked extensively on creating Relationships, Measures, Calculated columns, Tooltips in the powerBI.
- Worked extensively on DAX and KPIs in the power BI.
- Experienced in Power BI Desktop reports created in reportview to the Power BI Service.
- Efficient in using Power View and Power Map to visualize reports.
- Experience in using Microsoft power BI power Query to Extract data from external sources and to modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to Database.
- Involved in different kinds of Data Model Instance and they are Conceptual Design, Logical Design and Physical Design.
- Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
- Worked on Transforming and Loading data using SSIS Import/Export wizard
- Developed Tabular Reports, Sub-Reports, Matrix Reports, Drill down Reports and charts using SSRS
- Performed sorting, formatting and grouping to custom reports in SSRS and also published reports to the report server virtual directory
- Created spark applications using python to perform ETL.
- Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers
- Hands on experience with developing reports using SSRS
- Interacted with Developers in troubleshooting application and Report Developing
- Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
- Tuned several slow running queries in Production. Implemented Indexes to achieve time performance
Environment: SQL Server 2008/2008 R2/2012, Windows 2003/XP, Spotfire, Enterprise Manager, SSIS, SSRS, SSMS, SQL Profiler, T-SQL
Confidential, Lincoln, RI
SQL Server Developer
Responsibilities:
- Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
- Involved with Transact SQL (T-SQL) Coding, writing queries, functions & triggers.
- Created complex SQL queries using table joins (inner and outer), temporary tables and table variables.
- Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).
- Experience in deploying and scheduling the reports based on quarter, month, and year reports.
- Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).
- Developed, monitored and deployed SSIS packages.
- Worked on Excels to upload the data from excels to database.
- Responsible for implementation of data viewers, error configurations for error handling of the packages.
- Optimized long running Stored Procedures and Queries for effective data retrieval.
- Optimized queries by looking at Execution Plan for better tuning of the database.
- Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services (SSIS).
- Handlers in SSIS packages
- Responsible for creating user groups and assigning permissions.
- Created DTS packages to transfer objects from development server to production.
- Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
- Setup and maintained Linked Servers.
Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.
Confidential, Minneapolis, MN
SQL Server Developer
Responsibilities:
- Created and maintained store procedure for SSIS package and Report service to access data in the SQL Server database using T-SQL.
- Created ad-hoc report using MS Excel and Power Pivot (plug-in).
- Developed Microsoft SQL Server object (stored procedures, views, scalar-valued and table-valued functions) by using T-SQL.
- Configured and created SSIS solutions for ETL and Business Intelligence process for data integration and migration services and managed event handlers, package configurations, logging, system and user-defined variables for SSIS Packages.
- Created views based on report requirements.