We provide IT Staff Augmentation Services!

Sql Bi Developer (ssis/ssrs) Resume

3.00/5 (Submit Your Rating)

Dublin, OhiO

SUMMARY

  • Over 7+ yearsof IT Experience in Database Design, Development and MSBI development in SQL Server 2005/2008 R2/2012 and deployed in various environments like development, testing and production.
  • Had great experience with several business domains like Financial, Healthcare Insurance.
  • Hands on experience in installing, managing, migrating, monitoring and troubleshooting SQL Server 2005/2008R2/2012.
  • Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
  • Expertise in TSQL - DDL/DML/TCL/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
  • Experience in report designing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading parameterized, and drill through, Table, Matrix, ad-hoc and Sub Reports.
  • Experience indeveloping,monitoring, extractingandtransformingdata using SSIS, Import Export Wizard, and Bulk Insert.
  • Sound Experience and understanding of SSAS, OLAP Cube and Architecture
  • Experience in deploying created reports in various sources like Web browser, excel and PDF.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
  • Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLEDBconnection from heterogeneous sources like (Excel, Oracle, flat file, Text Format Data)by using multiple transformations provided by SSISsuch asData Conversion,Conditional Split,Bulk Insert,MergeandUnion All.
  • Good understanding of Normalization/De-normalization and database design methodology.
  • Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, UDFs and Triggers on Microsoft SQL Server.
  • Good knowledge in Database backup, Replication, recovery, restoration, DTS and Linked servers.
  • Experience in maintaining database, re-indexing, index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
  • Managed indexes and tuned queries by using execution plan for optimizing the performance of the databases.
  • Delivered work product that meets specifications, are defect free, and have optimal performance.
  • Driven detailed definition of feature requirements through discussions with Product Management team and Involved in Production support whenever required.
  • Had good experience on developing error checking and resolution routines and Experience with SQL replication methodologies.
  • Ability to work in groups and an open attitude towards learning.
  • A team player and have the ability to work effectively with senior management in accomplishing objectives and able to deliver results and meet deadlines.

TECHNICAL SKILLS

RDMS: SQL Server 2005/2008/2008 R2/2012, MS Access

Languages: SQL, T - SQL, HTML, C, C++ and C#

Operating Systems: Windows XP/2003/2008

OLAP/Reporting Tools: SSAS, SSRS

ETL Tools: SQL Server Integration Services (SSIS).

Other Tools: Microsoft Visual Source Safe (VSS), TFS, Microsoft Office

Data Modeling Tools: Microsoft Visio 2000/2003 and Altova tool

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, BCP and SQL server profiler.

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server2008/2012 Analysis Services and SQL Reporting services, ProClarity, PPS-2007

PROFESSIONAL EXPERIENCE

Confidential, Dublin, Ohio

SQL BI Developer (SSIS/SSRS)

Responsibilities:

  • Worked with BA’s and other Developers to understand the existing system.
  • Make analysis and development plan accordingly.
  • CreatedER diagramsusing Microsoft Visio 2010.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
  • Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL in SQL Server 2008 R2.
  • Created SSIS Packages to load data from sources like Flat files, excel, OLEDB, XML, and Oracle to SQL Server.
  • Involved inMigrationof Databases fromSQL Server 2008 to SQL Server 2012 using SSIS.
  • As a part of Merging and Migration process, client requires stored procedure development using SQL server.
  • Created SSIS Packages using Derived Columns, etc. in SQL Server Integration Services 2008 (SSIS).
  • Experience in creating complexSSISpackagesusing proper control and data flow elements with error handling.
  • Designed Data flows, Workflows and jobs to load data from source to target.
  • Enhancing and deploying the SSIS packages from development server to production server.
  • Involved in creating jobs, Alerts and schedule SSIS packages using SQL Server Agent.
  • Essentially responsible for monitoring scheduled jobs and to ensure all packages are running without any disruption.
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS).
  • WorkedwithTechnicalArchitects and Database analysts for the Design of Summary tables required for efficient Report Design.
  • Experience in configuring and deployingSSRSreportsontoMicrosoft Office SharePoint Server.
  • Recommended, schedule, and perform software maintenance, improvements and upgrades.
  • Participated in a 24x7 on-call rotation for the systems supported by the Risk Mgmt. Group.
  • Participated in the aspects of the software development process including, requirements, designing, coding, unit testing, quality assurance, and deployment.
  • Identifying improvements to existing systems or processes to reduce occurrences of system issues.

Environment: SQL SERVER 2008 R2/2008/2012, Business Intelligence Development Studio, SSIS 2008, SSRS 2008, Microsoft Visio 2010 and TFS.

Confidential, Jersey city, NJ

SQL BI Developer (SSIS/SSRS)

Responsibilities:

  • Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
  • Extensively used T-SQL in constructing User defined Functions, CTEs, Views, Indexes, Relational Database Models and Data Integrity.
  • Created complex Stored Procedures, Tables, and Triggers, views and Joins using T-SQL.
  • Used catalog views and System Stored Procedures for Database maintenance.
  • Migrated DTS packages from SQL Server 2005 to SQL Server 2012 asSSISPackages.
  • Experience in creating complexSSISpackagesusing proper control and data flow elements with error handling.
  • Enhancing and deploying the SSIS packages from development server to production server.
  • Performed Documentation for all kinds of reports and DTS and SSIS packages.
  • Created Packages inSSISwith error handling and also created complexSSISpackages using proper Control and Data flow elements.
  • Used various ETL tools like SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from various sources to transactional database as well as data warehouse.
  • Created reports in SSRS with different type of properties likechartcontrols, filters, Interactive Sorting, SQL parametersetc…
  • Created SQL server Reports usingSSRS 2012.Identified the data source and defined them to build the data source views.
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS).
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder and deployed.
  • Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server.
  • Tidal jobs development and testing.
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
  • Designing and developing of small to large data warehouse/ETL solutions using SSIS.
  • Worked much with performance tuning including index design and partitioning.
  • Had great experience in Strong design, analytical and structured problem solving skills.
  • Good at Design, develop, test, optimize and deploy ETL packages to perform all data integration requirements.

Environment: MSSQL Server 2012 and 2008, T-SQL, SSIS, SSRS, VSS, Excel, SharePoint Server, Tidal Scheduler 5.3, OLAP and OLTP.

Confidential, Houston, TX

SQL/BI (SSIS, SSRS, SSAS) Developer

Responsibilities:

  • Actively participated and interacted with users,team lead, DBAs and technical manager to fully understand the requirements of the system.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Designed dynamicSSISPackages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments.
  • UsedSSISto integrate data from existing system and performed transformations on MS SQL Server 2008.
  • Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services(SSRS).
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX language.
  • Designed and implemented DataMart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities and provide technical documentation of the system.
  • Providing technical leadership to ETL developers assigned to projects.
  • Providing quality project oversight for all activities related to data consolidation, data integration, data transformation and data quality.
  • Developing design specifications, unit test plans, and troubleshoot client issues. Work with a diverse project team with an emphasis on repeatable processes and technical documentation.
  • Performing hands-on design, development and testing within the ETL tool environment using a mixture of GUI driven tools and hands-on SQL.
  • Working knowledge of batch files processing and scripts.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS),SQL Server Analysis Services(SSAS), Proclarity and Windows 2008 Server.

Confidential, Dallas, TX

MS SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

  • Understand the requirements which are provided in BRD.
  • Designed and created the schema andstored proceduresthat will be used in Data QC.
  • Stored Procedures development, Unit testing and Integration Testing.
  • Converted Data Transformation Services(DTS)application to SQL Server Integrated Services(SSIS)as assigned.
  • Developed dtsx packages to extract, transform and load into the OLAP database from OLTP database using SQL Server Integration Services(SSIS).
  • Created packages in SSIS Designer using Control Flow and Data Flow transformations to implement business rules.
  • Involved in developing SSRS reports as per the client requirement.
  • Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
  • Generated several drill down and drill through reports usingSSRS.
  • Created high level multi-dimensional cubes and processed the huge data using SSAS. Expert in creating Star schema cubes usingSSAS.
  • Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Experience extracting data from a large variety of sources, transforming and loading to a SQL data warehouse.
  • Evaluate and address data quality issues.
  • Interacting with customers regarding application requirements.
  • Analyzing technical requirements and recommend ETL strategies and provide visual representation of designs.
  • Working with the team on architecture design and detailed technical design for BI and Analytics solutions.
  • Handling Customer issues at effective pace.

Environment: SQL SERVER 2008, SSIS 2008 and SSRS 2008, SSAS 2008, ProClarity.

Confidential

SQL Developer

Responsibilities:

  • Understand the requirements which are provided in BRD.
  • Gathered requirements to identify and create database objects such astables,views,triggersand Indexes.
  • Involved in Normalization of the database and bringing it to3NF.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Extensively used T-SQL in constructing User defined Functions, Views, Indexes, Relational Database Models and Data Integrity.
  • Created complex Stored Procedures, Tables, and Triggers, views and other SQL Joins and Statements for Applications by using T-SQL.
  • Involved in creating theconstraintsandtriggersto maintain the data and referential integrity.
  • CreatedViewsto enforce security and data customization.
  • CreatedNon-Clustered indexesto improve query performance and query optimization.
  • Involved in theperformance tuningand optimization ofT-SQLqueries.
  • Created StoredProceduresforcommonlyusedcomplex queries involving join and union of multiple tables.
  • Taken the ownership for issues to reach resolutions to prevent recurrences.
  • Following change management process to resolve application defects or to implement development enhancements.
  • Participated in staff, team, project and planning meetings as needed.
  • Supporting deployment of custom solutions when required to meet business needs.
  • Working closely with QA to define test plans and test cases for applications.

Environment: SQL SERVER 2005 and Microsoft Visio 2003, SSIS and SSRS 2005.

Confidential

SQL Developer

Responsibilities:

  • Requirement gathering from the client.
  • Actively involved in Normalization of database.
  • Designed DDL and DML for MS SQL Server 2005.
  • Creating tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Worked on SQL/T-SQL Queries and Stored Procedures in an effective way.
  • Optimizing query performance by creating indexes and involved in writing SQL batch scripts.
  • Analyzing technical requirements and design new data models or update existing data models.
  • Following enterprise wide standards for maintenance and high performance.
  • Monitoring and Performance Tuning, Physical Server Level, Database level (Database settings and options) and query tuning, settings, monitoring CPU usage and Disk I/O activity etc.

Environment: MS SQL Server 2005, Microsoft Visio 2003, SSIS 2005.

We'd love your feedback!