Senior Sql/bi Developer Resume
Denver, ColoradO
PROFESSIONAL SUMMARY:
- Over 6+ years of IT Experience in in analyzing, designing, and developing Client/Server,Data Warehousing/ Data Modeling /Business Intelligence (BI)Stackdatabase applications using MS SQL Server 2016/14/12/08/05.Worked extensively on ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions (SSRS), SQL Server Analytical Services (SSAS), POWERBI Desktop and Excel Reporting
- Experience in RDBMS & Data Warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse
- Strong understanding on Normalization/Data modeling and Azure.
- Good understanding of (SDLC) software development life cycle process methodologies and principles like agile and scrum
- Experience in installing and configuring SQL Server 2014/2012/2008R2/ 2008/2005/ 2000 SQL Server Versions
- Experience in data warehousing dimensional modeling to define dimensions and fact tables using star schema and snowflake schema design based on the requirements
- Experience with SQL server and in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Data Dictionaries and Integrity
- Expertise in writing TSQL queries using joins, sub queries and cursors in SQL Server 2005, 2008, 2012 and 2014
- Experience in analyzing, designing, tuning and developing business intelligence database applications using MS SQL Server 2005/2008/2012 SSIS, Reporting and Analysis services
- Worked on Azure data factory, Data lake Analytics, Data Lake store, Azure sql Database, Azure sql Data
- Warehouse, Azure storage account (Blob Storage), Azure Automation and worked on u - sql for delta loads.
- Experience in High Level Design of ETL - DTS Packages & SSIS Packages-for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data)
- Worked on SSIS Transformations such as Union, Union All, Data Conversions, Merge, Conditional split, Bulk Insert, Derived Columns, Control Flow using for loop Containers and Fuzzy Lookups etc
- Hands on experience in created ADF (Azure Data Factory) pipelines for migrating the on premises data from Netezza to Azure sql data warehouse.
- Developed power shell scripts to deploy datasets, liked services and pipelines in different environments and created a power shell run book for Azure automation account.
- Experience in creating XML data files using SSIS Script task (VB.NET.C#.NET).
- Expertise in creating effective Data Modeling and creating Relationships in Excel Data Modeling and PowerBI Modeling and worked with PowerBI reports, Excel Reports
- Proficiency in gathering business requirements through interviews, customer facing sessions, prototyping and observations
- Expert in generating Drill down/ Drillreports using SQL Server Reporting Services (SSRS) in BIDS
- Created complex dashboard using multiple data sources (like Oracle, SQL and Excel) and Custom Hierarchies to meet the Business requirements in Tableau
- Proficient in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance
- Worked with Team Foundation Server(TFS), perforce as the source for Version control and Project/issue management
- Working Knowledge in SQL Server Analysis Services(SSAS).Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill through Dashboards using Warehouses and OLTP Connections
- Extensive experience in Data Extraction and Transforming and Loading(ETL)usingDTS packageand by pulling large volumes of data (VLDB) from various data sourcesin MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008/2005 with .NET, Import/Export data,Bulk insertandBCP
- Expertisein developing reporting applications usingCognos Business Intelligence components like Report Studio,DMRFramework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
- Hands on experience in understanding to database design and their relational integrity, along with Constraints, OLAP, OLTP Cubes and Normalizations
- Expertise in integration of data from diverse data sources like Oracle, Excel, MS Access and DB2 to MS SQL Server by using Import Export Wizard, DTS and SSIS
- Extensively worked on developing and debugging Information mappings, sessions, and workflows
TECHNICAL SKILLS:
BI & DW Tools: SSIS, SSAS, SSRS, Data tools, PowerBI, PowerShell, Azure Data Factory, Azure Data Lake Store, Azure Data Lake Analytics, crystal reports.
Database Utilities: Enterprise Manager, SQL Server Management Studio, Netezza, BI Development studio, Visual Studio, Configuration Manager, SQL Server Profiler, SQL Query analyzer, SQL Server Agent
ETLTools: Data Transformation Services (DTS), SSIS, Import/export wizard, Bulk Insert, BCP, Data Warehousing.
BI Tools: SSIS, SSRS, SSAS, Crystal ReportsXI/X/9/8, Report Designer, Business Intelligence Development Studio(BIDS),Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, CognosConnection)
RDBMS: MS SQL Server2016/2014/2012/2008/2005,MYSQL,MS ACCESS, Oracle 11g/10/9i,DB2
Programming: SQL, T-SQL, Power BI, Visual Basic, Visual C++, MY-SQL, java script. Classic ASP, Asp.net, .Net frame work.
ERP: MS Dynamics Axapta 2009 - Financials
Web Technologies: Html, CSS
Operating System: Windows 98/XP/Vista/7/8, UNIX, Linux, Mac OSX
Data Modelling tool: Visual Studio, Adobe Photoshop, MS Office Suite, MS Visio
PROFESSIONAL EXPERIENCE:
Senior SQL/BI Developer
Confidential, Denver, Colorado
Responsibilities:
- Designed and implemented the Logical and Physical model of the database using Erwin.
- Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure and Constraint by SQL Server.
- Developed and optimized data structures, Stored Procedures, Dynamic Management views, DDL Triggers and User-Define Functions. Tuned, Monitored and maintained SQLServer Jobs.
- Implemented database management techniques that include backup/restore, import/export and generated scripts.
- Involved in Query Optimization, Performance Tuning and Rebuilding the Indexes at regular intervals for better performance.
- Worked with SQLServer Analysis Services (SSAS).
- Multidimensional Expressions (MDX) is to make accessing data from multiple dimensions.
- Pulling data on daily basis from OLTP database to OLAP or staging database using the SSIS packages.
- Used link servers in cases where data is to be pulled form a different database like oracle.
- Worked in OLAP environment where star schema is implemented, creating and identifying fact, dimension tables and establishing proper relations between them.
- Created special dimension tables like time dimensional tables.
- Created cubes and dimensions and measures and calculated measures per the business requirements.
- Export or Import data from other data sources like flat files using Import/Export through SSIS 2014.
- Created SSIS package to load data from Flat File to Data warehouse using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation and Slowly Changing Dimension.
- Developed reports and deployed them on server using SQLServer Reporting Services (SSRS).
- Generated Reports using Global Variables, Expressions and Functions.
- Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through reports and Sub reports using SSRS 2014.
Environment: Windows Sever 2014, MSSQLServer 2012/2014, SSIS 2012/2014, SSRS 2012/2014, T-SQL,SQLServer Profiler, Team Foundation Server and Erwin.
SQL Server BI Developer
Confidential, Montpelier, Vermont
Responsibilities:
- Involved in all phases of SDLC, and gathered business requirements from business people.
- Involved in Waterfall model of SDLC and gathered business requirements from business people.
- Design/develop database using SQLSERVER 2005/2008.
- Created SSIS Packages for migration of data between MS SQLServer database and other databases like MS Access,MS Excel and Flat Files and Oracle databases.
- Designed and Developed Complex SSIS packages for auditing Interfaces using SQLSERVER 2005 Integration Services.
- Developed SSIS Packages using ADO.NET, Oracle Connection manager, OLEDB, file system and Excel Connection manager.
- Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
- Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS).
- Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
- Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
- Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
- Deployed SSRS Reports in SharePoint Environment.
- Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQLjoins and statements for applications.
Environment: MS SQLServer Management Studio 2005/2008, Query Analyzer, SQL Profiler, MS SQLServer Integration Services (SSIS), MS SQLServer Reporting Services (SSRS), SharePoint Workspace, Windows XP.
SISS/SSRS Developer
Confidential, Jacksonville, Florida
Responsibilities:
- Gathered client requirements, specifications and performed analysis, design, development, deployment and user training. Create and maintain clearly written technical, user and system documentation.
- Worked on Data Extraction, Transforming and Loading(ETL) using various tools such as SSIS and Bulk Insert.
- Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.
- Experience in Creating and updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.Effectively loaded data into relational database using ETL tool.
- Migration of SSRS reports from SQL 2012 to SQL 2014.Tested different types of reports before moving it to the production.
- Created T-SQL (DDL and DML) scripts for RDBMS applications.
- Created and developed stored procedures, triggers, functions to handle complex business rules, history data and audit analysis. Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS,SSAS.
- Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
- Microsoft SharePoint 2013 and Office 365 with SharePoint online.
- Designed and developed complex drill through master detail and burst reports using Cognos 10.1.1 functionality and Spotfire.
- Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau and Spotfire.
- Strong experience in Microsoft SQL Server concept, T-SQL programming including: query optimization, stored procedure, user- defined functions, etc. required.
- The main duty in angular Js will include creating modules and components and coupling them together into a functional app. Assist data modelers in designing of dimensional model for Star schema.
- Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. UsedPL/SQLTables and Records in payment generation process. Written Test Plans and Involved in unit testing.
- Designed and developed confirmation letters, Invoice reports, MTM & various other reports usingPowerBuilder10 data windows. Interacted with business users on day-to-day basis to resolve their application issues and provided production support
- Create Views, Constraints and Triggers to implement business rules.
- Created Tables, Macros in Teradata SQL Assistant 7.1 and generating the sample reports using Excel 2007.
Environment: SQL Server Business Intelligence Development Studio, T-SQL, Microsoft Visual StudioSQL Server Management Studio, SQL Server SSRS/SSIS, ETL, Tableau Dashboards, XML, MS Excel.
BI DEVELOPER
Confidential
Responsibilities:
- Analyze client requirements and translate them into technical requirements.
- Created stored Procedures, T-SQL, Triggers, Views and Functions for the database Application.
- Included Report Design and Coding for Standard Tabular type reports, Cross-tab, Matrix, Adhoc reports, Parameterized reports, Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
- Implement database retrieve module (callable statement or T-SQL stored procedure) to retrieve user initiating documents, waivers and statement of intent.
- Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
- Worked with different methods of logging in SSIS.
- Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS.
- Created report snapshots to improve the performance of SSRS. Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
- Generate various ad hoc reports using MS Reporting Services. Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
- Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa.
- Proven ability in generating Parameterized reports and Linked reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
- Defined the report layout and identified Datasets for the report generation.
- Extensively used Report Builder and Report Manager in SSRS.
Environment: Windows, SQL Server 2005/2008/2012, ETL Tools, T-SQL, SQL Profiler, SSRS, Visual Source Safe, SQL Reporting Services (SSRS).
SQL Engineer/ETL Developer
Confidential
Responsibilities:
- Creating and managing Schema Objects such as Tables, Views, Indexes and Constraints.
- Implemented different joins to retrieve data from multiple tables with Referential Integrity.
- Reduced the loading /run time of ETL jobs by 5 hours of an application by changing the loading strategy to incremental. This resulted in monetary savings and load reduction ETL server and Database server.
- Rectified the design flaws in allETL jobs w.r.t. notification regarding current status of theETL job. The existing system used to send incorrect status of the ETL jobs, which increased the manual effort
- Migrated ETL jobs from IBM Data stage 8.5 to IBM Data stage 11.3
- Merged multiple ETL jobs which were repetitive into a single job. This reduced the overall load time of the application
- Developed an ETLapplication to load data into database which would help suppliers track their shipments. The project was to convert existing Mainframe jobs into ETL jobs
- While developing theETL code, I Identified redundancy in data across different modules and rectified it by merging such tables. Documented the entire process in theETLhandbook
- Created Triggers with error messages so as to ensure consistency during data entry.
- Assisting Database Administration Department with a few tasks such as maintaining a record of the Database Backup files, checking Agent Jobs and Maintenance plans.
Environment: SQLServer 2000, T-SQL, Query Analyzer, Enterprise Manager, ETL Tools, SQLProfiler, and MS Access.
