Neel Neel

Neel
neelvarmaa@yahoo.com
Ph# 972-534-2395
PROFESSIONAL SUMMARY:
• 8 years of IT experience in the Analysis, design, testing and Implementation of Business
Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, and
Client/Server Applications.
SQA with manual and automated testing tools in financial, Investment banking, Retail
Industry, health insurance, pharmaceutical and Supply Chain Management (DM and DP).
Wrote extensive SQL and PL/SQL scripts to test the ETL flow, Data Reconciliation,
Initialization, and Change Data Capture, Delta Processing, Incremental process.
Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data
architects, and assess if it complete and fully understand EDW and ETL Architecture.
Experience in Business Intelligence in generating various reports using Cognos and Business
Objects.
Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile,
Scrum, RAD, TDD.
Proactively resolved open defects against MDM and other subject areas.
• Progressive experience in application testing, development and support to batch processes
hosted on an IBM mainframe.
Experience in Testing BI applications using OBIEE, SSRS.
Good concept of ETL, Warehouse and BI applications integration.
Vast testing experience in a Mainframe environment.
Wide knowledge of Mainframe applications, solution design, high level design and
development.
Trained on reporting tool likes Micro strategy, Business Object and Cognos.
Strong knowledge in Data warehouse Testing using AbInitio.
Strong knowledge of test methodologies: Object Oriented test methodology, Service Oriented
Architecture, Top to bottom and Bottom to top test methodology, QA Validations
& QA Compliances to ensure the Quality Assurance Control.
Experience in testing Business Intelligence reports generated by various BI Tools like Cognos
and Business Objects.
Proficient in Functionality Testing, Black and White Box Testing, System Integration.
Testing, Regression Testing, User Acceptance Testing (UAT), and Load &Performance
Testing.
Worked under testing methodologies like Agile-SCRUM and Waterfall Model.
Experience in SDLC and Agile methodologies such as SCRUM.
Experience in setting up and defining UAT process, schedule, and deliverables.
Sound Business knowledge in Retail, Banking and Insurance domains.
Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite
consultants.
Strong ability in communicating with Project Development Team, QA Team, Business team(s)
and UAT team.
Working knowledge of test management tool HP ALM.
Industrial experience includes Healthcare (HIPAA and EDI), EHR clinical Systems.
Proven Leadership experience with strong Analytical, Presentation and Communication skills.
Expert in writing PERL & UNIX Shell scripting for various needs including text processing,
data archiving, data parsing and database connectivity.
Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality
Center in Client/Server.
Extensive experience in Quality Center, HP ALM, Rational clear Quest.
Strong Testing Experience in HIPAA X-12 EDI (Insurance/Health Series (INS) such as 274, 278,
820, 834, 835, 837, and Version 5010 of this transactions.
Strong knowledge of current industry standards, such as HIPAA, CAQH, 21 CFR part 11, 21 CFR
part 820, cGMP, CAPA.
Worked on Waterfall, RUP and Agile methodologies.
Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads.
Extensively used ETL methodology for supporting data extraction, transformations and
loading processing, in a corporate-wide-ETL Solution using Informatica.
Experience in User Acceptance Testing, Performance Testing, GUI Testing, System &
Functional Testing, Integration Testing, Regression Testing, Data Driven & Keyword driven
Testing.
Experience in IBM Rational Suite for maintaining test requirements, test flows using Requisite
Pro, automate tests using Rational Robot and Rational Functional Tester, Rational Manager,
Defect tracking using Rational Clear Quest, version control using Rational Clear Case.
Efficiently performed Defect Tracking using various tools like Quality Center, Test Director,
Rational Clear Quest, Remedy Tool, PVCS Tracker, and Bugzilla.
Proficient in writing SQL queries to perform data driven tests and involved in front-end and
back-end testing. Strong knowledge of RDBMS concepts.
Developed SQL queries in Oracle databases to conduct DB testing.
• Having good knowledge on Oracle Data Integrator.
• Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.
TECHNICAL SKILLS:
Programming
Languages
PL/SQL, C, Unix Shell Scripting, SQL, PL/SQL 11.1, C, C++
Operating
Systems
Microsoft Windows, UNIX – Sun Solaris, HP-UXMS Office MS Word,MS Excel,
MS PowerPoint, MS Outlook.
ETL Tools Informatica Power Center 9.x/8.x/7.x, DataStage, SSIS.
Other Tools TextPad, CompareIT, SnagIT, Oracle UPK, WinSCP, Data Flux.
Databases DB2 8.0, Sybase IQ, Oracle 10g/9i/8i, MS SQL Server
Teradata V2R6,
Sybase 12.3.
Testing Tools HP-ALM, Load Runner, QTP, Win Runner, Manual Testing, Jira.
Reporting Tools Cognos 10.1, SAP Business Objects XIR3.1, 4.0, 4.1
Platforms Windows NT4.0 / 98 / 95 / XP / Vista/7, NT Server.
Bug Tracking
Tools
Bugzilla, Rational Clear Quest.
Data Modeling Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension
tables, Pivot Tables, Erwin.
Version Control Tools Rational Clear Case, CVS.
Change Mgt Tools Test Director 8.0, Quality Center, Rational Clear Quest, Jira, Rational Team
Concert, RQM.
WORK EXPERIENCE:
Client: Medica -Minneapolis, MN
Jan- 2016 to Present
Role: QA/ETL Tester
Responsibilities:
• Supervising the QA team in accomplishing their tasks as per the deadlines.
• Ensured data integrity and verified all data modifications and calculations during database
migration using Informatica.
Involved in Design and development of test plans based on high-level and detailed designs.
Analyzed the use cases given by the business analysts and developed test cases using them.
Worked with the Business to coordinate the test case turnover process proceeding each cycle
and selectively executed the test cases to verify that they are kept current.
Identify the primary key (logical / physical) and put update or insert logic to test the
referential integrity.
Deleting the target data before processing based on logical or physical primary key.
Design and execute the test cases on the application as per company standards.
Preventing occurrences of multiple runs by flagging processed dates.
Analyzed test results, generate test reports, file bugs and follow up on resolution with
development & support team.
Used OBIEE DAC to run the data load jobs.
Created ETL test data for all ETL mapping rules to test the functionality of the Informatica.
Interaction with business and development to understand the business functionality.
Excellent experience in coordinating with offshore and onsite model.
Written Test Cases for ETL to compare Source and Target database systems.
Interacting with senior peers or subject matter experts to learn more about the dat.
Identifying duplicate records in the staging area before data gets processed.
Extensively written test scripts for back-end validations.
Created ETL test data for all ETL mapping rules to test the functionality of Informatica
mappings.
Written SQL scripts to test the mappings and tested Cognos Reports.
Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure
any Change Control in requirements leads to test case update.
Involved in metrics gathering , analysis and reporting to concerned team.
Tested the Oracle PL/SQL testing programs.
Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts.
Sending weekly reports to high level management regarding the status of test execution.
Giving deadlines and time lines for testing by using mapping documents.
Environment: SQL Server 2008, Siebel 8.0, MAINFRAMES OS 390, Windows XP, Informatica 8.1 ,
TOAD, Quality Center 10, OBIEE10.1.1.3, DAC.
Client: Citigroup Financials -Jersey City, NJ
May- 2013 to Dec- 2015
Role: ETL/BI QA ANALYST
Responsibilities:
• Did data profiling for multiple compliance feeds.
Used Excel Pivoting for various running totals, total sales for trades, highest performance of
trades.
Used Mercury Quality Center to trace the requirements, write the Test Cases in the test
plan, execute the Test Sets in the test lab and track the Defects logged in the defects module.
Extensively used Clear Quest for tracking and reporting bugs.
Categorized bugs based on the severity and interfaced with developers to resolve them.
Maintained Test Logs, Test Summary reports and participated in defect review meetings.
Made Change Requests for failed test cases and assigned them to responsible developers.
Developed complex SQL scripts/queries for data verification to compare the expected results
with database and analyzed the data and the calculations in the mapping for its correctness.
Adding new requirements in the QC and linking them with corresponding test cases.
Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma
separated text, Pipe delimited text etc).
Executed campaign based on customer requirements and followed company code
standardization rule.
Did lot of ETL testing based on ETL mapping document for data movement from source to
target.
Written several complex SQL queries to validate the Data Transformation Rules
for ETL testing.
Developed several data issues for Compliance Data.
Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs
including archiving the old data, running backend jobs & setting up of job dependencies.
Performed extensive data validations against Data Warehouse.
Loading Flat file Data into Teradata tables using Unix Shell scripts.
As a ETL Tester responsible for the business requirements, ETL Analysis, ETL test and
design of the flow and the logic for the Data warehouse project using Informatica, Shell
Scripting & PERL.
Written test cases for Data Stage jobs which were migrated to Informatica mapping.
Tested several Informatica Mappings to validate the business conditions.
Testing the source and target databases for conformance to specifications.
Conditional testing of constraints based on the business rules.
Worked with business team to test the reports developed in Cognos.
Tested Complex Reports in Cognos 8BI Report Studio.
Tested different master detail, summary reports, ad-hoc reports and on demand reports using
Cognos Report Studio.
Design and execute the test cases on the application as per company standards and tracked
the defects using HP Quality Center 9.2
• Designed and prepared scripts to monitor uptime/downtime of different system components.
Preventing occurrences of multiple runs by flagging processed dates.
Written Test Cases for ETL to compare Source and Target database systems.
Testing of records with logical delete using flags.
Monitored the data move process through Data Extract to Flat file through Informatica
Execution flows and Loading data to Netezza Data mart through NZLOAD utility.
Testing the ETL data movement from Oracle Data mart to Netezza Data mart on an
Incremental and full load basis.
Worked with all kinds of Derivatives including OPTIONS, SWAPS, FORWARDS, FUTURES and
Other Derivatives like ELN, Foreign Exchange and Fund Derivatives.
Created UNIX scripts for parsing and modifying data and experience in using Control M job
scheduler for automation of Unix Shell scripts and batch scheduling.
Developed the ETL process to automate the testing process and also load the test data into
the testing tables.
Written several VBA macros.
Environment: VBA, SQL, PL/SQL, Excel Pivot, Informatica PowerCenter 8.6.1, Oracle 10g/9i,
MainFrame via Web3270, VSAM Files, Copy Books, Cognos 8, DB2 UDB, WinSQL, UNIX (AIX), Linux,
PuTTY, WinSCP3, Mercury Quality Center 9.0/8.0, Control- M, Data Stage 7.5, TOAD, XML.
Client: Bayer healthcare-Berkeley, CA
March-2011 to March-2013
Role: ETL /QA Analyst
Responsibilities:
• Worked with Business /Technical Analyst in analysis of functional design specifications of ETL/
Data warehouse applications.
Analyzed Source to Stage and Stage to Target Mapping document indicating the source
tables, columns, data types, transformations required, business rules to be applied and target
tables.
Worked on various phases following Agile development approach.
Analyzing Data Processing implementing Data Martapplicationsmainly transformation
processes using ETL tool and understanding of ETL workflows and ETL mappings and also
monitoring the Production Environment.
Validated reports for data integrity as per regulatory compliance requirements in leiu with
Dodd Frank.
Study and analysis of the mapping document indicating the source tables, columns, data
types, transformations required, business rules to be applied, target tables, columns and data
types.
Analyzed the report generation feature of the developed application and customized the fields
in a report according the category of use, analysis and business forecast.
Used Rational Quality Manager for Test Case Management, Requirement Mapping,
and QAReporting and Analysis.
Participated in status update meeting, and triage issue/defect resolution meetings with
vendor, onsite and offshore team.
Data Validation from Difference Sources to Target using SQL.
Used Autosy to do job scheduling.
Created and executed SQL for DW to test scripts and Test cases based on the Mapping Design
documents.
Developed Test Plans, Test Cases, Test Scripts for UAT.
Experience in creating UNIX scripts for file transfer and file manipulation.
Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements.
Conducted various types of testing including GUI testing, Smoke Testing, Regression Testing,
acceptance testing, functional testing, Integration testing&System testing.
Loaded data to different databases using SQL scripts and maintained a repository for data
loading scripts.
Execute batch processing and verify the jobs status and data in database tables.
Tracked the defects using Quality Center and generated defect summary reports.
Prepared status summary reports with details of executed, passed and failed test cases.
Interacted with developers, Business & Management Teams and End Users.
Trained new QA resources and provided necessary documentation to UAT Participants.
Prepared UAT Test Cases using Rational Quality Manager.
Worked with PMO to discuss milestones and review timelines and schedule for the
implementation.
Conducted walkthrough with SME, stakeholders, and all the project lead to get documents
approved and baseline.
Extensive SQL querying on Staging, Data warehouse and Data Marts.
Used Agile Test Methods to provide rapid feedback to the developers significantly helping
them uncover important risks.
Validated reports based on Functional Requirements.
Analyzed various reports generated by SSRS.
Environment: Rational Team Test, Oracle 9i,ETL, Informatica, Windows 98/2000/XP, HTML, SQL,
JavaScript, Autosys,Clear Quest, JIRA, UNIX.
Client: Huntington National Bank -Chicago, IL
Oct-2010 to Feb-2011
Role: ETL QA Analyst
Responsibilities:
• Created complex T-SQL queries, stored procedures, and user defined functions (UDF's) to
encapsulate frequently and commonly used business logic making the system more modular,
secured and extensible.
Generated test data and tested database to meet the functionalities deliverables in the
project documentation and specifications.
Implemented complex business requirement in backend using efficient stored procedures and
flexible functions, and facilitated easy implementation to the front-end application.
Optimized the performance of queries with modifications in T-SQL queries, eliminated
redundant and inconsistent data, established joins and created indexes whenever necessary.
Involved in writing Adhoc queries for Business Analysts to extract required daily data,
Analyzing existing data and performing the data migration.
Generated on-demand and scheduled reports for business analysis or management decision.
Configuration of report server and report manager scheduling, give permissions to different
level of users in SQL Server Reporting Services (SSRS).
Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from
SQL server Database Engine and also Analysis Services cubes.
Developed custom reports and deployed them on server using SQL Server Reporting
Services (SSRS).
Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
Documented all database objects, procedures, views, functions & packages for future
references.
Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel,
Flat Files and CSV file, etc.
Experience in dynamic configuration of packages in SSIS.
Experienced in Tested, Cleaned and Standardized Data meeting the business standards using
Fuzzy /exact lookups in SSIS.
Organized Error and Event handling by giving Precedence Constraints, Break Points, Check
Points, Logging and viewers in SSIS.
Merged Data from Heterogeneous Data stores and Legacy System implementing SSIS on the
System.
Environment: SQL SERVER 2008, 2012, T-SQL, SSRS, SSIS, MS Excel, MS Office, SQL assistant, MS
Visual Studio, Report Builder, MS Visio.
Client: Chennai, Tamil Nadu
Nov- 2008 to Sep-2010
Role: ETL QA Tester
Responsibilities:
• Tested ETL jobs as per business rules using ETL design document
• Assisted in creating fact and dimension table implementation in Star Schema model based on
requirements.
Expert in writing Complex SQL querying in Oracle.
Involved in the testing of Data Mart using Power Center.
Identified and Documented additional data cleansing needs and consistent error patterns that
could diverted by modifying ETL code.
• Involved in Preparing Test Plan for re-engineering projects.
Developed Test Cases bases on Functional Specifications and Design Documents for IMS
project.
Extensively used Informatica Power Center for Extraction, Transformation and Loading
process.
Extensively tested several ETL Mappings developed using Informatica.
Extensively used SQL Server 2005 for testing the data which is loaded in the target database.
Tested complex objects to the universe to enhance the report functionality.
Tested ad hoc and canned reports for Hyperion 9.3.3.
Tested OBIEE 11g and Web Intelligence reports.
Worked in an Agile technology with Scrum.
Responsible for different Data mapping activities from Source systems to SQL Server 2005.
Queried in SQL Server 2005 Database and validated the data using SQL.
Effectively distributed responsibilities, arranged meetings and communicated with team
members in all phases of the project.
Wrote complex SQL queries using joins, sub queries and correlated sub queries.
Performed Unit testing and System Integration testing by developing and documenting test
cases in Quality Center.
Did Unit testing for all reports.
Involved in extensive DATA validation using SQL queries and back-end testing.
Responsible for migrating the code changes from development environment to SIT, UAT and
Production environments.
Validated cube and query data from the reporting system back to the source system.
Environment: Informatica 7.1/6.2, Flat files, MS SQL Server 2005, Oracle 9i, SQL, PL/SQL, AGILE,
Mercury Quality Center 10, Unix Shell Scripting, Windows XP/2000.

  • Updated 3 years ago

To contact this candidate email neelvarmaa@yahoo.com

Contact using webmail: Gmail / AOL / Yahoo / Outlook

This entry was posted in . Bookmark the permalink.