PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Installation, Configurations, Implementation and Administration of MS SQL Server 2012/2008/2005/2000 in Production, Test and Development Environments.
• Extensive experience and detailed knowledge of Healthcare.
• Extensive knowledge of RDBMS (Relational Database Management Systems).
• Experience in creating Tables, Views, cursors, stored procedures, functions and database triggers.
• Very good at designing Snow flake and Star schemas.
• Hands on experience with focus on Database design and Development using different tools of ER diagram, Normalization techniques, Confidential - SQL (DDL and DML) Coding and installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008 in Windows Environment.
• In-depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables.
• Very good experience in creating Package Configuration for SSIS packages.
• Hands on experience in creating SSRS reports, dashboards, scorecards for business and MS Excel Power View.
• Very good in implementing security, configuring subscriptions for SSRS reports.
• Good at fine tuning SSAS cubes, designing aggregations, creating partitions on measure groups, writing calculations (Named sets, Scope and Calculated members).
• Experience in creating and using of variables, fields, and calculated expressions, aggregated functions, joins, concatenation and mappings using QlikView.
• Very good at defining relations between dimensions and fact tables in SSAS DSV.
• Extensive experience in Database Designing such as Logical and Physical Data Modeling using Erwin and Microsoft Visio.
• Involved in designing, developing, testing, publishing, maintaining and supporting QlikView and QlikSense applications.
• Experience in using Performance Monitor/Profiler to monitor and solve performance issues like long running queries. Good experience with Execution plans and optimizing the queries.
• Hands on experience with Database Engine Tuning Advisor, creating and rebuilding Clustered and Non- Clustered Indexes.
• Installation and configuration of Microsoft SQL Server. Involved in creating Linked Servers between SQL Servers and other Heterogeneous environment
• Worked in creation of Technical Requirement Documents (TRD), Rough Order of Magnitude (ROM), Requirement Traceability Metric (RTM).
• Experience in maintenance of Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in Database Backup and Recovery procedures.
• Experience with QlikView Sheet objects including various charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Good experience in Database consistency checks using DBCC commands.
• Experience in implementing different types of Replication models like Snapshot and Transactional and Merge.
• Good at implementing Log Shipping and Database Mirroring.
• Involved in SQL server Clustering (Active/Passive Clustering).
• Good team player, optimistic, strong interpersonal and communication skills.

Education: Bachelor’s in Mechanical Manufacturing and Management

TECHNICAL SKILLS:

Operating Systems: Windows XP,2003,2000,9x,vista

RDBMS: SQL Server 2005/2008/2012, Oracle 9i/8i

Languages: Confidential -SQL, Pl-SQL, C, C++

Database Tools: Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, Business Intelligence Development Studio(BIDS), SQL Server DTS, SAS Enterprise minor 13.1, SAS Enterprise guide 9.1, SAS Sentiment Analysis studio

Reporting Tools: SQL Server Reporting Services 2012, 2008, 2005, Excel.

Tools and packages: MS Office, Visio, Adobe Photoshop, MS Excel, MS-Project 2000,SSIS, SAP, Oracle Crystal ball, Auto cad, ANSYS simulation software, Power BI, ARENA simulation, Control-M, Mingle, Qlikview, Tableau.

Web Technologies & Others: MS Front Page 98/2000, MS Office 2000/XP, HTML, XML, PHP, JavaScript, ASP.NET, VB.NET

WORK EXPERIENCE:

Confidential, Las Vegas

MICROSOFT BI/ETL DEVELOPER/DBA

Responsibilities:

• Working closely with Architects to develop Logical data Modeling Report solutions and potentially ETL packages.
• Building reports for business decision makers and creating ETL packages in a Microsoft environment.
• Focused on delivering EDW and BI related deliverables which includes a number of complex reports.
• Part of the Data Management team which includes Database Administration to Data Warehouse Architecture.
• Creating variety of reports for business to provide them with critical information about business status.
• Scripted complex stored procedures that read data from multiple sources in several databases and servers.
• Experience in Code Optimization and improving efficiency in databases including indexing, Recompiling Stored Procedure, user defined functions and performing other maintenance tasks.
• Involved in writing stored procedures using TSQL in management studio that are used for generating reports.
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Ability to prioritize deliverables and tasks across multiple clients and experience working with multiple client database and systems.
• Reviewed & Tested stored procedures, fixing bugs (if any) using Microsoft SQL Server Management Studio.
• Experience defining and building audits and controls to ensure the accuracy of the data.

Environment: Microsoft SQL Server Management Studio, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), SQL Server 2014/2012, TSQL, Microsoft excel.

Confidential, Winston-Salem, NC

MSBI Lead DBA/Developer

Responsibilities:

• 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.
• Designed and developed SSIS Packages to import and export data from MS Excel using Power BI, SQL Server 2008 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building physical models, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Filter and Sorting Data using Power View in Excel 2013.
• Developed various types of Power Pivot reports like Drill Down, Drill through, Cross tab reports.
• Developed dashboards which included charts (straight table, pivot table, pie chart, gauge chart) using Power BI.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Involved in development of dashboard with QlikView development checklist.
• Existing Qlikview data-model applications are used in qliksense by using the Binary load and using session log files on the qliksense server, tracked down the usage of the applications.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Created named sets, calculated member and designed scope in SSAS.
• Served as DBA in the completion of implementations, managing projects from business requirements analysis to solutions delivery and support.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports for generating Confidential reports as per the client requirements.

Environment: SQL Server 2012/2008 R2/2005 Enterprise Edition, SQL Server Data Tools, SQLServer Business Intelligence Development Studio (SSIS, SSRS), TSQL, C#, Qlikview, XML, MS Visual Source Safe and Windows Server 2003, Power BI.

Confidential, Akron, OH

SQL DBA

Responsibilities:

• Extracted data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in daily loads into Staging and DW areas, troubleshooting process issues and errors.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Cooperated with DBA team to create Scheduled Jobs to run the SSIS packages.
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Extracted data from different systems transformed and integrated in the QlikView.
• Created Data-driven Packages in SSIS 2008 as part of the automating the process for the Referral Process.
• Developed QlikView Dashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Assess the risks and recommend/ install service packs or hotfixes when needed.

Environment: SQL Server 2005 and SQL server 2008, SSIS, SSAS, Qlikview, Import and Export tools, SQL Server Agent, MS Access, and Confidential -SQL.

Confidential, Oklahoma city, OK

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed ETL packages with different data sources (SQL Server, Flat Files) and loaded the data into SQL reporting database by performing data mapping and data transformations using SQL Server Integration Services (SSIS).
• Designed and implemented ETL processes using SSIS 2005/2008/2012 with complex transformations like conditional splits, multicasting and audit to load data into data warehouse and data marts using star schemas.
• Migrated packages from development server to production server using package configuration.
• Extracted data using SSIS packages from SQL server source and exported them as excel and flat files to the users.
• Created several database objects like UDFs, indexed views, clustered and non-clustered indexes.
• Designed mapping and cleansing to deliver the data to the data warehouse from the data sources by profiling and massaging data in the source databases and files as well as creating a staging database to ensure that accuracy of data pushed to the relational warehouse.
• Responsible for logic implementation into the reports based on the healthcare standards for providers (physicians/departments/clinics).
• Created subscriptions to schedule reports to run on daily/weekly/monthly basis as per the customer requirements and deliver PDF/Excel reports to their inbox or to the network folders.
• Experience in building OLAP data warehouse solutions, design, and implementation; Created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created partitions for large measure groups in SSAS.
• Created data-related documentation (e.g. file descriptions and definitions, entity relationships and attributes, etc.). Created ER Diagram for the relational tables using Erwin.
• Involved in setting up the Development and Production Environments for QlikView.
• Knowledge and fair experience with Qlikview and Tableau dashboard reporting tools.
• Experience with business and technical requirements gathering, business process analysis, project planning/project tracking and task allocation.

Environment: SQL Server 2008 R2,SQL Server 2012, SQL server 2005, SQL, Confidential -SQL,PL/SQL,SQL Profiler, Erwin/Visio, SSIS, SSRS, SSAS, Visual Studio 2010/2012,Windows 7, MS Office, Windows Server 2008 R2, Report Builder, MS Excel 2010, MS Access 2008, Control-M, Mingle, Qlikview, Tableau.

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Designed application that collects client transaction volumes for WSS Custody and Sub
• Custody products, applies unit costs, and produces a monthly export to the Confidential &SS Costing system.
• Created Volume Automation to enable import and maintain unit costs and other reference data, as well as providing summarized MIS reports for administrative/integrity purposes
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement.
• Created and Modified Confidential -SQL stored procedures/triggers to validate integrity of the data.
• Created DTS and SSIS packages.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created ETL package for data conversion using various transformations tasks.
• Created dashboards to show the business performance.
• Created custom reports which had cascaded parameters using SSRS/SQL Server BI studio.
• Created Ad hoc reports using SSRS.
• Created reports that call Sub reports in SSRS.
• Created datasets for reports using Confidential -SQL and stored procedures.
• Responsible for Query optimization and Performance tuning.

Environment: Microsoft SQL Server 2005, SQL profiler, SSIS 2005, SSRS 2005, SSAS 2005, Visual Studio 2005/2008, Microsoft Office SharePoint 2007, windows 2003/XP/vista,.NET Framework, C#, VB, ASP.NET, ADO.NET.

Confidential

SQL Server Developer

Responsibilities:

• Designed, coded, tested and implemented user interfaces, procedures and functions and existing software application requirements.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Worked with technology features in SQL Server such as Partitioning, File Groups, Replication, Materialized Views, and Options available in executing database statistics.
• Install, tune, maintain and monitor SQL Server for the Production environment.
• Created variety of reports for business to provide them with critical information about business status.
• Created stored procedures for datasets in SSRS reports to run calculations at database level.
• Wrote expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Materialized views, dimensions and stored outlines for optimal performance.
• Involved in Normalization & De-normalization of database.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Involved in System testing.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005 Enterprise Edition,.NET Framework, XML, Confidential -SQL, SSIS 2005,SSRS, SSAS,VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access. Visual Studio 2005