SUMMARY:

• Having 7+ years of experience in Analysis, Design, Coding, Testing, Migration, Production support and Implementation of Software applications.
• Having 3 years of experience on Tableau Business Intelligence/Business Analytics software.
• Solid experience of technical support in major financial institutions including Health Insurance, P&C insurance, Banking, media and Utilities.
• Expertise in Tableau, MySQL, Teradata, Oracle, Qlikview, Informatica, COBOL, PL/I, EASYTRIEVE+, CICS, DB2, SQL, XML, MS. Access, MS SQL server.
• Experienced on Tableau Admin activities, Multidimensional database and writing SQL queries
• IBM certified DB2 Database Administrator.
• Bachelor of engineering degree in Computer Science.
• Proficient in Document Management Software MS Office, MS Visio
• Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
• Able to handle different projects concurrently and Lead experience.
• Technical support to the team, reviews of deliverables, communication with offshore team, track all the deliverables and to impart on job training to the team.
• Experience in performing System, Functionality, User Acceptance, Integration and Regression testing.
• Expertise in ENDEVOR for configuration management.
• Experience on data warehousing concepts, ETL tool Informatica.
• Having good knowledge on Middleware tool, TIBCO.
• Self - Motivated, energetic, self-starter with excellent analytical, organizational and creative skills.

TECHNICAL SKILLS:

Programming languages: Tableau, Qliview, PL/SQL, XML, COBOL, PL/I, EASYTRIEVE+

Database: DB2, MySQL,MS. Access, MS SQL server, SSAS, Oracle, Oracle Essbase, Teradata

Operating Systems: MVS, z/OS, Unix

Middleware: Tibco, MQ series.

Others: Stored procedures, DB2 Utilities, IBM utilities, Visio

PROFESSIONAL EXPERIENCE:

Confidential,Mason,OH

Sr.Tableau Developer

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on EMPI databases and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Embedded Tableau views in to SharePoint
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.

Environment: Tableau Desktop 8.2, Teradata, Windows 2008 Server.

Confidential,Henderson,NV

Tableau Developer/Business Analyst

• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Prepared use cases and got reviewed with state of Nevada.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.
• Generated Dashboards by joining multiple complex tables.
• Prepared different views for Small business Health Options Program (SHOP).
• Generated dashboard for Finance team, provided security by using user filters.
• Trained CSRs on tableau software.

Environment: Tableau Desktop 8.1/8.0/ 7.0, SQL Server 2008/2012, Oracle 11g, Windows 2008 Server.

Confidential,St Louis,MO

Tableau Developer

• Interacted with business users for gathering requirements for BASV Projects Dashboards.
• Prepared Use cases and look and feel documents and got reviewed with end users.
• Generated Tableau dashboards for e-bills and paper bills comparison.
• Generated tableau dashboards with quick filters and sets for ICD9 codes connecting to Oracle Database.
• Generated adhoc Tableau reports on demand for providers.
• Generated Tableau reports with Trend lines.
• Generated Tableau Dashboards with Oracle Essbase multidimensional database.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Performed incremental extracts for OLAP database.
• Created actual sales and target sales view with Trend lines, table calculations to see the difference between each quarter.

Environment: Tableau 8.1, Oracle 11g database, SQL developer, Windows Server R122012, Microsoft Excel and Access Database.

Confidential,Minneapolis,MN

Business Systems Analyst

• Interacted with business users for gathering requirements for ITASCA Projects.
• Prepared Use cases and got reviewed with Business users.
• High level and low-level design prepared and got the signoff from SMEs.
• Wrote Project Technical Specifications.
• Coordinated for SIT and UAT testing.

Environment: Tableau 7.0/8.0, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Microsoft Excel.

Confidential,Chicago,IL

Sr. Mainframe Developer/Analyst

• Interacted with the Business Analysts for gathering the SAMI project requirements.
• Modified the Charge sheet systems for providing the required information for Informatica and SAP Projects.
• Designed Mainframe Migration requirements.
• Prepared the Charge sheet reports for books, magazines. Etc.
• Analyzed data and prepared the reports for different months.
• Migrated Natural programs to COBOL.
• Identified the issues in current system and proposed the required changes.
• Wrote programs in Natural/Adabas, COBOL, CICS, JCL, IMS and DB numbers.
• Wrote Adabas queries to capture the information from ADABAS database.
• Documented Monthly charge sheet flow by analyzing the jobs/programs.

Environment: NATURAL, ADBAS, VS COBOL II, IMS DB, MARK IV, DB2, VSAM, JCL, CICS, INTERTEST, Win-XP & z/OS.

Confidential,Boston,MA

Sr. Mainframe Developer

• Interacted with the Business Analysts for gathering the project requirements and Change-Requests.
• Wrote programs in Natural/Adabas, Easytrieve+, VS COBOL II, CICS, IMS DB, DB2, SQL, and VSAM by following coding and quality standards.
• High level and low-level design prepared and got the signoff without major deviations.
• Wrote Daily, Weekly and Monthly Reporting Programs in Natural/Adabas, DB2 for Houston General vendor.
• Provided excellent solution for Future Dates problem for entire application and designed, modified and tested Natural/Adabas Cobol, IMS DB programs.
• Automated check number generation for Mitchell vendor, it helped saved massive amount of time spent by end-users.
• Production bugs fixed, helped in reducing turnaround time for BAs.
• Solved all the Production abends within SLA.
• Project documentation handled though Share Point and updated Share Point during each activity, these updates extensively used at the time of Meetings.
• Worked on ad-hoc requests, and resolved issues on high priority.
• Lead/Coordinated with offshore team.

Environment: NATURAL, ADBAS, VS COBOL II, IMS DB, DB2, CICS, PREDICT, .NET, NATRUAL SECURITY JCL, MQ SERIES, Win-XP, z/OS & MVS

Confidential,Atlanta,GA

Sr. Mainframe Developer - Consultant

• Tuned up programs/Jobs for both Australia and New Zealand market within Commonwealth Bank. Used COBOL/ NATURAL/ADABAS/EASYTRIEVE+ / JCL / VSAM / IMS / CICS / IBM Utilities scan the DB2 databases and provide statistics for business side.
• Followed butterfly model for QA region testing. Test data prepared for Unit testing. Test results executed through Test Director.
• Handled Batch production support used OPC scheduler and Remedy tracking tool.
• Coordinated with offshore team.
• Designed and developed Wire transfer Forex conversion application, Implemented CICS F7/F8 logic by using TSQs/DB2 Scrollable cursors.
• Developed account migration modules for the Queensland market, due to legal compliance.

Environment: VS COBOL II, EASYTRIEVE+, JCL, OPC, IMS, CICS, MQ, Java, TEST DIRECTOR and DB2, Win-XP, z/OS & MVS

Confidential

Mainframe Programmer

• Interacted with the Business Analysts for gathering the project requirements and Change-Requests.
• Wrote programs in VS COBOL II, PL/I, Easytrieve+, IMS, IDMS.
• Developed Data Protection Act project from scratch.
• Wrote programs at 350 LOC (Lines of code) per week.
• Prepared high level and low level design documents for DPA project.
• Wrote programs for DPA project from scratch and tested within 15 days.
• Code review and Peer review handled.
• Wrote new JCLs/PROCs.
• Prepared and executed Test plans for unit testing, System Testing and User Acceptance Testing (UAT).

Environment: VS COBOL II, PL/I, EASYTRIEVE+, ASSEMBLER, JCL, IMS DB, IDMS, VSAM and DB2, Win-XP, z/OS & MVS.

Confidential,Bloomington,IL

Software Engineer

• Analyzed the actuarial data.
• Updated rating tables on monthly basis for various states.
• Involved in modifying factors modifying while calculating premium for the policies.
• Wrote programs in PL/I, VS COBOL II, IMS DB/DC, DB2, CICS, IDMS, ADSO, VSAM and DB code
• Code review and Peer review handled.
• Wrote programs to convert the flat files/IMS database into XML files.
• Writing new and fixing issues in STORED PROCEDURES.
• Test plans, test cases and test data prepared for testing.
• Conducted unit testing and Integration testing.
• Created PSBs in testing environment.
• Updated lotus notes documents for high level design and low level design.

Environment: PL/I, VS COBOL II, JCL, VSAM, IMS DB/DC, CICS, IDMS, ADSO, DB2, XML, STORED PROCEDURES, Win-XP, z/OS & MVS.