We provide IT Staff Augmentation Services!

Msbi Sql Server Ssis/ssrs/ Etl Developer Resume

Pittsburgh, PA

PROFESSIONAL SUMMARY:

  • Over 5+ years of extensive experience in database design and development using MS SQL Server 2016/2014/ 2012/2008.
  • Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.
  • Expert in Data Modeling and Multi - Dimensional Modeling.
  • Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse.
  • Proficient in using Power BI
  • Experience in SFDC Integration using Web Service and Salesforce.com
  • Proficient in MS SQL Server suite of products like TSQL, SSRS and SSIS of MS SQL Server.
  • Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
  • Exploring App exchange applications and integrating them with Salesforce.
  • Maintained securities, roles, subscriptions in report manager in SSRS.
  • Expert in designing SSAS cubes with slowly changing dimension, partitions, Aggregation and KPIs.
  • Excellent ability to develop complex Crystal reports using custom SQLs, use of unions, creating subquery sections etc.
  • Extensive experience of writing complex T-SQL queries, Views, Triggers, Functions and Stored Procedures.
  • Developed complex reports using SSRS and deployed into MS CRM.
  • Experienced in migrating reports from Crystal Enterprise to SSRS.
  • Extensive experience in creating SQL Server analysis projects using MS SQL Server.
  • Experienced in creating complex SSIS and DTS packages for ETL purposes.
  • Implemented complicated transformations to be used in SSIS packages.
  • Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
  • Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
  • Competent in MS Dynamics CRM, C#, XML, Fetch XML, HTML5, CSS, JQuery, JavaScript, SQL Server, SSIS and SSRS.
  • Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, RDB models, data dictionaries, and data integrity, SQL joins and query writing.
  • Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
  • Knowledge of Reverse and forward Engineering, Logical and Physical models, Dimensional Modeling.
  • Migration of data from Excel source to CRM using SSIS.

TECHNICAL SKILLS:

Database Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio (2012 / 2014 / 2016 / 2017 ), Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Teradata SQL Assistant

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SSRS (2014/ 2012/2008/2005/2000 ), MS Access, MS Excel, Crystal Reports, Tableau Desktop, Power BI

Database: MS SQL Server 2012/2008/2005/2000, MS Access, Oracle 11g/10g/9i

Programming: T-SQL, PL/SQL, C, ASP.NET 4.5/4.0/3.5, C#.NET, VB.Net

Web Technologies: HTML, DHTML, XML, XSL, Java Script, CSS

Operating Systems: Windows 2003/2008 Server, Windows XP, Windows 7, Windows 8, Windows 10

Other Tools: MS Office Suite (MS Word, Power Point, MS Visio), ERWIN, Toad, Accurev, GITHUB

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

MSBI SQL Server SSIS/SSRS/ ETL Developer

Responsibilities:

  • Worked with business stakeholders, application developers, and productions teams and across functional units to identify business needs and discuss solution options
  • Gathered requirements from business users
  • Agile methodology was used throughout the project, performed pivotal role in planning and developing as well as aligning with the assigned sprints
  • Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using for each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension and more
  • Performed ETL mappings using MS SQL Server Integration Services
  • Implemented Event Handlers and Error Handling in SSIS packages
  • Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases
  • Supported Production Environment by schedule the packages and make the package dynamic with SQL Server Package Configuration
  • Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
  • Created/Updated database objects like tables, views, stored procedures, function, packages
  • Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
  • Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete
  • Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS)
  • Involved in monitoring and tuning report performance by analyzing the execution plan of the report
  • Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS
  • Involved in table and index partitioning for performance and Manageability
  • Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance

Environment: MS SQL Server 2008/12/14/16, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer

Confidential, Dearborn, MI

SSIS/Power BI/SQL developer

Responsibilities:

  • Responsible for creating and designing SSIS packages.
  • Using Azure data warehouse for storing the data
  • Generating reports though power BI application
  • Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
  • Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
  • Use event handing to send e-mail on error events at the time of transformation
  • Use login feature for analysis purpose
  • Written some C# coding for automatic loading of metadata to SQL tables and mapping documents.
  • Added intelligent system in SSIS to identify actual change and new change in dimension
  • Worked with APS appliance for the Order Analytics Repository
  • Deployed reports onto the production and QA server through various ways
  • Created projects by two ways one is package deployment and project deployment
  • I also converted one project from package deployment model to project deployment model.
  • Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, SQL server)
  • Created Script task for calling the web services using VB Script by Postman
  • Used Power BI to compare data from one server to other server
  • Prepared the data mapping for all the migrated jobs using SSIS
  • Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance in order to tune them
  • Responsible for Development of the scripts (Perl and Shell) needed during the Data Migration phase of the project.
  • Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting
  • Worked with Microsoft experts for creating packages.
  • Created SSIS packages using CRM Dynamics
  • Created script to migrate SQL server object from one environment to another environment
  • Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
  • Modified the queries to achieve better performance
  • Designed ETL process using SSIS to extracted data from flat files, excel files and SQL server database
  • Built complex stored procedures in Azure and on APS
  • Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance
  • Wrote Perl scripts to automate manual activities.
  • Worked on TFS for performing tasks
  • Used Accurev and GitHub for code repository

Environment: MS SQL 2008 R2/2012, SSIS, Azure, Power BI, APS, XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), SharePoint, DTS, Accurev, GITHUB, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Team Foundation Server, FTP & SFTP server, Perl scripting.

Confidential, Houston, TX

MSBI/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Responsible for creating and designing SSIS packages.
  • Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
  • Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
  • Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
  • Use event handing to send e-mail on error events at the time of transformation
  • Use login feature for analysis purpose
  • Added intelligent system in SSIS to identify actual change and new change in dimension
  • Design SSRS and excel reports, expense analysis, and balance sheet analysis.
  • Deployed reports onto the production report server through various ways
  • Worked on managing Tableau driven dashboards and reports
  • Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
  • Developed complex reports using SSRS and deployed into MS CRM.
  • Prepared the data mapping for all the migrated jobs using SSIS
  • Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance in order to tune them
  • Created SSIS packages using CRM Dynamics
  • Created script to migrate SQL server object from one environment to another environment
  • Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
  • Modified the queries to achieve better performance
  • Designed ETL process using SSIS to extracted data from flat files, excel files and SQL server database
  • Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
  • Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
  • Worked on migration of SSIS 2008 packages to SSIS 2012
  • Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
  • Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
  • Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
  • Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
  • Experience in working on different kinds of reports Parameterized Reports, Linked Reports, and Drill-through reports.
  • Wrote Python/Perl scripts to parse XML/JSON documents and load the data in database.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS, XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), Share point, DTS, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server.

Confidential, Houston, TX

QlikView developer/Data Ware House / ETL Developer

Responsibilities:

  • Worked with Business Intelligence team to learn about ongoing practices and processes.
  • Developed Reports & Interactive sheets as per the requirement of the clients.
  • Developed Dashboards using QlikView to monitor insurance and policy information.
  • Used various types of sheet objects for Dashboard creation.
  • Worked on QlikView and SAP database connection to extract the data and store it into QVD'S for best optimization practices.
  • Extensively worked with Variables and Aggregate functions.
  • Experience in use of Set Analysis for data comparison.
  • Developed complex Dashboards using KPI's, Filters, Variables and Prompts as per the client requirements.
  • Implemented multiple tiers of QVD architecture depending upon the complexity of the applications.
  • Implemented triggers to provide custom functionality in Dashboards.
  • Created event trigger and field event triggers and implemented Incremental reload.
  • Scheduled the Reloads as per demand and published Reports on the access point.
  • Involved in performance tuning & deployment of applications in QlikView environment.
  • Maintained the sheet security & controlled the sheets.

Environment: QlikView, QlikView Server / Publisher (QMC), SQL Server.

Confidential

Jr. SQL Developer (Intern)

Responsibilities:

  • Performed data conversions from flat files into a normalized database structure.
  • Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
  • Created Business Requirements, Design, Functional Specifications and Flowcharts.
  • Created DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
  • Data migration (import & export - BCP) from Text to SQL Server.
  • Created and managed users, roles and groups and handled database security.
  • Created Triggers to enforce data and referential integrity.
  • Development of T-SQL Stored Procedures for moving and maintaining synchronization of data between legacy system and newly developed application.
  • Expertise in using variables, property expressions, and script tasks in SSIS Integrated Database Maintenance jobs to perform full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Documented and maintained history of changes for future reference.
  • Developed & executed several Optimized queries in SQL.
  • Performance monitoring and tuning MS SQL Server.
  • Assisted the Application team in data modeling and T-SQL coding.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, Microsoft Office, Windows 2003/XP.

Hire Now