PROFESSIONAL SUMMARY:

• Over 8+ years of experience in the field of Information Technology with proficiency in SQL/SSIS/SSRS/ETL design and Data Warehouse Implementation/development for Banking, Finance, Health Care, Pharmaceutical, Telecommunications, B2B and Sales (POS) business sectors.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Strong working experience in SQL Server and T - SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non-Clustered indexes on tables.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data profiling and other database related activities.
• Created new cubes and modified existing cubes using SSAS 2012 to make data available for the decision makers.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Very aware of the changes made to Configuration files and deployment models and other changes in SQL Server 2012.
• Experience in deploying packages to Integration Services Catalog in SQL Server 2012.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Un-Block Transformations.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• A thorough professional with proactive attitude, out of the box thinking and generating new ideas.
• A keen communicator with the ability to relate to people across all levels in the organization.
• Have worked in rapid development/ agile model.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Un-Block Transformations.

TECHNICAL SKILLS:

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

Databases: MS SQL Server 2016,2014,2012,2008R2,2008,2005,2000, Oracle 9i/10g (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), Visual Studio, Crystal Reports.

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 techniques.

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

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, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot. Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

BI (ETL, SSIS, SSRS, Power BI)/SQL Developer

Responsibilities:

• Working as an application developer (SQL Server) and well versed in Business Intelligence Development (SSIS, SSRS & SSAS) for different Financial and Investment applications.
• Involved in Technical decisions for Functional requirements, Data Mapping, Data Directory Interaction with Business Analysts, Client team, Development team.
• Migrated data from SQL Server 2012 to the SQL Server 2014/2016 using SSIS.
• Developed stored procedures, views and User Defined Functions using MS SQL statements.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL.
• Back end Experience in MS SQL Server development, writing MS SQL stored procedures, views, triggers, cursors, UDFs.
• Created data queries and reports using WellView, QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
• Created Interactive dashboards on Finance data mart and Finance data using advanced Microsoft Visuals in Power BI.
• Advance level data manipulation is done in Excel.
• Created Pivot tables using Power Pivot and Power Query.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in POWER BI.
• Created Roles and implemented Row level security for user Authentication in POWER BI.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types. Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules.
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions.

Environment: MS SQL Server 2012/2014/2016 , Business Intelligence Development studio (SSRS/ SSAS/SSIS), Power BI, Tableau, Oracle 11g/10g/9i, MS Office Access 2003 and Visual Studio 2008, .Net 3.5, Team Foundation Server 2010, Agile Methodology.

Confidential, Philadelphia. PA

BI Developer/SQL Developer (ETL, SSIS, SSAS, SSRS, Power BI)

Responsibilities:

• Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look-ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Maintain and optimize the existing databases; monitor database performance and growth, performance tuning, generate reports according to the business requirements using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service (SSIS).
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Created Interactive dashboards on Health Care and Insurance data using advanced Microsoft Visuals in Power BI.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in POWER BI.
• Created Roles and implemented Row level security for user Authentication in POWER BI.
• Generated daily, weekly and monthly reports for the managers.
• Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.

Environment: MS SQL Server 2005/2008/2008 R2/2012, Business Intelligence Development studio (SSRS/ SSAS/SSIS), Oracle 11g/10g/9i, MS Office Access 2003 and Visual Studio 2008, .Net 3.5, Team Foundation Server 2010, Agile Methodology (Spring, SCRUM)

Confidential, Louisville, KY

SQL Developer/T-SQL/SSIS Developer/SSRS Developer

Responsibilities:

• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Loaded data from ODS to Data Warehouse using SSIS packages.
• Experience in SSIS script tasks, look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• Using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2012.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.

Environment: SQL Server 2012, SQL Server R2 2012, SSIS, SSRS, SSAS, Visual Source Safe 2012, Erwin 4.0, MS Excel 2007, C#, VB.Net, Windows Server 2010.

Confidential, Bloomington IL

BI Developer/SSIS/SSRS

Responsibilities:

• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Used Script task for Data Flow and Error Handling in SSIS.
• Responsible for ongoing maintenance and change management to existing reports and optimizer port performance in SSRS-2008.
• Used Reporting objects like Tabular, Matrix, Sub Reports, and Parameterized reports using SSRS.
• Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients
• Extensively worked in migrating office writer reports to SSRS-2008.
• Participated in Databases Architecture and data modeling design.
• Interacted with the Business Admin and gather the requirements and analyzed them.

Environment: Microsoft SQL Server 2008 R2, T-SQL, SSIS, SSRS, Visual Source Safe, MS Excel, Performance Point Server 2007.

Confidential

SQL Server Developer/SQL DBA

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 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, JavaScript, SQL Server 2016/2014/2012/2008 R2, Crystal Reports XI/10, SSIS, SSRS, SSAS, T-SQL, Windows Server 2008/2008 R2 Visual Studio 2008.

Confidentia

SQL Server Developer/SQL DBA

Responsibilities:

• DesignedSSISpackages to load data from different sources Text files, Excel to staging and staging to Data warehouse.
• Applied different transformations,Control,Lookups,SCD,and DerivedColumnto migrate SSIS package from one server to another.
• Implemented the concepts ofIncrementalDataLoad, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Scheduled theETLProcess using Jobs. Created Alerts for successful and unsuccessful completion of scheduled jobs in SQL Server Agent.
• Reduced the overall ETL Time by SQLQueryPerformanceTuning, Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Scheduled batch scripts inSQLAgentwith various steps to run the SSIS packages.
• Designed and implemented various Parameterized and cascading parameterized reports.
• Created and integratedUserDefinedFunctionsand Stored Procedures for reporting purposes.
• CreatedCharts,TabularandMatrixreports using SSRS andCrystalReportswith/withoutDrilldown.
• Created Crystal Reports and hosted them in the web for the users.
• Generating reports that can handle DynamicGroupingand DynamicSorting.
• CreatedAd-HocReports, Summary Reports,SubReportsand Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS).
• Creation ofClusteredandNon-ClusteredIndexes for query performance and generated various reports using complex stored procedures.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages and PDA as well as window messengers.

Environment: SQL Server 2016/2014/2012/2008 R2, Crystal Reports XI/10, SSIS, SSRS, SSAS, T-SQL, Windows Server 2008/2008 R2 Visual Studio 2008.