OBJECTIVE:

• Seeking a challenging position of a data analyst in an organization in order to utilize my analytical skills to help the top management in their decision making.

SUMMARY

• Possess fundamental understanding in finance, health care and retail industry.
• Talented with the data management policies, procedures and widespread technical tools.
• Strong logical, assessment and interpretation skills.
• Strong numerical, interpretative, analytical and diagnostic skills.
• Established aptitude to use and administer large databases using analytical tools.
• Advanced know - how with Excel and Visual Basic and Base SAS, SQL (oracle), Expert user of PowerPoint.
• Excellent planning and administrative abilities.
• Demonstrated ability to administer and recognize customers’ requirements and able find and procedure company data to hold up business decisions.
• Excellent in writing highly complex and well-tuned SQL queries to fulfill ad-hoc and strategic data segmentation requests.
• Created numerous reports using SAS and Pivot tables (Excel).
• Vast experience of working in the area of Data Management including Data Analysis, Gap Analysis and Data Mapping Functions. Tuning using various types of Partitioning and Indexes.
• Involved in retrieving and extracting data from multiple sources.
• Skilled in writing Data Mapping documents, Data Transformation Rules and maintaining Data Dictionary and Interface Requirements documents.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, and System Administrators.
• Knowledge of complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
• Experience in Data Alignment and Data Cleansing.
• Experience in Business Intelligence (and BI technologies) tools such as OLAP, Data Warehousing, reporting and querying tools, Data Mining and Spreadsheets.

TECHNICAL SKILLS

Operating System: Win XP, Vista, 7, Windows Server 2003, 2008, 2012(X32, X64), Unix

Business Applications: MS Access, Excel, Word, Outlook, PowerPoint, Visio and SharePoint

Databases: MS SQL Server 2005/2008/2012 , Teradata 12/13, My SQL 5.2

ETL/Other Tools: SAS 9.x, Informatica Power Center 8.6.1/9, Hyperion, SAP FICO

Scripting: SQL, PL/SQL

Querying Tools: Quest TOAD 9.1, SQL Server Management Studio 2008/2012, Teradata SQL Assistant, SQL Developer, Teradata-BTEQ, Teradata FastLoad, Teradata MultiLoad, Teradata TPump.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

• Provided analysis, understanding and business perspectives on many financial and operational issues.
• Used SQL queries and data mining to provide summary reports and data feeds to analytics.
• Involved in retrieving and extracting data from multiple sources.
• Maintained and updated data dictionary for CRMS.
• Worked closely with compliance team to provide customer risk rating and adhoc reports.
• Identified data source for cash vault, commercial cards, deposits, ACH & Wires & treasury management checks.
• Created Gap analysis document and performed data quality check.
• Used OLAP functions like csum, random, top n and qualifies.
• Gathered, analyzed and summarizeddatafrom multiple sources in support of presenting meaningful workforcedataand metrics to support the business needs.
• Analyzed the data using MS Excel Pivot table, and VLookup functions for different line of business under whole sale banking.
• Created numerous views for the business analyst team that the data is available on need to know basis,
• Created Tables in Teradata Database and SQL server for adhoc environment.
• Performed in depth analysis of data & prepared weekly, biweekly and monthly reports by using MS Excel, MS Access and SQL.
• Involved with business stakeholders, subject matter experts and technical groups to collect document and understand data validation and migration requirements.
• Identified problematic areas and conduct research to determine the best course of action to correct the data
• In collaboration with the DBA, migrated data from Teradata to SQL server for Adhoc environment for business analyst team.
• Mapped data from source application (CRMS) to target application.

Environment: Teradata 13.11, SQL Server 2008, Oracle SQL developer 3.2.09, MS Office, windows2007, windows XP

Confidential

Data Analyst

Responsibilities:

• Resolved the data related issues such as assessing data quality, data consolidation, evaluating existing data sources.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Involved working on different set of layers of Business Intelligence Infrastructure.
• Performed Data cleansing and scrubbing while finding the quality data.
• Worked on integration workflows and load processes.
• Worked extensively in Data consolidation and Harmonization.
• Worked extensively on the MS-SQL environment to run out the queries and explore the Databases.
• Defined key facts and dimensions necessary to support the business requirements.
• Used Teradata OLAP functions like random, qualifies, top n, rank, sample and random.
• Teradata SQL performance tuning.
• Made statistical analysis and reports using SAS
• Used PROC SORT to check uniqueness of ID variables.
• SAS datasets extensively with SAS base, SAS Macro and PROC SQL
• Converted data from MS Excel to SAS datasets with PROC IMPORT
• Mainly and effectively performed data sampling, data coding, verification, cleaning, conversion from other databases to SAS for further processing and analysis.
• Managed and supported the warehouse with the help of CRM tool.
• Used MS Excel functions like Lookup, Pivot tables & Macros for data analysis.
• Meeting with user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
• Flat file conversion from the data warehouse scenario.
• Created Fact and Dimension tables in Mart.

Environment: Teradata, Oracle 10g, SQL, UNIX Shell Scripting Informatica Power Center 8.6/8.1.1, Workflow Designer, Power center Designer, Repository Manager, XML, Windows NT/2000/XP, SAS base 9.0.

Confidential, Wilmington, DE

Data Analyst/ Business Analyst

Responsibilities:

• Processed data received from vendors and loading them into database. The process was carried out on weekly basis and reports were delivered on bi-weekly basis. The extracted data had to be checked for integrity.
• Conducted JAD sessions to identify Requirements.
• Documented requirements and obtained signoffs.
• Coordinated between the Business users and development team in resolving issues.
• Documented data cleansing and data profiling.
• Wrote SQL scripts to meet the business requirement.
• Analyzed views and produced reports.
• Identified and Generated BTEQ scripts for moving data from bad record to good one.
• Tested cleansed data for integrity and uniqueness.
• Automated the existing system to achieve faster and accurate data loading.
• Generated weekly, bi-weekly reports to be sent to client business team using business objects and documented them too.
• Experience creating Business Process Models.
• Ability to manage multiple projects simultaneously tracking them towards varying timelines effectively through a combination of business and technical skills.
• Used MS Excel Pivot Tables for analyzing the data.
• Good Understanding in clinical practice management, medical and laboratory billing and insurance claim with processing with process flow diagrams.
• Worked with compliance team to provide walkthroughs, review requirements and secure approvals to make sure the project is HIPAA compliant.
• Assisted QA team in creating test scenarios that covers day in a life of patient for Inpatient and Ambulatory workflows.

Environment: Mainframe,Teradata,Informatica Power Center 8.6/8.1.1, Windows XP, Windows 2005 Server, Excel Macros, UNIX, OLAP, MS VB, and MS Office.

Confidential

Data Analyst

Responsibilities:

• Maintained data consistency, database integrity and reported instances of data corruption.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for reports.
• Implemented business rules on data using Stored Procedures, Functions and Packages.
• Worked extensively on SQLServer 2005/2008, MS Access.
• Solid program development and business process knowledge - utilized effective communication skills
• Performed data quality checking.
• Used Teradata OLAP functions like random, qualifies, top n, custom, sample and random Teradata SQL performance tuning.
• Data migration between different environments and Third Party Databases.
• Using Oracle SQL, SAS procedures, packages, functions, database triggers to developing and execute MDM reports for performance and response purposes.
• Created complex and reusable SAS MACRO to create table, listing and graph for the submission to higher management.
• Analyzed the data using MS Excel Pivot table, and VLookup functions.
• Created reports in various output forms like Html, PDF using SAS ODS.
• Created drill down analysis reports using SQLServer Reporting Services.
• Extracted data from Teradata and Oracle and created pivot tables in Excel.
• Created Transformations and Mappings by using Informatica Designer.
• Processing tasks using Workflow Manager in order to move data from multiple sources into targets.
• Examines existing data and makes recommendations for improvement/efficiency. Resolved requirements and design issues.
• Participated in the testing process, ensuring testing verifies the user requirements.
• Works to continually improve the quality and efficiency of business systems.
• Aided in management and documentation of all project deliverables as well as training knowledge based articles.

Environment: Microsoft Project, SQL Server Analysis Services 2000, SQL Server 2000, Teradata, PL/SQL, MS Excel, MS Access 2003, Query Analyzer, DTS,MS Power Point, Visio, Visual Source Safe, ETL, QTP, TestDirector.

Confidential, Richmond - VA

Information Analyst

Responsibilities:

• Creation of SAS datasets from access tables as per business requirements.
• Data cleansing/scrubbing and validation.
• Archiving obsolete data on mainframe table using JCL and MVS platforms.
• Creation of Teradata user tables from SAS datasets and granting appropriate access rights.
• Automating the process of uploading the user tables in production tables using BTEQ and UNIX.
• Creating ad-hoc reports using SAS report feature.
• Logical and Physical modeling of tables.
• Handled end user queries regarding enhancements implemented.
• Created metadata and prod approval documents for the project.
• Used SQL queries and data mining to provide summary reports and data feeds to analytics.

Environment: Max OSX, Teradata 12, UNIX, Golden Gate, SQL

Confidential

Business Analyst

Responsibilities:

• Identified and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with corporate strategic objectives.
• Provided analysis, understanding and business perspectives on many financial and operational issues.
• Used Rational Unified Process (RUP) for streamlining the teams’ development activities.
• Gathered Business Requirements, analyze data/workflows. Defined the scope, financial projections and Cost/benefit analysis. Progressed from Problem Statement to well-documented Designs.
• Utilized Rational Requisite Pro as a user to analyze the business requirements and created test plans, test cases and test strategy using Rational Test Manager.
• Hands on experience working in MS-Excel and developed Excel models of detailed amortization schedule of various Gfee (Guarantee Fee) items.
• Collaborated in the creation and updated the Requirements Traceability Matrix (RTM) using Mercury Quality Center (Ver 8.2).
• Actively involved in validating the requirements and applying the RUP framework throughout the SDLC.
• Defined and performed the Test strategies and associated scripts for the verification and validation of all defined business requirements and associated functionality.
• Reviewed and analyzed the Use cases and come up with System design and Test plan Templates
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Developed prototype of new information processing application. Facilitated collection of functional requirements from system users and preparation of business requirement documents using Rational Requisite Pro.
• Involved UI, requirement and data modeling sessions and developed DFD Diagrams and ERDs.
• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Involved in Incident Reporting and Change Control procedures using Clear Quest and reports to track process of repairs and determine the current quality of the application.
• Performed and co-coordinated the System testing, regression testing of various builds during integration, performance and User acceptance testing using Rational Test Suite.
• Provided continuous feedback on project status to the team and senior management.
• Assisted the business in evaluating priorities, risks, and costs versus benefits of various solutions.
• Reviewed new system functionality and patched to determine what is applicable and what should be presented to the business for prioritization, across the various Lines of Business, including change management.
• Prepared weekly and monthly team status reports, progress identification reports, risk mitigation reports, production support reports, and financial and Corporate Infrastructure reports.
• Conducted design reviews to ensure that deliverables meet business needs, including in-house data share application development.
• Prepared documents such as Project Scope, Project Vision, Project Success, Business Requirements, Functional Specification, Data Warehouse Process Flow (SQL queries & Crystal Reports) using MS Office (Word, Excel, Visio) and dashboards.
• Communicated business and functional requirements to the development team for design.
• Facilitated implementation of new functionality through training sessions, demos, and training manuals.
• Developed and executed systems integration test scenarios.
• Worked with Release management for Implementation Plans (Pre and Post) to define roles and responsibilities, efforts and dependencies.

Environment: Rational Unified Process (RUP), UML, Windows, Oracle, SQL, Microsoft Office suite, Rational Enterprise suite, JAVA, J2EE, JSP, HTML, Visual Basic