SUMMARY

• 8 years of Extensive experience in MS Business Intelligence development/data warehousing and expert in leveraging the full stack including SQL server, SSRS, SSIS, SSAS, DAX, POWER BI and Data Transformation Services (DTS).
• Expert in developing new databases of all areas of SQL Server including user views, Stored procedures, functions, triggers, indexes, clustering, relational database models, data dictionaries, Backups, Recovery, common table expressions (CTEs), and data integrity.
• Experience in ETL (Extracting, Transforming and Loading) data from Flat file, Excel, Oracle, XML to MS SQL Server by using SSIS services.
• Specialized in creating and configuring SSIS solutions for elevated performance Data Integration, Business Intelligence Process and Data Migration which consist of Merging Data from various Populating Data Warehouses, Cleaning, Data Marts, Heterogeneous Data Stores and Standardizing Data.
• Experience in handling Debugging, Error logging, Error Handling and Production support for SSIS.
• Intense ability in generating drill through reports, drill down reports, handling parameterized reports and creating sophisticated report layouts in SSRS.
• Expert in providing Enterprise Reporting solutions using Crystal Reports, Performance Point Server, SSRS, Qlikview.
• Experience in migrating and upgrading Analysis Services(SSAS).
• Expert at accessing and analyzing Dimensions and Cubes using star schema to achieve the productivity of SQL server.
• Experience in using Data Analysis Expressions (DAX) functions for the Reports and for the Tabular Models.
• Developed and designed new SSAS Tabular models in memory engine.
• Specialized in Creating Power View Reports using the Tabular SSAS models in Excel.
• Expert in system study and testing Health Care, Banking applications developed on various technologies like TRIZETTO QNXT, SQL Server on Windows, and SharePoint.
• Specialized in Processing TRIZETTO QNXT Healthcare Claims (Professional & Institutional) in PORTAL with valid TPI.
• Expert in Different data formats used in healthcare like CCDA, CCR, X12,HL7 and NCPDP.
• Expert in using POWER BI tool and prepared dashboards using Tableau to make it more attractive.
• Experience in creating reports in POWER BI preview portal utilizing the SSAS Tabular through Analysis connector.

TECHNICAL SKILLS

Data Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), DTS, Crystal Reports 9.0/XI, ProClarity, Performance Point Server.

Languages: T - SQL, VB scripts, .NET, Visual Studio, C, Java, Oracle and UNIX Shell Script.

Operating Systems: Windows Vista x64/x86 Enterprise, Windows advanced server, Windows NT 5.2, UNIX, LINUX.

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

BI Tools: POWER BI, QlikView, Tableau, Cognos.

Software: MS Office, Visio, Adobe Photoshop, MS Excel, MS-Project.

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

• Fixed bugs in SQL processes that loads data into the data warehouse.
• Created complex queries to build views for salesforce application that in turn offered a dashboard format for asset Management.
• Reviewed data warehouse jobs and processes to fix missing data.
• Created jobs, stored procedures, views to fix long load times and bugs.
• Engineered process to obtain DB backup from cloud provider, restore it and load translogs to give a near real time DB on servers.
• Created and Maintained replication process from one server to another server.
• Moved entire DB process from one server to another server as business demands requested.
• Documented all jobs, views, store procedures, tasks and replication process.
• Created SSIS packages to restore full backup up every morning and to restore log files for every 30 minutes.
• Created stored procedures to extract data from various files like .xls, .lro, .csv and then insert into tables.
• Worked on many different files source files like Level1, LTS, LRO, Salesforce files.
• Created maintenance plan to update statistics, triggers, schemas and to take a full backup, differential backup and then scheduled them to run at particular time.
• Performed Performance Tuning in SSIS packages by using Block, Unblock and Row Transformations.
• Managed Package Configurations, Event Handling, User-defined Variables and Logging System on SSIS Packages.
• Implemented and Designed Replication solutions for SQL Server 2008 r2/2012 using Enterprise Manager.

Environment: Microsoft SQL Server 2008r2, Visual Studio 2012, DB2, Performance Point Server, C#, Microsoft Visual Basic, VBScript, XML, Microsoft Visio.

Confidential, CA

Sr. SQL Database Developer

Responsibilities:

• Worked on Partition Tables based upon Partition Schemas Partition and Functions.
• Engaged in developing dashboards and Tableau visualizations using Tableau Desktop.
• Worked in Extracting, Transforming and Loading data from Flat file, Excel, Oracle, XML to MS SQL Server by using SSIS services.
• Designed and developed SQL SSIS Packages to extract data from various data sources like Access database, Excel spreadsheet, and flat files into SQL server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created SQL server Reports using SSRS.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Worked on SSRS server to expose reports in other contexts like K2 Workspace.
• Write Complex SQL Scripts to load the relevant Data in QlikView Applications.
• Develop load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match).
• Designed tools and then import reports into K2 Workspace Report Designer.
• Worked on K2 designer which consists of forms, views and smart objectives.
• Created work flow in K2 black pearl allowing process rights.
• Worked on retrieving and storage data forms on K2.
• Worked on creating named query in SSAS Data Source View to get hierarchical summarize data for two dimensions.
• Engaged in detailed and advanced requirements gathering for POWER BI projects and statements of work.
• Created and maintained technical writing and guidelines for POWER BI Solutions and statements of work.
• Created MDX expressions to validate data in cube.
• Created and debugged data connections, data sources and Data Source Views.
• Migrated data from text files and Excel spreadsheets to SQL Server databases.
• Designed SSAS Tabular models in memory engine.

Environment: Microsoft SQL Server 2014, Visual Studio 2014, DB2, Performance Point Server, C#, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, POWER BI.

Confidential, MD

Sr. SQL SSIS Developer

Responsibilities:

• Worked in writing complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Involved in Creating Indexes for quick retrieval of information.
• Worked on Performance tuning and Optimization of query using execution plan.
• Performed event handling adequately to generate logs and audits for the generated SSIS packages.
• Worked on archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Experience in handling Debugging, Error logging, Error Handling and Production support for SSIS.
• Worked in system study and testing applications developed on TRIZETTO QNXT technology.
• Performed in Processing TRIZETTO QNXT Healthcare Claims (Professional & Institutional) in PORTAL with valid TPI.
• Involved in Maintaining and Entering providers’ data like additions, updates, audits, benefit types, enrollment period and eligibility, network coverage, and terminations) in the TRIZETTO QNXT system(s).
• Involved in EDI X12 transactions and flat file conversation Mainframe to Integrator v4.3. Maintain documentation such as paper maps and system workflow.
• Worked in Different data formats used in healthcare like CCDA, CCR, X12,HL7 and NCPDP.
• Worked in Editing reports related to provider setup (Pending Claims for provider information etc.).
• Performed store procedure function and Troubleshot member records when a flag is revealed in the process of Confirming members’ eligibility during bulk loading and ensure member.
• Migrated data from SAS environment to SQL Server 2012/2014 with SQL Server Integrated Services (SSIS).
• Involved in creating logging for ETL load at task level and package level to log number of records processed by each task and each package using SSIS.
• Created packages to convert txt files to XML files.
• Responsible for Scheduling Jobs, Maintaining, Alerting and Deploying SSIS packages.
• Involved in Creating Cascaded, Cross-tab, Parameterized, Drill-through and Drill-down Reports using SSRS 2012/2014.
• Developed Report Models for building Ad hoc reports using Crystal Reports.
• Experience in creating reports in POWER BI preview portal utilizing the SSAS Tabular through Analysis connector.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports in Qlikview.

Environment: MS SQL Server 2012/2014, MS Access, Performance Point Server, MS SQL Analysis Services 2012/2014, MS Excel, Visual Studio 2012/2014, Windows Server 2012, TRIZETTO QNXT, Crystal Reports, Excel.

Confidential, L.P, P.A

SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in designing, developing and analyzing the data warehousing applications.
• Created DTS packages for the data cleansing/transfer and transformation.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Worked on Extracting, Transforming and Loading (ETL) data and Import, Export them by DTS package.
• Performed Performance Tuning in SSIS packages by using Block, Unblock and Row Transformations.
• Managed Package Configurations, Event Handling, User-defined Variables and Logging System on SSIS Packages.
• Implemented and Designed Replication solutions for SQL Server 2008 r2/2012 using Enterprise Manager.
• Developed SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting
• Involved in SQL statements, queries, triggers and stored procedures.
• Performed modifications on the present stored procedures to meet recent design.
• Created indexed views, and appropriate indexes to cut the complex query time.
• Provided day-to-day administration tasks like space and log management.
• Developed Recovery Strategies, Backup and Disaster Recovery Plan.
• Involved in Creating Cascaded, Cross-tab, Parameterized, Drill-through and Drill-down Reports.
• Involved in creating Dashboard Reports to support end users using SSAS.
• Upgraded and migrated SSAS.
• Worked on Database, database tuning, performance planning, backup planning and database administration.
• Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, T-SQL, Crystal Reports 7/8, Windows 2012 Advance Server, VB.NET, MS Excel, and MS Office.

Confidential, OH

SQL SSAS/SSRS Developer

Responsibilities:

• Provided Database Administration and Development of SQL server at Confidential in support of a financial distributed.
• Replicated storage system with a multi-terabyte data store, installation of Oracle Financial accounting package, and evaluation of SQL Server 2008.
• Involved in design, development and implementation of SSIS, SSRS and SSAS.
• Developed SQL SSIS Packages to withdraw data from various data sources such as flat files, XML, and Excel into SQL server 2008 r2 using different transformations like sort, derived column and aggregate transformations.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler.
• Worked on upgrading/changing all the database objects from 2005 to make them compatible to the schema changes in 2008 r2.
• Performed restore and backup, database objects like indexes, tables, triggers, procedures, constraints and views.
• Created and configured SSIS solutions for elevated performance Data Integration, Business Intelligence Process and Data Migration.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used multiple join statements to get back the data from multiple tables.
• Created stored procedures, triggers, views, functions like user defined to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Designed and implemented parameterized reports, Drill Down, Drill Through reports for Confidential organization through SSRS.
• Developed SQL mortgage reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports.
• Developed Star schema using SSAS cubes.

Environment: SQL Server 2008 R2, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), C#, XML, SSMS, MS Excel, Oracle, Toad.

Confidential, Houston, TX

SQL SSRS/SSIS/SSAS Developer

Responsibilities:

• Created Tables, Non-Clustered, Clustered, Databases, Constraints, Stored Procedures Triggers and Views.
• Performed SQL Errors like Scheduling, Logging, activity/eliminate, Tasks/database, Blocking & deadlocks user counts and connections/locks etc.
• Developed packages using SSIS by implementing the infrastructure which enables variables, execution order, logging and event handling.
• Created ETL for data Transfer and Migration.
• Developed custom reports using SSRS/SQL Server BI Studio.
• Created Stepped and Blocked reports using SSRS.
• Created Drill Through and Various Cross tabbed reports using SSRS.
• Build the cubes using SSAS.

Environment: SQL Server 2008 Enterprise Edition, Enterprise Manager, MS Project, Windows Server, .NET, C#, ASP.NET, SSIS, SSRS, SSAS.

Confidential

SQL Server Developer

Responsibilities:

• Performed in the SDLC (Software Development Life Cycle) processes including programming, Analysis, testing, design, and Documentation.
• Responsible for MS SQL Server Installation and configuration, applied service packs and hot fix.
• Used Enterprise Manager IN SQL Server and Analyzer like Query analyzer to administer Server(SQL).
• Involved in creating tables, non-clustered, clustered indexes, Databases, Index, Constraints, defaults and rules.
• Wrote User Defined Functions and Stored Procedures, and also defined Roles and Privileges to control access to database.
• Created Triggers to enforce data and referential integrity.
• Developed Tabular reports using Crystal Reports.

Environment: SQL Server 2008, Windows NT platform, Crystal Reports 9.0.