PROFESSIONAL SUMMARY:

• Over 15 years of IT industry experience in Architecting, Analysis, design, development, testing, integration, administration and support of diversified application areas using various technologies.
• Extensively worked with various forms of data/datasets & databases, involving transformations, loads, reporting, analysis etc.
• A great coder for any type of requirement. Extensively worked on various web, scripting, desktop, database, distributed computing programming languages.
• Experience with installing, configuring and troubleshooting various Hadoop ecosystem components like Map Reduce, HDFS, Hive, Sqoop, Flume, Zookeeper, etc
• Experience with distributed computing framework Spark using Scala & Pyspark
• Good understanding of NoSQL databases like Hive, Hbase, Cassandra, MongoDB.
• Good understanding of ETL, Datawarehouse, Data Lakes concepts.
• Expertise in analyzing the data using Spark, HiveQL
• Excellent understanding of various data formats like XML, JSON, CSV, Avro, Parquet.
• Expertise in writing complex SQL queries, Query performance optimization, Stored Procedures/functions, Data loads and data quality.
• Experience in writing & executing Test Scripts for system, Integration, UAT.
• Excellent technical, analytical and quick - troubleshooting skills.
• Excellent modeling & presentation skills.
• Hard-working, productive and invaluable team member.
• Reputed as a quick learner & implementor of new tools
• Enthusiastic to explore more into big data & cloud technologies
• Avid user of Linux desktop & linux tools like Ubuntu, LinuxMint, CentOS etc.

TECHNICAL SKILLS:

Big Data/Science Technologies: Hadoop1/2, HDFS, Spark (Scala/Pyspark), Hive, Sqoop, Flume, Spark Streaming, MapReduce, Kafka, Zookeeper, Pig

Cloud Tools: AWS EC2, RDS, S3, SQS. SES, ELB (Knowledge of Lambda, EMR)

IDE/GUI dev Tools: Anaconda, IntelliJ, Eclipse, MS Visual Studio

Languages (General, database & Web): Python, Scala, Java, PHP, JavaScript/jQuery, SQL, PL/SQL, T-SQL, HTML/DHTML/CSS, VB Script, XML, VBA

Siebel: Siebel 8.x/7.x, Configuration/Integration

Databases: Oracle9i/10g,11g, MySQL, SQL Server, Hive (Knowledge of Hbase, Cassandra like NoSQL databases)

Database Tools: SQL Query Analyzer, Data Import/Export, SQL Profiler, Toad, MySQL Workbench, SQL Developer

Reporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS), MS Excel

Testing Tools: PostMan, SoapUI, HP-QC, BugZilla, other custom testing applications

Distributed Technologies & Integration Tools: Python-Flask RESTful API, Java REST services, Web Services, Java Servlets, JSP, JDBC, Siebel Integrations (EAI, Web Services, HTTP Transports, MQ adapters, integration, VBC), Soap UI, SSIS, Jenkins

Servers/OS: Unix/Centos, Ubuntu, Tomcat, IIS, BEA Weblogic Server, Windows Server(s), Unix/Linux(Ubuntu, Linux Mint etc)

ETL Tools: SQL Server Integration Services (SSIS)

Build Tools: Maven, SBT, Ant

Misc. Tools: GIT, GITHub, SVN, Putty, MS Visio, MS Project, Ambari

SDLC Methodologies: Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

Data/Cloud Engineer

Responsibilities:

• Analysis & design of the data imports into Loyalty RDBMS system & Hive.
• Worked on many POCs for various types of data massaging/processing.
• Design & development of simple RESTful services for real-time parts data into MySQL database using Python Flask-RESTful framework.
• Reading Hive data using Spark & generating meaningful data needed for analytics.
• Building the AWS RDS MySQL instances, and migrating the data into MySQL RDS instances
• Working on importing delimited data into CRM system through various processes.
• Creating EC2 instances, auto-scaling, load balancer, Security Groups etc.
• Creating & managing data in S3 Standard Storage and Glacier
• Worked with deployment & continuous integration using Jenkins.
• Testing the REST API using PostMan & SoapUI
• Working with optimizing the Siebel’s SQL queries by analyzing Oracle Execution Plans, creating/optimizing the database indexes.
• Troubleshooting & analyzing the data using SQL scripts.
• Creating JSON and Soap test cases.
• Writing various SQL queries to analyze and validate the data.

Environment: /Software used: Python Flask-RESTful API, Python 2.7/3.5, AWS, Flume, Java, Anaconda/Spyder, Eclipse IDE, venv, MySQL, Oracle, PostMan, Jenkins, Siebel 8.1 Loyalty application, Siebel Tools/Client, SQL, SQL Developer/Toad, Unix/Linux/Windows, Putty etc.

Confidential, Seattle, WA

Data Engineer

Responsibilities:

• Working on analysis, design & development of integrations between CRM & middleware application layer.
• Loading the Loyalty application data using Spark Streaming into HDFS (Hive ) through Kafka pipelines
• Reading the delimited log file data using Apache Spark & analyzing the application exceptions/errors.
• Loading the data from datawarehouse into Hive partitions
• Reading Hive data using Spark & generating meaningful data/reports needed for analytics.
• Extract the dataset into Spark RDDs/DataFrames to perform various operations or reporting
• Built custom java Flume Sink to import delimited coupon data into staging table
• Working with Siebel Data Model for data imports.
• Developed the Technical Design for integrating Loyalty Accrual & Redemption transactions, Loyalty member, cards, coupons.
• Troubleshooting & analyzing the data using SQL scripts.
• Creating various test-cases & executing using SoapUI
• Writing various SQL queries to analyze and validate the data.

Environment: /Software used: Apache Spark, Spark Streaming, Kafka, Flume, IntelliJ, Scala, Siebel CRM, Oracle 11g, SoapUI, SQL, PL/SQL, SQL Developer/Toad, Subversion, Sharepoint, HP-ALM/QC, Unix, Putty etc.

Confidential, Minneapolis, MN

Application/Data Engineer

Responsibilities:

• Worked on the analysis & design of Integration between Siebel & web applications using Shell Scripts, Web Services, Spark, SQL Scripts.
• Used Apache Spark RDDs & DataFrames to transform & analyze the Delivery schedules data stored in Hadoop cluster using PySpark (Python on Spark)
• Writing various SQL queries to analyze and validate the data.
• Wrote the shell scripts & SQL/PL-SQL scripts to generate the CSV files of daily scheduled Service Requests for Cisco Auto-dialer.
• Worked with cron jobs to generate SR/Activities data.
• Worked with Siebel data model.

Environment: /Software used: Apache Spark, Python/Scala, Siebel 8.1 Call Center Tools/Client, Apache Spark, Oracle 11g, SQL, PL/SQL, Shell Scripts, SQL Developer, Subversion, Sharepoint, HP-ALM/QC, Unix, Putty etc.

Confidential, Sunnyvale, CA

Sr. Technical Consultant

Responsibilities:

• Designed & Developed the Java RESTful Services for integration with Siebel CRM
• Built a tool using Java to generate & import the Product Eligibility Compatibility rules into Siebel.
• Migrations/importing the Maximo data model to integrate with Siebel CRM using Sqoop.
• Working with migration of Order management entities (Quotes, Orders, Fulfillment, Work Orders, Assets/MACD ).
• Validating importing legacy Assets using SQL scripts.
• Writing SQL queries to analyze and validate the data.
• Working with Siebel Data Model & optimizing the Siebel SQL queries by analysing Oracle Execution Plans, creating/optimizing the database indexes.

Environment: /Software used: Eclipse Neon, Java RESTful API, Tomcat8, Siebel 8.1 Call Center Tools/Client, Oracle 11g, SQL Server, SQL, T-SQL, SQL Developer/Toad, HP-ALM/QC, BI Publisher, Subversion, Sharepoint etc.

Confidential, Portland, OR

Data Engineer

Responsibilities:

• Created Java RESTful Services needed for Portal integration for Member enrollment, Providers Query, Household query etc.
• Working with Siebel data model for integration.
• Working with Data Maps for data transformation.
• Validating the data for Health Provider/Network/Plans.
• Writing SQL scripts to analyze and validate the data.
• Worked with configuring Siebel objects as per Oracle Expert Services review comments.
• Exposure to Siebel Open UI.

Environment: /Software used: Eclipse IDE, Java REST API, Tomcat7, Siebel 8.2.2.3 Public Sector, Oracle 11g, SQL, Soap UI, SQL Developer, Maven, XML, JIRA etc.

Confidential . S. Portland, ME

Siebel CRM Integration Architect

Responsibilities:

• Analysis, Design, Development of Siebel to B2B integration.
• Working with Siebel real-time integration using HTTP Transports, Web Services, Runtime events and Workflow Policies
• Develop various workflow processes that are invoked by runtime events
• Created a RTE service layer to capture Runtime Events as jobs
• Worked with Server Requests business service to submit workflow request jobs to specialized component.
• Worked with Siebel Integration Objects for integration between Siebel & web applications.
• Worked with various Siebel component jobs/RCRs.
• Worked with HTTP transports to send IO/XML messages to a web application.
• Siebel application configuration involving various Siebel objects using Configuration, eScripting, Server Component administration.
• Working with various SQL scripts to verify data.
• Working with SSIS packages for migrating data.
• Working with Communications Outbound Manager, Communication profiles to send emails
• Server administration tasks like full compilation, srf replacement, browser-scripts, component administration, Server shutdown/restart
• Working on Siebel Data Model & analyze the SQLs.

Environment: /Software used: Siebel 8.1 Call Center, Oracle 11g, SQL, SQL Server 2010, SSIS, HP ALM/QC, Soap UI, Putty, Unix, Toad, XML, Subversion etc.

Confidential, Santa Clara, CA

Siebel Integration Consultant

Responsibilities:

• Analysis, Development, Testing of Siebel to Mobility integration.
• Developed Siebel Inbound Web Services to enable Mobile Integration Platform to consume & display data in Mobile devices using mobile app.
• Worked with the Integration Objects, its Components and keys to be used for data to be exchanged between Siebel & Mobile app.
• Worked with Data Mapping to convert the data from one IO format to another
• Developed custom workflows to enable the Mobile app to choose appropriate Statuses by integrating with Siebel State Model for Service Requests & Activities
• Worked on Web Service WSDLs to generate the SOAP requests
• Worked with the SSO & AD based integration using Session Tokens between SOAP requests
• Siebel application configuration involving various Siebel objects using Configuration, Scripts (eScripting), Server Component administration.
• Designing the High Level Design Documents for application integration.
• Testing SOAP requests using Soap UI.
• Working with SQL scripts using joins defined in Business Component.

Environment: /Software used: Siebel 8.1 HTIM, Oracle 11, SQL, Soap UI, MS-Visio, MS-Project, HP Quality Center, XML etc.

Confidential, Culver City, CA

IT Specialist/Analyst

Responsibilities:

• Analysis, Developing, Testing and Support of the internal payroll processing applications.
• Generation of hundreds of ad-hoc reports to business users as needed by the external clients
• Analysis and implementation of the new development changes for application integration
• Analysis of the new development changes needed for the existing Siebel application by interacting with business users and proposing new solutions
• Data imports using SQL loads and SSIS packages
• Created T-SQL Stored procedures to back the reports
• Developed many reports using the SQL queries, stored procedures, Crystal Reports, SSRS.
• Designing the High Level Design Documents for application integration.
• Testing various internal applications.
• Worked on development & support of a PHP/MySQL application
• Exposure to the CapsPay payroll application using GoogleSDK for Java

Environment: /Software used: SQL Server, SQL/T-SQL, Crystal Reports, SSRS, SSIS, Putty, Unix, Eclipse, PHP, MySQL, MS-Visio, XML etc.

Confidential, Jacksonville, FL

Siebel Analyst/Developer

Responsibilities:

• Analysis of the business EAI and Product Administration requirements and coordination of the requirement development
• Writing & Execution of Test Scripts
• Involved in analysis/design of product visibility using Catalog Categories & Access Groups.
• Writing test scripts for testing the specific business requirements.
• Close interaction with the business/end users for understanding the business requirements and the Test Scripts to be created.
• Developing the Test Scenarios in Mercury Quality Center and interacting with various teams for integration testing.

Environment: Siebel Finance, Siebel 7.5 Client, Oracle 9i, HP ALM/QC, XML, SQL, PL/SQL, MS-Visio, Unix

Confidential, Milwaukee, WI

Siebel Techno-Functional Consultant

Responsibilities:

• Analysis of Business Requirement related to Order Management objects (Opportunities, Revenues, Quotes, Activities).
• Development of new Siebel application requirements using Application Configuration, eScript, Workflows, Assignment Manager, Data Maps.
• Application configuration using data Tables, Business Components, Business Objects, Pick Lists.
• Designed various Workflows as per the requirements
• Worked on Application Internationalization using Symbolic Strings and apply them to various UI objects.
• Worked with Data Maps for copying data from Opportunity to Quote.
• Performed Code Review meetings to ensure the application confirms to Siebel recommended standards.
• Wrote various Design Documents HLD, LLD and Review the design documents
• Writing the Test Scripts (OQ) for testing application navigation to test UI and the negative testing
• Executing test cases in HP Quality Center.
• Provided support for testing phases (OQ, PQ) by providing the test data, analyzing and clarifying the issues as necessary and supported the users as a post go-live process
• Extracting the component logs and troubleshooting various application issues

Environment: Siebel Life Sciences, Siebel 8.0 Tools & Client, SQL Server, Windows/Unix, HP Quality Center, XML, SQL, PL/SQL, MS-Visio

Confidential, Hoffman Estates, IL

Sr. Siebel Developer

Responsibilities:

• Involved in migration of Siebel database from Oracle 9i to 10g.
• Configured and setup database drivers needed that support Siebel 8.0.
• Supporting various Queue & HTTP transport based integration modules
• Setting up the new Development, Test and Production environments by Installing Database, Gateway, Siebel servers, SWSE on Windows servers.
• Starting & shutting down of the Siebel server, gateway, and web server to replace srf or troubleshoot the application.
• Experience in creating Database extract for the developers for their local database initialization.
• Siebel Server administration and user management, roles and responsibilities.
• Responsible for coordinating the requirements, design, development and testing.
• Configured the Siebel objects at business object, UI layers for enhancements required by the business.
• Designed the table level Mapping between External Table/columns to Siebel EIM Table/columns
• Worked with SQL loader utility to load the data from flat files onto Siebel temporary tables.
• Developed the database procedures & triggers to process the data before entering the Siebel database.
• Prepared IFB files and created EIM jobs to load Siebel base tables
• Establishing the communication between Siebel and web application running on Tomcat web server.
• Analyzing the Siebel application logs and troubleshooting the issues.

Environment: Siebel Financial, Siebel 8.0 Tools & Client, Windows Server 2005, Oracle 10g, Apache Tomcat, JSP, SQL, PL/SQL

Confidential .

Techno-Functional Siebel Consultant

Responsibilities:

• Implemented Business Object layer by customizing/creating Tables, Business Components and their mappings to view the relevant data on UI.
• Implemented Presentation layer by customizing/creating the UI objects like list/ form/ MVG/ Association Applet, Views, Screens.
• Understand Siebel Data layer and create any EIM loads needed to import data into the relevant tables
• Analysis and development of Integration business requirements for the data coming into Siebel from various interfaces (ODM, BAL, CMPAL).
• Configured the specialized Drilldowns (static & dynamic) for navigation to various views/applets as per the business needs.
• Devised and developed the workflows for processing the event-feed messages coming from interfaces.
• Worked on Integration Objects that represent the data that is passed across systems through an MQ Series middleware.
• Interaction with interface teams for bringing the consistency with the messages/XMLs exchanged between systems.
• Designed the workflow that verifies the data content in the XML and insert the data in Siebel based on the content in XML.
• Created a core API/Business Service to record/track all kinds of communications to the customer in the form of Email/SMS/Letter/Callback.
• Created various Communication Templates for Email/SMS/Letter.
• Worked with Inbound and outbound Web Services to process data with and from java/web applications.
• Worked extensively with XMLs and their processing objects.
• Modified the CSS/template files for adjustment of layout of the application.
• Configured the customer Dashboard.
• Worked with Component Requests and the workflows to be invoked periodically
• Writing various design documents, LLD and HLD

Environment: Siebel Call Centre, Siebel 7.7 and 7.5.3 Tools/Client, Oracle 8, Unix, SQL Loader, XML, SQL, PL/SQL

Confidential .

Siebel Developer (Siebel eCommunications)

Responsibilities:

• Design the LLD and organizing review meetings
• Configured the applets, views, screens objects on UI.
• Administration of data visibility by creating the users, positions & their responsibilities
• Configured the Drilldowns (static & dynamic) for navigation to various views/applets as per the business needs.
• Configured the Pick Lists (static & dynamic) for getting data from LOVs or other business data.
• Developed control files for Assets, Products data load from csv files to temporary tables using SQLLDR utility.
• Developed PL/SQL scripts to process the data in temporary tables and transfer onto EIM tables.
• Run EIM job to migrate the data onto Siebel base tables.
• Run the versioning job workflow for the loaded products.
• Developed eScript code to migrate the Assets data from Siebel to flat files.

Environment: Siebel Call Center, Siebel 7.5 Tools/Client, Unix, Windows 2000, SQL, PL/SQL

Confidential,

Software Consultant

Responsibilities:

• Customization of Siebel application using Siebel Tools
• Configuration of database layer by customizing/creating tables to fetch the data into Business Objects to view the relevant data.
• Creation and layout of UI objects, Applets, Views, Screen
• Implemented business functionality using custom SQL & PL/SQL procedures/triggers.
• Usage of specialized User Properties for best configuration techniques.
• Creation of predefined queries as per business requirements.
• Creation of List of Values and hierarchical Pick Lists to ensure only valid data enters the system.
• Installation & management of Siebel Tools, Client, local database extracts and initialization.

Environment: Siebel Call Center, 7.5 Tools, Client, Windows Server 2000, Windows XP, Oracle 8i

Confidential,

Software Engineer

Responsibilities:

• Designed the web pages using HTML and JavaScripts for business needs.
• Generated reports on monthly for a specific unit/Service Engineer.
• Developed data migration tool/engine that transfers the legacy data in flat files into the Java Objects and migrates the data into the database of appropriate fields using Java objects.
• Designed database schema for specific reports
• Developed data load that can work either foreground or background. Foreground option was enabled for few set of records/data coming from external sources. This enabled user to check for validity of data entering the database.
• The background option was provided for huge data load of new items brought into the system. Background migration is faster and allows for processing of errors on-the-rise basis or after complete data transfer.
• Administering/troubleshooting the application

Environment: J2SDK1.4, Eclipse IDE, J2EE, WebLogic 7, SQL Server 2000, Windows NT, HTML, MS-FrontPage 2000.