SUMMARY:

 Data Analyst with 8+ years of experience in data cleansing/wrangling, data manipulation, descriptive
 Extensive knowledge on supervised and unsupervised Machine Learning concepts
 Experienced Data Analytics Engineer with a strong background in programming, algorithms, predictive
modeling, machine learning and data insights looking to be a part of a team with an innovative, creative and
fast - paced work culture.
 Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to
handle multiple tasks and work well in a team environment.
 In depth knowledge of financial concepts and various financial instruments like stocks, bonds, derivatives etc.
 Possess a strong mathematical and statistical background with proficiency in programming languages like R
and SQL.
 Good experience in using WAMP (Windows, Apache, MYSQL, and Python/PHP) and LAMP
 Rich experience performing data analysis and creating visualizations using Tableau.
 Proficient with MS Excel and using advanced functions like Vlookup, Pivot Tables, Pivot Charts for data
analysis and reporting.
 Experience with Requests, NumPy, SciPy, Pytables, cv2, imageio, Python-Twitter, Matplotlib, HTTPLib2,
Urllib2, Beautiful Soup, Data Frame and Pandas python libraries during development lifecycle
 Proficiency with analytics with text-based data and building models using scikit-learn
 Extremely passionate about Machine Learning and hands on experience creating statistical models using
Regression, Classification and Clustering.
 Extensive experience with Relational Databases and using SQL for data analysis including joins and Analytical
functions.
 Executed complex HiveQL queries for required data extraction from Hive tables and written Hive UDF’s.
 Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to
handle multiple tasks and work well in a team environment.
 Experience with data warehousing, ETL processes and database management concepts with tools such
 Dedicated team player with excellent communication and presentation skills.
 Good Experience in Linux Bash scripting and following PEP-8 Guidelines in Python.
 Possess solid organization, negotiation, analysis skills and demonstrated ability to deliver on multiple
assignments, meet tight deadlines and be effective and decisive under pressure.

TECHNICAL SKILLS:
 Business Intelligence & Reporting: Tableau, Business Objects, Crystal Reports
 Programming Languages: SQL, R, Python, SAS, Oracle SQL, T-SQL, PL/SQL, UNIX Shell Scripts, Oracle
SQL
 Operating Systems: Windows, LINUX, UNIX, IBM Mainframe
 Databases: Teradata, Oracle, IBM DB2, SQL Server, Sybase, Redshift
 Relational Databases: SQL Server 2014, 2012, Oracle 12c, 11g, MySQL, MS Access
 Data Quality: Develop custom tool in PL/SQL, Informatica Data Quality, Confidential QualityStage
 Big Data Technology: Apache Hadoop, Hive, Pig Scripting Language JavaScript, HTML5, CSS Operating
Systems Linux, Mac OS, MS Windows
 Web Technologies: HTML, Adobe Dream Viewer
 Azure DevOps, Azure analysis services, Azure Datafactory

EDUCATION:

 Bachelors In Computer Information, New York City College and Technology, New York

PROFESSIONAL EXPERIENCE:

USAA, San Antonio, Texas Aug 2022 – Till

Date
Data Analyst

 Analyzed by measuring channel effectiveness interms of member communication emails, inbounds,

outbounds calls, and USAA applications.
  Analyzed Members online banking activities and the success rate, how many MSRs are working on inbound
and outbound calls, the fallout rate for auto generated and safe harbor letters, delinquent members in their
payments.
 Digitalized for overall USAA application, calls, bill pay, and email to provide members fastest, reliable and
hassle-free banking experiences in day-to-day life.
 Recovered, maintained, monitored, updated and modified existing Tableau Dashbaords on request for future
Business usage.
 Validated various sources of data for usable information in Snowflake, Hadoop, GPM
 Input data from available sources into relevant fields
 Coded data into groups that provide insights
 Transformed data into actionable information
 Maintained records as requested by Director Data Information and Analysis.
 Analyzed data to identify trends and notable changes using Coginity pro and Snowflake.
 Developed visual representations of quantitative and qualitative data using Tableau.
 Developed dashboards that automatically represent key data
 Ensured security of system and integrity of master documents by implementing document and system access
rights and revision controls.
 Ensured the company complies with applicable laws and regulations regarding data security and document
management.
 Developed with IT systems experts on hardware and software issues that affect the availability and
accessibility of content management systems.
 Digitalized base applications and based on that we will create our ad hoc reports, tactical and strategic
solutions using SAS, SQL and Tableau report to reveal a success rate to our business.

Experian Information Solutions, Inc.,New York, NY Nov 2020 - July

2022
Sr. Data Analyst

 Conducted meetings with the business users from HR and Legal domains to undertand the business use case
and other reporting requirements.
 Developed tools using Python, Power Shell scripting, XML to automate some of the menial tasks.
 Created reports, visualizations in Excel, Tableau and presented the results and insigts to the business users.
 Improve models that impacts company’s revenue and sales as a tool to marketing team to assist a deeper
understanding of the current and future events when making financial decisions and planning.
 Provided production support for python ETL application.
 Studied in-house requirements for the Data warehouse to be developed, Conducted one-on-one sessions with
business users to gather data warehouse requirements
 Worked with the data science team and to preapre a model for predicting employee turnover.
 Understanding and utilizing the historical, forecast data for bench marking to explore insights of consumers
purchasing behavior and providing reports and statistical analysis to optimize and influence company’s
revenue based on the findings in reports.
 Designed parameter-driven reporting environment or super users to directly access the data warehouse to
create ad-hoc reports.
 Involved in Data pipelines using python for medical image pre-processing, Training and Testing.
 Creating Financial Reports with predictive financial indexes by utilizing advanced SAS Programming, Macro
Language, SQL, Shell Scripting using historical data on Teradata DB or Transactional Data on Oracle,
 Insight analysis to improve existing indicators and create new matrices that impacts the growth of the sales
and revenue.
 Helped building a customer Master Data Management, by creating unique identifiable customer profile.
Identify anomalies of customer profile using R; find a remediation
 Knowledge of software engineering best practices and development life cycles, including coding standards,
code reviews, source control, build processes, testing, and operations.
 Validated data flow from source to the target system using SQL for a new in house application used for
identifying access persons per the SEC requirements.
 Performed due-diligence with the existing data in data warehouse, Generated ad-hoc SQL queries using joins,
database connections and transformation rules to compare and evaluate the prediction models.
 Created Data Mapping Document, for defining data flow between data source and target, with business rules.
 Used JIRA, Service Now for projects and issue tracking.
 Managing and designing the reporting environment, including data sources, security, and metadata.
 Developed Tableau reports and analysis.
 Processing confidential data and information according to guidelines.
 Participated in grooming backlog, daily scrums, retrospectives, and sprint reviews with product owner and
technology partners to meet release timelines and adding business value.
  Experience working with Agile and Test-Driven development within the software development lifecycle
(SDLC).
 Supporting initiatives for data integrity and normalization.

Land O’Lakes Inc., Minnesota, MN Sep 2019 – Oct 2020

Sr. Data Analyst

 Faciliatated and led meetings with the client to analyse the business needs and other ad-hoc requests.
 Created reports and visualizations to analyse data using MS Excel and Tableau and provided
recommendations to the client.
 Create key performance indicators, trending analysis, and advance pricing analysis to maximize the Revenue
as an assistance tools to Revenue Management team.
 Used MongoDB to stored data in JSON format and developed and tested many features of dashboards using
Python.
 Developed rest API's using python with flask framework and done the integration of various data sources
including Java, JDBC, RDBMS, Shell Scripting, Spreadsheets, and Text files.
 Understanding and utilizing the historical, forecast data for bench marking to explore insights of consumers
purchasing behavior and providing reports and statistical analysis to optimize and influence company’s
revenue based on the findings in reports.
 Extracted, Transformed, and Loaded multiple data sources into a data warehouse using SSIS. This historical
database designed mainly for reporting and analytic purpose.
 Extensive experience in Enterprise Information Management and Architecture technologies including
Information Lifecycle, Master Data Management and Business Intelligence.
 Built and maintain a scalable data infrastructure (ETLs, data warehouses, views, etc.) that integrates
disparate, user-level data sets into a unified view to make analytics easy and effective for all Confidential
employees.
 Developed analytical solutions using python.
 Coordinated with the tech team to research data issues and anomalies.
 Extensively used joins and partition functions in SQL to extract data stored across multiple tables in Relational
Data Warehouse and getting it ready for further analysis.
 Commissioning and decommissioning of data sets.
 Insight analysis to improve existing indicators and create new matrices that impacts the growth of the sales
and revenue.
 Processing confidential data and information according to guidelines.
 Created machine learning models using R and refreshed existing models to improve their accuracy.
 Commissioning and decommissioning of data sets.
 Developed Tableau reports and analysis.
 Provided technical expertise on data storage structures, data mining, data mapping and data cleansing.
 Created MS Powerpoint presentations to communicate the results and recommended future strategy to the
client.
 Managing and designing the reporting environment, including data sources, security, and metadata.
 Supporting the data warehouse in identifying and revising reporting requirements.

Oracle, Redwood City, CA Feb 2018 – Aug 2019

Data Analyst

 Met with the business users and stakeholders to understand and document the business requirements.
 Worked in a Relational Data Warehouse environment and extensively used SQL for data analysis.
 Prepared modeling and visualization design mockup documents
 Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
 Improve models that impacts company’s revenue and sales as a tool to marketing team to assist a deeper
understanding of the current and future events when making financial decisions and planning.
 Implement code in Python to retrieve and manipulate data.
 Developed python scripts to automate Data Analysis.
 Created dashboard and pivot reports to underwriters and loan officers to trace the loan process
appropriateness
 Validated the data flow from source to target tables to ensure data is loaded per the business rules.
 Created dashboards and reports using MS Excel and Tableau.
 Organized visualization requirement use case JAD sessions
 Discover business narratives told by the data and presented them to business stakeholders, and managers at
various levels.
 Manage all business data related to Revenue management including the captured data from industry as well
as internal data.
 Supporting initiatives for data integrity and normalization.
 Developed various dashboards, used context filters, sets while dealing with huge volume of data.
  Creating pricing Models to be used in making better decision to achieve the best price for the new accounts
and assisting Revenue Managers to make better decision utilizing the Model.
 Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports
 Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the
Logical Data Model
 Worked on development of data warehouse, Data Lake and ETL systems using relational and non
relationaltools like SQL, No SQL.
 Utilizing Tableau Application or Microsoft Excel as a key reporting tools.
 Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin
r9.5

Credit Spectrum, Inc., New York, NY Mar 2017- Jan 2018

Data Analyst

 Conducted meetings with business users to understand the business requirements and documented them by
preparing Business Requirements document.
 Creating Financial Reports with predictive financial indexes by utilizing advanced SAS Programming, Macro
Language, SQL, Shell Scripting using historical data on Teradata DB or Transactional Data on Oracle,
 Designed, developed, and tested visualization Power BI dashboards and reviewed with user community
 Utilizing Tableau Application or Microsoft Excel as a key reporting tools.
 Experience and Technical proficiency in Designing, Data Modeling Online Applications, Solution Lead for
Architecting Data Warehouse/Business Intelligence Applications.
 Worked in an Agile environment and participated in daily standups
 Established data cataloguing to standardize business definitions, data sampling, and data mapping
 Developed ORM data mart star-schema (12 conformed dimensions, 4 grain facts and 6 aggregated facts)
 Productionized solution collaborating with DBA and Automation tea
 Wrote the data ingestion routines to pull the information from multiple source systems during the regular
intervals
 Developed Data Mapping, Transformation and Cleansing rules for the Master Data Management Architecture
involved OLTP, ODS and OLAP.

 Creating pricing Models to be used in making better decision to achieve the best price for the new accounts
and assisting Revenue Managers to make better decision utilizing the Model.
 Organized visualization requirement use case JAD sessions.
 Productionized solution collaborating with DBA and Automation team
 Summarize analytical data into user - friendly reports by translating highly technical, detailed data into
appropriate recommendation for senior finance management for forecast and financial decision making
 Involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships,
providing access to the users and adding them to the specific group and scheduled instances for reports in
Tableau Server
 Conducted statistical analysis to validate data and interpretations using Python and R, as well as presented
Research findings, status reports and assisted with collecting user feedback to improve the processes and
tools.
 Financial Analytics & Systems Architecture Transformation in Master Data Management, Data Warehouse
and Business Intelligence design & implementation.
 Performed reconciliations for Single Family Servicing Data for Relational Data warehouse.
 Designed, developed, and tested visualization Power BI dashboards and reviewed with user community
 Extensively used SQL to extract data from Database and to respond to ad-hoc customer requests.

Numero Data LLC, Herndon, VA Nov 2015 – Feb 2017

Business/ Data Analyst

 Gathered business requirements from business users, SME, and stakeholders to understand their needs and
requirements
 Validated the GUI results with the database using SQL.
 Maintaining confidential database and information.
 Good working knowledge on Data warehousing concepts like Data Warehouse Architecture, Star schema,
Snowflake schema, Data marts and Dimension and Fact tables
 Summarize analytical data into user - friendly reports by translating highly technical, detailed data into
appropriate recommendation for senior finance management for forecast and financial decision making
 Developed comprehensive deployment instructions for IA 11.5 Confidential .
 Identified impacts of IA 11.5 Confidential within DQ.
 Conducted data analysis utilizing MS Excel tools like pivot tables, vlookup, graphs, and formulas.
 Coached and mentored GDC resources to leverage 11.5 features such as SQL Virtual tables to write complex
SQL rules.
  Tested entire DQ cycle in 11.5 to identify gaps, compatibility issues and defects.
 Seamlessly implemented changes into production.
 Technologies: Erwin, MS SQL Server 2012, Power BI Visualization Analytics, SharePoint, Jira and Lucid
Chart
 Automation of Finance Reports by SAS programming and Scripting to develop an efficient and error free
reports.
 Responsible for ETL Operation which extracts and transforms the data to Data Warehouse usingSSIS
 Prepared operational supporting document to deploy and maintain production activities
 Developed normalized Logical and Physical database models to design OLTP system for Mortgage
applications
 Gathered the requirements, analyzed the gaps, and interacted cross functional teams to finalize the business
needs
 Developed entire frontend and backend modules using Python on Django Web Framework.
 Created, Maintained & scheduled various reports in Power BI
 Map source system data elements to target system and develop, test, and support extraction, transformation
and load processes.
 Prepared operational supporting document to deploy and maintain production activities

HSBC, New York, Oct 2014 - Oct 2015

Data Analyst

Used Rational Unified Process (RUP) Methodology in defining the problem and gathering requirements and prepared
use case specification.
 Responsible for all project documentations and assisted testing team in understanding the business rules and
the system development.
 Responsible for ETL Operation which extracts and transforms the data to Data Warehouse usingAlteryx
 Provide ad hoc financial reports and answers to variety finance matrices fluctuation to Management on the
daily bases.
 Supporting the data warehouse in identifying and revising reporting requirements.
 Good knowledge of Apache Spark for using Big Data
 Commissioning and decommissioning of data sets.
 Developed Tableau reports and analysis.
 Automation of Finance Reports by SAS programming and Scripting to develop an efficient and error free
reports.
 Involved in the dimensional modeling of Data warehouse.
 Performed systems and UAT testing, in collaboration with development and production team to ensure the
systems meet with requirements in term of efficiency and performance.
 Prepared testing documentation including test objectives, test cases and test plan.
 Developed standard and Confidential hoc reports using T-SQL, SSRS and presented to Product Manager and
Executives.
 Good knowledge of Version Control Software - SVN, GitHub.
 Designed and developed methodologies and procedures to carry out effective analysis, provided training to
the end-users on the new systems implemented.
 Maintaining confidential database and information.
 Involved in the dimensional modeling of Data warehouse using Erwin tool
 Managing and designing the reporting environment, including data sources, security, and metadata.
 Worked in a production and test environment to design, develop and maintain the Premier Control Center, a
java-based e-commerce application that helps business customers, large and small to monitor and manage
their products and services.
 Provide ad hoc financial reports and answers to variety finance matrices fluctuation to Management on the
daily bases.
 Processing confidential data and information according to guidelines.
 Good Knowledge of web services using SOAP and REST protocols.
 Modifying, updating, and converting of legacy Codes and financial strategies to sync with a modern an up to
date form that sync with the current economy direction and prediction on monthly bases using all technical
tools on hand such as SQL, SAS programming and Microsoft office tools.
 Hands-on experience with bug tracking tools JIRA and IBM Peregrine.