PROFESSIONAL SUMMARY:

• IT Professional with 7+ years of experience in Analysis, Design, Development, Production Support, Testing and Deployment of software systems.
• Experience in database designing skills and experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2012/ 2008 R2/2005.
• Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Excellent T - SQL (DDL & DML) development skills to write complex queries involving multiple tables, great ability to develop and maintain Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval/query optimization.
• Excellent knowledge of creating jobs, SQL Mail Agent and scheduling DTS/SSIS Packages. Using SQL Server Agent.
• Expertise in SQL Server 2005/2008 R2 Reporting Services (SSRS) and SQL Server 2005/2008 R2 Integration Services (SSIS) in Business Intelligence (BI).
• Well versed with diverse types of reports such as Drill down, Snapshot, Cached, Drill through, Parameterized, Cascaded parameterized, Linked, Chart, and Sub-reports using SSRS.
• Experienced in configuring and maintaining Report Manager, Report Server and Report Builder for SQL Server Reporting Services (SSRS).
• Experienced in extracting, transforming and loading (ETL) data, from different Heterogeneous Data sources like MS Access, Flat File, Excel and Oracle, to MS SQL Server using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Expertise in designing SSIS packages to Import and Transform Data between Databases and External Data Sources.
• 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, Fuzzy Lookup, Fuzzy Grouping, Pivot etc.).
• Experience in Dimensional Modelling, Designing of Star, and Snow Flake Schemas.
• Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, developing reports using MDX and T-SQL.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Experienced in Agile development mythology like SCRUM.
• In-depth knowledge of understanding all stages of Software Development Life Cycle (SDLC).
• Competent, reliable and committed professional with a proven track record of successful implementations.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player
• Experience in the area of Warehousing in analysis, design and development of software applications using Pentaho, Jasper, BIRT BI servers and Report designers.
• Built Universes for WebI reporting purposes. Built several WebI reports across Claims, Utilization Management, Member Eligibility Enrolment, Capitation and Customer Relationship & Management.
• Created Web Intelligence (WebI) Reports with query filters, Sorts, Breaks, alerts, Complex Operations (AND, OR).
• Responsible for publishing of Crystal reports to Business Objects Infoview and configuring the database in Business Objects Content Management Console (CMC).
• Appliedsecurity featuresof Business Objectslike row level, report level & object level security in the universe so as to make the sensitive data secure.

TECHNICAL SKILLS:

Data Modelling Tools: Erwin, MS Visio

Database: MS SQL Server 2005/2008/ 2008R2/2012, Clarity

BI Tools: SQL 2008/2008R2/2012 SSIS, SSRS, SSAS, Web Intelligence, Crystal Reporting, Information Design Tool, Universe Design Tool.

Programming: T-SQL, JavaScript, C#

Version Control: MS Team Foundation Server, Jira, Service Now, Share Point

Operating Systems: Microsoft Vista/XP/NT/2007

Other Software: Microsoft Office Suite, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Report Writer & Report Analyst

Responsibilities:

• Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Exceptional communication skills in requirement gathering and design strategies for database management system.
• Offered production support at regular periods for migration and data issues.
• Developed re-usable stored procedures for database application support.
• Worked with transferring the data using SSIS (SQL Server Integration Services) packages.
• Used MS Excel, CSV files as data source and copied data to the target.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, Graphs.
• Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Designed drill down, drill through, sub-reports and ad-hoc reports on large scale.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Built Universes for WebI reporting purposes. Built several WebI reports across Claims, Utilization Management, Member Eligibility Enrolment, Capitation and Customer Relationship & Management.
• Created Web Intelligence (WebI) Reports with query filters, Sorts, Breaks, alerts, Complex Operations (AND, OR).
• Responsible for publishing of Crystal reports to Business Objects Infoview and configuring the database in Business Objects Content Management Console (CMC).
• Appliedsecurity featuresof Business Objectslike row level, report level & object level security in the universe so as to make the sensitive data secure.
• Created SSIS packages to import the data into SQL server.
• Involved in Troubleshooting of the already existing SSIS packages.
• Managed server related issues.
• Developed unit test plans for SSIS packages.
• Provided documentation for reports and SSIS packages.
• Worked with a team to suggest automated processes to reduce human errors and also to save time and resources.

Environment: MS SQL Server 2012, SQL Server Reporting Services, SQL Server Integration Services (SSIS), WebI Reporting, Crystal Reporting, Business Intelligence Development Studio (BIDS), OLAP.

Confidential, Raleigh, NC

SQL / BI Developer

Responsibilities:

• Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Exceptional communication skills in requirement gathering and design strategies for database management system.
• Offered production support at regular periods for migration and data issues.
• Developed re-usable stored procedures for database application support.
• Worked with transferring the data using SSIS (SQL Server Integration Services) packages.
• Used MS Excel, CSV files as data source and copied data to the target.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database.
• Generated various reports with drilldowns, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS.
• Deployed the SSRS reports in Microsoft office share point portal server.
• Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.
• Designed and rolled out canned and ad-hoc reports.
• Designed drill down, drill through, sub-reports and ad-hoc reports on large scale.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Created SSIS packages to import the data into SQL server.
• Involved in Troubleshooting of the already existing SSIS packages.
• Managed server related issues.
• Developed unit test plans for SSIS packages.
• Provided documentation for reports and SSIS packages.
• Worked with a team to suggest automated processes to reduce human errors and also to save time and resources.
• Description Jasper soft is well known in open source BI domain. We were involved in designing the dashboard for them illustrating the new capability of jasper’s like chart pro, map pro and widget pro

Environment: MS SQL Server 2012, SQL Server Reporting Services, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), OLAP, C#.

Confidential, Rochester, MN

SQL / BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server
• Implemented transactions at package level and task level to meet the business requirements.
• Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.
• Designed SSIS package templates as base code for package development incorporating package
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created SSRS reports using Report Parameters and Drop-Down Parameters
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.
• Generated Reports weekly and monthly to an online management interface using SSRS.
• Post production support
• Create, manage SQL Server AZURE Databases.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Critical issue resolving in given timeframe.
• Monitor jobs and reporting
• Performed code reviews, unit testing.
• Status meetings with the client, conducting reviews of the deliverables, defect tracking and analysis
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Jasper Reports - Involved in gathering report requirements and developing
• Using Jasper latest UI framework, we changed the look and feel ofJasper so to match application integrity.

Environment: SQL Server 2012, T-SQL, MS Integration, Analysis and Reporting Services, Management Studio, Query Analyser, Windows 2007 Server, Oracle 11g, C#, COSMOS.

Confidential - Los Angeles, CA

ETL/Reports Developer

Responsibilities:

• Designed logical and physical models for staging database and data warehouse using Erwin database modelling tool.
• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server.
• Used master child SSIS packages for better design and ease of maintenance.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
• Optimized packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source.
• Created alerts and mail confirmation of all packages and cube processes in SQL server Agent to get event messages such as success/failure of package, procedure.
• Deployed SSIS packages to the production server using XML and SQL server configurations.
• Created different kind of reports like parameterized reports, drill down reports, and sub reports to support business needs and involved in report deployment and report security.
• Designed the architecture for Extract, Transform, Load environment, development of mappings and process using Informatica Power Centre.
• Developed complex reports like Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks.
• Created Ad-hoc reports using Report Models (.smdl) files and deployed it on Report Manager to create reports on the fly for the people who are less adept with technical skills.
• Configured deployment of SQL Server Reporting Services to work with deployment of Microsoft SharePoint Integrated mode.
• Optimized the performance of reports by using various techniques like optimizing data-sets, making use of less number of input parameters along with caching and taking snapshot of reports.
• Implemented security on reports at Server Level, Report Level and Item Level according to the hierarchy in the organization and business requirement.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.

Environment: SQL Server 2008, Transact-SQL, SQL Server Integration Services (SSIS), SSRS (Reporting Services), Erwin, Windows Server, Web Services.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and system specification.
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Installed and Maintained MS SQL Server 2000/2005.
• Involved in creating clustered and Non-Clustered Indexes to improve the database transactions performance.
• Maintained the table performance by following the tuning tips like Normalization, creating indexes and collect statistics.
• Responsible for Design and Normalization of the database tables.
• Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Rebuilding the indexes at regular intervals better performance.
• Written various stored procedures for the purpose of application development.
• Design and implemented data access stored procedures and triggers for automating tasks.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Worked on crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal report.
• Worked on importing /transferring the data to database tables using DTS, Import and Export Utility.
• Created and automated regular jobs Daily/weekly Report Generations.
• Monitored Performance and optimized SQL queries for maximum efficiency.
• Support for Database programming related issues.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyser, Enterprise Manager, JavaScript