SUMMARY:

• Software Engineer with expertise in JAVA, PL/SQL & UNIX with more than 11 years of IT experience that includes Agile and Waterfall models. Career successes include major data migration/data warehouse projects. Major tasks performed are effective requirement gathering, gap analysis, technical document creation, assist various teams in defining and refining strategies in support of operational processes. Build and lead effective teams; recruit resources, allocate tasks and guide team for timely completion and delivery of critical projects.

TECHNICAL SKILLS:

Programming: Java SQL, PL/SQL, UNIX Scripting, Pro*C, COBOL, VB .NET, Perl, Python

Java: RestFul API, JSP, Web Services, WSDL, SOAP, Spring MVC, JASON, XML

Database/ETL: Oracle, Cassandra, Teradata, MySQL, Toad, SQL*Loader, Data Pump, Enterprise Manager, Query Analyzer, DBMS Profiler, AWR, SQL Server, Hadoop, Mongo DB

Reporting: Crystal Reports, Oracle Forms 9i, iReport 5.6

Data Modeling: Erwin, Talend, Informatica Power Designer

Test Management: HP ALM 11.0 (Quality Center), Remedy

Automation: Quick Test Professional 10.0, Selenium IDE, Selenium WebDriver

Functional: T - Mobile PrePaid/PostPaid Billing and Loan/Lease System, Amdocs Ensemble CSM, Billing, AR, CES8.1, Erricsson BSCS, Confidential RPX, EIP

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Technical Architect

Responsibilities:

• Explain migration process to all stakeholders; Mentor and Lead a team of 10 developers.
• Author high-level technical design documents (HLSD and FSD).
• Follow agile methodology; manage multiple sprint cycles and create user stories.
• Conduct defect analysis, reviews, and discussions; code changes, reviews, and testing; defect fixing; and code check-in. Enhance performance of slow-running Oracle queries.
• Designed and developed mini tools for migration of subscriber base from legacy to Ericsson BSCS for Confidential
• Worked with Erricsson in BSCS and for Telecordia for BSS solutions.
• Writing test case, creating test plans, executing test cases and perform defect reviews.
• Developed java based tools to invoke RestFul API’s in multithreaded fashion and consumed/validated using SOAP and Hermes JMS and used PostMan API for unit testing.
• Worked with Spring Framework, Hibernate and used Maven as build tool.
• Wrote extensive procedures, functions, packages for large population Data warehouse ETL activities.
• Set up Git repository for code backup and tag code changes.
• Developed eXtractor tool that allowed our team to complete the migration (rather than Other vendor/3rd party) and presented solution to client ( Confidential ); as a result, job was ed to our team. Completed project in half the projected time (in two years rather than four) and saved the client one third of the forecasted cost.
• Hired few developers and Quality Analyst, doubling the team’s efficiency. Trained and mentored new team members.
• Prepared code push document and unit-tested code in production server using dummy data; pre-test identified configuration file issues which avoided code changes and delays during go-live/production.
• Built automation tool to run data validations to execute approximately 2,000 test cases and caught numerous issues. As a result, the first Dress Rehearsal produced a 98.5% pass rate. With slight modifications, the Tool is being used in additional projects.
• Analyzed database tables, data populations, and PK/FK relationship using ERD to create performance-effective procedure that allowed completion of ETL process for three million customers within four hours. Saved 50% of allocated time and used that time for data validations and dollar-to-dollar reconciliation checks.

Confidential, Monroe, LA

Senior Subject Matter Expert Amdocs

Responsibilities:

• Contributed to all phases of SDLC: requirement gathering and analysis, preparing technical designs, coding, testing, deployment, and support for BSS/OSS Migration activities.
• Performed ETL activities, including source data extraction and data validation, cleansing, transformation, and loading into target system, using Talend and PL/SQL.
• Worked as Amdocs CSM and Billing expert.
• Developed data load tool (GDLT), using SQL, PL/SQL, and UNIX scripts for migration activities.
• Managed data integrity, performance tuning of slow-moving queries, and communication with client/stakeholders.Designed tool that validated customer addresses based on business logic, NPA-NXX combinations, and third-party tool. Achieved zero invalidated data in new system and 50% improvement in customer communication; ensured customers had dependable access to emergency (911) assistance.
• Implemented use of indexes when retrieving smaller amounts of data, Full Table scans for larger amounts of data, and multi-threading to invoke processes in parallel. Reduced query execution time by 50%.

Confidential

Senior Subject Matter Expert Amdocs

Responsibilities:

• Lead/Mentor team of ten, serving as Amdocs Infra expert and SQL, PL/SQL, and UNIX developer. Facilitated configuration, integration, and installation of portal (Picasso) in client environment in high-availability RAC mode.
• Interfaced with client to discuss requirements, environment validations, resource/time estimates, environment setup, and delivery.
• Performed data load, using SQL*Loader in Oracle UCM. Configured and implemented Oracle WebLogic server.
• Provided status reports to DBA, UNIX system administrator, PMO, technical lead, application team, upper management, HF owner, and testers.
• Established test cases, prioritized design process, and maintained design documents and code check-in.
• Addressed technical issues arising from lack of documentation and involvement of multiple vendors. Identified root cause of issues; developed action items to fix them. Completed project that everyone else had all but abandoned.

Confidential, Monroe, LA

Senior Subject Matter Expert Amdocs

Responsibilities:

• Managed ETL activities, requirement gathering and analysis, technical design development, defect analysis, issue identification, and code fixes.
• Led team of five to execute smooth project delivery within estimated timeline. Allocated tasks and prepared daily status updates. Adjusted Oracle queries and scripts.
• Participated in code porting from 32-bit to 64-bit system.
• Development for Migration of customers across different systems.
• Worked in Ensemble and Enabler modules for code and defect fixes.
• Identified bottlenecks and fine-tuned slow-running queries, following parallel execution approach. Reduced migration window to 1.5 days from three days.

Confidential, Dallas, TX

Senior Subject Matter Expert Amdocs

Responsibilities:

• Worked as Amdocs Subject Matter Expert for Ensemble Billing.
• Performed ETL/Migration activities, including source data extraction and data validation, cleansing, transformation, and loading into target system, using SQL, PL/SQL and unix scripting.
• Developed data validation and reconciliation tools.
• Managed data integrity, performance tuning of slow-moving queries, and communication with client/stakeholders.

Environment: Oracle 11g (SQL, PL/SQL), GDLT, ICQA, Toad, Oracle Enterprise Edition, UNIX scripting (sed, perl, awk), Pro*C, SVN, MS Excel/Word/PowerPoint