SUMMARY

• Experience in MongoDB large scale database systems.
• Experience in designing MongoDB multi - sharded cluster and monitoring with Ops Manager.
• Experience in designing MongoDB replica sets and multi-sharded cluster.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Designed and developed load balancing Mongo applications.
• Highly qualified with over 8 years of experience worked on, as a MongoDB DBA/Developer and MS SQL/BI consultant in implementing end-to-end Business solutions using the NoSQL (MongoDB) and Microsoft BI Stack (SSIS, SSRS, SSAS, Power Bi) with in several industries
• Good experience on advanced queries, query conditionals and aggregation framework.
• Good experience on MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets.
• SSL encryption, Analysis of data usage for proper index creation and data modeling.
• Experience migrating from Microsoft SQL to MongoDB
• Involved in gathering business requirements from clients through Joint Requirement Development sessions for functional and non-functional requirements.
• Experience in deploying, managing and developing with MongoDB clusters.
• Familiar with MongoDB clusters, performance tuning, backup and recovery.
• Participate in scalability testing to ensure Mongo dB high performance
• Experience in Mongo utilities (mongo stat, mongo top, mongoperf, mongo dump and mongo restore).
• Manage run-time configuration, processes, scaling, backup and recovery, monitoring, and performance tuning for production MongoDB instances.
• Implementation of MongoDB security mechanism with various Authentications.
• Experience on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Experience in creating and debugging large T-SQL database scripts and batches to facilitate effective database management.
• Experience in T-SQL programming in creating stored procedures, triggers, views and user defined functions on SQL 2005/2008/2008 R2, 2012 and 2014 Servers.
• Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.
• Hands on experience in aviation operation, customer relation, weight and balance and airport operations.
• Developed Power BI model used for financial reporting.
• Experience in writing complex DAX functions in Power BI.
• Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures, Views and SQL queries to pull data into power BI model.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Designed and created data extracts, supporting SSRS, POWER BI or other visualization tools reporting applications.
• Created Datasets in T-SQL, stored procedures for SSRS.
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat f iles .
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split .
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task .
• Debugging SSIS packages, Performance tuning on slowly running SSIS Packages.
• Created Reports using Charts, Gauges, Tables and matrix .
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down,Drill Through Report by Region

SKILLS:

Database Tools: Management Studio, MS Visio

RDBMS: MS SQL 2008/2008R2/2012/2014, NoSQL (MongoDB), MySQL

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS, Power Bi

Programming Languages: JavaScript, MSQL

Operating Systems: Windows Server 2003/2008/R2, 7/8

PROFESSIONAL EXPERIENCE:

Confidential

MongoDB Database (DBA)

Responsibilities:

• Creating and monitoring database objects like Indexes, Views, Users, and DB Links.
• Performing CRUD operations like Read, Update, Insert and Delete records in MongoDB.
• Working on MongoDB database concepts such as locking, indexes, Sharding, replication, schema design, etc.
• Working on creating various types of indexes on different collections to boost performance in Mongo database.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Migrating Mongo database systems from No-SSL authentication to SSL authentication using certificates.
• Migrating Mongo database from MMAPV1 storage engine to Wired Tiger storage engine.
• Managing Mongo databases using MMS monitoring tool.
• Performing ad-hoc backups using Mongodump and Mongorestore.
• Implementing write concern and read preferences in MongoDB replica set.
• Configuring delayed secondaries to avoid data loss due to human errors.
• Experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Troubleshooting server and database issues and bugs
• Experience in writing complex DAX functions in Power BI.
• Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure,
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures, Views and SQL queries to pull data into power BI model.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Designed and created data extracts, supporting SSRS, POWER BI or other visualization tools reporting applications.
• Created Datasets in T-SQL, stored procedures for SSRS.
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat f iles .
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split .
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task .
• Debugging SSIS packages, Performance tuning on slowly running SSIS Packages.
• Created Reports using Charts, Gauges, Tables and matrix .
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region

Environment: MongoDB, MMS, Linux/Unix, LVM Snapshots, Backup, Sharding, Replication, JavaScript

Confidential

SQL / BI Developer

Responsibilities:

• Creating and optimizing objects such as: Stored Procedures, Triggers, User define functions, Indexes and Views.
• Developing ETL solutions to support key business data flows
• Deploying, securing and automating SSIS packages.
• Verifying accuracy and consistency of data and supporting the Data base.
• Designing ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Developing SSIS packages to transform and load data from various sources.
• Implementing data security and integrity strategies.
• Developing cubes with dimension and fact table to facilitate speedy aggregation and delivery of data.
• Hands-on experience in managing Reporting Server and creating ad-hoc reports from OLTP and OLAP including its delivery using push and pull delivery methods.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Create caching report, snapshot to reduce the burden of report server. Along with creating snapshot, both standard subscription and data-driven subscription.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.

Environment: MS SQL Server 2008R2/08,2012, T-SQL, MS VISIO, Windows 2003/2008, SSIS, SSRS, SSAS

Confidential

Database/Bi Developer

Responsibilities:

• Loading data to the interface tables from multiple data sources using OLEDB, ODBC, ADO.NET connections.
• Developing T-SQL stored procedures, functions and views to implement the business logic for front end applications, reports as well as ETL processes.
• Writing TSQL code and complex stored procedures for different tasks.
• MS SQL Server installation, configuration.
• Designed SSIS Packages to transfer data between servers.
• Optimizing the performance of slow executing SSIS packages.
• Designing and developing SSIS Package templates for speedy future development.
• Creating Quality Assurance scripts to assure data integrity.
• Developing OLAP cubes for speedy aggregation and delivery of data.
• Importing or exporting data from heterogeneous sources like SQL Server, Excel, CSV and archive data files
• Designing SQL SSIS Packages in Business Intelligence Development

Environment: MS SQL Server 2008R2/08, T-SQL, BIDS, SSIS, SSAS, SSRS, Access, Excel, SQL Agent, Profiler, TFS

Confidential

SQL BI Developer

Responsibilities:

• Developing and creating logical and physical database architecture.
• Creating stored procedures, Functions, triggers for reporting, ETL and data consistency checks.
• Enhancing and deploying SSIS Packages from development server to production server.
• Monitoring, tuning indexes to increase query performance,
• Examining and evaluating data structures to fill gap between source and destination databases.
• Developing complex SSIS packages to extract, transform and load data from heterogeneous sources
• Optimizing the performance of slow executing SSIS packages.
• Designing and developing SSIS Package templates for speedy future development.
• Creating Quality Assurance scripts to assure data integrity.
• Developing OLAP cubes for speedy aggregation and delivery of data.
• Developing complex reports, ad-hoc reports, dashboards and KPIs.
• Generating different scheduled reports delivery to e-mails, shared directories and subscriptions;

Environment: MS SQL Server 2008 R2, SSIS, SSAS, SSRS, Excel, Windows server, Power Pivot