PROFESSIONAL SUMMARY:

• Over 7 years of experience in Microsoft SQL Server 2000/ 2005/20 , SSIS/SSRS/SSAS, OLTP and OLAP and also testing of web application into all phases including Design, Testing, Analysis Development and implementing using MS SQL server.
• Strong experience in Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/20 .
• Good knowledge on Normalization and Relational Database Management systems. Worked on adhoc reporting, Parameterized Reports, Custom Reporting.
• Experience in designing DTS/SSIS Packages to extract, load data into database, archive data file from different legacy systems using SQL Enterprise Manager/SSMS on SQL Server 2005/2008/2012 environment and deploy the data, Schedule the jobs.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Extensive professional experience in design, development, implementation and support of mission - critical Business Intelligence (BI) applications.
• Experience in in building Data Integration, Workflow Solutions and Creating, Configuring, Fine-tuning, Extracting, Transforming, and Loading (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
• Experience in supporting web based, mission critical applications including Logical and Physical Database Design.
• Experience in Dimensional Modeling, Designing of Star, Snow flake Schemas.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, developing reports using MDX and T-SQL.
• Good technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Created SSAS multidimensional cubes and Tabular Modeling in SQL Server 2012. Extensively used MDX query for SSAS
• Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Experience across entire Microsoft BI suite of products including SQL server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.
• Hands on Experience in using tools like Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Delivered BI reporting solutions in Power BI, reporting services (SSRS) and Tableau.
• Have knowledge about designing, deploying and operating available, scalable and fault tolerant systems using Amazon Web Services (AWS)
• Have knowledge in deployment, data security and troubleshooting of applications using AWS Services.
• Got trained in developing shell scripts for automation of build and release process.
• Learned the process to build and deploy automation using Docker Containers and CHEF.
• Experience in version control and source code management tools like GIT, TFS and SVN.
• Good experience in working with standard Microsoft Software applications like Word Excel, Microsoft project, Power Point and Visio.
• Strong analytical skills with ability to quickly understand client’s business needs and identify available data sources and the relationship that exist within them.
• Ability to learn and adapt quickly in a dynamic environment and Ability to work on multiple projects against aggressive deadlines
• Good communication, Writing, Presentation, Interpersonal and analytical skills and ability to work on multiple projects.
• Knowledge on Visual Studio.NET, Team foundation server (TFS)

TECHINAL SKILLS:

Operating Systems: Windows 2008 Server, Windows 2003 Server, Windows XP, Windows Vista, Windows 7

MS SQL Server 2008 components/environment: SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

SQL, T: SQL,.Net

RDBMS: SQL Server 2008, Oracle 9i/10 Developer Suite, MS Access

Querying /Reporting: SQL* Plus, Db access, ODBC query, Crystal Reports, MS SQL Server Reporting Service using MS Visual Studio 2008

Scripts: HTML, DHTML

SQL Server Tools: Management Studio, Profiler, Windows Performance monitor, SQL Server Configuration Manager

Other Tools: Team Foundation Server (TFS), SVN,Amazon Web Services (AWS), GitHub, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, NH

MSBI Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Involved in gathering requirements for data deliverables to ensure an understanding of their purpose and provide a technical perspective on requirements.
• Automated the creation of Excel pivot tables from SAS data sets using SAS /Macro and VBA
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Customers provide us the information through System One and from there data will get loaded into our database tables through the ETL packages that were scheduled to run every night.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages. Prepare and Distribute Financial Reports using SSRS to internal and provide recommendations for client’s strategic decision making
• Resolve production issues related to the SSRS reports and create ad-hoc financial reports for the clientsGenerated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances . Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling .
• Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Implemented Performance Tuning and Query Optimization .
• Created Package Configurations to deploy packages from development to production server .
• Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS)
• Using SQL Server Reporting Services (SSRS) generated periodic reports based on the statistical analysis of the data.
• Defined data sets with joins and sub-queries for complex queries involving multiple tables in SQL.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS).
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Used the tool BIRST to create, generate and distribute the reports to the customers based on their requirement.
• Used ALM to add/update the Business Requirements provided by the customers.

Environment : MS SQL Server 2005/20 /2016 , TSQL, Visual Studio 2013,2017,2019, SharePoint, SSAS, SSRS, SSIS, Auto Sys Scheduler, BIRST, ALM.

Confidential, Erie, PA

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in developing Packages for implementing Business logic through Stored Procedures and Functions .
• Understanding business requirements and conduct follow-up meetings, if necessary, with end-users
• Developed new process for the new Implementations, support activities and Change requests and to update the Business Process Management (BPM) document accordingly.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
• Developed all the required stored procedures, user-defined functions, and triggers using T-SQL.
• Passed parameters dynamically to Crystal Report in .net application at runtime.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T- SQL
• Worked with development team and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Involved in Database design & Data modeling various databases.
• Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
• Prepared technical documents like High Level Design.
• Understanding Customer requirement via interaction and writing functional specification.
• Wrote complex stored procedures and cursors to implement various business logics as per the client requirements
• Optimizing existing queries and fixing query performance issues.
• Actively interacted with end user to gather business requirement, system specification and enhancement.

Environment: MS SQL Server 2008/2008R2, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, ProClarity, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS.

Confidential, St. Louis, MO

SQL/BI Developer

Responsibilities:

• Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Exceptional communication skills in requirement gathering and design strategies for database management system.
• Offered production support at regular periods for migration and data issues.
• Developed re-usable stored procedures for database application support.
• Worked with transferring the data using SSIS(SQL Server Integration Services) packages.
• Used MS Excel, CSV files as data source and copied data to the target.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database.
• Generated Reports in SSRS using Expressions and Functions for the reports.
• Designed and rolled out canned and ad-hoc reports.
• Designed drill down, drill through, sub-reports and ad-hoc reports on large scale.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Created SSIS packages to import the data into SQL server.
• Trouble shooted the already existing SSIS packages.
• Managed server related issues.
• Developed unit test plans for SSIS packages.
• Provided documentation for reports and SSIS packages.
• Worked with a team to suggest automated processes to reduce human errors and also to save time and resources.

Environment: MS SQL Server 2012, SQL Server Reporting Services, SQL Server Integration Services (SSIS)SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), OLAP.

Confidential, Houston, TX

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Worked on creating Tables and writing Stored Procedures and User Defined Functions.
• Developed reports using SQL Server Reporting Services (SSRS).
• Involved in testing the application.
• Involve in Retesting, GUI Testing and Functional testing.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Responsible for design and development of complex reports using Crystal Reports XI.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Performed report analysis, requirements gathering, design, development, and deployment of business requirement documents.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Worked on the frontend system (MethOD Sunrise Clinical Manger 4.5) to create On Demand - MethOD reports.
• Designed, developed, and deployed new reports and enhancements to existing Reports, for various applications as assigned.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Build database queries and test cases for the testing team to test the reports.
• Responsible for back up and Restoration of SQL Reporting Service.
• Provided Documentation support on SSRS 2012 as assigned.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Integration Services 2012, SQL Server 2012 Reporting Service, Crystal Report XI, ASP, Visual Studio, XML, IIS 6.0, Windows Server 2008, Sunrise Clinical Manager 4.5, Team Foundation Server.

Confidential

SQL Developer

Responsibilities:

• Actively participated in gathering of User Requirement and system specification.
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Installed and Maintained MS SQL Server 2000/2005.
• Involved in creating clustered and Non-clustered Indexes to improve the database transactions performance.
• Maintained the table performance by following the tuning tips like Normalization, creating indexes and collect statistics.
• Responsible for Design and Normalization of the database tables.
• Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Rebuilding the indexes at regular intervals better performance.
• Written various stored procedures for the purpose of application development.
• Design and implemented data access stored procedures and triggers for automating tasks.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Worked on crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal report.
• Worked on importing /transferring the data to database tables using DTS, Import and Export Utility.
• Created and automated regular jobs Daily/weekly Report Generations.
• Monitored Performance and optimized SQL queries for maximum efficiency.
• Support for Database programming related issues.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager

Confidential

Trainee/Jr. Developer

Responsibilities:

• Involved in ER diagrams and mapping the data into database objects.
• Responsible for design of the database and the tables.
• Installed and Configured SQL Server 2008 successfully.
• Build table relationships and wrote stored procedure to clean the existing data.
• Coordinated with the front-end developer to put in the business rules. Wrote procedure to check some of the rules at the backend at the time of entering data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Environment: SQLServer 2008 Enterprise Edition, T-SQL, Enterprise manager, Erwin, MS Office and Windows 2003.