SUMMARY

• Highly qualified with over 7 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 and SSRAS) within several industries. experience in MongoDB large scale database systems.
• Experience in designing MongoDB multi-shaded cluster and monitoring with Ops Manager.
• Extensive experience in designing MongoDB replica sets and multi-shared cluster.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Focused on architecting NoSQL databases like Mongo and Cassandra databases.
• Designed and developed load balancing Mongo applications.
• 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 Oracle SQL and Microsoft SQL to MongoDB
• Participate in scalability testing to ensureMongodbhigh performance
• Experience in Mongo utilities (mongostat, mongotop, mongoperf, mongodump and mongorestore).
• Involved in gathering business requirements from clients through Joint Requirement Development sessions for functional and non-functional requirements.
• Extensive experience in deploying, managing and developing withMongoDBclusters.
• Familiar withMongoDBclusters, performance tuning, backup and recovery.
• Manage run-time configuration, processes, scaling, backup and recovery, monitoring, and performance tuning for productionMongoDBinstances.
• Implementation ofMongoDBsecurity mechanism with various Authentications.
• Well versed with Software Development Life Cycle (SDLC) process and familiar with RUP, Spiral, XP and Agile and Scrum Models.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Hands on experience with Erwin to forward and reverse engineer data models.
• Extensively created and debugged large T-SQL database scripts and batches to facilitate effective database management.
• Highly Proficient in T-SQL programming in creating stored procedures, triggers, views and user defined functions on SQL 2005/2008/2008 R2 and 2012 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.

TECHNICAL SKILLS

Database Tools: Management Studio, ER-Win, MS Visio

RDBMS: MS SQL 2008/2008R2/2012, NoSQL (MongoDB), Oracle 10g, MySQL

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS, SharePoint 2010

Programming Languages: JavaScript, Ruby, node.js, AngularJS

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

PROFESSIONAL EXPERIENCE

MongoDB Database Developer / PostgreSQL (DBA)

Confidential

Responsibilities:

• Created and monitored database objects like Indexes, Views, Users, and DB Links.
• Created Partition's estimated stats on one partition1 and copied the stats to remaining partitions using dbms stats.
• Performed CRUD operations like Update, Insert and Delete data in MongoDB.
• Experience migrating from Oracle SQL and Microsoft SQL to MongoDB
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design, etc.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Worked on creating documents in Mongo database.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Migrated Mongo database systems from No-SSL authentication to SSL authentication using certificates.
• Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.
• Managing Mongo databases using MMS monitoring tool.
• Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongodump and Mongorestore.
• Worked with capped collections to wipe out aged data based on requirements.
• Administered multiple environments (up to25 TB), automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Familiar with MongoDB write concern to avoid loss of data during system failures.
• Implemented read preferences in MongoDB replica set.
• Configured delayed secondaries to avoid human failures in coding and development.
• Strong experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Skilled in troubleshooting with good organizational and interpersonal skills.

Environment: MongoDB, Cassandra, Ruby, MMS, Puppet, Linux/Unix, LVM Snapshots, Backup Scheduler, Data guard, Sharding, Replication, Python, Shell scripting, Perl, JavaScript

SQL / BI Developer

Confidential, Scottsdale, AZ

Responsibilities:

• Created and optimized objects such as: Stored Procedures, Triggers, User define functions, Indexes, Views, and Index views.
• Designed a database optimization plan involving the creation of Table Partitions and the use of appropriate Indexes as recommended by Microsoft’s Index Guidelines.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL 2008 Server target staging database.
• Used master child SSIS packages for better design and ease of maintenance.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Implemented Error Handling during ETL load in SSIS packages to identify dimensions and facts that were not properly populated.
• Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods.
• Monitored all the packages that were scheduled. Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.
• Produced and Documented test summary information and signed-off testing to facilitate implementation in production environment.
• Used SQL 2008 Server Analysis Services to design cubes with dimensions and facts and created different cube objects like KPIs, Drill through Actions, Perspectives, Aggregations, and Translations.
• Created several reports using SSRS like parameterized report, drill through reports, linked and sub reports.
• Created reports with bookmark and document map inside them to navigate the items inside the reports.
• 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, T-SQL, MS VISIO, Windows 2003/2008 Server, SSIS, SSAS, SSRS

Data Architect

Confidential, Phoenix, AZ

Responsibilities:

• Providing On-Call Support for allSQLServer based Applications on rotation basis, comprising 162SQLServer Instances.
• Analyzing and designing and implementing different types of Replication Models.
• Configuring 3rd Party Tools like Quest Foglight and Oracle Client Tools onSQLServers and Working with OracleDBAteam for TNS Issues or any other Oracle Issues for our Linked Servers.
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
• Setting up monitoring alerts and dashboards in addition using ofSQLbuilt-in dashboards. Discussion with peers about performance issues,SQLInternals about log shipping, DB mirroring, replication etc.
• MSSQLServer installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management. Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating aSQLserver Performance Alerts.
• Maintaining and Automating SQL Server like, Configuring Database Mail, creating an Operators, Creating Jobs, Alerts, Database Maintenance plans.
• Took the lead in many occasions to Analyze/Fix Performance Issues of Applications.
• To Lead, mentor and/or provide guidance to less experienced database analysts, where applicable, including guidance for troubleshooting escalated issues.
• DesignedSQLSSIS Packages in Business Intelligence Development
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
• Monitoring and optimizing the performance of the Queries and Indexes usingSQLServer Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views

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

SQL BI Developer

Confidential

Responsibilities:

• Gathered business requirements as endeavor that will facilitate the planning and the implementation phase of a data warehouse for reporting.
• Conducted JAD sessions with different Auditors, Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS and FRS.
• Developed and created logical and physical database architecture using Erwin.
• Created stored procedure for auditing purposes as well as triggers for data consistency checks.
• Dramatically increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
• Examined and evaluated the data structures in the source and destination databases / staging Tables.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle into the SQL 2008R2/2012 Server target staging database.
• Developed complex ETL Packages using SQL Server 2008R2/12 Integration Services to load data from various sources like Oracle/SQL Server/DB2 to Staging Database and then to Data Warehouse.
• Used various transformations such as Derived Column, conditional split, fuzzy grouping, lookup etc.
• Identifies and implemented slowly changing dimension to maintain current information and history information in dimension tables.
• Used best practices for SSIS design such as Master Child architecture to leverage parallel execution of various packages.
• Managed SSIS Package Configurations in XML as well as SQL Server Formats when deploying to production.
• Created SSISDB catalog with SQL 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.
• Designed and developed SSIS Package template, so similar development practices are followed by all SSIS developers for logging, configurations and error handling.
• Created QA (Quality Assurance) scripts and sanity checks to further test ETL packages by comparing QA output with output from ETL package.
• Created various complex cubes with usage based aggregations and set-count aggregations and used appropriate storage modes like MOLAP, HOLAP and ROLAP depending upon how important the data is and how frequently it needs to be fetched from the DW.
• Implemented Key Performance Indicator Objects, Actions, Hierarchies and Attribute Relationships for added functionality and better performance of SSAS Warehouse.
• Developed complex reports like Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks.
• Extended reports as well as invoked embedded functions and integrated assemblies using expressions.
• Created canned and ad-hoc Reports using SQL 2012 Server Reporting Services and Excel services.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting using Excel Power Pivot.
• Generated different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Established connections to report server to browse the saved reports on SharePoint Integrated Mode.
• Designed strategies for securing the reports created depending upon the level of sensitivity of information that the report contained and for improving and further leveraging these reports in order to transfer / convert existing reports to SQL Server Reporting Service.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.

Environment: MS SQL Server 2008 R2/2012, SSIS, SSAS, SSRS, Erwin, Excel, Windows server, SharePoint 2010, Power Pivot, TFS

DBA / SQL Developer

Confidential, Ethiopia

Responsibilities:

• Troubleshoot and diagnose customer issues, documenting recreation steps.
• Trouble shooting issues related to SQL, SSIS and SSRS.
• Managing customer issues in On Time, customer issue status communications.
• Designed and developed various reports such as Tabular, Matrix, Drill-down, Drill Through, and Parameterized Reports using SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Designed and developed monthly, quarterly and yearly reports at branch and company level.
• Created SSIS Package for uploads and schedule them as SQL Server Agent. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Handled Initial and Delta loads and also used Error Handling, Logging and Checkpoints and made use of Configuration files.
• Used SSIS transformations for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.
• Created/Updated Stored Procedures and User Defined Functions with extensive use of T-SQL.
• Responsible for creating database objects (table, views, store procedure, triggers etc.) to provide structure to store data and to maintain database efficiently.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Responsible for creating the tables, views, stored procedures.
• Involved in designing conceptual, logical and physical model of the relational databases (OLTP and OLAP)
• Supported the existing BI platform for populating data warehouses.
• Designed complex stored procedures to perform data profiling in the pre-staging database.
• Analyzed different heterogeneous sources like Excel, Oracle, Flat Files, and SQL Server 2005 for ETL strategy that needs to be implemented with the help of SSIS packages.
• Created staging database to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Implemented Data conversion and data migration techniques at necessary times through the project life cycle.
• Implemented Master/Child Package Models to ensure that only the Master Package is scheduled which will in turn fire the other packages.
• Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented.
• Written test scripts in T-SQL to validate data on staging tables and data warehouse tables to validate the data results.
• Pre-Calculated the Aggregation Objects based on required performance gains so that reports can be generated within a window of time as described in the business requirement document
• Participated in the monitoring of the SQL server performance using tools like SQL profiler, database engine tuning advisor and command line tools.
• Generated test data and tested the database to meet the functionalities deliverables in the project documentation and specifications.
• Built SSRS project to generate reports with desired formats (Word, PDF, Excel, etc.) to present statistics information according to business requirements.
• Generated various reporting services RDLs using reporting services for Account Aggregation reports.
• Created Ad-hoc Reports using Report Builder and Report Models using Business Intelligence Development Studio to provide a template for end-users to create reports by themselves with a preselected group of relational tables.
• Supported the logging framework by generating reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server.

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