SUMMARY:

• 8+ Years of IT experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience in Creating Power BI Dashboards and managing relationship between tables to calculate accurate Results.
• Worked on all activities related to the development, implementation, administration and support of ETL process for large - scale Data ware houses using SSIS 2008/2012/2013/2014.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Experience in MS SQL Replication, Log Shipping and knowledge of clustering techniques and Database Mirroring.
• Experience in Performance Tuning and Query Optimization.
• Developed ETL process by using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Worked on VBA scripting while creating macros
• Experience working on various Relational Database systems (Oracle, SQL Server, DB2) and Flat files.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions using Erwin.
• Strong knowledge of .Net Framework 3.5, 3.0 and 2.0. Extensively used libraries for writing custom code when developing expressions in SSRS and SSIS.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers.
• Hands on experience with SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS) and Crystal Reports for report, generation, and integration in to .NET applications.
• Experience in using Visual Source Safe (VSS), Clear Case, SVN and TFS for version controlling.
• Created DTS package for data transfer between the two environments.
• Experience in Creating Databases based on Functional Requirements and System Design.
• Experience in implementing different types of Replication models like Snapshot and Transactional
• Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Dot Net Technologies: AJAX, ASP.Net, ADO.Net, WCF, WPF, LINQ.

Frameworks: ASP.Net MVC 3.0/4.0, Entity Framework.

BI Technology: SSIS, SSAS, SSRS, Informatica Power Center 9.5.1/9.1.0/8.6.1 Informatica Data Quality 9.5.1(Developer, Analyst), Power Exchange.

Data Modeling Tools: Erwin 7.x/4.5/4.1

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2012/2008/2005/2000, DB2, MS Access.

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Perl, HTML5, XML, WSDL, XSLT, CSS, JavaScript, Perl Scripting.

Utilities/ Tools: TOAD, SQL* Loader, Visual Studio 2005/2008/2010/2012, SOAP UI, Microsoft Power BI.

Version Control: VSS, TFS, GIT, SVN.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia

Sr. BI developer

Responsibilities:

• Created SSAS cubes with dimensions, hierarchies, measure groups, and KPIs to analyze business units.
• Analyzed cube performance with partitions and perspectives utilizing SSAS.
• Created Power BI dashboards to improve the business efficiency.
• Developed measures by using MDX queries to get accurate results in SSRS reports.
• Created packages to extract data from SAP source to EDW by using SSIS.
• Migrated data from SAP data sources and AS400 to centralized EDW cube using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Responsible for developing source to target mappings.
• Designed ETL (Extract, Transform, Load) strategy to transfer data using OLEDB providers from the existing diversified data sources.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL Joins and other T-SQL code to adept business logic.
• Developed reports specifications, created and modified reports using drill down, drill through, and sub-reports in SSRS.
• Worked with project lead and business users to understand business processes, gather and document project requirements and translate into specifications for BI reports and applications.
• Resolved Job and package Errors.
• Exported the data mart data to the SQL Server Analysis Services (SSAS) server to make resources available to the users for as report needs and created reports containing all the information regarding the publishers, distributors and retailers using SSRS for internal and external use.
• Involved in developing initial load/incremental load ETL packages, Staging Data ETL packages, Package Test Script, and Report Requirements/Unit Testing Document and synchronized these packages/documents onto Team Foundation Server (TFS) and SharePoint.

Environment: SQL Server 2013, SSIS, SSAS, SSRS, Power BI, Power Pivot, Excel, DTS, T-SQL, ERWIN, SSIS, SSAS, SSRS.

Confidential, Philadelphia PA

Sr. BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Developed complex Stored Procedures and views to generate various Drill-through reports, ad-hoc SQL scripts, parameterized reports and linked reports using SSRS.
• Created SSIS packages for data extraction from various sources such as Flat Files, oracle provider and IBM provider to SQL Server.
• Migrated data using ETL Tool in SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Collaborated with Technical Architect to design the Data Warehouse to house data from various data sources and ERPs.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Used SQL Server Analysis Services (SSAS) to create cubes with various measures and dimensions for report generation.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Responsible for Analysing requirements, designing, maintaining and updating data models using ERWIN .
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Worked with various SSIS packages which involve Transactions and roll back techniques.
• Backup and recovery strategies in a test environment before and then moved it to the production environment and restoration procedures.
• Implemented automated backup and database maintenance/cleanup jobs.
• Wrote T-SQL queries and procedures for retrieval of data
• Tested backup and recovery strategies in a test environment before and then moved it to the production environment.
• Created and Managed Logins, Users, Roles and User permissions as and when required with specific roles on production server.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation using the DBCC commands.
• Troubleshooting client issues ranging from improper configuration settings or data corruption to issues in underlying code, working with product management to provide enhancement or other resolution.

Environment: SQL Server 2008R2, Windows 2003/2003R2/2008 Servers, Excel, DTS, T-SQL, ERWIN, SSIS, SSAS, SSRS

Confidential, Montgomery, AL

SQL developer / ETL developer

Responsibilities:

• Collecting requirements from business users and transforming them into logical and physical database designs.
• 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.
• Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
• Designing the SSIS packages to import data from flat file source to SQL Server database.
• Implemented Error Handling and Logging in SQL Server Integration Services (SSIS).
• Scheduling & Maintaining SSIS packages in terms of data validation and consistency.
• Used Informatica Power Center 9.6 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Works with data modelers to prepare logical and physical data models and adds and deletes necessary fields using Erwin.
• Developed PL/SQL and UNIX Shell Scripts to scheduled sessions in Informatica B2B and Autosys.
• Working with complex SQL, Stored Procedures, Triggers, cursors, and packages in very large databases from various servers.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Stored procedures were executed and the data extracted was displayed using Crystal Reports.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
• Created Packages that Transfers Databases from One SQL Server instance to Another Instance and Scheduled the SSIS package for migration of data from old system to MS SQL 2012
• Design and Develop new SSAS Tabular Models.
• Automated and enhanced daily administrative tasks, including space management, backup & Recovery and performance monitoring.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation using the DBCC commands.
• Heavily used Transactional Replication based systems to update databases in different physical locations.
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.
• Performed ETL operations to support the data loads and transformations using SSIS and used SSRS for generating reports to end-users.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• ETL process for the configuration Synchronization DST task and Report Task.

Environment: SQL Server 2012,2008,2005, Windows 2003/2003R2/2008 Servers, Excel, DTS, T-SQL, ERWIN, SSIS, SSAS,SSRS, BCP, Spot Light.

Confidential, Dallas, TX

SQL developer

Responsibilities:

• Extracting data from different sources (CSV files, oracle, and MS SQL) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS
• Created user defined data types and added them to model database for future purpose.
• Involved in migration from SQL server 2000 to SQL server 2005.
• Logical and physical database design using Erwin Data Modeling Tool.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations Suggested backup strategies.
• Extensively involved in the SSAS storage and partitions and Aggregations, calculation of queries with MDX, Data mining models, developing reports using MDX and SQL.
• Implemented automated backup and database maintenance/cleanup jobs.
• Performed ETL to support data loads and transformations using DTS Packages and SSIS.
• Exported and imported data from text files and Excel to SQL Server database using bulk copy insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Implemented, deployed and maintained Log Shipping.
• Performed DBCC utilities and fixed data corruption in application databases.
• Built cubes for production application, Partitioned Cubes to decrease processing time and increase the performance of the queries running on front end application using SSAS2008.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Provided support for in-house and offshore Development Team.
• ETL process for the report preparation DST task. Data extraction and transform and loaded into Databases.

Environment: SQL Server 2005, SQL Server 2008R2, 2008SQL Server R2, DTS, T-SQL, Oracle 10g, ERWIN, SSIS, SSAS,SSRS, Windows Server 2008,2003, MS Access, Excel, HTML, JavaScript, BCP, Spot Light.

Confidential, Boston, MA

SQL developer

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Deployed SSIS packages and Reports to Production Servers.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS), Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Implemented MY SQL coding.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, SSAS, C#, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential

SQL Developer/Administrator

Responsibilities:

• Installed and configured SQL server 2005 and set-up Various Databases.
• Installed and configured Oracle databases on Unix and Linux platform.
• Created all administration tasks of SQL Server and designed database
• Worked with development team in relation to application tuning.
• Created tables, views and indexes.
• Developed various stored procedures, cursors, functions and triggers.
• Created tables and provided constraints and user defined rules and defaults.
• Used system stored procedures and DBCC commands.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Designed a report on the monitoring of SQL Server Performance, which gave a detail report to the management on the Performance of the server.
• Scheduled backups and performed restore operations for system test data depends on testers requirement.
• Created logins and maintained user permissions appropriately.
• Wrote complex T-SQL queries and procedures for retrieval of data.
• Created DTS packages for migration of data from SQL Server to MS Access or Oracle databases.
• Performed daily backups and developed recovery procedures.
• Managed Disk space, memory and User connections.
• Performed DBCC checks and fixing data corruption in Application databases.

Environment: SQL Server 2005/2000 Windows 2000/2003 server, DBCC, SQL Profiler, Enterprise Manager, Query Analyzer.