We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

Bethesda, MD

PROFILE SUMMARY:

  • Over 8 Years of professional experience in Development, Implementation and Administration of Database Systems by working as both OLTP Data Warehousing Systems Applications Specialist and SQL BI Developer, Oracle Developer, Development & Support of Oracle Database 9i, 10g and 11g in Production, Staging and Development environments.
  • Extensive experience in MS - SQL and Oracle PL/ SQL Development , involved in Design, Development and Support of MSSQL Server 2016/2014/ 2012/2008 and Oracle 11g and 12c databasefor both OLTP and OLAP Systems.
  • Extensive knowledge and experience in dealing with Relational Database Management Systems, Import/Export, Triggers, cursors.
  • Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Partitioned large Tables using partition technique .
  • Knowledge of relational database, normalization/de-normalization.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Excellent understanding of Database modeling for OLTP/OLAP systems, Implementation and organization.
  • Worked in OLTP and OLAP environment that includes Production Support and development databases in SQL server.
  • Experience in Microsoft stack of BI solutions - SSRS, SSIS with MS SQL 2016/2014/2012/2008.
  • Created SSIS packages to import data from various sources to SQL Server.
  • Experience in ETL operations using SSIS Packages from Development Server to Production Server.
  • Experience in transforming unstructured data from various data sources.
  • Set up transactions, loggings, event handlers and checkpoints to handle errors.
  • Migration of packages and Reports from SQL Server 2000 to SQL Server 2005.
  • Expertise in SQL Server reporting services (SSRS) 2005/2008 in generating complex reports: Tabular, Matrix,Cascaded, TOPN, Parameterized, Chart, Sub-reports, Drill-down and Ad hoc reports.
  • Experience in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
  • Proven ability in Query Optimization.
  • Designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
  • Formatted reports for various visual representations using conditional formatting and templates.
  • Worked on Version control systems like Subversion, GIT, CVS and Perforce .
  • In-depth understanding of all stages of software development life cycle (SDLC).
  • Extensive experience in using Oracle seeded packages like DBMS OUTPUT, DBMS SCHEDULER, UTL FILE, DBMS SQL and DBMS STATS.
  • Proficient in advance features of Oracle 9i for PL/SQL programming like Using Cursor Variables, Ref Cursors, Nested Tables and Dynamic SQL .
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
  • Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables .
  • Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases.
  • Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies .
  • Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation .
  • Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
  • Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.

TECHNICAL SKILLS:

SQL: Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services

Business Intelligence Tools: SQL Server Integration Services(SSIS),SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Crystal Reports 9.0/10.0

RDBMS: MS SQL Server 2008 R 2/2008/2005/2000 , Oracle 10g/9i,MS Access

SQL,T: SQL, PL/SQL, C, C++, JAVA, C#, VB

Web Technologies: HTML, XML, VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET

Data warehousing tools: Informatica, Business Objects, Cognos, Erwin

Office and Other Tools: Visual Studio 2008/2005, Visio, Visual Source Safe, Microsoft Word 2003/2007/2010 , Microsoft Excel 2003/2007/2010 , Microsoft PowerPoint 2003/2007/2010

Operating System: Windows 98, Windows 2000, Windows Server 2003, Windows NT, Windows XP, Windows Vista, Windows 7 Ultimate, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

SQL BI Developer

Responsibilities:

  • Responsible for systems analysis, development enhancement, maintenance and support of Oracle based application
  • Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Developer and Toad.
  • Wrote SQL, PL/SQL programs required to retrieve data using cursors and exception handling.
  • PL/SQL programming including triggers, procedures and packages.
  • Established relationships between tables; created constraints.
  • Involved in Performance tuning of PL/SQL Queries. worked with UNIX shell scripting
  • Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
  • Involved in the continuous enhancements and fixing of production problems.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remoteinstances.
  • Provided ongoing support for MS SQL SERVER database servers for systems, which include creation, configuration, maintenance and upgrade.
  • Involved in developing, testing, compiling, debugging and maintaining the data using SQL.
  • Created Stored Procedures, Functions, views and SSIS packages in MS SQL database.
  • Involved in the optimization of SQL queries, which resulted in substantial performance improvement for the conversion processes.
  • Used SQL Server SSIS tool to build high performance data integration solutions including extraction,transformation and load packages for data warehousing.
  • Manage source code, software builds, software versioning, and defect tracking on all software maintenance tasks and projects.
  • Maintained Continuous integration effort with Subversion along with scheduled builds.
  • Worked on Version control systems GIT Clear Case and Perforce.
  • Supported 24 X 7 Production On call.

Environment: Oracle 12c, TOAD, SQL Developer, Shell Scripts, UNIX, Windows 2012, MS SQL Server 2016, VS2019 and SSMS.

Confidential, Chevy Chase, MD

SQL BI Developer

Responsibilities:

  • Extensive experience with T-SQL in constructing Tables, implementing stored Procedures, Functions, Views, User Profiles, triggers, Data Dictionaries and Data Integrity.
  • Worked on Normalization and Relational Database Management Systems.
  • Experience of performance tuning, query optimization using Performance Monitor, SQL Profiler or other related tools.
  • Experience with developing complex SQL Queries and stored procedures, and automating data retrieval from other data sources.
  • Worked on creating Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) using visual studio tool.
  • Hands on Experience in Installing, configuring, managing, monitoring and troubleshooting SQL Server 2012/2014/2016.
  • Design, develop, deploy and test ETL processes using SQL Server Integration Services, stored procedures, and functions.
  • Create, schedule and monitor ETL Jobs using SQL Server Job Agent or other scheduling tools.
  • Review and identify stored procedures, packages and functions for best practices, enhanced features and better performance.
  • Provided support to staging and production cloud-based databases as well as create, operate, and maintain development and testing database environments.
  • Writing ad-hoc queries to analyze the desired output from the relational model.
  • Identify in-efficiently written SQL's for fine-tuning in order to improve performance.
  • Bulk updates/inserts using merge statements.
  • Writing analytical queries for faster processing and better performance.
  • Using appropriate hints and query techniques for faster retrieval of information.
  • Conversion and mapping of data, verifying the data integrity and validations.
  • ETL activities like retrieval of data from external file using external table for data transformation.

Environment: Windows 2008, MS SQL Server 2014/2016, VS2016, SSMS, Oracle 12c and TOAD.

Confidential, NY, NYC

SQL BI Developer

Responsibilities:

  • Involved in the development of custom stored procedures, functions, triggers using T-SQL
  • Involved in the optimization of SQL queries, which resulted in substantial performance improvement for the conversion processes.
  • Reorg/Rebuilding the indexes at regular intervals for better performance .
  • Developed SSIS, SSAS packages in SQL Server 2014 using Business Intelligence Studio and created the jobs to schedule the SSIS packages in SQL Scheduler.
  • Developed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
  • Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task to generate underlying data for the reports and to export cleaned data from Text file to different data Marts.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Developed Sub Reports, Matrix Reports, Charts, Ad hoc, Drilldown reports, using SQL Server Reporting Services (SSRS).
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Performed performance tuning of stored procedures using SQL Server Profiler.

Environment: MS SQL Server 2014/2016, Windows 2008, VS2016, SSMS, Oracle 12c and TOAD.

Confidential, Parsippany, NJ

SQL Developer

Responsibilities:

  • Developed several SSIS packages in SQL Server 2008R2 using Business Intelligence Studio and created the jobs to schedule the SSIS packages in SQL Scheduler.
  • Troubleshooting of SQL job failures, DTS and SSIS packages.
  • Troubleshoot the complex queries and created several indexes to improve the queries performance.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
  • Provided cloud computing services in IaaS and various other cloud services
  • Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Skilled in error and event handling: precedence Constraints, Break Points, Checkpoints and Logging.
  • Experience in SSIS script task, look up transformations and data flow tasks using T- SQL
  • Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
  • Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
  • Configured SQL mail agent for sending automatic emails

Environment : MS SQL Server 2014/2012, SSIS, OLAP, SSRS, MS Visual Studio and Windows Server.

Confidential, New Braunfels, TX

SQL BI Developer

Responsibilities:

  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
  • Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
  • Developed SQL Queries to fetch complex data from different tables using joins, database links and formatted the results into reports and kept logs.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary
  • Configured SQL mail agent for sending automatic emails
  • Createdjobs through SQL Server Agentfor SSIS packages.
  • Created various database objects such as tables, indexes and views based on the requirements.
  • Involved in setting up SQL Server and database configuration parameters and Creation of new databases, planning the location of data, index and Transaction log files on disks.
  • Involved in project planning, scheduling for database module with project managers
  • Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
  • Used Lookups Transformation to get the data from reference data sets.

Environment : MS SQL Server 2014/2012, SSIS, OLAP, SSRS, MS Visual Studio 2010, and Windows 2008 Server.

Confidential

SQL Developer

Responsibilities:

  • Developed and maintained ETL packages to extract the data from various sources and Responsible for debugging and upgrading of several ETL structures as per the requirements.
  • Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
  • Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages .
  • Responsible for creating reports based on the requirements using SSRS 2008 and Defined the report layout and identified datasets for the report generation.
  • Created different types of reports including financial reports, cross-tab, conditional, drill-down, sub reports also parameterized reports, ad hoc reports for existing databases.
  • Design and created financial report templates, bar graphs and pie charts based on the financial data . Scheduled the monthly /weekly/daily reports to run automatically.
  • Developed, implemented and maintained various database objects such as stored procedures, triggers, functions, indexes and views .
  • Worked as a team for defining measures and dimensions by creating cubes in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.
  • Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
  • Used VSS to store, run, view, edit and revert back to different versions of the design in case of a version control.

Environment: MS SQL Server 2005/2008, SQL server integration services 2008, SQL server Reporting Services 2008, VSS visual source safe, .NET Framework, ASP 3.0, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Hire Now