SUMMARY

• 9+ years of professional experience as Microsoft SQL server developer and BI Developer.
• Highly experienced as Database Engineer for Database projects, Finance, Health care, IT and retail Industry
• Experience with SQL Server 2008/2008 R 2/2012/2014/2016
• Good experience in developing ETL packages using SSIS 2008/2008 R2/2012
• Highly experience in designing reports, using SSRS 2008/2008 R2/2012, Report builder.
• Experience in transforming functional requirements to technical specifications.
• Experience in writing SQL queries to manipulate data.
• Experience in relational database concept and query tools.
• Strong experience in performance tuning and troubleshooting expertise, using SQL Server Profiler, Index Tuning wizard.
• Highly experienced in SQL coding, including teh creation of stored procedures, triggers, and SSIS packages.
• Excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For each Loop Container etc.) and various Data Flow Transformations (such as Derived columns, Conditional split, Lookup, Merge Join, Data Conversion.
• Experienced in Deploying SSIS packages using Manifest files and Import/Export Wizard while creating various Configuration Files to make teh packages work in various environments.
• Involved with Performance Tuning of SSIS packages.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database
• Experience in creating jobs, scheduling & automating using SQL Server Agent.
• Expert in writing, testing, and debugging application systems and processes.
• Knowledgeable about other aspects of reporting service such as Report Authoring, Report Management, Report Delivery and Report Security.
• Well versed with diverse types of reports such as Drill down, Drill through, Parameterized, Cascaded parameterized, Linked, Chart, and Sub - reports using SSRS. Created Subscriptions to teh SSRS reports
• Assisted in teh scheduling teh reports to refresh and run on daily, weekly and monthly basis and also deployment of teh reports using Direct deployment and Uploading files using teh Report Manger
• Proficient in Deploying database projects, Integration Services packages, SSRS reports.
• Experience in maintaining security at Database & File level and have skill to recover them back from disasters.
• Have experience in implementing T-SQL coding standards and preparing templates for SSIS packages & SSRS reports.
• Highly experienced in writing test cases and performing unit tests for Database objects, ETL packages & Reports.
• Experience in halping Business users to understand report models and training them to use Report Builder for Ad-Hoc reporting.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2008/2008R 2/2012/2014/2016 , Access 2000/2003

Languages: T-SQL, VB Script, C#, .net

Developer Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, DTS Import/Export, Visual Studio 2005/2008/2010/2012 , Team Foundation Server (TFS)

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

Reporting Tools: SQL Server Reporting Services (SSRS)

Operating Systems: Windows NT/ 98/2000/2003/2007/2010 Server XP/Vista, UNIX, Linux

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. SQL/BI Developer

Responsibilities:

• Written complex stored procedures, User defined Functions, triggers and other database objects using Transact-SQL.
• Created Indexes and tuned SQL Queries & Stored Procedures by using SQL Server performance tools.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables across different databases
• Using SQL stored procedures, functions, and triggers.
• Proficient use of SQL and data extraction methodologies.
• Update data marts and extract data
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Created SSIS packages to load data into Data Warehouse using Various SSIS tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task.
• Designed and implemented database redundancy by implementing referential integrity.
• Generated on-demand SQL reports to address ad-hoc requests from Business Users.
• Developed Drill Down, Drill Through, cascaded Parameterized, Tabular, Matrix & chart reports using SSRS.
• Developed and maintained ETL processes to populate departmental data marts and key data feeds.
• Investigated data issues and recommended realistic solutions based on operational constraints
• Performed data analysis and data mining.
• Automated and maintained current processes to ensure uninterrupted operations using SQL Server Agent.
• Worked in all phases of project Lifecycle and performed object migration across different environments (DEV/QA/PROD)
• Participated in design and code reviews -Fine tuning reporting queries and report implementation to ensure dat teh BI/RDBMS Servers are not impacted adversely
• Created Ad-Hoc Reports, Cached Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports using SQL Server Reporting services (SSRS).
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format teh contents of teh report.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send teh reports via email.
• Worked with various teams like Business Stakeholders, Business Analysts, Application Developers, and Production Teams to identify needs and followed by solution options.
• Installed SQL Server 2008 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2005 to SQL Server 2008 without any service interruption.
• Involved in teh all teh stages of Software Development Life Cycle (SDLC).
• Involved in teh normalization and de-normalization of teh databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2008.
• Wrote teh complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Responsible for monitoring teh progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
• Wrote MDX queries according to teh business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2008 Reporting Services (SSRS).
• Analyzed business requirements, design architecture and built technical specifications.

Environment: MS SQL Server 2012, 2014 SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS) 2012, MS Office 2010, 2013 MS Visio 2010.

Confidential, Richmond, VA

Sr SQL Developer

Responsibilities:

• Analyzed business needs and developed Technical Specifications based on interaction with Managers and Development Teams.
• Involved in teh all teh stages of Software Development Life Cycle (SDLC).
• Troubleshoot and support reports in teh production environment resolve issues and deploy bug fixes in a timely manner.
• Support Production issues on Archiving Job failures which might related to data issues
• Coordinated with business users, application development team on various production issues.
• Involved in teh normalization and de-normalization of teh databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2012.
• Wrote teh complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2012.
• Improved teh performance of teh T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Extensively used DML scripts to perform modification tasks like Insert, Update and Delete data in database tables.
• Developed Many Excel Reports like Power Pivot Table, chart Reports for Data manipulation.
• Created Macros to automate moving and formatting data, and Macros to run financial formulas behind teh Scene.
• Involved in extensive DATA validation by writing several complexes SQL queries and involved in back-end testing and worked with data quality issues.
• Improved teh performance of teh T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in teh packages.
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in teh SQL Server Integration Services packages from OLTP to OLAP.
• Developed Complex SSIS Packages using Proper Control flow and data flow elements.
• Worked with different methods of Logging in SSIS.
• Deployed SSIS Packages into Different Servers by Configuring it.
• Excellent report creation skills using SSRS
• Developed Tabular Reports, Matrix Reports Parameterized Reports Sub reports, Snapshot and Adhoc reports (SSRS)
• Improved teh SSRS Report performance by using different methods.
• Created Standard and Data driven Subscription for SSRS Reports
• Wrote C#, VB.NET Code for Script Task in SSIS 2012
• Also, responsible for transferring data from Production Server to teh Development Server occasionally on Incremental Basis for teh purpose of checking teh consistency in data.
• Used teh WCF services as teh major component in communicating with teh data access layer.
• Implemented WCF Web service for Integration with other Inbound Applications using .Net 4.0, C#, WCF ADO.Net Entity Framework, XML, XSLT, SOAP and SQL Server 2008.
• Created Rest Web Services to communicate between SOAP Web Services and UI.

Environment: MS SQL Server 2012, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS, SSAS), MS-Visual Studio, XML, MS Office 2010, MS Visio 2007, Team Foundation Server.

Confidential, San Jose, CA

Database Developer

Responsibilities:

• Involved in FACETS Implementation Testing, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Validated EDI Claim Process according to HIPPA compliance.
• Worked as a Data analyst to set Facets data in Claims Processing, Members/Subscribers, Groups, Billing for different testing efforts.
• Analyzed teh requirements and selected teh dimensions based on teh analysis requirements.
• Designed Tables, Constraints, Views, and Indexes, and created teh Cubes for Business Intelligence.
• Involved in writing Test Plans for SQL Stored Procedures and User Defined Functions.
• Created Views to facilitate easy User Interface Implementation and Triggers on them to facilitate consistent data entry into teh database.
• Developed teh ETL Process to load teh data from teh mainframe production databases to teh Oracle database models.
• Involved in High-Level Documentation for SQL Server Database Design, Periodic Data Refresh, and Database Upgrades. And finally set standard, guidelines, and best practices based on teh documentation.
• Executed Database Tuning, Performance Planning, Back Up Planning, and Database Administration.
• Participated in teh Normalization and De-Normalization of database along with creating and managed Clustered and Non-Clustered Indexes to improve database performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of teh database servers.
• Designed SSIS packages dynamically dat could run on various Environments by creating XML and SQL Server Configuration Files.
• Experience in SSIS Script Task, Look Up Transformations and Data Flow Tasks using T- SQL and (VB) Scripts.
• Developed OLAP model based on Dimension and Facts for efficient loads of data mainly based on Star Schema.
• Created teh New Dimensions, Shared Dimensions, and Time Dimensions and implemented those dimensions while generating Cubes from SSAS.
• Hold responsibility for teh creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX Queries, Perspectives, KPI’s, Scorecards and Dashboards.
• Created Partitions and designed various Storage Modes to increase teh performance of cubes using SSAS.
• Involved in Scheduling, Creating Snapshots, Creating Report Subscriptions and Data Driven Subscriptions.
• Developed MDX Scripts to create datasets to generate various reports which included Interactive Drill Down Reports and Report Models.
• Documented all processes involved in maintaining teh database for future reference.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, TSQL, Business Intelligence Development Studio (SSRS/SSIS/SSAS), Oracle 9i, XML, Windows 2003 Server, Microsoft, SQL Profiler, OLAP

Confidential

SQL Server Developer

Responsibilities:

• Worked with various teams like Business Stakeholders, Business Analysts, Application Developers, and Production Teams to identify needs and followed by solution options.
• Using SQL stored procedures, functions, and triggers.
• Proficient use of SQL and data extraction methodologies.
• Update data marts and extract data
• Installed SQL Server 2008 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2005 to SQL Server 2008 without any service interruption.
• Involved in teh all teh stages of Software Development Life Cycle (SDLC).
• Involved in teh normalization and de-normalization of teh databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2008.
• Wrote teh complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Responsible for monitoring teh progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
• Wrote MDX queries according to teh business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2008 Reporting Services (SSRS).
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.
• Created jobs and scheduled jobs using SQL Server Agent.
• Deployed code into teh production environment. Provided 24/7 production support for teh production database
• Coordinated with teh functional team and designed various types of reports as per teh business needs. Teh report types included Drill Down, Drill Through, Parameterized, Linked, Sub-reports and Ad-hoc reports.
• Created Cascaded Parameters for reports as per business and customer requirements in order to allow convenient filtering of teh contents.
• Worked on Dimensional modeling using Star Schema and Snowflakes Schema mostly adhering to Star Schema.
• Constructed cubes, starting from scratch, using SSAS based on data volumes used in ad-hoc analytic research and Automated Reporting.
• Optimized teh performance of cubes by creating reasonable Partitions, defining proper Hierarchies and setting teh proper Attribute Relationships.
• Created a Report Model based on SSAS Cubes, also changing Default Configuration on existing cubes.
• Implemented Key Performance Indicators (KPI) in order to identity teh performance of teh application and displayed those KPIs in teh Dashboard.
• Creating Sub Cubes and Perspectives to allow/restrict users to view data depending on teh departments they belong to.

Environment: MS SQL Server 2008/2005, Windows Server 2003, SQL Server Management Studio, Business Intelligence Development Studio (SSIS, SSRS, SSAS), MS-Visual Studio.