SUMMARY

• Talented, Motivated and Result - Oriented IT professional & Certified Professional Scrum master with 9 years of experience, with expertise in areas such as programming, design, technical, functional, business and data requirement analysis, Reporting, Gap Analysis, Testing Cycles, End-User Training and Post Production Support.
• Lead a team of engineers, and analysts, in developing web-based software applications in 3-tier architecture (App/Web/Database)
• Expertise in creating and publishing complex, intuitive and innovative Reports/Dashboards/Storyboards in Tableau Software, and Ad-hoc SQL reports
• Worked closely with business users by participating Requirements Gathering Meetings, Working Sessions, and Brain-Storming sessions to gather/prioritize/track product requirements/bugs
• Strong Knowledge in Marketing/Advertising, Campaign Management, and Google Analytics Platform/Tool
• Certified Professional Scrum Master in Agile, and well experienced in Waterfall Methodologies
• Lead a team providing production support services for handful+ of applications, used by Cisco’s Marketing Team
• Well experienced in Perl, CGI, DBI, and HTML based systems, involving Oracle / Sybase databases.
• Very Strong in Perl and Unix / KSH backend scripting, and complex PL/SQL queries
• Managed the projects by closely working with the Project Managers and IT Managers
• Working knowledge in JavaScript, jQuery, AJAX, PHP, CSS3, Java, Python, LAMP, Data Warehouse, ETL, Informatica, Unica, Salesforce, Big Data, Hive, Amazon Redshift systems
• Acted as a liaison between the Stakeholders, Business Users, Product Owners, and Engineering team, and Support Team
• Good team player and experienced enough to lead a team/manage a project
• Excellent communication and documentation skills I'm currently in H1/work visa and am eligible to work with my current employer. I would need a H1 Transfer to work for your company.

TECHNICAL SKILLS

Programming Languages: Perl CGI/DBI, SQL, T-SQL, PL-SQL, Korn Shell (KSH), Java, PHP

Web Technologies: HTML / HTML 5, XML, XSD, XPath, JavaScript, CSS2/CSS3, AJAX, JQuery, Web Services

Databases: Oracle 9i/10g/11g, Sybase, MySQL, MS Access

Project Management: OpenProj, Smartsheet, Rally

Version Control: CVS, SVN, git, PVCS, MS Visual Source Safe (VSS)

UML: Use Case diagram, Dataflow diagram, Sequence diagram for modeling business scenarios and application flows

Reporting: Tableau, Clickstream (SAP BO - BI)

Testing Skills: Unit Testing, System Testing, Integration Testing, Smoke Testing

Tools: & Miscellaneous Toad, BCP, FTP, SendMail, CGI, DBI/DBD, CronTab, Aquadata, ERWin, MS Visio, BMC Remedy, HP Quality Center, Putty, Cygwin, SSH Tectia, FileZilla, Gimp, SQL Plus, Kintana, Apache Web Server, MS Office, WebEx, Jabber, SharePoint, Jive, Box, Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Sr. Data Analyst

Confidential - San Jose, CA

Responsibilities:

• Analytics consultant for the Marketing Insights and Operations Team at Confidential .
• Designing, developing and publishing Reports on Tableau Server, to aid marketing insights and operations.
• Extracting and Transforming data such as Breaking down Customers, Prospects into multiple segments across regions - as part of Data preparation for Reports
• Optimizing tableau reports for presentation, data insights, and performance
• Provided better user interaction with reports by creating Filters, URL Action, URL Filter, Image, Hyperlinks, Highlights, Sorting, Grouping, and using custom filters with Parameters.
• Created Oracle & PL/SQL Database objects such as Tables, Views, Procedures, Jobs etc for data quality and performance reasons.

Sr. Data Analyst / Tableau Developer

Confidential‏ - San Jose, CA

Responsibilities:

• Designed, Developed / Published the entire Reporting Module for GRS application, using Tableau Desktop and Server.
• Adhered to the Flow and Formatting of reports per the Business Users expectations.
• Applied advance features of Tableau namely LOD Expression, Table Calculations, Date / String / Numeric Calculations, IF / CASE/ IFNULL / ZN and several other logical functions
• Experienced in Data Blending, Different database join types in Tableau, Multiple Joins, Complex SQL, and Data Extract.
• Created complex reports such as Line Graphs with Dual Axis, Histograms, Map, Highlight Tables, Treemaps, Pie Charts, Packed Bubbles, Heatmaps, etc.,
• Optimized the performance of Reports by using Custom SQL, fine-tuning the Joins, and extracting Data.
• Added Reference Lines, Trend lines, and forecasting using Tableau built-in features.
• Created Reports for different devices such as Laptop, Tablet etc., and both for IT and Business Users.
• Exposure to Installation and Configuration of Tableau Server.
• Performed User Management, Project Management, and Ad-hoc Data Schedule in Tableau Server.
• Analyzed data in multiple databases to extract and create appropriate reports.
• Trained few business users on Basic Tableau User training, and provided support as needed.
• Defined best practices for Tableau report development.

Sr. IT Systems/Technical Analyst

Confidential ‏ - San Jose, CA

Responsibilities:

• Involved in the Initial Design, Development and Delivery for NSMS, GRS.
• Did Business, Technical and Functional analysis, and provided feasible solutions for NSMS, GRS, SR.
• Actively participated in brain-storming sessions with Product Owners, and Stakeholders.
• Helped in outlining project’s scope & goals with project standpoint, assumptions and business risks
• Authored several BRDs, FSDs, User Stories, and Use Cases
• Planned the Sprints, Phases/Releases and Maintained Product Backlog, User Stories, Defects, as Agile Methodologies
• Used Rally as platform for Agile methodologies
• Created HTML Mockups for needed use cases.
• Facilitated Development Team in solution Design, Reviewed & approved QA team’s Test Plan and Test Case Scenarios.
• Participated/Drove some UAT sessions on System Testing, Integration Testing with other Marketing Systems like Unica, Operation Data Store.
• Performed Sanity/Smoke testing during production releases
• Implemented scripts for Data Migration using Perl from the legacy system to NSMS, GRS
• Prepared customized reports on GRS usage/metrics for the Business Team, in terms of quarter-over-quarter, across Financial Year, using advanced SQL queries against the underlying Oracle database
• Developed the nightly/daily/hourly cron jobs that integrate data across multiple IT Datamart/Datastore systems such as MODS, UNICA with NSMS, GRS
• Pulled quarterly reports on the application hits #s from Clickstream tool
• Coordinated with Load Testing team to run Load Test and get recommendations on performance enhancement
• Created & modified Oracle Database objects such as Tables, Views, Index, Triggers, Jobs, Stored Procedures etc

Sr. IT Support Analyst / Engineer

Confidential - San Jose, CA

Responsibilities:

• Develop and Deploy tools for Content Management System and Reporting using Perl/CGI/DBI, Oracle, and UNIX.
• Analyzed and Fixed several bugs that existed in different transactional applications
• Lead and collaborated with the support team analysts and engineers in resolving the bugs, and maintaining the SLA.
• Participated in monitoring the applications health during peak hours or vital events.
• Worked extensively in the backend Oracle database - Created many Tables, Stored Procedures and Triggers etc.,
• Worked in performance tuning on PL-SQL queries used for pulling reports
• Created many lookup tables and views to speed up queries
• Developed Perl/CGI scripts for various user interfaces, backend automation jobs, process improvements.
• Created reports Dashboard using PERL, CGI, Oracle, and JavaScript
• Developed many PERL modules and packages, Debugged and Enhanced existing PERL script
• Provided data analysis and reporting using complex SQL queries
• Coordinated efforts between onshore/offshore team members

Software Developer

Confidential ‏ - Jacksonville, FL

Responsibilities:

• Created many database objects including table, Stored Procedures and Triggers
• Enhanced several stored procedures to implement new business logic
• Designed, developed, tested and debugged application components and objects that were developed in either SQL, Sybase stored procedures, Sybase Triggers, Perl or Unix Shell Script according to technical specifications
• Worked in tuning the queries and stored procedures in Sybase
• Created several Perl scripts for Data clean up and Unix Shell Scripts for batch work /ad hoc queries / reports
• Developed unit test scripts and test data, done Unit testing, System testing and Documentation of the whole process