SUMMARY

• Over 10 years of IT Industry experience in analysis, design, development, implementation, Test, deployment and documentation of relational and non - relational databases applications.
• Over 10 years of strong data design, data administration and development in SQL Server 7.0/2000, MS SQL Server 2005, 2008, 2012, 2014 and 2016.
• Experience worked on installations, configuration of SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 for standalone and cluster setup.
• Experience in data warehouse (DW) tools like DTS (Data Transformation Services), SSIS Packages, BULK INSERT, and BCP to Extract, Transfer and Populate the Staging Database and populate DW fact tables after cleaning the Staging data.
• Expertise in Transact-SQL (DDL, DML), views, stored procedures and database triggers.
• Extensive knowledge of normalization, relational database management systems and NoSQL.
• Working and hands on experience on SQL Server Business Intelligence BI tool SSRS for reporting and created Report using Data Warehouse (DW), Cube, MSRA and Power BI.
• Good Experience in Writing Test cases, Test Database Application by written query and Stored Procedures. Also created automated test cases to test the database applications.
• Good Experience working in development Cycle to Plan, Design, Develop, Test and Deployment of Database Code and Objects.
• Extensive hands on experience on Hadoop ecosystems (Hadoop HDFS, Hive, HBase, Python, NoSQL) with Hortonwork sandbox.
• Extensive Hand On experience on Installing, Configuring and setting up Hadoop,Python,NoSQL,Cassandara,MongoDB,Drill,Phoenix and Presto in Hortonworks Sandbox.
• Extensive Hands On experience on transferring data in Hadoop between MySQL and HDFS/Hive using Sqoop.
• Extensive Hands On experience on Querying data in Hadoop using Pig,Spark,Drill,Phoenix,Presto and Hive.
• Extensive Hands On experience on Managing Hadoop Cluster using YARN, Tez, Mesos, Zookeeper, Oozie, Zeppelin, Hue.
• Extensive Hands On experience on Feeding data to Hadoop Cluster using Kafka and Flume.
• Extensive Hand On knowledge with unstructured data formats & Hive/HBase/NoSQL Data Modeling experience.
• Hands on experience working and knowledge of Amazon Web Services: Data Services and MS Azure.
• Knowledge on AWS technologies and AWS NoSQL Technologies like DynamoDB and Redshift (SQL workbench), Redshift spectrum, Snowflake Datawarehouse
• Extensive Knowledge AWS data Pipelines using Xplenty for ETL and data visualization using BIME.
• Extensive Knowledge of Amazon RDS Databases using MySQL, Amazon Aurora, MS SQl Server, Oracle and PostgreSQL (9.4.1).

TECHNICAL SKILLS

RDBMS: MS SQL Server 7.0/2000, 2005,2008,2012,2014 MS-ACCESS

Programming: Python,VB 6.0, C#, Java, T-SQL, PL/SQL, XML, OPENXML, PowerShell

Internet Technologies: HTML, DHTML, VBScript, JavaScript, Dreamweaver3/4

Reporting Tools: BI, SSRS, Pivot Table, MS OLAP Services, Power Pivot

Data Warehouse: DTS, Integration Services, BULK INSERT, BCP

Operating Systems: Windows - NT/2012, Windows-XP, Vista, W 7, MS-DOS, UNIX,Linux

Big Data: Hadoop system, R Language, MongoDB and NoSQL

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server Developer

Responsibilities:

• Working in Entity Data Model Platform of MS which will be replacing Siebel Sales System.
• Involves in Development of EDM Database Objects to perform data transfer from Siebel Sales System.
• Involves in Development of EDM database to support future MS Sales data and Archive Sales Data.
• Working on CDR and QoE Database of Lync Server 2010 Usage.
• Worked on SSIS, SSRS and SSAS to develop data warehouse for Lync Server 2010 Data.
• Worked on SSIS to bring data from multiple sources and publish in Datamart.
• Created SSIS packages and jobs to transform and load the CDR and QoE data into Lync Reporting Datamart.
• Created SSRS reports using Report Builder 3 to present Lync usage on demand.
• Responsible to test the insights Xbox live reporting application.
• Writing adhoc SQL Queries and scripts to test Datawarehouse.
• Writing MDX Queries to test Cubes.
• Microsoft Adcenter Ads BI Team.
• Responsible to develop new functionalities and maintenance of Adcenter SQL Database.
• Responsible to develop new functionalities and maintenance of MSFIT SQL Datawarehouse.
• Responsible for mainting and adding new dimension in ETL tool.
• Responsible to create database object like tables and procdures for new added dimension tables.
• Worked on SSIS, SSAS, Cube and report using MSRA,Power Pivot.
• Worked on Power BI regression dashboard for ETL job analysis.
• Worked on Azure Database and on primes Databases.
• Worked on Test Automation using TSQL and C#.

Confidential

SQL Server 2005 Database Developer

Responsibilities:

• Working on Confidential Messaging Team one of the active Projects of Confidential .
• Working on development of messaging of Confidential which supports Mail, Friends request and Notification and more projects.
• Design and created Horizontal partition tables.

Confidential

SQL Server 2005 Database Developer

Responsibilities:

• Worked on OLAP Analysis Service (SSAS), SSIS and SSRS.
• Written stored procedures to create report on Customer and individual Order detail of images and media they download or purchased and also calculate the revenue of Customer using Data warehouse.

Confidential

MS SQL Server 2005 Developer

Responsibilities:

• Written Stored Procedure to evaluate organization, Enrollment, Reference, MCP information, specialization and competency information achieved by Microsoft Vendors Partners.
• Written stored procedure to Enroll Partners in PMC system, evaluate Enrollment, to Evaluate Organization Status, Benefits, Asset and reference Information’s.
• Written on Test Data and Created a lots Of Test Data to Test the New application and Features.

Confidential

MS SQL Server 2005 Developer

Responsibilities:

• Worked mostly on SSAS using Integration DB and Data mart.
• Used SSAS, SSIS and SSRS to developed stored procedure, create packages and reports accordingly.
• Created SSIS packages to Load Data warehouse Integration Database from two MS Source System.
• Writing stored procedure for new report and encapsulate the logic.
• Responsible for all Database Administration work like Restore and Backup the Database.

Confidential, Miami, FL

MS SQL server 2005 Developer

Responsibilities:

• Responsible for extracting the data from SQL server 2000 and Sybase database and transfer into SQL Server 2000 Data warehouse.
• Perform proactive SQL Server database performance and optimization tasks and duties.
• Extracting Data from XML file through OPENXML and put into SQL Server 2000 Tables.
• Create DTS packages to transfer XML Data directly into SQL Server DB.
• Wrote ActiveX script to read XML file dynamically and transfer Data into SQL Server DB.

Confidential

MS SQL SERVER 2000 developer

Responsibilities:

• Responsible for database development and maintenance of the MS SQL SERVER for the testing and development databases.
• Understanding Business data and QICS Data warehouse (OLAP).
• Created view on Dimension table of Fact Table for security purpose and to perform well.
• Targeted performance tuning of SQL Server 2000 database.
• Write various referencing stored procedures to support vb.net application with selection listing for customer to limit data to be displayed in reports.

Confidential, Dayton, OH

MS SQL SERVER 2000 Developer

Responsibilities:

• Designed and developed high level relational data models with data modeling tools.
• Perform proactive SQL Server database performance and optimization tasks and duties.
• Review and analyze customer historical profiler data to track and reveal current and future pain point for the system and client's usage experience.
• Assist performance team in development of SQL Server database tuning methodology and practices.