SUMMARY

• An IT professional with 8+ years of experience working as a Data Analyst in Banking/Finance sector.
• Experienced in Agile (Scrum), Waterfall and various Software Development Life Cycle (SDLC) processes and methodologies.
• Experienced with Data Warehouse in the development and execution of data conversion, data cleaning and extractions, data governance, data profiling and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Sound Involvement with AWS services like Amazon EC2, S3, EMR, Amazon Elastic Load Balancing, IAM, Auto Scaling, Cloud Front, CloudWatch, SQS, and Lambda to trigger resources.
• Experienced working on Tableau to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End - user and help them make effective business.
• Solid knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snowflake Modeling for FACT and Dimensions Tables) using Analysis Services.
• Experience in Data modeling for Data Warehouse development, Data Analysis for Online Transaction Processing (OLTP) and Business Intelligence (BI) applications.
• Experience in writing database object and ETL technical specification documents/STMs.
• Experience in consolidation of data systems for statistics into snowflake data warehouse using Talend.
• Experience collaborating with DBAs and ETL developers to identify and resolve technical, data quality, and change management issues.
• Knowledgeable in cross-validation techniques of Machine Learning models.
• Expertise in Data Visualization by producing tables, graphs, listings using various procedures and tools.
• Proficient in checking the APIs, if returning data in XML format is not as defined in the API documentation.
• Worked with database development and designing using Big Data, Oracle SQL, PL/SQL using TOAD and Microsoft SQL server T-SQL, Teradata, and MS Access.
• Experienced in Python to manipulate data for data loading and extraction.
• Highly skilled in using Hadoop (pig and Hive) for basic analysis and extraction of data in the infrastructure to provide Data Summarization.
• Experience in automating recurring reports using SQL and Python.
• Experience with Microsoft SQL Stack including SQL Server Reporting Services (SSRS) & (SSIS).
• Experience interacting with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate, and validate requirements using Joint Application Design (JAD), Joint Application Review (JAR) sessions.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Participated in weekly project status meetings and task review meetings, documented, and disseminated meeting minutes effectively.

TECHNICAL SKILLS

Methodology: Agile-Scrum, Waterfall, Hybrid

ETL Tools: Informatica Power Center, MS SQL Server Integration Services (SSIS), Data Stage

Reporting and Visualization Tools: Power-BI, COGNOS-BI, Query Studio, Report Studio, Tableau, SSRS, MicroStrategy, Crystal Reports, MS Project, MS Office, MS SharePoint

Data Modeling: Erwin, Star-Schema Modeling, Snowflake Schema Modeling

Programming Languages: SQL, PL/SQL, HTML, Visual Basic, Java, UNIX shell scripting, Python, R

Database: Oracle 11g/10g/9i/8i/7.3, SQL Server, MS Access, Azure Devops, AWS

Utilities: AWS (RedShift, EC2, EMR, Lambda, S3, AWS IOT), Azure, Tableau

Operating System: Windows, UNIX, Linux

Programming Tools: SQL*PLUS, SQL* Loader, TOAD

Big Data: Hadoop, Spark, Spark SQL, and Hive

Defect Management: HP Quality Center/ ALM, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Data Analyst/ Reporting Analyst

Responsibilities:

• Created Interactive Tableau Dashboard after gathering and analysing the data from the warehouse to illustrate the metrics of the business process.
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including MS SQL Server andTeradata.
• Developed interactive Tableau visualizations after gathering Business Requirements to illustrate KPI and Performance metrics of the business processes.
• Worked on Informatica to resolve issues, perform debugging of mappings and reports.
• Extraction of test data from tables and loading of data into SQL tables.
• Involved in several complex financial reports related to Non-performing Loans portfolio, which includes Credit Loss Reporting Package and Annual Reports Package.
• These reports produced were able to support executive decision-making.
• Provided data analysis of data as requested by the business users for business efficiencies.
• Developed MDM strategies and solutions utilizing SQL server MDS tools.
• Active MDM team player to ensure targets and metrics are achieved.
• Facilitated request for adds/changes to the MDM subject areas (new fields / list of values).
• Responsibility for the production of all formal documentation related to the IT infrastructure.
• Worked with data migration team to move raw data from varies sources to AWS/Redshift.
• Diagrammed data models which conformed raw data to a dimensional model to facilitate ETL processes in DataStage and AWS.
• Processed numerous terabytes of data stored in AWS using Elastic Map Reduce (EMR) to AWS Redshift.
• Maintaining Data quality high threshold at 99% and low threshold at 98%.
• Performed datamapping, logicaldatamodeling, used SQL queries to filterdatawithin Oracle.
• Reviewed thedatamodel and reporting requirements for Cognos Reports with theData warehouse/ETLand Reporting team.
• Reviewed andresearched data to ensure data integrity, accuracy and validity and analyzed report results identifying opportunities and trends.
• Created Data Mapping Document and Metadata for the Enterprise Data Warehouse (EDW).
• Performed different data reporting duties as directed by the Director and/or Supervisor.
• Participated in development of business process flows for the mortgage/loan process (Loan Origination to Loan Closing for a proprietary loan application and processing system).
• Built robust ETL pipelines to extract varnish usage metrics periodically using Pythons advanced system libraries and performed aggregation at various time steps to create consolidated dashboards on AWS cloud.
• Used Python to acquire data with different entries from different formats and doubled the speed of data collection.
• Performed data validation and calculation verification of loan balance, yearly interest paid, yearly principal paid and total interest for validating the amortization calculation.
• Validated reference data for automatic interest changes affecting amortization values and changes over period.
• Preprocessed data using python to remove anomalies and created multiple interactive dashboards.
• Identified data patterns, provided metrics, diagnosed problems, and provided intelligence for business operations using Tableau.
• Processed ETL using SSIS, analyzed star schema and create KPI using SSAS.
• Assisted in the creation and development of various projects, by planning with Management the resources needed to meet the timelines set for the finalization of the project.
• Calculated and analyzed claims data for provider incentive and supplemental benefit analysis using Microsoft Access and Oracle SQL.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Cleansed and validated data prior to importing into databases.
• Completed ad-hoc projects relating to data investigations, follow-ups on analysis results, or other client requests.
• Support SMEs in data definition and mapping tasks using SQL, created dashboard using Tableau.
• Created, modified, and managed various SSRS Report Model Projects in MSBI studio.
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided using SSRS.
• Scheduled SSRS reports for end users and managed the security of the reports.
• Exported SSRS reports to various formats like PDF, Word and Excel and scheduled to reports to send as an email body.
• Used SQL to complete complex table joins within database to create reports for clients.
• Created and reviewed monthly/quarterly information and summarized for client reports.

Environment: Python, AWS (EMR, Redshift), UNIX, UAT, ALM, SQL, JIRA, SSIS, SSAS, SSRS, Tableau, Machine Learning

Confidential, Hayward, CA

Sr. Data Analyst

Responsibilities:

• Developed optimized ETL processes using AWS cloud platform to capture and aggregate operational metrics of thermostatic engine cooling fan; built interactive visualizations as a deliverable.
• Responsible for data analysis, extracting data elements from various OLTP’s using ETL techniques and utilized Business Intelligence Tools for report generation.
• Performed Data profiling on source Databases and fed inputs to Source to Target mapping documents.
• Responsible for providing accurate and timely reporting and data mining to all levels of the business.
• Assisted multiple teams across the global organization to update and maintain Excel reports, providing reporting capabilities to constantly changing business requirements.
• Worked in Amazon AWS Lambda, Amazon Simple Queue Service (Amazon SQS) environment.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Worked on Data modeling, Advanced SQL with Columnar Databases using AWS.
• Automated Regular AWS tasks like snapshots creation using Python scripts.
• Deployed and monitored scalable infrastructure on Amazon Web Services (AWS) & configuration management using AWS Lambda API.
• Created SQL statements to work within the functional document and ran the results against the facets system to ensure the correctness of the data.
• Worked with MDM systems team with respect to technical aspects and generating reports.
• Organized and prepared data collected from client with Excel as part of Financial Report Standard, calculated risk parameters, adjusted parameters to be predictive and calculated expected credit loss to better assess client performance.
• Analyzed financial statements, compiled audit working papers and drafted reports.
• Created Tables, Stored procedures, and defined functions.
• Identified data patterns, provided metrics, diagnosed problems, and provided intelligence for business operations using Tableau.
• Used Python for manipulating the data read from data sources and convert them as CSV files AWS SQL standards
• Created ETL design mapping sheets, data reconciliation strategy, data archival strategy- ETL framework, stored procedures and built SQL query objects to detect data loss.
• Built and designed business intelligence /data visualization dashboards in Tableau.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package per the advanced feature of SQL Server Integration Services.
• Created reports, tables, and figures in Tableau and Excel.
• Develop and maintain dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Design, develop, implement, and maintain scheduled analytics, reporting and scorecards using Excel and PowerBI.
• Involved in writing extensive SQL queries for back-end testing of oracle database.
• Investigating software bugs and reporting to the developers using Quality Center Defect Module.
• Analyzed system requirements and developed detailed test plan for testing.
• Tracked and reported defects using Quality Center.
• Generated defect reports using Quality Center for the developers.

Environment: Agile, MS Office, Excel, ETL, Tableau, PowerBI, VBA, Snowflake, Python, AWS Lambda, Amazon SQS, T-SQL, Jira

Confidential, New York, NY

Data Analyst

Responsibilities:

• Worked with various data domains primarily with Master and Reference data which includes Hogan Customer Information system, security and Inventory Master, over the counter products, reference data and Traded products.
• Worked with other data domains like Financial Management and Reporting data specifically on Regulatory Data Repository.
• Estimated initial project costs and optimized financial reporting leading to faster project funding approvals for Loan and Mortgage Processes.
• Implemented Master Data Management (MDM) for all entities in the project by maintaining a master hub for improving the data quality by following various data governance techniques and data dictionary standards.
• Worked with various Data sources like Oracle, SQL Server, Teradata and HDFS (Hive).
• Worked closely with application business data owners and technical data managers on applications which are in scope to implement data quality controls.
• Collected Data Dictionaries from data owners or leveraging available dictionaries from centralized metadata repository to identify critical business data elements.
• Involved in documenting the ETL process and wrote SQL Queries for the retrieval of the data.
• Identify and propose resolution of recurring Data Quality problems.
• Developed and published a set of metrics capturing Data Quality trends for a week, month, and quarter to ensure our Data Quality programs are working effectively.
• Developed active Data Quality monitoring and measurement, establishing and publishing KPIs and SLAs.
• Provide Data Quality advisory services participating in cross-functional teams and development or improvement task forces.
• Draft task and project timelines of Data Quality product solutions to collaboratively support the Data Analytics and Warehousing team.
• Partnered with technical team and subject matter experts to research reported data anomalies, identify root causes, and determine solutions.
• Executed enterprise data governance strategies in line with the organization s strategic plan and objectives.
• Oversee the creation of data governance policies and standards.
• Worked with Bank Related Customer Master Data for Data analysis purpose by utilizing Teradata Database and Teradata SQL Assistant for querying.
• Optimized Teradata Tables by building indexes for faster retrieval of Data.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, complex database triggers and data migration scripts.

Environment: Waterfall methodology, Talend, Oracle, Teradata, ETL, MDM, UNIX, SAS, SQL Server, PL/SQL, SSIS

Confidential, Herndon, VA

Data Analyst

Responsibilities:

• Prepared test Data sets and performed data analysis and used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Worked directly with internal customers to understand the business environment and needs.
• Performed data analysis to understand data flows.
• Performed gap analysis and data mapping.
• Performed data quality checks.
• Worked with SMEs to define multifamily mortgage business rules.
• Performed data and business rules validation and verification.
• Performed back-end testing by extensively using SQL commands on UNIX to verify the database security and accuracy.
• Worked on data modeling and produced data mapping and data definition documentation.
• Created (Extract, Transform, Load) ETL design mapping sheets, data reconciliation strategy, data archival strategy- ETL framework, stored procedures and built SQL query objects to detect data loss.
• Worked with the business users to understand & documented the design and functionality requirements.
• Involved in testing and documentation for application developed in SDLC Environment.
• Worked with project manager to document and manage change request.
• Contributed during daily status calls, weekly, monthly status meetings, and review sessions.
• Answered questions and scenarios that came up as the developers and testers work off the business requirements.
• Created process flows, presentations and reports to document recommendations and delivered them to the business stakeholders.
• Responsible from the user perspective to analyze dashboards and analytical reporting requirements using Tableau.
• Performed detailed analysis of complex business processes, data requirements and proposes solutions.
• Composed user manuals, technical references, and other customer facing technical documents for EUCs.
• Wrote and executed complex SQL queries for analysis and testing in TOAD.
• Involved in writing Data Mapping Documents for the system and involved in documenting the ETL process and writing SQL Queries for the retrieval of the data.
• Developed test plans, test cases, procedures, and documents given business requirements and design documents.
• Performed portfolio level testing.
• Involved in investing root causes and business impact of deferred defects.
• Performed User Acceptance Testing (UAT) of the EUC applications.

Environment: Agile, Data Modeling, ETL, TOAD, UNIX, UAT, MS Office Suite