Data Analyst And Ssis/ssrs Developer Resume
VA
SUMMARY:
- 6+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2012/2008 R2/2005 in Production, QA and Development Environments.
- Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
- Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to teh business requirements.
- Strong experience wif T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking teh database consistency by executing DBCC Commands.
- Experience in implementing solutions and developing wif .NET Framework.
- Involved wif programming languages C#, XML.
- Proficient in setting up and troubleshootingASP.NETconfiguration files.
- Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
- Expertise in SQL Server 2005/2008 R2 Reporting Services (SSRS), SQL Server 2005/2008 R2 Integration Services (SSIS) and in SQL Server 2005/2008 R2 Analysis Services (SSAS) in Business Intelligence (BI).
- Hands on experience wif performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2/2012).
- Excellent noledge of Scheduling Jobs and Alerts using SQL Server Agent.
- Ability to work in all stages of System Development Life Cycle (SDLC).
- Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
- Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled teh Reports in Report Manager.
- Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
- Experience in Interacting wif Business users to analyze teh business process and transforming requirements into screens, performing ETL, documenting and rolling out teh deliverables.
- Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
- Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
- Experience in .NET/C# application development environment to use SQL Server Databases.
- Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
- Good noledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Misanalysis Services.
- Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
- Involved in design of logical and physical data modeling using Erwin data modeling tool.
- Worked wif Business Analysts, Web development team, and users on database solutions.
TECHNICAL SKILLS:
Operating System: Windows NT 4.0, Windows 2000/2003/2008 R2 Enterprise/Datacenter Server, XP Professional, UNIX.
Databases: MS SQL Server 2012/2008 R2/2005/2000, MS Access, My SQL
Programming Languages: T-SQL, C, C++, Shell Scripting, SQL, XML, C#, VB.NET, MDX
Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook.
Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer, SQL Client Utility.
Reporting Tools: Reporting Service (SSRS) 2000/2005/2008 R2/2012
ETL Tools: DTS, SSIS.
MS Tools: Management Studio, Visual Studio. Share Point, TFS 2012.
Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP
Other Tools: Source Depot, Octopus, JIRA
PROFESSIONAL EXPERIENCE:
Confidential, VA
Data Analyst and SSIS/SSRS developer
Responsibilities:
- Involved in complete SDLC life cycle.
- Extract, Transform and Load source data into respective target tables to build teh required data marts.
- Understand user requirements and Data Model defined and developed by teh business analysts and data architects.
- Experience in implementing solutions and developing wif .NET Framework.
- Involved wif programming languages C#, XML.
- Proficient in setting up and troubleshootingASP.NETconfiguration files.
- Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
- Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
- Implemented different types of constraints on tables.
- Designed and applied entity and attributes description and definition for teh models.
- Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases.
- Maintained teh physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
- Migrated data from IBM-DB2 to SQL Server 2008/2012 wif SQL Server Integrated Services (SSIS).
- Created ETL process using SSIS to transfer data from heterogeneous data sources.
- Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
- Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
- Done migration from SSIS 2008 to SSIS 2012.
- Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
- Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
- Develop/Build/Deploying all teh database and ETL objects using TFS 2012.
- Responsible for gathering business requirements to create business user reports.
- Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
- Developed optimal stored procedures and queries to create data sets for reports.
- Created SSRS Reports on teh top of teh cube using some MDX queries.
- Responsible for scheduling teh subscription reports wif teh subscription report wizard.
- Migrating COGNOS reports to SSRS.
- Worked on performance tuning on existing stored procedures and existing reports for teh faster processing of reports.
- Developed Cube wif Star Schema.
- Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.
Environment: MS SQL Server 2008 R2/2012, DTS, T-SQL, XML, Flat File, SQL Server Reporting Services, Visio, IIS, Windows XP/7,TFS 2012
Confidential, Plano, TX
Data Analyst and SQL Server/SSIS/SSRS Developer
Responsibilities:
- Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for teh application.
- Involved in designing teh physical databases model on SQL Server 2005/2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
- Extensively used T-SQL to manipulate and architect to produce results for users.
- Performance tuning of Queries and Stored Procedures.
- Experience in implementing solutions and developing wif .NET Framework.
- Involved wif programming languages C#, XML.
- Proficient in setting up and troubleshootingASP.NETconfiguration files.
- me Used SQL profiler to view indexes performance to mostly eliminate table scan.
- Worked wif development teams in teh design of physical databases and in modification.
- Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
- Good understanding of Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
- Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
- Worked on various complex requirements of developing monitoring dashboards wif multiple KPIs in Performance Point Monitoring Server 2007, Share point.
- Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
- Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
- Created SSIS process design architecting teh flow of data from various sources to target.
- Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
- Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
- Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
- Created ETL SSIS packages both design and code to process data to target databases.
- Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
- Constructed OLTP and OLAP Databases.
- Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
- Created calculated fields wif MDX code to meet additional measures needs that are calculated from existing measures.
- Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
- OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
- Used Notification services to generate error messages and send them to teh user through e-mails, pager messages, and PDA as well as window messengers.
- Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
- Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Source Depot, JIRA.
Confidential, Atlanta, GA
SR. SQl Server ETL SSIS/SSRS Developer
Responsibilities:
- Responsible for Logical & Physical Design of teh Database
- Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults
- Creation of New NT User Logins and granting privileges to users/Groups and objects
- Used DBCC(Database consistency check commands) to check physical and logical consistency of teh databases and Rebuild indexes
- Backup and recovery of Master, MSDB and Application databases
- Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current
- Implemented log shipping and performed changing roles when production data base goes down.
- Responsible for Query optimization and Performance tuning
- Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications
- Worked extensively on DTS Package designs for Import/Export from various Data Source Flat file, Excel, MS Access to MS SQL Server and schedule teh jobs in SQL Server
- Extensively worked wif Command-Line Utilities like BCP, Net Start, Net Stop, ISQL/OSQL, DTSRUN, DTSWIZ, ITWIZ, ODBCCMPT, REBUILDM
- Implemented in Linked Server setup, which allows access to teh distributed, heterogeneous queries against OLE DB data sources for EXCEL, MS ACCESS and Text files.
- Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments
- Monitor Server Level Blocks/deadlocks & Maintain all teh OLTP Servers wif Maximum Database Availability, Reliability & Investigate and resolve any Database Related issues /performance related issues wif Minimal Downtime & Maximum Reliability
- Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
- Setup Transactional Replication and maintain teh servers.
- Performed SQL Server 2005 installation and Upgrade in Test, Development, QA & Production servers.
- Implemented database mirroring in SQL server 2005.
Environment: SQL Server 2005/2000 T-SQL, Excel, Advanced Windows 2003 Server & PVCS Version Control Management, MS
Confidential, Milwaukee
SQL Server/SSIS/SSRS Developer
Responsibilities:
- Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for teh application.
- Involved in designing teh physical databases model on SQL Server 2005/2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
- Extensively used T-SQL to manipulate and architect to produce results for users.
- Performance tuning of Queries and Stored Procedures.
- GeneratedComplex reports in Cognos 10.1 report studio including Drill down reportsfrom DMR modeled Frame work model.
- Cognos Administration: Defined roles and permission and matched them across all environments for multiple applications (linked teh reports to dashboards
- me Used SQL profiler to view indexes performance to mostly eliminate table scan.
- Worked wif development teams in teh design of physical databases and in modification.
- Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
- Good understanding of Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
- Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
- Worked on various complex requirements of developing monitoring dashboards wif multiple KPIs in Performance Point Monitoring Server 2007, Share point.
- Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
- Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
- Created SSIS process design architecting teh flow of data from various sources to target.
- Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
- Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
- Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
- Created ETL SSIS packages both design and code to process data to target databases.
- Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
- Constructed OLTP and OLAP Databases.
- Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
- Created calculated fields wif MDX code to meet additional measures needs that are calculated from existing measures.
- Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
- OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
- Used Notification services to generate error messages and send them to teh user through e-mails, pager messages, and PDA as well as window messengers.
- Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
- Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Source Depot, JIRA
Confidential
SQL Server/BI Developer
Responsibilities:
- Installation of MS SQL enterprise servers on test and development boxes.
- Designed and Created databases, tables, views, stored procedures and triggers.
- Created groups, roles, users and assigning access privileges to users.
- Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
- Monitored and scheduled existing/new jobs on production environment.
- Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
- Worked to tune teh SQL queries using SQL Profiler.
- Tested backup and recovery strategies in a test environment before and after moved to production environment.
- Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones.
- Migrated data from SAS environment to SQL Server 2005 wif SQL Server Integrated Services (SSIS).
- Created ETL process using SSIS to transfer data from heterogeneous data sources.
- Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
- Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
- Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
- Responsible for gathering business requirements to create business user reports.
- Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
- Developed optimal stored procedures and queries to create data sets for reports.
- Designed and implemented stylish report layouts.
- Generated Reports using Global Variables, Expressions and Functions for teh reports.
- Responsible for scheduling teh subscription reports wif teh subscription report wizard.
- Played a Content Manager role on report server.
- Worked on performance tuning on existing stored procedures and existing reports for teh faster processing of reports.
- Designed SSAS cube to hold summary data for Target dashboards.
- Developed Cube wif Star Schema.
- Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
Environment: MS SQL Server 2005, MS SQL Server 2000, Windows 2003 Server, T-SQL, SSIS, SSRS,SSAS, ASP .Net, VB.net