SUMMARY

• 7 + years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 (R2)/2005/2000 in Development, Test and Production Environments with various business domains like Financial, Healthcare and manufacturing.
• Excellent understanding ofRelational Database Systems, Normalization, logical and physical data modelling.
• Excellent T - SQL development skills to write complex queries involving multiple tables, great ability to develop and maintainstored procedures, triggers, user defined functions.
• Experience inCreating and Updating Clustered and Non-Clustered Indexesto keep up the SQL Server Performance
• Experience inPerformance TuningandQuery Optimization.
• Expert in maintainingError loggingusingExceptional HandlinginT-SQLandSSIS.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation
• Good knowledge ofSystem Development Life Cycle (SDLC).
• Expert Knowledge of Integration Services(SSIS), Analysis Services(SSAS)and Reporting Services(SSRS)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying theSSISPackages from development server to production server by using package configurations
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in using tools likeBulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Developing reports onSSAS & SSRSon SQL Server (2000/2005). Sound Experience and understanding ofSSAS, OLAP cube and Architecture.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2005/2000.
• Experience in Database Development, modelling, Data Warehousing, Design and Technical Management.
• Used MDX to interact with the back end OLAP Services
• Experience in creating reports throughPROCLARITY.UsedPROCLARITYfor accessing and analyzing cubes and dimensions.
• Well aware of SDLC procedures, Change control rules, problem management and escalation procedures.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Good in implementingSQL Server Security and Process Control.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and end users.

TECHNICAL SKILLS

Languages: C, SQL, T-SQL

RDBMS: MS SQL Server 2014/2 R2, 2005, 2000, 7.0, MS-Access

Web Technologies: HTML, XML

Productivity Applications: MS Word, MS Excel, MS Access, MS FrontPage.

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS, ETL Informatica V8 & V9.

Data Modelling Tool: ERWIN, Visio

Operating System: Windows 95/98/2000/XP/NT, MS Dos and UNIX

Tools: Microsoft Visual Studio 2008, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr SQL developer

Responsibilities:

• Gather requirements and understand the specifications of wholesale access needs.
• Designed and built prototype for access challenge on the wholesale end to integrate with Enterprise access tool.
• Installed and Configured Microsoft SQL Server 2008/2012/2014 .
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/2012/2014 .
• Actively involved in developingComplex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Design and document the error-handling strategy in the ETL load process using Event handlers.
• Scheduling and monitoring ETL packages daily load. Developed Exception handling process for each SSIS package. Tested the data with complex queries, joins and sub queries.
• Developed manyMDXand DAX queries for creatingcalculated measuresthat fits business logic.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Developed dashboards using Excel Power Pivot.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
• Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
• Generating ad-hoc reports usingMS-ExcelandCrystal Reports.
• Logical Data ModellingusingER-Winto fit business requirement.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Debugged packages and use error handling scenarios for the Packages
• Fixed QA bugs created for ETL team after migration of packages
• Used SQL Server 2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management and data center services.
• Managed the historical data in the data warehouse from various data sources.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.

Environment: MS SQL Server 2005/ 2008/2012/2014 , Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SSAS, SSRS 2008, ER win,ETL Informatica, T-SQL,MDX, Visual Studio 2008, MS Office 2007, SQL Profiler visual studio 2005, MS Visio.

Confidential, Erie, PA

Sr. SQL developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Supported Users for various Reporting and Analytics requirements across multiple Business Units and departments.
• Designed and developed enterprise reports (SSRS) using the data fromTeradata,SSAS Cubesand various heterogeneous data sources.
• Worked on developingTables,Indexes,Views, Creating complexstored procedures,Triggers,Functionsin SQL Server 2005.
• CreatedTables,MacrosinTeradataSQL Assistant 7.1and generating the sample reports using Excel 2007.
• Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc to extract, transfer and load (ETL) data from OLTP to OLAP databases
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources likeFlat Files,Exceland otherOLEDB,ODBCdata sources.
• Designed and DevelopedSSIS Packagesusing various Control Flow and Data Flow items to Transform and Load the Data usingSQL Server Integration Services (SSIS).
• Scheduling and maintaining SSIS Packages and batch jobs thruSQL Server Agenton a weekly basis.
• Created various Tabular and Matrix Reports usingSSRS.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008/2012/2014 via SQL Server Integrated Services
• Experience in configuringpackage logging, error loggingandevent handlingto redirect error rows and fix the errors in SSIS.
• DevelopingOLAP cubesby identifying tables(fact and dimension), Data Source and Data Source Views, attributes and dimension members usingSQL Server Analysis Services (SSAS).
• Developed manyMDXqueries for creatingcalculated measuresthat fits business logic.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Designing Enterprise reports usingSQL Server Reporting Services (SSRS 2005)andExcel Pivot tablesbased onOLAP cubeswhich make use of multiple value selection inparameterspick list,cascading prompts,matrixdynamics reports and other features of reporting services.
• CreatedDrill-through reports,parameterized reportsandlinkedreportsusing SSRS 2005.
• Created official Templates,Mailing Subscriptionsand createdshared data sourcesthat can be used across different processes.
• Complete administration of SSAS Cubes which involvedcreating logins, maintainingitem level security,managing rolesandgranting permissions.
• Involved in Database Administration activities likeBack Up, Securityetc.

Environment: MS SQL Server 2008/2012/2014 , MS SQL Server Integration Services 2005/2008/2012 , SQL Server 2005, Visual Studio 2005, Reporting Services (SSRS 2005), Integration Services (SSIS 2005), MS Office 2007, Lotus Notes, SQL Server Analysis Services (SSAS 2005), Tabular, ETL, MDX, Visual Source Safe (VSS), Teradata SQL Assistant 7.1, SQL Server Profiler.

Confidential, Miami FL

SQL developer

Responsibilities:

• CreatedSQL server AnalysisProjects using MS SQL Server 2005.
• Designed/ developedSSAS (OLAP) MDXdeveloping components.
• ConfiguredSnapshot Replication(Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Deployed/DesignedcubesinSSASenvironment.
• Knowledge in designing and developing Data Warehouses, Data marts andBusiness Intelligenceusing multi-dimensional models such asStar SchemasandSnow Flake Schemafor developing Cubes using MDX and DAX.
• Built cube (business requirements includingKPI’s were already declared before development) and mentored internals on procedures.
• Identified and definedFact relationshipsinSSAS.
• Worked with QA team on fixing data quality or process bugs.
• Developed procedures and functions for business & data transactions withError Handling.
• Tuned SQL statements (Using Indexes) and Stored Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Converted various SQL statements into stored procedures thereby reducing the number of database accesses (since Stored Procedures passes the whole block at one time).
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of theUNIONOperator and using theTOPoperator to limit the Select Statement in certain Queries.
• Developed Stored Procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data intofact tables.
• Optimized queries tuned and monitored serverperformanceusing SQL Profiler.
• Worked closely with the developers, end users and the administrator in designing and creating the database.
• UsedSSISto createETL packages(.dtsxfiles) to validate, extract, transform and load data to data warehouse databases, data mart databases, and processSSAS cubesto store data toOLAPdatabases.
• Fine tuned database objects and server to ensure efficient data retrieval.
• Successfully loaded data from Excel, Access andFlat Files(.txt) into a SQL Server database Table.
• Wrote procedures to prepare databases for replication.
• Used SQL Profiler for troubleshooting, monitoring,optimizationof SQL Server and SQL code.

Environment: SQL Server 2005, Query Analyzer, Enterprise Manager, SSIS, DTS Designer, SQL Profiler, Index Tuning Wizard, T-SQL, Analysis Services (SSAS), ASP.NET, XML, Windows OS.

Confidential, Maryland Heights, MO.

SQL developer

Responsibilities:

• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
• Built efficient SSIS packages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.
• Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse/OltpDB
• Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as .
• Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: SQL Server 2005, MS SQL Server 2005, SSIS, SSRS, MS BIDS, T-SQL, SSRS, Erwin 4.x Crystal Reports 10, Visual Studio 2005, MS Office 2007, SQL Profiler, Windows 2003.

Confidential

Junior SQL developer

Responsibilities:

• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation.
• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2005/2000, DTS, T-SQL, VSS, VBScript, XHTML, XML, Windows 2000/2003 Server.