SUMMARY

• Around 7 years of professional experience as a Business/Database Analyst, Configuration Management Analyst in IT Industries
• Strong Data Warehousing, Data Marts, Data Analysis, Data Organization, Metadata and Data Modeling experience in RDBMS databases
• Attending project meetings and work with teams, Project managers, team members / associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks.
• Experience in understanding different business process, functionality requirements, and data requirements in relation to process and come up with scenarios to validate the flow.
• Designing, Developing, implementation of the Data marts, Data Structures, Stored Procedures, Functions, Dataware house tables, views, Materialized Views, Indexes at Database level using PL/SQL and Oracle.
• Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL, PL/SQL, Ms Excel and Ms Access.
• Extensive experience in data cleansing and analysis, using pivot tables, formulas (v - lookup and others), data validation, conditional formatting, and graph and chart manipulation
• Proficient in writing UNIX shell scripts and other scripting languages for data analysis.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Good knowledge on Crystal Reports XI 2008 and Crystal XCelsius 2008
• Good Experience in Publishing Reports in Business Objects Enterprise and Crystal Enterprise via.
• Crystal Publishing Wizard and Crystal Management Console and distributed reports in multiple formats such as Excel, Word, RTF, HTML & PDF in CMC.
• Wrote documentation for the reports. Developed curriculum and trained users on Clarity data and reporting tools such as Crystal reports and SQL.
• Good experience in Developing Drill down created various Charts and Graphs by using Chart expert of Crystal Reports.
• Archived the old data by converting them in to SAS data sets and flat files.
• Performing Data Retrieval, Data validation/Mining, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst by using Oracle, DB2 and SAS.
• Extensive data mining of different attributes involved in business tables and providing consolidated analysis reports, resolutions on a time to time basis.
• Experience Performing Problem troubleshooting, Problem resolution, and root cause analysis for Application and batch related issues.
• Experience creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
• Good working knowledge with the MDM components like core master data hub, Data integration and consolidation, Integration and delivery, access control, Synchronization, Operations and data governance
• Worked with the users and testing teams to implement the business logic as expected.
• Good understanding of SDLC and project management principles.
• Good experience working with very large databases and Performance tuning.
• Creative to understand complex problems and finding right solutions in time.
• Team Player as well as able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

RDBMS: Oracle (SQL, PL/SQL, Stored Procedures, Rapid SQL), NCR Teradata utilities (BTEQ, \Fast Load, Fast Export), SQL SERVER, DB2, Sybase and Access

Languages: SQL, PL/SQL, C and C++, k-Shell, C-Shell, Visual Basic, Perl, Python

Operating Systems: Windows 2000/NT, XP, UNIX, Windows 7

OLAP: Business Objects /XIR2, BO Enterprise, Info View, Web Intelligence

Technologies: Client Server, Data Warehousing, Web -enabled

Tools: Toad, Teradata Sql Assistant, Test director, Mercury quality center, MS Office, SAS, MS Excel, Ms Access, Ms Word, RequisitePro, Clear case, Clear quest

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Sr. Data Analyst

Responsibilities:

• Perform Daily validation of Business data reports by querying databases and rerun of missing business events before the close of Business day.
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Assisted / influenced management team in making key business decisions by providing essential business intelligence in the format of graphs, charts, data analysis and conclusions
• Involved in data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.
• Daily use of complex Excel formulas and pivot tables to manipulate large datasets.
• Optimizing the complex queries for data retrieval from huge databases.
• Root cause analysis of data discrepancies between different business system looking at Business rules, data model and provide the analysis to development/bug fix team.
• Lead the data Correction and validation process by using data utilities to fix the mismatches between different shared business operating systems.
• Worked on mapping and modeling of the data.
• Checking and validating data in the Mapping document running the queries on Teradata.
• Modified the existing mapping template to a more clear and easy to understand template.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Identified the source and target tables. Developed mapping document using MS excel.
• Conduct downstream analysis for different tables involved in data discrepancies and arriving at a solution to resolve the same.
• Developed Views, Stored Procedures, Packages, Functions and Database Triggers.
• Involved in data mining of different attributes involved in business tables and providing consolidated analysis reports, resolutions on a time to time basis.
• Verifying data quality after every deployment and perform extensive analysis for the data variance pre and post implementation.
• Developed data quality script to analyze and report on provider data to the MDM team.
• Part of the tem working on MDM core functionalities like Identity resolution, Core data models, Data governance utilities, Data integration, Standardization and enhancement, Data profiling
• Played a substantial role in the process identification, definition and functional requirements gathering, in an effort to develop a practical technology solution.
• Involved in Database report development utilizing Crystal Reports XI, MS Access, Excel(charts/graphs, and pivot tables), and rePortal (Crystal Report Publishing Tool)
• Create new reports with formatting or standard templates, applying sorts, Calculations, Breaks and Ranking to data based on the client requirement.
• Export the Crystal reports to Excel and PDF formats for end users to allow viewing the reports on varying systems
• Published Reports in Crystal Enterprise via. Crystal Publishing Wizard and Central Management Console.
• Extensively involved inUser Acceptance Testing (UAT) and Regression testing.
• Involved in writing automation scripts for daily reports using Perl scripting language

Environment: HP UNIX, Clear Case, Clear Quest, Windows XP, SAS, Excel, Teradata 12.0, toad, PL/SQL, Shell Scripts, Perl, DB2, Crystal reports 2011,SQL Server 2008, VB, Pivot Tables, Rapid SQL.

Confidential, Reston, VA

Data Analyst/ ETL Analyst/ Report Developer

Responsibilities:

• Developed Ad hoc queries, SQL queries to fill business analyst, Operations Analysts, Financial analyst data requests.
• Involved in data analysis and returned a report with charts, descriptive statistics, Cross Tabulations, Tests and conclusions.
• +Enhanced the existing shell scripts to include new customers and executed automation scripts for daily reports using Perl scripting language.
• Performed Data validations, Data integrity before delivering data to operations, financial analyst.
• Assembled & analyzed the modeling database using data mining techniques, including data reduction, data enhancement and data transformations.
• Implemented business rules on data using Stored Procedures, Functions and Packages.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Used SSIS, SSRS for solving business problems and creating reports in organization.
• Designing Logical and Physical data models for collateral management application.
• Developed data quality rules for the application and ETL team to cleanse and transform the data.
• Worked in the Data migration approach of loading into target on incremental approach.
• Designed staging tables for Data migration to load and transform legacy data.
• Created scripts to modify database structures
• Worked with test team for writing scripts and validate data and fix database errors in database
• Worked on source to target mapping between legacy and target data model.
• Created data trace map and data quality mapping documents.
• Involved in defining the source to target data mappings, business rules, and business and data definitions.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Work with offshore team to handle data warehouse, ETL and Business Intelligent development.
• Create scripts and execute them to perform data migration between environments.
• Performed data investigation to find out the data issues in the underlying feeds and databases
• Facilitated metadata walkthrough sessions with application and data governance team.
• Worked in the development of end to end data flows for the application.
• Worked on Design, report and layout with Reporting team
• Developed Quality Assurance plans as data cleansing and data quality rules.
• Worked in the validation of test data and data conditioning to support the testing.
• Worked on the documentation of entities and attributes and metadata.
• Worked with the data governance team to establish new processes and procedures like data standardization and data quality.
• Worked on maintaining the integrity of the Master Reference data (MDM)
• Worked on creating the test cases and UAT process
• Worked in evaluating and implementing tool sets for data profiling
• Worked with data conditioning and test cases for supporting testing phase

Environment: HP UNIX, Clear Case, Pivot Tables, Excel, Clear Quest, Windows XP, SAS, Shell Scripts, Perl, SQL Server 2008, SSIS( SQL Server Integration Services), SSRS( SQL Server reporting services),VB,DB2, Excel and Rapid SQL.

Confidential, Reston, VA

Data Analyst/Data Miner

Responsibilities:

• Made sure all the applications moved into production environment meets the standards set by team and have no performance issues.
• Extensive Excel work using pivot tables and complex formulas to manipulate large data structures.
• Assembled & analyzed the modeling database using data mining techniques, including data reduction, data enhancement and data transformations.
• Wrote automation scripts for data mining on daily and weekly reports using Perl.
• Extensivedata miningof different attributes involved in business tables and providing consolidated analysis reports, resolutions on a time to time basis.
• Interacted with DBA’s about SQL Tuning issues and implemented the changes in the script as per their recommendations.
• Constantly monitoring the status of applications in production and let the customers know if there are any issues in UNIX environment.
• Perform data quality checks on manufacturing data received from different process every day and provide the discrepancies in any process using statistical process control mechanisms.
• Restart the application with any changes needed if any of the application fails for that day.
• Provide end of month report to the team about the metrics of production performance.
• Always reacted fast on the dollar impact reports which are time sensitive as well.
• Gathered and uploaded all the documentation and scripts of production into Knowledge Link.
• Maintained scripts in Scheduler to run properly.
• Performed data mapping from source to target.
• Used Stored Procedures, Packages and Database Triggers extensively.
• Extensively involved in coding and writing complex database triggers, stored procedures and packages.
• Achieved goal of developing structures to support moving data from DB2 mainframe to Teradata.
• Performance tuning and Optimization of large database for fast accessing data and reports Ms Excel, Unix, Oracle, Teradata being used for data transformation.
• Provided and/or developed automation scripts using Perl and Shell.
• Exported data from Teradata into various files by using Ms Excel, Ms Access and SAS.

Environment: Teradata, DB2, Excel, sql assistant 6.1/12.0, 6.01,BO, SQL, PL/SQL, UNIX, PERL, Windows 2000/NT UNIX, SAS 9.1.3, SQL Assistant, SAS PROC SQL, JMP,Yield3 and SPC charts

Confidential, Cleveland, OH

Data Analyst

Responsibilities:

• Provided Data Analysis, gathered Business requirements and Designed and developed various Business Reports.
• Developed various BTEQ scripts to create business logic and process the data.
• Developed complex queries to retrieve data from multiple sources, charts, tables and crosstabs.
• Generated weekly, bi weekly, monthly reports with help Oracle, SQL, MS Access, MS Excel, UNIX, SAS.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes).
• Assisted IT developers and non IT developers (Database Analysts) with Teradata Utilities.
• Large volume of Mainframes data is extracted and converted into Oracle tables from remote UNIX and Windows environments.
• Monitoring the existing code performance and to change the code for better performance.
• Performed data validations, Data integrity before delivering data to operations, financial analyst.
• Experience in database monitoring and data stewardship.
• Identifying root cause problems and providing solutions..
• Developed SQL queries for Extracting data from production database and built data structures, reports.
• Designed, Developed Ad-hoc reports as per business analyst, operation analyst, project manager data request.
• Developed programming standards and custom Perl modules to increase script resilience and maintainability
• Analyzed data by pulling data from data warehouse into MS Excel and build graphs.

Environment: Teradata, SQL Developer, Excel, SQL server 2005., SQL, PL/SQL, UNIX, Windows 2000/NT UNIX, SAS 9.1.3, SQL Assistant, SAS PROC SQL