Seeking a position in an organization which allows building of technical skills with a
Challenging role and continuous professional growth
Oracle, MS SQL Server, My SQL, DB2, PostgreSQL,MS Access
C++ ,Java , Shell Scripting , PL/SQL
Software and Tools
MicroStrategy, Informatica, Eclipse , Data Mining -Weka
Windows 7/Vista/XP/2000/9x, Linux
Data & Business Intelligence Engineer06/2013 to CurrentEharmony.com Inc
3+ years of hands-on experience in BI and Data warehousing projects Experience in areas of R-OLAP, M-OLAP, star/snow-flake schema design, report generation, UI design, creation and maintenance of Data Marts/Data warehouses 3+ years of hands-on experience in various database technologies including Oracle, SQL Server , PostgreSQL and DB2 Experienced MicroStrategy developer with expertise in MicroStrategy Desktop, MicroStrategy Web, Dashboards Certified Oracle PL/SQL Developer Associate Good hands on data mining algorithms.
Classification algorithms like C4.5, Naive Bayesian classifier, Clustering algorithms like K-means, K-meloids, DBSCAN Excellent understanding of ETL techniques and tools Experience in Java Enterprise Edition (Java EE), Java Server Pages (JSP) and Java database Connectivity (JDBC) technologies.
Excellent, analytical and communication skills Well acquainted with all stages of SDLC.
Data Analyst08/2012 to 06/2013Solarbridge Technologies
Working closely with product team to understand business and responsible for modeling data and designing data warehouse.
Responsible for creation, interpretation and management of large datasets to achieve business goals.
Identify and solve issues concerning data management to improve data quality.
Responsible for data updates, indexing, and maintenance in production database Responsible for developing end to end JAVA application for database migration from PostgreSQL to MySQL Responsible for developing UNIX shell scripts to automate production database scripts.
BI and Database Developer01/2008 to 01/2011
Designed and implemented data warehouse and dashboard based solution for the Toll Systems In capacity of a team leader, handled a team of two developers to implement end to end solution for the Toll Systems using dashboards and data warehousing technologies Analyzed various key performance indicators for Toll System such as generated revenue, budgeted amount, forecasted amount and net profit Designed and developed various dashboards to display key performance indicators Designed, developed and deployed the desktop and web based reports using BI and Data warehousing tool MicroStrategy Created and managed oracle application table spaces, tables, views, indexes, schemas, synonyms required for the project Handled deployment and administration of the application in production environments Optimized performance of dashboards by developing summarized oracle database views Analyzed, documented, and transformed user requirements to the technical team Designed and developed database and dashboard based solution for leading retail manufacturer in USA Participated in data warehouse design to provide solutions to various business needs In capacity of a senior database developer designed and developed the PL/SQL stored procedures, functions and packages Worked with the ETL team and managed the user acceptance testing to ensure to data quality Built object prompts like metric prompts and attribute prompts Created facts and metrics using pass through functions like ApplySimple Created transformations for time cycle reports that is fiscal year or month Designed the database and dashboard based solution for leading home construction materials supplier company in USA Created analytical report containing order KPI/analytics, status tracking, ageing analysis, and ranking Top 10 customers Built metrics like conditional and level metrics using MicroStrategy desktop Designed and developed the static SQL, dynamic SQL, PL/SQL stored procedures, functions, packages to extract, transform and migrate data from various data sources to staging database with exception handling Created reports, prompts, provided hyperlinks for drilling/navigation Interacted with End users for creating Customized reports.
Masters: Computer Science2013Texas State UniversitySan MarcosComputer Science
Bachelor of Engineering: Computer Science2008IndiaComputer Science
Oracle 9i PL/SQL Developer Certified Associate
*Won Graduate Academic Excellence Award , Texas State University San Marcos
*Won competitive scholarship for government college of engineering
*Presented technical paper in paper presentation competition in India