SUMMARY

• Over 6+ years of experience in design, development & analysis of SQL Server 2014/2012/2008 and SQL Server Business Intelligence tools - SSIS, SSRS and SSAS.
• Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2008/2012/2014.
• Good understanding of (SDLC) software development life cycle process methodologies and principles.
• Proficient in MS SQL Server, Expert Knowledge of Reporting Services (SSRS), Integration Services (SSIS).
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
• A multitasking analytical thinker with the ability to work on fast paced work Environment.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Command to bulk copy the data from Text files to SQL Server and vice versa.
• Involved in creating backups and restore of the databases.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and end users.
• Flexible, enthusiastic and project oriented team player with solid communication and Leadership skills to develop creative solution for challenging client needs.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle).

TECHNICAL SKILLS

Database: MS SQL SERVER /2008 R, MS Access 2013/2010.

Operating Systems: Windows

Cloud Technology: MS Azure/ Office 365

Programming Languages: Transact SQL and Macros.

Web Technologies: XML.

Productivity Applications: MS Word, MS Excel, MS Access.

DB Tools: SQL Server Management Studio, SQL BIDS, SQL Server Data tools, SQL Profiler

ETL Tools: DTS, SSIS.

Reporting Tools: MS SQL Reporting services (SSRS), MS Access and Microsoft Excel.

Data Modeling Tool: ERWIN, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Owings Mills, MD

SQL BI Developer (SSIS/SSRS) IT-COMET ETL & Reporting

Responsibilities:

• Designed, Developed and Modified and Implemented reports using SQL Server reporting services.
• Design, develop, test and deploy state level multi-tier application using VB.Net, IIS, web services and SQL Server.
• Involved in migration from SQL Server and 2014.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and scheduling the packages in the environment (Development, Staging, and Production).
• Agile methodology was adopted in the development.
• Generated various Report models on Views and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from SQL Server 2012/2014, MS Excel and Flat files.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Advanced extensible reporting skills in creating report templates, bar graphs, pie charts, debugging and testing of reports based on the financial data using SQL Server 2012/2014 Reporting Services (SSRS).
• Creating stories and tasks in Version One, attending every day stand up meetings as part of agile methodology.
• Developed complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, Triggers, CTE's, Views, Constraints with best execution plan in SSMS to implement the business logic
• Created email subscriptions for data driven reports by using Report Manager.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Responsible for the design and development of .Net web applications for firm's Solutions.
• Designed complex T-SQL queries, User Defined Functions, Stored Procedures and Triggers followed by thorough analysis and testing of those database objects before deployment to the production server.
• Improved the performance of the slow running queries by using performance tuning.
• Created packages in SSIS with error handling.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in and support and also have experience in incremental data loading.

Environment: SQL Server 2014, SSIS, SSRS, SSAS, Python, Pandas, Power Shell, Visual studio, Asp.net, C#.net, MS Azure, Visual Studio 2012, Azure SDK.

Confidential, New York, NY

MS SQL Server Developer

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into ETL Design Specifications.
• Backup and Restore method was used to migrate SQL Server instances from one server to other.
• After migration validation reports were generated on migrated instances to verify that entire instances got migrated successfully.
• Involved in data refresh from production to test and development servers.
• Designed and implemented Sales Data warehouse star schema, Fact and Dimensions.
• Execute SQL task, Execute Process task, execute package task and Script task, File System Task, Send Mail Task.
• Extensively used variables, package configurations, logging
• Designed and deployed Reports, Report Model using SSRS.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, and Execution Plan and Index Tuning wizard.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for Error handling during the ETL process.
• Documented the development work and production releases for future .
• Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.

Environment: MS SQL Server 2008-R2/2005, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Windows XP, Windows Server 2003

Confidential, Philadelphia, PA

SQL Server Developer

Responsibilities:

• Requirement gathering - Solution design
• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in the migration from SQL server .
• Designed DDL and DML for MS SQL Server 2005
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Created tables, views, triggers, stored procedures and indexes.
• Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Perform daily database backup & restoration and monitor the performance of DB Server.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configured SQL Server 2005 on development server for designing and testing.

Environment: MS SQL Server 2005, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.

Confidential

SQL Server Developer

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on servers.
• Defined various facts and dimensions in the data mart including Fact Less Facts and designed the Data Mart defining Entities, Attributes and relationships between them.
• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Fine-tuned Stored Procedures, using Execution Plan in T-SQL for better performance.
• Troubleshoot and minimize production down issues.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Created, Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Generated reports using SSRS.
• Monitored failed and long running MS SQL Server jobs.
• Monitored, tuned, and analyzed database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, T-SQL, DTS, MS Visual Studio 2005 (SSIS, SSRS), Crystal reports 7, Windows 2000 Server, .Net Programming, VSS 4.0.