We provide IT Staff Augmentation Services!

Data Analyst Resume

Minneapolis, MN

SUMMARY

  • 8+ years of Industry experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sourcesand strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
  • Expert in writing SQL queries and optimizing the queriesin Oracle,SQL Server 2008 and Teradata.
  • Excellent Software Development Life Cycle (SDLC)with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
  • Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Performeddata analysis and data profiling using complexSQLon various sources systems including Oracle andTeradata.
  • Excellent experience on Teradata SQL queries, Teradata Indexes, Utilities such asM - load, Tpump, Fast load and Fast Export.
  • Experienced working withExcel Pivotand VBA macros for various business scenarios.
  • Strong experience inData Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, andData Exportthrough the use of multiple ETL tools such as Ab Initio and Informatica Power Center Experience in testing and writing SQL and PL/SQLstatements - Stored Procedures, Functions, Triggers and packages.
  • Experience inautomating and schedulingthe Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions.
  • Excellent knowledge on creating reports onSAP Business Objects, Webi reports for multiple data providers.
  • Excellent knowledge in preparing requiredproject documentationandtrackingand reportingregularly on the status of projects to all project stakeholders
  • Extensive knowledge and experience inproducing tables, reports, graphsand listings using various procedures and handlinglarge databases to perform complexdata manipulations.
  • Excellent experience inData miningwithquerying and mining large datasetsto discover transition patterns and examine financial data.
  • Experience in testingBusiness Intelligence reportsgenerated by various BI Tools like Cognos and Business Objects
  • Excellent knowledge on creatingDML statementsfor underlying statements.
  • ExtensiveETL testing experience using Informatica8.6.1/8.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Have good exposure on working inoffshore/onsite modelwith ability to understand and/or create functional requirements working with client and also have Good experience in requirement analysis and generating test artifacts from requirements docs.
  • Excellent in creating various artifacts for projects which includespecification documents, data mappingand data analysis documents.
  • Anexcellent team player& technically strong person who has capability to work withbusiness users, project managers, team leads, architectsand peers, thus maintaining healthy environment in the project.

TECHNICAL SKILLS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, Logical Data Physical Modeling, Erwin r7.2/3/4, Sybase Power Designer.

Databases: Oracle 11g, 10i 9i/8i, SQL Server 2008/20052000 , DB2, TeraData 12, MS Access.

BI: Business objects

ETL: Abinitio, Informatica Power Center 8.X/7.x/6.2

Tools: WinSQL, TOAD, Autosys, Teradata SQL Assistant, ClearQuest, ALM

Environment: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3,Sun Solaris7, WinNT4.0

Data Warehousing: Informatica(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, Data Stage

Reporting Tools: Business Objects, XIR3, Cognos Suite

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

Programming: SQL, PL/SQL, UNIX Shell Scripting, VB Script

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

  • Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
  • Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle andTeradata.
  • Written several shell scripts usingUNIXKorn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
  • Metrics reporting, data mining and trends in helpdesk environment usingAccess
  • Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MSAccess,Exceland SQL
  • WrittenSQLscripts to test themappingsand Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
  • Involved in extensive DATA validation by writing several complexSQLqueries and Involved in back-end testing and worked with data quality issues.
  • Worked with end users to gain an understanding of information andcore dataconcepts behind their business.
  • Assisted in defining business requirements for the IT team and createdBRD and functional specificationsdocuments along with mapping documents to assist the developers in their coding.
  • Identify & record defects with required information for issue to be reproduced by development team.
  • Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
  • Flexible to work late hours to coordinate with offshore team.

Environment: MS SQL Server 2008 client & SERVER, MS office, Legacy - Mainframes, Titanium, Rational Clear Quest, Clear Case.

Confidential, Houston, TX

Data Analyst

Responsibilities:

  • Work with users to identify the most appropriatesource of recordrequired to define the asset data for financing
  • Performdata profiling in the source systemsthat are required for financing
  • Document the completeprocess flow to describe program development, logic, testing, and implementation, application integration, coding.
  • Involved in defining the trumping rules applied by Master Data Repository
  • Define thelist codes and code conversionsbetween the source systems and MDR.
  • Involved in defining thesource to target data mappings, business rules, business and data definitions
  • Responsible for defining thekey identifiersfor each mapping/interface
  • Responsible for defining thefunctional requirement documentsfor each source to target interface.
  • Document, clarify, and communicate requestsfor change requests with the requestor and coordinate with the development and testing team.
  • Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.
  • Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.
  • Interact with computer systems end-users and project business sponsors todetermine, document, and obtain signoff on business requirements.
  • Responsible in maintaining theEnterprise Metadata Librarywith any changes or updates
  • Documentdata quality and traceabilitydocuments for each source interface
  • Establish standards of procedures. Generate weekly andmonthly asset inventory reports.
  • Coordinate with thebusiness users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
  • Remain knowledgeable in all areas ofbusiness operations in order to identify systems needs and requirements.
  • Provided direction and shares knowledge with and mentored team members in areas of expertise.
  • Identified and continuously acted to improve individual and team knowledge of new technologies, business processes and project management skills.
  • Stayed current on trends, latest industry developments and shared knowledge among colleagues.
  • Excellent skills in user research and analysis of the existing systems, with knowledge of traceability matrix.
  • Strong Experience in conductingUser Acceptance Testing (UAT), Unit Testing and documenting Test Cases and Test Scripts.
  • Excellent verbal and written communication skills with the ability to interact professionally with stakeholders at all levels of the organization, including the ability to exercise good judgment in frequency and nature of communications to senior management, stakeholders and team members.
  • Possess a disciplined, professional and quality centered approach with strong analytical and problem solving skills.

Environment: SQL/Server, Oracle 9i, MS-Excel, Teradata, MDM, SAP, QlikView, Microstrategy, Informatica, PowerPivot, ER Studio, XML, Selenium, SoapUI, CruiseControl.Net, HP Quality Center 10, Maven Business Objects, OBIEE, Cognos

Confidential - Dallas, TX

Data Analyst

Responsibilities:

  • Involved inData mapping specificationsto 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.
  • Analyzedbusiness requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
  • Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
  • TestedComplex ETL Mappingsand Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data,Relational Data(Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
  • Performedad hoc analyses, as needed, with the ability to comprehend analysis as needed
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Responsible for creatingtest cases tomake sure the data originating from source is making into target properly in the right format.
  • Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc
  • Involved inTeradata SQL Development, Unit Testing and PerformanceTuning and to ensure testing issues are resolved on the basis of using defect reports.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • Experience in creatingUNIX scripts for file transferand file manipulation.
  • Provide support to client with assessing how many virtual user licenses would be needed for performance testing.
  • Ensuringonsite to offshore transition, QA Processes and closure of problems & issues.
  • Tested the database to checkfield size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Informatica 8.1, Data Flux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata

Confidential - Herndon, VA

Data Analyst

Responsibilities:

  • Involved in the design of the overall database usingEntity Relationshipdiagrams.
  • Wrote triggers, menus andstored proceduresinPL/SQL.
  • Involved in developing interactive forms and customization of screens usingForms 4.5.
  • Involved inbuilding, debugging and runningforms.
  • Involved inData loadingandExtractingfunctions usingSQL*Loader.
  • Designed and developed all thetables, viewsfor the system in Oracle.
  • Designing anddeveloping forms validationprocedures for query and update of data.
  • Extensive learning and development activities.
  • Performed back-end testing for the Application.
  • Performed manual testing for integration and acceptance.
  • Performed negative and positive testing for the application.
  • Modified existing Test Plans and Test Scripts for regression testing.
  • Conducted data integrity testing by extensive use of SQL.

Environment: Oracle, SQL*plus, SQL*Loader, T-SQL, PL/SQL, Forms, Reports, Business Objects, WinRunner

Confidential

SQL Developer

Responsibilities:

  • Designed and developed various SQL scripts as a part of automation of manual monthly reporting to the third-party consumer.
  • Responsible for gathering requirements from business analysts and operational analysts and identifying data sources required for requests.
  • Worked on data analysis, profiling data and validating the reports sent to third party.
  • Extracted, analyzed and presented data in a graphical format using Microsoft Excel that helped managers to make key business decisions.
  • Worked on data validations and verifications to evaluate data is consistent and appropriate that generated is according to needed requirements.
  • Contributed to the standardization of reports, using SAP, SQL and Tableau. Automated reports eliminating manual reporting effort by 9 hours weekly.
  • Assisted in the design of the database using Entity Relationship diagrams.
  • Involved in Data profiling, cleansing, Data loading and Extracting functions using SQL Loader.
  • Assisted in ETL implementation using SQL Server Integration Services (SSIS), applying some business logic and data cleaning in staging server to maintain child and parent relationship.
  • Deliver reports and ad-hoc analysis focused in the area of client behavior and profiling using SAS, SQL and Excel.

Confidential

SQL Developer

Responsibilities:

  • Worked on the project that involved development and implementation of a data warehouse.
  • Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in all the environments for SQL Server 2000.
  • Developed DTS Packages to transfer the data between SQL Server and other database and files.
  • Scheduled jobs & Re-Scheduled on Production Databases.
  • Created report form with Stored Procedure using T-SQL.
  • Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
  • Created database objects like tables, views and indexes.
  • Created and modified stored procedures, triggers and cursors.
  • Designed, developed and modified various Reports.
  • Handled and managed customer relationship management system.
  • Designing and modeling database according to Requirement. And made changes according to it.
  • Designed, developed, and tested complex queries for Reports distribution.
  • Built and performed user acceptance testing on modified reports.
  • Skilled in running jobs in Enterprise Manager using job-scheduling tool.

Environment: MS SQL Server 2005, MY SQL, Lotus Access, MS Office Suite (word, power point, excel), SSRS, SQL Server Integration Services (SSIS).