SSIS/SQL Developer Resume Hartford, CT - Hire IT People (2024)

SUMMARY

• 06+ years of experience in Database programming, System Analysis, Design, Development & Support of MSBI and MS SQL Server 2014/2016.
• Proficient in requirement analysis, system design, and Object - Oriented Design (UML).
• Hands on experience in Development and Deployment of SSIS & SSRS packages.
• Experience in Importing/Exporting Data from various heterogeneous data sources to SQL server using transformation of OLTP data to the Data Warehouse using SSIS.
• Extensive experience in the development of Reports using SQL Server 2016 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports and score cards in multiple formats using multi - dimensional objects.
• Expert in monitoring SQL Server Performance, troubleshooting using SQL Profiler, Index Tuning Wizard (DTA), Windows Performance Monitor and Maintenance plan.
• Deployment of SSRS Reports and power view reports on SharePoint Portal and integrating Reports, Analysis Reports with SharePoint 2010(MOSS).
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Hands-on experience in Core Java, Cypress, Test Cafe, JavaScript, Databases (NoSQL, Aurora using Ansible, Terraform and AWS services) Jenkins, GitHub, Source Tree.
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Good experience on developing and implementing backup and recovery strategies, creating and maintaining users and responsibilities.
• Extensive experience in T-SQL programming in creating and using Stored Procedures, Triggers, Functions and complex queries on various versions of SQL server.
• Developed framework from the scratch for using Cypress to automate UI and used Java script, NodeJS and NPM for Angular based user interface.
• Experience with all phases of software development life cycle (SDLC) and project methodologies.
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Exceptional versatility and adaptability, extremely diligent having excellent communication skills and ability to work both as individual and as a team member.
• Effective Team Player with excellent Analytical, Programming, Written and Verbal Communication skills.

TECHNICAL SKILLS

RDBMS: SQL Server 2008/2012/2014/2016 , Oracle, My SQL

SQL Server Tools: SQL Server Management Studio, SSIS, SSAS, SSRS

Languages: T-SQL, Java

Version Control Tools: Microsoft team foundation server (TFS), GIT

Operating Systems: Windows, UNIX

Other Tools: Microsoft Visio, Toad, MS Office, Share point server 2013, SQL Plus

PROFESSIONAL EXPERIENCE

Confidential

SSIS/SQL Developer

Responsibilities:

• Worked on SSRS report generate excel based reports for the business.
• Extracting the data from SQL database and showing it on SSRS.
• Validating the records against each report.
• Compile user requirements and specifications for reports.
• Design, create and test SQL reports using SSRS.
• Validate report functionality with internal users.
• Experience with Java or other object-oriented programming language
• Respond to users to troubleshoot and/or improve existing reports.
• Develop new report requirements, changes to existing reports, and identify reporting errors.
• Collaborate with internal QA on customer acceptance testing.

Confidential

SSIS/SQL Developer

Responsibilities:

• Worked on SSIS package to download the zip files from SFTP and unzip the compressed files.
• Extracting the data from xml files and loading it into KOFAX Data Warehouse.
• Validating the records against each tiff image files
• Used transformations like Derived column, Conditional split, Aggregate, Lookup, Union All and Execute SQL tasks to load data into KOFAX Data Warehouse.
• Capturing the logs in case the invalid records found in the batches.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views, SQL joins.
• Loading the data from MACESS Data Warehouse to KOFAX Data Warehouse
• Worked on Dev/Pre-Prod and Prod environment to deploy the packages.
• Scheduled the SSIS packages using jobs

Confidential

SSIS/SQL Developer

Responsibilities:

• Worked in Data Extraction, Transformation and Loading from source to target system using Integration Services.
• Involved in deploying and scheduling SSIS Packages.
• Worked on creating the new jobs in SQL server.
• Worked on Requirements gathering.
• Creating Technical design document based on the requirements.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views, SQL joins.
• Used transformations like Derived column, Conditional split, Aggregate, Lookup, Union All and Execute SQL task to load data into Data Warehouse.
• Creating Technical design document based on the requirements.
• Worked on enhancements and bug fixes.
• Did analysis work for few projects.
• Documented all the project work like Unit test case document, Code Review document.
• Interaction with Clients to document the requirements and for discussing technical challenges.

Confidential, Hartford, CT

SSIS/SSRS Developer

Responsibilities:

• Worked with Visual Studio 2015 for Creating packaging in SSIS
• Developed SSIS packages and Deployed SSIS Project using Project Deployment model that includes packages and project parameters.
• Experience in Importing/Exporting Data from various heterogeneous data sources to
• SQL server using transformation of OLTP data to the Data Warehouse using SSIS.
• Worked on Database Objects creation such as Tables, CTE, User Defined Data Types, Stored Procedures, Views,
• User Defined Functions and Triggers.

Confidential, Branchville, NJ

SQL Developer

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Created various types of reports such as complex drill-down reports, drill through reports, parameterized reports, matrix reports, Sub reports, non-parameterized reports and charts using reporting services based on relational and OLAP databases.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.
• Extracted data from various sources like SQL Server 2016, CSV, Microsoft Excel and Text file from Client servers.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Designed and documented the entire Architecture of Power BI POC.
• Implementation and delivery ofMSBIplatform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server usingSSIS,SSRS.
• Monitoring SQL server performance using SQL Profiler to find performance and Deadlocks.
• Developed Employee scorecard reports which track all the employee metrics needed for the statistical analysis of Business.
• Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems like MS SQL Server.
• Extensively worked with SSIS tool suite, designed and created mapping using various SSIS transformations like OLEDB command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Scheduled and executed SSIS Packages using SQL Server Agent and Development of automated daily, weekly and monthly system maintenance tasks such as database backup, Database Integrity verification, indexing and statistics updates.
• Design and develop new Power BI solutions and migrating reports from SSRS.
• Created DataMart for sales team to create Ad-hoc reports using report builder.
• Implemented Power BI gateway to keep Dashboards and reports up-to-date with on-premise data sources.
• Extensive use of Team foundation server for code check-in/check-out and managing source code changes.
• Developed custom calculated measures using DAX for various Fact calculations for efficient data visualization in Power BI.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing.

Environment: MS SQL Server 2016, SSIS, SSRS, SSAS, Visual Studio 2012, Power pivot, T-SQL, Power BI, MS TFS.

Confidential

SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Installed SQL Server 2014 and Management tools using SQL Server Setup Program and upgraded existing databases from sql server 2012.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to load the shipping and customer data.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).
• Created custom logging and package configurations to change connection strings and variables dynamically. Used all types of containers in SSIS.
• Created package deployment utility and deployed packages into various environments. Involved in unit testing, SIT, UAT and data validations.
• Writing variousT-SQLqueries,Stored Proceduresand used them to build packages.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server reporting services.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Worked in agile methodology, participated in daily scrum meetings.

Environment: Agile, SQL Server 2014, SSIS, SSAS, SSRS, Java, Power BI, MS Office 2007, T-SQL, Windows Server 2008.

Confidential

Jr. SQL & BI Developer

Responsibilities:

• Analyzing and understanding the existing reporting environment.
• Worked closely with the Business analysts for requirements gathering, designing the database and creating workflow for report.
• Implementing the new reporting requirements for the business by making use of the new database and schema changes.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse
• Created one central SSIS Master Package to execute multiple child packages with Control Flow and Data Flow. Utilized Parent Package and XML Configuration to dynamically pass variable values on runtime.
• Developed dashboards using Power BI.
• Participated in identifying data migration issues and resolved them.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Created and scheduling maintenance jobs in new environment using SQL Server Mailing Agent in SQL Server.
• Extensively used variables, break point, check point, logging, package configuration and event handler in SSIS packages to meet the business needs.
• Involved in performance tuning to optimize queries and enhance the performance of databases, SQL queries, and stored procedures using SQL Profiler, Execution Plan and Index Tuning Wizard.
• Resolving the SSAS cube connectivity and data issues as and when needed.
• Interacted with Business Users to help them understand to generate reports/look at the business data with various drill down options with Excel via connecting to SQL Server Analysis Services (SSAS).
• Supported the production environment for any Data or Logic Related Issues, Test and Debug the use case scenarios and migrate the code as needed by coordinating with the DBA Team.

Environment: SQL Server 2012, SQL Server Integration Services (SSIS), Reporting Services(SSRS), TFS, Power BI, Power-Shell, Pivot Tables, MS Visual Studio.Net, C#, Java, SQL Profiler, Windows 2003/2007 Server OS.