SUMMARY

• Around 6 years of strong experience with demonstrated success in the Database Design, development of SQL Server 2000/2005/2008 R 2/2012/2014.
• Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Profound knowledge and ability to write views, temporary tables, indexes, triggers, stored procedures when required and complex queries with complex joins and aggregate functions.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Experience in writing MDX Queries.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• Created many Drill through,Drill Down, Sub reports, Snapshot, parameterized reports etc., using SSRS.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc., and created various user roles (SSAS).
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Good Knowledge in development of reports using QlikView 11.20 and 12.0.
• Created Reports using Power BI.
• Ready to relocate.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Power BI

Database: MS SQL Server 2014, 2012, 2010, 2008 R2, 2005, 2000, SQLCMD, Microsoft Office 2007/2003, MS - Access.

Language: C,C++,HTML,CSS,XML,TSQL,MYSQL,DHTML,VB.NET,ASP.NET,.NET Frame Work, C#, JavaScript

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto-CA

BI Developer

Responsibilities:

• Develop SQL queries for creation of tables in database and verification of data from database.
• Develop schemas for validating the general XML Files.
• Involved in modifying the existing reports in SSRS.
• Create Local Repository using TFS.
• Write Complex Queries, Stored Procedures, Triggers and Functions using T-SQL for SQL Server 2008 R2/2012.
• Create SSIS (ETL) Packages to migrate data from heterogeneous sources such as MS Excel, Flat files, .CSV files.
• Perform the Version Control in TFS to document the Code changes.
• Add SQL Statements as required for the Existing Stored Procedures.
• Designed, Developed, Tested, and Published and maintained Power BIFunctional reports, Dashboards based on user requirements.
• Worked on Power BIDashboard to make some changes on behalf of Business requirements.
• Experience in creating Power BIDashboards (Power View, Power Query, Power Pivot, and Power Maps).
• Script out the hard-coded variables in different schemas.
• Add Action Parameter to Usage Trend Reports.
• Migrate SSIS Packages to TFS.
• Create new SSIS Packages and set up incremental updates.

Environment: SSMS, SSRS, SSIS, TFS, Power BI, Visual Studio, BIDS.

Confidential, Springfield-OR

SQL-SSRS/SSIS Developer

Responsibilities:

• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Responsible to create several tabular reports and drilldown reports using SSRS as per the user requirement and posting the reports in exact synergy.
• Interacted with the Business Analysts for requirement analysis and created Functional Specification Documents based on the business requirements.
• Involved in modifying the existing reports in SSRS and Exact ERP system
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Used various transforms in SSIS to load data from flat files to the SQL databases.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Participated in Databases Architecture and data modeling design.
• Reviewed and developed data models and database designs with development teams.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Power BI Reports and Dashboards.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Created Dashboards based on the designs defined by the executive team.
• Involved in writing documentation for custom work.
• Worked with Exact ERP and developed reports in Exact Synergy.
• Developed various types of reports like Drill down, Drill through and Parameterized reports using SQL Server Reporting Services 2008 R2.

Environment: SQL Server 2008R2 / 2012/2014, Exact Globe and Exact Synergy, MDX, T-SQL, Power BI, MS Access, MS Excel,& SSIS,SSRS,SSAS, TFS

Confidential, Peoria - IL

SQL-SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed complex programs in VB Script, which connects to SFTP server to get the initial data which is in CSV Format, with best execution plan.
• Performed data conversions from flat files into a normalized database structure.
• Involved in maintenance of existingOLTPdatabases as well as designing SSIS packages for custom warehousing needs.
• Extensively worked on OLAP cubes using SSAS.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Involved in writing SQL Queries for pulling large volume of records from Facets and claims database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
• Involved in development and automation of SQL Scripts,
• Dealt with Data migration.
• Created SSIS packages to convert flat file to XML file.
• Created cubes and dimensions (SSAS), MDX Querying for the analysis of sales in specific areas.
• Good understanding of SSRS with Report authoring, created weekly and monthly reports as per requirement using SSRS.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
• Configured mail tasks to know the job status of SSIS packages.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.

Environment: SQL Server 2000/2005/2008 , SQL Query Analyzer, SQL profiler, ERWIN Data Modeler, SSIS, SSRS, SSAS, Power BI, OLTP,OLAP, Visual Studio 2008,ETL, MS Access, MDX, Crystal Reports.

Confidential

SQL-SSIS/SSRS Developer

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Deployed SSIS packages and Reports to Production Servers.
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL Server Analysis Services.

Environment: MS SQL Server 2005, SSRS, SSIS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.