SUMMARY

• Almost 7 years of IT industry experience with Microsoft SQL Server 2012/2014/2016/2017/2019 , SSIS/SSRS, and OLAP as SQL Developer.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Joins, Indexes, Data Import/Export, Triggers.
• Experience using Joins and sub - Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Wrote Complex SQL queries for verifying data integrity in Dimension and Fact tables and created and have In-depth knowledge in various RDBMS concepts.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Familiar with Agile development and waterfall methodologies.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density charts
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Developed ETL process using SSIS with various Control flow, Data flow tasks and Stored Procedures for the work order validation process.
• Experience in Data Modeling, Normalization and building Referential Integrity Constraints, Database Design and Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2014/2016/2017 for both OLTP & Business Intelligence applications.
• ETL implementation using SQL Server Integration Services (SSIS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like Dynamic, Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map and Sub-Reports.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau and Spotfire.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem-solving skills.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C#, ASP (.NET), XML, HTML, DHTML, HTTP

Databases: MS SQL Server 2012/2014/2016/2017/2019 , (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Power BI, Visual Studio.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniquesPackages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2012, Microsoft Performance Point Server 2012

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, Microsoft Office, Excel Power Pivot. Excel Data Explorer.

PROFESSIONAL EXPERIENCE

MS SQL Developer SSIS

Confidential

Responsibilities:

• Involved in Planning, Defining and Designing database using Erwin 8.0 on business requirements and provided documentations.
• Designed MS SSIS Packages to extract data from various OLTP sources, Text Files, XML (Extensible Markup Language) Files, MS SQL Server 2000, Excel, and MS Access 2000 to OLAP system like SQL Server.
• Wrote T- SQL queries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.
• Created various SSIS packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column.
• Wrote T- SQL queries, Store Procedures and used them to build packages and maintain the history of the data.
• Involved in Design and Developed OLAP cubes for the end user analysis purpose using MS SSAS 2005. Identified fact and dimension tables in the Cube.
• Developed reports in MS SQL Server environment using MS SSRS-2005 in Business Intelligence Development Studio (BIDS).
• Generated Sub-Reports, drill down reports, Drill through reports and Parameterized reports using MS SSRS for the end user requirements.
• Worked with the front-end developers to deploy the reports.
• Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like MS SQL Server Management Studio, MS SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in development of MDX expressions for cube calculation and KPIs (Key Performance Indicators)
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

Tools: and Technologies: - MS SQL Server 2012, SSRS, T- SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v8.0, ASP.Net, C#.

MS SQL Server Developer/ SSIS/SSRS Developer

Confidential - Sunnyvale, CA

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Engaged in gathering data and documenting it for further reference.
• Involved in installation and configuration of MS SQL Server 2008.
• Expert in designing database using ERWIN.v7.2
• Upgraded the server from MS SQL Server 2005 to MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, developed, and deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated various reports using SSRS 2008.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages.

Tools: and Technologies: - MS SQL Server 2008, SSIS, SSRS, SSAS, Oracle10g, Visual Studio 2005, VSS 2005, Erwin 7.3, Windows NT/2003, Microsoft .NET framework 3.5, C#, JavaScript, ASP.NET, XML.

Confidential, Bethesda, Maryland

SQL Server Developer

Responsibilities:

• Installation and configuration of SQL Server 2012 on Window XP.
• Managing of database objects like Tables, views, indexes etc.
• Managing of users including creation/alteration, grant of system/DB roles and permission on various database objects.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Well experienced with tools like Query Analyzer, SQL utility.
• Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.
• Creation and management of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Automation and execution of data transformation scripts.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Optimized SQL queries for improved performance and availability.
• Designed, analyzed and upgraded databases.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Implemented the changes/modification like iterative/incremental development and used .NET Framework and Object-Oriented Methodologies for application development by using agile scrum methodology.
• Maintained Source definitions, Transformation rules and Target definitions using Informatica Repository Manager.
• Developing SSIS packages that upload multiple flat files using for each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a date.
• Developed Transact-SQL scripts to enforce business rules.

Tools: and Technologies: - MS SQL Server 2008/12, BIDS,TFS, Windows Server, Windows NT, Erwin, Crystal Reports