Sql Bi Developer/ssis/ssrs Resume
Phoenix, AZ
SUMMARY
- Over 8 years of IT experience in Capital Markets Banking / Financials/ Mortgages, Medical and Retail sectors as a SQL server Developer dat includes Database Design, Data modeling, Development, Implementation, Administration, ETL and Reporting of SQL Server 2012/2008/2005/2000.
- Expertise in Database Administration on Production Servers wif server configuration, performance tuning and maintenance wif outstanding troubleshooting capabilities
- Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
- Expertise in scripting T - SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
- Data Modeling - Hands on Data warehousing and Data Modeling tools like Erwin 4.0, Visio 5.0/ 2002.
- Expertise in creating and configuring SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
- Expertise in 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.
- Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
- Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
- Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
- Expertise in creating Report Models for building Ad hoc reports using SSRS.
- Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
- Expert in providing Enterprise Reporting solutions using SSRS, Crystal Reports, Performance Point Server, ProClarity and SharePoint Services.
- Proficient in building Star schema and Snow Flake schema depending on business requirements.
- Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies wif SSAS.
- Proficient in working wif Multidimensional Expressions (MDX).
- Expertise in creating Perspectives, Partitions, Design Aggregations and Cell Level Security in cubes using SSAS.
- Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
- Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
- Has very good knowledge in transactional replication, merge replication, and snapshot replication.
- Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
- Excellent communication and interpersonal skills wif very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and in a team.
TECHNICAL SKILLS
RDBMS: MS SQL Server 2000/2005/2008/2012, MS Access, Oracle 9i/10g, DB2.
Programming Languages: T-SQL, PL/SQL, C#, Java, VB scripts and UNIX Shell Script.
Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS).
Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.
BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), ProClarity OLAP tools, Performance Point Server 2007, MS Visio, Erwin, Crystal Reports 9.0/XI.
ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1
Web Technologies: XML, XPath, HTML, XSL, JavaScript, IIS.
Data Modeling: Visio 2007 and Erwin 4.1.
Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server.
Version Control: Visual Source Safe (VSS), Team Foundation Server (TFS)
PROFESSIONAL EXPERIENCE
Confidential, Phoenix, AZ
SQL BI Developer/SSIS/SSRS
Responsibilities:
- Managed security on Production and Development environments.
- Monitored teh complete environment for resource utilizations and to avoid any bottlenecks.
- Creating and maintaining various databases on Production and development environments usingSQLServer 2005/2000.
- Understanding teh business requirements, analyzing source system, source files, setting up teh goals for implementing teh new client.
- Created and executed SQL Server Integration Service packages to populate data from teh various data sources, created packages for different data loading operations for many applications.
- Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
- Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
- ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
- Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
- Involved inDatabase Backupandrecovery.
- Created and designed solutions dat use teh SSRS gateway to interface between SSRS and a web front end (ideally flex).
- Experience in modifying SSRS rdl (XML) which is teh primary role of SSRS gateway.
- Worked closely wif teh business users in defining and documenting reporting requirements in order to design, develop and maintained in SSRS 2008 R2.
- Comfortable mentoring others in my team for complex SSRS reports.
- Converted data types using Derived Column, Data Conversion Transformation.
- Designed and deployed reports wif Drill Down, Drill Through, Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.
- Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
- Created Ad-Hoc Reporting wif Report Builder and Programming Reporting Services.
- Converted various data files (CSV, XML and Legacy Flat Files) based on business logic using Script Task and Script Component.
- Configured and Maintained MySQL database servers.
- Administered MySQL database installations and upgrades, performance monitoring and tuning, backup and recovery, space management, capacity planning and resource utilization.
- Created SSIS Packages for Incremental Loading and slowly changing dimensions.
- Created logging, custom logging and error handling packages.
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Optimized teh performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance teh performance of databases.
- Created Development and Production support documents.
- Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
- Environment: SQL Server 2014/2012/2008 Enterprise Edition, Visual Studio 2008/2010, DB2, VBScript, XML, MySQL, Microsoft Visio, Windows 2003 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), Informatica Power Center 9.1/8.6/8.5/8.1/7.1, T-SQL, Team Foundation Server (TFS).
Confidential, Chevy Chase, MD
MS SQL BI (SSIS/SSRS) Developer
Responsibilities:
- Participated in gathering User Requirements and System Specifications.
- Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
- Wrote teh complex queries using joins, Sub-queries, common table expressions (CTE) in T-SQL.
- Created and executed SQL Server Integration Service packages to populate data from teh various data sources, created packages for different data loading operations for many applications.
- Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
- Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Used SSIS features like event handlers, property expressions, package configurations, transaction option and protection levels in teh packages.
- Design, deployment, and maintenance of various SSRS Reports in SQL Server.
- Created Cross-Tab, Drill-down, Drill-through, Parameterized, cascading parameterized and Sub-Report using RDL.
- Configured and Maintained MySQL database servers.
- Administered MySQL database installations and upgrades, performance monitoring and tuning, backup and recovery, space management, capacity planning and resource utilization.
- Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
- Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions
- Created Dimensions and cubes wif star schema using SQL Server Analysis Services (SSAS)
- Involved inStaging PartitionsandUsage Based Optimization (UBO)mechanisms for SSAS 2012 and 2008 OLAP databases.
- Involved inTabular Data warehouseandDAXoperations for SSAS 2012 and 2008 OLAP databases.
- Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
- Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non -production database code as well as T-SQL code from developers and QA.
- Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
Environment: SQL Server 2008/2005 Enterprise Edition, Visual Studio 2008/2005, Oracle, SQL, PL/SQL, T-SQL, XML, VBScript, C#, XML, Microsoft Excel, Windows Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MySQL, Team Foundation Server (TFS).
Confidential, Boston, MA
MS SQL BI (SSIS/SSRS/SSAS) Developer
Responsibilities:
- Created T-SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.
- Defined Check constraints, Business Rules, Indexes, and Views.
- Worked wif Exception handling wif @@error and wif Try/catch.
- Has good hands on experience working wif FTP component in SSIS and used Configuration Manager to retrieve teh passwords.
- Used teh SSIS Import/Export, migrated teh Heterogeneous Database such as Oracle and Access database, flat files to SQL server.
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
- Created Drill Through and Various Cross tabbed reports using SSRS.
- Developed various kinds of Tabular, Matrix, Drill-down, Charts and web receiving reports using SSRS.
- Defined calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
- Identified and Defined Key Performance Indicators (KPI) in SSAS 2005.
- Defined relationships between Measure groups and Dimensions.
- Conceptualized and Designed Logical and Physical Data Models using ERWIN.
- Configured replication servers and transactional replication between production & standby server for disaster recovery.
- Configured Snapshot replication for reporting, user acceptance test and development servers.
- Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning teh database. Implemented different types of constraints on tables.
Environment: MS SQL Server 2005/2008,MS Analysis Services 2005, MS Access, SSIS, SSRS, Erwin 4.1, Windows XP Professional/2008 Server, MS-Access, Oracle 9i, T-SQL, PL/SQL, XML, VB Script, Team Foundation Server (TFS).
Confidential - FSSA, Indianapolis, IN
MS SQL/SSIS/SSRS Developer
Responsibilities:
- Developed and optimized database structures, stored procedures, views, and user-defined functions for teh Application.
- Design and create SQL Database, tables, indexes, and views.
- Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes.
- Responsible for gathering/refining requirements from teh customer for developing reports.
- Developed physical data models and create DDL scripts to create database schema and database objects.
- Extensively used SSIS Import/Export Wizard, for performing teh ETL operations.
- Created SSIS Packages using Pivot, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task.
- Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
- Configured SSIS packages using Package configuration wizard to allow package run on different environments.
- Efficiently implemented Error handling in SSIS
- Created SSIS packages to load data from various data sources Oracle,DB2 and Flat files.
- Consolidate teh data load into ODS using SSIS
- Developed Query for generating Drill Down and Drill Through reports in SSRS 2005.
- Generated and formatted Reports using Global Variables, Expressions and Functions for teh SSRS reports. Designed and implemented stylish report layouts.
- Deploying SSRS reports to report server and managing report subscriptions.
- Involved in report snapshots to improve teh performance of SSRS.
- Provided day-to-day administration tasks like space and log management.
- Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
- Configured Snapshot replication for reporting, user acceptance test and development servers.
Environment: SQL Server2008/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), BCP, DTS, Import/Export Wizard, SQL Server Management Studio, DTS, MS SQL SERVER, T-SQL, Windows 2003 Server, XML, MS Excel and MS Access, Visual Source Safe (VSS), Crystal Reports, TOAD, visual studio 2008.
Confidential
MS SQL Developer
Responsibilities:
- Installed and Configured SQL Server 2005 Environment.
- Migration of databases from MS SQL Server 2000 to MS SQL Server 2005.
- Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
- Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
- Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Linked Servers.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports.
- Involved in writing source code using SQL, PL/SQL.
- Involved in analysis and design of teh system specification and gathering requirements and prepared teh document for proposed system.
- Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
- Experience in building star schema and snowflake schema depending on teh business data requirement.
- Monitored performance and optimized SQL queries for maximum efficiency.
- Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS.
- Developed user friendly GUI using HTML and CSS.
- Created UNIX Shell scripts for automating teh execution process.
- Worked in production environment wif supporting and trouble-shooting production processes.
- Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
Environment: MS SQL Server 2000/2005, Oracle 8i, T-SQL, VB, ASP.NET, Data Transformation Services (DTS), MS Excel, HTML, CSS, VB, XML, Microsoft Visual Source Safe, MS Visio 2007, SQL Server Management Studio (SSMS), SQL Profiler, Windows 2000 Advance Server.