SUMMARY:

• Business Intelligence, Data Science professional and Database architect/designer/developer/consultant with extensive hands - on experience in all stages of SDLC.
• Seeking long-term projects involving database design, architecture, Business Intelligence, Analytics, & Big Data.

TECHNICAL SKILLS:

Languages: R, Python, SQL, CLSQL, HQL, C#, Perl, Shell scripts, Java

Databases: SQL Server 7/2000/2005/2008/2012/2014/2016, SYBASE, MYSQL, Oracle, Hadoop, Cassandra, MongoDb, PostGress

Operating Systems: Windows 2000 to current server family, XP, DOS and UNIX

Software: PowerBI, Tableau, SQL Azure, Visual Studio, Azure ML Studio, SSIS, SSRS, SSAS, GRETL, Pentaho

PROFESSIONAL EXPERIENCE:

Independent Consultant

Confidential

Responsibilities:

• Mentored & guided multiple team members in variety of discipline
• Utilized SSIS to load data in SQL Azure Cloud database
• Configured SQL Azure in the cloud for geo-replication, ip-based security, & encrypt resources
• Used PowerBI & Tableau to implement Dashboard using SalesForce data in Clouds on Leads, Assessments, student & staff hours
• Researched application of DataScience concept such as A-B test using Gretl on Lead source, Attendance data.
• Tested deployment of SQL Azure Datawarehouse and connected PowerBI with it

Confidential

BI Architect/Developer/Analyst

• Mentored & guided multiple team members in variety of discipline
• Used PowerBI & Tableau to implement dashboard using SalesForce cloud data on Donors, Volunteers. Built Geo-segmentation model.
• Researched application of DataScience concept such as linear regression using Gretl on donor, volunteer data. Tested POC in Azure ML Studio
• Researching data ingestion via SSIS to Amazon AWS for possible deployment

Confidential

BI Architect/Developer/Analyst

• Mentored & guided multiple team members in variety of discipline
• Worked in BigData project for Merger/Acquisition team on Hadoop, Cassandra and Spark
• Worked in developing SSRS 2016 reports with Impala, Hive in Hadoop platform
• Utilized SSIS to ease data ingestion process with Hadoop
• Worked in BigData ETL using Sqoop and received training in MapReduce
• Built dashboard using PowerBI & Tableau with Celenova data on Sales.
• Implemented data mining solutions in both PowerBI & Tableau using bins, distributions, A-B test, & validating them with Chi-Squared test

Confidential

BI Architect/Developer/Analyst

• Mentored & guided multiple team members in variety of discipline
• Worked in PowerBI project in Marketing Data
• Automated Excel data file refresh using WebTrend’s REST api and utilized VBS script

Confidential

BI Architect/Developer/Analyst

• Mentored & guided multiple team members in variety of discipline
• Managed datawarehouse for a billion-dollar company with 20+ car dealerships. Worked in SQL 2012, 2014, 2016 environment and migrated data to SQL 2016.
• Built POC projects to compare Informatica, DataStage, Pentaho, & SSIS for Data Warehouse
• Built SSIS projects for Datawarehouse, wrote stored procedure, functions etc
• Built POC Data mining project utilizing Vehicle & Sales data warehouse
• Deployed dashboard using SSRS 2014 & 2016, PowerBI & Tableau.
• Worked on PowerBI, DAX. Created dashboard displaying vehicle sales related metrics.
• Worked with Sys Admin to create POC project in Hadoop
• Used ODBC to communicate with Hadoop+Impala via PowerBI dashboard
• Built internal library for DataScience effort. Worked on collecting data to discover maintenance schedule for cars. Used R language, Python, Scala for Logistics Regression analysis and participated in Science Museum’s Data Science challenge with colleagues

Confidential

Business Intelligence Consultant

• Mentored & guided multiple team members in variety of discipline at client sites
• Delivered solutions in SSAS, SSIS, SSRS
• Worked in PowerBI, & PowerMap project for MinCo to show worldwide sales metrics. Also explored custom mapping capabilities of PowerMap.
• Worked on Multidimensional solution in Confidential, & tabular solution & DAX in MinCo.
• Built proof-of-concept solution in pyramid analytics for client
• Worked in Chi-Squared, Adjusted-R squared projects on marketing data for educational services. Analyzed data in GRETL, built & trained data in logistic regression. Implemented visualization dashboard in Tableau.
• Worked on projects involving MDS, DQS and ETL, also tuned queries, mentored junior resources both internal and at client sites
• Worked with environments which included SQL 2014 / 2012 / 2008 R 2/ 2005 / 2000 / 7.0 / 6.5, SSIS, SSAS, SSRS, DBPro, .Net, C#

Confidential

Business Intelligence /SQL/ETL Consultant

• Worked with MS CRM’s ETL tool scribe insight and directed contractors to build supporting packages
• Mentored & guided multiple team members in variety of discipline at client sites
• Used that tool to convert data from legacy database and migrate them into CRM’s database in SQL Server 2008
• Used SSIS for various data cleanup tasks
• Tuned sql queries as needed for ssis packages
• Tested various POC in SQL 2012 and 2014. Built internal reports for MSCRM using MS SSRS 2008

Confidential

Business Intelligence Developer

• Created POC on SSAS tabular & Multi-dimensional mode
• Demonstrated cons & pros of MDX & DAX
• Put together Data Warehouse proposal
• Mentored & guided multiple team members in variety of discipline at client sites
• Designed and developed SSIS packages to migrate data from NetEzza to SQL Server 2008 R2
• Created source-destination mapping documentation for projects
• Wrote stored procedures, functions, CTEs, advanced queries in TSQL
• Tuned queries for client
• Designed and developed reports in SSRS
• Wrote a wrapper app in C# to help clients in Citrix gain access to SSRS report server
• Helped develop POC reports in MicroStrategy, Alterian, and Tableau

Confidential

Sr. Business Intelligence Consultant

Responsibilities:

• Worked on data-warehouse for Kidney, Cancer, and Women's Health product team
• Utilized SQL Server 2008 R2, and SSIS to integrate data from Oracle, Sybase, SaaS ERP, Access, CSV flatfiles
• Participated in the data model design that followed Ralph Kimball methodology to build star schema containing fact, dimension tables
• Guided our BI architect on overall structure of the data model from various sources and helped build data dictionary or source-destination mapping
• Collaborated with internal team that implemented the front-end of the dashboard in BusinessObjects
• Supported Qcare team's SSIS solution and turned around production issue during critical time
• Tuned sql queries using execution plan in both Oracle and SQL Server, indexing, perfmon counters
• Participated in code review, documentation of technical specification, metrics pseudocode and support procedures, and unit testing of various logical components

Confidential

Business Intelligence

• Worked with the HR IT Team’s Payroll data in PeopleSoft ERP, Security's Badge data in IBM DB2, and EDI processes to build SSIS packages
• Mentored & guided multiple team members in variety of discipline at client sites
• Worked on SSRS reports, perl scripts, Sikuli, and reviewed java codes, as the SSIS packages supported operations involving CyberShift which is the internal portal for Confidential employees across the US and the world to manage their vacation time

Confidential

Business Intelligence Consultant

Responsibilities:

• Standardized reporting environment
• Utilized both out-of-the-box subscription scheduling and dynamic data driven subscription scheduling for reports
• Mentored & guided multiple team members in variety of discipline at client sites
• Helped complete the business case for the data-warehouse and chose the front end tools for it. Built POC SSAS solution for the project
• Negotiated with managed services and helped promote the project to executives
• Wrote complex stored procedures, functions, and pivot tables for reports
• Tuned sql queries using execution plan, indexing, perfmon counters
• Participated in code review, data model design, documentation of technical specification and support procedures, unit testing of various logical components

Confidential

Business Intelligence Consultant

Responsibilities:

• Worked in SQL Server 2005 environment to develop SSIS packages
• Delivered data-warehouse utilizing Ralph Kimball's design methodology
• Started the design with a star schema which later turned into a snowflake
• Utilized excel data mining add-on to complement the SSAS solution's cube
• Wrote stored procedures, functions
• Tuned sql queries using execution plan, indexing, perfmon counters
• Participated in code review, data model design, documentation of technical specification and support procedures, unit testing of various logical components

Confidential

Lead Database Developer and .Net Software Engineer

• Led database development on .Net application side
• Created database solution in DBPro
• Performed migration from oracle database to MS SQL Server
• Wroted SSIS packages to import Oracle data to SQL Server
• Implemented creative solutions for blob data from Oracle to SQL
• Extensive development in TSQL and C# .Net 2.0, 3.0
• Worked in Agile development environment
• Wrote tools in C# for QA team, and Content team
• Went through training on Windows Presentation Foundation and SOA
• Worked on pilot program to evaluate Element-K resources so that it becomes part of internal online university to train employees
• Worked within enviorment of .Net, C#, SQL 2005

Confidential

.Net Consultant

Responsibilities:

• Worked in a diverse development environment to rewrite existing application called MAX to .Net. Also acted as the Build Master
• Worked with both U.S. team and overseas team in Malaysia to co-ordinate development activities
• Reviewed diagrams in ErWin to get understanding of data model
• Wrote application in C# to deploy both assembly and data related artifacts
• Worked with DBPro to maintain SQL Database artifacts
• Wrote POC for SSIS and SSRS
• Developed installer, bootstrapper packages, and automated the process using Visual Build Pro
• Converted old data to new XML representation utilizing new XML, XSLT api, reporting against specific customer site utilizing generic collection