Sr. Sql Bi/etl/data Warehouse Developer Resume
Livermore, CA
SUMMARY
- Over 7 years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
- Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2005/2008/2012/2014/2016.
- Expertise in writing T - SQL queries, dynamic queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User-Defined Functions, Views, Constraints (Primary key, Foreign key, Unique key, check key etc.) and cursors.
- Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
- Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment. Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
- Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS. Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
- Proficient in OLTP, OLAP and Data Warehousing Design concepts. Good experience building Star Schema and Snowflake Schema based on the business requirements.
- Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
- Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
- Experienced in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
- Experience in validating the results in Tableau by running SQL queries in MS SQL developer.
- Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS). Expertise in creating Cell Level Security in cubes using SSAS. Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS. Expertise in creating Dashboard Reports to support end users using SSAS.
- Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and end users.
- Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
- Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler.
- Expert in implementing and planning Server Security and autantication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL.
- Experience in creating XML files and XSD schema files. Excellent noledge on Object Oriented Analysis and Design concepts.
- Good team player, strong interpersonal and communication skills combined wif self-motivation, initiative and the ability to think outside the box.
TECHNICAL SKILLS
Databases: SQL Server 2016/2014/2012/2008/2005 , MS Access, Teradata, Oracle, DB2, AS400 and MySQL
Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, DBCC.
BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica 8, ProClarity OLAP tools, Performance Point Server 2007, Crystal Reports 9.0/XI
Languages: SQL, T-SQL, PL/SQL, Dynamic SQL, .NET, HTML, C, C++, C#, UNIX, MDX.
Web Technologies: XML, HTML, XSL, JavaScript, IIS
Database Design Tools: Erwin 5.1, MS Visio 2007/2003, Rational Rose(UML)
Tools: & Technologies PerformancePoint Server 2007(ProClarity), Enterprise Manager, SSMS, Database Tuning Advisor, DTS, Analysis Manager, BCP, Visual Studio, Microsoft Office SharePoint Server 2007.
Operating Systems: Windows 7,10. Windows 2000/NT 4.0, Windows 2003 Advanced Server/Windows 95/98/200/XP-pro, UNIX
PROFESSIONAL EXPERIENCE
Confidential, Livermore, CA
Sr. SQL BI/ETL/Data warehouse Developer
Responsibilities:
- Extract, Transform and Load the source data into the respective target tables to build the required data marts.
- Install and configure the servers and clients using SQL Server 2014/2016. Create and upgrade SQL databases.
- Get some Understanding regarding the user requirements and Data Model defined and developed by the business analysts and data architects.
- Created functional specification document and technical specification document. Constructed OLTP and OLAP Databases.
- Performed DBA tasks like Backup, restore of tables and Stored Procedures and Refreshing Database on weekly basis.
- Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
- Involved in loading data from Teradata to HDFS. Administering and Monitoring TFS Servers.
- Maintaining the build environment, the source code control system and managing build packages using TFS.
- Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
- Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
- Designed SSAS Tabularmodel for summary reports.Created Snapshots, Subscriptions and Transactions using Replication services.
- Created ETL process using SSIS to transfer data from heterogeneous data sources.
- Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
- Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
- Designed and Developed Integrations to Microsoft Dynamics (GP) from Audit systems. Responsible for gathering business requirements to create business user reports.
- Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008/2012 wif .NET applications.
- Create reports in Power BI preview portal utilizing the SSAS Tabular. Published Power BI Desktop reports created in Report view to the Power BI service.
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Created roles using SSAS to restrict cube properties. Writing the DAX statements for SSAS Cube.
- Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the SSAS Tabular Models.
- Developed Report Models for building Ad hoc reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports.
- Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports.
- Responsible for scheduling the subscription reports wif the subscription report wizard. Played a Content Manager role on report server.
- Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
- Involved in publishing of various kinds of live, interactive data visualizations dashboards, reports and workbooks from TableauDesktop.
- Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
- Expertise in Client-Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADand SQL*LOADER
Environment: SQL Server 2016/2014 R2 Enterprise Edition, Microsoft Dynamic GP, Micro Strategy Desktop 10/9, SSRS, SSIS, SSAS, Redgate, .NET Framework, C#, ADO.NET, Windows Advance Server, XML, MS Excel, Access and Team Foundation Server (TFS).
Confidential, Richardson, TX
SQL/SSIS/ETL/SSRS/SSAS/Data Warehouse Developer
Responsibilities:
- Built Data marts (Fact and Dimension tables) from the warehouse tables. Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
- Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
- Understand user requirements and Data Model defined and developed by the business analysts and data architects.
- Wrote hundreds of stored procedures and function on numerous SQL server to use in SSIS package and Power BI. Created SSIS Packages per the requirements.
- Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
- Used comprehensive noledge of T-SQL code as well as SSIS, SSRS, visualization tools i.e. Power Bi and Tableau and predictive modelling to build models for tangible operational excellence of the commercial aviation business.
- Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
- Worked wif Flat Files (Pipe Delimited) sources and implemented error handling routines.
- Worked wif Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections.
- Created OLAP Dimensions, Measures and Cubes using SSAS.
- Implemented and enhanced existing reports like Group by, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
- Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
- Extensive Knowledge in Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model.
- Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
- Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
- Wrote custom functions to produce the derived fields using the source table fields for each record from source
- Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process.
- Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
- Created Power BI Visualizations and Dashboards as per the requirements.
- Worked wif Date/time manipulations in SQL Server built in functionalities as well as Data Integrator Date functions.
- Implemented history preserving using Table comparison, History Preserving and Key generation transformations in warehouse /dimension workflows.
- As a part of optimization: Used MAP operations to route UPDATE and INSERT records in warehouse workflows
- Ran stats on all tables. Right choice of transformations & right design in data flows. Implemented incremental load process.
- Handled the cross schema (Warehouse, Data mart) challenges between the different environments (Development, QA and Production) by granting permissions on tables using Database functions in scripts before running work flows.
- Prepared ETL design documents for implemented work flows and loaded the documents in the project share point site.
Environment: SQL Server 2012/2014 Enterprise Edition, Enterprise Manager, MicroStrategy Desktop 10/9, TFS, ERWIN, UML, MS Project, .NET, C#, ASP.NET, SSIS, SSRS, SSAS, Team Foundation Server (TFS), SQL Server Agent.
Confidential, Midland, NC
SQL/ETL/SSIS/SSRS/SSAS Developer
Responsibilities:
- Worked as a developer in creating complex Stored Procedures, Triggers, Functions.
- Developed Triggers to raise events on executing insert, delete and update stored procedures.
- Optimized existing stored procedures to achieve improved performance.
- Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
- Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio.
- Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
- Developed XML tags to structure data and improve the data migration process.
- Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 9i/10g.
- Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
- Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
- Worked on SSIS performance tuning using counters, Error handling, Event handling, re-running of failed SSIS packages using Checkpoints.
- Worked wif Transactional and Snap-shot Fact-Tables.
- Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
- Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
- Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server Analysis Services (SSAS).
- Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance Monitor and tuning SQL Server performance.
Environment: SQL Server 2008/2012, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), VB, MS Access, Visual Studio, T-SQL, Windows XP.
Confidential
SQL/Data Warehouse Developer
Responsibilities:
- Installed and Configured SQL Server 2005 Environment.
- Migration of databases from MS SQL Server 2000 to MS SQL Server 2005.
- Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
- Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
- Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Linked Servers.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
- Involved in analysis and design of the system specification and gathering requirements and prepared the document for proposed system.
- Experience in building star schema and snowflake schema depending on the business data requirement.
- Monitored performance and optimized SQL queries for maximum efficiency.
- Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS.
- Created UNIX Shell scripts for automating the execution process.
- Worked in production environment wif supporting and trouble-shooting production processes.
- Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
Environment: MS SQL Server 2005, T-SQL, Data Transformation Services (DTS), MS Excel, HTML, CSS, VB, Microsoft Visual Source Safe, SQL Server Management Studio (SSMS), SQL Profiler.