SUMMARY:

• 9+ years of experience on user requirement gathering development of Business requirements documents (BRDs) and functional specifications.
• 7 years of experience working with different data manipulation, data visualization tools and 5+ years of experience in detecting and mitigating compliance, regulatory and reputational risk across different financial firms.
• Solid experience inDataModeling using designed tool Erwin, Oracle SQL Developer, SQL Server Management studio, MySQL, SQL Plus and Toad.Hands on experience with PL/SQL programming and writing Stored procedures.
• Expertise in SQL Server Integration Services (SSIS), Informatica and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). Worked extensively on Informatica, Oracle BI, Tableau, QlikView, SAS BI and Power BI. Experience performing statistical data analysis on very large datasets using SAS, R and Python.
• Progressive expertise in analyzing the requirements, application design, development, testing and production support for various environments.
• Proven experience in relational and dimensional data modeling, data management, data warehousing, data transformation, data profiling, metadata and master data ( data) management and business intelligence tools.
• Scrum Master with strong technical background and strong understanding of project management methodologies including both Agile Scrum and Waterfall.
• Hands on experience with HTML5 and XML and proficiency in tools like Keil, MathCAD, Mathematica, Unity Pro7, Virtuoso, PeopleSoft, Blackboard vista and Learn.
• Product managerial experience, assessing cross - functional business requirements for SDLC-driven IT projects.
• Industrial experience coupled with communication skills which would help in effective productivity.

TECHNICAL SKILLS:

Languages: PL/SQL, T-SQL, C, C++, Verilog, MATLAB, VHDL, Python, R, VBA, SAS, Macros.

Technologies/Tools: Actimize, Detica, WatchList Monitoring, SWIFT, Keil, MATHEMATICA, Mathcad, Simulink, Cadence, Virtuoso, AutoCAD, Actimize, Autodesk, SSMS, TOAD, SSIS, SSAS, SSRS, SAS EG, MSOffice, SPSS, Blackboard Vista, SharePoint Designer, PeopleSoft, Power BI, Hive, Maya, Informatica, QlikView, QlikSense, Oracle 8i/9i/10g, MS-SQL 2000, MS Access, OBIEE 10.x, 11.x, JIRA, Tableau, Confluence

Web Servers: Microsoft IIS 6.0, oc4j, WebLogic.

Web Development: HTML, CSS, XML, Adobe Dreamweaver.

Operating Systems: Windows, Macintosh.

WORK EXPERIENCE:

Senior Business Data Analyst

Confidential, New York

Responsibilities:

• Deliver key metrics, reports, dashboards and ad-hoc analyses with interpretation, contributing to the development of hypotheses and actions. Utilizing Qliksense for this development.
• Conduct quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand how our users interact with the product.
• Define, implement and standardize metrics, reports and dashboards leveraging Tableau.
• Design and develop data preparation components and processes that extract and transform data across disparate database tables by creating aggregates tables for reporting and validation, ensuring integrity of analysis data by developing the requirement specifications and assisting the development and testing of data tables.
• Support A/B testing by designing robust experiments, analyzing results, and communicating insights to business stakeholders
• Pursue data quality, troubleshoot data validation, and see issues to resolution. Partner with fellow analysts and stakeholders to provide subject matter knowledge, self-service solutions and processes to ensure they are repeatable, sustainable and scalable.

Senior Consultant

Confidential, New York

Responsibilities:

• Designed a segmentation and tuning approach specific to Detica transaction monitoring for a large financial services firm, to reduce the number of false positive alerts without compromising the quality of alerts. Performed cluster analysis using K-means/K-medians algorithms to segment a significantly large amount of data by value and volume and also predicted the nature of future data.
• Supported implementation of sanction screening models for a large financial firm by analyzing the screening procedures and performed model remediation to follow regulatory standards. Performed SWIFT message analysis by analyzing the data from different trade systems and documented the end to end data transformations as a part of Watch List Monitoring (WLM).
• Led the data analysis of a major bank's AML Transaction Monitoring system to identify relationships between many data sources in order to document target state data mapping and transformation logic to be used to integrate the data into a new system. Performed statistical analysis to create sampling metrics (confidence level/error of margin) for the functional test cases and designed stratification approaches to sample very large volume of the diversified data.
• Assisted with the design of new data governance model and rationalized the organization to best facilitate policy/procedure compliance and data quality improvement. Developed and delivered KPIs, metrics and quality reports to quantify compliance with policy, data quality, and overall effectiveness of the data governance program.
• Led the design and development of data integration, data transformation, metadata management, ETL, data modeling toolsets that were used to satisfy functional requirements across various projects. Performed quality reviews on proposed bank-monitoring activities by analyzing data generation methodologies applicable to company standards, while also developing methods and procedures to conduct bank-monitoring activities
• Worked as a lead business analyst to develop formal test scripts and business requirement documentation for process improvements within a large bank's existing compliance functions. Performed current state analysis and developed a target operating model that redesigned existing compliance processes, improving on operational efficiencies and reporting processes. Worked with Actimize system designing and solution implementation.

Data Analytics and Visualization Analyst

Confidential, Charlotte, NC

Responsibilities:

• Developed automated Factsheets, Manager’s Reports/ Investor’s Reports, Pitchbooks, Quarter-to-Date Investment Reports, etc. using Seismic tool.
• Performed data related activities such as data extraction, profiling, importing, cleansing, transforming, validating and modeling data for company wide use and created automated solutions in line with the business requirements. Designed dashboards and reports using Power BI and Tableau.
• Designed and developed data structures for collection and storage of data. Wrote complex queries to increase the performance of the dashboards by using different tuning techniques.
• Developed high performance data integration solutions such as developing SSIS (SQL Server Integration Server) packages to integrate data from heterogeneous data sources.
• Gathered business requirements to write various T-SQL Queries on SQL Server to get the desired form of data from the database to develop automated documents.
• Key resource for generation and manipulation of data needed by senior leadership for day-to-day operations and analysis.

Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• Involved in the design, development and modification of system applications.
• Worked as a part of Global Compliance team analyzing systems, processes, reports and data archives from a worldwide network.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQLjoins for applications and implemented different types of constraints on tables.
• Extracted and loaded data into SQL Server Database using SSIS.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Used data profiling automation to uncover the characteristics of the data and the relationships between data sources before driving the data along with understanding the data and mapping document.
• Extensively involved in designing the SSIS packages to export data from flat file sources to SQL Server databases.
• Designed and implemented SharePoint web parts with display templates & workflows and solutions in line with SDLC process.
• Created and deployed electronic InfoPath forms which are maintained from time to time. Used R to auto-populate the InfoPath forms which is a part of the Test Migration project.
• Conducted a time-sensitive, meticulous investigation and analysis of each instance of potentialAnti-MoneyLaunderingactivity (Actimize) and/or suspicious financial activity across multiple jurisdictions and countries, utilizing multiple research and analytical tools.
• Worked on data integration, data transformation, metadata management, ETL, data modeling tool sets.
• Responsible for helping to capture business requirements, identifying appropriate data sources, data quality issues, business transformation rules, mapping source to target.
• Provided analytical support in EIT activities related to multiple Compliance Control Functions.
• Gathered and organized data in order to track, report and monitor the effectiveness of bank controls while identifying and escalating regulatory issues to management.
• Experienced in branding SharePoint site collections and team sites by modifying the master pages, page layouts, Nintex Forms and CSS styling.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Worked on enterprise-wide data Governance policies, standards and data Framework to govern full data life cycle including data creation, usage, retention and deletion.
• Performed quality reviews on proposed bank-monitoring activities by analyzing data generation methodologies applicable to company standards, while also developing methods and procedures to conduct bank-monitoring activities.

Data Analyst

Confidential

Responsibilities:

• Involved in extensiveDatavalidation using SQL queries and back-end testing.
• Worked with Design and Development team to implement requirements.
• Served as Scrum Master on a scaled agile program with 180 team members and Agile coach.
• Performed dataanalysis, primarily identifieddatasets, sourcedata, source Metadata,datadefinitions and data formats.
• Defined and implemented EnterpriseDataManagement services from a technology perspective while understanding the business drivers.
• Led Lean Six Sigmaproject to reduce the number of patient cancellations or absentees by developing a process improvement plan and increasing savings by $300K.
• Provided 24x7 support of eight Oracle Applications EBS environments running release R12.1.3. Acted as the Lead team member responsible for all database activities associated with the support of Oracle Applications HR, Financials Suite, Purchasing, Self Service, and Inventory. Successfully completed an upgrade of EBS from 11i to 12.1.3 ahead of schedule and under budget.
• Created dashboards using key performance indicator (KPIs) such as employee headcount, employee turnover, employee on-boarded, etc.
• Defined roles for Master Data-Governance and rationalize organization to best facilitate policy/procedure compliance and data quality improvement.
• Developed and delivered KPIs, metrics and quality reports to quantify compliance with policy, data quality, and overall effectiveness of the Master Data Governance program.
• Provided suggested improvements to the preliminary Data Governance processes, templates and best practices based on proven best practice.
• Designed both normalized and denormalized dimensional data structures. Created reports by changing the procedure of the query. Helped in running the workflow in ETL.
• Worked on Data Cleansing, Data Transformations, Data Mining, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Completed primary and secondary validation by providing unit test cases.

Instructional Technology Assistant

Confidential, Houston, TX

Responsibilities:

• Assisted faculty in Blackboard and SharePoint. Supported elementary instructional personnel with the presentation of technology-based instructions and exercises in the classroom or computer laboratory, installed and maintained hardware and software campus-wide.
• Maintained and designed Confidential SharePoint lists and views. Conducted quizzes for Students through SharePoint Designer- Turning Point tool.
• Assisted in standardization, documentation, and implementation of overall physical datamanagement and data release processes.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language. Performed dataanalysis on climatic datausing cross validation techniques.
• Utilized SAS, SQL, and occasionally R to conduct statistical analysis on a variety of institutional and academic related data.
• Generated various internal reports and data requests regarding graduate at the Confidential .
• Worked with Stored Procedures to handle various checks, to generate the ballot and the voting demographics were written in SQL Server 2008.
• Worked with Adobe Dreamweaver and HTML5 to create and edit web pages in the Law Center Website. Posted the daily news and events. Updated the syllabus and faculty lists. Designed the website.

Data Analyst/Business Analyst

Confidential

Responsibilities:

• Involved in Gathering, Analyzing Business Requirements for Reports.
• Created/Modified Metadata repository, defined/developed Physical Data Layer, Business Model (Aggregates, Dimensions and time Series functions) and Presentation Layer using BI Tool.
• Responsible for solving all the technical problems related to Teradata and intensively worked on the Teradata SQL part, as well as the Utility part of Teradata.
• Coordinated the collection of metrics across multiple sources including SQL databases, manual daily reports, and email driven activities. Wrote SQL and PL/SQL queries to analyze data.
• Conducted detailed analyses of complex systems using Excel, Access, and SQL Server Management Studio.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Conducted independent analysis by quantitatively analyzing data/information. Developed and presented oral and written analyses to support operational goals to management.
• Provided analytical support and documentation for databases after collaborating with IT to prepare current systems for migration to new business intelligence system.
• Performed ad-hoc dataanalysis and creation of reports using SQL and Excel.