SUMMARY

• Over 9 years of experience in Design, Analysis, Reporting, Development, Modeling, Implementation and Testing of Decision Support Systems using Big Data Technologies, MS SQL Server/Business Intelligence.
• 2 years of experience in Hortonworks Hadoop Development with MapReduce, HBase, Pig, Hive, Scala, Spark, Flume, Sqoop, Oozie.
• Designing, building, installing, configuring and supporting Hadoop.
• Familiar with MongoDB and Cassandra.
• Experience with Big Data ML toolkits, such as Mahout, SparkML.
• Experience in Kafka + Strom for streaming.
• Expert in SSRS, SSAS and SSIS of MS SQL Server product suit.
• Proficient in configuration, installation and maintenance of SQL Server.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Very good T - SQL Programming skills. Experience in query optimization& performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience in Replication - Snapshot, Merge and Transactional.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server.
• Extensively used Common Table Expressions, Table Variables, Temporary Tables, Views and Split functions in a Store Procedure that populated the SSRS reports.
• Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Highly Proficient in designing MDXin accessing cubes and hands-on experience in query structuring, performance optimization.
• Hands on experience work with MDX queries, KPIs and partitions of cubes in OLAP
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Strong Knowledge of Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Exceptional interpersonal skills, ability to lead from front, with the impeccable problem solving ability, blended with quality to thrive and excel under any given dire situation has been essence of my success.
• Working experience in agile development.

TECHNICAL SKILLS

Programming Languages: C#, VB.Net, ASP.Net, C, C++, JavaScript, VB Script, Java, Python, XML

Microsoft .Net Technologies: .NET, Enterprise Library, Web application, Windows Service, Web services

Microsoft SharePoint Technologies: Microsoft Office SharePoint Server(MOSS) 2007

Databases Technologies: Microsoft SQL server, MS Access, ORACLE 9/8i,Hbase,CRM etc.

Reporting: SQL Server Reporting Services (SSRS), Data Reports, Crystal Reports Active Reports etc.

Analysis: SQL Server Analysis Services (SSAS), Performance Point

Integration: SQL Server Integration Services (SSIS), DTS

Development: Microsoft Visual Studio .NET 05/08

Other: Team Foundation System 2005, Microsoft Visio, ERWIN, Visual Source Safe 6.0/2005, IIS 6.0/7.0, CVS etc

Operating Systems: Windows 2003 Server/ XP/ 2000, Linux, AS400 iSeries

PROFESSIONAL EXPERIENCE

Confidential, FL

Hadoop Developer

Responsibility:

• Hadoop development and implementation.
• Loading from disparate data sets.
• Pre-processing using Hive and Pig.
• Translate complex functional and technical requirements into detailed design.
• Perform analysis of vast data stores and uncover insights.
• Maintain security and data privacy.
• Create scalable and high-performance web services for data tracking.
• High-speed querying.
• Managing and deploying HBase.
• Being a part of a POC effort to help build new Hadoop clusters.
• Test prototypes and oversee handover to operational teams.
• Propose best practices/standards.
• As a Hadoop Consultant/Hadoop Developer focused around the design and the development of a variety of data products.
• Assisting the team in the adoption of new technologies as well as help shape the delivery practices.
• Knowledge and experience of the Hadoop ecosystem such as HDFS, MapReduce, Hive, Impala, Oozie, Hbase
• Experience of Spark, Scala, Sqoop and NoSQL
• Experience of multiple large scale deliveries in agile environments.

Environment: Hadoop 2, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Spark, Oozie, Flume, Kafka, NoSQL.

Confidential

System Analyst

Responsibility:

• Interacted with the business analysts for the database and application issues. Interacted with the business analysts for understanding and gathering business requirements.
• Created various fixed width text files using SSIS 2008.
• Created various packages in SSIS for the designing and crating various reposting Data marts specific to the project requirement from various sources like Oracle, Excel, Access, and SQL.
• Involved in data modeling for the application and created ER diagram using ERWin.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Designed MDX queries to access OLAP cubes. Extensively used OLAP cubes and SSAS to generate reports using SSRS.
• Implemented database standards and naming convention for the database objects.
• Developed SSIS packages to extract, transform and load into the Campaign database from OLTP database.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Worked with Star Schema, Cubes and Analytical services.
• Provided 7 x 24 Production support

Environment: MS SQL Server 2008/2012, SQL Server 2008/2012 Analysis Service, MS SQL Server Integration Services 2008/2012,MS SQL Server Reporting Services 2008/2012, T-SQL, MDX,CRM, SharePoint (MOSS),C#

Confidential, Charlotte, NC

Business Intelligence/SQL Developer

Responsibility:

• Interacted with the business analysts for understanding and gathering business requirements.
• Designed a complex SSIS package for data feeds from data sources like AS400 iSeries, csv or Excel files to SQL Server 2008.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Successfully deployed periodic drop and load process for client data feeds (csv and excel files) using SSIS packages with defined security.
• Proficiently created Reports based on the requirements using SSRS 2008.
• Involved to write complex T-SQL, MDX queries and Stored Procedures for generating reports.
• Designed and developed various Reports, utilizing Dynamic and Cascading Prompts, Client Statement Reports, Fund & Property Reports, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008.
• Created Dashboard reports and deployed on Product using XML.
• Designed and developed validation reporting tools to compare data with legacy systems to current system and making sure that SSIS data transfer performed correctly.
• Responsible to manage data from different systems and gather into staging for loading into system using GL load process.
• Successfully worked with Report Server and configured into SQL Server 2008.
• Deployed C#.Net code for complex calculation in reports using DLL.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard for drop and load process.
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Tuned SQL queries using execution plans for better performance.
• Analyzed reports and fixed bugs in stored procedures.
• Efficiently managed ElementTool tickets/issues and responsible for UAT and Production deployment with fixes.

Environment: MS SQL Server 2008/2012, MS SQL Server 2008/2012 Reporting Service, SSIS, Business Intelligence and Development System 2008/2012, AS400 iSeries, C#.Net, .Net Platform 3.5, XML, MDX, T-SQL, MS Visio, Windows XP, Element Tool

Confidential, CA

Business Intelligent/SQL Developer

Responsibility:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the highly efficient system.
• Designed and developed various Service Management Reports like Account Receivable Invoice, Account Receivable Statement, Receipt, Advance Deposit VAT Summary Report, Trace Report, Police Report, Open Balance Report, and Registration Card, Language Translation reports using SSRS, XML and .Net 3.5.
• Extensively involved into developing Reporting Framework on .Net technologies such as C#, ASP.Net, ADO.Net, .Net Reflection, Web Services, Http Handlers and modules, XML, and VB.Net.
• Designed and developed custom web forms, web interface, .NET components and user controls using ASP.NET and C#.
• Developed complex SSIS packages to integrate data from multiple data sources of Flat files, ORACLE, OLEDB, excel on SQL server for each independent Hotel property.
• Defined SSIS package security and OLAP cube security levels and implemented it.
• Implemented cube KPIs and SSAS reports on dashboard of internal SharePoint portal.
• Worked on KPI lists, Excel Services and Excel Web Access Web parts on SharePoint Server 2007 dashboards.
• Configured Report Server and deployed .rdl reports using SharePoint Native and Integrated Mode. Used SharePoint web parts on SharePoint Native mode.
• Proficiently used T-SQL to write new stored procedures and triggers, views, modified existing ones, and tuned them such that they perform well.
• Extensively used HP Quality Center 9.0 and 9.2 for defect tracking and resolution.
• Modified various existing Reports using Crystal Reports 10.
• Proficiently worked under very dynamic and agile environment.

Environment: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, SSIS, Business Intelligence and Development System 2005, MOSS 2007, ASP.Net, C#.Net, VB.Net 2005, .Net Platform 2.5, XML, VB6, T-SQL, MS Visio, Windows XP, HP Quality Center 9.0/9.2,C#

Confidential, Daman, IN

SQL Server Developer

Responsibility:

• Partly Involved in System study and database designing.
• Install, configure and upgrade MS SQL Server.
• Assisted for Development and design the GUI with ActiveX Controls like MS Flex Grid, List View, Tree View, etc.
• Used MS Visual Source Safe 6.0 as a Version Control System.
• Generated MIS reports using Crystal Reports.
• Coding, Testing, designing the Active X controls.
• Client side implementation and testing.
• Maintain the application as per the users’ requirement.

Environment: MS SQL Server, MS SQL Server Reporting service, MS SSIS, T-SQL, Windows, Outlook Soft