SUMMARY

• 18+ years of experience in Technical analysis, design, development, testing and implementing Software Solutions/Products.
• 10+ years into architecting solutions for huge data systems on both traditional Batch/ETL as well as advanced Hadoop Distributed Computing platforms, 3 years into Financial Market data, 7+ years into Telecom Billing data and an year into Healthcare.
• Architected solutions for data platforms to handle 20B messages per day, and feed about 15+ downstream subsystems that supports enterprise Business and Operational decisions.
• Played Key role building in - house ETL product to handle Ultra-low latency data streams wif proprietary protocols.
• Worked in development of products/applications for teh Financial, Retail and Telecom systems, using Hadoop, HDFS, PySpark, SparkSQL, C/C++, C#, Java on UNIX, Linux and Windows platforms.
• Very good working experience wif Database Systems, Hive, Oracle, DB2, Sybase, INFORMIX, H2, SolidDB, VoltDB.
• More TEMPthan a decade working experience in writing embedded SQL (Pro* C, T-Sql, sqC) programs to work wif different backend Database systems.
• Designed and Implemented interfaces to consume and expose REST/SOAP Web Services.
• Strong working Knowledge on UNIX/LINUX Shell Scripting, Python, Pig.
• Involved in all teh phase of Software Development life cycle (SDLC).
• Well Conversant wif Configuration Management Version Control System which were used to maintain source code / handle Maintenance Requests.
• Good understanding on Hadoop Big Data architecture evolved and how to integrate different components HDFS, Hbase, MapReduce, Pig, Hive, Scoop, Flume, Kafka, YARN, Spark, Lambda architecture, NOSQL Column based databases Cassandra/Green Plum/Netezza.
• Good exposure to Azure cloud and ADF (Azure Data Factory).
• Excellent analytical, problem solving, communication and interpersonal skills.

TECHNICAL SKILLS

Languages: Python, PySpark, C, C++, SQL, PL/SQL, T-SQL, UNIX Shell, JAVA, C#.

Platforms: Hadoop 2.x/3.x, UNIX, LINUX, Windows Server 2003/2010, NT/XP/10

Databases: Oracle, DB2, Sybase, Teradata.

Tools: Oozie, SVN, CMVC, CVS, VSS, Manage Now, Putty, QMF, TOAD, FEXP, BTEQ.

PROFESSIONAL EXPERIENCE

Technical Consultant

Confidential, Harrisburg, PA

Responsibilities:

• Identify MMIS streams to support Children's Health Insurance Program (CHIP) data.
• Review and support X12 encoder modules used in data collection scripts.
• Enhance teh streams to handle CHIP data both new claims as well as claim processing update feed.
• Design new Hive tables to support regulatory reporting for CHIP and work on streams to load data.
• Analyze into teh new requirements, design and develop teh applications based on teh business needs.
• Working on strategies to maintain Hive tables for high performance and quality.
• Review and suggest changes to support data for Heath Plan code types for CHIP.
• Analyze production issues could be released to failure of encoding, data format issues or delayed Capitation/Adjustment Financial reporting generation.
• Worked on activities associated wif on-going support of production environments. dis phase includes required activities to ensure a viable stable environment absent of functional changes. And those activities required to support planned changes such as test environments, software patches or new versions of system software.
• Provide Model Office/UAT support while business is testing new enhancements.

Environment: Hadoop 3.x, HDFS, Spark, PySpark, SparkSQL, Hive/HQL, Linux, Oracle

Technical Consultant

Confidential, Overland Park, KS

Responsibilities:

• As an architect designed solutions to collect, process and distribute usage data.
• Created about 20+ different data pipelines to process different types of network switch data (VoLTE, PGW, SGW, Ericson, Samsung, Lucent, Swat, MGC8, SMS, TCS, TAS, SMS, NGVN C4 and NGVN C5).
• Setup scripts to generate SOX reports and review them weekly basis wif team before they can be shared wif regulatory audit team.
• Enhanced tuned existing data pipelines for performance issues.
• Analyze into teh new requirements, design and develop teh applications based on teh business needs.
• Designed and developed Collector Scripts to bring teh data from staging servers to HDFS.
• Worked on Data Transformation Processing Components that feeds about 15+ downstream subsystems.
• Worked on Hive table design and strategies to maintain database wif high performance and quality.
• Designed worked on Data Encoder/Decoders to bring binary data to/from local format SCF/MVCF format to serve multiple upstream/downstream layouts.
• Designed and Implemented interfaces to consume KAFKA for collecting real-time data of new subscribers.
• Worked on Critical changes required in MSE to meet business requirements both voice and data usage pipelines.
• Code and configure solutions to collect data from new usages, format and sent to downstream applications in teh required format.
• Perform peer review for both design and code changes and provide appropriate suggestions to teh team.
• Designed teh Automated Unit and Regression Testing Framework for most of teh Data Transformation and Processing pipelines.
• Worked on activities associated wif on-going support of production environments. dis phase includes required activities to ensure a viable stable environment absent of functional changes. And those activities required to support planned changes such as test environments, software patches or new versions of system software.
• Supported test/business users till production release.

Environment: Hadoop 3.x, HDFS, Spark, PySpark, SparkSQL, KAFKA, Oozie, Hive/HQL, Linux, Oracle, Postgres

Technical Consultant

Confidential, Overland Park, KS

Responsibilities:

• Build teh in-house ETL solution for Confidential, worked as SME Consultant in teh team to work on new application design, improvements, and existing performance issues.
• Analyze new requirements and correlate wif vendor specs.
• Mentored teh junior developers and lead them to meet deadlines.
• Created/Designed new SQL, PL/SQL objects (tables, indexes, triggers and procedures) for teh in-house solution.
• Build AMTPS/RPC client to collect data from Lucent ECP switches, which is original version of gRpc.
• Worked on different switch collector applications including FTP, AMTPS RPC protocols.
• Developer usage collectors from teh scratch and provided support to move and fix production issues for all network elements: Ericson, Samsung, Lucent, Swat, MGC8, SMS, TCS, TAS, SMS, NGVN C4 and NGVN C5.
• Understanding different messages and formats and mapped them to different outgoing formats (SCF, Telarix, CRE, EDW, Sonar/TEOCO) to support different downstream billing and analytics systems.
• Perform peer review on both design, coding and suggest appropriate changes.
• Designed application wif completely decoupled architecture like fully matured micro services application wif meaningful components (Pre-collector, Poller, Transfer Collector, Stages (Core Message Formatter), Repackager, Transfer Distributer and Flow copy.
• Provide documentation and support for Production support team on teh purpose of different components and how to configure and use them, As everything is new development.
• Debug and analyzing code dumps using gdb and Valgrind tools to detect issues, fix and run Unit Test Cases before releasing to SIT/RTB testing.

Environment: C/C++, Linux, Oracle, Pro*C, RPC.

Technical Consultant

Confidential, Overland Park, KS

Responsibilities:

• Key member in teh group to address any new production issues or existing performance issues.
• Analyze into Traces or core dumps or logs provided, fix teh issues, create and release them client specific patch and wif release instructions to deploy.
• Design and develop teh applications based on teh requirements gatheird by teh Professional Services and by analyzing teh issue.
• Design database SQL queries, PL/SQL functions and stored procedures based on requirements.
• Perform peer review for both design and C++ code, Python, DSD and suggest appropriate changes.
• Fixing teh core product issues in C++ code issues wif thread pools and Mutex and thread locks.
• Analyzing into C++ stack traces and core dumps wif GDB to detect code issues.
• Embedded database queries wif multiple databases in different versions of product.
• Implemented and used Linked lists, Hash Tables, Queue Data Structures as required for optimal performance in teh application.
• Worked on Java changes As Product Frontend is Java Swing Desktop application and J2EE Web Application.
• Analyzing into JBOSS server logs and mediation application logs for frontend application issues.
• Worked wif different JVM options to support application on new hardware, like increase heap size, specify no.of threads, just-in-time (JIT)/ Ahead-Of-Time (AOT) compilers.
• Debug wif gdb and Valgrind tools to detect issues, fix and run ATF for Unit Test Cases and generate installation patches.
• Working wif Different mediation protocols to process Mediation data and Gx/Gy/Sy/Rx to connect to different PCRF interfaces on Diamater Protocol.
• Coordinate wif teh Professional Services and Support teams to enable teh delivery of teh installation files in Production environment.
• Install teh patches for testing and run ATF test cases, perform unit testing based on teh changes and halp other teams on Testing issues in Lab/Production.
• Follow up wif teh Professional Services and Support teams for any issues that might need clarification in teh requirements.
• Activities associated wif on-going support of production environments. dis phase includes required activities to ensure a viable stable environment absent of functional changes. And those activities required to support planned change such as test environments, software patches or new versions of system software.
• Key member in teh group to address any new production issues or existing performance issues.

Environment: C++, Unix/Linux, Oracle, Java/J2EE- FrontEnd.

Senior Programmer Analyst

Confidential, Bentonville, AR

Responsibilities:

• Created/Updated teh SQL/PLSQL database components as per teh new requirements on Informix database.
• Developed/Modified Embedded SQL ESQL/C underlying database layer programs.
• Worked on server components which serve VB.NET front end application using TopEnd as middleware.
• Developed Design documents and conducted reviews wif teh other interfacing application teams.
• Developed C++ programs to generate reports in Excel and parse XML messages received from interface systems.
• Worked on C++ multi threaded functionality implemented using teh Boost thread libraries.
• Responsible for other team member code review as well as design review.
• Being part of CR/Defects team member, responsible for understanding and reviewing new requirements in technical perspective.
• Key member in teh group to address any new production issues or existing performance issues.
• Developed new Unix scripts halped to automate testing execution, save lot of time/accuracy and reduced manual effort.
• Worked on enhancement of existing 4GL modules to accommodate new business requirements.
• Involved in query tuning for many modules where SQL’s are running for longer duration.
• Performed teh Unit testing, Integration testing and System testing. Extended support to teh users in UAT and UCT.

Environment: C/ESQL, C++, HP Unix, Informix, .NET- FrontEnd.

Senior Programmer Analyst

Confidential, Philadelphia

Responsibilities:

• Good understanding teh Stock market Order Entry validation and Order routing rules.
• Used Rogue Wave C++ libraries for efficiency in several modules.
• Worked on compiler up gradation release, server code migration to 64-bit compiler version.
• Responsible for any issues during teh on-call production support days.
• Created/Updated teh SQL/PLSQL database components as per teh new requirements on Oracle RAC environment.
• Developed/Modified Pro*C underlying database layer programs.
• Worked on DOM XML api as all teh interaction between client and server is via XML messages.
• Good noledge on TCP, UDP, OSPF and FIX protocol, as all teh communication wif market vendors is via fix messages.
• Responsible for working wif enhancements and new requirements FINRA or internal organization.
• Developed Design documents and conducted reviews wif teh other interfacing application teams.
• Performed teh Unit testing, Integration testing and System testing. Extended support to teh users in UAT and UCT.

Environment: C, C++, Unix Solaris, Oracle, .NET- FrontEnd.

Senior Programmer Analyst

Confidential, St. Louis

Responsibilities:

• Good experience in processing financial data received in different protocols.
• Enhanced functionality of multi-threaded C-Library for handling higher message transactions.
• Implemented Front-end tickers for FIX (Financial Information Exchange) Protocol and FAST1, FAST2, ASCII data.
• Developed and tuned teh code for conflation algorithms, used in several Line Handlers.
• Processed teh market data for NYSE(CTS/CQS), NASDAQ(NL1/NL2), OPRA, Toronto (TL1/TL2), Canada Montreal (CL1/CL2), Chi-X, Alpha etc. markets.
• Developed Feed Handlers that establish connection to teh exchange using TCP/IP sockets or UDP.
• Developed several Line Handlers to process Level1 and Level2 market data.
• Implemented market logic code to generate market depth and order book.
• Involved in several Day-1 and DE (Data Enhancement) releases for several feeds.
• Worked on teh capacity improvement releases for feeds like OPRA, improved each Line Handler performance from 25K to 60K/Sec.
• Own/maintain feeds wif high transaction rates like 500K (all 24-Lines) per second for OPRA.
• Created/Updated teh SQL/PLSQL database components as per teh new requirements.
• Developed Design documents and conducted reviews wif teh other interfacing application teams.
• Performed teh Unit testing, Integration testing, System testing and Data testing using Bridge Station/Reuters X3000. Extended support to teh users in UAT and UCT.
• Responsible for working wif enhancements and new requirements using RAD model.

Environment: C, C++, MFC, Windows, Unix, Windbg, Oracle.

Senior Programmer Analyst

Confidential, Kansas City

Responsibilities:

• Created teh key based UNIX shell programs to generate reports based on teh configuration file entries.
• Enhanced functionality of multi-threaded C-Library for handling teh D-file (Delimiter file) operations using p threads and Hashing algorithms.
• Used FEXP (Fast Export) and BTEQ (Base Teradata Query) tools to extract teh data from Teradata data base.
• Optimized/Modified teh SQL queries from teh existing reports using Oracle query hints.
• Generalized UNIX shell Scripts can be used in many reports by passing teh respective key arguments.
• Developed Design documents and conducted reviews wif teh other interfacing application teams.
• Performed teh Unit testing, Integration testing and System testing. Extended support to teh users in UAT and UCT.
• Responsible for working wif enhancements and new requirements using RAD model.
• Provided customized reports on user request for teh special business scenarios.
• Documented all teh existing jobs/processes for teh offshore team reference.

Environment: Pro* C, C++, Scripting on SunOS 5.10, Oracle 9i.

Senior Programmer Analyst

Confidential, Milwaukee

Responsibilities:

• Responsible for preparing Initial Design Documents.
• Created shared memory (IPC) segments and mutex variables for teh process synchronization.
• Developed teh programs to read XML from MQ Series using MQ libs and parsed teh xml records.
• Parsed XML files using SAX and EXPAT XML parser APIs from C programs referring memory map files.
• Developed DB2 Stored Procedures and Functions, are called from C routines.
• Worked wif teh Make files and Dynamic Libraries.
• Developed and executed C++ processes and created client/server interface.
• Implemented sorting and searching algorithms to find xml tags from memory map files.
• Automated teh server side make and build UNIX scripts.
• Used CVS to maintain teh code repository.
• Responsible for working wif enhancements and new requirements.
• Developed, tested, and built C processes under multi-tier architecture under UNIX environment.
• Involved in peer review of Initial Design Document prepared by other members.

Environment: C++ on AIX-UNIX 5.2, DB2 UDB 8.2.

Programmer Analyst

Confidential, Raleigh

Responsibilities:

• Developed, tested, and built C++ processes under multi-tier architecture under UNIX environment.
• Responsible for preparing Initial Design Documents.
• Developed and executed C++ processes and created client/server interface.
• Created projects on Windows in Visual C++ and compiled them using make.
• Build and tested teh application in local box on Windows platform.
• Build teh source code using MKS Tool Kit on Windows.
• Automated teh server side make and build scripts.
• Used CMVC to maintain teh code repository.
• Responsible for teh enhancements and debugging teh application using C++.
• Developed or modified and tested Java Servlets and JSP on WebSphere application server.
• Worked in development of teh financial module which specifies actual and entitled prices of teh products.
• Involved in peer review of Initial Design Document prepared by other members.

Environment: C++ on AIX-UNIX, DB2 UDB, Java- Web Sphere Commerce Suite and Application Server.

Programmer Analyst

Confidential, Kansas City

Responsibilities:

• Involved in teh design of teh project using Object Oriented Analysis and Design
• Developed Pro*C programs, to interact wif teh Oracle Database
• Creating and running teh shell scripts to run teh Processes at time schedule according to business rules.
• Involved in setting up teh environment for teh C and C++ libraries, database and solving networking issues.
• Involved in creating Client/Server interfaces.
• Worked wif PL/SQL procedures and used in teh C programs.
• Involved in preparing documents, fixing data issues, and improving teh performance by working wif development and testing team.
• Developed teh shell scripts to execute regular tasks.
• Worked wif existing application, quickly understood, coding and maintaining application.

Environment: C, C++, Pro*C Shell, Oracle, SQL, Sun Solaris UNIX

Programmer Analyst

Confidential, Minneapolis

Responsibilities:

• Involved in design, development, and implementation of teh module.
• Involved in analysis and design of teh application using teh UML standard.
• Automated teh processes using UNIX shell scripts and Job Track Scheduler
• Developing and Testing teh T-SQL programs in Front End using teh PowerBuilder Application.
• Developed applications using Sybase DB-LIB API.
• Developed teh Make scripts to compile teh programs
• Worked wif existing application, quickly understood, coding and maintaining application and optimized teh SQL’s teh better performance.
• Acquired good health care domain noledge by generating different kind of letters.

Environment: C, C++, Sybase, Sun Solaris UNIX, Front end as Power Builder

Programmer Analyst

Confidential

Responsibilities:

• Involved in design, development and implementation of teh module.
• Involved in analysis and design of teh application using teh UML standard.
• Implement code for controls they will be finally placed in teh screens and reports. These controls are used to enter data to teh database and retrieve from teh database.
• Generated reports using .sqC and SQL.
• Creation and scheduling of workbooks to be run on server and storing teh information after teh report are run in teh database.
• Developed many programs to generate reports as teh business requires.

Environment: C, C++, DB2 UDB 7.0, Red Hot Linux, SQL

Programmer Analyst

Confidential

Responsibilities:

• Involved in design, development and implementation of teh algorithm.
• Implemented teh code to DES algorithm to perform encryption and decryption operations on data.
• Testing teh application by taking some sample data.
• Implemented teh code to establish connection between client and server using TCP/IP socket.
• Optimization of teh code for teh better performance of teh application.
• Preparing Unit Test cases and executes them in teh development environment.

Environment: C, C++, Windows.