We provide IT Staff Augmentation Services!

Ms Sql/ssis/tableau Developer Resume

SUMMARY

  • Over 7+ years of experience as SQL developer and SQL BI. Strong experience in interpreting and analyzing data in order to drive successful business solutions.
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
  • Excellent understanding of business operations and analytics tools for effective analysis of data.
  • Actively participated in gathering business requirements to implement functional and technical specifications.
  • Migrated databases\instances from SQL Server 2008 to SQL Server 2017 version.
  • Experience in T-SQL programming, writing complex stored procedures, efficient SQL queries with joins and tuning for optimal performance.
  • Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS).
  • Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Functions, Database Triggers.
  • Efficient in creating joins and sub-queries for complex queries involving multiple tables.
  • Created stored procedures for generating reports using SQL Server Reporting Services (SSRS).
  • Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP).
  • Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
  • Experience in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Experience in optimizing SQL code by understanding execution plans, using SQL Profiler, DMVs, Index tuning wizard and other tools.
  • Designed and developed data visualizations, prototypes for various reports/dashboards and published on Tableau Server.
  • Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.
  • Experienced in Extracting, Transforming and Loading data from various data sources like excel, flat file and Oracle to SQL Server databases using SSIS SQL Server Integration services.
  • Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert utilities.
  • Experience in working with partially / full blocking transformations and expertise in performance tuning of SSIS packages.
  • Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Proficient in SSIS package designing/development/deployment/documentation.
  • Strong experience in assigning permissions to the valid users for executing the reports & deploying reports to report servers.
  • Experience in UNIX Shell Scripting, scheduling cron jobs and dbms jobs.
  • Experience in using source code analysis tools, automated build process and unit testing, debugging.
  • Expert in creating Drill Down and Drill Through, Ad Hoc, Parameterized reports, Sub-reports, Snapshots, designing report layout using SQL SSRS.
  • Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL Loader.
  • Used version controlling tools such as Tortoise SVN, GIT and MS Team Foundation Server.
  • Excellent team player with great communication skills, positive attitude, problem-solving and trouble-shooting capabilities.
  • Can easily adapt to any new technologies with ease and comfort.
  • Good experience in understanding and designing solutions for complex integration scenarios. Technical skills

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, PL/SQL, C, C# .NET, UNIX & Shell scripting, Java Script, Html

Databases: SQL Server 2017/2016/2014/2012/2008 R2/2008,, Oracle 10g/11g, My SQL, MS Access

Tools: SSMS, SQL Sever Data Tools, Putty, Import/Export, SQL *LOADER, SQL Developer, TOAD, PL/ SQL developer, Visual Studio, Tableau, CVS, DTS Package

Testing: Manual Testing, Unit Testing

ETL Tools: SSIS, INFORMATICA

Reporting Tools: Tableau, SSRS, Oracle Reports

Operating Systems: Windows 7/10, UNIX, LINUX

Application Packages: Microsoft Office Suite, MS Visio

PROFESSIONAL EXPERIENCE

Confidential

MS SQL/SSIS/Tableau developer

Responsibilities:

  • Involved in gathering user requirements and reporting requirements for a better understanding of the business process.
  • Extensively worked with Microsoft SQL and SSIS and converted business requirements into SQL logic as per the requirement.
  • Participated in work stream planning process including inception, technical design, development, testing and delivery of Tableau dashboards.
  • Extracted the source data coming from various sources like flat files, excel files, database objects and transform it to database understandable form and load into database tables using SSIS.
  • Perform data conversions, imports and exports of data within and between internal and external software systems.
  • Build and implement a reporting framework within ESSG TPG that detects data reconciliation or deviation between the TDC reported and the internal SOR.
  • Provided third party daily vendor deviation reporting to each TDC.
  • Provided Third party Governance management weekly deviation aging and trending reports.
  • The processed data from SSIS to database tables are input for Tableau reporting and it gives insightful information for making business decisions.
  • Created new Tables, Indexes, Views, Materialized Views, Procedures and Functions
  • Created Reports in PDF, XML and Excel format as per the Requirement provided by the User.
  • Designed and Developed data validation, load processes using SSIS tasks, SQL scripts, Stored Procedures, Functions, and Triggers.
  • Created Indexes on existing tables to improve performance.
  • Experience in creating dashboards using table calculations, logical calculations, number calculations and creating parameters in Tableau.
  • Converted tableau format reports into data visualization dashboards using available Tableau features.
  • Designed and developed data visualizations, prototypes for various reports/dashboards and published on Tableau Server.
  • Documented new and existing models, solutions and implementations.
  • Provided support to the User/Customer incase if they have any questions on running the Reports.
  • Involved in doing Unit Testing, Integration Testing and System Testing.
  • Provided support and maintenance of scheduled PROD jobs.

Environment: MS SQL, SSIS, Tableau, MS Visio, Share point, MS Excel, GIT, Jira

Confidential, Philadelphia, PA

Oracle PL/SQL developer

Responsibilities:

  • Involved in gathering user requirements and reporting requirements for a better understanding of the business process.
  • Extensively worked with Oracle SQL and PL/SQL and converted business requirements into PL/SQL logic as per the requirement.
  • Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
  • Created new Tables, Indexes, Views, Materialized Views and Functions
  • Created Reports in PDF, XML and Excel format as per the Requirement provided by the User.
  • Worked with Paper Parameter form, Paper Layout's on Oracle Reports.
  • Designed and Developed data validation, load processes using PL/SQL scripts, Stored Procedures, Functions, and Triggers.
  • Experience in writing complex SQL Queries.
  • Writing Shell scripts to call stored procedures and packages to load data files using external tables.
  • Worked with Scheduler for Scheduling and Running Oracle Reports/Jobs.
  • Worked with Data Integration Projects.
  • Created Packages and Procedures to automatically drop table indexes and recreate indexes for the tables during data loads.
  • Provided support to the User/Customer incase if they have any questions on running the Reports.
  • Involved in doing Unit Testing, Integration Testing and System Testing.
  • Used different types of Indexes like Function-Based Index, partitioned index etc.. to improve the performance.
  • Played a major role in production support and maintenance of jobs.
  • Meet deadlines while meeting the reporting needs of the business users and project owners.

Environment: Oracle 11g/12c, UNIX, TOAD for Oracle, SQL Developer, SQL *Plus, GIT, Jira.

Hire Now