Sql Bi Developer (ssis/ssrs) Resume
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.
