Msbi Developer Resume
Edison, NJ
SUMMARY
- 6 Years of experience in domain focused on Microsoft SQL Server 2008/2008R2/2012, SSIS/SSRS
- Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors
- Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS
- Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS)
- Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance
- Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process
- Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
- Excellent experience in generating Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users
- Involved in designing DTS/SSIS Packages to extract, load data into database, archive data file from different legacy systems and Data Mining in SSIS
- Writing SQL/TSQL, Stored Procedures, Functions, Triggers, Views in SQL Server
- Migrated data from external system including flat files, excel, MS Access and oracle into SQL Server 2008 using SSIS packages
- Extensive experience in Extract Transform Load (ETL) process using Microsoft SSIS
- Developed SSIS packages using various Control Flow and Data Flow tasks like Derived Columns, Condition Split, Execute SQL Task, Bulk Insert, Send email, FTP Task
- Good experience with SSIS package Configuration, Deployment
- Developed interactive reports using Crystal Reports and SQL Server Reporting Services
- Expert in performance tuning, query optimization and running database
- Expertise in writing T - SQL Queries using Joins, Sub queries and Cursors in MS SQL server 2008/2012
- Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, testing and implementing on production server
- Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production
- Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS
- Excellent analytical skills with Proficiency in debugging and Problem Solving
- Excellent communication, analytical, interpersonal and presentation skills
- Experience at working both independently and in a team-oriented, collaborative environment
- Excellent team player and can work independently under less supervision
TECHNICAL SKILLS
Microsoft Technologies: .NET4.0/3.5/3.0,ADO.NET
Web Technologies: XML, HTML, CSS, JavaScript
Languages: C#, SQL, Transact SQL, PL/SQL
Database: SQL Server 2008/ 2008 R2/2012, Oracle 11g/10g
Scripting Languages: Java Script, VB, PowerShell
ETL Tools: SSIS (SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)
Operating System: Windows XP, Windows 7, Windows 8, Windows Server 2003/2008
Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management StudioSQL Server 2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server
PROFESSIONAL EXPERIENCE
Confidential, Edison, NJ
MSBI Developer
Responsibilities:
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports
- Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder
- Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS
- Responsible for scheduling the subscription reports with Data Driven Subscription Windows File share and Email Delivery using SSRS
- Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end
- Worked on Report Subscription for Report Delivery using Email Delivery for the NFPs and FSA(Fed) Using Data Driven Subscription
- Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports
- Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, maintenance
- Developed complex packages which takes data from various sources like excel, Flat file, DB2, oracle using AS400 IBM and ODBC drivers, calling reporting service within the package to create SSRS reports on fly and calling web service to transfer data of XMl type
- Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
- Created schemas, keys and indexes considering the granularity of the data
- Designed Dataflow, Workflows and jobs to load data from source to target in BO Data Integrator
- Develop data staging tables and Create indexes in the destination table in order to make the ETL process faster than expected
- Deployed the packages in Production server and schedule the packages according to the requirements
- Deployed SSIS packages and Reports to Production Servers
Environment: SQL Server2012, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Server, Window 7 Professional, Microsoft Dynamics, Performance Point Server 2010
Confidential, Texas
SQL Server\ BI Developer
Responsibilities:
- Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005/2008 and Flat files
- Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
- Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc
- Implemented Event Handlers and Error Handling in SSIS packages
- Created SSIS packages for Data Conversion using data conversion transformation
- Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS
- Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008
- Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent
- Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package
- Involved in scheduling the backups
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
Environment: SQL Server 2010/2012, SQL Server Integration Service, T-SQL, Microsoft Reporting Service, Oracle 9i.
Confidential, Siler City, North Carolina
SQL Server\SSIS\SSRS Developer
Responsibilities:
- Created Tablix Reports, Matrix Reports, Parameterized Reports and Sub reports using SQL Server Reporting Services 2008
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports
- Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint ETL packages with different data sources (SQLServer, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages Involved in scheduling, creating snapshots and subscriptions for the reports
- Development, improvement, customization and deployment of SSRS reports in Business Development Studio
- Involved in creating Indexes, Constraints on database objects
- Created various Weekly and Monthly reports showing detailed information in SSRS
- Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling
- Experience in moving the data from heterogeneous data sources like oracle, xml to SQL using SSIS
- Hands on experience in using different transformations like fuzzy lookup, derived column transformation using SSIS
- Wrote queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder
- Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS
- Responsible for scheduling the subscription reports with Data Driven Subscription Windows File share and Email Delivery using SSRS.
- Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end
- Worked on backups scheduling
Environment: SQL Server 2008/2008 R2, SSIS, T-SQL, Microsoft Reporting Service, Oracle 9i, Performance Point Server 2007.
Confidential, Kansas City, MO
SSIS\SSRS Developer
Responsibilities:
- Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program in Development and Production server
- Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions
- Created SSIS packages to pull data fromSQLServer and exported to Excel Spreadsheets and vice versa
- Import/export using SSIS to/from MS Access, Excel, and Text file to SQL Server
- Loaded Data from various sources like flat files, Excel, Access, to SQL Server database Using SSIS Tools
- Creating SSIS Packages and built Reports using SSRS
- Created reports to retrieve data using Stored Procedures that accepts parameters
- Developed stored procedures to generate reports using SSRS
- Developed Drill-Down reports according to requirement using SSRS
- Developed triggers and stored procedures to in corporate the business logic and process
- Indexed views, dimensions and stored outlines for optimal performance
- Actively involved in Troubleshooting database performance issues
Environment: Microsoft SQL Server 2008/2008 R2, SSMS, BIDS, XML, SQL Server Reporting Services, .NET Framework 3.0, and Visual Source Safe. Excel Macros
Confidential, Kansas City, MO
SQL Server Developer
Responsibilities:
- Written Stored Procedures, complex queries, Views and Functions, Triggers inSQLServer 2008 environment.
- Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept
- Involved in Design, Development and testing of the system
- Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
- Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintained Referential Integrity
- Developed User Defined Functions and created Views
- Created Triggers to maintain the Referential Integrity
- Created complex Stored Procedures, DTS (Data Transformation Service) packages, triggers, cursors, tables, views
- Implemented Exceptional Handling
- Used Crystal Reports and MS Access to write complex formulas and to query the database to generate different types of ad-hoc reports
- Performed normalization of data base to reduce redundancy and achieve maximum system performance
- Used query analyzer to optimize queries and developed database and even configured based on the present need
Environment: Microsoft SQL Server 2008, SQLServer Management Studio, Crystal reports