SUMMARY:

• Over 10+ years of experience in performing Software Analysis, Architect, Design, Development, Support, Migration and Testing of various Applications in Banking, Finance, Healthcare, Retail domain, and Manufacturing
• Over 10 years experience in Healthcare product development and supporting.
• Broad industry knowledge in Healthcare (Insurance, Plans, Claim Processing, Billing), Practice Management (EMR/HRS), Patient Portal, EDI Interface, Banking, Finance, Enterprise Tolling Management, and HR & Payroll
• Worked with clients Citibank, IBM, Confidential Technology, Electronic Transaction Consultants, Harris County Toll Road Authority (HCTRA), North Texas Toll way Authority (NTTA), Confidential, Confidential, and Orchestrate HR.
• Sold experience in gathering Requirement and able to effectively translate business requirements into technical solutions.
• Extensive experience in Managing & providing technical leadership the team member (20+) and guiding in application development from project conception to delivery.
• Excellent in technical competencies, understanding in the area of technology tools, Database, Data warehousing and Business Intelligence applications
• Hands on experience in database architecture and practice; logical and physical Data Modeling using normalizing Techniques and dimensional modeling with help Oracle Data Modeler, ER - Studio/Erwin, Oracle Designer 9i, CA Cool: Gen, and IEF Case Tool
• Extensive experience in ETL design, development, and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center 8.x/9x.
• Experience in data extraction, Transformation and loading (ETL) from various sources like Oracle, Teradata, SQL Server and Flat files using SSIS Import and Export, SSIS Packages.
• In-depth knowledge and experience in Physical and Logical Data Modeling and Dimensional Data Modeling, Fact & Dimension tables,
• Expertise in design & development of PL/SQL Procedures, Functions, Packages and Triggers
• Solid experience at scripting using Unix/Linux/AWK /Shell scripting
• Expertise in Web services integrations tools using NET, Java, PL/SQL, XML, REST, XSD, SOAP, MQ and other API, and informatics
• Expertise in performance SQL Turning, Troubleshooting, analyzing the query plans
• Strong experience in SDLC, Agile, Scrum development and Waterfalls methodologies
• Excellent Analytical and problem-solving skills
• Exceptional interpersonal skills, including teamwork, facilitation, and Documentation
• Good communication skill, able to demonstrate complex technical structures in an understandable user-friendly format

PROFESSIONAL EXPERIENCE:

Electronic Transactions Consultants

Confidential,Richardson, TX

• Worked as Application Architect, provided oversight of software development, identified tools/software's, design, development, documentation, testing, and rollout of enterprise Tolling Back-of-office to Harris county Toll way Authority
• Handled the design, architect and supervise the implementation functionality project requirements and documented
• Generated business process flow specification documents with help of Business Analysts and MS Visio
• Prototyped and suggested technologies for Data Modeling (Erwin, Oracle Data Modeler), DWH (Oracle OWB, ID, Informatica) and Integrations (Jenkins, clear case) and Oracle 12c new features under Linux
• Acted as Subject Matter Expert (SME) for product development on functional (Tolling Industry) and Technical
• Produced and reviewed 80% of project ERD, Logical & Physical, DDL, constraints using Oracle Data Modeler and ER-Studio/Erwin tool
• Maximized my involvement in design, development and unit testing of ETL interfaces, packages, and procedures created/modified for data extraction from different sources like Oracle DB/Linux, Flat files, and SQL Server
• Generated projects ETL scripts using transformation like Expression, Lookup, Aggregator, filter, pivot, store procedure and packages, table functions, update/delete strategy
• Optimized in Performance tuning of ETL mappings by modifying the source 40+ objects (views, Materialized views, and by using Analytical functions like LEAD, LAG, RANK, ROLLUP, CUBE) with help of SQL query and informatics
• Handled the responsibilities to design and develop the client faced screen, Dashboard, and business logic with help of Java, EJB, Restful, and MQ
• Generate 50+ SQL and PL/SQL scripts using procedure and functions, triggers for implementing some logic in ETL mappings like enabling and disabling the indexes, and refreshing Materialized Views
• Generated the most complicated Waterfall Statistical Dashboard using business intelligence to display Toll transactions movements.
• Generated 25+ Java web services (Java, PL/SQL, XML, REST, SOAP) interfacing with external client/platforms
• Performed in fine turning many 100+ complex SQL queries using TOAD, explain plan, SQL Trace, AWR, and Hints
• Conducted scrum meeting with 20+ Team and tracked the status of the project using Waterfall and Agile
• Developed 10+ Multithreading Parallel processing using Oracle Advanced Queuing
• Performed 60% project code reviews and adhered to architecture systems and SDLC best practices and coding standards
• Produced 120+ the SQL and Unix/Linux Scripts for scheduling in Control-M
• Prepared deliverables and schedules with help of MS project for 15+ project tasks
• Provided technical guidance to QA team on Test case preparation and validations and saved 10% Testing time

Environment: Oracle 12c/11g RAC /Sun, Oracle Reports D2k, Oracle Discover, PLSQL, SQL Navigator, TOAD, SQL Data Modeler, ER-Studio/ER-Win, Oracle Warehouse Builder 11g, Oracle Data Integrator 12c/11g, Oracle Application Server, Crystal Report, Informatics Web Tools: Java, J2EE, Been, EJB, JSON, ActiveMQ, Web logic, F5, LDAP, Linux and Maven Repository: IBM Clear Case, Jenkins; Control-M Schedulers; SLDC, Waterfall, Agile

Confidential,Dallas, TX

Application Development Manager/Architect

Responsibilities:

• Worked as Application Development Manager/Architect in design, development, support, and implementation of projects such as Patient Portal, Medical Insurance, Claim Processing, Billing, and Financial accounting HR and Payroll, Practice Management (EMR), and Injury Tracking System in N-Tire Environments on Oracle and SQL Server Database.
• Gathered business requirements and translated into software/modules components and documented the functionalities
• Led and Provided technical leadership to 20+ team members from project conception to delivery, and as a coordinator between the onsite and offshore teams.
• Identified frameworks, technologies and standards for developing and implementing applications
• Designed and created logical and physical data model schema structure, tables, view schema using Data Model tool ORACLE Designer 10g/9i
• Built HRMS/Payroll Applications system using .NET/Oracle frameworks, technologies, and standards for developing and implementing applications within 2 years and processed over 300 clients.
• Led and Built the Patient Portals application using Java, J2ee, and Oracle 9i/8
• Saved 10% resources by guiding the client to ensure that any defects, incidents, and problems are identified and resolved
• Wrote over 50 of database packages, procedures, functions, triggers, views, index, and constraints using Oracle PL/SQL in Oracle 11g/10g/98i.
• Produced ORALE Web Service (XML, XSLT, SOAP, RPC, and REST) and integrated external systems (Symmetric Tax Engine, Metavante Bank, Master Tax, ADP Advanced MD).
• Wrote 40 over of .NET Web Service (XML, soap, WSDL, and disco) and integrated external systems (Net time, Symmetric Tax Engine, EMR-LAB, E-verify, and Exact Hire).
• Wrote interface routines to exchange data with external venter WebMD/PHCS/Multiplan/Metavante to download Payer’s EOBs in EDI 837/277,835/HL7 format using XML, JAVA, XSD, and XLST
• Generated over 70 of Screens and reports for customers using Oracle Forms and reports 10g/9i, PL/SQL scripting.
• Worked extensively on tuning SQL queries and fixed the slow running queries in production with utilities like Explain plan.
• Created email and file I/O operations utilities using Java and used them as objects in Oracle as Java Stored Procedures.
• Implemented PL/SQL to perform application security and batch job scheduling.
• Generated dynamic web-reports using java, HTML, DHTML and JavaScript.
• Wrote shell scripts for load monitoring, File manipulation, and data loads Confidential . and scheduled using Cron jobs.
• Managed project Software Design review, peer code review and software test activities on a regular basis
• Used SQL* Loader and export/import UTL mechanism for data migration for bulk upload.
• Led and implemented on HIPPA 5010 EDI transformation.
• Produced custom Scheduler job using PLSQL/Unix/Script to perform application security and batch job scheduling, sends 100k email/EOB to patients/Payers/Groups.
• Re-Engineered the NCR forms and screen to Oracle Servlet Screen and migrated claims data from NCR to Oracle Database
• Excelled in guiding the work of team members and client to ensure that any defects, incidents, and problems are identified and resolved.
• Environment: Oracle 9i/8I RAC /Sun, Oracle Development Suite, Oracle Designer, Oracle Forms, Oracle Reports, SQL, PLSQL, Oracle Application Server, SQL Server, IIS Server, MS Project, MS Team Foundation Server, Java, J2ee, Servlets, UNIX shell script, MS visual Studio, Visual Basic, C#, ASP.NET, VB.NET, Web Service XML, XLST, SOAP

Confidential,Iselin, NJ

System Manager

Responsibilities:

• Worked as a System Manager in developing a Web-enabled application ‘Retail Banking system' for Confidential utilizing web-architecture tools in Oracle database.
• Prepared of functional and design specifications.
• Prepared Initial Oracle database Schema, tables, view, and constraints.

Confidential,Orlando, FL

Lead developer

Responsibilities:

• Worked as Lead developer for Confidential Contract, prototype, architect and re-engineered Confidential 's time Reporting System form character base NCR/HP UNIX Platform to an intranet Web Applications (Java, Tomcat, J2EE, JSP, and Servlets)
• Generated Logical and Physical Data design using IEF Case Tool on DB2 and Oracle
• Changed/re-engineered Confidential 's time Reporting System form character base NCR/HP UNIX Platform to an intranet Web Applications (Tomcat, J2EE, JSP, and Servlets) saved 30% resources and Hardware
• Generated 50+ gawk/Perl/Shell scripts for running scheduler jobs for Transforming data to from Oracle to DB2