SUMMARY:

• Experienced and detail oriented data analyst, with background in Healthcare, Wholesale Credit Risk and Regulatory space. Hands on with SQL Server, Netezza, Oracle; combined with an intellectually curious mindset, using an investigative approach to analyze risk and data patterns.
• Ability to coordinate multiple projects and meet deadlines in a fast - paced, challenging environment.
• Ability to act as liaison and single point contact for clients and third-party partners.
• Expertise in various methodologies - Agile (Scrum), Kanban and Water Fall Model
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for various projects.
• Proficient in writing scripts and macros using VBScript for automating data mapping and analysis.
• Proven strong analytical and problem-solving skills.
• Strong interpersonal and business skills to achieve co-operation and co-ordination with multiple stakeholders.
• Effective in communicating with the team as well as senior management in technology and business organization to deal with multiple deadline-driven, customer-sensitive projects.
• Clear and concise in producing documentation with technology as well as business teams with experience in articulating analysis results.

TECHNICAL SKILLS:

Databases: Netezza, MS SQL Server, MySQL, SQL Lite Android, ORM Lite Android, Oracle

Security Compliance Regulations: CCAR, OWASP, PCI DSS, HIPPA, PII, PHI.

Web Technologies: HTML5, JavaScript, jQuery, XML, CSS, Java, JSP, Servlets, JDBC, JSON.

Tools: TOAD, VersionOne, JIRA, Rally, Symantec, Splunk, VB Script, Microsoft Office Suite (MS PowerPoint, MS Excel, MS Word, MS Visio), Eclipse, Android Development tools, MS Project, Moodle

PROFESSIONAL CAREER:

Confidential

Senior Data Analyst

Technologies/Standards: Netezza, MS Excel, TOAD, MS SQL Server, Oracle, Power Designer, VersionOne, Rally

Responsibilities:

• Created physical data mappings for Collateral area to a new and dynamically changing Unified Credit Data Model which is in the Third Normalized form (3NF).
• Provided data analysis and mapped complex attributes at the granular level for every flexible data model neutral with respect to the choice of data analysis approach and toolset.
• Lead the complete Collateral project mappings with nCino and LoanIQ where “gap/fit” analysis needed to be incorporated.
• Solved problems and conducted root cause analysis for data quality issues and development of metrics to support QA and Dev team.
• Used multiple database systems such as Netezza, Oracle, SQL Server for different systems to analyse and tie data together from different sources.
• Created and validated mappings for data from various SORs (Data Sources) based on HMDA/CRA 2017, 2018 specifications.
• Imported HMDA/CRA data files into the reporting database, using knowledge of such processes to ensure accurate and efficient data collection.
• Researched and resolved exceptions identified during the verification process, working with the respective lines of business.
• Acted as liaison between departments like QA, Dev and Business teams to develop or enhance data management process.
• Validated the reverse engineered data in Confidential ’s Loan System in Credit Risk space to ensure the data mappings/ transformations have optimal success.
• Performed data mappings, manual/off-tool Data Entries process and Cross Team Coordination.
• Worked closely with developers and testers to ensure requirements and functional designs are translated accurately into working technical designs and that test plans and scripts serve customer needs.
• Worked independently, with limited direction to write queries using SQL to ensure the data quality and transformation correctness in an agile environment.
• Handled very large data sets with more than 100 data fields and columns with millions of records.
• Utilized Excel, TOAD (Netezza, SQL Server) and Power Designer to query, understand, and manipulate complex data with strong understanding of logical data models and data entity relationship diagrams.
• Analysed thousands of rows of data using V-lookups and pivot tables.
• Worked with multiple Stakeholders including off-shore teams to define the analytical requirements for the Credit Risk space.
• Actively participated in the complete life-cycle of solution implementation phase and ensured that deliverables are submitted after thorough inspection.

Confidential

IT Business Analyst

Technologies/Standards: Agile Methodology, MS SQL Server, JIRA, MS Excel, WAR, XSD Schema

Responsibilities:

• Lead the Ernst & Young team in the Edit Check Reporting Project to provide summary reports to business.
• Devised configuration changes per Federal Reserve Board (FRB) Rules in XSD to match data from Data Providers.
• Involved in Enterprise Stress Testing, CCAR - Comprehensive Capital Analysis and Review, FR Y-14A/Q/Ms.
• Partnered with application development team to ensure successful receipt of FR Y-14 QM files.
• Reviewed structured and unstructured SQL queries and conducted QA analysis for an overall 9,000+ SQL queries for all business schedules for FR Y-14/Q/M schedules.
• Maintained a proprietary Confidential Database Management tool for processing FRB edit checks and deriving reports.
• Identified and categorized edit checks that need further investigation and business explanations from LOBs.
• Implemented edit checks in SQL as per FRB instructions and Data Dictionary received every submission cycle.
• Summarized results for business and other stakeholders ensuring successful submission to the Federal Reserve Board.
• Document data flows and quality controls for current files and created Data Sets and Configuration changes in WAR.
• Communicated with quality assurance team for data completeness of Edit Checks.
• Identified gaps in data compliance from various Business Units and reengineered existing business processes and redesigned data flows.
• Coordination with team and leadership for stakeholder identification and communication.
• Continuous attention to user stories and provided additional information to scrum master as needed.
• Practiced agile methodologies throughout the course of the project.

Confidential

Experienced Associate

Technologies/Standards: Symantec DLP, MS Office, MS Visio, HIPPA, PII, PHI

Responsibilities:

• Operated with data owners of different business functions to ensure solutions implemented for Symantec DLP do not negatively impact current business practices.
• Facilitated discussions with various stakeholders to understand security policies and stakeholders in the HR environment.
• Identified the best location to place DLP solution to access the company’s entire network with the network team.
• Created best practice technical architecture models utilizing knowledge of industry and technology trends.
• Achieved seamless database system function through close interactions with DBAs.
• Closely worked with DBAs to ensure the database systems runs smooth without thorough understanding of client environment, analysis and design discussions with team members and department directors.
• Documented a complete governance model for Symantec DLP including Process Run Guide, Incidence Response Plan, DLP Metrics, DLP Standards and Policies and security policies.
• Defined rules and polices in DLP Enforce Server as per the PCI, PII and HIPPA compliance to protect client and secure sensitive data for all Data at Rest sources.
• Deployed Symantec DLP system on the application team’s workstations.
• Prioritized and created an optimal strategy for addressing configuration standards issue such as, Tripwire reports and MSB compliance.
• Created an assessment plan according to the recommended practices of the organization so that activities and milestones of the assessment team can be measured against the goals of that plan.
• Conducted analysis on vulnerability scans and provided recommendations for remediation.
• Identified inconsistencies and gaps within a business process description and collaborated with stakeholders to clarify and simplify complex business processes.
• Identified technology components, data flows, possible interfaces, and affected Lines of Business based on high-level process description or scenarios to understand assessment scope
• Verified that teams adhere to the organizations’ PCI DSS Framework to support the organizational standards.
• Compiled the compliance report indicating the level of PCI DSS compliance by the business process.
• Analyzed third party data sets (spreadsheets, databases, etc.) for importing into business applications.
• Used spreadsheets and database systems to aggregate data and perform analysis.
• Created SQL scripts for data exchange and validation.
• Diagnosed data anomalies or discrepancies within databases and identified actions to remedy those issues.
• Implemented data management standards and procedures for the organization.
• Worked with developers and DBAs to identify and resolve bottlenecks and performance issues.

Confidential, Charlotte, NC

Graduate Teaching Assistant

Technologies/Standards: JSP, Java, CSS, HTML5, MySQL, VB Script, MS Excel

Responsibilities:

• Assisted in development of support materials related to tutoring.
• Designed course projects and lab assignments involving JSP, Java and HTML5.
• Graded homework assignments, projects and lab and programming assignments.
• Held weekly office hours to help students with course work and projects.
• Maintained grading chart for the course and created automated score calculators using VB Script.

Confidential

User Experience Designer

Technologies/Standards: MS PowerPoint, MS Visio, HTML, CSS

Responsibilities:

• Redesigned multiple interfaces and created wireframes for various Confidential Social Edge and Commerce Edge platforms.
• Execute all visual design stages from concept to final hand-off to dev teams
• Conceptualized original ideas to bring simplicity and user friendliness to complex design roadblocks.
• Created wireframes, storyboards, user flows, process flows and site maps to effectively communicate interaction and design ideas and detailed design documentation.
• Created user interface design process and deliverables throughout the development lifecycle including requirements refinement, task flows, storyboards, wireframes, mock-ups, prototypes, and detailed design documentation.