SUMMARY:

• 9 years of experience in requirements gathering, analysis, development, implementation, testing, deployment and maintenance.
• Developing Client/Server using Microsoft products SQL Server 2012/2008R2/2005, MSBI - SSIS, SSAS, SSRS, Teradata, JavaScript, JQuery, HTML5, CSS3, Angular, ASP.Net, C #.NET, VB.Net, MSAccess, VB6.0, VBA and various segments of Software Development Life Cycle (SDLC) under Production, Development and Staging Environments.
• Extensive SQL Development experience in Banking, Insurance and Telecom sectors with a strong understanding of data & analytics.
• Expertise in SQL Server 2012/2008/2005 , SQL Server Data Tools in Visual Studio 2010/2012, Teradata SQL Assistant, DB2, MS Access, VBA.
• Experience of .Net Framework (ASP.NET, VB.NET, C#.NET, JavaScript, JQuery, Angular, HTML, CSS and IIS 7.0).
• Excellent T-SQL Developer skills including Stored Procedures, Indexes, Views, Functions, Triggers, Cursors and Distributed Transactions.
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Experienced with different Relational databases like Teradata, SQL Server, and MS Access.
• Worked on Teradata Store procedures and functions to confirm the data and load it on the table.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Good exposure to relational database management systems.
• Experience in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Good exposure in creation of jobs, schedulers, alerts using SQL Server agent and notifications using SQL mail and database mail.
• Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Experience in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in Drillthrough, Drilldown, Subreports, Cached and Nested Data Regions (Report Builder and SSRS)
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert in SSIS.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Flat Files, SQL Server.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Involved in migration of SSIS (2005) to SSIS (2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience with version control systems like Microsoft Visual Source Safe (VSS), Team Foundation Server (TFS), TortoiseSVN(SubVersion).
• Experience in Actuate 9 reporting and primavera tools.
• Specializes in Visual Basic 6.0, programming MS ACCESS (XP/2003/2007) VBA front-end and back-end, MS Excel XP/2003/2007 VBA (Lookups, Pivots, Charts, Macros) and is also proficient in the MS OFFICE Suite of software, particularly MS-WORD and Power Point including the interfacing/exchange of data between these software’s
• Created Dynamic Charts/Graphs in MS Excel and MS Access using VBA.
• Having development experience of .net components for reusable content framework for SSRS reports.
• Knowledge in SharePoint & Performance Point Servers.
• Knowledge in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Knowledge on Creating and Configuring Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008 Analysis Services.
• Flexible, enthusiastic and project oriented team player with good communication and leadership skills to develop creative solution for challenging client needs.
• Good communication, interpersonal skills and has a strong ability to work as part of a team and as well as handle independent responsibilities.
• Experience with version control systems like Microsoft Visual Source Safe (VSS), Team Foundation Server (TFS).
• Extensively worked on production support, bug fixing and closing production tickets.

TECHNICAL SKILLS:

Tools: /Technology/Languages Microsoft SQL Server2005, 2008R2, 2012 MS-ACCESS (Reporting), MS- EXCEL (Pivot, Charts & Macros), VBA, Teradata, T-SQL, PL/SQL, SSIS, SSRSSSAS Service Broker, Crystal Reporting, QueryAnalyzer, SQL Profiler, XML, HTML, VB Script, IIS6/IIS7, VBA (Macros), VB6.0, ASP.NET, VB.NETC#.NET, SharePoint, UltraEdit, WinSCP, MS Visual Studio, BIDS, PerfMonJavaScript, Angular, Primavera, Actuate 9, HP ALM, ITSM

Version Tools: TFS, SVN, VSS, Confidential

Operating System: WINDOWS 7, 8, Windows Server 2008, XP/NT 4.0

Domain: Banking, Cards, Insurance, Telecom

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

TSQL, MSBI Developer, DOT NET Developer

Responsibilities:

• Worked on requirement gathering, business analysis, development, testing and project coordination.
• Followed and implemented the Agile Methodology in the SDLC.
• Involved in designing the database using SQL server 2012/2008 R2and MS access database.
• Involved in enhancements, performance tuning and created ad-hoc reports using Report builder.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report)
• Created and managed database objects and efficiently such as tables, views, clusters, indexes, stored procedures, functions and triggers and referential Integrity.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Worked extensively on complex queries, debugging and its performances tuning.
• Created the indexes to improve the performances and also rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Experience with optimization tools for monitoring and tuning using Index tuning wizard, SQL profiler and windows performance monitor.
• Development of User Interface using Java script, JQuery, CSS, ASP.NET and HTML.
• Created, deployed and managed security for reports using SSRS.
• Development of .net components for reusable for reports in SSRS.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Configured and trained users to use Reporting Services.
• Expertise in designing the packages using various transformations available in SSIS.
• Involved in ETL process to extracting/transforming/loading data from different data sources using SSIS packages.
• Experienced in migrating the data using SSIS Packages, Import/Export and Copy database wizard.
• Good exposure in creation of jobs, schedulers, alerts using SQL Server agent and notifications using SQL mail and database mail.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Creating different types of reports by extracting data from tables, stored procedures into reports and customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Developed reports based on a Power Pivot workbook and Power View reports using SSRS 2012 and integrated with SharePoint 2013.
• Responsible for analyzing requirements and developing the SSRS reports by using Teradata, SQL queries, views and macros.
• Proficient in designing layouts, sorting data and implementing calculation fields for the reports.
• Expertise in migrating the reports from SQL server 2005 to SQL server 2008R2/2012version.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS) or share point.
• Worked on unit, system, integration and system testing.
• Works on the deployment, app support documentation to promote the code into production using version control tool.

System Environment: Actuate 9, Primavera Evolve 9, IIS 7.0, MSBI (SSIS, SSAS, SSRS), Crystal Reports, SQL Server, Tomcat, Web Logic, J2EE, JSP, MS Access(Reporting), MS Excel(Pivot, Chart and Macros), VBA, JavaScript, JQuery, HTML, CSS, SAP BO,ITSM, ALM, TFS, SQL Profiler, TSQL and Query analyzer, Agile Methodology.

Confidential

SQL Developer, SSIS SSAS SSRS Developer, DOTNET Programmer

Responsibilities:

• Gathered requirements from business analyst.
• In-depth knowledge of T-SQL (DDL, DML, DSL, and SQL CMD.
• Created database schema and database objects like tables, stored procedures, indexes, constraints, triggers, views, cursors and functions.
• Involved in dot net development and unit testing.
• Development of User Interface using Java script, JQuery, CSS and HTML.
• Rebuilding the indexes at regular intervals for better performance.
• Created Parameterized reports, Cross-Tab reports, Drill down reports, drill through reports, Sub Reports & Summary reports by Using SSRS.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Worked extensively on complex queries, performances tuning and Query Optimization.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the Development and Production environments.
• Worked on designing various SSIS packages to Exact/transform/Load the data using various transformations.
• Designed and developed the crystal reports in ASP.NET using visual studio.
• Involved in migrating SSRS reports from SQL Server 2005 to SQL Server 2008/2008R2.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Worked on unit/system testing, deployment and documentation to promote the code into production.
• Created Dynamic Charts/Graphs in MS Excel (Pivot, Macros) and MS Access using VBA.
• Followed the Agile Methodology in the SDLC.

System Environment: MSBI (SSIS, SSAS, SSRS), SQL Server, MS Access, JavaScript, JQuery, Angular, HTML5, CSS3.0, ASP.NET, C#.NET, ITSM, ALM, TFS, SQL Profiler, TSQL, Query analyzer, Web services, Crystal Reports, Agile.

Confidential

SQL Server/BI Developer/FE developer

Responsibilities:

• Gathering requirements, design, Data Modeling and Implementation.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Extracted data from various sources like SQL Server 2008, Oracle, .CSV, Excel, UNIX and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2008 as part of the automating the process for the Referral Process.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Implemented failure alerts using email in SSIS.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.

System Environment: MSBI (SSIS, SSAS, SSRS), SQL Server, MS Access, JavaScript, JQuery, HTML, CSS, ITSM, ALM, VSS, SQL Profiler, TSQL,VB6, VBA, EZLynx(Rating Engine), LexisNexis(for legal and public-records related information), Book Smart, Mainframe, ASP.NET.

Confidential, Carol Stream, IL

SQL Server Developer, SSIS SSRS SSAS Developer

Responsibilities:

• Involved in designing the database and front end form design.
• Expert in creating tables, writing and debugging complex quires, stored procedures, functions, referential Integrity constraints, views, indexes and DML/DDL.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Rebuilding the indexes at regular intervals for better performance.
• Developed DTS packages for transferring the data from source to destination between MS Excel, Flat Files and SQL Server.
• Extensively used DTS Import/Export Wizard, for performing the ETL operations.
• Involved in migration DTS packages to SSIS packages.
• Develop various SSRS reports using report wizard and report designer.
• Designed various types of SSRS reports like table, matrix, rectangle, sub reports, drill down, charts with custom report items and used sorting, multivalued parameters.
• Experience in creating, developing and Publishing Reports.

System Environment: MSBI (SSIS, SSAS), SQL Server2008R2, MS Access, JavaScript, JQuery, HTML, CSS, TFS, SQL Profiler, TSQL, VB6, VBA, Teradata, Excel exports, Flat files.

Confidential, Plano, TX

MSBI, SQL, DOTNET Developer

Responsibilities:

• Participated on daily onsite calls.
• Gathering requirements and implementation.
• Involved in developing the code and designing the forms.
• Implementing Excel Pivot tables and charts using dot net.
• Worked on requirement gathering, business analysis, development, testing and project coordination.

System Environment: MSBI (SSIS, SSAS, SSRS), ASP.NET, C#.Net, Web Services, Crystal Reports, SQL Server, MS Access, VBA, VB6.0, JavaScript, HTML, CSS, ITSM, HP ALM, TFS, SQL Profiler, TSQL and Query analyzer.