SUMMARY:

• Around 8 Years of extensive IT experience as a Microsoft SQL Server 2000 /2005/2008/2008 R 2/2012/2014. Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Retail, Finance and HealthCare.
• Experienced SQL - Server Developer in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Excellent knowledge in creating Databases, Tables, Stored Procedures using SQL, T-SQL (DDL, DML, DCL). Designing logical/physical databases and Troubleshooting.
• Knowledge in Creating and maintaining database objects, Triggers, Cursors, Views, Indexes, SQL Joins and other statements for various applications.
• Good knowledge in Tuning SQL queries & improving the performance of the Database.
• Experience in various Extracting, Transforming and Loading (ETL) tasks using SQL including tools like BCP utility, SSIS Packages with proper control & data flow elements, Import Export Wizard.
• Working knowledge of transforming data from various data sources using OLE DB connection by creating various SSIS Packages (SQL 2005).
• Extensive Knowledge to Plan, install, configure and perform upgrades of SQL Server 2005 database on various platforms as well as migrating and relocating from one OS platform to other.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization.
• In-depth knowledge on SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Worked on different data modeling tools like Embarcadero.
• Comprehensive technical, oral, written and communicational skills
• Very good Knowledge in database design using MS Visio.
• Built several Power BI dashboards connecting to different sources.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PHP

SQL Server Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer, Oracle

Databases: SQL Server 2008R 2/2008/2005/2000, MS Access

Operating Systems: Windows Server 2014/2012/2008 R1/2008R2/2003/2000 Windows 2007/2008/ NT/95/XP, UNIX

ETL Tools: DTS, SSIS, BCP, Import/Export Wizard, BI Studio, Infromatica

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, MS Excel, Power BI

Business Tools: Word, Excel, PowerPoint, Access, Outlook, Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Conshohoken, PA

Sr SQL BI Developer

Responsibilities:

• Automated the daily/ weekly manual process using SSIS.
• Automation includes, get the latest file from FTP server using FTP Task and move to local folder, load the data into SQL table and move the file to Archive folder using File System Task.
• Process the new data in SQL Table by running multiple SQL scripts and Stored Procedure.
• Load the processed data to flat file using Flat File Destination component and generate filename based on the requirement using Expression Task and save the file in local folder.
• Encrypt the file to. pgp format using Execute Process Task by writing pgp command line.
• Push the encrypted file to ftp folder using FTP Task and send out a system generated email to the users mentioning the status of daily/ weekly process.
• Deployed SSIS package in SQL server Management Studio using SSISDB catalog and created a job in SQL server agent to invoke the SSIS package.
• Created Stored Procedure to call the SSIS package deployed in SQL Server and created an Excel Macro with a button which calls the stored procedure, by which the SSIS package is been triggered on demand.
• Created Stored Procedures using HTML script to send an email to the users and team once the process is completed.
• Built a tool using SSIS and SQL server for PACE to load the data from multiple excel spreadsheets to SQL server database and undergo standardizing/processing of the data and export the data to new excel spreadsheet with a desired name and send out an email to the user on successful completion.
• Acted as a DBA by deploying the scripts in different environments like prod/qa/dev and resolve the issues in case of any occurrence.
• Created new databases based on the requirement and allocated the desired amount of storage space.
• In case of any spacing issue, could delete unwanted data from several databases.

Environment: MS SQL Server 2000, T-SQL, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.

Confidential, Conshohoken, PA

Sr.SQL BI/Power BI Developer

Responsibilities:

• Experienced in extracting data from various data sources like: SQL server, raw file, flat file, Excel, and OLE DB sources from Client servers.
• Worked on different packages with various types of transformation tool like: Lookup, fuzzy Lookup, derived column, join, merge join, conditional split and slowly changing dimension.
• Expertise in troubleshooting ETL packages by implementing SSIS functionalities, like: breakpoints, checkpoints and event handler.
• Utilized configuration tables to update multiple SSIS packages simultaneously.
• Tune ETL procedures to optimize load and query Performance.
• Prepare all ETL processes according to business requirements and in corporate all business requirements into all design specifications.
• Implemented Custom Logging, Auditing and custom Email notifications using SSIS.
• To analyze performance, used: Calculation, KPI, Derived column and hierarchy. Also created MDX Multidimensional Expressions scripts and built reports on top of cubes.
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• Once the data is extracted from different sources, built several Power BI dashboards like: Clustered column chart, Stacked column chart, Pie chart, Matrix, Heat map and many more.
• Used Slicer to view the dashboard for desired time.
• Once the dasboards are built, published on different workspaces where consumers can go look at it and give their feedback.
• Connected to different sources like, SQL, Access DB, Excel, Azure SQL Databse.

Environment: SQL Server 2014/ 2012/2008 R2/2005, Query Analyzer, Microsoft PowerBI, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2014/XP, SharePoint server 2007.

Confidential, Princeton, NJ

SQL/BI Developer

Responsibilities:

• Load multiple flat/excel files into database and undergo some data validation and data reconciliation using SSIS.
• Send a report with the status and the numbers to the finance department once the data load is completed successfully.
• Using a third-party software called Insurity to load the data into data warehouse, by writing C# script.
• Created several Stored Procedures to display the data in IEV format.
• Used ADO.NET connection to load the data from multiple sheets with different format each.
• Created SSIS packages to load the data into Type1 table from excel spreadsheet using Excel Source component in SSIS.
• Deployed SSIS packages in SSMS and scheduled them using SQL Server Agent to run on regular intervals.
• Created several Cascading Parameterized and Drill Down/Through reports for the business to view the data monthly.
• Worked on performance tuning of long running queries/stored procedures to run the queries faster and effective manner.
• Used Actual and Estimated execution plan during the process of performance tuning.
• Migrated data from different sources to destinations using stored procedures, SQL server agent, JAMS job scheduler and SSIS packages.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Created different Tableau dashboards based on requests.

Environment: SQL Server 2014/ 2012/2008 R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2014/XP, SharePoint server 2007, Insurity.

Confidential, Chester brook, PA

SQL/BI Developer, DBA

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Involved in the entire System study, analysis and Design.
• Developed SQL Queries to fetch complex data from different tables in remote databases. using joins, database links and formatted the results into reports and kept logs.
• Installation, configuration of MS SQL Server 2000 for development and testing purpose
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases, using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of T -SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Data migration (import & export - BCP) from Text to SQL Server.

Environment: SQL Server 2014/ 2012/2008 R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2014/XP, SharePoint server 2007, FileZilla, Winscp.

Confidential, Philadelphia, PA

Lead SQL/BI Developer

Responsibilities:

• Worked closely with data architects and provided valuable inputs on building a new database design.
• Identified the list of SQL objects which needs to be worked on by the requirements given by business.
• Red gate’s SQL search tool has been used to identify the list of SQL objects using the requirements given.
• Analyzed all SQL objects and documented code rationalization.
• Analyzed Referential Integrity of the database and documented and replicated the same to another database with better changes wherever needed.
• Created tables with primary and foreign keys to satisfy the database design.
• Created Synonyms to give an alias to an already existing or potential new object.
• Created Schemas to simplify administration of security, backup and restore.
• Created complex stored procedures to load the data from one database to another daily, by implementing restart ability, traceability, change data capture (CDC) and code rationalization.
• Scheduled jobs to execute Stored Procedures which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Extracted data from internal data warehouse system to SSRS
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Designed ER diagrams and mapped the data into database objects and involved in normalization of the database in OLTP.

Confidential, Philadelphia, PA

SQL/BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Designed and created SQL tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Created User Defined Functions, Stored Procedures, and Triggers.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in creating SSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Created data loads and Performed Data validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Monitoring the jobs in case of heavy data loads and high memory usage.
• Used MS Team Foundation server for Code Check -in and check out.
• Prepared documentation related to database design, Low-Level-Design Documents, Service Level Agreement and Unit testing plan and scripts

Environment: SQL Server 2005, 2008, 2012 MS Excel 2007, & Windows 2000 and 2003 platform, SQL, UML, C#.NET, HTML, ASP, MS PowerPoint, MS Project

Confidential, Riverside, CA

SQL/BI Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, Cross-Tab reports, drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.

Environment: SQL Server 2005, Windows 2000/2003, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005, Visual Team Foundation Server, Crystal Reports.