PROFESSIONAL SUMMARY

• 7 years of experience in working with MS SQL server, SSIS, SSRS, SSAS, Tableau.
• Expertise in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Optimal Performance.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Experience in data migration (using tools like Bulk Insert, DTEXEC and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server.
• Expertise in creating SQL server Reports using SSRS.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill - down, Top N, Summary and Subreports and formatting them.
• Experience in Diagnosing and Troubleshooting performance issues in SQL using DMV’s and DTA.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Optimal Performance.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, creating databases/File groups/files/Transaction Logs.
• Experience in upgrading SQL Server software to new versions and applying service packs and hotfixes and unattended Installation.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity for the Relational Database Model implementing as per business requirement.
• Involved in administration tasks such as disaster recovery with Backup and Restore Strategies, Data Loading, Batch Jobs, Data Unloading, Upgrades, Creating Databases, Files, Filegroups, Transaction logs, Clustering, Replication, Data Mirroring, Linked Servers, SQL Profiler, Log Shipping and Re-Indexing
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C, C++, SQL, T-SQL, PL/SQL.

Operating Systems: Windows Server 2003, Windows 2000 advanced server, Windows Server 2012 R2

Databases: MS-SQL Server 2016/2014/2008/2005/2000, MS-Access 97 & 2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS)

Scripting: HTML, DHTML, Shell Scripting

Reporting Tools: SSRS, SSAS, Crystal Reports, Tableau, VB.Net

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Created and executed SQL Server Integration Service bundles to populate information from the different information sources, made bundles for various information stacking operations for some applications.
• Created SSIS Packages utilizing SSIS Designer for sending out heterogeneous information from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS bundles to SSIS bundles and changed the bundles with new highlights of SQL SSIS.
• Designed and executed Parameterized and falling parameterized reports utilizing SSRS.
• Used SQL Profiler for investigating, checking, and enhancement of SQL Server and non-creation database code and in addition T-SQL code from engineers and QA.
• Backing up, reestablishing framework and different databases according to necessities, and furthermore booked those reinforcements.
• Used SQL Server Profiler to follow the moderate running questions and attempted to Optimize SQL inquiries for enhanced execution and accessibility.
• Created the records on segments having high selectivity and low thickness to accelerate the execution of information recovery inquiries and put away techniques.
• Identified, tried, and settled database execution issues (observing and tuning) to guarantee database streamlining.
• Used to extract all the Eligibility Files like 837, 835, 999 and 834 from Facets and the used to migrate the data according to client requirement.
• Checked the ISA Segments, Elements, and Loops etc. for ANSI X12 Format as per HL7 implementation guidelines.
• Configured HL7 ADT and Scheduling interfaces in Epic Bridges.
• Analysis and manipulation of EDI data to conform to ANSI X12 Standards (Examples: construct rules in Paper free to calculate HCPCS and splitting diagnosis codes to the correct qualifiers).
• Ensured all data sent to HEDIS software vendor are accurate and meet HEDIS reporting timeline.
• Created Ad-hoc reports, Tabular reports, Drill down and Drill up reports.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Delivered the last SSRS Report utilizing the Request Handler.
• Partially engaged with framework study and database planning.
• Created DTSX Packages to import and fare information from Excel Spreadsheets, People Soft, text records and CSV documents.
• Created perspectives to diminish evident database multifaceted nature for end clients and keeping touchy segments from being chosen.
• Identified, tried, and settled database execution issues (checking and tuning) to guarantee database improvement.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created reports in Power BI portal utilizing the SSAS Tabular via Analysis Connector.
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.

Environment: MS SQL Server 2016/2014, T-SQL, VB.Net, DTS, SSAS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Server Query Analyzer, MDX, SQL Server BIDS, MS- Visual Studio 2013.

Confidential , Montgomery, A

SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed complex projects in T-SQL, composing Stored Procedures, Triggers and Queries with best execution design.
• Conducted database administration, execution estimation and execution tuning for new databases and existing databases by utilizing SQL Profiler, Data Engine Tuning Advisor and record tuning wizard.
• Generated occasional reports in view of the factual investigation of the information utilizing SQL Server Reporting Services (SSRS).
• Rewrote SQL questions to redesign SQL Server execution utilizing SQL Server 2014/2008
• Created User Defined Functions to epitomize much of the time and ordinarily utilized business rationale making the framework more measured, secured and extensible.
• Defined Check imperatives, Business Rules, Indexes, and Views.
• Optimizing Stored Procedures and long-running questions utilizing ordering methodologies and inquiry advancement strategies.
• Used the SSIS Import/Export, relocated the Heterogeneous Database, for example, Oracle and Access database, level documents to SQL server 2014.
• Managed up degree of DTS bundles to SSIS bundles
• Responsible for creating, observing and conveying SSIS bundles.
• Configured SQL mail operator for sending programmed messages when a SSIS bundle is fizzled or succeed.
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Report utilizing RDL.
• Created questions for creating drill down reports in SSRS 2014. Organized the reports utilizing the Global factors, articulations and Functions.
• Created Linked Servers to associate OLE DB information sources and suppliers.
• Designed different reports utilizing diverse detailing highlights, for example, amass by and penetrate through and so on.
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.

Environment: SQL Server 2014/2008, Query Analyzer, VB.Net, SSIS 2014, T-SQL, Excel, Microsoft SQL Reporting Services 2014(SSRS), SSAS 2014,Ab Initio, Oracle 10g. Analysis Services (SSAS), DTS, T-SQL, Windows Server 2012 R2, XML, MS Excel, MS Access.

Confidential, Ft Worth, TX

SSIS/SSRS/SSAS Developer

Responsibilities:

• Created and executed SQL Server Integration Service bundles to populate information from the different information sources, made bundles for various information stacking operations for some applications.
• Created SSIS Packages utilizing SSIS Designer for trading heterogeneous information from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS bundles to SSIS bundles and adjusted the bundles with new highlights of SQL SSIS.
• Designed and actualized Parameterized and falling parameterized reports utilizing SSRS.
• Used SQL Profiler for investigating, observing, and advancement of SQL Server and non-creation database code and in addition T-SQL code from designers and QA.
• Backing up, reestablishing framework and different databases according to prerequisites, and furthermore planned those reinforcements.
• Used SQL Server Profiler to follow the moderate running questions and attempted to Optimize SQL inquiries for enhanced execution and accessibility.
• Created and repaired information associations, information sources and Data Source Views.
• Deployed and transferred the SSRS reports to SharePoint Server for the end clients to take a gander at them.
• Modified current database by including tables, adjusting referential trustworthiness and connections to help online framework.
• Used ETL (Extraction, Transformation, Loading) from heterogeneous source frameworks. Helped DBA in utilizing the store supervisor to offer authorizations to clients to make new clients and archives.
• Created DTS Packages and changed over DTS bundles to SSIS 2012/2010
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.

Environment: SQL Server 2008/2012, Query Analyzer, SSIS 2012, T-SQL, Excel, Microsoft SQL Reporting Services 2012 (SSRS), SSAS 2012,Ab Initio, Oracle 10g. Analysis Services (SSAS), DTS, T-SQL, XML, MS Excel, MS Access.

SQL BI Developer/SSIS/SSAS/SSRS

Responsibilities:

• Involved in User Requirement Gathering and Technical Specification Documentation.
• Involved in Designing of the logical and physical database
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Creating transactional and merge replication on different servers.
• Performance tuning at Database level, T-SQL level and operating system level.
• Trouble shooting Problems by using SQL server profiler.
• Creating DTS packages to maintain central repository by extensively using different SQL2012/2008 DTS tasks.
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, and flat file, XML in order to create and maintain a centralized data warehouse.
• Plan and implement data roll-up from live site to data warehouse.
• Created reports using Crystal Reports using imported data sources.
• Generated various reports using Crystal Reports.
• Resolving the bugs in the database.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2012/2008, DTS, Crystal reports, .Net Framework1.1, ASP.NET, C#.NET, VSS, IIS 6.0, Windows XP

Confidential

SQL Developer/SSIS/SSRS

Responsibilities:

• Designed, coded, tried and executed UIs, strategies and capacities for new and existing programming application prerequisites.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Install, tune, keep up and screen SQL Server for the Production condition
• Created DTS bundle to get information from various sources, unite and converge into one single source.
• A created assortment of reports for business to give them basic data about business status.
• Actively associated with Normalization and De-standardization of the database.
• Created complex factors, numerous breaks, sorts in the reports.
• Created nonspecific Measure class for bland measures, and made a separate class for restrictive items.
• Involved in System testing.
• Decided upon the locking methodology that could be utilized for different bunch Programming structures and Transactions.

Environment: SQL Server 2008 Enterprise Edition, Enterprise Manager, ERWIN, UML, MS Project, Windows 2005 Server, SSIS, SSRS,SSAS

Confidential

SQL Data Analyst

Responsibilities:

• Responsible for making Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures and Triggers
• Was associated with composing Triggers and Stored Procedures.
• Actively associated with Normalization and De-standardization of the database.
• Was associated with execution tuning of the Database
• Used SQL Profiler and Data Base Engine Tuning Advisor to execution tune the Database.
• Scheduling Jobs and Alerting utilizing SQL Server Agent
• Created User logins at the server level.
• Created logins, parts, and gatherings to the Window NT and MS SQL Server and keeping up legitimate security methods.
• Developed custom reports utilizing Microsoft revealing Services.
• Created Stepped and Block reports utilizing Microsoft revealing administrations
• Created Drill Through and Various Cross selected reports utilizing Microsoft revealing administrations.

Environment: MS SQL Server 2008, DTS, Crystal reports, .Net Framework1.1, ASP.NET, C#.NET, VSS, IIS 6.0, Windows XP