Business Intelligence Resume Profile
Dallas, US
PROFESSIONAL SUMMARY
10 years experience in architecture, planning, developing, implementingsolutions facilitating corporate growth, Lead cross functional teams with diverse technical backgrounds. Experienced in Data Analytics, Business Intelligence, Big Data Solutions, Web Mobile Dashboard, E-Commerce applications SaaS.Experienced in management of large technical teams, building new businesses and helping organizations to reduce cost and strategic investment.
- Architected and Delivered products in J2EE, Spring, Mule ESB/Talend ESB, Flex, HTML5, JavaScript frameworks Sencha ExtJS, JQuery, Angular JS, Bootstrap etc. , Objective C, Swift, Android, Pentaho Dashboard, Jasper dashboard, Tableau, SaaS, WebServices, REST/SOAP.
- Architected and Designed Applications with Pentaho BI, Jasper BI, IBM BI Cognos 10/8, Talend Software Stack, IBM TM1, Cognos SDK,Pentaho Data Integration, Pentaho Mondrian OLAP, R Statistical Language, Apache Hadoop, Cloudera, Apache STORM, Apache Kafka, Apache Flume, Apache Solr,MongoDB, Cassandra Netezza Analytics,Vertica, Druid, HBase, MonetDB, Neo4j, Apache CouchDB and Oracle.
- Experienced in Java, JEE, JSR 168 Portlets, AJAX, EJB, JPA, JSF, JavaScript libraries, Servlets, JMS, XML/XSL, JDBC, JAAS, LDAP UMLE.
- Experienced in Web Services, UDDI, WSDL, SOAP, XML, XSL, XSLT and XML Schema.
- Expert skills in Objected Oriented Design using UML and Core J2EE Design Patterns. Used MS Visio Ration Architect tools
- Experience in various software project management activities like Estimating efforts, Project planning, Project Scheduling and Task Allocation to Team, Tracking and Mitigating the Risks, Team Building and Management, Project Management and Quality related Activities
- Experienced in Banking and Financial Services. Detailed Subject matter expertise in Investor Services for strategic Investor Services applications and mobile platforms
EMPLOYMENT HISTORY
Senior Solution Architect Senior Manager Technology
Confidential
Cognizant Technology Solutions is an information technology services company Head Quartered at Teaneck, New Jersey, United States with significant operations in India.
TECHNICAL SKILLS
Operating System | AIX, LINUX 2.2.2 RedHat6.2 , Windows 2000, Windows NT. |
Architectural Software Design Patterns | MVC, Layered, SOA, Asynchronous EAI patterns, OO and J2EE Design patterns. |
Software Development Methodologies | RUP, XP, Agile and TDD. |
Object Oriented Design | UML using Rational Rose, Enterprise Architect and IBM Software Architect. |
Technologies/Software | Java, J2EE, EJB 2.1, 3.0 , XML, Quartz, JAXP, Struts, XML, JFC/SWING, XSL, Spring 2.5/3.0, Spring Integration, Blaze DS, JPA, Hibernate, IBatis, Log4J, XML RPC, JUNIT, Pentaho,SOAP, JMS, Web Services, MQSeries, Mule ESB, Talend ESB, Flex, HTML 5, CSS 3, JavaScript Frameworks Sencha ExtJS, JQuery, Angular JS, Bootstrap etc. , Highchart and D3 chart, Android, Object C, Swift,SQL, PL/SQL. |
Web/Application Servers | Apache Web Server, IIS, IBM Websphere, Tomcat, JBoss, and Jetty. |
Java Reporting | Cognos SDK for ReportNet, Cognos SDK 8.3, Cognos 10 and Cognos Mash up Services. |
RDBMS NoSQL DB | Oracle 8/8i/9i/10g, MS SQL Server, Composite Software, MongoDB, Cassandra Netezza Analytics, Vertica, Druid, HBase, MonetDB, Neo4j, Apache CouchDB. |
BI Tools | IBM Cognos, IBM TM1, Jasper BI, Pentaho BI,Tableau, Talend SDK, Pentaho Mondrian. |
Platform | Apache Hadoop HDFS, Map Reduce, Python coding, Hive, Sqoop , Cloudera Hadoop, Talend Software Stack, Cognos SDK, Pentaho Data Integration, Pentaho Mondrian OLAP, R Statistical Language, Apache STORM, Apache Kafka, Apache Flume. |
Development Tools | Eclipse IDE, IBM RAD, Rational Rose, Rational Software Architect RSA , Enterprise Architect, XML Spy, XML Binder and WTP from Eclipse.org, MyEclipse, IntelliJ, Sencha Architect, Sencha Complete,WaveMaker, Wakanda. |
PROFESSIONAL EXPERIENCE
Confidential
Senior Solutions Architect,
Confidential Application performs online analysis on historical behavior of Users to predict and prepare data on dashboard so that information is available to users for viewing and take actions. Widget on the Dashboard shows current data with comparisons from previous activity points. Application also provides flexibility of analyze detailed data in online data analysis tool and extract information in format of users choice PDF/Excel/MHTML .
- Architected and implemented the Dashboard with online analysis tool for Accounting, Custody, Sec Lending and performance business units with data size of 56 TB.
- Implemented Apache STORM Kafka for real time processing of data from ETL IBM DataStage source with Mule ESB.
- Implemented Apache Hadoop cluster with HBase, Apache Solr with multiple Shards, Pentaho Data , MonetDB for high performance data processing.
- Implemented R statistical to perform analytics calculation in real time with streaming data form HBase.
- Implemented Pentaho Mondrian as OLAP provider for online data analysis tool.
- Designed and Implemented HTML 5 user Interface with ExtJS, JQuery, CSS3, Highchart, D3 chart and Spring MVC.
- Managed team of 25 members 20 Offshore and 5 Online.
Confidential
SolutionsArchitect,
Portal shows high level Data consolidation for Business Sectors served by JPMorgan Securities Services. Users have flexibility to drill down on Summary Data and explode the Portal in full screen Business view. Graphs and Grids are dynamically drawn using JSON Response from Pentaho data Integration and Mule ESB Servers. WSS Portal provides platform for application on- boarding where application can be hosted on local as well on Remote application servers. Application utilized NoSql database for data caching and high performance data processing.
- Implemented R statistical to perform complex analytical calculation on Securities Lending data.
- Implemented NoSQL Cassandra to cache preprocessed data to support faster retrieval for online Users.
- Designed and Created Hadoop infrastructure to deal with 56M record for Custody data, this was to achieve 5 second screen rendering SLA. HDFS was created on 12 Linux boxes with 250 GB data transfer per day.
- Implemented MonetDB Druid for real time analysis of Accounting data.
- Implemented Apache Solr search for Custody Transaction with 20 M transaction message per day.
- Implemented Pentaho BI Dashboard with Mondrian OLAP and Pentaho data integration.
- Implemented Dynamic Jasper Report to perform dynamic reporting form OLAP Grid User Interface.
- Implemented Mule ESBfor SOA Environment.
- Developed architectures for web services security using WS-Security and WS-Policy.
- Designed and Implemented Flex, HTML 5 user Interface with ExtJS, JQuery, CSS3, Highchart, D3 chart and Spring MVC.
- Developed data models and data architecture for financial data
- Managed Team of 20 members 10 Onsite resources and 10 offshore.
Confidential
Solutions Architect,
Confidential Reporting is JPMorgan's enhanced reporting application for clients serving Custody, Accounting and Securities Lending reporting. Easy to use and integrated with intuitive navigation and easy access via single sign-on to the JPMorgan ACCESSS client portal. It's part of the VIEWS platform/suite of applications linking to other web-based applications including Performance Measurement, Compliance Reporting, Network News Reference, Transaction Initiation and Corporate Action Instructions Online.
- Designed and Developed Service Framework for VPR application using Mule ESB, Spring 3.0, JPA 2, Active MQ, Message Driven Bean/Pojo, Apache CXF. This Framework provides service level abstraction for the system and enables application as Service SOA .
- Designed and Developed Cognos Reporting Service layer using Cognos SDK, Spring 3.0, Spring Integration, Axis 2 and Hessian Binary web services. This abstraction is responsible for all Cognos Reporting Engine interaction and provides easy to use API for users.
- Several Optimization and performance improvement of application for stability and system load. This involves JVM optimization, evaluation of JVM performance and heap analysis using tools like JConsole, IBM heap analyzer etc.
- Developed In-house Java profiler tool for performance statistics extraction and visualization, which uses aspect weaving at to non-invasively instrument the application binaries and extract performance statistics which can be visualized and analyzed in an offline manner.
- Developed In-house performance monitoring tool for java application, this tool can measure application performance under multithreaded environment. Tool also provides facility to identify optimal number of instances to deploy for handling given user base. This tool also provides facility for data visualization of system activity
- Designed and Development framework for Flex 4.5 using robolegs. Framework also includes Babel Effect for internalization support and Blaze DS for server side integration.
- Managed team of 32 members 25 offshore resources and 7 Onsite resources.
Application Architect Senior Developer,
Confidential application is to limit human effort of building reports in a reporting system. The ARC system receives report specific requirements from MDR report feed and enables automated reporting build by mapping these report specific requirements to a pre-defined report model. ARC is intended to be an accelerator for report development and does not intend to completely automate report creation.
- Designed and Developed the core framework and modules of ARC using Flex 4.5, Spring 3.0 IBatis and Cognos SDK.
- Cognos version agnostic framework, with XSD and XSLT based module that is used as core of the system.
- Designed System Decoupled from both up-stream and downstream systems. Coupling is through configuration and mappings.
- Designed Metadata based generic System that can be use with any reporting System.
- Managed team of 10 members 8 offshore resources and 2 Onsite resources.
Application Architect Senior Developer,
Confidential Portfolio Reporting provides users with the ability to modify reports through the application's Report Wizard functionality. It is accessed via the Customize button on the Global Toolbar in the Workspace.This project was migration of Existing JSP/HTML, JavaScript, Struts, EJB and Hibernate 2.1 project to flex based Project using Flex 3.0, Blaze DS, Spring 3.0, Spring Integration and JPA.
- Designed and developed Framework for the Flex application using Flex 3.0, Blaze DS, Spring 3.0 and JPA2.
- This application demanded large amount of data and server interaction, Developed a module using de-queable cells that loads and unloads data on visible data set.
- Implemented the design using Apache -Axis.
- Implemented Software as Service Architecture This application was developed as Technology agnostic application.
- Improved screen rendering performance by 250 .
- Managed team of 8 members 6 offshore resources and 2 Onsite resources.
Senior Developer,
Confidential is reporting application based on cognos reporting engine, Report developed in cognos are backed by XML document and requires frequent bulk changes. Manual modification of reports is erroneous and requires large effort. Script Master automates the bulk modification of reports using XML based language. Users have to define update action and location of modification to perform bulk modification. This application has helped JPMC to reduce effort by 250 .
- Designed Generic solution for Report Modification built on XSLT.
- Implemented Software as Service - Functionality can be invoked using Hessian Web Service.
- Design and developed Generic Customizable solution using Meta information.
- Designed scripts for project management tasks like build, deployment etc. using Maven and Ant.
- Continuous testing using JUnit - Test Driven Development.
Senior Developer,
Cognos 8 has changed report internal and spec significantly, which had impact on VPR Custom reports because they were constructed with Cognos 7 spec. Cognos 8 migration was Technology refresh project targeted to migrate generation of VPR Wizard Report from Cognos 8 and automatically migrate existing Cognos 7 wizard reports to Cognos8. These component uses Cognos SDK to converts the wizard objects / report definition to Cognos 8 spec after applying all application related processing.
- Coded transaction aware module for XA aware data stores.
- Implemented design using patterns like Service Locator, DAO.
- Designed and Developed Cognos SDK Wizard capability for VPR using Cognos SDK, Spring 3.0, JPA2. This service layer enables VR Users to customize system-defined report.
- Developed Web Service interface for this application using Hessian Binary web service and Apache CXF to enable this module for SOA.
- Implemented Continuous testing using JUnit, maven and Hudson.
- Designed Rules based architecture.
- Managed team of 6 members 6 Onsite resources.
Module Lead and Developer,
Confidential is a Query Tool that allows the Customers as well as internal JPMC users to create and execute customized queries on the Profile Repository. The application is capable of handling various security types such as Equities, Fixed Income, Cash, International Equities, International Derivatives, etc. The application takes care of generating the profile reports too. As collateral agent, JPM holds collateral on the BDAS system. The eligibility criteria are entered into the BDAS system through a screen based UI. BDAS checks collateral eligibility for each TPR on a daily basis based upon the criteria. The check occurs at the time the collateral is allocated to the lender.
- Designed and developed complex intuitive GUI using JSP, JavaScript and CSS.
- Used MVC framework architecture.
- Used design patterns like proxy, command, factory etc.
- Implemented database interactions using JDBC with back-end Oracle
- Used Hibernate and IBatis for data persistence.
- Developed PL/SQL Stored procedures.
- Continuous testing using JUnit and StrutsTestCase, for testing Struts Framework based applications.
Team Member,
Portfolio Views PV is a browser based thin client reporting tool that allows JPMC clients to submit request for reports and view the same. It was primarily developed for Institutional Investors Clients of JPMorgan Chase . PV is capable of generation Custody and Institutional Accounting reports. In PV JPMC Product Manager and Investors can select a predefined report or create a User defined reports and submit it with certain specified criteria for execution. PV is capable of generating reports in PDF and Excel format. The system also provides lending reports based on intra-day, close of business day or historical data through JPMorgan T SS.
- Developed EJB 1.1/2.1 Session and Entity bean based business service
- Developed Jasper reports for system and service module to interact with J2EE system.
- Database designing and PL/SQL stored Procedure development for Oracle.
- Developed C module to read and push MQ messages for performance consideration.
- Developed Unit Test cases using JUnit.
- Developed UI Automation test using Selenium.