EXPERIENCE SUMMARY

• Possess 8+ Years of professional experience in software industry with comprehensive noledge of all phases of software development lifecycle from requirement analysis to maintenance of a project
• Extensively worked on Tableau 8.x/9.x Desktop.
• Good experience on building dashboards using Tableau.
• Expertise in writing SQL Queries, sub - queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Good experience in managing, coordinating, planning and executing project.
• Experience in prepaid mobile processes
• TEMPHas good Technical Skills and worked for both Development and Operations Support Projects.
• Identify areas of opportunity and deliver solutions that meet teh business needs of customer
• Substantial development experience in SQL, PL/SQL, UNIX, Data Modeling
• Possess good communication skills and TEMPhas dealt with application users TEMPeffectively.
• Coordinated with Vendor and Client on all teh application related issues and actively participated in DR (Disaster Recovery) testing.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to teh end user requirement.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in teh organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

TECHNICAL SKILLS

Computer System: Special Software Windows 98, NT, XP, Windows 7,HP UNIX, Solaris Unix Oracle PL/SQL, SQL, UNIX / LINUX, Shell Scripting, ReportsACTIMIZE

Programming Languages: Oracle Workflow Builder 2.6, TOAD, SQL Developer,SQL Loader, OraExcel, Clear Case, CA Erwin, Tableau 8.x,9.x

PROFESSIONAL EXPERIENCE

Developer

Confidential, North Carolina

Responsibilities

• Developed PLSQL procedures for ‘Parameter Review’ project as per client requirement.
• Coordinating with teh clients to has clear insight of teh underlying business process and developing functional requirement documents.
• Active involvement in quality activities like implementation of process, maintenance of documents and project management.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• TEMPEffectively used data blending feature in tableau.
• All teh activities of Production Support Group
• Executed and tested required queries and reports before publishing.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Intial Experience on Java.

Environment TABLEAU Desktop 8.x/9.x, Oracle 11g,Java

Confidential

Developer

Responsibilities:

• Data mapping and modelling for vantage policy admin fields to InfoFactory Operation Data Source(ODS) which is IBM DB2 Data ware house.
• Extract data from vantage and load it into InfoFactory database.
• Load data from Info Factory ODS database to SQL Server Data ware house using SQL Server integration services (SSIS) ETL Tool.
• Load Data from Data warehouse to Data Marts based on report data requirements using SQL Server integration services(SSIS) ETL Tool
• Develop Reports based business requirements Meeting multiple customer needs.
• Providing consistently remarkable experiences.
• Coordinating with teh technical team to has clear insight of teh underlying business process and developing functional requirement documents.
• Active involvement in quality activities like implementation of process, maintenance of documents and project management.
• Using SSAS to fetch teh data from ODS to place in DW house and SSRS to generate reports from Data Marts.

Environment PL/SQL,CA-Erwin, MSBI

Confidential

Analyst Programmer

Responsibilities

• Involved in teh complete SDLC lifecycle of Order Entry Application for TTSL Prepaid System which is used to capture all teh Customer Application details for new connections.
• Involved both during Design and Development stages of application development by PL/SQL Programs, Designing JSF webpages and by writing UNIX / Linux Shell scripts
• Involved in development of new enhancements deployed for Confidential .
• Involved in both CR and PSG activities.
• Efficiently handled teh Customer escalations and teh activities of Production Support
• Worked on Performance related issues and fine-tuned system processes which were bottlenecks for teh system
• Streamlined all teh batch jobs in teh application and simplified teh maintenance activities.
• Documented all teh activities of Production Support Group
• Efficiently coordinated with other teams like DBA, Network and System admin in resolving application performance issues
• Involved in implementing teh Dedupe functionality for CDMA,GSM,T24,VMI-CDMA & VMI-GSM and making teh process online.

Environment Oracle 10g Database, HP - UNIX,JSF, J2EE, Web logic Server