SUMMARY

• Experienced in database development (Conceptual, Logical and Physical Data Model) and Dimensional Modeling.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Constraints, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules using Server 2012/2008 R2/2008/2005/2000.
• Designed and Created Databases, CTE, Table Variable, Temp Tables, Table Partition, resolved lock issues and Configured Security Issues.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Extensive experience in using T - SQL (DML, DDL) and wrote complex SQL Queries in SQL Server 2012/2008/20005/2000 platforms.
• Developed various Tabular Reports, Matrix Reports, Report dat contains Chart and Graphs, Reports dat aggregate data, Reports containing parameters and Expression, Grouping and Filters, Reports containing Totals and Subtotals, Report Actions, Linked reports, Sub reports, Composite Report Items and Dynamic Visibility, Drill-down and multi-valued parameter reports, and ad-hoc reports using SQL Server 2012/2008 R2/2008/2005 Reporting Services.
• Configured and Deployed different reports in Report Manager and Report Server.
• Using SQL Server 2012/2008 R2/2008/2005/2000 SSRS, me have designed and created reports and distributed reports in multiple render formats such as Excel, PDF, XML, HTML, TIFF, Word and CSV.
• Designed, configured and implemented OLAP Databases.
• Using SQL Server 2012/2008 R2/2008/2005 SSAS, me have created and configured Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views using SQL Server 2008/2005 Analysis Services.
• Actively participated in the designing of Data Warehouse for both Star and Snow Flake schema.
• Designed and Implemented SSIS Packages for different projects using SQL Server 2012/2008/2005 SSIS.
• Implemented Configuration Files, Variables and Property Expression in SSIS Package.
• Designed in Extraction, Transforming and Loading (ETL) data flows using SSIS; Implemented mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Conducted Data Analytics and Visualizations using PowerPivot, PowerView and SharePoint
• Created, triaged and resolved different level of bugs using VSTS Suite 2010/2008/2005.Conducted QA and test. Developed test plan, test cases and test procedures. Documented test results.
• Solid experience of ERP Applications including General ledger, Sales Order Processing, Accounts Receivable, Accounts Payable, Inventory Control, Purchase Order Processing and Process Manufacturing.
• Excellent interpersonal skills working in teams wif people from different cultures and backgrounds. And energetic wif excellent analytical and organizational skills.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008 R2/2008/2005, Oracle 10g/9i/8i

Business Intelligence Tools: SSRS, SSAS, SSIS, PowerPivot, PowerView

Reporting Tools: SSRS, Crystal Report, Oracle Report 10g/9i and Business Object

Source Code Control: Microsoft Visual Studio Team Foundation 2008/2010 (TFS), Microsoft Visual Source Safe (VSS) and Subversions

Language: T-SQL, MDX, PL/SQL, Visual Basic 6.0/.Net, C#

Data Modeling: E-R Modeling and Dimensional Modeling

Web Technologies: SharePoint 2010/2007, XML, HTML and VB Script

MicroSoft Office Applications (Excel, Word, Access, PowerPoint for version 2013/2010/2007/2003):

Operating Systems: Windows Server 2008/2003/, Windows 8/7/Vista/XP/98/95

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Technology Lead

Responsibilities:

• Actively Participated in acquiring of different data sources about 8 Terabyte Data Size in SQL Server 2012 Env.
• Created and configured Databases.
• Wrote complex SQL Queries to analyze data in various different data sources using SQL Server 2012 Env.
• Designed and maintained Databases, Stored Procedures, Views, Functions, Temp Tables, Table Variables, Indexes and Tables and Wrote Complex Queries to manipulate data using SQL Server 2012 Databases.
• Configured and created Schema, Login Accounts, Users, Roles, Permissions, Jobs and Schedules and Resolved Performance Issues in SQL Server 2012 Env.
• Designed SSIS Packages to import and export data between databases.
• Implemented Configuration Files, Variables and Property Expression in SSIS Package.
• Designed in Extraction, Transforming and Loading (ETL) data flows using SSIS; Implemented mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities
• Conducted Data Analytics and Visualizations using PowerPivot, PowerView and SharePoint
• Actively participated on different issue analysis and finding and resolving bottle necks and challenges.
• Collaborated wif Program Managers, Solution Delivery Managers, Project Managers, business partners, and developers to coordinate project schedules and timelines.
• Worked wif offshore teams as well as on site staffs on a wide range of tasks and supported different level of issues.

Confidential, Easton, MD

SQL Server Developer

Responsibilities:

• Migrated Micro Soft Access based PI Books database in to SQL Server Database.
• Redesigned Logical and Physical Data Model for Microsoft Access Based PI Books Database and implemented using SQL Server.
• Designed Stored Procedures, Views, Functions, and Tables and Wrote Complex Queries to manipulate data using SQL Server Databases.
• Designed SSIS Package to transfer data between databases.
• Wrote complex SQL script to import/export from Microsoft Access into SQL Server Database.

Confidential, Seattle, WA

SQL Server Developer

Responsibilities:

• Developed Stored Procedures, Views, Functions, Indexes and Tables and Wrote Complex Queries for Crystal Report Conversion, New Report Development, Data Analysis and Data Extracts Projects Using SQL Server Databases.
• Wrote complex SQL queries, Temp Tables, Table Variables and Common Table Expressions and resolved performance issues to assure the quality of client reports, internal reports, cubes and data analysis.
• Designed Stored procedures/functions/report for the formatting of mailing labels dat can be used as a standard template.
• Converted different Crystal Reports into SSRS.
• Designed various Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Report dat contains Chart and Graphs, Reports dat aggregate data, Reports containing parameters and groups, Reports containing Totals and Subtotals, Drill-down and multi-valued parameter reports and ad-hoc reports for New Report Development and Crystal Report Conversion Projects using SSRS.
• Configured and Deployed different reports in Report Manager and Report Servers.
• Designed and distributed reports in multiple formats such as Excel, PDF, Word, XML, HTML, TIFF and CSV using SSRS.
• Managed different Reports using Browser-Based Report Manager and SQL Server Management Studio Based Report Manager.
• Created SSIS Package for 16 Month Survey and 20 Month Survey Data for DatStat Projects.
• Created and Configured Jobs for 16 Month and 20 Month Survey SSIS Package Using SQL Server Agent.
• Conducted different Data Analysis and Data Extract to support the Business Environment using SQL Database Objects (tables, views, functions, stored procedure, temp tables, table variables, CTE), EXCEL 2010 and SharePoint 2010.
• Alliance and EOP Data Extract, Outbound Reenrollment Data Analysis, Mind and Body BOB Data Extract, M & B Survey Completed Data Analysis, BCBS MN Evaluation Data Analysis and Wisconsin Tobacco Usage Data Extract
• Designed and analyzed cubes data for a range of projects using Excel 2010, Analysis Services and SharePoint.
• Analyzed, tuned and optimized different SSRS Reports and there data sources.
• Created technical documentations and published in SharePoint Site

Confidential, Bellevue, WA

Business Intelligence Developer

Responsibilities:

• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Chart and Graphs, Reports dat aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SQL Server 2008 R2/2008/2005 Reporting Services for different mCore products.
• Designed reports wif formulas, grouping/sorting and parameters (including multi-value parameters) using SQL Server 2008 R2/2008/2005 Reporting Services.
• Designed and created reports and distributed reports in multiple formats such as Excel, PDF, XML, HTML, TIFF and CSV using SQL Server 2008 R2/2008/2005 Reporting Services.
• Configured and Deployed different reports in the Servers using SQL Server 2008/2005 Reporting Services.
• Managed different Reports using Browser-Based Report Manager and SQL Server Management Studio Based Report Manager.
• Extensive Experience on OLAP Database and Cube Development.
• Designed Custom Assemblies/Function to enhance the functionality of different reports.
• Wrote complex MDX queries as a data source for different reports in various mCore projects.
• Created and Configured Cubes using SQL Server 2008 R2/2008/2005 Analysis Services.
• Configured Dimensions, Measures and Measures Groups using SQL Server 2008 R2/2008/2005 Analysis Services.
• Conducted data analytics and data mining for Cellular, T-Mobile and Alltel business reviews.
• Worked closely wif the business users in defining and documenting reporting requirements and business reviews.
• Developed different Views, Stored Procedures and Functions and Triggers used as a data source for different reports.
• Created, triaged and resolved different level of bugs using VSTS Suite 2008/2005.

Confidential, Bellevue, WA, USA

Business Intelligence Developer

Responsibilities:

• Developed Views, Stored Procedures and Functions used as a data source for various Reports.
• Developed various Tabular Reports, Matrix Reports, Report dat contains Chart and Graphs, Reports dat aggregate data, Reports containing parameters and Expression, Grouping and Filters, Reports containing Totals and Subtotals, Report Actions, Composite Report Items and Dynamic Visibility, Drill-down and multi-valued parameter reports, and ad-hoc reports using SQL Server 2008/2005 Reporting Services.
• Managed different Reports using Browser-Based Report Manager and SQL Server Management Studio Based Report Manager.
• Developed different types of ad-hoc reports using Report Model and Report Builder tools of SQL Server 2008/2005 Reporting Services.
• Configured and Deployed different reports in Report Manager and Report Server.
• Using SQL Server 2008/2005/2000 SSRS, me have designed and created reports and distributed reports in multiple formats such as Excel, PDF, XML, HTML, TIFF and CSV.
• Using SQL Server 2008/2005 SSAS, me have created and configured Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views using SQL Server 2008/2005 Analysis Services.
• Designed Data Warehouse Database for both Start and Snow Flake Schema.
• Designed, configured and implemented OLAP Databases.
• Enhanced the functionality of Cube by creating KPI, Actions and Perspective using SQL Server 2008/2005 Analysis Services.
• Created MDX queries to access cube information.
• Designed and Created SSIS Packages to support the Foundation Project using SQL Server 2008 Integration Services and wrote ETL Code.
• Designed SSIS Packages to transfer data between servers, load data into database; Scheduled the jobs to do these tasks periodically;
• Implemented Configuration Files, Variables and Property Expression in SSIS Package.
• Analyzed, tuned and optimized different SSRS Reports and there data sources.
• Created logical and physical data modeling for development database using Erwin Tool
• Performed DBCC utilities and fixed data corruption in application databases.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries using SQL Server.
• Worked closely wif the business users in defining and documenting reporting requirements in order to design, develop and maintain SQL Server 2008/2005 Reporting Services in Report Conversion Project.
• Created, triaged and resolved different level of bugs using VSTS Suite 2010/2008/2005.Conducted QA and test. Developed test plan, test cases and test procedures. Documented test results.

Confidential, Fairfax, Virginia, USA

Junior Consultant

Responsibilities:

• me have managed 4 successful integration and software development projects including…
• SOPAKCO Packaging
• United Refractory
• J & B Sausage Company
• Boston ITW Company
• Configured and deployed ERP Applications including General ledger, Sales Order Processing, Accounts Receivable, Accounts Payable, Inventory Control, Purchase Order Processing, Process Manufacturing, Maintenance Management, Government and Public services sector management.
• Provided a training on various module of ERP Applications (GL, AP, AR, SOP, POP, Inventory, Process Manufacturing, Maintenance Management, and Fixed Assets) at different client sites.
• Designed and loaded Client data into Dev, Test, Pilot and Production Platforms.
• Designed in Extraction, Transforming and Loading (ETL) data flows using SSIS; Implemented mappings/workflows to extract data from SQL Server and Flat File/Excel sources and load into Dev, Test, and Prod Machines.
• Designed Stored Procedures, Views, Functions, and Tables and Wrote Complex Queries to manipulate data using SQL Server 2000/2005 Databases.
• Developed various Tabular Reports, Matrix Reports, Report dat contains Chart and Graphs, Reports dat aggregate data, Reports containing parameters and groups, Reports containing Totals and Subtotals, Drill-down and multi-valued parameter reports, and ad-hoc reports using different reporting tools (SSRS, Crystal Reports and Business Objects)
• Conducted various data analytics and visualization for different projects.
• Worked closely wif the business users in defining and documenting requirements.

Confidential

Application and Database Team Leader

Responsibilities:

• Installed, configured, upgraded, applied patches planned and administrated Oracle 9i/10g Instances for TIN(Tax Payer Identification Number System) and SIGTAS Application (Valued Added Tax System).
• Designed, configured, customized and administrated TIN(Tax Payer Identification Number System) and SIGTAS Application (Valued Added Tax System) for both Dev and Prod Environments.
• Performed administrative tasks such as backup and recovery, SQL Tuning, Scripting, Database Replication and RMAN for different Oracle Instances.
• Implemented security policy, roles, users account, object privileges across Oracle Databases and for TIN and SIGTAS Applications.
• Created and Managed Oracle instances object like tablespaces, tables, views, indexes, functions, procedures and triggers.
• Planned and implemented upgrades from Oracle 8i database to Oracle 9i, documentation and procedures.
• Involved in Requirement Analysis, Design, and Implementation for TIN and SIGTAS Applications.
• Designed backup and recovery plan, implemented wif RMAN as centralized backup solution.
• Developed different Forms and Reports for TIN and SIGTAS Application Using Oracle Forms 9i/10g and Oracle Reports 9i/10g and Designed and implemented complex code using PL/SQL.
• Involved in capacity and resource planning and trained junior developers.
• Developed complex SQL Code, stored procedures, functions, tables, views and indexes for others legacy systems like Human Resource, Payroll and others using SQL Server Databases in the Ministry of Revenues.
• Implemented Logical and Physical Data Modeling using SQL Server Databases.

Confidential

SQL Server Database Administrator and Programmer

Responsibilities:

• Determined the SQL Server Installation; Installed SQL Server Management tools using SQL Server Setup Program; Tested the Installation of SQL Server
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Updated Database Statistics and Re-indexing
• Designed Stored Procedures, Views, Functions, and Tables and Wrote Complex Queries to manipulate data using SQL Server Databases.
• Designed and implemented Library Management System using Visual Basic and SQL Server Databases.
• Wrote complex SQL script to import/export from Microsoft Access into SQL Server Database.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery
• Configured Different RAID Levels (Redundant Array of Independent Disks)
• Designed DTS Package, DTS Import/Export for Transferring data from various Database