We provide IT Staff Augmentation Services!

Sr. Software Engineer Resume

Sunnyvale, CA

PROFESSIONAL SUMMARY:

  • 10+ years of IT experience in Data Visualizations, Reporting, Data Warehousing, Data Modeling and Data Analysis for various clients across diverse domains
  • 3+ years of experience in data visualizations/creation of dashboards using Tableau 7.0/8.0.
  • Worked in various roles as a developer, analyst to create BI reports, dashboards and visualizations using Tableau
  • Good knowledge of working with the R integration in Tableau
  • Good knowledge of RDBMS concepts, SQL, Oracle, SQL Server, Core Java, Perl
  • Excellent understanding of statistics and data analytics techniques using R package
  • Well acquainted with HADOOP platform and its application in ETL testing
  • A team leader with varied experience of handling teams ranging from 5-12 members
  • Worked on most of the product life cycle stages like development, testing, support and maintenance
  • Extensive experience in client interaction, on-site training and offshore team building
  • Extensively involved in requirement gathering, analysis and proposed best possible solution by developing POC's
  • 3 years experience in administration of CRM for Life Science and Chemical Analysis division of a Fortune 500, US multinational.

Technical Skills:

Area Tools BI Tools :Tableau 7.0/8.0+ Desktop, Tableau Server

Data Analysis: R package, SPSS, Advanced Excel

RDBMS: Oracle 10g, SQL Server 2000/2005, MySQL, MS Access

Big Data Technologies: Hadoop, Pig, Hive

Application Development: Java, Visual Basic, C

Data Modeling Tools: ERWIN, Dia

Cloud Platform: Amazon EC2

Web Technologies: PHP, HTML, XML

CRM: SalesLogix 6.2 and 7

Scripting: Perl, Python, Shell Script

Operating Systems: Windows NT/2000/XP, Unix, Linux, Windows Server 2003/2008

Professional Experience:

Confidential Sunnyvale, CA

Role: Sr. Tableau Developer Responsibilities:

  • Worked with end users to understand, elicit and analyze reporting requirements.
  • Gather data from different data sources MySQL, Mongo DB, Google analytics, Teradata and flat files.
  • Develop Tableau data extracts (tde files) from the above mentioned data sources using Pentaho Data Integration
  • Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user’s needs, standardizing dashboard’s size, look and feel etc.
  • Developed ad-hoc reports using Tableau Desktop and Advanced Excel
  • Created Sets, Parameters, advance calculations, Calculated Fields and functions for customizing calculations like dynamic sorting, filtering, parameter driven analysis etc.
  • Extensively used data blending capabilities within Tableau joining multiple sources for custom analysis.

Environment: Tableau 8.2, Pentaho Data Integration tool 5 .0, Teradata, MySQL, Mongo DB

Confidential Stamford, CT

Role: Sr. Software Engineer

Responsibilities:

  • Requirement gathering, analysis and development of Tableau dashboards
  • Designed and developed Tableau dashboards from scratch to support reporting and Business
  • Intelligence initiatives
  • Combined data from multiple data sources using Tableau desktop including Excel, SQL Server, Oracle
  • Prepared dashboards using complex calculations, parameters in Tableau
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, filters, calculated fields, Sets , Groups, Parameters etc., in Tableau.
  • Defined best practices for the dashboard and visualizations using Tableau
  • Extending support to clients for on-site installations

Environment: Tableau 8.0, Oracle, SQL Server, Apache Tomcat, Core Java, Flex,

Confidential

Role: Tableau Developer

Responsibilities:

  • Carry out feasibility study for the product on the Hadoop architecture.
  • Installed Tableau Server
  • Designing of dashboard for data health and diagnostics using Tableau
  • Created Tableau scorecards, dashboards using bar graphs, scattered plots, geographical maps, Gantt charts.
  • Worked on scheduling extracts and distribution of dashboards
  • Defined best practices for Tableau report development
  • Created incremental refreshes for data sources on Tableau server.

Environment: Tableau 8, Core Java, Java Servlets, Tomcat, HADOOP, MySQL, Amazon Redshift

Confidential

Role: Tech Lead

Responsibilities:

  • Developing data analysis pipeline using Perl and R package
  • Designed and developed Tableau dashboards from scratch to support reporting.
  • Used SQL scripts and aggregation functions and advanced charts for applications.
  • Given training /demos to users on Tableau Desktop/Reader.
  • Designing ETL schema complying with the project specifications.
  • Implement the statistical analysis strategies for knowledgebase discovery.
  • Development of Perl scripts used in ETL
  • Creation of metadata for ETL by integrating and mapping data from various data repositories.

Environment: Tableau 7, MySQL 5.0, Apache, Perl, PHP, R package, Kettle, Dia

Confidential

Role: Data Analyst

Responsibilities:

  • Requirement gathering and analysis, functional/technical specifications, development, deployment, Testing and overall coordination of the team.
  • Created schema of MAGE-OM classes in to tables according to the inheritance hierarchy.
  • Study and analysis of community standards like MAGE-ML, MIAME, MAGE-OM and GO.
  • analyzed and developed solution for data integration from LIMS(Laboratory Information Management System)
  • Created various ad-hoc Dashboards/Reports for day-to-day requirements making use of different views.
  • Created stored procedures and functions in Oracle 10g to retrieve the data required to generate reports.
  • Configuring Relational to Object mapping Java libraries and their integration into presentation layer.

Environment: Oracle 10g, Windows XP/Server 2003, Java 1.6, Perl

Confidential

Role: DW Admin

Responsibilities:

  • Installed, configured and customized the system for internal use.
  • User maintenance.
  • Porting of in-house data into BioMart for creation of customized DataMart
  • Query optimization and tuning for performance enhancement.
  • Writing data pipelines using Perl APIs for customized data import and export

Environment: BioMart 0.7, Perl 5.6, Oracle 10g, MySQL 5.1, Fedora 11

Confidential Pune-India
Role: Module Lead

Responsibilities:

  • Act as delivery-in-charge for all deliverables. The deliverables included small work packets like developing plug-ins, writing technical articles, online tutorials etc.
  • Handle all issues from product users on case to case basis.
  • Act as first point of contact for all product managers at client side.
  • Project Tracking and reporting using different measurement matrices.
  • Perform risk analysis for project on regular intervals.
  • Effort estimation, distribution and tracking of different tasks/work packets
  • Create and send reports to clients at regular intervals based on the SLA parameters.
  • Propose enhancements in the products to the client.
  • Create a knowledgebase system and upgrade it on continuous basis.
  • Conduct on-site/off-shore product trainings for clients.
  • To provide support to the in-house development and QA teams

Environment :Java 1.5, Oracle 9i/10g, Java, XML, Perl, R Package, MS SQL Server 2000, Robo Help, Agilent Gene Spring GX, Agilent DNA Analytics, Agilent eArray, Agilent FE, Agilent Synapsis

Confidential

Role: CRM Administration

Responsibilities:

  • Involved in interacting with the end user for requirement gathering and implementing new forms in the CRM.
  • Synching of data from local data centers to global data center and ensuring it's integrity.
  • Played key role in migrating CRM Systems from 6.2 version ( windows based) to 7.1 ( web version)
  • Created sales reports to compare current cycle and previous cycle sales.
  • Developed and executed test cases during the migration process.
  • Created stored procedures in SQL Server 2000 to retrieve the data required to generate reports.
  • Wrote scripts for porting of data from legacy systems.
Environment: SaleLogix CRM 6.2/7.1, SQL Sever 2000

Hire Now