We provide IT Staff Augmentation Services!

T-sql/bi Developer Resume

SUMMARY

  • Around 9 years of experience in IT industry, working as a BI|ETL|T - SQL|SSIS|SSRS|QlikView Developer having good experience on T-SQL, SQL Server, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Oracle 10g, NoSQL, QlikView, PowerBI, Tableau and QlikView.
  • Experienced in SDLC (Software Development Life Cycle) by following Agile methodology/Waterfall for gathering requirements, analysis, design, development, testing, debugging and deploying.
  • Excellent knowledge of Business Intelligence and Data Warehousing with good fundamentals in Databases and Programming.
  • Experience in Dimensional modeling using Star Schema and Snowflake Schema and data analysis to provide Business Intelligence solutions.
  • Expertise in writing T-SQL Queries using Joins, Sub queries, stored procedures, functions, triggers for building packages and Performance tuning SSIS packages and SSRS Reports.
  • Worked on MS SQL Server Query Engine, Execution Plan, Indexing and other performance tuning techniques.
  • Strong Knowledge on creating SSIS packages using control flow tasks like Execute SQL Task, FTP, For Loop, For-each-Loop, Execute Package task, etc. and data flow tasks like Derived column, Slowly Changing Dimension, Look up, Conditional Split, OLEDB command, etc. Also, different types of sources and destinations like Oracle source, SQL, Excel, flat file, Raw, etc.
  • Experience in SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages, configuring Checkpoints, troubleshooting, debugging the data flow by using Data viewers, awareness on Transactions concepts to roll back the data of SSIS packages in case of failure.
  • Experience in developing Oracle scripts, Functions and Packages using Oracle SQL developer.
  • Implementing Logging features to the existing packages to track the record counts, package status by storing it in logging DB tables with their associated column values.
  • Familiar with Complex Reporting Requirements like Dashboard, Matrix, Cascading Summary, Sub reports and pass through parameters from main report to the sub reports.
  • Strong knowledge in creating subscriptions on reporting services like Data Driven Subscriptions (DDS) and Static Subscriptions and enabling DDS with dynamic queries for extracting parameter values from database on runtime.
  • Participating on Review and Retrospective meetings for sharing ideas to improve productivity.
  • Scripting knowledge using C# or VB knowledge to work on script components for ETL purpose by replacing existing transformations or to add an additional functionality for the packages
  • Creating SSAS cube, deploying and browsing the cubes using KPIs.

TECHNICAL SKILLS

  • MS SQL Server 2008 R 2/2012/2014/2016 , Oracle 10g DB and MongoDB.
  • T-SQL, PEGA, C, C++, C#, VB.Net, SQL, MySQL, NoSQL, HTML 5, CSS, JScript and XML
  • Word, Excel, Outlook, DevOps, JIRA and Clarity.
  • Team Foundation Server (TFS), BitBucket, GIT and SVN repository.
  • SQL Server Management Studio and MongoDB.
  • SQL Reporting Service (SSRS), PowerBI, Tableau, Pentaho and QlikView.
  • SSIS, Pentaho Data Integration and Talend Studio for Integration.
  • Visual Studio 2008/2010/2012/2013/2015.

PROFESSIONAL EXPERIENCE

Confidential

T-SQL/BI Developer

Responsibilities:

  • Extracting, Transforming and Loading data from Excel, Flat file, Oracle, etc. to target MS SQL Server data warehouse using SSIS under Dataflow task transformations for the data using data conversion, derived column, look up, Conditional Split, Aggregate, SCD, Union all, Row Count and Merge join transformations.
  • ETL changes for SSIS packages by using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, File System Task, FTP Task, Script Task, Send Mail Task and Data Flow Task.
  • Scheduled Jobs to run the SSIS Packages on timely manner through SQL Server Agent.
  • Acting upon the Service requests/tickets as per the priority level from the clients and completing the requests as per the requirements without any issues using SSIS for ETL changes and SSRS reports.
  • Develop, schedule and generate variety of reports like List, Matrix, Drill-Down, Drill-through, Chart, Cascaded reports, Multi-value and Sub Reports by creating Expressions/Parameters/Sub-Reports/Sorting & Grouping using SQL Server Reporting Services (SSRS).
  • Experienced in creating Standard and data-driven subscriptions with different delivery extensions like Windows File Share, E-mail and SharePoint Library.
  • Building complex T-SQL queries and stored procedures for the reports in SSRS.
  • Migrating Oracle database source based SSRS reports to SQL source-based by changing the Oracle source code to SQL code compatible.
  • Developed Oracle scripts, Functions and Packages using Oracle SQL developer.
  • Created and managed database objects such as tables, views, indexes, stored procedures, user defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
  • Good T-SQL Programming techniques in query optimization using Actual and Estimated Execution Plans in SSMS, SQL profiler to find the long running queries and performance tuning by creating Clustered and Non-Clustered Indexes.
  • Code deployments to QA and supporting them until code moves to UAT. Supporting business while UAT in progress and working on creating change requests with deployment instructions to deploy or move the code from UAT to PROD.
  • Supporting or working with L2 teams for the release support.

Environment: Business Intelligence Development Studio, C#/VB.net, XML, MS SQL Server 2014/2012/2008 R2, SSIS, SSRS, Oracle SQL developer, Team Foundation Server, Query Analyzer, SQL Profiler, Microsoft Office Excel and Windows Server 2008 Standard.

Confidential, Hampton, VA

T-SQL/BI Developer

Responsibilities:

  • Interacting with business/clients on weekly basis for gathering requirements and prioritizing/creating tasks.
  • Acting as a Lead to lead/assign tasks, reviewing reports and SQL codes developed by developers.
  • Translating business requirements and developing data repositories to create data models.
  • Created and managed database objects such as tables, views, indexes, stored procedures, user defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
  • Developed Drill down, Drill through, ad hoc, sub reports, Dash boards, Cached reports in SSRS. Distributed reports via SSRS in different formats to users on a weekly, monthly basis.
  • Created and Enhanced SSRS Reports by creating Expressions/Parameters/Sub-Reports/Sorting & Grouping.
  • Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, File System Task, FTP Task, Script Task, Send Mail Task and Data Flow Task.
  • Extracted data from sources and transformed the data using different transformations like data conversion, derived column, look up, Conditional Split, Aggregate, Union all, Row Count and merge join transformations.
  • Created Ad-hoc reports with complex t-SQL queries based on business requirement.
  • Wrote complex T-SQL queries and stored procedures for the building reports in SSRS.
  • Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS).
  • Used SSRS to create reports, customized Reports, on-demand reports.
  • Designed Different Types of reports like Drill Down, Drill Through, Sub Reports, Parameterized Reports, Sort prompts, Cascading parameters reports and Multi Value Parameters.
  • Created user defined functions in SSRS using VB script.
  • Create reports/dashboards from data marts/Analysis Services cubes using Tableau for analysis of data. Create reporting layer tables for fast execution of reports and dashboards.
  • Help users understand data marts, query data from huge tables and help them use the right tools and methods in getting to their results faster.
  • Maintained development process for developing ETL Packages and reports as per the norms like Gathering requirements, Design, Development, Code review, Unit Testing, Peer Review and Review before releasing to QA.
  • Good T-SQL Programming techniques in query optimization and performance tuning.
  • Experienced in creating nested Grouping, sorting columns and writing expressions per the business requirements.

Confidential

Sr. MSBI Developer

Responsibilities:

  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
  • Developed reports using report builder 3.0 and integrated SharePoint with SSRS 2008 R2 to deploy the reports to a web application.
  • Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Very good T-SQL Programming skills. Experience in query optimization and performance tuning.
  • Translating business requirements into technical design specifications.
  • Collecting requirements from business users and transforming then into logical and physical database designs.
  • Created packages using DTS and SSIS for data extraction from XML, Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
  • Extensively used XML task to retrieve XML documents.
  • Moved the static data from various text files to SQL Server 2008 database using BCP Import and Export, Bulk Insert.
  • Responsible for automation of maintenance jobs, locks and index configurations.
  • Performed DBA tasks through Enterprise Manager, Query Analyzer, Import Export wizard.
  • Developed SQL scripts to Insert/Update and Delete data in database tables.
  • Deployed code to System Test/UAT/Production servers.
  • Configured and monitored transactional replication on QA servers.
  • Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.

Confidential

Sr. MSBI Developer

Responsibilities:

  • Working closely with functional manager to understand the functional requirements.
  • Responsible for writing T-SQL queries, Stored Procedures and user-defined functions for handling the business requirements.
  • Responsible for implementing the ETL solutions using SQL Server Integration Services.
  • Extracting data from multiple sources like flat files and SQL server and transforming, cleansing, validating data and loading into destination tables.
  • Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, File System Task, FTP Task, Script Task, Send Mail Task and Data Flow Task.
  • Extracted data from sources and transformed the data using different transformations like data conversion, derived column, look up, Conditional Split, Aggregate, Union all, Row Count and merge join transformations.
  • Created Event Handlers for the Packages Using Event Handler Tab for Error Handling and Logging purpose.
  • Generating the reports as per functional needs.
  • Enabled email notifications using SSIS package for large data files subscribed through Windows File Share placed in a folder for different customers with different time frames.
  • Enabled email notifications using SSIS package for large data files subscribed through Windows File Share placed in a folder for different customers with different time frames.
  • Unit tested the SSIS packages.
  • Involved in self review and pre-review of the deliverables.
  • Interacting with UI developers for integrating ETL packages with applications.
  • Creating and executing Unit test cases.
  • Creating deployment documents.

Hire Now