SUMMARY

• Around 8 years of experience in analyzing, designing, and developing Client/Server,Data Warehousing/ Data Modeling /Business Intelligence (BI)Stackdatabase applications using MS SQL Server 2016/12/08/05 , SQL Server Integration, and Reporting & Analysis Services.(SSIS, SSRS & SSAS)
• Extensive Experience in database administration, design, development and business intelligence of cosmos Microsoft SQL Server 2012/2008R 2/2005/2000.
• Strong experience with T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Created numerous simple to complex queries involvingself joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
• Experience in optimizing the queries by creating variousclustered, non-clusteredindexes, indexed viewsand user-defined functions,Common TableExpressions (CTE’S), User-defined functions and viewsand usedBackup, Recoverymodels usingMS SQL Server 2012/2008/2005.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and Stored Procedures.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2005/2008R2/2012 database systems.
• Experience in Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Expertise in Performance tuning, Query Optimization and Maintaining data integrity using SQL Profiler and Spotlight.
• Experience in Database administration activities like backup, disaster recovery and maintaining database Security.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and Always on Availability groups.
• Experience in analyzing, designing, tuning and developing business intelligence database applications using MS SQL Server 2005/2008R2/2012 SSIS, Reporting and Analysis services.
• Extensive experience in Data Extraction and Transforming and Loading(ETL)usingDTS packageand by pulling large volumes of data (VLDB) from various data sourcesin MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008/2005 with .NET, Import/Export data,Bulk insertandBCP.
• Expertisein developing reporting applications usingCognos Business Intelligence components like Report Studio,DMRFramework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Extensively used Report Wizard, Report Builder and Report Manager for developing and deploying reports in SSRS.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling OLAP for dimension modeling.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Hands on Experience in developing ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from various sources like (Excel, CSV, flat file) by using multiple transformations provided by SSIS and Analysis Services (MDS).
• Experience in handling Master Data Management (MDM) services and setting up the Master Data Services (MDS) to integrate and maintain various entities.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Vision and Erwin Tool.
• Worked with Team Foundation Server(TFS), perforce as the source for version control and project/issue management.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

TECHNICAL SKILLS

BI & DW Tools: SSIS, SSAS, SSRS, Data tools, PowerBI, PowerShell, crystal reports.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development studio, Visual Studio, Configuration Manager, SQL Server Profiler, SQL Query analyzer, SQL Server Agent

ETLTools: Data Transformation Services (DTS), SSIS, Import/export wizard, Bulk Insert, BCP, Data Warehousing.

BI Tools: SSIS, SSRS, SSAS, Crystal ReportsXI/X/9/8, Report Designer, Business Intelligence Development Studio(BIDS),Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, CognosConnection)

RDBMS: MS SQL Server 2016/2014/2012/2008/2005 , MYSQL,MS ACCESS, Oracle 11g/10/9i,DB2

Programming: SQL, T-SQL, Visual Basic, Visual C++, MY-SQL, java script. Classic ASP, Asp.net, .Net frame work.

ERP: MS Dynamics Axapta 2009 - Financials

Web Technologies: Html, CSS

Operating System: Windows 98/XP/Vista/7/8, UNIX, Linux, Mac OSX

Data Modelling tool: Visual Studio, Adobe Photoshop, MS Office Suite, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Albuquerque, NM

Senior SQL Server/Data Warehouse Developer

RESPONSIBILITIES:

• Actively participated in interacting with users, team lead, DBA’s and technical manager to fully understand the Application/System and Business requirements.
• Assist data modelers in designing of dimensional model for Star schema.
• Involved in database Schema design and development.
• Expertise inoptimizing long runningT-SQLlookup queriestoreduce the lookup cache size, managing Clustered and Non Clustered Indexes,Stored Procedures for Incremental Loads and long data load by dividing the large data loads intoBatch Tableswith optimum batch sizeusing execution plan.
• Worked on Dimensional modelling of the data from Scratch(Extracted the scratch data from heterogeneous sources anddoing theETLfor incremental data loadsusing SSISand building them intoDimensionandFact tablesusingStar Schema).
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Executed stored proc using BATCH files.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.Used Batch Files to Import Data from other Data Base.
• Built new MDS (Master data services) and data warehouse application for business users and Migrated data from old data warehouse to new data warehouse. Developed and maintained Crystal reports as per the user requirement.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Worked as a member inOn-Call Supportwhich requires the On-Call support person to fix the job failures immediately even after the working hours.
• Extensive hands on experiencewithSSISto build huge packages which involves sourcing the data from aTab Delimited Text Files,DB2,XML, Excel filesandFlat Filesand setting up the VariablesandParametersand mapping the obtainedresult setsto aMap Network Drive which uses theMerge Scripts.
• Capaciously worked on integrations involvingMicrosoft Visual C#to use in thescript componentsof SSIS.
• Created Metadata reportsin SSRSthat gives the information about the metadata of the jobs like Effective from, Effective to, Current or not current report, Execution times and errors if there are any.
• Involved in creating measure groups using different fact tables and created calculated members, Advanced KPI’sand named set inSSAS.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error
• Handling and troubleshooting the scripts in failure to load the data into database.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Expert in SSIS Deploying and Scheduling
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Process SSAS cubes to store data to OLAP databases
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

ENVIRONMENT: SQL Server 2008/2012/2014 Enterprise Edition,MDS, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2005.

Confidential, Los Angeles, CA

Senior SQL Server/ SSIS, SSAS, SSRS Developer

RESPONSIBILITIES:

• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Involved inOptimizingStored Proceduresand long running queries usingindexingstrategies and query-optimization techniques.
• CreatedUser Defined Functions(UDF’s) to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Designed SSAS cube to hold summary data for Target dashboards.
• Developed Cube with Star Schema.
• Used variousETLtools likeSSIS/DTSfor data flow from source files likeDB2, XML, Excel, Tablesandviewsto other databases or files with proper mapping and loading toData Warehouse.
• UsingSQL Server Integration Services(SSIS)to populate data from various data sources Developed web based front-end screens usingMSFrontPage, HTMLandJava Script. Actively designed the database to fasten certain daily jobs, storedprocedures.
• Enhancing and deploying theSSIS Packagesfrom Development server toUATandProduction server.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Prototyped datavisualizations using Charts, drill-down, parameterized controlsusing Tableauto highlight the value of analytics in Executive decision support control.
• Generated various reports with drill-downs, calculated members, drop-downs from the cubes by connecting to Analysis server from SSRS
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Developed Report Models usingreport builderand distributed reports in multiple formats using SQL ServerReporting Services (SSRS)inBusiness intelligence development studio (BIDS).
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

ENVIRONMENT: Microsoft SQL Server 2005/2008/2012 Enterprise Edition, MS Access, ETL Packages (SSRS, SSIS), Great Plains, PL/SQL, C#, VB.Net, HTML, IIS, Visual Studio 2008 & 2005, Visual Source Safe, DTS, T-SQL, VSS, TFS.

Confidential, Jacksonville, FL

MS SQL/ BI Developer/SSIS, SSAS, SSRS

RESPONSIBILITIES:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server
• Implemented transactions at package level and task level to meet the business requirements.
• Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating usefulclustered indexandnon-clustered indexesand Views.
• Managedupgradation ofDTS packages to SSIS packagesand fillingDimensionandFact tablesintoData WarehouseandData Marts.
• DeployingSSRSreports to report server and managing report subscriptions.
• Designed SSIS package templates as base code for package development incorporating package
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Created SSRS reports using Report Parameters and Drop-Down Parameters
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.
• Generated Reports weekly and monthly to an online management interface using SSRS
• Responsible for Post production support
• Create, manage SQL Server AZURE Databases.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Understanding theOLAPprocessing for changing and maintaining the data warehouse.
• Resolved critical issues in given timeframe.
• Monitored jobs and created several critical reports
• Performed code reviews, unit testing.
• Status meetings with the client, conducting reviews of the deliverables, defect tracking and analysis
• Work with business stakeholders, application developer, and production teams and across functional units to identify business needs and discuss solution options.

ENVIRONMENT: SQL Server 2012, T-SQL, MS Integration, Analysis and Reporting Services, Management Studio, Query Analyzer, Windows 2007 Server, Oracle 11g, C#, COSMOS.

Confidential

SQL Server Developer

RESPONSIBILITIES:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
• Document internal and external data sources and data integrations and provide operatingsupport ordataintegrationsolutions.
• Created ETL packages with different Heterogeneous data sources(SQL Server, Flat Files, CSV,Excel source files, and XML files) and then loaded the data into destination tables by performing different kinds of transformations usingSSIS/DTSpackages.
• Involved in database Schema design and development.
• Designed tables, constraints, necessary stored procedures, functions, triggers and packages using T-SQL.
• Audited the Front-end application calls to SQL Server.
• Created efficient Queries, Indexes, Views and Functions.
• Developed complex programs inT-SQL, writingStored Procedures, Triggers, Functionsand Queries with best execution plan.
• Created packages usingError handling mechanismand usedBreak points, Toggle switches andvariablesto handle package dynamically inSSIS.
• DesignedETLpackage, withETLImport/Export wizardfor transferring data.
• Enforced Security requirements using triggers to prevent unauthorized access to the database.
• Optimized the Database for best performance, with DBCC, partition table.
• Design and develop the payroll module using MS SQL Server 2005.
• Migrated data from MS Access to SQL Server.
• Performance Tuning of the client databases for better performance on a regular basis.
• Responsibilities include writing of scripts for Database tasks, releasing Database objects into production.
• Running DBCC consistency checks, fixing data corruption on application Databases.
• Experienced working onStar, Crystalandsnow flake schemasand used thefactand dimensiontables to build the cubes, perform processing and deployed them toSSASdatabase.
• Created complex SSAS cubeswith multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Improved existing reports performanceby using execution log2 and optimized the underlying procedure and queries.
• Worked in establishing connectivity between VB applications and MS SQL Server by using ADO.
• Supporting ADO and Active-X connectivity to the database

ENVIRONMENT: SQL server 2000/2005, Oracle 9i/10G, MS VB Access, Windows 2003 Standard Edition, Windows 2005.

Confidential

SQL Developer

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on Servers.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Implement and maintain database security.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Going through the clients' requirements and coming up with database design and application architecture.
• Troubleshoot and minimize production down issues.
• Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Maintaining User account administration for Different domains.

Environment: MS SQL Server 2000/2005, SSIS, Visual Studio 2005, VB.net 2005.