OBJECTIVE:

BI Developer\ Data Analyst\ETL Developer\SSAS Developer\Database Developer\SQL Developer

SUMMARY:

• More than 8 years of experience in System Data Analysis for data integration, data volition, data cleansing by creating ETL package, as well as Development and maintenance of database applications on SQL Server 2008R2/2012 R2 in OLTP/OLAP/BI environment
• Worked experience in Insurance, Healthcare, Retailer, and UniversityWorked experienced on BI developer, SQL developer, Data architect, DBA
• Experience on SQL Server: SSRS, SSAS, SSIS, SharePoint;
• Oracle: sqlplus, sqlldr, SQL developer, TOAD;
• SAP Database Objects BI, Crystal Reports;
• Tableau, CRM, Sybase, SQL Anywhere, PixelPoint POS
• IDX(GE Healthcare), QNXT(TriZetto), etc.
• Production support: Database, Data warehouse, Cube process, job, analyze, diagnosis, and trouble shooting as a BI developer and DBA duties
• Experience on SQL, TSQL (Stored procedure, function, trigger, and cursor)
• Experience on logical and physical design schema, data modeling, and creating Database, Data mart, and Data Warehouse
• Experience on creating and maintaining cube and data mining
• Maintenance of data warehouse for loading data daily, cube processing
• Worked on database of projects related to retailer, clinic trail, healthcare insurance plan, finance, home and auto loan processing, school events, human resources, lawyer office business, and weblog
• Experience on automation, marketing campaign, data mining models and predictive analytics
• Experience on Team foundation server (Agile)Worked projects: Marketing campaign, customers predictive analytics
• Design, architecting, and maintaining database, data mart, data warehouse
• Creating and maintaining BI solution: SSIS package, cubes, data mining models, SSRS report, Crystal Reports, dashboard and Power view report
• Design and create automation program (ETL) for data validation and data cleansingdata loading, data file generation for qualifying format
• Loading data into database, dimensional data warehouse
• Design and create SSIS package for data validation and data cleansing automatically, as well as generate data file for qualifying format
• Customizing logging and event handler
• EDI and raw data in health insurance
• Created various types of reports, managed report security, deployed and developed web reports using SAP Crystal Reports, Tableau, Excel and SSRS
• Built various report based on business requirements: matrix report, parameter report, dashboard report with charts and drill down function, cascading report, custom coded report, linked report, and KPI report etc.
• Created SSRS report
• Created Crystal Reports
• Created Tableau reports
• Created dashboard report using SSRS, excel with MS macros, and Tableau
• Created SharePoint report, power view report
• Created pivot report and KPI report in excel using cube or stored procedure
• Migrated Jasper Reports to SSRS
• Migrated Crystal Reports to SSRS
• Created data mart, cube and large dataset view for data analysis, created data mining models for predictive analysis, used SSAS and PowerPivot
• Created cube with measure and dimensions for reporting
• Configured attributes of dimension table with hierarchy relationships
• Maintained cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions
• Created data - mining solutions in BIDS/SSDT, created large dataset and view, deployed them to SSAS instance
• Trained the model and queried the model using DMX
• Evaluated models and used ideal model for prediction of business
• Used excel2010 PowerPivot for data mining and analysis
• Installed, configured SharePoint2010 with SQL server 2008R2 integration and SharePoint2010 with SQL Server 2012 farm, maintained services and sites
• Planed and designed SharePoint environment
• Created, modified, and maintained SharePoint accounts as directed and in compliance with all standard operating procedures
• Create Web application, Service application, site, list, page, libraries, deployed SSRS report and excel report to web, as well as maintenance
• Created SharePoint power view report
• Production support, troubleshooting, maintaining database server processes daily
• Installation, configuration and maintenance of database and BI services (SQL Server 2008R2/2012, SSIS, SSAS, SSRS, Share Point and Oracle 11g, 12c), creating database, partitioning of tables, creating indexes, as well as login and user creation, role and permission configuration
• Design, create, develop end user testing environments
• Migration and upgrade of database and BI solutions, troubleshooting
• Worked on performance tuning, query optimization, and database optimization by optimizing code, creating index, trigger, automation procedure and partition
• Worked on maintaining and monitoring database performance by creating customizing logging, SQL profiler, and check points. SQL server maintenance plan backup/restore, and partition
• Worked on creating table, constraints, schema, database and data mart
• Worked on database validation using stored procedure, trigger, cursor
• Experience in load variety of large volume data files into SQL server 2008R2/2012 database, migrate Oracle tables into SQL Server 2008R2/2012 database tables and generate Report with SSRS, as well as migrate SQL database data to Oracle using TOAD
• Experience on maintenance and load variety of large volume data to Oracle using sqlplus, SQL*loader, SQL developer, and TOAD
• Installed, configured, and maintaining virtual machines for windows
• Installed and configured the integration of QA developer with SAP Crystal reports viewer
• Translating business requirements into conceptual, logical, and physical data model ing data modeling using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling
• Designed star schema data warehouse to convert Sybase OLTP to SQL server OLAP model using SSAS
• Architecting and implementing BI solutions:
• Crated SSIS package to load data to dimensional data warehouse
• Created cube, data mining in SSAS for report and predictive analytics
• Load data to data warehouse from staging server, and cube processing
• Advanced SQL queries with multi-table joins, group functions, single row functions, subqueries, Set operation T-SQL (Stored procedure, function, trigger, cursor) and Oracle PL/SQL
• Recursive CTEs, CTE, temp tables, derived tables, and effective DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications
• MDX query

COMPUTER SKILLS:

Databases: SQL Server 2005/2008R2/2012, Oracle, Sybase, CRM, IDX, QNXT

Reporting: SSRS, SAP Crystal Reports 2011/2013, Tableau, iReport (Jasper Report), web reports-ShorePoint2010, SSRS-Report Builder

Analyzing: SSAS, Excel 2007/2010 (Power pivot, Data mining, V Lookups, merge data, cross referencing), FlowJo DataAnalyzer, JMP,SAS

Language: T-SQL, PL/SQL, MDX, Visual Basic, MS macros, sqlplus, ASP.NET

Internet: SharePoint 2010, Web Application, page

MS Office: Word, Excel, PowerPoint, Access, Outlook, Visio

Operating Systems and GUI: Windows Server 2008R2, Windows XP, Windows 7/8 Virtual Machine, VMware, SQL developer, SQL*Loader, TODA, SQLplus Installation, configuration and migration hands on skills Microsoft SQL Server 2008/2012, SSIS, SSAS, SSRSSharePoint 2010 with SQL server 2008R2 integrationSharePoint2010 with SQL Server 2012 farm Oracle11g, Oracle12cSybase, SQL Anywhere (10, 12)

WORK EXPERIENCE:

Systems Data Analyst, ETL Developer

Confidential

Responsibilities:

• Design, create, develop testing environments for end user
• Design, create, develop the data validation programs (includes: created data mart, database, schema, tables, constrains) based on business logic and data logic for data cleansing
• Analyze data, trace errors and root cause, and develop systematic process fixes automatically
• Plan, design, and develop SSIS package and automation programs
• Design and develop metrics report using pivot table
• Design and develop report using SSRS and SSIS (output data file qualifying format)
• Document development activities, and training end users
• Review and optimize codes for performance tuning
• Monitor, maintenance, and troubleshooting automation programs

BI Developer

Confidential

Responsibilities:

• Installed and configured PixelPoint POS Sybase and integrated Crystal reports viewer for end user, built and maintained developer environment for report test
• Design and architecting data mart for different departments
• Modified and maintaining marketing campaign mining models
• Creating reports with sub reports, parameterized reports, nested groups, complex formulas, running totals, summaries and conditional formatting
• Generating reports using tables, views, stored procedures
• Worked on performance optimization of various reports
• Automated reports for weekly, monthly and yearly schedule using Crystal Reports, VB and RDC (Report Designer Component) and delivered via Adobe PDF format. Exported reports to formats like PDF, Excel, and HTML
• Extracted data from Sybase, custom manufacturing Pixel POS application, using Crystal Reports
• Generated SSRS reports for department of Loss and Prevention
• Generated Crystal Reports for all departments in the whole retail company
• Troubleshooting and tickets solution on Crystal Reports
• Wrote complex code of hierarchy for SSRS report
• View codes and optimizing codes for performance tuning

Data Analyst, DBA

Confidential, VA

Responsibilities:

• Worked on data mining and predictive analytics
• Created large data view from data warehouse using complex SQL queries.
• Built different mining models (e.g. decision tree, clustering, and time series) used historic data, evaluated models and mail campaign.