We provide IT Staff Augmentation Services!

Ssis, Ms Sql Developer Resume

SC

PROFESSIONAL SUMMARY:

  • Overall 7+ years of Experience in Data Warehousing and Business Intelligence applications design, development, Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
  • Experienced in logical and physical database design and development, normalization, data modeling and SQL Server Enterprise Manager/SQL Server Management Studio .
  • Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
  • Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
  • Extensive ETL experience using DTS/SSIS for data extraction, transformation and loading from OLTP systems to ODS and OLAP systems.
  • Experience in Extraction of data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP and Bulk Insert utilities.
  • Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
  • Expert in scheduling jobs for SSIS Packages and sending Alerts using SQL Mail.
  • Adept in designing Stylish Report layout and have extensive experience in generating Drill down and Drill through as well as Slice and Dice reports with Drop down menu option, sorting the data, Sub reports defining subtotals in SSRS 2005/2008/2008 R2.
  • Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent. ETL, OLAP Experience
  • Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
  • Experience on Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
  • Expertise in creating and managing Package Configurations, Logging, System and User - defined Variables for SSIS Packages.
  • Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
  • Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages and Project Configuration wizard to configure SSIS Projects.
  • Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
  • Develop reports in SSRS using different types of properties like chart controls, Filters, Interactive Sorting, SQL parameters etc.
  • Develop medium to complex reports like detailed list report, Summary reports, Matrix reports, drill through reports, Sub-reports, ad-hoc reports to meet the business needs using SQL Server Reporting.
  • Experience in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
  • Expertise in upgrading or migrating Analysis Services.
  • Proficient in building Star schema and Snowflake schema depending on business requirements.
  • Experience on working with Multidimensional Expressions (MDX).
  • Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
  • Microsoft certified Power Bi Developer.
  • Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
  • Did lab work on designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.
  • Hands on calculated columns and measures using DAX in Power BI based on report requirements.
  • Created reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
  • Used several types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.).

TECHNICAL SKILLS:

Operating Systems: Windows 10/8.1/7, Unix, Linux.

Databases: MS SQL Server 2019/2014/2012/2008 R2, Teradata, Oracle 12c/11g/ 10g, MongoDB, MySQL, MS Access.

Database Design Tools and Data Modeling: Star Schema, Snowflake Schema, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization.

Modelling Techniques / Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

BI Tools: SQL, SQL Server Integration Services (SSIS 2012), SQL Server Analytical Services (SSAS 2012), Visual Studio, Power BI.

Languages: C, XML, .Net, Core Java.

PROFESSIONAL EXPERIENCE:

Confidential, SC

SSIS, MS SQL Developer

Responsibilities:

  • Experienced with writing MDX which multidimensional queries and aggregate functions related to cubes, measures, hierarchies, processing cubes and deployment of cubes.
  • Defined Calculations, Key Performance Indicators (KPIs), Actions, Perspectives, Translations, and Security Roles in SSAS.
  • Contribute to development and maintenance of data warehouse, ETL processes, and OLTP system.
  • Created Partitions, Calculated Members, Schemas, and File Groups for Fact Tables and Cubes.
  • Generated specifications for analysis reports by using SQL Server Reporting Services (SSRS) 2008R2.
  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Developed and created data dictionary, advanced queries, views, indexes, and functions for databases.
  • Wrote database triggers in T-SQL to check the referential integrity of the database.
  • Created the MS DTS packages for executing the required tasks. Created the jobs and scheduled for daily running.
  • Migrated 80+ DTS packages from SQL R2 using SSIS designer.
  • Executing proof of concepts to assess the value of Artificial Intelligence use cases.
  • Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using SSRS.
  • Created reports from database onto excel spread sheet using DTS.
  • Knowledge of one or more open-source Machine Learning Framework.
  • Actively participate in related Artificial Intelligence communities and technology forms.
  • Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
  • Wrote multiple programs in Python to monitor virtual machine usage data using VMWare API calls.
  • Involved in creating maintenance plans in SQL Agent to back up the database.
  • Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
  • Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent.
  • Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS .

Environment: SQL Server 2012/2008R2, SQL Profiler, SQL Server Agent, T- SQL, Performance Tuning, SSIS, SSRS, Integration Tools, SSAS, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, Microsoft Visio 2000.

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

  • Created numerous efficient Stored Procedures to perform data cleansing and loading tasks when data is loaded into the staging area.
  • Involved in Data Extraction, Transforming and Loading (ETL) using SSIS, BCP, Bulk Insert, DTS, and XML between Oracle, DB2, and Access to MS SQL server database.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
  • Used SSRS to Create Tabular, Matrix, and Drill down, Drill through reports, Summary Reports, and Parameterized Reports, Charts and graphs as per customer requirements.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Cascading, Summarized, Matrix, Map and Cross-join
  • Created Advanced Reporting Services Programming Using the Reporting Services Web Service .
  • Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
  • Responsible for creating dashboards and overall creation of data visualizations.
  • Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc.)
  • Converting business requirements into dashboard views and designs.
  • Understanding the concepts of refreshing, migrations and scheduling, taking back ups and restoration of tableau repository.
  • Resolved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Building and publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Involved in the complete SDLC including requirement specifications, Analysis, Design, Development, Testing and worked on End-to-End Process (starting from requirements analysis to implementation).
  • Identified data issues and worked extensively on bad data to resolve the issues. Also, worked on net iteration to eliminate backout claims, duplicates, calculate cost etc.
  • Extensive experience in writing complex queries including stored procedures, temp tables, functions, CTE’s, Joins, Sub queries and more.
  • Worked with parameters, variables, error handling, expressions in SQL server 2016 and SSIS. Also, I worked on RDBMS concepts for creating database objects such as tables, views, functions, indexes etc.
  • Performed data cleaning, Data Aggregation, Data Scrubbing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SQL queries.
  • Highly experienced in performance tuning and query optimization.
  • Developed ETL packages using different data sources (SQL server, Excel, Flat files, XML etc.) and loaded the data into the target by performing various kinds of transformations.
  • Provided documentation about database/Tables and Updated functional specification, technical design documents and Unit test cases.
  • Excellent Interpersonal, Analytical & Communication Skills with experience in interacting with clients, data admins and multiple groups.
  • Ability to work in a fast-paced environment and under deadlines.

Environment: MS SQL Server 2016/2012, MS SQL Server Management Studio (SSMS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS Visual Studio 2012, 2017, ETL, MDM, and Microsoft Team Foundation Server.

Confidential, Minnetonka, MN

MS SQL SSIS/SSAS/SSRS Developer

Responsibilities:

  • Experience in extracting the data from OLTP Systems to OLAP (DWH) using SSIS.
  • Developed and deployed SSIS packages and also upgrading DTS packages to SSIS. Also involved in Modified the Existing SSIS Packages .
  • Frequently used data flow and Control Flow Items for Designing ETL Packages.
  • Used various transformations such as Derived Column, look up, Conditional Split and Multicast while implementing the business logics and load the data to destination using SSIS.
  • Performed error handling in SSIS using Event Handling and logging.
  • Assisted in production of OLAP Cubes, written queries to produce reports using SQL SERVER 2012, SASS and SSRS.
  • Work with companies to implement Python programming and train on-site Python Programmers.
  • Speak at conferences and make presentations regarding Python as well as its applications and features.
  • Extracted data from On-Premises and SaaS (Software as a Service) into Power BI desktop.
  • Improved the performance of SSIS packages by using fast load options, converting the data type at source if applicable, parallel processing, using non-blocking, semi blocking components over blocking components, dropping and rebuilding the indexes during the SSIS package run.
  • Ran the SSIS package through SQL job.
  • Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters.
  • Created Linked reports, Ad-hoc reports (using Report Builder) based on the requirement. Linked reports are created in the Report Server to reduce the repetition of the reports.
  • Designed SSAS cubes for providing business intelligence applications.
  • Created various calculations and Named Datasets to implement business Logics.
  • Worked on Cube Reconciliation and Unit Testing.
  • Created stored procedures and functions to support efficient data storage and manipulation. Created check constraints to maintain data integrity

Environment: MS SQL Server Management Studio (SSMS), MS SQL Server 2014/2012, T-SQL, Visual Studio 2010, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), ETL, MS SQL Server Analysis Services (SSAS)

Confidential, Chicago, Illinois

SSIS, MS SQL Developer

Responsibilities:

  • Experienced with writing MDX which multidimensional queries and aggregate functions related to cubes, measures, hierarchies, processing cubes and deployment of cubes.
  • Defined Calculations, Key Performance Indicators (KPIs), Actions, Perspectives, Translations, and Security Roles in SSAS.
  • Created Partitions, Calculated Members, Schemas, and File Groups for Fact Tables and Cubes.
  • Generated specifications for analysis reports by using SQL Server Reporting Services (SSRS) 2008R2.
  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Developed and created data dictionary, advanced queries, views, indexes, and functions for databases.
  • Responsible for designing and executing Application objects and schema objects using MicroStrategy Desktop.
  • Developed and maintained Data Warehouse (Retek, MicroStrategy) reports providing sales increased data access and inventory data (Visual Basic 5.0, access 97, Oracle 8i)
  • MicroStrategy DSS Agent create cache table on schedule.
  • Wrote database triggers in T-SQL to check the referential integrity of the database.
  • Created the MS DTS packages for executing the required tasks. Created the jobs and scheduled for daily running.
  • Extensive experience resolving technical issues using the IBM Infosphere DataStage tool.
  • Migrated 80+ DTS packages from SQL R2 using SSIS designer.
  • Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using SSRS.
  • Created reports from database onto excel spread sheet using DTS.
  • Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
  • Involved in creating maintenance plans in SQL Agent to back up the database.
  • Experience in monitoring and administrating IBM Info Sphere DataStage server performance and usage.
  • Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
  • Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent.
  • Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS .

Environment: SQL Server 2012/2008R2, SQL Profiler, SQL Server Agent, T- SQL, Performance Tuning, SSIS, SSRS, Integration Tools, SSAS, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, Microsoft Visio 2000.

Confidential

SSIS/SSRS developer/Sr. MS SQL Developer

Responsibilities:

  • Developed, maintained and executed SQL scripts/queries and validated completeness, integrity and accuracy of data.
  • Designed, developed, and tested stored procedures, views and complex queries for creation of Reports.
  • Designed and developed Data Transformation Process (Extraction, Transformation & Loading) using Heterogeneous Sources to Destination (SQL Server).
  • Successfully created SSIS packages using Sequence Container, Data Flow, Execute SQL, Bulk Insert, Send Mail Task Etc.
  • Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, views.
  • Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.
  • Loaded flat files into SQL Server tables and vice versa using SSIS.
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Created graphical representation of data in reports by using graphs (such as Bar, Column, Pie) for quick data analysis and trending using SSRS.
  • Built the report models, created a wide variety of interactive reports for business users in SSRS 2008R2 and deployed the reports in various formats depending on the user requirements.
  • Created & used stored procedures for database transactions in SQL Server.
  • Created user groups and accounts for users who could access the reports.
  • Implemented SQL queries and stored procedures and validated code against designs.
  • Involved in Converting Crystal Reports to SQL Server Reporting Service.
  • Used SQL Agent for job scheduling.
  • Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient management.
  • Built and performed user acceptance testing on new and modified reports. Generated different types of reports like tabular, matrix, list and more.

Environment: MS SQL Server 2008R2, (SSRS), (SSIS), Views, SQL Agent, Data Flow, Profiler, MS Excel, T-SQL, Performance Tuning, Microsoft office Suite (Word, Excel and PowerPoint).

Hire Now