SUMMARY:

• Over 11+ years of experience in SQL Server 2000/2005/2008/2008 R2/2012, DTS/SSIS/SQL Server Data tools, SQL Reporting SSRS, SQL Server Analysis Services(SSAS), SQL BI Development, T - SQL, (Windows SharePoint Server 3.0 (WSS), SharePoint Designer 2003/2007, SharePoint Administration, Design Architecture, Prototype, Dimension Modeling
• Good hands on experience in Self Service Business intelligence tools like Tableau, QlikView, Yellowfin BI, awareness to web intelligence tools like Business Objects.
• Experience in writing PL/SQL Stored Procedures, tables, views, and Triggers to populate the base tables on daily basis and implementing business rules and transformations.
• Have very good knowledge of Database Replication like Transactional, Snapshot and Merge Replications, Log Shipping and their usage.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Good experience in building Logical and Physical Data modeling using Erwin, ER Studio
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Strong analytical skills able to understand complex business problems and convert them into functional components
• Good Knowledge of SharePoint Administration, Configuration like HTTP and FTP, and Windows Web Services.
• Knowledge of installing and configuring Reporting Server on 32/64 Bit server, Integration Service, and Databases Services in standalone and Shared Environment .
• Good in SQL Server configuration for High Availability, design and maintain backup strategies.
• Hands on experience with Microsoft BI Tools, Microsoft PowerPoint Server.
• Hands on experience in building Enterprise Datawarehouse (EDW) using Kimball and Bill Inmon Approach
• Excellent hand on experience with DML, DDL and DCL T-SQL commands
• Extensively used Visual Basic as a front-end tool with SQL/Server, Oracle and MS Access as back-end databases under Window 00/NT/95/98 environments.
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings, and session
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Expertise in extracting data from various data sources like flat files, Excel files, MS Access, SQL Server, and Oracle, DB2, My SQL.
• Excellent team player with strong written, communication, interpersonal, analytical skills, capable of working under high stress environment with resource constraints.
• Ability to adapt to changes in information technology and quickly learn and utilize new database tools and methodologies.
• Involved in Develop the test cases for each & every component that exists in the solution.
• Ability to manage multiple projects and tasks simultaneously with little or no guidance.
• Have strong abilities in understanding and implementing ETL and ELT concepts varying in open source ELT and Licensed ETL tools

TECHNICAL SKILLS:

Environment: s: Windows XP/NT/ 00 / 98 / 95, IBM-AIX 4.0/3.1, AS/400, MSDOS6.22, UNIX

ETL Tools: DTS/ BIDS / Datatools (SSIS), Informatica power center 7.1/6.2 (Designer, Server Manager, Workflow Manager, Workflow Monitor, Repository Manager), Power Analyzer, Talend, Pentaho Desktop Integrator

RDBMS: SQL Server 2000/2005/2008/2012/2014/2016, Oracle 9i/8i/8.0/7.0, MS SQL 7.0, MS Access 2005/2003/2000, My SQL Server.

Data Modeling: Erwin 4.0/3.5.2/3. x, ER Studio Dimensional Data Modeling, SQL Server Database Models

Database Monitoring: SQL Server Profiler, SQL Diagnostic Manager, WinStat (For disk usage on server)

Languages: SQL, PL/SQL, C, C++, ASP (Basic), VBScript (Basic), UNIX Shell Script (Basic)

OLAP Tools: Business Objects, Cognos, Analysis Services, SSAS, Reporting Services SSRS, Crystal Reports 9, Tableau Desktop 9.0, Qlik View, Yellowfin BI

Database: SQL Server 2000/2005/2008/2012/2014/2016, Oracle 9i, DB2, MySQL Lite

Desktop Programs: SharePoint Designer, VB Script

Others: UML, SQL*Loader, iSQL*Plus, Toad, Clear case, Microsoft PowerPoint Server (Basic), MDX

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Database Analyst

Responsibilities:

• Responsible to prep environment for one time data load and setup from application across.
• Help team members with query tuning, query writing.
• Work with business users and make changes to database, build KPI, support adhoc data requests.
• Data migration, environment setup and management, DBA activities.

Environment: Sun Java, SQL Server (Azure), SSIS.

Confidential, McLean, VA

Data Analyst

Responsibilities:

• Work with business users, requirements gathering, and design.
• Use tableau for building Workbook, extract data and publish to Server, and validate data for workbooks published on Server.
• Work on ETL logics to load feed from heterogeneous system, data cleansing, and data governance.
• Work on performance tuning of SQL queries for data extract in Tableau Server and Performance tuning of Tables.
• Written script to load unstructured Excel files received from Suppliers, and Vendors and load them into SQL Server Table for Analysis.

Environment: SQL Server 2012, BIDS, Windows X, Tableau Desktop, Tableau Server

Confidential, Herndon, VA

DWH Solution Architect

Responsibilities:

• Work with business users understand in-house application, requirements gathering.
• Build prototype model to help business users to visualize data, KPI, Drill through reports, navigation in Tableau, Qlik View, PowerBI, PowerPivot, SSRS Reports
• Build DB models that would help business users to build reports with minimal technical knowledge (SSBI - Self Service Business Intelligence)
• SSIS Package to pull data from heterogeneous database, web system and consolidate in warehouse for one moment of truth and review overall organization performance, understand trend, and other business metrics.
• Build, define work environments, capacity planning, DB maintenance plans, Job schedules, Job alerts
• Provide project and development status in SCRUM calls.

Environment: SQL Server 2014, Data Tools, Windows X, Tableau Desktop, QlikView Sense, Power BI

Confidential, Chantilly, VA

DWH Solution Architect

Responsibilities:

• Conduct interactive session with customers to understand business model, requirements, rules
• Create Technical Document, Mapping Document, Data Flow Diagrams, ETL Document defining scope of data, data cleansing rules and load pattern (SCD1, SCD2, SCD3)
• Building, deploying datamart’s in Star Schema/Snowflake Schema method.
• Build database maintenance plans, performance tuning, and archiving policies for data retention.
• Build packages to automate process for partition creating, and partition processing for MOLAP Cubes.
• Create ETL Logics, and define/set event handler for business events, notifications for support team.
• Build complex logic to process consolidated data from heterogeneous sources system, data cleansing, to convert raw data into understandable business format.
• Create business model, Logical Dimensional Model, Physical Dimensional Model.
• Used BIDS/Report developer tool to build Tabular, Matrix, Drill Down, linked reports and Dashboards.
• Have worked on migration of SharePoint 2000 and 2003 server, and restore workflow history from database backup.
• Configure, monitor, and restore SharePoint workflow maintenance plans.
• POC for tool validation using YellowfinBI, QlikView Sense, Tableau.

Environment: SQL Server 2008 R2/2012, Data Tools, SSRS 2008, Windows X, SharePoint 2010/2014

Confidential

SQL Server Technical Lead

Responsibilities:

• Interact with customer, understand business requirements, and create technical documentation.
• Provide daily status updates in agile standup meetings.
• Create technical documents for Existing applications
• Troubleshoot and performance tuning of SSIS Packages, SSAS multidimensional Cubes, SSRS Reports.
• Responsible to create and maintain Multidimensional and Tabular models
• Worked on offshore onsite model and handled team of two.
• Create Ad hoc reports as requested by business group.
• Cube enhancements, unit testing and prepare migration document for migration.
• Supported legacy SQL Server 2000 applications.
• Support Enterprise Datawarehouse and DataMart’s.
• SSRS, Analysis Service (SSAS), MDX Queries.

Environment: SQL Server 2012, SQL Server Reporting Server, SQL Server 2000, SSAS, SSRS, Windows X

Confidential

Technical Lead

Responsibilities:

• Interact with business stake holders, understand requirements, perform analysis and build Logical and Physical DB model.
• Build Conceptual Model.
• Installation, configuration and build maintenance plans for Development and Production environment.
• Interact with stakeholders and provide project status and development
• Project documentation like Business requirement documentation, Technical documentation, FAQ's for Support phase.
• Successfully configured and build Reporting Server (Development, Production) environments.
• Build, deploy, and administer RDL reports using data tools and Report server administration.

Environment: OS: Windows Server 2012 Datawarehouse Tools: MSBI Stack.

Confidential

Senior Consultant

Responsibilities:

• Mentor team members for offshore support activities.
• Provide technical support and assistance to onsite members.
• Debug, troubleshoot and performance enhancement of queries, SSIS Packages
• Perform detailed analysis of SQL Server performance, document expensive queries hit on server, educate customers on effective usage of UDF, CTE, Query Hints, Create awareness on table locks and impact of DML operations on huge data volume of data.
• Made recommendations for table partitions, SQL Server Replication options.
• Had challenges loading ODS data due to volume and frequency. This was effectively built by building Optimized stage Tables and Fast load options in SSIS.

Environment: MSBI Suite (SSIS, SSMS, SSAS, SSRS (report server model)), SQL server 2008.

Confidential

SQL Server Technologist

Responsibilities:

• Interact with Business user in Germany.
• Convert UML model to DB model.
• Setting up development environment.
• Writing scripts for data fetch and feed from Web UI.

Environment: SQL Server 2008 R2, Microsoft Visio

Confidential, Ghana, SA

SQL Server Technologist

Responsibilities:

• Involved in Analysis of existing architecture.
• Optimization of Database structure, ETL, stored procedures
• Part of SQL Server up gradation and move data from legacy systems to new systems.
• Design backup strategies and server up time strategy with help of Replication for disaster recovery and mirroring for performance.

Environment: SSMS, Database tuning advisor from SSMS, Database server reports, DB Modeling tool.