SUMMARY:

• 8+ years of experience in IT industry performing Design and Development using SQL Server 2005/2008 R2/2012/2014.
• Working knowledge of database administering and backup/restore.
• Expertise working with SQL Server 2005/2008 R2/2012/2014 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS/Catalogs and SSRS, DQS.
• Experience in data Normalization and Data Modeling using Erwin and Visio and generating mapping documents.
• Extract Transform Load (ETL) development using SQL server 2008R2/2012 Integration Services (SSIS) and SQL Server 2008R2/2012 Reporting Services (SSRS).
• Very good understanding and experience of Relational Database Management Systems RDBMS .
• Migrated DTS Packages to SSIS using various versions of SQL Server.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Working knowledge of configuring Power BI and Creating user friendly dashboards.
• Configured and administer BPA (Business Process Automation) for designing ETL work flow and including multiple packages within the work flow
• Documenting all ETL projects and work flows by using BI Documenter and including supporting documents for troubleshooting.
• Experience with Ad - hoc reporting, parameterized, custom reporting using SSRS and Power BI.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.
• Managed Production Server and Development server for SCCM Reporting .
• Developed Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11.
• Worked with new data quality services (DQS) in SQL 2012 as part of creating rules for data mapping and data cleansing.
• Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for Query performance analysis.
• Experienced in Data Migration by using side-by-side upgrade process Management.
• Experienced in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions. Implementing SQL Server security and Object permissions.
• Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace and 3 rd party tools.
• Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.
• Experience in Query Tuning by Using Execution Plan, query analyzer and tuning advisor.
• Good Knowledge of Web development technologies such as HTML, XML , DHTML and Visual Studio 2008/2010.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2005/2008 R2/2012 Server, Unix, Linux

Languages: T-SQL, PL/SQL, ASP.NET, .Net Framework 3.0/4.0/4.5, C#, XML

Data Warehouse Tools: SSIS, SSRS, SSAS, BIDS (Business Intelligence Development Studio), Data tools, DTS, Melissa Data, SalesForce, Informatica cloud, TFS, Erwin 9.0 SEQUEL view point, System I Navigator, BPA (Business Process Automation), DQS (Data Quality Service), MDM (Master Data Management)

Databases: MS Access, SQL Server 2005/2008R2/2012/2014, Oracle 10g/11g, Teradata, MySQL, DB2, AS/400 Mainframe, Siebel CRM

Reporting Tools: SSRS 2005/2008R2/2012, Qlikview, Cognos 10.1 Report Studio, Report Builder 3.0/4.0, Jaspersoft, Power BI

Other Tools: SQL Sentry Power Suite, VSS (Visual Source Safe), TFS, HPQC (HP Quality Center), Hadoop (HDFS), GitHub, RedHat linux 6 (hosted Oracle VM)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. MSBI Lead Consultant

Responsibilities:

• Developing Data Warehouse project for GA virtual school(GAVS) from the scratch and handling existing SLDS ongoing developments.
• Helping users to identify the possible matrices for the Power BI reporting and other analytics decisive reporting.
• Created Data Models for each module of the current OLTP system and participating in the brain storming session to nail possible design challenges.
• Designed configurations tables and ETL templates to maintain consistency across all the different solutions.
• Extensively working on SQL 2014 for Virtual school project (GAVS) and SQL 2008 R2 for all other supporting projects.
• Configured Power BI Gateway for the dashboards and other Ad hoc reporting needs.
• Created various Power BI Dashboard and reports using PBI Desktop and deployed it to the shared location.
• Using Direct query for live tiles in the Power BI Desktop and design presentable dashboard for mobile users.
• Configured SSIS Catalogs for Development and UAT environments and using parameters to drive all configurations changes and deployments.
• Created views and data marts for Power BI and SSRS reporting. Created Cubes for various predictive dashboards and ad-hoc reporting.
• Helping junior developers to troubleshooting existing ETL processes and building effective solutions for new requirements.
• Participating on call supports for after hours and root cause analysis for data issues.

Confidential, Atlanta, GA

BI/Data Warehouse Lead Consultant

Responsibilities:

• Works as a solution architect for developing EDW (enterprise Data Warehouse) from the existing legacy system.
• Managing data modeling team and brain storming sessions for EDW practices.
• Tracking day to day activities of developers to ensure the quality of work and meet the timeline.
• Design an architect process diagram for the new process and building an ETL solution using BI Stacks (SSIS, SSRS, SSAS).
• Managing various existing process to incorporate within the new development and create SSIS packages to feed the Datamart and data cubes.
• Handling Reporting layer to generate new reports as well maintain existing reports for business users.
• Conducted root cause and analysis for database incidents and problems. Managed security by defining roles and rights.
• Monitored data activities (i.e. database status, logs, space utilization, extents, checkpoints, locks and long transactions).
• Exposure of importing and exporting data between relational sources like SQL Server/Oracle and HDFS/Hive.

Confidential, Columbus, GA

BI Technical Lead Consultant

Responsibilities:

• Technical lead for data management and operations for Empower .net project (New app developed for centralized the loan process).
• Managed the rollout, training, and support of an EDW reporting solution (SSRS) and Empower.Net (New App to consolidate Loans).
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Handling on call supports for all data issues and framework issues.
• Managing team of 4 Developers with 2 off shore.
• Used Caching (Cache Technology) for fast retrieval of data to generate SSRS reports against data warehouse and Normalization and De-Normalization of existing tables for faster query retrieval.
• Developing and maintaining existing SSAS Cubes for dashboard reports and KPIs.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension (SCD) wizard.
• Getting involved in Big Data platform and having good exposure of big data.

Confidential, Richmond, VA

MSBI Consultant

Responsibilities:

• Extracting data from various sources like flat files (delimited, fixed width), Siebel CRM, Teradata, Oracle 11g, SQL 2008R2 and load it to SQL database for further process.
• Gathered requirement from the end user and developing ETL work flow for various ongoing projects
• Designing physical and logical data models and handling data repository for data models.
• Handling most of independent packages as well projects and troubleshooting it in case of any failure.
• Good exposure of Teradata express studio for writing queries and comparing the result with SQL audit tables.
• Configured and administer BPA (Business Process Automation) for designing ETL work flow and including multiple packages within the work flow.
• Administrating the Medicare and CRM data projects and deliver the data to vendor for further analysis and development.
• Documenting all ETL projects and work flows by using Bi Documenter and also including supporting documents for troubleshoot for each project.
• Creating a template for the projects and making sure that following the same template across the project for better view and knowing. Supporting data modeler for the design prospect and help them to review it.
• Handling status call for every week and noting the work done and ongoing for the team.
• Created and maintaining audit for all the projects to store the execution logs in SQL database with insert, update and delete records.
• Developing data warehouse solution for customer & marketing analytics group data and designing the ETL data flows to load history tables.
• Designed the connectivity layer between the applications to the database using ADO.NET.
• Developed the business layer for all the business validations per user requirements using .NET Framework.
• Working on data profiling and data discovery for migrating legacy to new databases. Working with Melissa Data interface to cleanse contacts, email and address data.
• Working with Informatica cloud and Salesforce integration for live data feed in SQL Databases.
• Configuring and maintaining reporting services for ad-hoc reporting and report models for the users.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.
• Developing and Tuning Data Cubes in SSAS for achieving best performance at reporting level. Writing MDX for generating SSRS reports and maintaining existing Dashboards.
• Working with BI stacks (SSIS, SSRS, SSAS) to creating aggregated datasets and datamart for business user as well dashboards.

Confidential, Richmond, VA

MSBI Consultant

Responsibilities:

• Closely worked with business users for gathering requirements and conducting a weekly meeting for BI team. Worked with Data modelers to create physical and logical models by using ERWIN.
• Developed DDL script using ERWIN and implemented rollout data models to design further SQL development. Creating test cases to implement the changes to QA and PROD for new ETL development and existing ETL packages.
• Extracting data from I-series (AS 400), Oracle, SQL 2005 and flat files using SSIS and performing all necessary procedures for data cleansing. Maintaining Landing zone and staging zone for data dumping.
• Running PL/SQL script and validate the data load for SQL server.
• Performed intensive data quality on various data migration and written various post scripts to perform data correction. Used various tasks like fuzzy lookup, for each loop, file system task for data cleansing and automate the process.
• Documented all ETL packages and applying versioning with other changes. Also created supporting documents for future failures. Worked on multiple projects for ETL development and system integration for new environment.
• Provide resolution and escalation of tickets assigned to Data Management group using Remedy force.
• Worked with TFS 2012 for check in, check out and deploying packages to QA and PROD.
• Experience with Ad-hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
• Multiple views were created to reduce the complexity of writing procedures and increase database performance.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW) and offshore team management.
• Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse. Configuring and administering MDM services for direct client access.
• Hands on experience using DQS services and DQS task for Data Cleansing and creating rules for business.
• Highly skilled in developing Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11. Good exposure on Cognos 10.1 report studio and Framework manager.

Confidential, Fort Mill, SC

MSBI Consultant

Responsibilities:

• Involved in gathering requirements for Database creation, scheduling status review meetings, documents and code review.
• Good exposure in creating and managing conceptual, physical and logical data models.
• Created data mapping and sourcing documents for various sources to NPS (New App).
• Involved in designing and implementing relational database (RDBMS) model as per business needs. Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server 2012 integration services.
• Extracting data from IMS/DB2, MS Access, SQL Server 2005/2008 for migration and performing various transformations in SSIS (ETL) per business rules.
• Configured integration services 2012 and reporting services 2012 for developing new environment for NPS systems (New Application). Converted existing DTS packages to SSIS (ETL) and tune the connections pointing towards new applications. Designed various database connections for the NPS using ADO.NET.
• Conducting a meeting with BSA to gathering more information on work flow for data migration and to understand new terminology for new application.
• Used change data capture (CDC) to simplify ETL in data warehouse applications.
• Experience in creating jobs, alerts, SQL mail agent and schedule SSIS (ETL) packages.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server. Experience Type 1 SCD and Type 2 SCD mappings to update slowly changing dimension tables. Experience pulling data from SSAS cube and developing and maintaining cubes.
• Experience in configuration of report server and report manager scheduling, give permission to different level of users in SQL server reporting services (SSRS).
• Performs System testing for all the modules and helps business in User Acceptance Testing.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.
• Well Experience in using tools like SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.
• Coordinating with offshore team for on time delivery of products and query resolution activities.

Confidential, Austin, TX

SSRS Consultant

Responsibilities:

• Extract Transform Load (ETL) development using SQL Server 2005, SQL server 2008R2 Integration Services (SSIS) and SQL Server 2008R2 Reporting Services (SSRS).
• Captured Plan information for heavy, slow-running, and poorly performing T-SQL in SQL Sentry Performance advisor to providing a record of all plan changes and optimizing query based on results.
• Developed and maintained ETL packages (SSIS Packages) to extract the data from various sources and involved in debugging and upgrading of several ETL structures as per the requirements.
• Build Development Server for Reporting and creating SCCM Reports Based on infrastructure needs. Publishing Reports on Reporting Server and Share point portal.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managing Production Server and Development server for SCCM Reporting .
• Formatted the reports using the Global variables and expressions. Managed security by defining roles and rights.
• Manages the implementation and support of SQL Server 2008R2 and SCCM across multiple applications.
• Experience in data migration (using tools like DTS, Bulk Insert, BCP and Replication) between different homogeneous and heterogeneous systems and SQL Server.
• Working knowledge of disaster recovery and high availability solution like replication, transaction log shipping, mirroring and clustering.
• Monitored the database server performance and if required go for tuning of the T-SQL queries, stored procedures etc. Proven ability to handle database of more than 500 GB in size.
• Conducted root cause and analysis for database incidents and problems. Provide 2nd and 3rd level support and rotating on-call support.
• Monitored data activities (i.e. database status, logs, space utilization, extents, checkpoints, locks and long transactions). Developed and maintained scripts, utility jobs or implement needed software for database maintenance.

Confidential, Hoboken, NJ

SSIS Consultant

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of agile model system.
• Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Worked in Active passive cluster environment. Used log shipping for synchronization of databases. Update statistics, database integrity check and Backup operations
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Migrating databases from legacy system to SQL server and involving in rewrite codes and validate after migration.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
• Developed T-SQL for maintaining, developing and creating database and fine tune Stored Procedures and Queries to improve performance of system.
• Proficient in creating and tuning database, developing views and having good exposure of C# and .NET Framework.
• Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.
• Developed, monitored and deployed SSIS packages and user Defined Functions for giving Scores and views for the application. Generated reports from SSRS (SQL server reporting services) and SSAS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.