PROFESSIONAL SUMMARY:

• Having 8 years of experience in Designing, Developing and maintaining Databases/BI applications. A Wide range of expertise in SQL Server and BI Stack (SSIS, SSAS and SSRS) within multiple industries to include such as Media, Finance, Insurance and Healthcare.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS) , MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Proficient in creating Transact - SQL (DDL, DML, DCL and TCL), Indexes, Views, CTE, Complex Stored Procedures, User and System defined functions.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views and User defined data types, Cursors and Indexes using T-SQL.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical, Logical design, Data Mapping, Table normalization and Data Modeling.
• Extensive knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client /Server Applications.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• 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.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) .
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Sequence Container, For Each Loop, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Experienced in creating several types of reports such as Complex drill down and drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS .
• Experience in report writing according to the business requirement in SSRS .
• Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Service .
• Generated reports using Global Variables, Expressions and Functions using SSRS .
• Proficiency in creating several types of complex reports like Cascading parameters, Parameterized Reports, Crosstabs, Conditional, Pie Chart Reports, Drill-down, Summary and Sub Reports Developed Dash Board Reports.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS) .
• Worked on creation and deployment of cubes on SSAS for data with pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Created, Maintained and scheduled various reports in Power BI like Tabular Reports.
• Expertise in using Power BI and prepared dashboard reports for internal team progress tracking.
• Designing and development of various dashboards reports, using tableau desktop, with visualizations components like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and Geographic Visualization.
• Excellent communication skills, analytical skills, understand business requirements in various domains. Self-learning ability and leadership qualities.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C, C++, SQL, T-SQL, PL/SQL

Operating Systems: Windows Server 2003/2008/2012, (Mac & Linux), Unix

Databases: MS-SQL Server 2012/ 2008/2005/2000, MS-Access, Oracle

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS)

Scripting: HTML, DHTML, Shell Scripting

Reporting Tools: SSRS, SSAS, Crystal Reports, Tableau

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

Tools/Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Business Objects, Crystal Reports 9.0, XML, Visual Source Safe Visual Studio Team Foundation Server (TFS), Power BI (Power Query, Power Pivot, Power View, Power Map)

PROFESSIONAL EXPERIENCE:

Confidential, Rancho Cucamonga, CA

Sr. SQL/BI (SSIS, SSRS, SSAS) Developer

Responsibilities:

• Modified the existing stored procedures to get the new functionality depending on the client requirement. Created many tables with the cluster and non-clustered indexes on columns.
• Created various database objects such as tables, indexes and views based on the requirement.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs.
• Created Company level inventory, sales reports from OLAP Cubes using MDX Script.
• Created Weekly, Daily level reports from lowest granular level (store) to highest (company) granular level with lots of metrics.
• Introduced Power BI in company by evaluating Power BI and Tableau as earlier Crystal Reports were used.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Built Ad-Hoc reports in Power BI depending on business requirements was one of the major responsibilities.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Created reports with best fly-on performance and deployed reports to SharePoint site with good look and feel.
• Worked on the performance of reports, created appropriate indexes on tables and modified the code in existing stored procedures to get the quick response on SharePoint site.
• Attended functional testing meetings, user acceptance sessions and worked on the feedbacks.
• Created deployment documents for the reports and worked with database administrator in the deployment of the report objects to the production server.
• Optimized SQL Server query performance.
• Created multi-dimensional cubes using SSAS and designing DW schemas.
• Created perspectives in SSAS and configured security levels for the Cubes.
• Developed and deployed SSIS packages, configuration files and schedules job to run the packages to generate data in CSV files.
• Created SSIS packages to get the data from source (FTP Server) to staging environment using different transformations on daily basis.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Aggregated the data in staging environment using the stored procedure which involved in complex calculations and materialized the data to DataMart which is useful to create the reports.
• Created SSIS packages and daily jobs which sends the customer data from production server to other servers (E-com) on daily basis.
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Used SSRS 2005/2008 to build various kinds of reports based on requirements. Developed Drill-through, Drill-down, Sub reports, and Cascading reports.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS .
• Created ETL metadata reports using SSRS reports include like execution times for the SSIS packages, Failure reports with error description .
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer based on the requirements.
• Created the report which gives the status of the production server jobs, which is useful for the team to track if there are any failures.
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Used Team foundation server for sprint plan and database objects (ETL, Reports) check-in.

Environment: SQL Server 2014/2016, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL server Profiler, Microsoft Visual Studio 2010, Power BI, Team Foundation Server(TFS)

Confidential, Fort Mill, SC

Sr. SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Collaborated in gathering system specification requirements for the project.
• Collaborated in creation/review of functional requirement specifications and supporting documents during data modeling process.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Redesigned indexes to speed up query performance and utilized database engine tuning advisor for further suggestions.
• Created Triggers to enforce user defined integrity as per the business logic.
• Created tables, views, stored procedures, functions, CTEs and indexes in support of various databases and ETL applications.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created staging database to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Designed the end-to-end ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
• Developed complex mappings utilizing SSIS to transform and load the data from various source systems such as Oracle, Excel and Flat files into the SQL 2012 Server target staging database.
• Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Identified slowly changing transformation, to maintain historical data in data warehouse.
• Implemented Master/Child packages so only the master package needs to be scheduled which will in turn trigger the execution of other packages.
• Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.
• Configured data source and data source views, dimensions, cubes, measures, partitions, KPIs and MDX Queries utilizing SQL Server Analysis Services.
• Managed very large reports that return a large volume of records and optimized their performance utilizing techniques such as cascading parameters and filters.
• Designed several scorecards and dashboards utilizing Power Pivot and Tableau to display information needs by other departments and upper management.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Created, Maintained and scheduled various reports in Power BI like Tabular Reports, Matrix Reports .
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Provided production support on the existing Power BI dashboards and other ETL processes to resolve the issues quickly.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS) .
• Designed and developed standalone data migration applications to retrieve and populate data from Azure Table/ BLOB storage to an on-premises SQL Server instance.
• Created different schedules for report delivery to e-mails and shared directories, enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Collaborated TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization.

Environment: SQL Server 2012/2014, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL server Profiler, Microsoft Visual Studio 2010, Power BI, Team Foundation Server(TFS), Tableau, Share Point

Confidential, New York City, NY

Sr. SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• 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.
• Worked independently on a Project Called Back Order Relief Process for IPR (Inventory Planning and Replenishment) to build ETL process by gathering the requirements and pull data from multiple sources (flat files and Access DB) to SQL to provide Useful SSRS reports and Dashboard to the Business users.
• Also, worked on Order age reporting project, which helps the business monitor the Order fulfillment process and use the calculated On-time percentage metrics to determine the performance within the distribution center
• Worked on Onboarding the WMS (Warehouse Management System) Oracle data and landed the data tables on our production SQL Server with process indexing and considering other constraints.
• Created volatile tables and partitioning the tables and responsible for supporting existing projects using Teradata SQL assistant tool.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.
• Migrated data from Heterogeneous Data Sources to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed and responsible for development of Dashboards in Tableau.
• Experience in creating reports and performing business analysis in Tableau.
• Developed various operational Drill-through and Drill-down custom reports using .Net framework within SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
• Production support, troubleshooting and debugging in a high-volume transaction processing environment.
• Support existing projects over the holiday season to ensure the business had all the data and reports available.

Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), SQL Server Integration services (SSIS), Business Intelligence Development Studio (BIDS), MS Excel, MS Access, Windows XP, SQL Server Management Studio (SSMS).

Confidential, CA

SQL/SSRS/SSIS/SSAS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Worked on OLAP Data warehouse, Model, Design and Implementation.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Developed Parameterized, Drill-through and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Scheduling the SSIS packages and Jobs.
• Improved Performance by creating Clustered and Non- Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MS SQL Server 2008, T-SQL, Power pivot, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio), Visual Source Safe (VSS).

Confidential

Jr. SQL Developer

Responsibilities:

• Conducted Performance tuning/MS SQL server development-SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, advanced queries, views and functions for databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: MS SQL Server 2000/2005/2008, T-SQL, DTS, Oracle 8i/9i, TOAD, Micro strategy, Microsoft Visual Source Safe, MS Visio 2007, MS Projects 2007.

Confidential

Jr. SQL Developer

Responsibilities:

• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Installed, authored and managed reports using SQL Server 2005 Reporting Services.
• Analyzed the project environment and sub systems of the project and prepared a high-level documentation for application designing.
• Responsible for gathering business requirements, developing and reviewing of design documents.
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintained the database consistency with DBCC at regular intervals.
• Involved in development activities included hardware and network specification, installation and configuration and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2008/2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.