SUMMARY:

• Leading big data developer and system analyst with over twenty years extensive data processing experience. Strong background in developing Financial, Accounting and Billing Systems that include full project life cycle design and development along with excellent programming and problem solving skills in developing database applications and web applications.
• Experience in building big data solutions in various backend process based applications as data architect and Hadoop developer using HDFS, MapR, Elasticsearch, NiFi, Kafka, Hive, HBase, Pig, Python, Sybase, DB2, Oracle, SQL Server, JAVA, XML, Perl, C/C++.

TECHNICAL SKILLS:

Hadoop, HDFS, MapR, NiFi, Kafka, Elasticsearch, Hive, HBase, Pig, Spark, Kafka, Scala, Python, NoSQL

Netezza, Sybase, DB2, Oracle, PL/SQL, OCI, T - SQL, DB-Library, SQL Server, MySQL, Informatica

ASP.NET, C#, VB, JAVA, XML, JavaScripts, C/C++, Perl, DBI/DBD, Unix/Linux, Shell, Windows

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant / Architect

• Design and develop the Enterprise Security data flows to the MapR based data lake platform, provide realtime logplant data analytics, search tools.
• Build independent search engine, and dashboard visualization tools using NiFi, Kafka, Elasticsearch, Kibana clusters.
• Manage, Design and implement the Federated Ingestion Layer platform as part of the Enterprise Security Platforms for data monitoring, alerting and visualizations. Providing log data integrations, cyber analytics, management and governance overview, data streamings.

Environment: MapR, Hadoop, HBase, Scala, Kafka, NiFi, Elasticsearch, Kibana, Pyhton, UNIX/Linux

Confidential

Big Data Hadoop Developer/Architect

• Analyze and Design the Integrated AT&T International Data into the big data analytical platform by utilizing the SQL on Hadoop concept especially in using NoSQL solutions Hive/Tez, Phoenix/HBase, Vertica, Cassandra.
• Build the data lakes thru a C/C++ data streaming pools and create a user friendly environment that helps business users to efficiently use SQL queries in a multiple-country interactive querying platform. Develop Spark, Kafka based streaming data and Spark SQL queries to fully utilize Spark memory architecture for SQL over Hadoop.
• Design and develop ETL tools across different databases and platforms by using the virtual pipes, Store Procedures and APIs.
• Provide proof of concepts and benchmark testing reports to the management team in making critical decisions on the future products.

Environment: Sybase, Oracle, Python, Hortonworks Hadoop, HDFS, MapReduce, Hive, HBase, Pig, Sqoop, Tez, Spark, Scala, Kafka, Phoenix, Vertica, Cassandra, Java, UNIX/Linux, Informatica

Confidential

Big Data Hadoop Developer/Architect

• Leading the effort in design and develop fast ETL tools across different databases and platforms by using the virtual pipes, Store Procedures and APIs. Providing real time data synch and improving performances significantly in Time Series Data Analysis Platform.
• Partner with business users to analyze multiple data resources and the existing manual approaches to establish a OLAP reporting platform along with the existing MicroStrategy analytics that delivers the analytical solutions for building the data modeler.
• Exploring Big Data capability and feasibility in migrating current Time Series databases to Hadoop, HDFS, MapReduce, Hive, Pig environment for reporting, regulatory and VaR model analysis. Design and develop user defined MapReduce functions using Java, Python, perl to build proof-of-concept data models.
• Leading the support for our business partners during a time critical transition. Planning and creating user requirements in data pruning techniques which improved performances dramatically.
• Involved the redesign and object oriented data approaches for the future TSS applications that feeds directly into BI applications as part of the new strategy technology orientations.
• Initiated the concept of entitlement, authorization and authentication along with the current active directory. Actively working on database automated promotions in various stages all across the Market Risk Suite.

Environment: Sybase, Netezza, Perl, Python, Hadoop, HDFS, MapReduce, Hive, Pig, Java, UNIX, Informatica, Quartz, MicroStrategy, OLAP, DevOps, Agile

Confidential

Big Data Hadoop Developer

• Designed cross platform Fraud Negative Data Warehouse and Applications, identify and analyze structured and unstructured data to build business intelligence reporting approaches.
• Developed Network Linkage Data reporting tools using Apache Hadoop open platform.
• Analyze major social media network data and text mining in the big data environment, and integrate with the existing Data Warehouse to perform R&D studies and build proof-of-concept models.
• Analyzed and developed models to support and interact with marketing staff, management team and major clients for future data plans in Hadoop HDFS environment. Closely working with statistical and computational modeling team to extract valuable insights with underlying systems.

Environment: Hadoop, HDFS, MapReduce, NoSQL, Hive, HBase, Pig, Python, ASP.NET, C#, JAVA, XML, SOAP, Web Services, Perl, Sybase, Oracle, SQL Server, UNIX, Informatica

Confidential

Senior Developer

• Supporting counterparty exposure enterprise data and Confidential exchange systems to provide institutional securities business with a consolidated source of positions, balances, nettings and collateral information.
• Integrated OLAP Confidential by implementing business rules and performing data transformation for the accurate and timely Confidential reports to Credit Department, Firm Management, Regulatory Reporting and Business Unit Controllers.
• Designed and implement the database migrations of ETL functionality from Sybase to DB2 UDB to support the strategic trading platforms and data analysis on Fixed Income, Repos, Swaps, Options, MBS, Commodities.
• Design and develop Event Driven UI to integrate the legacy applications and the new DB2 based strategic analytic platform.

Environment: DB2, Sybase, SQL Server, Perl, Python, ASP.NET, C#, JAVA, JDBC, XML, SOAP, Web Services, OLAP, JavaScripts, UNIX/Linux, Informatica, C/C++, autosys, Perforce

Confidential

Senior Developer

• Working with financial users and management team to conceive, re-design and deploy enterprise level financial reporting system.
• Provided P&L statements, balance sheets, audit reports, product risk analysis reports and other relevant financial reports for products like Equity Derivatives, Swaps, Futures, Repo and Fixed Income products as well.
• Established and implemented data analysis and reporting UI tools for controllers and accountants to properly manage and monitor the products.

Environment: Oracle, Sybase, SQL Server, ASP.NET, C#, JAVA, JDBC, Web Services, Perl, UNIX/Linux, C/C++, Autosys, Perforce, Hyperion

Confidential

Senior D eveloper

• Managed the development team to design and build applications delivering exceptional client services to Confidential fund investors.
• Was responsible for the design, development and implementation of Confidential applications including Web portal, Communication Manager, Fund Subscription Service, Investment Management, Document Management and Reporting Tools.
• Integrated APIs and databases for applications used by Private Equity, Real Estate and Infrastructure services.

Environment : DB2, SQL Server, Sybase, ASP.NET, C#, Perl, Informatica, UNIX, JAVA, Autosys, perforce, Salesforce CRM

Confidential

Senior Developer

• Managed the design, development and implementation of Prime Brokerage databases for trading, borrowing, settlements and reporting.
• Worked with end users and third party vendors to define and implement technical solutions. As system support, provide full front-to-backend processing, and manage all relevant data requests for asset controls, accounting, finance, operations and regulatory reporting systems.
• Engaged in data hub infrastructure system designs based on analysis of users and IT requirements. Initiate the Object Oriented distributing and reporting system design by using Perl and DBI/DBD in accessing Sybase databases and bundling data set and methods together. Integrated the existing Perl scripts based reporting system into the new Perl modules to take advantage of the Object Oriented design.
• Managed and developed Equity Derivative trading strategy platform that covers a variety of business lines including Arbitrage and Convertible Bond trading. Provide all necessary support to trading desks for delivery of technology initiatives around the core Equity Derivatives support system.

Environment: ASP.NET, VB, C#, JAVA, XML, SOAP, Web Services, Sybase, UNIX, Perl

Confidential

Senior Developer

• Managed, designed and developed account management applications for Confidential group by using Sybase, UNIX shell, Perl, Confidential WebSphere, UML tools and Object Orient designs.
• Developed business core logic store procedures and functions to provide interfaces for the J2EE based multi-tier systems.
• Established Perl based services and reporting tools that are used for connecting Sybase and Oracle databases, for creating customer-provisioning status and generating reports.

Environment: Oracle, Sybase, JAVA, J2EE, JDBC, XML, SOAP, Web Services, JavaScript, UNIX/Linux, Perl, C/C++

Confidential

Consultant

• Designed financial consulting databases for global private clients. Developed business core stored procedures and provided interfaces by integrating Sybase, SQL Server, CT-Lib, C++, Java and ASP.NET into the applications. Provided financial advisors and account managers statistics analysis tools to calculate portfolio holdings, balances and performances for account re-positioning and tolerance analysis.
• Analyzed and developed a Portfolio Review Application to provide a comprehensive overview and reporting of the fixed income products in a household account. Developed quick reporting and database maintenance tools used for ad-hoc requests and daily status reports, portfolio rebalancing and performance reports.
• Maintained and supported financial advisory commission platform for transaction validation and commission calculation. Provided interfaces for fees, commission distributions and account statements. Responsible for all business core logic stored procedures by using Sybase, CT-Lib and SQL Server.

Confidential

Consultant

• Organized and supervised the integration of a complete mortgage database that is critical for developing modeling services. Also as a DBA, responsible for the performance tunings of the databases and applications. Teamed with Quantitative Developers and Web Service Developers, designed and built Object Oriented Perl modules for calculations based on the models provided.

Confidential

IT Consultant

• Systemized a universal billing platform to replace legacy systems by integrating AT&T Global Customer Billing structures, in accordance to AT&T’s Global Business strategy, which allows AT&T to have a hierarchy structure for managing global business accounts thoroughly.

Confidential

Analyst

• Designed and programmed accounting and sales order tracking systems for corporate clients.