SUMMARY:

• Technology Specialist with over 7 years of IT experience that includes System Analysis and Design, Development & Support of MS - SQL 2008R2/2012/2014 and Business Intelligence including SSRS/SSIS.
• Extensive experience and detailed knowledge of Healthcare, Banking and Security.
• Extensive experience in Database design and development of applications using SQL Server 2008R2/2012/2014, Reporting Services (SSRS), Integration Services (SSIS), Normalization/De-normalization concepts and have knowledge in SQL Server Analysis Services (SSAS), MDX queries, OLAP Cubes.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Indexes, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Expert level knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Expert in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2005
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Experienced in Creating dimension tables in Teradata to fit our reporting needs.
• Extensive knowledge of Teradata utilities, Teradata Viewpoint tool for production platforms monitoring, awareness of TASM workload settings.
• Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension Tables.
• Proficient in Job Scheduling, Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Worked on administration tasks such as Creating Databases, upgrades, Data loading/unloading, Batch Jobs, Backup & Recovery, User and Application Table Management.
• Hands on experience in creating reports using Crystal Reports.
• Excellent understanding of full Software Development Life Cycle (SDLC)
• Ability to work independently, demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment.
• Development background with experience developing backend .NET and Java applications to support data initiatives.
• Expert level knowledge on object oriented programming language like C# and vba

TECHNICAL SKILLS:

Databases: MS SQL server 2008R2/2012/2014, Oracle 9i/10g, PL-SQL, DB2, Sybase, MS Access

Database Design Tool and Data Modeling: Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server DTS, Visual Studio, Crystal Reports and Knowledge in SQL Server Analysis Services (SSAS),Full stack MS BI.

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console

Microsoft tools: MS Office, Management studio, Visual studio

PROFESSIONAL EXPERIENCE:

Confidential, DALLAS, TX

MS SQL Server Developer/BI Developer

Responsibilities:

• Gathered business requirements related to data and business intelligence needs, HLD design for the ETL and Reporting requirements.
• Liaise with business subject matter experts in analysing Business Requirement Document (BRD) and translating them into conceptual data models and schema development to be implemented with T-SQL, ETL and Reporting to develop a solution.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Optimized the database by creating new tables, various clustered, non-clustered indexes.
• Developed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Responsible to created views with multiple Facts and dimension tables in Teradata for building cubes.
• Diagnosing and tuning the server optimal performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.
• Map source system data elements to target system and develop, test, and support extraction, transformation, load processes, data profiling, data quality and clean ups for SSIS packages.
• Used various SSIS tasks such as Data flow task, Fuzzy lookup, Conditional Split, Derived Column and Union All which were used for Data Scrubbing, data validation checks during Staging.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data base.
• Created SSIS packages to load data into Data base using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Planned to schedule reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs using SQL Server Reporting services (SSRS).
• Designed for Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively used Report Manager to configure Web URLs, E-mail and Databases to prepare reports and make reports visually appealing by adding different report formatting options and also provided back-end support for functional testing and performance testing.

Environment: SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Teradata, Database Tuning wizard and Visual Source Safe.

Confidential, NJ

SQL Developer/ SSIS/SSRS Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of reports in SQL Server Reporting Services (SSRS).
• Designed and developed a full-scale reporting solution for an environment using SQL Server 2008 and SSRS 2008.
• Worked on developing Tables, Indexes, Views, Complex Stored Procedures, Triggers, Functions, SQL joins and other T-SQL code to implement business rules in SQL Server 2008.
• Wrote T-SQL, designed and modified database objects such as Tables, Stored Procedures, and UDF for SSRS report requirement.
• Extensively utilized Teradata utilities for loading the data in to CPM DWH system.
• Used SQL to query the databases and do as much crunching as possible in Teradata, using very complicated SQL.
• Defined Check constraints, Business Rule, Indexes and Views.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Installed and configured MS SQL Server 2008R2 along with Visual Studio on a network domain system.
• Designed develop SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to AMS database.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions and more using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Proficient in using Table variable, Temp table, Dynamic SQL, Loop, CTE, and various built-in functions in SQL server.
• Developed Tabular, Chart, Matrix, Drill down and Drill through reports using SSRSas well as managed the Subscriptions of the reports.
• Generated Multi Parameterized reports in SSRS allowing users the ability to make selections before executing reports; thus making them user friendly.
• Experience in deployment of the generated SSRS reports through report manager.
• Designed and developed corporate performance management solutions including Dashboards, Score cards and analysis of SSRS reports using the data from SQL Server 2008.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Extensively used SSRS for creating reports like Sub-reports, Linked reports, Cascaded Parameterized reports, Matrix reports and different types of Graph reports.
• Created official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes.
• Subscribed many of reports useful for the clients through scheduled Email subscriptions.

Environment: SQL Server 2008, SQL Server Reporting Services (SSRS), Microsoft Visio, SQL Profiler, Database Engine Tuning Advisor and Visual Source Safe.

Confidential, Burlington, NJ

SQL Server/SSRS Analyst

Responsibilities:

• Acknowledging the User Requirement documentation from the client and analysing the requirements.
• Involved in the analysis, design, created process flow diagram, coding and publication of customer facing reports.
• Developed a new Request page using Microsoft SharePoint InfoPath which is used by customers to fill out their requirements.
• Developed a new page using Microsoft InfoPath which is used by customers to fill out their requirements.
• Created Complex Stored procedures, Triggers, Indexes, Rules, Integrity constraints, Cursors, Views and ad hoc queries using SQL 2005/2008 for the business logic.
• Designed index and optimized queries by using execution plan for performance tuning of the database.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Developed various reports which include Drill down reports, Drill through repots, Cascaded Parameterized reports, Linked Reports, Sub Reports and Matrix reports using SSRS and integrated with Microsoft office Share Point portal. The SharePoint page also contains parameters for enabling the end-users to make filter selections.
• Created reports, metrics, KPIs and scorecard to the customers using SSRS.
• Experience in generating reports like Tabular, Chart, Graph, Parameterized reports using SSRS and deployed the same through report manager.
• Worked on designing and developing Executive Reportslike Customer Monthly Report, Reporting Services Integration, Internal Customer facing reports and Internal Managed Security Services Reports.
• New Initiatives to automate many of the Metricsreports useful for the management and delivering it through Scheduled email subscriptions.
• Managed documents in SharePoint portal.
• Involved in the revamp of the existing database, which was primarily aimed at performance enhancement and as a step to streamline the reporting process.
• Defined a streamlined process for the entire development and testing life cycles.
• Arranging a knowledge sharing sessions and bringing up the best practices among the team.

Environment: SQL Server 2005, 2008, SQL Server Reporting Services(SSRS), Microsoft InfoPath, Microsoft Sharepoint, MS Visio, Managed HPSD (Internal Tool), SQL Profiler, Database Engine Tuning Advisor and Visual Source Safe.