Report developer at Boeing, Philadelphia

Project name: Master Member Index (MMI) Client: Blue Cross Blue Shield Association• Developing SAS code to generate reports, including calculations, aggregations, and formatting.• Created various types of reports, including tabular, matrix, and free-form reports, using Microsoft SQL Server Reporting Services (SSRS).• Leveraged analytical skills by utilizing TOAD for IBM DB2 to generate insightful MMI reports, such as the "Records Arbitrated by Arbitrator" report, facilitating data-driven decision making.• Developed complex backend SQL queries to extract and transform data for interactive Tableau dashboards.• Championed agile methodology by actively participating in the development process. Contributed to project clarity and on-time delivery through creating and estimating user stories in Rally and attending regular MMI scrum meetings with technical teams.• Demonstrated business acumen as part of the MMI Business team by creating new business rules for MMI arbitration automation, streamlining the process. • Leveraged Salesforce as a business user to maintain (Licensee Change Management Process) LCMP events and surveys, maintaining process efficiency in CRM software.

• Responsible for creating and maintaining daily, bi-monthly and monthly reports in various areas.• Utilized SAS tools like Base SAS, SAS Enterprise Guide, SAS Visual Analytics, and SAS Report Studio to create reports.• Designed and created data models using Power Query to transform and clean raw data. Developed interactive dashboards using Power BI that provide a visual representation of key metrics and insights.• Prepared ad hoc and operational reports using Teradata SQL Assistant and SQL server management studio.• Extensive Exposure to SQL Server and Teradata SQL and advanced analysis with Excel. • Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Teradata and SQL server and loaded into SQL Server Tested ETL process (Data Loading, Extraction and transformations) using Microsoft SQL Server Integration Services (SSIS).• Created and maintained various Tableau Dashboards using Tableau Desktop 2021.4.• Trained new members of DNAS team how to prepare reports. • Contributed as a member of Member interaction analytics team to prepare data and create dashboard and provide different KPIs.

* Create adhoc reports using Teradata SQL assistant, SQL Server management studio and Microsoft Excel.

SAS programming

* Work as SAS Programmer.

Masters Student in Predictive Analytics at the College of Computing and Digital Media (CDM).

Online Economic Disclosure Statement ProjectProduct support to web applicationsTechnologies:Apache:- Sling- JCR- Jackrabbit- Felix- SpringDay Communique (Day CQ5) (Enterprise Web Content Management System)

Insurance to Value ProjectDescriptionThe objective of this project is to dynamically access calculated insurance values through webservices. Initially the vendor used to send quartly cd to install in CNA internal system. The goal was to directly access MSB(vendor) Expresslync Webservices and retrieve desired building insurance values. Request and Response xml mapping was done and the internal system was connected to External webservice through Amberpoint.ResponsibilitiesWorked with Webservices and wsdl.Gathered Business requirement and prepared RSD document for the project. Maintained offshore-onshore communication for development.Acted as key onsite contact person.Worked with Control-M job.Wrote Java code using regex pattern..Worked with Oracle SQL Developer.Used PVCS version manager for code repository. Involved in integration testing.Provided assistance for User Acceptance Testing.Environment: RAD for Websphere, WAS 6.0, Web Services, Windows XP, Oracle 9i database, CNA bridje architecture, Oracle SQL developer, Junit.

Medical Educational GrantsDescriptionThe objective of this project is to add enhancement to the the Grants application. The purpose is to create an applicant profile which will automate cross-referencing of applicants with a provider database to flag applicants who are not eligible to receive funding. It will also automate the Expedited Grant Review Checklist and Process to provide complete electronic documentation as recommended by legal and compliance for all grants eligible for expedited review. The application can be found at www.sagrants.com.ResponsibilitiesWorked with Struts Action classes and validations.Worked with display tags of JSPUsed Ajax to update the parts of the webpages.Used Spring dependency injection and spring-ibatis integration.Worked with Web services call.Wrote complex SQL queries and worked with Oracle 10g database.Worked with IBatis.Worked with TOAD.Used Visual Source Safe (VSS) for code repository. Involved in junit and integration testing.Environment: J2SDK v 1.5, Spring 2.0, RAD for Websphere, Websphere 7.5, Web Services, Windows XP, Oracle 10g database, Eclipse 3.2, Toad for Oracle, IBatis, Junit.

Order To Pay TranslatorDescriptionThe scope of this project is to develop and implement OTP translator which will automate the process of manually entering order shell. OTP translator translates the order into XML format, then the webmethods send the translated order to OTP, and a complete OTP order is generated in the store.ResponsibilitiesImplemented Java programs for creating DAO classes and Data Access Layer.Used Java 5.0 generics to create translation rule types.Worked with POJO for Struts.Implemented JSF for front end development.Used Ajax to update the parts of the webpages.Used Spring Core Container module to separate the application Configuration and dependency specification from the actual codeWorked with Web services and SOAP messaging for the project.Wrote SQL query with JDBC connection and worked with Oracle 9i database.Worked with hibernate.Worked with Ant and maven for building the project.Debugged application in IBM WebSphere.Used Eclipse 3.2 for development. Involved in junit and integration testing.Environment: J2SDK v 1.5, EJB, Weblogic 9.2, Weblogic 7.0, Maven,Web Services, Windows XP, Oracle 9i database, Eclipse 3.2, Ajax, Spring, POJO, JSF, Oracle SQL Developer, hibernate, Junit.

Mecap Web portal SystemDescriptionMecap is a web portal system which allows users to log in and create a customer order for existing voice over ip service plan. It looks for the services provided in customer areas and enroll customers in service plan. It keeps track of customer record. Responsibilities:Worked in a group of six and was responsible for gathering business requirements.Prepared Use case diagrams and Class diagrams using Rational Rose as part of designing the application.Designed user interface for admin users to interact with Mecap system. Used Ajax for the web interface.Worked with Java Server Faces for the web interface.Worked with POJO for handling data.Designed and implemented mysql database to record the data. Designed and implemented Spring ORM module to integrate HibernateUsed Struts to implement the presentation layer\Worked with IBM Websphere Application Server. Used hibernate and data access objects to implement the database and persistent layer.Generated Reports using JReport to look the customer user-friendly manner as per the requirements.Used JSR-168 Portlet Specification using Java Environment: J2SDK v 1.5, Servlets, JSP, Spring, Struts, HTML. JSF, POJO, Java Script, Websphere 5.0, UNIX, JReport, Sun Solaris, Windows 2000, Ajax, Oracle 9i, Design Pattern and Log4j

Account Web Management SystemDescriptionAccount Web Management System is a web based system which keeps track of user accounts. It allows users to add a new account, search for existing account information, and conduct the transaction for an existing account. It updates all its transaction and customer records. Responsibilities: Developed Session Beans for the business logic layer. Developed Java Beans to store page data in the session, to be used in JSP. Deployed business components using Spring Dao package. Worked with JSF for front end development. Worked with Apache Axis for Webservices. Used Maven to build the project.Developed the application in Windows environment using EclipseWorked with Oracle 9i database for the back end system.Worked with Unix Shell ScriptingEnvironment: Servlets, JSP, EJB, HTML, Java Script, JSF, Eclipse, JMS, Spring, Windows 2000, Oracle 9i, Apache Axis, Maven, Unix Shell Scripting