SUMMARY:

• More than 11 Years of experience in Design, Development, Data Analysis and Testing in Oracle/Teradata based applications.
• Strong data warehousing and business intelligence skills.
• Experience in Cloud Computing, Salesforce(CRM) & Force.com.
• Industry experience as a Data Analyst with solid understanding of Data Modeling, Data Warehouse/Data Mart Design, BI, OLAP, Client/Server applications.
• Excellent knowledge in Data Analysis, Data Source Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Expert in writing SQL queries and optimizing the queries in Oracle.
• Performed Data analysis and Data Profiling using complex SQL on various sources systems including Oracle and Teradata.
• Excellent experience on using Teradata SQL Assistant & Teradata Administrator.
• Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents.
• Basic experience of UNIX.
• Experience with Business Intelligence tools like Hyperion/Brio and Interactive Reporting
• Good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Highly proficient in SQA methodologies for Waterfall, Agile.
• Good demonstrate capacity and ability to manage multiple complex projects concurrently.
• Back end testing and performed Data integrity/verification testing using SQL queries.
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.
• Strong planning, analytical and problem solving skills.
• Excellent Written/Verbal communication skills.

TECHNICAL SKILLS:

Databases: Oracle, Teradata

DB Tools: TOAD, SQL Assistant, Teradata Manager

Data Analysis Tools: Informatica Developer, Tableau, Metric Insights

Cloud Computing: Salesforce

Programming Languages: SQL, PL/SQL, SOQL, Java Script, VB Script

Reporting Tools: Brio, Hyperion Solutions (9.3), Interactive, Reporting 11

Version Management: PVCS, CVS and SVN

Test management Tools/: Rational Test Manager, HPQC/ALM

Testing, Defect Tracking: Quick Test Professional, Test Complete, Test Director, Rational Clear Quest, JIRA.

PROFESSIONAL EXPERIENCE:

Confidential

Developer/Analyst

Responsibilities:

• Analyzing Business Requirement, Data Analysis and Data validation.
• Project management, Creating and managing Users, Role, Permission set, Profiles, Sharing Rule, Validation Rule, Applications, Objects, Records Type, Page Layouts, Custom Fields & application, Data Type, Fields Accessibility, Apex Data Loader, Command line Data Loader, Sales force API, Data Migration.
• Reporting and dashboards development.
• Manuall Testing and validating the entire Applications including the Objects, Fields, Data, Users, Roles etc.

Confidential, Englewood, CO

Data Quality Developer/Analyst

Responsibilities:

• Creating Data Quality Operations Requirements for facilitating monitoring, notifications, alerts, reporting, and troubleshooting data.
• Creating and Running Informatica Data Quality Profiles and Rules.
• Performes Data Quality analysis and Data validation.
• Created Process Flow documentation for Rosetta Dataset.
• Creating Data Mapping document for the Rosetta Data Lineage including Customer Information, Billing Information, Activity, Integrity, Customer Interact, Services, Demographic Information, Equipments, Usage, Calculations, Scores etc..
• Detailed analysis of the ETL script, identifying and documenting the Target/Source Tables/Columns, Data type, Column Description, Tables, Transformation Rules, Join/Filter crieteria, ETL crieteria etc.
• Supporting and helping the Users to understand the Rosetta Data Lineage.

Confidential, Westminister Co

Developer/Analyst

Responsibilities:

• Creating and managing Users, Role, Permission set, Profiles, Sharing Rule, Validation Rule, Applications, Objects, Records Type, Page Layouts, Custom Fields & application, Data Type, Fields Accessibility, Apex Data Loader, Command line Data Loader, Sales force API, Data Migration.
• Analyzing Business Requirement, Data Analysis and Data validation.
• Public website & Report creation, enhancement.
• Lead automation
• Opportunity automation
• Sales and Forecasting
• Email Automation
• System Integration, Manage salesforce deployments.
• Testing and validating the entire Applications including the Objects, Fields, Fields Accessibility, Data, Records, Page Layouts, Custom Fields, Data Type, Users, Roles, and Permission set, Profiles, Sharing Rule, and Validation Rule etc.

Confidential, Englewood.

Developer/Analyst (SME)

Responsibilities:

• Analyzing Business Requirement and System Requirement.
• Report design and development using SQL, PL/SQL and Interactive Reporting Studio
• Unit testing, System testing, Release, Schedule, Publish, and Run Reports using EPM Portal
• Facilitated meetings between Stakeholders, DBAs, Developers and with multi - functional team to identify and resolve issues and integrate system enhancements.
• Worked closely with end-users to develop a detailed understanding of the opportunities for improvement and functionality, detect bugs and resolve them, provide feedback and improve the entire development process.
• Participate in the project status review meeting.
• Analyze and clarify business request and specifications.

Environment: Hyperion IR, EPM, Windows, IE, Oracle, SQL, PLSQL, Microstrategy

Confidential Englewood, CO

Developer/Analyst

Responsibilities:

• Requirement analysis
• Report design and development
• Performed Data verification & validation for making meaningful and useful reports according to various requirements.
• Unit testing, System testing and release
• Coordinating with Testing and Business team
• Developed and Tested numerous month end reports for the Accounting (Programming Payments, Tax).
• Developed and Tested reports for the Sales tax team that will help them claim money for equipment that has been re deployed.
• Developed and Tested reports for the Marketing, Internal Audit and Corporate Management Program.
• Tune queries and develop generic queries so that they can re-use when needed.
• Thorough knowledge of the various databases and the data and how they can be manipulated to produce meaningful reports for the business.
• Extensively used SQL Query, Joining tables, SQL functions in Queries.
• Having interacted closely with the various business units, I understand their requirements and am able to suggest ways to develop reports that would be more useful to the business.
• Trouble shooting, analyzing reports that do not produce the expected results and finding solutions or work around for them.
• Widely used Database objects like Views, Indexes, Stored Procedures, synonyms, Triggers and Global Links for reducing the load on ETL tools.
• Performed Validations, Testing and verified actual results to the expected results
• Performed Backend testing by using SQL on Teradata database for validating & retrieving the data used for various testing scenarios.

Confidential, Englewood.

QA Analyst

Responsibilities:

• Developing test cases by analyzing the requirement specifications for functionality and regression testing and execute them against new builds.
• Test Trouble Tickets, Change Requests and Enhancements.
• System, UAT, Regression and Performance test.
• Performing back end data validations using SQL Server to ensure the expected configurations exist in the standard list of configuration tables in our system called NEPTUNE.
• Validating the feasibility of a new Call Plan or new Market by creating new Accounts and Telephone Numbers and assigning usage by going through all the transaction processes ( Confidential Digital Voice processing) right from the Switch to the billing including Mediation, Pricing and Billing using End to End Testing method.
• Submitting and Managing bugs in defect tracking tool. (Test Director)
• Worked closely with Development and Product / Project Management for the timely resolution of defects and verify defect fixes.
• Used to attend requirement discussion, design discussion, status update meetings and the Lesson learned meetings for various projects.
• Creating Data for System testing and User Acceptance Testing.
• Helping Users to understand the implementation of new interfaces and enhancements

Confidential, Aurora, CO

QA Analyst

Responsibilities:

• Test case preparation and Test design.
• Requirement mapping against test cases using Rational tools.
• Execute test cases by manual and automated process.
• Preparation and Execution of Test Cases
• Involved in Functionality testing, Integration testing, Smoke testing, Black Box testing, Usability testing and Regression.
• Performing User Acceptance testing
• Involved in doing System testing of applications along with team members
• Verified and validated fixed defects
• Test reporting and Bug Tracking.

Environment: All the user interfaces are developed in Java//J2EE framework with SQL Server as backend and JBoss as the Application server.

Confidential

QA Analyst

Responsibilities:

• Write test documentation including test suites, test cases, checklists, etc.
• Persistent in localizing software defects and make them reproducible.
• Involved in assisting the QA Lead and participated in planning and organizing the test schedules.
• Designed and executed Test Plans and Test Cases based on business requirements.
• Executed Test Scripts and different Test scenarios.
• Test Scenarios, for manual with some automation testing.
• Use Quality Center Application to track defects.

Environment: ASP, Microsoft Interdev, VB Script for the front end development and Oracle as the backend Database server..

Confidential

QA Analyst

Responsibilities:

• Write and execute SQL queries for data validation.
• System test case preparation and testing.
• Set up and staged test data for all testing purposes and validated the results to conform functionality to requirements.
• Performed Positive and Negative Testing to ensure appropriate user authentication.
• Developed and Maintained Test Matrix to reflect the test progress