We provide IT Staff Augmentation Services!

Tech Lead/sr Reports Developer Resume

2.00/5 (Submit Your Rating)

IndianapoliS

SUMMARY

  • 10+ Years of development experience with exposure to complete project life cycle including requirements analysis, design, development, quality assurance and deployment.
  • Functioned as Developer Lead in various reporting and application development projects.
  • Extensive experience in design and development using SAP BOBJ, Crystal Reports, Tableau software applications.
  • Have very good knowledge in Oracle, SQL Server and MS Access databases.
  • Proficient in writing test plans, test scenarios/test cases and documentation of test results.
  • Extensive experience and understanding of Data Analysis and Reconciliation necessities for various business processes.
  • Working in Multiple Projects at same time under stressful, deadline oriented environments.
  • I am highly self - motivated, goal oriented and committed to timely delivery.

TECHNICAL SKILLS

Packaged Software: Tableau Desktop 9 and 10 Versions (Tableau Visualizations and Dashboards), SAP BOBJ XI R2 and R3/R4 (Universe Designer, Web Intelligence, Desktop intelligence Reporting), BODS, SAP Crystal Reports 2008/2013/XI/2016, SAP Lumira, SAP BW, SAP HANA, Xcelsius 2008, Informatica, Cognos, Power BI, TrackWise and Darwin Applications.

Languages/Technologies: Java, C, Oracle SQL.

Database: Oracle, MS Access, MS SQL server.

O/S: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE

Tech Lead/Sr Reports Developer

Confidential, Indianapolis

Responsibilities:

  • Responsible for report estimations, report development, report testing, Bug fix, support and report implementation for TrackWise application.
  • Interacting with client and end users regularly, in order to develop reports required and to resolve the existing issues.
  • Develop and maintain 400 Crystal reports. Creating new Design documents, requirements in QC, updating scripts for formal Testing.
  • Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports
  • Good at using shared and global variables across crystal reports
  • Used Team Foundation Server for version control of the reports
  • Good experience in creating functions like WhilePrintingRecords, WhileReadingRecords etc. and in Migrating Crystal Reports from older versions to newer versions
  • Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports
  • Expert in creating various PL/SQL stored procedures, views, functions and temporary tables for data input to the Crystal Reports
  • Extensive knowledge in pre-defined functions like string, date, numeric, conversion and null functions of Crystal like isnull, inrepeatedgroupheader, monthtodate, lastfullmonth, lastfullweek etc.
  • Expert in writing complex formulae at the summary level and group level to implement the business logic
  • Involve in weekly status meetings with Client as Onsite Coordinator.
  • Develop Tableau Visualizations and Dashboards using Tableau Desktop (9.3 and 10.5 versions)
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
  • Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
  • Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Also, involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
  • Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Confidential

Sr Reports Developer

Responsibilities:

  • Develop and maintain Global Batch Release Raw Data and Global Stability Non Recon Raw Data reports.
  • Created Webi reports through report template in Web Application Designer.
  • Converted business requirements in business/technical requirement documents.
  • Designed web intelligence reports for dimensional hierarchical data
  • Involved in unit testing and User acceptance testing.
  • Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)
  • Wrote formulas, parameters and conditions, Query filters depending upon selection criteria.
  • Involved in Modifying and Performance tuning of the Existing Reports.
  • Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
  • Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
  • Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.
  • Extensively worked in Universe Designer to update it based upon the new requirements.
  • Modified existing universe and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and developed hierarchies and derived tables.
  • Exported the universe to BO Repository.
  • Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.

Confidential

Sr Reports Developer

Responsibilities:

  • Develop and maintain 15 WEBI reports.
  • Extensively worked in Query Panel by creating conditions, filters, Database ranking, sub queries.
  • Creating User Prompts, Conditions and Filters to improve the quality of report generation.
  • Scheduling Reports using scheduler Info view as well as CMC.
  • Working on Universe in Designer for creating simple universe.
  • Involve in requirement gathering from client in form of FS and Excel.
  • Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems in the Crystal Reports.
  • Extensively worked on providing and revoking access to users in CMC (Dev, Test and Production environments).

Confidential

Sr Reports Developer

Responsibilities:

  • Managing Issues/conflict, risks, changes, traceability, prioritizing requirements, baseline and release Coverage in HP Quality Center.
  • Co-ordinate with Test Team in Review test design spec, test case spec, creating metrics such that all scenarios covered as per testing scripts.
  • Involved in Formal testing of BO reports using HP Quality Center ALM
  • Involved in Formal testing of BO Universe using HP Quality Center ALM

Environment: SAP Crystal Reports, SAP BO, Informatica, TrackWise Application, Oracle SQL, TFS, Quality Center.

We'd love your feedback!