PROFESSIONAL SUMMARY:

• Around 11 years of rich experience in Requirement Analysis, Design, Development & Implementation, Testing & Deployment and Production support/Maintenance Activities of complete software development life cycle (SDLC) in field of Desktop Applications, Microsoft web and client/server technologies
• Worked extensively on Data warehousing and Client Server applications using SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS) and SQL Server Analysis Services (SSAS), SQL Server and .NET Framework
• Experienced in .NET (C#) and VBA (Excel Macros, MS - Access) and MIS Finance Systems
• Expert level knowledge of RDBS and SQL relationships, Excel 2016 and 2014 especially Pivot tables
• (Power pivots, Power query and closely work with Dashboard reports).
• Mocked the required reports ( by visualizing and Exploring the data) for day-to- day review of The supplier data using Power BI
• Created interactive dashboards and reports with visualization using Power BI by pulling the data from SQL server and Excel spread sheets.
• Experienced in Management Information System reports.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Migration experience from MS SQL Server 2000 to MS SQL Server MS SQL Server 2005 to MS SQL Server 2008.
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Good knowledge of Relational Database Management Systems (RDBMS) with experience in Database Design, Development, Data model analysis & Data migration using MS SQL Server
• In-depth knowledge in various RDBMS concepts like Database, Table, Table Normalization, writing complex Database Queries, Stored procedures, Triggers, Cursors in MS SQL Server
• Strong experience in DDL, DML, T-SQL, views, functions and packages
• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database
• Expert level skills on T-SQL and query optimization, developing ETL strategies using SSIS, Database designing using SQL Server
• Experience in creating Reports, Jobs, Alerts, SQL Mail Agent and Scheduling SSIS Packages
• Good experience and understanding of database design, relational integrity constraints, OLTP, OLAP, Cubes and normalizations
• Supported team in resolving SQL Reporting services and ETL related issues
• Good experience with SQL Server SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services)
• Expert in preparing all types of reports using SSRS
• Familiar with Complex Reporting Requirements - Complex Drill - Through, charts, Discontinuous Cross Tabs and Summary Reports. Experience in dimensional modelling using Star Schema and Snow-Flake Schema, Data Analysis providing Business Intelligence solutions
• Dedicated Team Player with high tolerance & patience level, humorous nature and good in communication & Interpersonal skills
• Capable of performing under minimal supervision, multi-tasking, meet deadlines as an individual contributor and a committed team player
• Good Experience in Implementing Transactions etc.,
• Good Experience in building Package deployment and package Configuration
• Exceptional ability to adapt to latest technologies, perseverance, innovative and organized

TECHNICAL SKILLS:

Operating System:: Windows server

Languages:: C#, VB.Net, Visual Basic 6.0, T-SQL, PL/SQL, Visual Studio XML, Java Script

Tools: SQL Server Management Studio, Enterprise Manager SSIS, SSRS, BI Development Studio, SQL Loader, Tableau 8.X, Microsoft Power BI

DATABASE:: MS Access, MS SQL Server Postgre SQL

Tools: /Utility: Enterprise Manager, SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, BCP, SQL Profiler

Software:: MS Office, Visio, Adobe Photoshop, Ms Excel, MS-Project 2000, Toad Data Modeller

Reporting Services:: Excel, SQL Server Reporting Services, Performance Point Server, Crystal

PROFESSIONAL EXPERIENCE:

SQL/SSIS/SSRS Developer

Confidential - Denton, TX

Responsibilities:

• Gathered requirement and designed technical document to implement the application.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
• Used TSQL to create various stored procedures.
• Performed Data Cleaning activities
• Designed and developed data model in SQL Server using Visio.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs, XML).
• Created property expressions for several tasks like For Each Loop Containers, Sequence container etc and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
• Implemented error handling and notifications in SSIS
• Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created parameters (multi value, hidden, default etc) for the required fields using the report designer to see the dropdowns in the end report.
• Created reports using Caching and Snapshots for better performance of the reports.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Created package configuration files to make packages dynamic across multiple environments.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created SSRS subscriptions and data driven subscriptions.
• Performance tuning of SQL queries and stored procedures
• Come up with different test scenarios for automating Unit test cases, Build verification test cases and Environment test cases

Environment: Windows XP, T-SQL, MS Access, SQL Server 2008 R2, SSIS, SSRS, VSS, TFS, Tableau 8.X, Power BI.

SQL/SSIS/SSRS/SSAS Developer

Confidential - Phoenix, AZ

Responsibilities:

• Gathering the requirements from the clients for the different source systems.
• Responsible for ETL Design
• Involved in daily incremental loads into Staging and ODS areas, trouble shooting process issues and errors.
• Created several Staging Databases.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Used various Control Flow tasks in SSIS like For Each Loop Containers, Sequence container etc and data flow tasks like derived column, lookup, Fuzzy Lookups, conditional splits etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created package configuration files to make packages dynamic across multiple environments.
• Created reports using Caching and Snapshots for better performance of the reports.
• Providing the user education on PPS which helps the users to generate the reports from the share point.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Hands on Experience in Data Modelling Tools (Microsoft Visio, Toad Data modeller and Power designer).
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Implemented lookup transformations using cache.
• Published Reports to the report server virtual directory.
• Created analysis Services Database to hold Sales, Inventory and Finance cubes.
• Created named sets, calculated member and designed scope in SSAS.
• Designed cube aggregations and Usage based aggregations for fast query retrieval
• Created partitions for large measure groups in SSAS.
• Created Actions, Drill through and Reporting Actions in Cube.
• Created SSRS reports on Inventory cube by writing MDX.
• Come up with different test scenarios for automating Unit test cases, Build verification test cases and Environment test cases
• Rebuild/Reorganized indexes where ever necessary.
• Involved in DBA activities like database backup, restore.

Environment: Windows 2003MDX, T-SQL, Oracle 10g, MS Access, SQL Server 2008 R2, SSIS, SSAS, SSRS, Performance Point server, VSS, Power BI.

SQL Developer

Confidential - Portland, ME

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of end User Requirements
• Used TSQL to create various stored procedures.
• Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Involved in generating summary reports using SSRS.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
• Created YTD, MTD sales reports

Environment: Windows 2003, C#.Net, T-SQL, MS Access, Windows XP, Microsoft SQL Server 2005, SSRS, Microsoft Visual Studio 2003, VSS, MS Access

SQL Server SSIS/SSRS Developer

Confidential - Nashville, TN

Responsibilities:

• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between Oracles to SQL Server.
• Moving data to staging tables using SSIS.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and • Materialized views for remote instances.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Handling the orphan rows in Dimension and Fact tables.
• Develop the Documents for Logging/Error Handling for SSIS Packages.
• Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Actively participated in User Acceptance Testing and Debugging of the system.

Environment: MS SQL Server 2000/2005/2008 (SSRS/SSIS/SSAS), MS SQL Server BIDS, MS Visual Studio 2005, Microsoft Office Suite, XML, Crystal Reports XI, Windows XP, Windows 2003 Server. SQL BI Server/SSIS/SSRS Developer

Confidential - Memphis, TN

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Designed, coded, tested and implemented user interfaces, procedures and functions for new and existing software application requirements.
• Worked with technology features in SQL Server such as Partitioning, File Groups, Replication, Materialized Views, Options available in executing database statistics
• Install, tune, maintain and monitor SQL Server for the Production environment
• Created SSIS package to get data from different sources, consolidate and merge into one single destination.
• Created variety of reports for business to provide them with critical information about business status.
• Created stored procedures for datasets in SSRS reports to run calculations at database level.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Materialized views, dimensions and stored outlines for optimal performance.
• Actively involved in Normalization & De-normalization of database.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Involved in System testing.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
• Used Database Engine Tuning Advisor and SQL Profiler to optimize queries and enhance the performance of database servers
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
• Performed tuning of SQL queries and stored procedures using SQL Profiler.
• Involved in generating summary reports using SSRS.
• Created YTD, MTD sales reports.

Environment: SQL Server 2005 Enterprise Edition.NET Framework, XML, T-SQL, SSIS 2005, SSRSSSAS, VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access. Visual Studio 2005

Software Engineer

Confidential, New Jersey, NJ

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Created DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Expertise in using variables, property expressions, script tasks in SSIS Integrated Database Maintenance jobs to perform full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Developed & executed several Optimized queries in SQL.
• Assigned Index tuning scripts to run at regular intervals.
• Performance monitoring and tuning MS SQL Server.
• Assisted the Application team in data modelling and T-SQL coding.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows 2003/XP.