PROFESSIONAL SUMMARY:

• More than seven years of North American experience in the field of Advanced Analytics, High Performance Computing, Software Development, Business Intelligence, Data Analytics and Business Analysis
• Solid knowledge of Parallel Data Processing using PySpark on Hadoop, Statistical Analysis using SAS and Machine Learning Algorithms using R and Python
• Thorough conceptual understanding of Big Data Eco - System, model deployment using Docker Containers and Kubernetes, Data Structures and Algorithms
• Strong communication and interpersonal skills
• More than five years of IT and Computer Science experience in India around Data Warehousing

TECHNICAL SKILLS:

Project Management Skills: Continuous Project Plan Designing and Process Improvement

Operating System: Windows 98/2000/XP/7, DOS, UNIX AIX

Statistical Tools: SAS, R and Anaconda Python

Languages: C, SQL, PL/SQL, XML, HTML, Perl/Python/Shell Scripting

RDBMS: Sybase, Oracle 8i/9i/10g, Teradata V2R5/V2R6, MS Access 2003, Data Modeling Knowledge

Big Data: HDFS, Hive and Spark

MS Office Suite: Word, Excel, PowerPoint, Visio and Access

PROFESSIONAL EXPERIENCE:

LEAD data analytics CONSULTANT

Confidential, MI

Responsibilities:

• Processed data on HDFS using PySpark through Jupyter Notebook
• Performed feasibility analysis of migrating from SAS to Python/PySpark for massive parallel data processing on Hadoop cluster
• Prepared test scripts in SAS for automatic execution of test cases around customer scoring
• Prepared Python scripts for testing system components on Hadoop clusters such as connectivity to Teradata, Oracle and SQL Server
• Partnered with business users to gather requirements on various model life cycle stages from model development to model deployment on Anaconda Enterprise 5
• Provided Enterprise level Functional support to Anaconda users
• Worked with Anaconda vendor on various orchestration concepts such as Dockers, Containers and Kubernetes

Data ENGINEER

Confidential, OH

Responsibilities:

• Worked on CCAR project in Unix environment where all models were migrated from desktops to SAS grid
• Developed R and Python scripts for loan level mathematical calculations
• Installed R and Python on windows laptops for new users
• Created SAS Datasets to serve as Master Data for all the loss prediction models
• Analyzed data using SAS and Proc SQL & SAS Macro
• Prepared dashboard for monitoring of model execution life cycle
• Prepared aggregated KPIs to track loan level performance
• Analyzed SAS grid environment for optimization of Credit Risk models
• Conducted UAT and provided Production Support to live applications
• Prepared Functional and Non Functional Documents on pulling structured and unstructured data for performing federated search

Data Analytics CONSULTANT

Confidential

Responsibilities:

• Created Mortgage Servicing reports and dashboard using SAS, Macros, Proc SQL, Oracle & Excel in Unix environment
• Created Loan Level Datasets using SAS AND Proc SQL
• Used Statistical SAS Procedures such as Proc Freq for univariate statistical analysis
• Defined KPIs for top executives
• Calculated metrics that helped the business team analyze the performance of key sub servicers
• Responsible for Metadata creation and management
• Performed time series analysis of Loan Level data sets
• Implemented ITSM for new Change Requests
• Worked with business team, data vendors and the Business Intelligence team to ensure availability of data in correct and required format
• Migrated Credit Card applications from old server to new server
• Enhanced the credit card applications using SAS, Oracle and Shell Scripts
• Performed Data Analysis on the data received from vendors
• Provided functional support to the client to resolve their ad hoc queries
• Created business and functional requirement documents
• Led the engagement in all key areas: project scoping, planning, estimation, requirement gathering and implementation through regular client communication
• Performed UAT to ensure smooth delivery of software deliverables
• Coordinated the engagement in a complex & geographically distributed team structure
• Prepared wireframes for executive dashboard for key products
• Managed the incidence management process of an application
• Facilitated and organized different meetings within the team and with the stakeholders

SENIOR ANALYST

Confidential

Responsibilities:

• Supported SunGard’s middle office and back office application used by traders of Confidential for trade settlement in Unix environment
• Created business and functional requirement documents for new enhancement projects
• Managed various user requests and provided them access to some of the Lehman’s middle office applications
• Interacted with system users to make enhancements based on their needs
• Established scope and effectively managed project scope utilizing change control processes
• Interacted with various upstream and downstream systems
• Responsible for identifying and documenting business rules, created detailed Use Cases and conducted User Acceptance Tests (UAT)
• Involved in documentation during various phases of development life cycle
• Developed Perl and Unix Shell scripts to process the files containing financial data from Bloomberg and developed SQL queries to fetch and process data from the data base
• Created and Scheduled jobs using Autosys and Shell Scripts

SENIOR ANALYST

Confidential

Responsibilities:

• Preprocessed the data files using SAS & Proc SQL
• Provided on call support to the batch jobs responsible for processing mortgage data using DataStage and Unix
• Worked on reference data for mortgage banking application
• Worked on data warehousing solutions for business intelligence related solutions
• Prepared Batch jobs using ControlM
• Supported the Credit cards application of Confidential Europe
• Created standard reports that were used key stake holders by using PL/SQL and Stored Procedures written in Oracle
• Responsible for scheduling the deliverables
• Gathered and created functional and technical specification documents as a Business analyst in the UK
• Assisted the technical team in understanding and developing the appropriate functionality of system
• Identified business issues and defined the required solution to ensure delivery
• Established processes for workflow execution
• Extensively involved in creating test plans, test scenarios and test cases

ANALYST

Confidential

Responsibilities:

• Enhanced the trade reconciliations application which was used by traders in the post trade operations
• Provided production support to the Prime brokerage interest rate derivative application of one of the leading investment banks
• Preprocessed the files that were used by Informatica for loading in the data warehouse
• Created Project Plans
• Involved in automation using various scripting languages such as Perl & Shell scripting
• Involved in documentation during various phases of development life cycle