PROFESSIONAL SUMMARY:
· 12 years of total experience in analysis, design development and Testing of enterprise level data warehouses.
· Experience working as a Sr. Systems Analyst, Data Analyst, Sr. Test Analyst, BI Lead, Sr. Informatica Developer, Business Analyst, QA Lead.
· Experience working with the ETL process using Informatica.
· Extensive expertise using SQL for database development on MS SQL Server, Oracle, Teradata and DB2.
· Good understanding and working experience with Facets
· Proficient in data analysis and problem solving.
· Worked on almost all phases of Software Development Life Cycle
· Expertise in all aspects of Testing in enterprise organization - Unit Testing, System and Integration Testing, User Acceptance and Pre-and-Post Production Testing
· Knowledgeable and experienced on current data warehousing concepts and methodologies.
· Ability to document warehousing designs and clearly communicate alternatives to the client and business.
· Understand Data Warehouse Change Data Capture (CDC) processing and challenges. Experienced in data modeling both in 3rd normal form and dimensional techniques.
· Experience in Business analysis in developing plans and processes to accurately solicit and capture project requirements and goals.
· Experience in working closely with the project management team to ensure timely delivery of solutions. Ability to learn business concepts quickly and relate them to specific project needs.
· Experience in Functional testing, Stress Testing, Regression Testing and Integration testing (in SIT, UAT and End to End).
· Extensive experience in designing Use Cases, Process Flow Diagrams, Business Requirements and Functional Requirements
· Familiarity and experience in all Testing phases, deliverables and activities.
· Experience in conducting Joint Application Development (JAD) sessions, Feasibility Studies, Risk & Impact Analysis.
· Proficient at coordinating the testing team in developing test plan and test cases by giving the view of functional requirements.
· Coordinated user acceptance testing and assisted clients with creation of Test Plans and Test Scripts.
· Well versed with QA Methodologies to ensure Quality Assurance
· Experience and expertise in Testing in the Mainframe and Client/Sever and Web platforms
· Excellent at problem solving, Root cause Analysis and devise solutions based on Impact and Risk.
PRIMARY / BUSINESS SKILLS:
· Business Analysis
· Quality Assurance
· Data Analysis
· Data modeling/ Profiling/Designing
· Data warehousing
· Business Intelligence
PROCESS / METHODOLOGY:
· Agile Unified Process
· Scrum
· RUP-Rational Unified Process
· ER- Entity Relationship Modeling
BUSINESS SKILLS
· Requirement Gathering
· Business Process Research
· Use Case Modeling and Analysis
· Functional requirement gathering
· Project Management
· Gap/Data Analysis and Impact Analysis
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center 8.1/7.1.4/ 7.1/6.1/5.1 Informatica PowerMart 6.2/5.1/4.7,
Informatica Power Connect.
Databases: Oracle 10g/9i/8i/8.0/7.x, DB2 UDB, MS SQLServer, 6.5/7.0/2000,Sybase
BI Tools: Business Objects6.5/XI R2, Designer, Supervisor, Web Intelligence 2.X/6.X,
Broad Cast Agent, Publisher, ZABO, Cognos, SAS.
Data Modeling: Erwin 3.5/4.0,UML
Languages: PL/SQL, Visual Studio, Java, C, C++, SQL, COBOL, T-SQL, HTML, XML,
Scripting: Perl, UNIX Shell Scripts
Methodologies RUP, Spiral Model, Waterfall Model, JAD
Version Control Tools PVCS, Clear case, SVN Tortoise
Environment: MVS OS/390, TSO/ISPF, MS Windows 2000/98/95/XP, Sun Solaris, UNIX,
MS Outlook 2003/2007, MS Visio2003, JCL, QMF.
Others: Facets
Profile Summary:
· 5 years of SAP experience, which includes technical expertise in SAP XI/PI
· Handled multiple implementation projects and production support projects
· Onsite-Offshore coordination experience as both lead and developer for solution design, technical activities, development and testing
· Working as an integration Consultant for the current project
· SAP BODS 10.0 Training completed
Technical Experience:
- Actively involved in implementation of A2A and B2B integrations using SAP PI
- Worked on SAP XI 3.0, SAP PI7.0 and SAP PI 7.1 and in different phases of project implementation from design, development, unit testing, integration testing, UAT, Go- Lives and post implementation support
- Experience in requirement gathering, analysis, design, development, testing, documentation, status tracking and monitoring and quality processes
- Involved in interface development using SAP PI components like Enterprise Service Repository(ESR/IR), Integration Directory(ID), Business Process Management(ccBPM), Service Registry and Advanced Adapter Engine(AAE)
- Experience in standard Graphical mappings, XSLT and Java mapping programs
- Experience in interface configuration using adapters like File(FTP), SOAP, JMS, Mail, JDBC, HTTP, CIDX, ABAP proxies and cross applications using RFC, IDOCs
- Experience in alert configuration, adapter module configuration, and developing user defined functions/UDF and queue handling
- Interface monitoring experience through Runtime Workbench and NW Administration
- Interfacing experience with SAP Modules like ECC 6.0, CRM, SRM, MDM, FICO, HCM and FSCM
- Involved in interface development and design with 3rd party applications like IBM Tivoli, PeopleSoft
- Aware of XI/PI admin activities and objects transport using files(.tpz), CMS and CTS+
- Developed effective working relationships with client functional/technical teams to understand support requirements, result oriented problem solving, tactical and strategic plans to implement technology solutions, and to effectively manage client expectations
Technical Proficiencies:
Platforms : Windows 9X/NT/7
Tools : NWDS, Soap UI, XML Spy, Net weaver ARIS,HP QC , IBM Maximo
EAI : SAP XI 3.0, SAP PI 7.0, SAP PI 7.1
ERP :SAP ECC
Languages : Java
RDBMS : Oracle 8i, PL/SQL
Web Technologies : HTML, XML
Corporate Trainings:
- SAP Net Weaver XI 3.0
- SAP Net weaver MI
SUMMARY:
Ø 7 years of extensive IT experience in all phases of Software Development Life Cycle including, but not limited to requirement analysis, design, development, maintaining, debugging and database support.
Ø Experienced in Microsoft .NET Technologies using .Net Framework 2.0/3.0/3.5/4.0/4.5, C#.Net, ASP.NET (Web Forms), and ADO.NET.
Ø Expertise in developing Client Server Systems as well as Web Based Business solutions using MS visual studio 2008/2010/2012, SQL Server Management Studio 2005/2008
Ø Experience in implementing 3-Tier pattern, Entity Framework and MVC architecture.
Ø Expert in designing and developing web based and windows based applications using ASP.Net, C#.Net, ADO.Net, CSS, Java Script, HTML
Ø Having good experience in OOP's, Caching, Authentication, Windows Services, User Controls and Web Custom Controls. Experience in working with User Controls and Custom Controls.
Ø Created parts of the application using ASP.NET Microsoft AJAX Toolkit controls like Script Manager, Update Panel within some web pages, thus reducing the number of round trips to the server per page and improved user experience.
Ø Worked extensively on HTML Controls, Server Controls, and Web Controls using C#.
Ø Experience in developing GUI (Graphical User Interfaces) for ASP.Net Web Forms.
Ø Worked extensively with Iterative Agile Methodologies (SCRUM), Waterfall methodologies and Test-driven development (TDD), RAPID.
Ø Experience in developing test cases and performing unit testing and production support and maintenance of various project.
Ø Good experience in converting the Business Requirements into Technical Specifications.
Ø Strong understating of RDBMS like MSSQL 2005/2008, MySQL and proficient in developing Stored Procedures, Views, Triggers and Cursors.
Ø Possess strong communication skills, Interpersonal skills and ability to swiftly learn innovative concepts.
TECHNICAL SKILLS:
| Programming Languages | C#, ASP.NET(2.0/3.0/3.5/4.0), ADO, VB, SQL, PL/SQL, C++, C |
| MS .Net Technologies | .Net Framework, ASP.Net, WPF, WCF (Windows Communication Foundation - Web Services), ADO.Net, C#, VB.Net, XML, LINQ, Web Services |
| Web Technologies | HTML, DHTML,CSS, JavaScript, XML, jQuery, AJAX, Silverlight |
| RDBMS | SQL Server 2008/2005/2000, Oracle 11g/10g/9i, MS Access |
| Applications | MS Visual Studio 2010/2008/2005/2003, MS Office 2010/2007/2003, Team Foundation Server, Tortoise SVN, jEdit, Toad |
| Web Servers | IIS 4.0/5.0/5.1/6.0/7.0, MS Active Directory |
| OS/Platforms | Windows 8/7/Vista/2003/XP/2000/NT, Windows Server 2008/2003, Linux, Unix. |
SUMMARY
· 8 years of experience in IT in the areas of analysis, design, development in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica, Business Objects with Oracle, SQL Server, ParAccel, Teradata V2R5.1, DB2 databases and Netezza.
· Involved in complete software development life cycle (SDLC) of project with experience in Healthcare Insurance, Automobile, Banking, Manufacturing and Pharmaceutical domains.
· Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solvingassociated with the ETL processes by working closely with BI team.
· Experience in developing Enterprise level datawarehouse, Data marts and Operational databases.
· Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, Repository management and administration, implementation of STAR, Snowflake schemas; Incremental loads, Change Data Capture and slowly changing dimensions.
· Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 9.1/8.6/7.x.
· Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 11.2/10g/9i/8i, Teradata V2R5.1, DB2 UDB.
· Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre session and post session commands.
· Worked with heterogeneous data sources like Oracle, SQL Server 2008/2005, Teradata V2R5.1, flat files, XML files, DB2 UDB, Main Frames and COBOL files.
· Used Metadata Manager to extracts metadata from application, business intelligence, data integration, data modeling, and relational metadata sources.
· Perform error handling as part of production support on Informatica as well as Unix.
· Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches
· Experience in working with Logical and Physical data models.
· Expertise in using GUI tolls like Erwin, Toad, SQL Developer, SQL Navigator and SQL *Loader.
· Excellent communication skills, team player, ability to work individually and meet tight deadlines.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 9.1/8.6/7.x Informatica Power Exchange 5.1/4.7/1.7, Power Analyzer 3.5, Informatica Power Connect and Metadata Manager.
Databases: Oracle 11g/10g/9i/8i/8.0/7.x,ParAccel 4.0, Teradata, DB2 9.7, MS SQL Server 7.0/2000/2005 Netezaa 4.0 and Sybase ASE 12.5.3/15.
Operating Systems: UNIX (Sun-Solaris, HP-UX), Windows NT/XP/Vista, MSDOS
Programming SQL, SQL-Plus, PL/SQL, UNIX Shell Scripting (Korn, C), COBOL, C++, Java
Reporting Tools: Business ObjectsXIR2/6.5/5.0/5.1, Cognos Impromptu 7.0/6.0/5.0, Informatica Analytics Delivery Platform, MicroStrategy.
Modeling Tools: Erwin 4.1 and MS Visio
Other Tools: SQL Navigator, Rapid SQL for DB2, Quest Toad for Oracle, SQL Developer 1.5.1, Autosys, Telnet, Serena Dimensions Version Manager, MS SharePoint, Mercury Quality center, Team Track.
Methodologies: Ralph Kimball
SUMMARY
- Around 8 years of IT experience in Software Test Design, Test Planning and Test Implementation for software projects.
- Innovative, creative and results-oriented software professional, hands-on experience in planning, coordinating the testing program policies, procedures and schedules on multiple projects using both Manual procedures and Automated Testing tools in in different testing methodologies like Agile, Scrum, Waterfall etc.
- Excellent understanding of Software Development life Cycle (SDLC) and importance of QA in Development/ Enhancement and Maintenance of software applications.
- Expertise in analyzing system specifications and business requirement. Proficiency in development, execution, and maintenance of Test plans, Test cases and Test scripts.
- Good working experience using Quality Center
- Expertise in testing Web-based and Client-Server applications.
- Expertise in performing User Acceptance Testing (UAT), Database Testing, System Testing, Regression Testing, Integration Testing.
- Good experience in using test management tools like Quality center for writing, or uploading test cases, viewing test plans, defect tracking.
- Knowledge in Load and Stress testing using Load Runner.
- Have a working Experience in UNIX
- Writing complex SQL queries to extract data from various source tables to perform database testing.
- Excellent organizational, detail oriented, time management, and strong analytical and problem solving skills with a consultative approach in defining solutions.
- Participated in requirement review meetings, analyzing requirements, developing test plan and test cases, Requirement Traceability Matrix, Defect management, Reporting and tracking.
- Solid experience in testing Mainframe and Client/server applications in Healthcare domain
- Benefit plan building and Group configuration. Ran macros to copy benefit base configuration unto new Benefit/Group configuration. Conversion projects ICD-9 conversion to ICD-10.
- Tested NASCO and Facets applications. Performed manual test, UAT and Unit.
- Expertise in writing test cases from use cases
- Backend testing using SQL for validation
- Created Use Case Documents from Business requirements
- Validated Test requirements and interpret/analyze product performance against design.
- Ability to work in remote, independently and on team environment.
- Integrity tested, Unit, validation, Regression testing, research, and validation of data.
- Data extraction, Compression, Validation in MS Access and SQL of errors, mining, and mapping positioning data.
- UAT, Regression, Unit and Integrity testing performed.
- Reporting of defects into ClearQuest and Quality Center
- Created test cases and test grids for Unit, UAT, integrity and regression testing.
- Automated tested and daily application support remotely.
SUMMARY
¨ Over 7 years of experience in Software Development Life Cycle process, with emphasis on Quality Assurance Testing in various enterprise-wide application environments;
¨ Expertise in manual testing - black box and white box testing;
¨ Proficient in writing Test Cases for both Manual and Automated Testing;
¨ Extensive experience in functional testing, user acceptance testing, GUI testing, back-end testing,browser compatibility testing, and load/performance, regression and integration testing;
¨ Hands-on experience in testing of client-server and web-based applications (intranet and extranet) in .NET, SQL Server, Oracle, DB2 and J2EE environments;
¨ Proficient in SQL, T-SQL and PL/SQL; executed and updated SQL queries and SQL Scripts for manualback-end testing.
¨ Extensively performed ETL testing and Reporting application testing in supporting enterprise-widedata warehousing and business intelligence (BI) applications;
¨ Experienced in interacting with peers, both technical team members and business stakeholders, and analyzing business requirements and transforming into Test cases, reporting status updates and rolling out the deliverables on-time;
¨ Possess working knowledge of using defect-tracking tools like Test Director, Quality Center, RationalClearQuest & Test Manager;
¨ Hands on expertise in developing, and enhancing automated test scripts using Quick Test Pro;
¨ Involved in Change management and Configuration Management processes;
¨ Proficient in working with databases like MS SQL Server, Oracle and DB2 and other BI/ETL tools such as Cognos, Informatica, Microsoft SSIS/SSRS;
¨ A Life-long learner, ability to absorb upcoming technologies and acquire functional knowledge on-the-project and support business deliverables;
¨ Excellent team player and can work with minimum supervision in a time sensitive environment ensuring 100% compliance with corporate set standards;
TECHNICAL SKILLS
Testing Tools: Quick Test Pro 10.x/8.0/ 6.5, Win Runner, Load Runner 9.x/7.8
Defect Tracking Tools: Test Director 8/7.5, Quality Center 9/10, Rational ClearQuest 7.0
Front End Tools: MS Office Suite, MS Visio, ERWIN, TOAD 7.5, Rational RequisitePro
Browsers: Netscape Navigator, Internet Explorer, Mozilla Firefox
Languages: SQL, PL/SQL, SQL*PLUS, VBScript, HTML, XML, JavaScript, MS-DOS, Unix Shell scripting, VBA
Source Control Tool: Visual Source Safe, AccuRev
Packages: Cognos 8.x/7.x, Informatica 8.1.1/7.x
Databases: SQL Server 2005/2008, Oracle 11i/10g, Teradata, DB2
Operating Systems: Win 2000/2003, UNIX, LINUX, Windows XP/2000/7, MS-DOS
SUMMARY
· 6 + years of experience in Information Technology with emphasis on Software Testing/ Quality Assurance with experience in testing Client/Web based applications.
· Expertise in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems.
· Complete understanding of Software Development Life Cycle (SDLC).
· Analysis and Review of Software and Business Requirement Documents.
· Formulating Test Plans and Test Cases based on the User/Business Requirement Document (BRD) / Functional specification document/ Software Architecture document(SAD)
· Expertise in the functional testing of Client/Server and Web applications.
· Extensive experience in data validation and manipulation in the Oracle database using SQL queries.
· Extensively tested almost all of the transformations of informatica.
· Used defect-tracking tools like Quality Center, TestDirector, ClearQuest for collecting Reqirement Tracibility Metrics, reporting the modification requests and tracking them to completion.
· Clear understanding of multi tier application architecture and development concepts
· Performed Functional testing of the application including SBC Factory by using Manual test methods and creating Java Programs to verify validity
· Experience with Unix shell scripts
· Performed Database Validation using program stubs.
· Extensive experience in Server configuration and Server performance monitoring on various platforms including UNIX and Windows NT
· Involved in writing programming scripts in Unix shell Scripts in automate test process.
· Expertise in Data Warehousing Concepts.
· Experience working with version control systems like StarTeam, ClearQuest, Test Director, Quality Center.
· Experience in mentoring and training a group of testers on the QA procedures, guidelines and testing tools and their implementation in the current project.
· Formulating Test Plan, Test Scripts and Test Cases based on the Design Document and User Requirement Document for the Unit, Integration, Regression, Functional, Performance, and User Acceptance Testing.
· Expertise inAutomation Testing using Rational Enterprise Suite and Mercury Produ cts including Rational Robot, WinRunner, LoadRunner, Rational TestManager, Mercury TestDirector, and ClearQuest.
· Excellent Communication and Interpersonal skills.
· Improved the documentation of QA testing practices to enhance their repeatability, saving time and money and encouraging testing standardization and best practices.
· Experience in UNDERSTANDING the Customer Requirements and deriving the Test Scenarios/Conditions based on the Requirements.
TECHNICAL SKILLS
ETL Tools | Informatica 8.6/8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor) |
Data Modeling | Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling |
| Databases | Oracle 10g/9i/8i,SQL Server 2005/2000, DB2,Teradata 8.1,MS Access |
OLAP Tools | Business Objects XI R2/6.x/5.x, Cognos 8.0/7.0/6.0 |
| Languages | SQL, PL/SQL, Unix Shell Script, C,C++,Visual Basic, XML |
Operating Systems | Windows 2003/2000/NT, AIX, UNIX, Linux |
Testing Tools | Quality Center 9.0, Test Director 6.5/7.2/7.6/8.0, Clearquest, MS Excel, Word (Professional Plus 2007), Snipping Tool |
DB Tools | TOAD, SQL Assistant, Squirrel SQL 3.5.0 |
| Communication Tools | MS Office Outlook, WebEx |
| Other Tools | Toad, SQL* Loader, SQL Assistant, Share point, Windows 7 Professional, Internet explorer, Fire Fox,Google Chrome |
Regards
Santosh
Delight Consulting Services LLC.
Office: 248-680-6684 Ext 307
248-606-0900 Ext 307
Fax: 248-498-6195
Email: KSR@delightconsulting.com
Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "remove" in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses which might be diverting the e-mails to you.
--
You received this message because you are subscribed to the Google
Groups "US consulting Contract Opportunities" group.
To post to this group, send email to us-consulting-temp@googlegroups.com
To unsubscribe from this group, send email to
us-consulting-temp+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.co.in/group/us-consulting-temp?hl=en-GB
---
You received this message because you are subscribed to the Google Groups "US consulting Contract Opportunities" group.
To unsubscribe from this group and stop receiving emails from it, send an email to us-consulting-temp+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment