SUMMARY:

• An SQL developer with 8+ years of extensive experience in Database Solutions and 6+ years of BI Solutions using Microsoft Technologies.
• Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2008/2012/2014 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS)
• Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL
• Excellent knowledge of performance tuning in stored procedures and queries, using tools like SQL Profiler, Execution Plans, Database Tuning Advisor, DMV’s with efficient coding standards.
• Experienced in creating SSIS Packages for integrating data using both heterogeneous and homogenous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Strong knowledge and experience in error handling of SSIS packages. using transactions, check points (package restart ability features), break points and error logging procedures.
• Highly experienced in full cycle of DTS/SQL server integration services (SSIS 2008/2012/2014 ) Packages (Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing data transfers and ETL Purposes across different servers.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Expert in designing various reports like table format, matrix, dashboards and creating subscriptions using SQL Server Reporting Services (SSRS 2008/2012/2014 ) and BI tools like Excel, Power Pivot/ Power Query and Power BI.
• Implemented Subscription, schedule refresh, data alert utilizing Power BI Gateway.
• Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized (Cascading parameters), TopN, Summary, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2008/2012/2014 .
• Highly skilled in developing OLAP cubes using SSAS 2008/2012/2014, calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling, DSV diagrams, Fact and Dimensions Tables using Analysis Services.
• Developed cubes using Partitions, added the Key Performance Indicators (KPI), partition aggregations, Perspectives, slow changing dimensions etc. and created various user roles.

TECHNICAL SKILLS:

BI Tools: SSIS, SSAS, SSRS, QlikView, SSDT (BIDS), Business Objects, Power BI, Power Pivot, Power Query, Visual Studio, Crystal Reports 9.0, Teradata, Performance Point Server, ProClarity, SQL*Plus, SQL*Loader, Erwin Data Modeler, JasperSoft Studio.

Databases: SQL Server 2008/2012/2014, MySQL, Oracle 10g, 11g.

Operating Systems: Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional

Application package: MS Office Suite, Visio, Power BI

Languages: T-SQL, PL/SQL, C/C++, HTML, XML, C#.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Team Foundation Server (TFS)

Protocol: FTP, TCP/IP, Named Pipes

PROFESSIONAL EXPERIENCE:

Confidential, Cedar Rapids, IA

SQL/BI Developer

Responsibilities:

• Responsible for Design, Development and testing of SSIS Packages to load data from various Databases and Files.
• Implemented batch processing using Jobs and DTS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using SSIS.
• Data migration (import & export - BCP) from Text to SQL Server.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server, Oracle, DB2 etc.).
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Designed the user interface screens and implemented application logic under the Microsoft .NET framework using C# to use .NET features powered with CLR.
• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes Meeting User Needs and Requirements from both technical and strategic views of an organization.
• Successfully tested all task in staging and stored all versions of data using Team Foundation Server (TFS).
• Involved in Mock testing, Unit Testing and Integration testing in SSIS, SSAS.
• Use Power BI Desktop to connect to SSAS cubes (live connection) or directly to database tables (Direct Query Mode) or to flat file sources (Import mode). Design reports based on business requirements. Deploy the reports to Power BI Service Workspaces to create Dashboards for consumption by end users.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports, Cross Tabs, Drill down reports using SSRS.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points. Developed BI solutions using Power Query.
• Gathered the requirements from the clients and designed Dashboards and Scorecards making sure the response time isn’t affected

Environment: MS SQL Server 2014/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Oracle 10g, Power BI, Power Query, SSMS, Team Foundation Server (TFS), SQL Server Data tools, Business Objects, SharePoint 2012.

SQL /BI Developer

Responsibilities:

• Involved in Framework development for ETL Implementation and support for the Analytics and Reporting needs for various customers
• Used SSDT to design SSIS packages to transfer data between servers, load data (Excel layouts) into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Created SSIS script tasks, Lookup transformations and Data flow tasks using C# and VB scripts and other transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.
• Using Power BI as a front-end BI tool and Microsoft SQL Server 2012 as a back-end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views. Also modified and created Joins to Improve the Database execution speed.
• Designed and Developed matrix, tabular and parametric, Drill down and Drill Through reports with Drop down menu option using SSRS and scheduled to generate all daily, weekly, monthly and quarterly Reports including the current status.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View to visualize reports.
• Strong knowledge of managed claims management process, Knowledge of Medicaid and Medicare Services. CMS, Health Assessment Systems, Hl7 Standards, HIPAA, PPACA (Patient Protection and Affordable Care Act), Compliance issues, HL7 Message Validation, ICD 9, Electronic Health Records, Electronic Medical Records.
• Involved in Mock testing, Unit Testing and Integration testing in SSIS.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SSAS and DAX was used to create calculated measures and calculated fields.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services ( SSAS ).
• Developed various dashboards using Power BI to facilitate informed decision making.
• Used Team Foundation Server (TFS) for source control, and data collection.

Environment:: SQL Server 2012, SSIS, SSRS, SSAS, SSDT, Teradata, Visual Studio 2012, Erwin 4.0, QlikView, Power BI, Power Pivot, MS Excel 2010, C#, Team Foundation Server (TFS), Windows Server 2010.

SQL Developer/SSIS/SSRS

Responsibilities:

• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Created SSIS package to check XML file validation and data validation to match the requirements and to transfer XML file data into SQL server database.
• Used SSIS for ETL processes to populate data from various data sources, creating packages for different data loading operations for application.
• Improved performance of SQL server queries using joins, sub queries, query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Worked with SQL server profiler to generate traces.
• Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.
• Used SQL server BIDS to design SSIS packages to transfer data between servers and deploy the data.
• Scheduled the job to do this task periodically creating and modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Deploying and scheduling reports using SSRS to generate all daily, weekly, and monthly and Quarterly Reports including current status.

Environment: MS SQL Server 2008, SSIS/SSRS 2008, Visual Studio 2008/2010, C#, SQL Server Profiler, SSMS, Business Intelligence Development Studio (BIDS)

SQL BI Developer

Responsibilities:

• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• 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 to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file and CSV files to data ware house by using BIDS.
• Deploying and scheduling Reports using SSRS/Crystal to generate all daily, weekly, monthly and quarterly Reports including status.

Environment:: Windows server 2008/2008R2, MS SQL Server 2008/2008R2, SSIS, SSRS, BIDS, Oracle, Microsoft Outlook, Team Foundation Server (TFS).

SQL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Actively participated in gathering of Requirement and System Specification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Wrote Transact SQL utilities to generate table insert and update statements.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE)
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2008/2005, T-SQL, .Net, Microsoft Framework 2.0, Erwin, MS Visio.