SUMMARY:

• Having 8+ Years of Experience in IT, with 7+ years as Database Developer & Administrator and 2+ years as Systems/ Network Administrator. Well versed and Experienced in Microsoft SQL Server 2008R2/2012, SSIS/SSRS/SSAS for both OLTP and OLAP (Data warehousing) environments, Business Intelligence(BI) Project Development, Implementation and Administration from end to end by usingMicroStrategy9.x / 8.x Product Suites includingMicroStrategyDesktop, Web, Architect, Administrator, Intelligence Server. Network installation & Security and Computer Hardware Configurations respectively.
• Experience in designing Database Models using MS Visio and ER - Win for both Relational and dimensional modeling.
• Good knowledge of Data warehousing, Bottom-Up and Top-Down Design methodologies, Operational Data Store (ODS), OLAP, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using Analysis Services.
• Strong experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints, Indexes and Batch Scripts using various DDL and DML commands.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Involved in huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Dev/QA/UAT/Prod environments.
• Prepare RCA (Root Cause Analysis) using Profiler Trace, Performance counters with System Monitor.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Fine Tuning of the MicroStrategy reports using Data Mart Reports, Aggregate Tables and Intelligent.
• Experience in developing Test Strategy, Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements and Requirement Traceability Matrix (RTM) documents, and developing Test Scenarios to support quality deliverables.
• Expert in Object Migrations using object Manager from MicroStrategy toolbox.
• Expertise in Developing Reports by using Freeform SQL Queries and Logical Views in MicroStrategy Desktop.
• Proficient in using RDBMS Such as Oracle, SQL Server DB2 and Teradata.
• Involved in Upgrading MicroStrategy to various version of 9.x
• Good Exposure, Some Hands on Experience working with URL APIs and good knowledge on SDK.
• Extensively used LINQ and Entity Framework to exchange data between web applications and database objects.
• Hands on experience in developing and modifying User Interfaces using Bootstrap 3.2, AngularJS, ASP.NET, AJAX, JQuery, XML, HTML5/DHTML, CSS, JavaScript, and LINQ.
• Experience in maintaining Servers, workstations and computer labs including software and hardware. VMWARE and Putty.
• Involved in maintaining and updating inventory of devices and supporting all network hardware & software of systems.
• Experience in installations and maintenance of Operating system & software and their renewals including their performance troubleshooting by contacting support teams.
• Excellent knowledge in working with SQL Assistant, Teradata Manager & Admin tools and also used Teradata M-Load utility with Informatica to load terabytes of data. Good working knowledge of application development and analysis.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Excellent analytical/communication skills, Team Play and very much result Oriented.

TECHNICAL SKILLS:

Microsoft Technologies: SQL Server 2008R2/2012, SSIS/SSRS/SSAS for both OLTP and OLAP (Data warehousing), C#.NET, ADO.NET, ASP.NET

Programming Languages: C, C++, C#, SQL, PL/SQL, XML

Database: SQL Server 2005/2008, MS-Access, MySQL, T-SQL, PL/SQL

Application Tools: Visual Studio 2008/2010, Visual Source Safe 2005, SQL Query Browser/ Management Studio, Subversion (SVN).

Operating Systems: Windows 95/98/NT/2000/XP, Windows 2000/2003/2008 Server, MS-DOS

Design Tools: UML (Rational Rose), MS Visio

Application Servers: IIS 5.0/4.0

WORK EXPERIENCE:

Confidential, Fairfax, VA

Programmer Analyst

Responsibilities:

• Responsible for General Database Administration, Query Performance tuning, and validated some of the existing schemas of the HIPAA and HRMS projects.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Loaded the data from multiple systems to the Reporting Data warehouse database.
• Creating logins and assigning roles with least privileges.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration.
• Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
• Automated various DBA tasks and created alert mechanisms for CPU, Memory utilization, SQL errors and backup failures using Power shell.
• Recommend possible remedies for better performance.
• Installed and configured SQL Server 2008, 2008 R2, 2012 and 2014 Enterprise Edition Environment.
• Upgraded SQL Server from SQL 2008 to SQL 2012 and SQL 2014.
• Work in cooperation with developers/team for achievement of efficient database access for applications. This includes activities like designing, adding, eliminating or maintaining indexes, organizing tables, recommending SQL changes to application development teams.
• Transformed data from various data sources like MS Access, MS Excel, and Oracle using OLE DB connection by creating various DTS packages.
• Deployed the Packages and Scheduled them using SQL Server Agent Job.
• Monitor strategies, processes, and procedures to ensure data integrity.
• Prepare RCA (Root Cause Analysis) using Profiler Trace, Performance counters with System Monitor. Reporting and resolving serious SQL Server alerts.
• Verifying all instances are up and error log files for any new entries.
• Filter and Sorting Data using Power View in Excel 2013. Developed Power Maps using Excel 2013 for Reporting.
• Worked on DTS Package, DTS Import/Export for transferring data between Database (Oracle and Text format data) to SQL Server.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects, which requires frequent interaction with the Business Users.
• Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategyDesktop using the Configuration Wizard.
• Generated and implementedMicroStrategyReports by creating Schema and Public Object like attributes facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Used Administrator tools like Project Merge and Object Manager to move the objects from one environment to another environment.
• Experience in working withMicroStrategyIntelligence Server,MicroStrategyWeb andMicroStrategy Administrator reporting basic usingMicroStrategyDesktop andMicroStrategyWeb.
• Creation of Logical Views, reports like Canned, Ad-hoc, Free Form and transaction along with Dynamic Dashboards and Mobile Dashboards.

Environment: MSSQL Server 2012/2008, Visual Studio 2010/2008, Reporting Services (SSRS 2008), MicroStrategy9.2.1 (Administrator, Architect, Desktop, Web, Object Manager, Integrity Manager), .NET 4.0/3.5, Business Intelligence Development Studio (BIDS), MS Office 2007, Office 365, PowerPivot, UNIX, MS Access, OLTP and OLAP (Data warehousing), SVN Tortoise, ETL, MS Excel, Oracle SQL developer.

Confidential, Silver Spring, MD

Data warehouse Developer

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Converted complex Oracle PL/SQL packages, functions, procedures to SQL Server 2012(T-SQL).
• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Identified various data sources, formulated data dictionaries, designed and developed data models (physical/logical data models) based on the given specs and requirements.
• Created Tables, Views, Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on different database objects to obtain the required results.
• Create and maintain SQL Server queries, views, stored procedures, and SSIS packages which extend and support the SharePoint Global Support web application.
• Deployed the Packages and Scheduled them using SQL Server Agent Job.
• Experience in using SQL Profiler, Index Tuning Wizard and Performance Monitor to monitor SQL Server for dead locks and long running queries.
• Monitor strategies, processes, and procedures to ensure data integrity
• Filter and Sorting Data using Power View in Excel 2013. Developed Power Maps using Excel 2013 for Reporting.
• Worked closely with Project lead, architect and technical lead to estimate, understand the task and deliver the solution in a timely manner.
• Created Different Graphs and Charts for analyzing related Information using PowerBI Features. (PowerQuery, PowerPivot and PowerView).
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Generating scheduled report for business analysis or management decision using SQL server SSRS.
• Extensively used SSRS features such as Sorting, Interactive Sort, Groups, Filters and cascading parameters.
• Involved in gathering business requirements and documenting specifications and also experience in Analysis, Design, Development, Testing, Documentation and Implementation of the project.
• Experience in writing the Functional & Technical Design documents. Responsible for complete Functional
• Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects, which requires frequent interaction with the Business Users.
• Used Administrator tools like Project Merge and Object Manager to move the objects from one environment to another environment.
• Experience in designing, developing, and customizing several web pages using HTML5, DHTML, CSS3, AngularJS, Java Script and ASP.NET 4.5.
• Using SQL Server 2012 database as back-end along with ADO.NET, Entity Framework and Linq to Entities to access the database tables.
• Extensively worked with Micro Strategy Desktop. Experienced in building Filters, Consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
• Worked on Edit Links on summary reports, attributes and metrics to drill down to Detail report "passing Prompts Dynamically" and "Answer with the same prompt from the Source".
• Worked on SDK in modifying and over writing existing plugins and also adding extra plugins on requirement.
• Worked closely with SDK Development team in finding issue on CSS files and suggested code modification required.
• Involved in different administration tasks such as creating users, security roles and assigning different access rights to the users.
• Responsible for various Performance tasks like Tuning, Caching, assigning Query, Governing Settings, and report Optimization.

Environment: MSSQL Server 2012/2008, Visual Studio 2010/2008, Reporting Services (SSRS 2008), .NET 4.0/3.5, Business Intelligence Development Studio (BIDS), MicroStrategy9.2.1 (Administrator, Architect, Desktop, Web, Object Manager, Integrity Manager), MS Office 2007, Office 365, PowerPivot, UNIX, MS Access, OLTP and OLAP (Data warehousing), SVN Tortoise, ETL, MS Excel, Oracle SQL developer.

Confidential, Silver Spring, MD

ETL/Data warehouse Tester

Responsibilities:

• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Validated Extract/Transform/Load (ETL) processes that load Oracle/DB2 test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users.
• Gathered and documented Use Cases, Business Rules, created and maintained Requirements/Test Traceability Matrices.
• Prepare test strategy, plans and ensure traceability throughout all test phases (functional, integration and system testing) of the software development lifecycle.
• Responsible for the development, establishment, and enforcement of quality assurance measures and testing standards throughout their development/product lifecycles;
• Responsible for Test Status reporting to the project management
• Responsible for Defect Management and conduction review meetings with Business & project stakeholders
• Responsible for daily task allocations to the team members, keeping Time Tracking / Work Management System up to date on a daily basis;
• Study and evaluating Business Requirements, Business Specification Design, Data Architecture & logical data models and then trained test team to improve testing.
• Maintain end to end traceability of requirements to test cases to defects.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Analyze test data to detect significant findings and recommended corrective measures
• Used Agile methodology for repeated testing.
• Forecasting, Analyzed and recommended budget and staffing needs based on research project projections. Coordinated staff assignments.
• Create, maintain, and execute test cases/scripts in HP ALM.
• Planned Test-Cases & Test-Scripts based on the URD.
• Performed Functional Testing (Black box/White Box), Integration, Regression, Systems, Backend, User Acceptance testing
• Created, maintained and updated regression suites upon receiving new build.
• Experience in Testing data conversions and transformations
• Test Case Execution andAdhoctesting
• Utilized HP ALM for directing, tracking and outlining needs during a project SDLC.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader

Environment: Windows XP, UNIX, SQL, PL/SQL, DB2, AQT, TOAD for Oracle, Toad for Data Point, HPALM, Ab Initio, MS Visio.

Confidential, Silver Spring, MD

Data Analyst

Responsibilities:

• Translating functional requirements into detailed Technical Specifications for Data Conversions, Reports, Interface and Customizations.
• Met with Customers to determine User requirements and Business Goals.
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• ConductedJAD sessionsto gather requirements, performedUse Caseandwork flow analysis, outlined business rules, and developed domain object models.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database
• Created a conceptual design based on the interaction with the functional and technical team.
• Analyzed the existing data model and incorporated new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensure proper referential integrity of the system
• Analyzed, created and formatted the Reports as per Business Requirements.
• Analyzed and created various Ad hoc Reports for users based on User Requirements.
• Created both list and drill down reports identifying the data hierarchy
• Performed report validation writing SQL queries using TOAD on an Oracle database.
• Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements
• Analysis of the data identifying source of data and data mappings of BHC.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Createdand maintained specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, flows).
• Worked in collaboration with various areas of the organization, identified additional stakeholder Requirements, and Documented requirements in a Software Requirements Specification document.

Environment: Oracle 10g, SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects.

Confidential, Baton Rouge, LA

Network/Database Administrator

Responsibilities:

• Maintain and administer computer networks and related computing environments including computer hardware, systems software, applications software, and all configurations.
• Installed and Configure SQL 2012. 2014 Active-Active Cluster on Windows 2008 production servers.
• Look after Servers, workstations and the computer labs including software and hardware. Virtual machine (Remote access) to the systems in entire domain. (Shell and Putty)
• Responsible for the installations and maintenance of Operating system & software and their renewals including their performance troubleshooting by contacting support teams
• Perform data backups and disaster recovery operations. Implement Database Mirroring for Disaster Recovery.
• Loaded the data from multiple systems to the Reporting Data warehouse database.
• Diagnose, troubleshoot, and resolve hardware, software, or other network and system problems, and replace defective components when necessary.
• Configuration of Printers, Scanners and Dual monitors.
• Plan, coordinate, and implement network (LAN/WAN) security measures to protect data, software, and hardware.
• Configure, monitor, and maintain email applications or virus protection software.
• Maintaining and updating inventory of all devices that belongs to the department.
• Operate master consoles to monitor the performance of computer systems and networks, and to coordinate computer network access and use.
• Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Maintain the department (Physics & Astronomy) website.
• Create and maintain the accounts for the students and faculty for broadcasting mail and classes registration.
• IT support to the Food science department.
• Diagnose, troubleshoot, and resolve hardware, software, or other network and system problems, and replace defective components when necessary
• Website maintenance and Excel reports with PowerPoint files for their presentations.
• Maintenance of data and Generating scheduled report for their statistical review using SQL server SSRS to business team.
• Maintaining and updating inventory of all devices that belongs to the department.
• Look after the device failures and consultation with corresponding vendor to resolve it.
• Helping in Lab works too.

Environment: MSSQL Server 2008, Visual Studio 2008, Office 365, MS Office 2010, PowerPivot, Linux, MS Access, Putty, Computer hardware & networking, IIS 4.0, ASP.NET, Windows 95/98/NT/2000/XP, Windows 2000/2003/2008 Server, VMWARE, MS-DOS Ubuntu and Mac OS.

Confidential

Informatica Developer

Responsibilities:

• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Defined Target Load Order Plan for loading data into Target Tables.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Used shell scripts for post session operations.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created new mappings and mapplets and also tuned them for better performance.
• Involved in checking and comparing data between Source files and database.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Extensively worked in the performance tuning on Informatica mappings
• Prepared Unit and Integration test cases and tested as per requirements.

Environment: Informatica PowerCenter 7.1, Oracle 9i, UNIX, Flat Files, Toad