SUMMARY:

• 8+ years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation, and Deployments using SQL Server 2014/ 2012/2008/2005 & Oracle 11g,12c.
• Strong experience in Business Intelligence (BI) using Visual Studio 2010/2008/2005.
• Created, Built, and deployed successfully dynamic SSIS packages into SQL Server 2014 / 2012/2008/2005 databases and scheduled them according to requirements.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Experienced in TSQL (DDL, DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2008/12/14
• Experienced in relational database design, SQL queries, Stored procedures, Functions, clustered, non-clustered indexes and indexed, views, Performance tuning,
• Experienced in Importing/Exporting Data from various data sources like Excel, and Flat file using DTS utility and SSIS services.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
• Extensive experience in creating enterprise reports using SSRS 2008/2012 using Report Manager, Report Builder, and BIDS
• Created many Drill Through, Drill Down, Parameterized reports using SSRS 2005/2008
• Excellent knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models for developing SSAS Cubes using MDX
• Have hands-on experience in Performance Tuning and Query Optimization. Worked on identifying and resolving blocking and deadlocks
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Self-motivated and possesses ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User-oriented with a desire to learn client's business requirement.
• Excellent communication skills, bridging Client Interaction and a Team player. Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem-solving skills, and a fast learner who also adapts quickly to new technologies with the ability to take new roles in minimum time with little training

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012/2008/2003/2000 Windows 8/7/Vista/XP

Languages: T-SQL, PL/SQL, C#, .Net, VB.Net, ASP.Net, XML, HTML, Java Script

Tools: Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development Studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2012/2008/2005, SQL * Plus, Toad, Erwin, Power BITivoli Work Scheduler, Tidal, JIRA.

Databases: MS SQL Server 2012/2008/2005, AWS, Oracle11g/10g/9i, DB2, MS Access, MySQL.

Data Modeling Tools: Microsoft Visio, UML, Erwin, Oracle Enterprise Management OEM

Software: MS Office, DTS X Change, Adobe Photoshop, MS Excel, MS-Project 2000

Reporting Services: Hyperion Financial Reporting Studio, Excel, SQL Server Reporting Services, Crystal Reports.

PROFESSIONAL EXPERIENCE:

Confidential, Dulles, VA

SQL/ BI / Developer (SSIS/SSAS/SSRS/FRS)

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Working on Financial Reporting Studio and Crystal Reports
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Extract Transform Load (ETL) development using SQL Server 2008, SQL 2008 Integration Services (SSIS).
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 OLAP databases.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Involved in project planning, scheduling for database module with project managers.
• Generated database monitoring and data validation report in SQL Server Reporting Service (SSRS).
• Generated various reports with drill downs, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Developed tabular models for reporting, come up with a design based on requirements and volume of data whether to develop SSAS OLAP cube or tabular model.
• Deployed the SSRS reports in Confidential office share point portal server.
• Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.
• Wrote an optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Created Star Schema for OLAP cube generation and extensively worked dimension modelling for analysis service using SSAS.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Responsible for automation of maintenance jobs, locks, and indexes configurations.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Environment: MS SQL Server 2014/2012, SSAS, DTS, Windows 7, Visual Studio 2010/2013, SQL Server Business Intelligence Development Studio(BIDS), SSRS, TFS, MS-Visual Studio 2010, MS Access, XML.

MS SQL Server /SSRS/SSIS/SSAS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Project-manage Oracle MDM implementations for Oracle customers.
• Developed Custom Logging so the user can know when a row is inserted in custom logging table by every SSIS package that executes if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using DBAmp pro tool
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Responsible for creating partition function and schema for the table partitioning.
• Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period.
• Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created various jobs using SQL Server Agent.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meets business and system requirements.
• Documented the project work and process.

Environment: Confidential SQL Server 2012, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Visual Source Safe 2005, C#, SQL Profiler

SQL/SSIS/SSAS/SSRS Developer

Responsibilities:

• Created SSIS packages to migrate data from different data sources to the data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in enhancing and deploying the SSIS Packages from a development server to production server.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Developed complex reports using multiple data providers, user-defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Tools: & Technologies:SQL Server 2012, SQL Server BI Development Studio (BIDS) 2012, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server.

MSBI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in gather user requirements and system specifications.
• Developed stored procedures, functions and database triggers.
• Maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2000, SQL Server 2005 and SQL Server 2008 with latest service packs.
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel spreadsheet to SQL Server 2005.
• Migrated DTS packages to SSIS packages by modifying those packages.
• Migrated and recreated existing dimensions and cubes using Star Schema on SQL Server 2005 to achieve the efficiency of SSAS.
• Build MDX queries for Analysis Services and Reporting Services.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, crosstabs and charts.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
• Managed the security of servers, creating the new logins and users, changing roles of users.
• Involved in developing a logical and physical model of the database using Erwin.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Environment: SQL Server 2008/2005 Enterprise Edition, Visual Studio 2008, T-SQL, SQL Server 2005 Management Studio, SQL Analyzer and Enterprise Manager, SQL Agent.

MS SQL Server Developer

Responsibilities:

• Involved in Gathering end-user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
• Composed user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.
• Programming in SQL server using stored procedures, triggers, views, user-defined functions
• Involved in database design, normalization, de-normalization in building a data warehouse and reporting systems.
• Involved in query tuning by creating clustered and non-clustered indexes on tables, and used index tuning wizard.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Used event handlers for event handling which includes on pre-execute, post execute and error.
• Involved in package logging in both standard (SQL server and file-based) and custom logging using customer stored procedure and tables.
• Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using detect utility, command prompt with .bat files etc.
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Created ad-hoc reports more often based on end-user requirements.
• Involved in developing parameterized reports using single values, multi-values and cascading parameters.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, pdf, MS word and excel formats using SSRS (2005/2008).

Environment: SQL server 2000/2005/2008, SQL Query Analyzer, SQL profiler, SSIS, SSRS, SSAS, Windows Server 2003/2008, C#, .Net, Visual Studio 2008, MS Access

SQL Developer

Responsibilities:

• Involved in the installation of SQL server. Installed SQL server enterprise manager tools using SQL Setup.
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic.
• Optimized queries by looking at the execution plan for better tuning of the database.
• Designed and developed various complex reports using drill down, drill through, cross-tabbed reports etc.
• Responsible for ongoing maintenance and management of existing reports. Also to optimize report performance.
• Used Report manager to deploy reports, schedule reports and created groups and users.
• Designed and developed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup, merge join, fuzzy lookup, derived columns etc.
• Involved in automating SSIS packages using SQL server agent jobs, windows scheduler and third part tools.
• Implemented event handlers & error handling in SSIS and notified process results to various communities.

Environment: MS SQL Server 2005, SQL server Reporting Services 2005, SQL Server Management Studio, MS Excel, T-SQL