SUMMARY

• Data Analyst with 10+ years' experience in various domains of the financial Industry including online banking, mortgage and loan, credit Card, investment banking and retail banking.
• Experience working in all phases of Software Development Life Cycle using mythologies like Waterfall, Agile Scrum and Rapid Unified Process(RUP).
• Experience on business intelligence (and BI technologies) tools such as OLAP, Data Warehouse, reporting and Querying Tools, Data Mining and Spreadsheets.
• Strong knowledge and experience in database programming SQL (PL/SQL, T - SQL, I-SQL, etc.) and fine tuning.
• Proficient in working with Informatica as ETL developer, Informatica Power Center, Informatica Cloud.
• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS, etc.).
• Strong knowledge and experience in using and implementing integration/ETL framework.
• Experience in manage a large data set, develop reports, and troubleshoot data issues from single or multiple systems.
• Proficiency in use of query and reporting analysis tools; excel (macros, pivot tables, lookups).
• Experience in data visualization using Python, R Programming, Tableau and SQL
• Strong experience in Database like Mongo DB, MySQL, and SQL server
• Experience in various phases of Software Development life cycle
• Experience with Data Analytics, Data Wrangling, Data Exploration, Data Visualization, and Data Modelling.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently.
• Used Git and GitHub for version Controlling.
• Proficient in developing different types of Tableau Reports, working at the data model to fit tableau needs and discovering data by tableau to best answer the business questions
• Working knowledge of Amazon Web Services (AWS) and Cloud Data Management.
• Knowledge in creating and developing PowerBI, Tableau Dashboards into the rich look
• Experience in developing data applications in Windows and macOS environments.

TECHNICAL SKILLS

Business Modeling: Microsoft Visio

Requirements Management: Requisite Pro, Microsoft Office (Word & Excel)

Front End Tools: Microsoft Project, Microsoft Office

Databases: Oracle, MS Access, SQL Server, Teradata

ETL Tools: Informatica PowerCenter, Microsoft SQL Server Integrated Services

Languages: PL/SQL, SQL, HTML

Reporting Tools: BO, OBIEE

OS: Windows

Others: MS Project, MS Office, TOAD

Data modeling: Microsoft SQL Server Analysis Services

PROFESSIONAL EXPERIENCE

Confidential, Knoxville, TN

Sr. Data Analyst

Responsibilities:

• Worked closely with IT Data Migration team to document data migration requirements, on project planning and load scheduling, testing, and troubleshooting, and issue resolution.
• Responsible for Requirement Analysis, Functional Specifications, Data Cleansing, Data Modeling, Data Architecture, Gap Analysis, Data Transformations, Data Relationships and Reporting Analysis.
• Load data using ETL process dealing with different data sources MS Excel, MS Access and SQL Server, CSV Flat files, etc. into target database by performing different kinds of transformations using SQL Server Agent.
• Executed test, data extraction, and analysis utilizing the department's various computer software packages within established deadlines.
• Experience in creating Unix scripts to file transfer and file manipulation.
• Produced artifacts such as BRDs, FRDs and Use Case Documents using MS Excel and Visio for documenting system requirements.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Creating and maintaining periodic financial reports in SSRS (Developing SSRS Deals for conversion)
• Assessing Data Lake through cloud platform for data cleaning and integration
• Maintain Structured Query Language (SQL) databases and extract, transform and loading processes established to aggregate various data sources across the Bank used in analysis and modeling.
• Provide all the business rules, transformation logic, derived column expressions, SQL, etc. to build mapping documents.
• Participate in client meetings and client stakeholders as well as internal meetings.
• Maintain data of dashboards & analytics of workforce/business outcomes.
• Utilize basic Data Modeling concepts and Entity Relationship Diagrams to build efficient SQL.

Confidential, Jersey City, NJ

IT Data Analyst

Responsibilities:

• Liaise with stakeholders to understand the structure, policies, and operations of the organization, and translate that knowledge into recommended solutions that enable the organization to achieve its goals.
• Filtered and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
• Managed, Updated, and manipulated report orientation and structure with the use of Advanced Excel function including Pivot Tableau and VLOOKUP.
• Provided organizational performance reporting, monitoring of key metrics and coordinate development, tracking and execution of remediation action plans
• Created and executed SQL queries to perform Data Integrity testing on a Teradata Database to Validate and test data using TOAD.
• Used Excel sheets, flat files, CSV file to generate Tableau ad hoc reports.
• Acquired data from primary or secondary data sources and maintain databases/data systems.
• Work with application system business users and SMEs and translates the findings into technical mapping documents.
• Understand extract, load, and translate (ETL) processes and database population.

Confidential, New York

SQL Data Analyst

Responsibilities:

• Respond to ad-hoc requests for information from team members and other requestors by identifying and managing relevant data needed to satisfy the request.
• Tested the data using the Logs generated after loading the data into Data Warehouse .
• Prepared Traceability Matrix with requirement and test Cases.
• Ensured different internal external system exchanged data according to the specifications to transform data from enterprise data warehouse to SQL Server load data to fact tables.
• Performed report optimization and analysis using Pivot tables and V-Lookup function.
• Generate tableau dashboards for sales with forecast and lines.
• Building, publishing, customized interactive reports and dashboards, report scheduling using Tableau server.
• Analyze data to draw business-relevant conclusions and in data visualization techniques and tools

Confidential, Watsonville, CA

Data Analyst

Responsibilities:

• Understand source systems and apply that knowledge to prepare the detailed mapping of source to target documents for use by Developers.
• Prepared, and documented detailed specifications of the programs utilized to pull data.
• Ability to obtain, extract and clean data from various sources which could include, Azure App Insights, Databricks and SQL sources.
• Provide status of mapping work to Project Managers and other members of Management.
• Participated in Mapping Review Sessions.
• Involved in data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.