We provide IT Staff Augmentation Services!

Sql Bi /data Warehouse Developer Resume

Woonsocket, Ri

SUMMARY:

  • Strong experience in logical and physical database design and development, Normalization and data modeling.
  • Practice on Data Modeling (ERD) experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow - flake modeling using tools like Erwin, EMBARCADERO ERStudio .
  • Creating and managing schema objects such as tables, views, indexes, Triggers, Stored Procedures and referential integrity depending on user requirements and converting them into technical specifications.
  • Subscribe and connecting to SQL AZURE Data Bases and wring the scripts to Create Data Base Objects Within the SQL AZURE.
  • Writing T-SQL Script for creation of data base objects Stored Procedures, User Defined Functions, Triggers, Views, Sub Queries, Stored Procedures in T-SQL,/MySQL PL/SQL/ Sybase (ASE)/DB2
  • Writing Sub Queries to avoid complexity to join Data sets and Common table Expressions (CTE) for Temporary result set .
  • Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
  • Worked on SQL Server 2014 migration from SQL Server 2012/2008R2 / 2008, Master in scripting for Homogenous and Heterogeneous sources Migration.
  • Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP and OLAP and Data Modeling.
  • Designed, created, and maintained DB2 database objects. Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
  • Expert in Data Extraction, Transformation, and Loading (ETL) using Talend, Oracle Data Integrator (ODI) or similar tools such as BODI, Informatica, Data Stage, SSIS, or related technologies.
  • Migrating data from various sources such as Excel, Oracle, MS Access, OLE DB, DB2, flat files to SQL server. To different destinations using SSIS.
  • Great Expertise in creating and managing Event, Handlers, Package Configurations, Logging and User-defined Variables for SSIS Packages.
  • Utilize existing enterprise BI tool set (e.g., SQL Server Reporting Services, SS Analysis Services, SharePoint, and Crystal reports and Power BI, Tableau) and web services that provide standard analytic computations that can be leveraged in multiple BI solutions.
  • Experience in generating and handling parameterized reports Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.
  • Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
  • Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
  • Connecting to different data sources to blend and modeling Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server 7.0 and 8.2,9.0 for reporting and analyzing of data.
  • Experienced with all phases of Data Warehouse development life cycle, from gathering requirements, testing, Functional Specifications, Technical Specs, Design documents, Implementation and support
  • Expert knowledge in developing, Multidimensional databases using SSAS. Experience in OLAP cubes using SSAS for data mining with Hierarchies, Star and Snow Flake Schemas of Data Marts .
  • Extensive experience in Data warehousing like identifying the Facts and Dimensions, creating Star and Snowflake schemas.
  • Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies, Perspectives, Partitions and Designed Aggregations in cubes using SSAS.
  • Advanced working knowledge of report development, data models, and administration processes in Business Intelligence tools such as IBM Cognos, Oracle OBIEE, SAS BPC, etc.
  • Knowledge on Cognos version 11 (COGNOS Analytics, Dashboard) and DQM
  • Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database
  • Good Understanding of Kimball and Bill Inmon warehouse modeling and usage of modeling tools such as Embarcadero, Erwin and DB Artisan.
  • Well Experienced in SAP Business Object for report development.
  • Extensive experience in writing MDX Scripting and MDX, DAX Queries.
  • SSAS and building data cubes. For the ETL process worked on 10 million records at a time.
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI, Qlick view .
  • Interact With front end applications by Web and Client/Server Application development using Microsoft .NET Framework with C# and VB.NET, ASP.NET, C#, progr amming languages
  • Working with Web Technologies Java, AJAX, HTML, PHP, JavaScript, Rest API, JSON, Ruby, and Python. Through visual studio as programmer.
  • Ability to configure SQL server to XML and HTML used to extract and store. Expert Excel user including VBA programming.
  • Strong expertise in writing complex Access, Excel Macros with Excel VBA for different Business Environments.
  • Writing Unix/Linux/Perl, Python Scripting.
  • Customizing Microsoft’s Team Foundation Server according to the company’s requirements. And generating multiple TFS reports, Upgrading TFS 2010 to TFS 2012.
  • Work with customers to ensure user acceptance testing and complete delivery of reporting/analysis solution for DSRIP reporting.
  • Provided Technical/ Production Support, and on-going maintenance for Crystal Reports.
  • High interest and earnest fondness for Quantitative Finance, Trading and Risk Management.
  • Experience in working with software methodologies like Agile, SCRUM, and Waterfall
  • Good Experience on MS Dynamics CRM.
  • Used to work on Microsoft Analytics Platform System ( APS ), for data warehousing and Big Data analytics and data integration, high-speed query processing, to store large amount of data and simple maintenance for end-to-end business intelligence solutions.
  • Documentation of logic used in Tableau
  • Ability to communicate to a variety of audiences in both verbal and written form.
  • Exposure to AWS platform, Red shift Data warehouse, Alteryx is nice to have
  • Reports development utilizing Information Builders' Web Focus version 8.1and App Studio
  • Knowledge on Exposure to Big data and related technologies like SQOOP, SyncSor.

TECHNICAL SKILLS:

Platforms: Windows XP/2003, 2008 Server/Vista/ Windows 7, Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER, Net Framework 1.0/2.0/3.5/4.0, CSOM, SSOM, REST API, MS Excel APIs, Linux, FTP, REST and JSON.

Languages: T-SQL, SQL, SQL*PL/SQL, MY SQL VB .NET, C#, HTML, MDX/DAX, Java script

RDBMS: Microsoft SQL Server 2005/2008/2012 /2014, 2016 MS Access,DB2, Oracle 11g/10g, Tableau Desktop 7.0, 8.0,9.0

SQL Server Tools: DTS, SSIS, SSAS, SSRS, SSMS, OWB,ODI, Power BI Configuration Manager, Enterprise Manager, Query Analyzer Profiler, Database Tuning Advisor, SAP BO data services 9.0, IBM's Data stage version 9.0.

Other Tools: MS Office Suite, MS Visio, Crystal Reports, MIS Reports, TFS, Share point 2013.

WORK EXPERIENCE:

Confidential, Woonsocket, RI

SQL BI /Data warehouse Developer

Responsibilities:

  • Writing New T-SQL, PL/SQL/ Teradata queries for Table design and creation .
  • Involved in Data Warehouse Design and Development by using star Schema Design Method.
  • Migrated Data from SQL server 2012 to SQL Server 2014.
  • Implemented stored procedures with proper Set Commands and enforced business rules via checks and constraints.
  • Writing T-SQL, PL/SQL/MySQL Joins, correlated and non correlated Sub Queries t o avoid complexity to join Data set s and Common table Expressions (CTE) for Temporary result and Temporary tables and Pivoting tables and functions .
  • Performance tuning to optimize any existing queries to speed up performanc e with modifications in removed unnecessary columns eliminated redundant and inconsistent data by applying Normalization techniques, established joins and created indexes whenever necessary.
  • Review/modify current database design for better performance
  • Implement database management tasks backup and Restore and recovery and disaster recovery and high availability.
  • Used to work wit h troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc .
  • Creating SSIS and OWB, ODI packages and Modify/optimize existing SSIS packages to accomplish ETL Process for Data Ware House Development.
  • Used to work on Microsoft Analytics Platform System ( APS ), for data warehousing.
  • Designed, developed and deployed custom reports to Report Manager in MS SQL Server environment using SSRS 2012 to Create Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2012 Reporting Services (SSRS).
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Connecting to different data sources to blend and modeling of data within the Tableau server 9.0 to create interactive dash boards for reporting and analyzing of data.
  • Good Analytic capabilities in analyzing data, reporting requirements, identify KPIs, insights and trends.
  • Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively
  • Installed On premise data gateway and scheduled daily data refresh in Power BI. Microsoft Power Query years) M query language.
  • Power BI technical skill set and experience as it related to loading data, transforming data, and presenting data (visualization);
  • New QlikView application data modeling and UI development, i.e. building and maintaining QVDs and QVWs
  • Production support and optimization of existing QlikView dashboards.
  • Good Experience on DAX and OLAP, OLTP in Data Ware House Development.
  • Detail-oriented Financial Analyst with hands-on experience in quantitative / statistical analysis, and forecasting budgeting, accounting, and forecasting with Excel VBA.
  • Develop new VBA code (Excel) and Modify/optimize any existing VBA (Macros) code if necessary, Pivot tables.
  • Worked on data preparation, data blending, and the creation of data models / sets using Alteryx
  • Performed designing, building, and testing several complex workflows in Alteryx
  • Working with SharePoint Designer to create work flow intex forms using share point 2013.
  • Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Micro Strategy Desktop.
  • Business Analyst (BA) experience, especially regarding documentation of existing data sources; and The apparent ability to train the users in using and configuring Power BI and Qlick view.
  • Upgraded the Micro Strategy 8.0.1 version on Windows to the 9.0.1 Version on UNIX.
  • Subscribe an d connecting to SQL AZURE Data Bases and writing the scripts Create Data Base Objects Within the SQL AZURE.
  • Interact With front end applications by Web and Client/Server Application development using Microsoft .NET Framework with C# and VB.NET as programming languages.
  • Reports development utilizing Information Builders' Web Focus version 8.1and App Studio
  • Working with Web Technologies Java, AJAX, HTML, PHP, JavaScript, Rest API, JSON, Ruby, and Python. Through visual studio as programmer.
  • Ability to configure SQL server to XML and HTML used to extract and store. Expert Excel user including VBA programming.
  • Working with Linux and UNIX Operating system and shell scripting migration process. Writing Unix/Linux/Perl, Python Scripting.
  • Proven experience working with large teams, in Agile/Scrum models required.

Environment: MS SQL Server 2012/2014, T-SQL, SSIS 2008/2012, SSRS 2012/2014 and MySQL 5.0.22 and 5.1.24 Oracle 11g/10g, Oracle9i/8i Tableau Desktop 9.0

Confidential, New York, NY

SQL BI Developer

Responsibilities:

  • Writing New T-SQL, PL/SQL/ MySQL queries for Table design and creation .
  • Good Experience on MS Dynamics CRM.
  • Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2014/2012 Enterprise Edition.
  • Designed and developed SSIS Packages migrating data from various sources such as MS Excel, Oracle, MS Access, OLE DB, and flat files to different destinations using SSIS/ OWB,ODI for ETL Process to accomplish Data ware house Development in Star and Snow flake Schema Design Method.
  • Designed, developed and deployed custom reports to Report Manager in MS SQL Server environment using SSRS 2012.
  • Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS).
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • . Used ETL to implement the slowly changing Dimensions (SCD) in data warehouse. Expert knowledge in developing multidimensional databases (MDX, DAX) using SSAS. Experience in OLAP cubes using SSAS for data mining with Hierarchies, Star and Snow Flake Schemas of Data Marts .
  • Good Experience on DAX and OLAP, OLTP in Data Ware House Development .
  • Utilize existing enterprise BI tool set (e.g., SQL Server Reporting Services, SS Analysis Services, SharePoint, and Crystal reports and Power BI) and web services that provide standard analytic computations that can be leveraged in multiple BI solutions.
  • Delivered custom and scheduled reports using Crystal Reports, Built and performance tuned back end T-SQL, PL/SQL code.
  • Created effective Dashboards in Power BI, and Service and made the reports user friendly and interactive.
  • Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively
  • Installed On premise data gateway and scheduled daily data refresh in Power BI.
  • Connecting to different data sources to blend and modeling of data within the Tableau server 8.0 to create interactive dash boards for reporting and analyzing of data.
  • Experience in QlikView dashboard development skills - intermediate to advanced understanding of scripting and front-end development
  • Develop new VBA code (Excel) and Modify/optimize any existing VBA code if necessary.
  • Used to work with Team foundation server TFS to open bugs, create tasks and user stories, initiate change requests.
  • Deploy applications and test plans and regression testing, data base testing used to work with TFS Generated and executed VB scripts using Test Complete.
  • Interact With front end applications by Web and Client/Server Application development using Microsoft .NET Framework with C# and VB.NET as programming languages, Restful webapi using c#api.
  • Working with Web Technologies Java, AJAX, HTML, PHP, JavaScript, Rest API, JSON, Ruby, and Python. Through visual studio as programmer.
  • Ability to configure SQL server to XML and HTML used to extract and store. Expert Excel user including VBA programming.
  • Wrote Scripts in UNIX Shell scripting for migration process.
  • Writing Unix/Linux/Perl, Python Scripting.
  • Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Micro Strategy Desktop.
  • Worked on Analytical and Visualization Tool: Tableau, Excel, VB, Alteryx, and Qlikview Data Manipulation: Excel, Alteryx.
  • Upgraded the Micro Strategy 8.0.1 version on Windows to the 9.0.1 Version on UNIX.
  • Subscribe an d connecting to SQL AZURE Data Bases and wring the scripts Create Data Base Objects Within the SQL AZURE.

Environment: MS SQL Server 2008R2/2012/, T-SQL, SSIS 2008/2012, SSRS 2008R2/2012/2014 and MySQL 5.0.22 and 5.1.24 Oracle 11g/10g, Oracle9i/8i Tableau Desktop 7.0, 8.0.

Confidential, Juno Beach, FL

SQL BI Developer

Responsibilities:

  • Build and maintain SQL/PL/SQL/MySQL/Teradata scripts, indexes, and complex queries for data analysis and extraction.
  • Provide database coding to support business applications using T-SQL/PL/SQL/Teradata fine-tuned Stored Procedures and SQL Queries and User Defined Functions for better performance.
  • Worked on Query optimization for scheduled jobs to accomplish Performance tuning.
  • Implemented change data capture to reduce load duration in SSIS and OWB, ODI packages for Migration Process for Development of Data Ware house Design Star Schema Design Method.
  • Generating daily reports for upper management on kinds of products brought to the table by vendors using SSRS.
  • Implemented embedded Tablix and dash boards using SSRS.
  • Responsible for complete reporting cycle (Design, Develop and Deploy).
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • Delivered custom and scheduled reports using Crystal Reports, Built and performance tuned back end T-SQL, PL/SQL/Teradata code.
  • Used to work on Microsoft Analytics Platform System ( APS ), for data warehousing
  • Working with Web Technologies Java, AJAX, XML, HTML, PHP, API, JavaScript, Rest API, JSON, Ruby, and Python. Through visual studio as programmer.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: SSIS, SSRS, T-SQL, Visual Studio, SQL Server Profiler, MS SQL Server 2008R2/2012, SQL Server Business Intelligence Development Studio, Oracle 8i, T MySQL (4.x, 5.x).T ableau Desktop 7.0, 8.0.

Confidential, Indianapolis, IN

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

  • Involved in Data modeling, designing and building relational databases and Data ware house Development in star and snow flake methods.
  • Creating and managing schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Developed stored procedures, triggers in SQL/PL/SQL/MySQL/Teradata for lowering traffic between servers & clients.
  • Experience on anti-money laundering
  • Worked on performance tuning to Improve performance of SQL queries by creating indexes
  • Restricted access to secure columns of the tables by creating views that omitted secure data, and provided access for only no secure data for developers.
  • Implemented iterative logic in batch processing for loading data SQL server into multiple data for Migrating Data from different sources to Destinations.
  • Used to work on Microsoft Analytics Platform System ( APS ), for data warehousing
  • Used to Work with Teradata utilities (T-SQL, B-TEQ, Fast Load, Multi Load, Fast Export, T pump, Visual Explain, Query man), Teradata parallel support and UNIX Shell scripting, API .
  • Working with Web Technologies Java, AJAX, HTML, PHP, JavaScript, Rest API, JSON, Ruby, and Python. Through visual studio as programmer.
  • Ability to configure SQL server to XML and HTML used to extract and store. Expert Excel user including VBA programming.
  • Wrote Teradata Macros and used various Teradata analytic functions.
  • Working closely with Application Developers in optimizing the query performance, tuning stored procedures taking long time in production environment and performance monitoring using SQL Profiler

Environment: MS SQL Server 2005/2008/2012, T-SQL, SSIS 2008/2012, SSRS 2005/2008 R2/2012.

Confidential

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

  • Written Stored Procedures and SQL scripts both In SQL server and PL SQL’ server.
  • Designed T-SQL scripts to identify long running queries and blocking sessions.
  • Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
  • Normalization and De-Normalization of tables .
  • Developed Backup and Restore scripts for SQL server 2005 .
  • Installed and Configured SQL server 2005 with latest service packs .
  • Written T- SQL queries for the retrieval of the data.
  • Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
  • Maintained the security, integrity and availability of SQL Server.
  • Ability to identify and resolve bottle necks specifically related to fragmentation, Locking (page level, row level, and leaf level), blocking and memory and resource contention.

Environment: SQL Server 2008R2, T-QL, SQL Server 2008/2005 Oracle 9i, Visual Basic, SSIS, SSRS2005/2008, Excel.

Confidential

Data base programmer

Responsibilities:

  • Used to write Stored Procedures and SQL scripts both in SQL
  • Designed T-SQL scripts to identify long running queries and blocking sessions.
  • Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions .
  • Developed Backup and Restore scripts for SQL-Server 2005.
  • Used DBCC utilities and fixed data corruption in application databases.
  • Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions .
  • Written T-SQL queries for the retrieval of the data.
  • Error handling using Try-Catch Block .
  • Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
  • Prepared daily and weekly status reports and collaborated with other team members.

Environment: SQLServer2008R2/2008/2005 Enterprise Edition, T-SQL, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL.

Hire Now