SUMMARY

• 5+ years of experience indataanalysis and statistical modeling includingdataextraction, manipulation, visualization and validation techniques, reporting on various projects.
• Strong skills in SQL,datawarehouse,dataexploration,dataextraction,datavalidation, reporting and excel.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in tableau.
• Good statistical knowledge of descriptive models including various sorts of mixed models and predictive solution model including linear regression, logistic regression and Random Forest.
• Experienced with various ETL tools like SSIS, Informatica,
• Has used SQL queries to performDataAnalysis andDataProfiling.
• Identify source systems, their connectivity, related tables and fields and ensuredatasuitably for mapping.
• Generated ad - hoc SQL queries using joins, database connections and transformation rules to fetchdatafrom Teradata database.
• Hands on experience on T-SQL Programming, Server Integration Service (SSIS), SQL Server Reporting Service (SSRS) and SQL Server Analysis Service (SSAS), Data Analysis/Modeling.
• Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center, DataStage, Ab Initio and SSIS ETL tools.
• Expertise in SAS/Base, SAS/SQL, SAS/Macros, SAS/Stat, SAS/Graph and Output delivery system.
• Outstanding Knowledge and experience in Microsoft Office tools like MS Outlook, MS word, MS PowerPoint, MS Excel/pivot table.
• Excellent client oriented approach, outstanding analytical skills to resolve issues and make teh system run smooth.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

• T-SQL Programming
• Server Integration Service (SSIS)
• SQL Server Reporting Service (SSRS)
• SQL Server Analysis Service (SSAS)
• Data Analysis/Modeling.
• RDBMS (ORACLE)
• TERADATA
• EViews
• Tableau.
• SAS/Base
• SAS/SQL
• SAS/Macros
• SAS/Stat
• SAS/Graph
• SAS/Access
• SAS/ODS
• SAS/SQL
• Knowledge of SAS/Enterprise Guide.
• Microsoft Office Package including MS Excel/pivot table
• MS Word
• MS PowerPoint and MS Access

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Data Analyst

Responsibilities:

• Cleansed file, extracted data and manipulated datasets with different SAS data steps as needed for forecasting analysis.
• Identified and developed requirements for Guidewire Policy Center user interfaces.
• Provide support across different domain areas such as Auto Assignment, Payments, Claims Documentation, and Appointment Logs, Auto Estimations, Fire Claims etc.
• Analyzed teh business rules for Auto claim assignments.
• Designed and developed SAS macros and other utilities to expedite most frequent SAS programming activities and usage by financial reporting and Modeling teams
• Collected requirements from Business Users and take part in preparation of technical specifications
• Created new database objects like tables, procedures, Functions, Indexes and Views
• Designed Constraints, rules and set Primary, Foreign, Unique and default key and hierarchical database.
• Conducts data mapping, designs, develops and implements ETL process
• Extracted, Transformed and loaded data for business users to manipulate into reports
• Supported management team with reports generation and analysis using ETL tools, Excel and SQL
• Performed ETL repository administration including promotion of software packages to proper environment, troubleshooting and technical support
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Developed stored procedures in SQL Server to standardize DML transactions such as insert, update and delete from teh database.
• Created SSIS package to load data from Flat files, Excel and Access to SQL server using connection manager
• Transform teh data using various SSIS tools such as derived Columns, conditional splits, data conversions, Aggregate and Pivot transformation
• Created data transformation task such as BULK INSERT to import data from client
• Identified teh dimension, fact tables and designed teh data warehouse using star schema and designed new schema for teh data mart.

Confidential, San Ramon CA

Data Analyst

Responsibilities:

• Used SQL to access data and retrieve data, maintain accurate and detailed records on assigned structure and create statistical graphs, interpret data and results and provide ongoing reports.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetchdatafrom Teradata database.
• Experienced on Excel (formulas, pivot table) and Tableau to extract factors, summarize and visualizedataand create report.
• Created custom reports and pivot tables for Sales Reps that were tailored by segment, area and technology
• Analysed requirements to make sure that they are feasible realizable on Guidewire Policy Center.
• Extracted data from teh databases (SQL Server) using SSIS ETL tools.
• Designed and Developed SSIS packages for performing ETL process usingSQLServer 2008 Integration Services
• Expert in extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files
• Created Stored Procedure and Views, Indexes,SQL joins and Sub queries
• Worked with integration services for transferring and reviewing data from different sources like (Flat file, Excel, CSV).
• Responsible for data warehouse design and development including conceptual, logical and physical data models, data analysis, data profiling, and ETL design.
• Designed ETL Processes for Extracting/ Cleansing/ Transforming teh data from various sources and loading into teh DW after sorting and aggregation.
• Developed source to target mapping for various ETL feeds.
• Generated Daily, Weekly, Monthly reports for teh analysis of managers and end users by usingSQLServer Reporting Services.
• Created data mapping documents from source to target systems.
• Created logical and physical design of teh centralized Relational Database.
• Identified and processed teh facts and dimension tables.
• Participated in teh tasks of data migration from legacy to new database system.
• Developed and enforced Report Server database administration and user standards and procedures.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded teh data into destination tables by performing transformations using SSIS packages
• Migrated Employeedatafrom HeterogeneousDataSources and legacy system (Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Confidential

Data Analyst

Responsibilities:

• Extractsdatafrom SQL database and Excel tables to create pivot tables and charts for senior management
• Created a library of parameterized T-SQL scripts that can be quickly modified to a specific client's requirement. (code re-use)
• Experience in writing/testing complex SQL Queries, Stored Procedures, Triggers, and User Defined Functions to implement teh business logic.
• Wrote numerous SQL queries to extract data from different data source
• Ran multiple regression analysis to establish relationship models between key data variables
• Conducted association analysis and cluster analysis to optimize product relations and groupings by SAS procedure.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica Mapping.
• Used ETL tool for Extraction, Transformation and Loading teh data into target database.
• Extensive use of SQL server, Pivot Tables in report generation and dashboard creation
• Import/Export data from and into SQL Server platform using SAS tool
• Performed decision tree analysis to investigate teh most optimal bidding strategy based on probability
• SAS code generation for internal team members to export and import data in and out of SAS
• Used SSIS to improve data quality and data integration
• Migrated Employeedatafrom HeterogeneousDataSources and legacy system (Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Provided support for teh development and implementation of business plans, and tracking teh progress of ongoing client efforts and initiatives.
• Generated periodic reports based on teh statistical analysis of thedatafrom various time frame and division using SQL Server Reporting Service (SSRS).

Confidential

Data Analyst

Responsibilities:

• Has used SQL queries to performDataAnalysis.
• Identify source systems, their connectivity, related tables and fields and ensuredatasuitably for mapping.
• Directed teh project plan and completed a large-scaledatamigration (Clean-up, Mapping) and de-duplication from a legacy.
• Used ETL tool for Extraction, Transformation and Loading teh data into target database.
• Contributed to teh SQL Server integration services and applied customized ETL work on to clean and format data into reporting system database.
• Performed data mapping on teh extracted data, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Used MS Visio to carry out teh business modeling, data modeling, and object modeling efforts to develop teh business architecture for rapid and controlled application development.
• Experience in writing SQL queries, Stored Procedures and Triggers.
• Worked extensively on Business Requirements, Functional Specification, Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use cases modelling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards
• Extracted, compiled and analyzeddatafrom MS Access database to generate report and dashboards using Tableau.
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Developed impactful Tableau Dashboards, presented findings anddatato team to improve strategies and operations.
• Collaborated with Business Information Systems to gather, analyze business,datarequirements to design charts and graphs