SUMMARY:

PROFESSIONAL SUMMARY:

• 10 years of functional experience with Financial, Retail, Telecommunication Manufacturing Units.
• Expertise in Team Leadership, Training Mentoring members of a group.
• Experienced in Project Management that includes managing onshore and offshore resources Business/Data Analyst.
• Strong knowledge of the Software Development Life Cycle methodologies like Agile and Waterfall models.
• Experience with Iterative Software Development Life Cycle Process as per Rational Unified Process RUP , involved in inception, elaboration, construction transition phases using rational tools like RequisitePro, ClearCase, ClearQuest during various phases of RUP.
• Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document BRD , Functional Requirement Document FRD ,Software Requirement Specification SRS across the deliverables of a project.
• Expertise of UML in visualizing and documenting the artifacts using Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams, Sequence Diagrams using MS Visio.
• Transformed from FMS/2 Mainframe data to FMS/3 AIX/Web based application with Oracle Database while working for Quality Compliance Team.
• Assisted with Architectural support in finalizing technical designs for different areas in Finance as well as operational support in testing flows before actual release.
• Experience in extracting data from various Relational Databases like Oracle, SQL server, MS Access, COBOL and Flat Files using Informatica mappings.
• Excellent experience in creation of Database objects like Stored Procedures, Functions and Triggers in database languages like PL/SQL.
• Worked on Conversion systems using PDI Pervasive Data Integrator while doing transformation from source to target.
• Reviewed SDLC diagram, from Approach paper down to technical design down to testing performance level.
• Strong analytical skills with ability to follow project standards and decision-making capability.
• Excellent communication skills, with the ability to work in a challenging environment.

FUNCTIONAL AREAS:

• Gathered Business Requirements through brainstorming sessions

• Designed and developed Use Cases using UML and Business Process Modelling
• Utilized agile project management techniques to increase team productivity and meet delivery dates
• Provided suggestions and ideas more from a strategic and long term perspective
• Conversion Interface of financial systems using ETL tool
• Logical physical business process analysis code review
• Operational support in Unix Mainframe environments for actual scripts/flow while troubleshooting job failures for testing team
• Point of Sale Store Applications of Retail industry
• QA Analysis, Data validation System Integration
• Finance Warehouse systems of Retail industry
• Telecommunication Taxation Reporting systems
• Payroll, Inventory, Purchase Order, Distribution systems
• Admissions Accounting systems in College

TECHNICAL SKILLS:

ETL tools - Informatica Power Center 7.1/6.2/5.1, PDI, SQL LOADER

Reporting tools - Business Objects XIR1/6.0/5.1/ 2.6, Web Intelligence, WebFOCUS, Info View

Programming Lang. COBOL, C, C , Visual Basic, Autosys, Unix Shell Scripts, PL/SQL Scripts, Perl Scripts

Databases - Oracle 11g/9i/8i/7.X, SQL Server 7.0/6.5, TERADATA, DB2

Operating Systems - Unix, AIX, MVS, OS 390, Windows XP

Methods - Dimensional Business Modelling Star Schema , Kimball methodology

Requirement Mgmt Tools - Requisite Pro, Clear Case, Clear Quest

Dev. Methodologies - RUP, Agile, Waterfall, STV

PROFESSIONAL EXPERIENCE:

Confidential

Conversion Architect / Developer

Responsibilities:

• Conducted Functionality, Regression, Integration, performance, GUI and Back-End testing of Client/Server and Web based applications.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Established RUP Rational Unified Process methodology and provided assistance in developing Use cases and project plans.
• Queried database using SQL for backend testing.
• Formal evaluations providing critical input on functional design, technical designs test results.
• Conducted technical review of design, coding package test scripts execution with expected results.
• Wrote technical specification like design docs, implementation docs, task lists, etc.
• Worked closely with business users acted as a liaison between developers and the business analysts.
• Responsible for identifying analyzing data, root cause analysis of production problems.
• Responsible for managing test lifecycles for new and production support development efforts.
• Successfully managed and mentored the team of Developers periodically.
• Designing and implementing best practice in ETL solutions for Data Warehouse and OLTP to resolve issues in nightly/weekly/monthly cycles.
• Wrote code to improve performance time for Interface jobs in PL/SQL.
• Created Job specifications as per the new design implementation process.

Environment: Requisite Pro, Rational Rose, Agile, PDI, AIX, DB2, Unix, SQL, PL/SQL, SQL LOADER, TOAD, Windows XP, Java, MS Visio, Clear Case, Clear Quest, Share point, FTP, RUP, UML, Agile, Waterfall

Confidential

Systems Analyst

Responsibilities:

• Requirement gatherings from functional users and analysis.
• Wrote Use Cases for different functions of Point of Sale operations
• Raw form of data data collect validation with new release.
• Issue Request or Change Request analysis.
• Interaction with QA dept on follow-up with pending issues.
• Wrote PERL scripts to interact among different applications.
• ETL of POS data into Datawarehouse using SQL Loader.
• Transferring POS data into Teradata using feeder file.
• SQL Teradata queries to access data from Data Warehouse.
• Co-ordinated the unit testing and UAT phases.

Environment: Vax, PERL scripts, SQL LOADER, OS 390, DB2, TERADATA, C, C , Windows, DOS, Informatica 6.2, Business Objects 5.1, SQL, PL/SQL, Oracle 9i, Visual Basic

Confidential

Systems Analyst

Responsibilities:

• Reports modified as per Store systems changes from users.
• Initiated Cronjob in Unix for automating the procedures.
• PL/SQL procedures modified as per user's requirements.
• Co-ordinated with users unit testing of the system.
• Data modeling to include more tables, views keys
• Installed Project Scheduler to keep track of time spent per project.

Environment: Oracle 9i, SQL, PL/SQL, Data Modeling, Cronjob, Windows, DOS, Informatica 5.1, Business Objects 2.6