We provide IT Staff Augmentation Services!

Bi/sql Developer Resume

Norfolk, VirginiA

SUMMARY:

  • 5 Years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing (ETL/ELT)/Decision Support Systems and Business Intelligence.
  • Skilled professional with experience in all stages of SDLC: planning, analysis, design, implementation and Worked with SDLC methodologies like Waterfall, Agile (Scrum).
  • Experience in IT industry with strong background in Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling for BI applications.
  • Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling (Normalization/De normalization, ER Diagrams, Keys).
  • Expert in development, implementation, administration and support of SSIS processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2012/2008r2.
  • Expert in Extraction, Transforming and Loading (ETL/SSIS) data flows using SSIS; creating mappings / workflows to extract data from Oracle, SQL Server and Flat File, XML, Web services, legacy systems and load into various Dimensions and Facts.
  • Experience working in complex XML file to read nested node structure. Create custom XSL, XSD using custom script component.
  • Expert in Extracting, Transforming, Analyzing, Visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and C-level executives to take informed action.
  • Worked on Creating Dashboards using QlikView/ Qlik Sense using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated adhoc Qlik Sense Apps as per the user requirement.
  • Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
  • Experience in Database structuring, database application design & development, Entity Relationship Modeling (ERM), Data export/import, SQL programming & ETL procedures.
  • Performed different types of loads Incremental Load and Historical Load.
  • Knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
  • Expertise in Designing Universes for Ad-hoc query, canned reporting and analysis using the Designer Module.
  • Expertise in creating standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
  • Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
  • Sound knowledge in writing SQL Queries.
  • Accustomed to various tools such as JIRA for bug tracking, Proficient in functional, negative, regression, system integration, user acceptance (UAT), browser compatibility, root cause analysis and complex SQL queries.
  • Experienced developing data mapping, data dictionary and data lineage documents for ETL and Stored procedure.
  • Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem-solving skills, Ability to adapt, learn new technologies and get proficient in them very quickly.

WORK EXPERIENCE:

Confidential, Norfolk, Virginia

BI/SQL Developer

Responsibilities:

  • In-Depth Knowledge with requirements gathering, analysis, design, development, change management, deployment and user training.
  • Responsible for SSIS job monitoring and success/failure email monitoring and took corrective actions to resolve the production issues.
  • Created Stored Procedures in T-SQL those were invoked to load Dimensions and Fact tables and also for Error handling during the SSIS process.
  • Responsible for writing complex SQL scripts by implementing various joins and data transformation to achieve accurate data profiling results to further discuss with SME’s. and business analysts.
  • Worked with users to fix data quality issues and defining business rules to cleanse the data for data marts to achieve accurate reporting results.
  • Developed SSIS packages adhering to the development standards and formats.
  • Examined existing data flow process and suggested improvements to Business.
  • Designed and implemented Data Marts, Facts, and Dimensions having Star / Snowflake schemas using Dimensional Modeling principles.
  • Successfully transferred old data from various sources like flat files, MS Access, and Excel, MSSQL 2008 r2 into MS SQL Server 2014 using SSIS Packages.
  • Expert in processing complex XML files using standard XML source transformation and script component using C# for complex nested XML files to generate XSD and XSL.
  • Worked on SSIS-Web Service task to read data from web services with and without input parameters.
  • Optimized queries and did performance tuning using various MS SQL Server tools such execution plan, SQL Profiler.
  • Participate in business requirements and design review sessions and work directly with business units to define and prototype QlikView/QlikSense Applications.
  • Extract, transform and load data from SQL databases into QlikView applications.
  • Participate in design, develop, and test QlikView scripts in load editor to import data from source systems and test QlikView/Qlik Sense dashboards to meet customer requirements.
  • Participate in migration of QlikView Applications to QlikSense.
  • Create and maintain technical design documentation.
  • Interact with Data Warehouse staff to design, create and tune physical database objects (tables, views, indexes) to support logical and dimensional models.
  • Created basic dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
  • Designed and developed ETL with the incremental loads where applicable.

Environment: Microsoft SQL Server 2008R2,2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Qlik Sense 3.2, Oracle 11g, Access, Windows 2003 Server, Team Foundation Server.

Confidential, Little Ferry, NJ

BI/ SQL/ ETL Developer

Responsibilities:

  • Reviewed and analyzed business needs and developed Technical Specifications based on interaction with Analysts and Development Teams.
  • Designed and developed database objects like Batch Scripts, Stored Procedures, Views, Tables and Indexes consumed at various stages of Cleansing process, Reports or Data Validation using SQL best practice standard.
  • Responsible for production support, daily job monitoring, problem solving and SQL scripts for adhoc reporting.
  • Responsible to extract data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
  • Deploy SSIS Package into Production and used Variables to export various package properties to make package environment independent.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Developed various ETL templates for reusability to extract data from various sources to load into SQL stage and data mart.
  • Developed various real time and non-real time SSRS reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) subscription using report manager.
  • Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to load data into SQL Server for data profiling using SQL queries.
  • Create and schedule different complex reports as per given business requirement by leveraging the adhoc reporting using QlikView.
  • Designed and created the dashboard reports for Executive board of company using Incremental Logic & Developed the data model using Link Tables and concatenate.
  • Developed ETL deployment documents for both File system and SSISDB catalog deployment.
  • Designed UI using different types of sheet objects like Trellis chart, Pivot table, Straight table, Bar chart, Scatter chart, Trends, KPI's, Bookmarks, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.
  • Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
  • Using QlikView functions such as Date and Time, Keep, Join, Mapping, and String & input Fields etc.
  • Provided 7 x 24 Production support for the database and application issues.

Environment: Microsoft SQL Server 2008R2,2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Query Analyzer, Microsoft SharePoint, Microsoft Visio Professional 2010, QlikView 9, Oracle 10g/11g, SQL Assistant, HP Quality Center 10.

Confidential

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
  • Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose.
  • Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned in daily scrum.
  • Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2012 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
  • Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).
  • Used Team Foundation Server to retain Project code during deployment process.
  • Part of Code review during Production deployment and QA deployment.
  • Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
  • Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C#.
  • Created Process for Error Details in Application system, Control-M Job, SQL agent Job to easily identify Issue for Support and Solution.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
  • Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
  • Developed Power BI reports and dashboards from multiple data sources using data blending
  • Developed SQL queries/scripts to validate the data such as checking duplicate, null values, truncated values and ensuring correct data aggregations
  • Explored data in variety of ways and across multiple visualizations using Power BI, Strategic expertise in design of experiments, data collections, analysis and visualization.
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
  • Also Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
  • Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Environment: MS SQL Server 2012, SSIS Package, SQL BI Suite (SSMS, SSIS, SSRS, SSAS), XML, MS Excel, MS Access 2007 & Windows Server 2008, C#, SQL Profiler, Erwin r 7.3.,Net 4.0/4.5.,TFS 2010, Power BI.

Confidential

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2008 R2 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
  • Gathered user requirements to develop the business logic and analyzed and designed database solutions.
  • Designed Console application to generate Single .CSV and text file from Different Relational Database table using SSIS and C#.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • 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.
  • Extensively participated in functional and technical meetings for designing the architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW) and offshore team management
  • Used various SSIS tasks such as Conditional Split, Script Component Task, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
  • Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
  • Designed, deployed, and maintained of various SSRS Reports. Created reports using SQL Server Reporting Services
  • Designed Database, Tables and Views structure for the new data mart.
  • Successfully transferred old data from various sources like flat files, MS Access, and Excel into SQL Server 2008R2 using SSIS Packages and BCP
  • Created complex Stored Procedures and Functions for integrity checks of transferred data.

Environment: MS SQL Server 2008/2012, SQL BI Suite (SSMS, SSIS, SSRS), XML, MS Excel, MS Access 2007 & Windows Server 2008 Access 2003 & Windows Server 2003, SQL Profiler, Data Analyzer, Erwin r 7.3.,Net 4.0/4.5.,TFS 2005/2008/2010/2012 , SQL Server 2008R2, SSIS 2008R2, SSAS, SSMS.

Hire Now