We provide IT Staff Augmentation Services!

Etl/ssrs Developer Resume

4.00/5 (Submit Your Rating)

OBJECTIVE

  • To pursue a career full of challenges which provides me ample opportunities to learn and grow.
  • At the same time I want to fully utilize my capabilities to dedicate myself to the organization and add value to it by sincere efforts.

SUMMARY

  • 5 + years of extensive experience in analyzing, designing, developing, installing, configuring and deploying MS SQL Server 2012/ 2008/2005/2000 , Oracle and Informatica.
  • 5 years of experience with PL/SQL, T - SQL SQL Server in creating Tables, Views, Scripts, Indexes, Triggers, Complex stored procedures, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
  • 4+ years of experience in ETL tools Informatica Power Center, SSIS and reporting tool SSRS for SQL Server 2012/2008 and C# using dot Net framework.
  • Used XML parser and generator transformations to read/write XML data to relational tables and files.
  • Expert in using SSIS and Informatica to import data from multiple data sources and then applying various transformations to them before loading them into the destination.
  • Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
  • Expert in designingSSISPackages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided bySSIS.
  • Excellent experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
  • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging usingSSIS.
  • Strong Data Warehousing skills in Dimensional modeling using Star Schema/Snowflake schema.
  • Expert in using generating Visual Studio 2008/2005/2000 Client Side Report, Tabular Reports, Matrix Reports, Drill down Reports, Parameterized Reports, Ad-hoc Reports, and Stylish Reports usingSQL ServerReporting Services (SSRS).
  • Proficient in using global variables, expressions and functions for the reports.
  • Very good knowledge in scheduling and deploying reports on report manger.
  • Experienced in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
  • Proficient in using tools like SQL Profiler, index Tuning Wizard, Windows Performance Monitor, Database Engine Tuning Advisor for Monitoring and Tuning MSSQL ServerPerformance.
  • Excellent verbal/written communication skills and strong analytical abilities, and can perform well both independently and as a team player.

TECHNICAL SKILLS

  • DB2
  • RDBMS
  • Mainframe
  • SQL Server 2012/ 2008/2005/2000
  • MS Access 2010/2007/2003
  • Oracle
  • SSIS
  • SSAS
  • SSRS
  • INORMATICA 9.1 Power Centre(ETL)
  • Tableau
  • Crystal Report
  • TFS
  • T-SQL
  • PL SQL
  • C# .NET
  • DOS
  • Windows Server 2003/2005/2008
  • HTML
  • ISS and XML
  • XSLT
  • MS Office
  • Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential

ETL/SSRS Developer

Responsibilities:

  • Participated in brain storming technical solution with the team
  • Participated in validation and review data model- Designing (Technical Design) ETL interfaces.
  • Designed and maintained data warehousing artifacts and data dictionary and mapping design.
  • Created Complex Stored Procedures, Triggers, Functions (UDF), Indexes, Views, Scripts and other T-SQL code for the SQL applications following SQL code standards
  • Extensively used C# .net to implement various functionalities required in the ETL process like parsing complex XML files, validation of XML files against DTD/XSD, Error handeling, correcting the source flat files.
  • Written C# Scripts in Script components to implement folder watcher task for time popped loads.
  • Wrote various complex SQL queries for data profiling for data validation and data quality critical for data warehouse.
  • Optimized SQL queries, and long running Stored Procedures for improved performance and availability, and for effective data retrieval.
  • Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
  • Responsible for implementing error handling in ETL using C# in script component/Task.
  • Used Aggregate, Conditional Split, Union All, Lookup, Derived Column, Data Conversion, Multicasting and Merge Join Data Flow transformations in SSIS
  • Responsible for Coding, testing, performance tuning in developing Informatica mappings and workflows.
  • Created SSIS package using for each loop, sequence container to load multiple files from same source folder on different FTP location and to perform group task
  • Build & implement drill through drill down, parameterized and real time BI reports using SSRS.
  • Responsible for Deployment of the report using SSRS and used Report subscription (Email) to publish reports

Environment: SQL Server 2012/2008, Windows Server 2003/2008, C# .NET, Enterprise Manager, SSMS, SQL Server Business Intelligence Studio, SQL Server Profiler, Altova XML Spy, TFS, Excel, T-SQL, SSIS, SSRS, Informatica power center.

Confidential

ETL/SSRS Developer

Responsibilities:

  • Responsible for converting business requirement into functional and technical document.
  • Rewrite the existing code, queries, stored procedures for long running queries by replacing cursors with various joins, common table expression (CTE), indexing and applied MS best practices for query tuning
  • Used Aggregate, Conditional Split, Union All, Lookup, Derived Column, Data Conversion, Multicasting and Merge Join Data Flow transformations in SSIS
  • Analysis of source XML files to confirm its standards and well formedness.
  • Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling in the packages.
  • Written several C # scripts to implement SQL optimization through SQL Server metadata tables.
  • Reading the source XML files generated by the legacy system and parse them as per XSD given for the files and load data to relational target viz. MS SQL Server tables for further processing.
  • Generate XML files out of Relational tables to feed the other applications as per business needs.
  • Coding, testing, performance tuning in developing Informatica mappings and workflows.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers
  • Worked with end users to analyze data flow process and understand requirement for the finance reporting
  • Perform performance tuning, optimization, Bug Fixing and Enhancement during the various quality assurance testing cycles and for the Production dash board report using Database Performance monitoring tools
  • Created monthly and quarterly sales reports in tabular and matrix form using SSRS, maintained and enhanced the existing data warehouse reports
  • Interacted with testing team to fix the defects raised during the testing period.
  • Responsible for creating data mapping and data dictionary and ETL documentation.

Environment: SQL Server 2008 R2, SSMS, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, TFS,XML, Informatica 9.5, C# .NET, DB2, SQL, UNIX Scripting, Excel, T-SQL, SSIS,SSRS

Confidential

BI Developer

Responsibilities:

  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation
  • Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
  • Extensively used ETL/Informatica power center for loading the data from various sources involving flat files and oracle tables to Data warehouse.
  • Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
  • Extensively used ETL transformations such as lookup, merge, derived column, data conversion and aggregate etc.
  • Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
  • Wrote T-SQL queries, Store Procedures and used them to build packages
  • Created/Updated database objects like tables, views, stored procedures, function, packages
  • Handled slowly changing dimensions to maintain the history of the data
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
  • Created reports to retrieve data using Stored Procedures that accept parameters
  • Supported production operation activities, with focus on integration and development of new and existing products and services

Environment: MS SQL Server 2008, MS SQL Server Integration services (SSIS), MS SQL Server Reporting Services (SSRS), Informatica 9.5, DB2, Oracle, SQL, UNIX Scripting, and Excel.

Confidential

BI Developer

Responsibilities:

  • Responsible for requirement gathering and converting business requirement into functional and technical document.
  • Involved in preparation of High Level Design Document (HLD), Low Level Design Documents (LLD).
  • Extensively used ETL/Informatica for loading the data from various sources involving flat files and oracle tables to Data warehouse.
  • Developed and deployed ETL packages to load data from various sources to staging and staging to Data warehouse.
  • Worked with various ETL/Informatica transformations like Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
  • Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
  • Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
  • Wrote T-SQL queries, Store Procedures and used them to build packages
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
  • Developed and maintained ETL and data mapping documentation.

Environment: MS SQL Server 2008, MS SQL Server Integration services (SSIS), MS SQL Server Reporting Services (SSRS), Informatica 9.5, DB2, Oracle, SQL, UNIX Scripting, and Excel.

We'd love your feedback!