SUMMARY

• Career spanning 5 years of software development experience on SQL Server, SSRS and SSIS Technologies.
• Expert in Database designing, writing queries, Stored Procedures, Functions, and Triggers using Microsoft SQL Server 2012/2008R2/2008.
• Experience in developing SSRS reports, managing and supporting.
• Expert in creating various type of reports such as drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational databases
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models using SQL Server 2014/2012/2008 R2/2008 Reporting Services (SSRS) based on client requirement.
• Proficient in developing / debugging SSIS Packages using SSIS designer in Business Intelligence Development Studio (BIDS) for integrating data from heterogeneous sources (MS Excel, Flat Files etc.).
• Implemented Script task, Transformations(Aggregate, sort, row count), Flat file data import, Excel data import, SQL Server data import, Sampling data(Row sampling, Percentile Sampling), Expression task, Conditional Split, Sequence Containers, For loop container, For each container, Caching, debugging, deployment package.
• Experienced in working with Qlikview 12.0. Designed, developed and supported Dashboards and various Reports using Qlikview.
• Good Knowledge of installation, Backup and Recovery of SQL Server 2012/2008R2/2008/SSRS/SSIS.
• Expertise in database optimization on fine tuning the stored procedures and SQL queries.
• Good knowledge OLAP Cubes using SSAS.
• Good knowledge and understanding of Object Oriented Design Principles.
• Good Knowledge in SQL Server 2014, SSIS and ETL process.
• Extensive knowledge of thesoftware development life cycle (SDLC)from requirements gathering to programming, testing and maintenance.
• Willing to adapt to new technologies and work environments.
• Ability to rapidly absorb new concepts and apply them effectively; innovative problem solving skills and expert trouble - shooter.
• Effective in working independently and collaboratively in teams with exemplary analytical and problem solving skills.

TECHNICAL SKILLS

Programming Languages: T-SQL, SQL, PL/SQL

Microsoft Technologies: SSRS 2014/2012/2008 R2/2008, SSIS 2014/2012/2008 R2/2008, Report Server

RDBMS: SQL Server 2008/2008R2/2012/2014, Oracle10g/11g and MS Access

Dash boarding/Analytics: QlikView 12.0

Other Tools: MS Office 2007/2010, MS Visio 2008/2010

PROFESSIONAL EXPERIENCE

Confidential, Brightstar, IL

SQL Server Developer / BI Developer

Responsibilities:

• Involved in supporting and enhancing the applications (T&A, Sprint BBTI, Verso and WMS etc) developed by Brightstar.
• Involved in gathering business requirements, design document, planning, development and testing.
• Involved in processing the various Inbound files provided by vendors and publishing the results and reports for the users and as well as the vendors on regular basis.
• Developed various SSIS packages to transform data from various resources like excel files and flat files.
• Developed Various SSRS reports (Drill down reports, Sub reports, Parameterized reports) and deployed it to reporting server.
• Created Stored Procedures, User Defined Functions, Views, Tables and T-SQL scripts.
• Fine tuning of stored procedures and T-SQL scripts.
• Used SSIS tasks like execute sql task, dataflow tasks, send mail task, file system task, for each loop, sequence containers etc.
• Used various SSIS transformations like Look up Transformation, Row count, Data conversion, Derived Column, Conditional Split etc.
• Developed ad hoc queries as per the users need.
• Designed, developed, implemented and supported QlikView Dashboards. Integrated data sources and databases with QlikView 12.0.
• Designed, developed data models and backend queries for presenting data using Qlikview.
• Developed various reports (Summary Reports, Detail Reports etc) using Qlikview.
• Used various Qlikview objects like charts, list boxes, calendar objects, pivot tables, button, text objects etc.

Environment: Reporting Services, SSRS, SSIS, SSAS, SQL Server 2014/2012, Oracle Database, Share Point, JD EdwardsEnterprise One, Quilkview.

Confidential, Raleigh, NC

SQL Server Developer / BI Developer

Responsibilities:

• Involved in gathering of business requirements, design document, planning and development and testing.
• Constructed SSIS Packages tested and implemented to import data from OLEDB databases.
• Integrated Oracle E-Business Suite with SQL Server
• CreatedStored Procedures, Views, User Defined Functions and Triggersusing SQL Server 2012to retrieve data from multiple databases and manipulation of data into the databases.
• Developed SSRS reports for internal administrative purpose and Deployment of SSRS reports into report server
• Developed subscriptions, sending reports in the form of PDF to the users
• Developed ad hoc queries for the users to get instant results
• Used SSIS, ETL process for importing data into database through flat files and from other sources.
• Implemented Expression task, Aggregate transformations, Sequence Containers in SSIS

Environment: Reporting Services, SSRS, SSIS, SQL Server 2012, Oracle Database, Share Point, TOPS (Trapeze Software), Oracle EBS, Noetix.

Confidential, Irvine, CA

Database migration expert

Responsibilities:

• Involved in gathering of business requirements
• Import / export technique used for transforming the data
• T-SQL scripts is implemented to validate the data
• Stored procedures, DDL, DML, function are used in the process of transformation.
• Developed various SSIS packages to the loading data in to SQL Server.
• Developed ad hoc queries for the users to get instant results
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server and test environment.
• Created efficient Stored Procedures, User defined Functions, Tables, Views etc
• Created various reports using SSRS and deployment of SSRS reports into report server
• Developed ad hoc queries for users

Environment: SQL Server 2008/ SQL Server 2012

Confidential

SQL Server Developer / BI Developer

Responsibilities:

• Involved in database design, creating tables, views, triggers and indexes
• Implemented stored procedures for data access and manipulation
• Unit testing, debugging and problem solving
• Created various kinds of reports using SSRS
• Developed ad hoc queries for the users

Environment: SQL Server 2005, Reporting Services, SSRS,SSIS