SUMMARY

• 7+ years of Experience in Data Analysis, Data Modeler, Data Warehouse professional with applied Information Technology.
• Experienced in data mapping, data modeling and collecting various data metrics for marketing, performance return of investments and customer - level engagement projects.
• Extensive experience in Process/Data Modeling, Quality Assurance/Testing of both client and server side and data warehousing applications
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical
• Design of Database and ER Diagrams using multiple data modeling tools like ERWIN,RDA(Rational Data Architect) ER Studio.
• Specializing in the development of Data Warehouse, Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms.
• Experience in Data Warehouse, Data Mart Design and Data Warehouse Bus Architecture.
• Prepare Reports for potential suspicious activity.
• Skilled in eliciting stakeholder demands and translating them to data, functional, quality and usability requirements.
• Experienced in source data quality analysis, defining of quality criteria and data governance.
• Experienced in preparing Score Cards and metric reports using MS Access and MS Excel.
• Worked with data validation, Adhoc report, report validation using excel, VBA Macro, crystal Reports and Business Objects.
• Good understanding of Data warehouse and experienced writing complex SQL queries to extract and analyze the data.
• Worked with DB2, Teradata, MS SQL Server, Oracle database environment.
• Efficient in VBA for MS Excel for planning/status reporting and creating test data.
• Highly dependable Data Analyst successful at profiling and interpreting data. Supportive and enthusiastic team player dedicated to streamlining processes and efficiently reconciling data issues.

TECHNICAL SKILLS

Reporting & Analysis: Microsoft office Suite, Teradata, OBIEE, SSRS, Crystal Reports, Cognos.

Languages: VBScript, SQL

Quality Management: TFS, Rally, Jira, HP QC, Rational ClearQuest, Rational ClearCase

Packages: MS Office (Word, Access, Excel, PowerPoint, Project, Visio), Macros using VBA

Databases & Tools: Oracle, MS SQL Server, DB2, Teradata

Data Modeling: Visio, RDA (Rational Data Architect), ERWIN, ER Studio and Info sphere data architect.

ETL: SSIS, Informatica, DataStage

Operating Systems: Microsoft Windows, UNIX, LINUX

Web Technologies: XML/HTML/DHTML/CSS MS SQL, Servlets

PROFESSIONAL EXPERIENCE

Confidential, Dorchester, MA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Collected key data metrics to determine mandatory and discretionary investments based on the prioritizations and projected the expected returns using MS Access.
• Analyzed and rectified data in source systems and Financial Data Warehouse databases.
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
• Validated and informed the technical design through data analysis across multiple layers of data warehouses, source systems.
• Perform root cause analysis on smaller self-contained data analysis tasks that are related to assigned data processes.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Worked to ensure high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
• Develop and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.
• Involved in translating the business requirements into data requirements across different systems.
• Involved in understanding the customer needs with regards to data, documenting requirements, developing complex SQL statements to extract the data and packaging/encrypting data for delivery to customers.
• Checked the naming standards, data integrity and referential integrity.
• Coordinated with Data modelers in giving requirements for ER diagrams including data type length and integrity constraints.
• Created and validated the test data environment for Staging area, loading the Staging area with data from multiple sources.
• Created data masking rules to mask sensitive data before extracting of test data from various sources and loading of data into tables.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica and Ab Initio using Oracle, DB2, Teradata and UNIX.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Tested the ETL process for both before and after data cleansing process.
• Experience in creating UNIX scripts for file manipulation and profiling.
• Updated metadata repository with the changes in the CCDW.
• Documented the technical and business data rules

Environment: SQL Server 2005, Quality Center 10.0, PERL, Cognos Series 10.0, Oracle 10g, Unix IBM AIX 6.1, Teradata 12.0, Teradata SQL Assistant 12.0, T- SQL, XML Files, XSLT, XML Spy 2010, SQL, PL/SQL., Erwin, UML

Confidential, San Antonio, TX

Sr. Data Analyst/Data Modeler

Responsibilities:

• Worked with SME and conducted JAD sessions documented the requirements using UML and use case diagrams
• Analyze the client data and business terms from a data quality and integrity perspective.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Created and Designed logical database schema for data warehouse (Oracle) environment to prepare for ETL.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Validate for the naming standards, data integrity and referential integrity.
• Created ETL test data for all transformation rules and covered all the scenarios required for implementing business logic.
• Identified, suggested and managed improvements in process to meet data quality criteria.
• Used Erwin Data Modeler to create, enhance, and maintain logical and physical models.
• Responsible for data mapping and data mediation between the source data table and target tables using MS Access and MS Excel.
• Created SQL queries to pull out data and metrics from the database.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results.
• Created Adhoc reports and pivot tables in Excel using VBA and macros.
• Created clear requirements for data on reports and graphs, based on business user requirements and business rules.
• Written several complex SQL queries for validating Reports.
• Used Quality Center to resolve data and report system defects by coordinating with team members.
• Worked with business team and helped them handshake with IT reporting team.
• Prepared test data in XML files and checked whether data is parsed and loaded to staging tables.
• Tested several stored procedures.
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.

Environment: Microsoft Visio 2014, VBA, Macros, Excel, Rational ClearQuest, Rational ClearCase, Oracle 12c, OBIEE 12c, Informatica 9.6.1, Oracle RDBMs, SoapUI 5.2, SQL, SQL Developer, PL/SQL, XML, Windows XP, Putty, UNIX, Control-M

Confidential, Rancho Cucamonga, CA

Data Analyst / Data Modeler

Responsibilities:

• Involved in Business and data analysis during requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Reviewed and recommended database modifications.
• Created and Reviewed Informatica Mapping documents to with business and data governance rules.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Defined data requirements and elements used in XML transactions.
• Generated and reviewed reports to analyze data using different excel formats
• Validating the data passed to downstream systems and checked the data integrity and referential integrity.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• Validating and profiling Flat file Data into Teradata tables using Unix Shell scripts.
• As Data analyst responsible for the understanding the business data requirements, ETL and subsequently creating testing of data in reports.
• Documented requirements for numerous Adhoc reporting efforts.
• Tested several Reports for completeness, quality for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Analyzed the bug reports in reports by running similar SQL queries against the source system(s) to perform root-cause analysis.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Environment: Jira, Teradata, Teradata SQL Assistant,Informatica 8.6.1, Business Objects XIR3, QTP 9.2, Quality Center 9.2, SQL, PL/SQL, IBM DB2, VBA MS Excel, Erwin, Autosys

Confidential, Mt Laurel, NJ

Data/ETL Analyst

Responsibilities:

• Verifying the Business requirement document and Technical design document against requirements.
• Prepared Test Scenarios based on understanding of business process flow.
• PerformedUATtesting in theUATenvironment prior to notify to the customer to start performingUATtesting.
• Worked with the testing team to provide insights into the data scenarios and test case.
• Verify and analyze data mapping issues and work with data analysts to find effective fix.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Metrics reporting, data mining and trends in helpdesk environment using Access.
• Load new or modified data into back-end database.
• Trained on building Conceptual, Logical and Physical data model.
• Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
• Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System.
• Tested reports developed by SSRS for both Adhoc & Canned Reporting users.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Gather data from Help Desk Ticketing System and write Adhoc reports and, charts and graphs for analysis.
• Tested analytical reports using Analysis Studio
• Involve in review the Use cases of functionality with project team.
• Prepared Daily Status and Weekly status report
• Attending reviews, status meetings and customer interaction.

Environment: Excel, MS Visual studio, SQL Server 2000, Erwin, Windows 2000, TOAD, SSIS, MTM, SharePoint, TFS, SSRS