SUMMARY:

• Over 4 years of experience in Database Design, Programming, Development and Implementation of Client Server Applications & Database systems
• Involved in all phases of Software Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Experience in Data modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Experienced in T - SQL programming in writing complex Queries, stored procedures, Triggers, Views and Functions.
• Created clustered and non clustered indexes. Indexed views.
• Experience in writing complex SQL queries involving multiple table inner and outer joins, correlated joins, temporary tables, table variables.
• Used Performance Monitor/Profiler to solve dead locks/long running queries. .
• Experience in Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, Import/Export utility, and Bulk Copy Program (BCP).
• Perform activities like, Data Modeling, Data Integration, Data profiling, Data Mining.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Created email subscriptions for data driven reports by using Report Manager.
• Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Allowing application development organizations to work on several versions of software simultaneously Strong technical knowledge in Troubleshooting and Performance tuning.
• Excellent interpersonal, presentation skills, with demonstrable leadership, verbal and written communications to maintain effective work relationships with all levels of personnel in a team environment or independently.
• Used Agile tools like User Stories, Priority Classification, User Narratives. Managed the Sprint backlogs and burn down charts.
• Created several documentations like BRD, TTD using MS word and uploaded to Share point.

TECHNICAL SKILLS:

Database (RDBMS): MS-SQL SERVER 2005/2008/2012/2014 , Sybase, ORACLE 10g/11g, MS-Access 2007/2010/2013

Operating Systems: Windows, Linux and Unix.

Programming Languages: Transact SQL, VB.NET, ASP.NET, C#, Unix Shell Scripts, VBA.

DB Tools: SSMS, SQL BIDS, SQL Server Data tools, SQL Profiler, Toad

Reporting Tools: MS SQL Reporting services (SSRS), MS SQL Analysis Services (SSAS), Crystal Reports, Power Pivot and Microsoft Excel.

Data Modeling Tool: ERWIN, Visio

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Sr.SQL/SSIS/SSRS Developer

Responsibilities:

• Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for delta and history loads.
• Worked with complex SQL, Stored Procedures, Triggers and packages in very large databases from various servers using SQL server.
• Working in production support to tune and optimize the process for better performance.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures also with Execution Plan.
• Implemented and maintained moderate to complex SSIS packages. Migrated SSIS Packages from SQL Server 2008 to SQL Server 2012.
• Responsible for all ETL operations within the IT Department including client Data, warehouse loads and data extraction.
• Extensively Developed and delivered dynamic reporting solutions using SQL Server 2008 Reporting Services and troubleshoot Stored Procedures that are used for existing or newly created reports.
• Debugged and fixed the systems to increase the performance bottlenecks.
• Actively engage in design discussions, database initiatives, new approaches and Documentation.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types
• Perform Administration tasks including security access, backups and restores.

Environment: Microsoft BI, Microsoft SSAS, Microsoft SSRS, Microsoft SSIS, Transact-SQL, Microsoft BIDS, Microsoft Visual Studio, Power Pivot, DAX, Pro Clarity, BI architecture, Cosmos, Dashboard, Microsoft Performance Point, Nintex, PPS, Stsadm, Caml, Enterprise search, Power View, Visualization, Microsoft technologies, BIA, MDS, KPI, MDX, MaxL, Slowly changing dimensions, ESSCMD, BSO, Essbase

Confidential, CA

SQL/BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: Microsoft BI, Microsoft SSAS, Microsoft SSRS, Microsoft SSIS, Transact-SQL, Microsoft BIDS, Microsoft Visual Studio, Power Pivot, DAX, Pro Clarity, BI architecture, Cosmos, Dashboard, Microsoft Performance Point, Nintex, PPS, Stsadm, Caml, Enterprise search, Power View, Visualization, Microsoft technologies, BIA, MDS, KPI, MDX, MaxL, Slowly changing dimensions, ESSCMD, BSO, Essbase

Confidential, Madison, WI

MS SQL/ SSIS Developer

Responsibilities:

• Created Stored Procedures, Views, Triggers, User defined Functions and scripting Complex T-SQL logics for business rules.
• Importing file exception reports after the missing data is recovered by the data entry team.
• Re-processing the complex T-SQL scripts to update the data in Staging Purchase History table and Purchase History table.
• Validation of the scripts and to check in the scripts like tables, views and stored procedures into TFS.
• Optimizing the T-SQL script using the estimated execution plan based on the cost of the steps and indexes.
• Cleaning, fixing the data which is incomplete and identifying the various exceptions in the received data.
• Worked on File integrity validation, Data integrity validation and Data quality analysis.
• Created SSIS packages with which data resources such as Flat files, Excel files, were loaded daily to create and maintain a centralized data warehouse.
• Created Complex SSIS packages using various transformations provided by SSIS such as data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Created different types of Reports such as Cross-Tab, Drill-down, Summary, OLAP, Sub reports and formatting those using SSRS.
• Assisting the data entry team when needed and pulling the required data from various tables using complex T-SQL queries.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent. Expertise in Backup configuration, monitoring and tuning.

Environment: MS SQL Server 2012/2008/2005, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2008/2010 OLAP