PROFILE

• A technology professional with proven track record of success in Business/Data Analysis, Data Quality Assurance, Data Lineage, and Defect Management. Possess excellent analytical, problem-solving, and supervisory skills.
• Areas of Expertise
• Root Cause Analysis Defect Management Data Quality and Metrics ETL BI Ad-hoc Reports
• Data Lineage and Metadata management Testing Business/Data Analysis
• Requirements Elicitation, USE Cases, and Functional Specification

Technical Skills

• PENTAHO TABLEAU MS SQL SERVER T/SQL SSIS Oracle PL/SQL UML / MS Visio
• VB Excel Scripts/Macros MS Power Point, Access Lotus Notes/Script Hyperion/Brio Query

PROFESSIONAL EXPERIENCE

Confidential

Analyst - Program

• Building Business Intelligence BI data-sets and reports for Business Operations Managers BOM , who are dealing with customer technical support, towards their analytical needs so that they can take timely and informed decisions that lead to process improvement and generating more revenue.
• Extracting data from various sources such as Oracle, MS SQL Server and transform them based on the Users' requirements and finally creating a BI dataset and/or reports, using the ETL tool PENTAHO.
• Developing data model and SQL scripts for the ETL jobs and for testing.
• Testing the output using TABLEAU analyzing tool and publishing it for Users' consumption
• Documenting all the above mentioned artifacts

Confidential

IT Business Analyst

Involved in 'BASEL Data Quality' project which was a response to the Federal Regulators and Internal Audit that required Bank of America to ensure that the data was accurate for 'BASEL Reporting'.

Responsibilities:

• Obtained all the source information from the data custodians for all the data elements furnished in BASEL reporting.
• Reviewed, analyzed and validated the collected source metadata by querying SQL in their native technical systems/applications. The technical systems include MSSQL Server, Teradata and Oracle.
• Established source-to-target mapping based on the above analysis and maintain the data lineage in MSSQL database.
• Documented the end-to-end data lineage for all the BASEL Key Business Elements KBEs and pushed it periodically to IBM IIS metadata repository to support data governance and enterprise wide Metadata management.
• Developed SSIS package to extract data from the lineage database and transformed it to the required format to be loaded onto IBM IIS.
• Performed Root Cause Analysis RCA for the defects raised in Quality Center for BASEL data elements to resolve the issues.
• Developed SQL scripts and execute it against various systems listed in the lineage for the defective data element and documented to check/validate whether it is getting its value from the source data elements according to the derivation logic.
• When the data flow is not according to the derivation, then the same logic was referred to SMEs and the source assignment and/or derivation logic was corrected accordingly.
• Developed and maintained fine-tune DQ RCA templates for efficiency so that future RCs are quickly found and the defects would be remediated effectively,
• Corrected existing DQ rules controls / filters or develop new rules based on the RCA outcome.
• Reviewed, analyzed and evaluated the Change Requests
• Interacted with the business users, developers, and Project Managers and Documented the change

Confidential

Systems Analyst

Responsibilities:

• Extracted data from different disparate sources SAP, Oracle, SQL Server, delimited flat files, Excel , Transform, and Load onto a single data source MS SQL SERVER .
• Automated ETL processes using SSIS SQL Server Integration Services .
• Performed Data Analysis/Profiling DP of source data and target data as well.
• Prepared and present data metrics/reports to all parties concerned based on the above to continually improve data quality data accuracy and timeliness .

Confidential

IT Business Analyst

Responsibilities:

• Gathered, Analyzed, and Prototyped Business Requirements to agree on what the customers want/need exactly.
• Interviewed various people/stakeholders at various levels to understand the business requirements, process requirements and process flow.
• Developed and delivered powerful presentations by positioning contents and objectives appropriately.
• Estimated and prioritizing the requirements on the basis of 'value' to the business/customer.
• Prepared Business Requirements Documents BRD and Translated BRD into Functional Specification Documents FSD .
• Created executive summary as part of the BRD for a quicker review and sign-off from the customers.
• Created Business and Systems Use Cases for business users and development team.
• Defined Acceptance and Evaluation Criteria
• Performed high level functional testing on completion of the development to check if it meets the 'stated' functional needs and certified the release for QA SIT/UAT testing.
• Managed the Requirements Requirements Traceability Matrix and Change Control
• Created and maintained CRs Change Requests and CRs log and updated Requirements traceability matrices.
• Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
• Made myself available almost all the time to the developers and testers to address the issues pertaining to requirements.

Confidential

Systems Analyst/ Consultant

Provided Business System analysis and Design, Data Analysis, BI reporting, SQL and Stored Procedures. Assisted project teams as necessary so that the projects completed on time and within budget.