SUMMARY

• Experience as Data Analyst with 7+ years of industry experience in Data Analysis, data modelling, process flow and quality assurance skills.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Solid understanding of Data Modeling, Data Analysis, data profiling, creating data mapping documents and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Executive leader responsible for the leadership, strategy and technical execution of Enterprise Data Management function.
• Led global cross - functional process reengineering teams translating business requirements into a common functional process model and software platform for supply chain, sales & finance,
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Strong experience in Object Oriented Software Development using Java/J2EE technologies.
• Strong knowledge of all phases in Software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Evaluate the capabilities of Trillium and Dataflux to replace the existing system for Parsing, Address Enrichment and Matching
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Design and review of various documents including the Software Requirement specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Experience in Data Transformation, Data Loading, Modeling and Performance Tuning.
• Strong in database design, domain modelling and ER diagrams design
• Well conversant with scripting languages like Java Script, VB Script, HTML, DHTML, and XML.
• Highly motivated and a self starter with excellent communication and interpersonal skills
• Strong analytical and problem solving skills, capable of addressing relevant facts and recommending solutions.
• Used Team Site Content Management Tool to deploy and manage the content managed files.

PROFESSIONAL EXPERIENCE

Sr. Data Analyst

Confidential, Flint, MI

Responsibilities:

• Analysed the requirements and segregated them into high level and low level Use Cases, activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Responsible for full lifecycle development of Business Intelligence solutions including; requirements gathering, and gap analysis, source system identification, data profiling, ETL development and solution testing.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies.
• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Identify, cultivate, and close opportunities for enterprise level data management solutions across all USAF, JWAC, and OSD programs
• The primary purpose of the Fraud Prevention Specialist III is to review real-time and near real-time data in order to proactively identify and block suspicious activity with online transactions work closely with the Mgr. Fraud Mitigation to develop and maintain scoring and rule engine effectiveness.
• Worked in close partnership with the Supply Chain Direct and their staff; FBP for Operations, FBP for Sales & with Corporate Finance.
• Performed Account Management activities including creation and distribution of RMIS Legal Contracts, RMIS Id issuance, RMIS password management along with tracking of target dates.
• Extensive experience in Enterprise Data Management (MDM, BI/ETL) as an developer, business Intelligence.
• Responsible for communicating with internal and external entities, members of the sales team and other Citigroup AML monitoring units.
• Proficient in Object Oriented Principles and developing the user interfaces using CSS, HTML, and JavaScript.
• Provide support to capital markets and prepare presentations for all marketing pitches and provide required materials.
• Good understanding of BRD, FRD, Use cases, work flow diagram, project schedules.
• Maintaining DTDs and developing XML schemas.
• Coordinates the preparation, capture, conversion, and quality control of XML content with XML suppliers.
• Created Business Requirement (BRD) and Functional Requirement (FRD) documentation.
• Develop TSQL queries and stored procedures and write ad hoc reports
• Included all diagrams and Use cases along with functional database online and offline
• Strong research and Investigation skills related to Fraud and AML risk, which includes FinCen, OFAC, CIP documentation, as well as Smurfing, Straw man laundering techniques
• Evaluates transactions and customer relationships for money laundering activities, identifies red flag issues and escalates within the AML framework for further investigation.
• Provided guidance as needed to investigators on AML subject knowledge, RFI's RFI Responses, next steps, etc.
• Familiar with SOX Compliances and Basel II standards. Worked on data analysis of Mantas - Anti-Money Laundering (AML) Compliance data and supported user requirements.
• Object Oriented Analysis and Design using UML include development of class diagrams, Sequence diagrams, and State diagrams and implemented these diagrams in Microsoft Visio.
• Domain expertise included evaluation of Internal risk Ratings, ALGO Limits and Credit Risk Exposures, Risk Exposure Modeling, REPO/ ABCP/ MABS/ MRB/ Fed Funds/ MMF/ Custodian monitoring
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Analyzed massive and highly complex data sets across multiple platforms to perform ad-hoc analysis and reporting using SAS, Cognos and Python.
• Ability to look through Logs, XML and Design documents to assist in trouble shooting as needed
• Overseeing fraud prevention agents for operation of restricting card and internet orders, releasing card and internet orders, analyzing current fraud trends, protecting credit cards against fraudulent activities, providing customer service
• Prepared end to end test cases based on Business requirements documents, functional specification documents and use cases. Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Answers inbound/make outbound fraud prevention and fraud investigation calls.
• Managed Supply Chain feasibility studies on anticipated costs of prospective business and recommended storage and freight pricing for new business.

Data Analyst

Confidential, Pittuburgh, PA

Responsibilities:

• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Updating the internal anti-money laundering software by monitoring anti-money laundering (AML) activity
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Extensive experience in Enterprise Data Management (MDM, BI/ETL) as an developer, business Intelligence.
• Created customized reports in Charles River such as commission analysis report, boxed position report, take-over report, and compliance report etc. using Crystal Reports, Excel VBA and SQL.
• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Developed and implemented clinical cost reduction and resource utilization strategies with focus on managing supply expense and improving services.
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Work with business partners and vendors to ensure the request and response XML is stored in SQL DB and the objects, variables attribute are being documented accurately for reporting
• Maintain xsl to align with changes made to XML through designer application based on decision matrices (scores, calcs, rules, etc) .
• Create and maintain store procedures to be called by SQL agent job daily for parsing XML
• Monitoring MS SQL server performance using SQL profiler to find performance, deadlocks and blockings and capturing long running SQL queries for fine tuning the SQL statements that better result in efficient SQL statements processing.
• Monitored health conditions of databases and performed a day to day task like taking backups and restoring them.
• Providing offsite consultation for clients with our Enterprise Data Management software.
• Analyzed massive and highly complex data sets across multiple platforms to perform ad-hoc analysis and reporting using SAS, Cognos and Python.
• Responsible for Security & Fraud Prevention including Bank Security Act (BSA) Officer, physical security, loss prevention and investigations. Interact with all levels of bank personnel, law enforcement (local, state and federal) and legal counsel.
• Source and structure AML data, metrics and qualitative factors to support analysis of risk factors.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, Execute package task, Transfer database task, for loop & foreach loop containers.
• Evaluate the capabilities of Trillium and Dataflux to replace the existing system for Parsing, Address Enrichment and Matching
• Managed risk-based audits, due diligence and governance of new initiatives and compliance (AML (Anti-Money Laundering), SOX, Basel, GLBA, PCI) programs to mitigate risks
• Implemented Actimize Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries. Transformed project data requirements into project data models.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Worked alongside Users/SMEs (Subject Matter Experts) to recommend and gather low-level business processes and convert them into technical requirements for the development team, at various stages of the SDLC (System Development Life Cycle).
• 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.
• Worked in the Technologies like DataFlux, Trillium, Informatica, Datastage, Oracle Financial Analyzer, Oracle Sales Analyzer and Oracle Express
• Administered training and provided development and mentoring for the Supply Chain team.
• Provided support to Finance Group with data and analysis to comply with corporate reporting.

Data Analyst

Confidential, Atlanta, GA

Responsibilities:

• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Performed validation and testing on the metadata in the in house metadata tool CDM.
• Written Test Plan and Test Strategy for both BID Data Project and Billing.
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters
• Responsible for SQL Server 2000 database development, database modeling, database program, database administrator
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard
• Maintain and implement the database using SQL Server 2000 back-end tools and DTS.
• Design, develop and administer the E-Work platform website
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Created Graphical representation of reports such as Bar charts, Pie charts etc as per the End user requirements using Business Objects and Crystal reports.
• Develops test scripts, use cases, and conducts application testing.
• Analyze AML risk assessment results to identify and summarize risk themes.
• Partnered globally with the Alliances, Product Management, Product Marketing, and Sales Teams to align target markets and create appropriate programs for all of Trillium Software's products .
• Involved in Gap analysis of processes As-Is and To-Be Processes within the organization for implementation of RUP methodologies.
• Worked on ETL packages dealing with different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team
• Prepared test cases for data validations between Data Mart to data cubes.

Data Analyst

Confidential - Dearborn.MI

Responsibilities:

• Responsible for the creation, financial tracking and reconciliation of Vehicle Operations (VO) Body Construction Engineering (BCE) vehicle program checkbooks within Excel via data retrieval from the Program Financial Reporting system (PFR)
• Input of all monetary installments when Long Lead Funds (LLF) and Program Approval Milestone (PA) funds are loaded into the Project Costing Asset Management system (PCAM)
• Weekly reconciliation of Change Request (CR) Funds when approved.
• Daily creation of the Mechanized Appropriation Request System (MEARS) Drafts to fund (PO) Purchase Orders and Ford To Furnish (FTF) requisitions in the PFR system
• Vehicle Program requisition activity tracking and reporting to management and body leaders via data retrieval from the Corporate Procurement And Receiving System (CPARS)
• Creation of Tooling Purchase Orders as needed during duration of program unless partial POs are required
• Reconciliation of FTF activity on a weekly basis to capture PO's in system
• Ongoing Two-Way management for various sub-systems within each vehicle program checkbook
• Creation of CPARS Advanced Purchase Notification (APN), CPARS Purchase Notification (PN) and Cost Optimization requests for Value Assessment Analysis (VAA) as requested by the engineers
• Hard copy filing of MEARS drafts, Negotiated Settled Base Quotes, APN's, PN's, CR's and Two-Way Notifications (Advanced and No Cost) once the approval process is complete.
• Responsible for creating the Microsoft Excel Master Requirement List (MRL) Download derived from the Emergent Systems Enterprise Engineering Knowledge System (e2ks) for the DPA 3 Block Engineering Department daily.
• Conduct data mapping sessions, and write the required business requirements documentation including use cases.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Filing and data archiving.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Ensured accurate data entry within every carline listed in the dept. e2ks folders
• Responsible for ensuring the most up to date versions of MRL Download Interface Checkers; both interior and exterior lists housed in the dept. Share Point folders
• Responsible for accurate completion of all Name Edit Requests as well as the requests for new part name entries
• Provided ongoing support to all dept. Engineers, within the e2ks system and prepared various reports as requested.