SUMMARY:

A result - oriented professional with 9+ years of IT experience in Software Development & Testing of Web, Mobile, Apps, Cloud-based, & Client-Server applications.

Software Testing Expertise:

• Proficient in Manual Testing, Software Development Life Cycle (SDLC), Testing Life Cycle (STLC)
• Skilled at using commercial tools like HP-QC
• Adept at developing, debugging, enhancing & executing Test scripts and Authoring Test cases
• Active participation in the development of Test Strategies, Plan, review of Test cases (Peer Reviews)
• Expertise in conducting Smoke, Functional testing and proceeding with Defect tracking system
• Re-testing and Regression testing on the modified build and performing System testing
• Participation in Integration testing of various applications and Database testing
• Dealt with Cloud & Mobile based testing
• Leading onsite and offshore teams ensuring timely completion of the project
• Preparation of Test Metrics, Monthly, Weekly & Daily status reports

Software Development Expertise:

• FINACLE implementation for Multi-National banks South East Asia.
• SQL database experience in a High transaction and multi-server production environment.
• Hands on experience in MS SQL Server 2012/2008R2/2005 within SQL Server Integration Services, SQL Server Reporting Services.
• Creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints in T-SQL.
• Expert in working with Business Intelligence Development Studio (BIDS) which includes SSIS, SSRS.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Extensive experience in generating different type of reports including: Parameterized queries, Formatted Reports, Tabular forms, Matrix (cross Tab report) form, Cascading, Drill Down, Drill through, List items, Charts and Sub reports using SSRS 2012/2008(R2).
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Excellent Knowledge of Star/Snowflake Schemas.
• Experience with Database Tuning Advisor, Performance Monitor and SQL Profiler for tracing and auditing.
• Extensive experience in using SQL Profiler, System Monitor, Query Analyzer and Performance Monitor for Troubleshooting, Monitoring, Optimization and Tuning of SQL Server and SQL code.

TECHNICAL SKILLS:Tools : SQL Server Management Studio (SSMS), BIDS, SQL Profiler, Query Analyzer, Performance Monitor, Database Engine Tuning Advisor, SQL Mail.

DBMS/RDBMS : MS SQL SERVER 2012/2008R2/2005000.

ETL Tools : SQL Server Integration Services.

Reporting Tools : SQL Server Reporting Services, MS Excel, and Report Builder 3.0.

Languages : SQL, T-SQL, PL/SQL, and FINACLE Scripting.

Data Modeling : MS Visio

Other Technologies: HTML, CSS, and JavaScript.

Testing tools: HPQC

Operating Systems: Microsoft Windows XP/Vista, Microsoft Windows Server 2003/2008R2 and UNIX.PROFESSIONAL EXPERIENCE:

Confidential, CA

Technical Test Lead

 Responsibilities:

• Single Point of Contact for Email Campaigning Program. Successfully completed 7 Campaigns in 2016 and prepping-up for 2017 Campaigns.
• Defining Test Strategies-Approach, Reviewing Test Plan & Cases, Leading offshore team, and perform duties of onsite coordinator.
• Collaborate with Business Stake holders, IT development & PMO teams to ensure that the quality metrics are reviewed, closed and agreed upon.
• Reviewing status reports and taking appropriate actions accordingly.
• Sending crisp and clear status to the higher management.
• Creating and defining risks contingencies and plans.
• Understanding and defining areas to calculate the overall risk to the project.
• Creating strategies to mitigate those risks and take necessary measures to control the risks.
• Awareness to all the stake holders for the various risks
• Create backup plans for all the testing strategies.
• Have team meetings at appropriate time to understand & review the current risks and motivate team to resolve the same.
• Work with the development team to ensure that the quality engineers get apt support like automation hooks or debug builds where ever and whenever possible.

ENVIRONMENT: Exact Target Cloud Based Platform, Mobile Apps testing, CRM, Web-Portal, Public Website, Email Campaign.

Confidential

Technology Analyst

 Responsibilities:

• Provided customization support for SIT and UAT for both DBS China and Taiwan go-live
• Onsite coordinator & module lead for loans and payments.
• Worked for customization of EMOC 2, EMOC 4, WMS, SGAUTO Loans, LMS, TZRETT, CBG and IBG projects
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different data transformations (DTS) using SSIS.
• Implemented Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.
• Worked with Business users to refine requirements.
• Experienced in troubleshooting production servers and user and application issues.

ENVIRONMENT: FINACLE, JavaScript, WebSphere Studio Application Developer, Jasper Reports, SSRS
Confidential

Senior Software Engineer

 Responsibilities:

• Lead 8-member team in Payment Module
• SIT and UAT support: Fix issues raised by testing team and End users of the product
• Interact directly with bank users to seek clarifications and provide solutions.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.

ENVIRONMENT: Finacle Scripting, C, HTML, JavaScript, Toad, Web Sphere.77.7
Confidential

Senior Software Engineer

Responsibilities:

• Coordinated for FINACLE pre-sales in providing POCs for Finacle Customization and Reports
• Worked across various modules in Finacle Product.
• Involved in customization of UI - Menus, Tabs, Look-ups, Hyperlinks, Forms and Reports in 10.x version
• Created BATCH jobs to automate ‘Charges Collection‘ activity.
• Worked on report customization using iReport and PL-SQL.

ENVIRONMENT: MS SQL Server 2008R2/2008,SSIS, SSRS2012/2008, T-SQL, TFS, Finacle Scripting, Java Script, CSS, HTML
Confidential

Senior Software Engineer,

Responsibilities:

• Coordinated for FINACLE pre-sales in providing POCs for Finacle Customization and Reports
• Worked across various modules in Finacle Product.
• Involved in customization of UI - Menus, Tabs, Look-ups, Hyperlinks, Forms and Reports in 10.x version
• Worked on report customization using iReport and PL-SQL.

ENVIRONMENT: MS SQL Server 2008R2/2008, SSIS, SSRS2012/2008, T-SQL, TFS, Finacle Scripting, Java Script, CSS, HTML
Confidential

Software Engineer

 Responsibilities:

• Created and maintained database objects.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Created various reports using MS Reporting Services 2000.
• Tuned complex SQL Queries.
• Loading data from various data sources using MS Data Transformation Services.
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.
• Involved in various phases of SDLC.
• Analyzed the estimated execution plan of complex stored procedures and tune the badly or slowly performing queries to improve performance.
• Participated in report authoring, used conditional formatting to make the reports more user friendly.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Wrote and integrated stored procedures to generate the reports.

ENVIRONMENT: SQL Server 2008R2/2005, SSIS, SSRS, and Visual Studio 2005.
Confidential

Software Engineer

Responsibilities:

• Developed the module using iReport tool and involved in Testing during the final application delivery.
• Pivotal role in execution of Wealth Management System.
• Extensively worked on UI based customizations & Batch jobs
• Created daily and monthly system generated reports

Environment: FINACLE Scripting, Worked as Software Engineer from Feb-2007 to May-2010 on FINACLE Implementation for both major and minor enhancements for clients that include - MIFEL, CFS eBanking, ANZ Bank and EBI Bank

Confidential,

Customer Care Executive,

Responsibilities:

Worked as Customer Care Call Center Agent (Non-IT) for SerWizSol and Orion Dialog.