Profile Summary

• ork experience in domains that include: Social Services, Insurance, Pharmaceutical, and Apparel industries
• Experience with various J2EE components/tools of IBM C ram including: Eclipse, XML, Ant, Web Services, Junit, Apache Tomcat, UML, Websphere
• Well versed with different software development methodologies waterfall, agile
• Working knowledge and experience in Oracle Hyperion Essbase PlanningQuick learner with a good aptitude, logic and problem-solving skills. A team player

Technical Skills

Languages Java, J2EE, SQL, XML, XHTML, UML, Cognos Powerhouse and its related tools, Cobol, VB/VBA, Progress, EDI

Databases/Servers RDBMS, SQL Server, Apache Tomcat, Oracle, WebSphere, JDBC,

HP Mainframe, Essbase, MS Access, Progress, DB2

IDE/OS/Frameworks Eclipse, SSMS, MVC, Rational Software Architect, Windows, Informatica,

HP-MPEXL

Others IBM C ram, Oracle Hyperion Essbase Planning , Design Patterns,

Web Services, Junit, Ant

Familiarities Spring, Struts, Hibernate, EJB, Mavin, Javascript

Professional Experience

Confidential

Java/C ram Developer

Environment: Java / J2EE, C ram V6 / 5.2, Eclipse, Rational Software Architect, Apache

Tomcat 5.5, Oracle 11g, WebSphere Process Server, Oracle Warehouse Builder,

Business Objects, Talend

Role: Provide C ram subject matter expertise to the User Training group and also to assist

them in imparting the C ram application training to end users.

Project Description:

• Consolidated Assistance Support System CASS is project for Department
• of Human Services of the State of New Jersey. It is a very large, multi-year initiative that consists
• of the entire automation of social services benefit management programs being provided by the
• state of New Jersey. The project has been designed with a vision of improving service to the
• clients and to phase out old mainframe based systems. Programs supported include Child Care,
• Food Stamps, General Assistance, TANF, Medicaid, SCHIP and newly implemented Federal
• Affordable Care Act ACA . The main objective of CASS is to integrate all the various systems used
• currently for benefit management under one system to streamline the whole process.

Covered areas include:

o Application Intake Process

o Case Management

o MAGI and Non-MAGI Medicaid Eligibility

o Ongoing Eligibility for SNAP, TANF and other programs

o Other Affordable Care Act ACA mandated requirements

Confidential

Environment: Java/J2EE, C ram V4.5/5.2, Eclipse, Rational Rose Modeler, XML, Rational

ClearCase, Rational ClearQuest, WebSphere, WAS, DB2

Role: Participated in C ram version upgrade from v4.5 to 5.2.

Project Description:

• The project was a C ram upgrade from v4.5 to 5.2 for The Louisiana
• Department of Children and Family Services DCFS . DCFS is an administrative department
• within the Executive Branch of State government in Louisiana. It is a public-funded service
• organization whose purpose is to administer the public assistance and welfare laws of the State
• and to provide high quality social programs and services to Louisiana residents at the lowest
• possible cost to the taxpayers. Programs include Child Care, Child Welfare, and TANF.

Responsibilities:

o Assist in setting up the development environment for C ram 5.2 and other software configuration tasks.

o Participate in merging and further customizing the custom code with new version. This involves using various J2EE tools, such as: UML to remodel any version discrepancies, Ant targets to generate Java codes and folder structures from XML files, Java APIs to customize the code for the clients, and Ant targets again to generate JSP codes from XML files.

o Participated in Database migration tasks

o Unit test the upgraded code and application using Junit and UAT.

o Defect correction for the upgrade release which involves using J2EE tools.

o Provided guidance and mentored junior Java developers on IBM C ram framework

Confidential

Environment: Informatica, Java, Eclipse, Sql Server, SSIS, DCS, SQL, Web Services, Cognos BI

reporting/dashboard

Role: Convert and prepare clients' raw data from multiple countries using Informatica Java

Transformation to be used for the next phase of the process.

Accomplishments/Responsibilities/Duties:

• Created Informatica Java Transformations for various countries, generating control values from raw data files which include look-up functionalities to other data files and Sql Server tables.
• Used Java and Sql Server and other tools to analyze and/or troubleshoot data discrepancies and provide alternate and more efficient solutions.
• Analyzed existing Java Web Services that invoke database operations and provide more efficient and resourceful solution.
• Created Sql Queries to be used by DIL team for further ETL processing for BI reports.
• Collaborated with DIL Informatica , Sql Server, and DCS teams to automate incoming raw policy files to transform and finally translate to database tables for Prophet System and Cognos BI reports.
• Attended weekly/daily meetings with DIL, Sql Server, and DCS teams to discuss the progress of each country, to prioritize outstanding tasks, and to discuss to resolve any issues.

Confidential

Accomplishments/Responsibilities/Duties:

• Functioned as the lead programmer in servicing Bristol-Myers Squibb developing customized solutions for sales, inventory, ordering, approval, billing and reporting systems.
• Built fully automated order-load and its approval processes using Cognos Powerhouse and Cobol in HP3000 for Bristol-Myers Squibb for orders taken from web with Sql Server as a back-end.
• Played a major role in producing and migrating historical data from HP to Sql Server system.
• Wrote Java program in Eclipse IDE that takes Excel address files and converts them into Pitney Bowe system format to generate labels for UPS and Fedex shipments.
• Used Java to query and manipulate data from Sql Server and Access database tables.
• Used Sql Server and MS Access/VBA to access Sql Server databases to create queries and stored procedures called by web applications.
• Re-wrote some existing processes using Cognos Powerhouse and its related tools to make them run two to ten times faster and more efficiently.
• Collaborated with Web and SQL teams for the development of various integrated solutions.
• Utilized familiarity with a wide range of applications and programming languages such as .NET technology, XHTML, JavaScript, CSS, etc.

Confidential

Accomplishments/Responsibilities/Duties:

• Managed and supervised Data Processing Department: duties included developing customized user applications, educating users, creating and managing accounts and passwords, backing up data, managing spool files, and other various tasks.
• Developed and maintained an apparel application ground-up using Progress in Windows LAN environment which included order entry, ticketing, invoicing, inventory control, reports, etc.
• Created, fully implemented, and maintained an apparel application for invoicing, order entry, inventory control, sales commissions, reports, and chargebacks using Cognos Powerhouse.
• Implemented EDI documents using Gentran Basic on HP3000 and built EDI bridge programs.