We provide IT Staff Augmentation Services!

Sr. Report/etl Developer Resume

5.00/5 (Submit Your Rating)

SfO

SUMMARY

  • Over 10 years of professional experience in IT industry as a Business Intelligence (BI) developer worked on various projects which includes technical environments not only Microsoft BI suite but also other BI tools and technologies such as Cognos, Teradata, Talend, XML,Tableau etc.
  • Experience in working at client location, Involved in MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS) and SQL Server Analysis Services (SSAS)
  • Extensively worked on Data Extraction, transforming the data by using SSIS. Proven proficiency at Data Transformations like Derived Column, Conditional Split, Aggregate, Multicast and Sort& Execute SQL Task, for each Loop, Slowly Changing Dimensions, Union All, Merge Join, Data conversion etc
  • Proficient in OLTP OLAP and Datawarehouse Design Concepts.
  • Experience in loading the data into Data Warehouse after applying the business logic and transforming the data
  • Involved in developing Transformations, worked in multiple projects as BI Developer in Designing ETL
  • Experience in Packages and Reports in development and implementation stages of the Projects
  • Hands on experience in creation of work flows with Tasks, Containers and various Transformations in SSIS
  • Good exposure in identifying various dimensions and facts to implement data - ware house architecture
  • Experience in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS
  • Experience and understanding of SSAS, OLAP Cubes, Measure Groups, Dimensions, Calculations, Partitions, Perspectives, Aggregations and Hierarchies
  • Created different Parameterized Reports which consist of report Criteria in various reports
  • Designed Reports, Sub Reports, drill though reports using various features like Charts, graphs, filters etc
  • Experienced inCognos 8, Report Netwith Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection
  • Generated multiple Enterprise reports using report studio, cubes as source and from SQL server database, which includes various reporting features such as group by, drill downs, drill through using cognos reporting
  • Knowledge on scheduling and bursting. Scheduled the reports to run automatically for particular time and send dat to emails. Generated the dashboards to display the data in different forms like daily, weekly, monthly basis using Cognos
  • Extensively usedFramework Manager,Query StudioandReport Studioformodel design,ad-hocreporting and advancedreport authoring
  • Defined and build the BI metadata layer based on the business requirements
  • Provided expertise in BI development and related implementation technologies
  • Assisted the testing team and facilitate the user acceptance testing (UAT)
  • Knowledge in Planning, Designing, developing and deploying Data warehouses / Data Marts with experience of both relational & multidimensional database
  • Data Ingestion to HDFS from various data sources. Analyzed large data sets by running HIVE queries and PIG scripts.
  • Good experience in writing the PIG scripts.
  • Experience in importing and exporting data from HDFS to Relational Database Systems and vice-versa using Apache Hadoop Eco-System
  • Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and loading usingTalend and designed data conversions from wide variety of source systems
  • Extensively created mappings in Talendusing tMap, tJoin, tReplicate, tParallelize, tJava, tJavarow, tDie, tAggregateRow, tWarn, tLogCatcher,tMysqlScd, tFilter, tGlobalmap etc
  • Knowledge of using Talend/ETL tool to import/export data
  • Experienced in versioning, importing and exporting Talend jobs. Set up Triggers for Talend jobs in Job conductor.
  • Had good knowledge on creating JILS in autosys and scheduling the jobs to run on desired time
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS

Databases/BI Tools: SQLServer2005/2008R2/2012/2014,Access Datawarehouse, SSIS,SSRS,Tableau,Talend, SSAS

Web Technologies: HTML5,CSS3Big Data Hadoop, HDFS,Hive,PIG

Programming Languages: SQL,T-SQL,MYSQL

IDE: Eclipse, Microsoft visual studio

Operating System: Windows vista, XP/, Linux, Ubuntu, Mac OSX

PROFESSIONAL EXPERIENCE

Confidential

Sr. Report/ETL developer

Responsibilities:

  • Developed Parameterized, cascading parameterized, multi level grouping in the reports
  • Created various types of reports like table, matrix, charts using SSRS .
  • Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports
  • Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
  • Performed unit testing of reports on QA databases
  • Generated reports using Global Variables, Expressions and Functions.
  • Developed drill down, drill through and subreports.
  • HIVE UDFs to in corporate external business logic into HIVE scripts
  • Developed join data set scripts using HIVE join operations.
  • Developed join data set scripts using PIG Latin join operations
  • WrittenHIVE jobs to parse the logs and structure them in tabular format to facilitate effective querying on the log data.
  • Involved in creatingHIVE tables loading data and writing queries dat will run internally in MapReduce way.

Confidential

Sr. Report/ETL Developer

Responsibilities:

  • Involved in doing the change requests and releasing them to production monthly as per the requirements
  • Created Talend Mappings to populate the data into dimensions and fact tables.
  • Broad design, development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings.
  • Designing and implementing a variety ofSSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder 3.0 based on the requirements.
  • Created the Tablix, Chart and ad-hoc reports using SSRS2012, and deployed them on to shared point.
  • Implemented Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized.
  • Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports
  • Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
  • Responsible for Monitoring and Tuning Report performance.
  • Configured the report viewing security for various users at various levels using Report Manager.
  • Designed, Developed and Deployed reports in MS SQL Server environment usingSSRS.
  • Experienced in Talend Data Integration, Talend Platform Setup on Windows and UNIX systems.
  • Created complex mappings inTalend 6.0.1/5.5 using tMap, tJoin, tReplicate, tParallelize, tJava, tjavarow, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.
  • Created joblets inTalend for the processes which can be used in most of the jobs in a project like to Start job and Commit job.
  • Created the JILS in autosys and scheduling them to run on scheduled time
  • Involved in running the monthly cycle where we extract the data from files and loading to teradata by submitting the mainframe jobs
  • Worked on teradata concepts like Bulk Insert, Fast Load, fast Export
  • Running and monitoring the autosys jobs to load daily data in order to complete the daily cycles.

Confidential

Report Developer

Responsibilities:

  • Designed Reports, Sub Reports, drill though reports using various features like Charts, graphs, filters, pie charts Using Cognos Reporting Tool
  • Created events using event manager and added the meta data, newly calculated columns to tables in physical layer and business layer to meta data using frame work manger in Cognos
  • Develop and maintained ETL process for data warehouse using custom Stored Procedures, Functions and Views
  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS)
  • Worked on building the relationship between tables in frame work manager
  • Developed Function, Views and Stored Procedure for reports.
  • Generated the alerts and trigger’s and created the events for sending mail to clients or end users for particular reports as per requirement using Event studio
  • Involved in the Design discussions of the Mappings for data loading
  • Generated Ad hoc reports using SQL queries as per client requirement

Confidential, SFO

BI Developer

Responsibilities:

  • Created packages for implementing ETL by using various control flow items for each loop, for loop and data Flow transformations execute SQL, conditional split, multicast, derived column, lookup, sort, union all etc. Did error handling while moving the data
  • Involved in developing Transformations like Aggregate, Conditional Split, Lookup, Execute SQL Task, for each Loop, Slowly Changing Dimensions, Union All, Merge Join, Data conversion etc.
  • Created different types of reports like Sub Reports, drill down, drill though reports using various features like Charts, graphs, filters etc. using SSRS.
  • Involved in creation review offunctional requirementspecifications and supporting documents for business systems, experience in database design process and data modeling process.
  • Extracted data from various sources like SQL Server 2008/2012, .CSV, Excel and Text file from Client servers and through FTP and Processed the data using SSIS and Generated reports using SSRS
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS).
  • Designing the cubes for reporting in SSAS as per the requirement along with calculated members and required hierarchies which also includes MDX queries.

Confidential

BI Developer

Responsibilities:

  • Migrated DTS Packages(SQL2000) to SQL Server Integration (SQL 2005)
  • Loading data into dimension, fact and aggregate tables by creating SSIS packages.
  • Involved in developing Transformations like Aggregate, Conditional Split, Lookup, Execute SQL Task, For each Loop, Slowly Changing Dimensions, Union All, Merge Join, Data conversion etc.
  • Creation of packages by using required transformations in SSIS.
  • Creation of Tabular, Chart, Parameterized reports using SSRS.
  • Designed Reports, Sub Reports, drill though reports using various features like Charts, graphs, filters etc.
  • Understanding the traditional database of the client, and understanding the architecture of the target Data warehouse.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS).
  • Designing the cubes for reporting in SSAS as per the requirement along with calculated members and required hierarchies which also includes MDX queries.

Confidential, Tucker, GA

BI Developer

Responsibilities:

  • Involved in building Data Marts and OLAP Cubes.
  • Analyze the source map documents and creating packages to move the data from source to destination.
  • Creating packages for implementing ETL by using various control flow items for each loop, for loop and data Flow transformations execute SQL, conditional split, multicast, derived column, lookup, sort, union all etc. Did error handling while moving the data.
  • Scheduled the ETL Package (Monthly) Using SQL Server 2005 Management Studio.
  • Develop the package for ETL process
  • Involved in creation of the package and was responsible for moving the package from development server to production server.
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, developing reports using MDX and SQL.
  • Used various report items like tables, matrix, sub reports.

We'd love your feedback!