SUMMARY:

• 9 years of experience in design, development, management and analysis of databases/Data warehouses, extraction/transformation/loading (ETL) design & implementation (SSIS), OLAP cube design and construction (SSAS), report development (SSRS) as well as troubleshooting and performance tuning using the SQL Server 2005/2008/R 2/2012/2016. Also created a lot of reports using Power BI.
• Experienced in all the stages of Software Development Life Cycle (SDLC) and in the migration and up - gradation of databases.
• Forward and reverse engineered the logical/physical data model designs using Erwin data modeling tool.
• Adept in developing and debugging complex stored procedures, triggers, tables, user defined functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Efficiently monitored and tuned the performance of Complex T-SQL scripts by analyzing the execution plans, updating the statistics and also using tools like SQL Profiler and Database Tuning Advisor (DTA).
• Actively involved in the enterprise Data Warehouse designing using Kimball/Inmon design methodologies and following DW Design best Practices.
• Adept in staging DB design, Data Warehouse analysis, ETL strategies, and design of optimal and efficient OLAP cube strategies based on infrastructure as well as cube size.
• Migrated data from Oracle, Flat file, Excel to Microsoft SQL Server by using SSIS different tools like SSIS, BCP and BULK INSERT for the implementation of ETL strategies.
• Implemented Script Component as Source, Transformation and Destination depending on the requirement using C#/VB.Net script.
• Worked with XML and SQL table configurations for deploying the SSIS Packages from a test/development environment to the production servers for day to day operation.
• Proficient in developing, maintaining and optimizing multidimensional cubes by creating query bounded partitions, usage based optimizations and using proper storage modes like MOLAP, HOLAP and ROLAP.
• Actively involved in data parsing for JSON API to populate data into the SQL Server database.
• Involved in creating and modifying the SSAS navigation and aggregation hierarchies which will provide significant improvement in analysis and report drill down.
• Well versed with SSRS reporting lifecycle, authoring, managing, accessing report stages.
• Designed reports like tabular, matrix, parameterized, sub reports, drill down/drill through reports from Relational databases and OLAP Cubes using SSRS.
• Generated Report Models to support Ad-hoc reporting and created reports from models using Report Builder.
• Experience with the formatting of reports for various visual representations using conditional formatting and templates.
• Proficient in configuring the Report Server and Report manager to set up roles and security on the reports.
• Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS.
• Created a lot of reports in Power BI. Also converted existing reports from SSRS to Power BI.

TECHNICAL SKILLS:

Data Modeling: ER Win, MS Visio

RDBMS: MS-SQL Server 2008/R2/2012

BI Tools: SSIS, SSRS, SSAS, BIDS/SSDT, MS Share point 2010, TFS, Power PivotPower View, Power BI

Database Programming: SQL, T-SQL, PL/SQL

Programming Language: C, C++, C#

Others: Matlab

PROFESSIONAL EXPERIENCE:

Confidential, Glendale, CA

SQL/SSIS Developer

Responsibilities:

• Monitored the incoming data because of daily jobs and other regular processes to identify the impact on the server. Performed cleansing of the data and loaded in the production server.
• Monitored the already designed ETL packages and their respective SQL Server jobs to see the performance of the packages.
• Redesigned already existing data flows and packages to optimize them for better performance during the holiday season. Some of them included redesigning the stored procedures and performance tuning for SQL queries. Performed query optimization by eliminating redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Redesigned the tables in the package by changing the columns needed and created flat files for the tables to be loaded to an SFTP server.
• Worked on a new holiday subscription project to develop tables and sent the data in the form of an API (Application programming interface) to the permission center.
• Designed an SSIS package to deserialize and parse JSON API and perform error handling transformations to load the data into SQL server databases.
• Created triggers and audit tables to monitor the data and report any data issues using inserted and deleted tables.
• Created views for Microstrategy reporting as required by the end users.
• Created complex stored procedures and modified them to support efficient data storage and manipulation.

Environment: Microsoft SQL Server 2012/2016, SSIS, MS Access, Flat Files, Excel Power BI, SharePoint, Visual Studio, TFS, C# .NET, Postman, JSON API, Microstrategy

Confidential

SQL/SSIS/SSRS Developer

Responsibilities:

• Monitored the incoming data because of daily jobs and other regular processes to identify the impact on the server. Performed cleansing of the data and loaded in the production server.
• Created views to facilitate easy user interface implementation, and triggers on them to assist consistent data entry into the database.
• Performed T-SQL Tuning operations at various levels by embedding code into a Stored Procedure, making proper use of Indexes and Partitions as well as using SQL Profiler and Data Base Engine Tuning Advisor.
• Monitored all the packages that were scheduled. Involved in debugging the Packages by utilizing SSIS features like breakpoints, event-handlers, Data-Viewers and custom loggings.
• Incorporated Error Redirection during ETL load in SSIS packages to identify dimensions and facts that were not properly populated.
• Involved in the troubleshooting of SSIS Packages, managing their configurations to transfer data from production to other databases.
• Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented.
• Created package configurations and deployed the SSIS packages to SSISDB catalog in SSIS
• Enabling Checkpoints on already implemented transactions so as to optimize entire ETL strategy so as to start the package execution from latest point of failure.
• Created several business specific Stored Procedures for generating various kinds of daily and monthly reports for different Business Requirements. These reports were utilized by Business Analyst to keep track of Referrals for the Customers.
• Created the design documents for the entire project including table structures and design logic of stored procedures, packages and Reports.
• Created ad-hoc reports, and enterprise reports (parameterized, drill down, drill through and cascading) using SQL Server Reporting Services and Report Manager.
• Created a lot of reports for the county using .NET C# reporting where C# is used in the front end and SSRS in the back-end.
• Generated reports from OLTP using Report Server Project by creating a Report Model.
• Optimized reports at Server, Report and Item levels using various Roles Assignments on Report Manager.
• Delivered on demand reports in different rendering formats using Standard and Data Driven Subscriptions.
• Effectively handled data errors during the modification of existing reports and creation of new reports.
• Effectively converted a lot of reports from MS Access to .NET C# reporting.
• Reporting Platform changed to Power BI and converted some of the SSRS reports to Power BI on-premises version.

Environment: Microsoft SQL Server 2008/R2, BIDS/SSDT, SSIS, SSRS, SSAS, MS Access, Flat Files, ER-Win, Excel Power BI, SharePoint, Visual Studio, TFS, C# .NET

Confidential, Mammoth Lakes, CA

SSIS/BI Reports Developer

Responsibilities:

• Involved in analyzing business requirements that will facilitate the planning and the implementation phase of reporting application by conducting various JRD sessions.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Wrote TSQL scripts and complex Stored Procedures to implement the business needs and to support the front end applications.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Used SSIS to extract, transform and load data from multiple input sources and loading into SQL Server.
• Used control flow tasks and container as well as Transformations in a complex design to build an algorithm to cleanse and consolidate data.
• Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
• Identified and handled early arriving Facts and late arriving dimensions using inferred dimensions.
• Was responsible for detecting errors in ETL Operation and rectify them using event handlers and debugging techniques.
• Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods.
• Created complex stored procedures to perform Index maintenance, data profiling, for loading data marts and generating datasets for reports.
• Written and optimized procedures in PL/SQL for data cleansing in Oracle OLTP feeding SSRS reports.
• Followed the regular reporting life cycle Analysis, Design, Development, Testing and Scheduling to develop User Interface Reports and created several reports using SSRS like drill through reports, linked and sub reports using SSRS and Power BI.
• Identified and defined the Datasets for the report generation, encapsulating multiple select statements into stored procedures, identifying and adding the report/query parameters, and written PL/SQL queries to pull data from Oracle databases etc.
• Created several business reports like Patient Recovery, Patient Cost of treatment, Patient medication, lab test results, etc. using SSRS.
• Utilized conditional formatting to create reports which provide a visually appealing and descriptive representation.
• Created Document Map for easy navigation to the particular section of the report.
• Used Power View to create various analytical reports depicting critical KPIs along with slicers and dicers enabling end-user to make filters.
• Used 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.
• Installed, Configured and managed Report Server and scheduled report delivery using Data Driven Subscriptions in SSRS.

Environment: SQL Server 2012, T-SQL, MS Excel, Erwin, Windows Server 2008R2, SSDT, SSIS,SSAS, SSRS, C#.Net, SharePoint, Power Pivot, Power View, Power BI, TFS.

Confidential, Los Angeles, CA

SQL/SSRS Developer

Responsibilities:

• Conducted JAD sessions with users and business clients to gather specific requirements and expectations and implement effective reports design.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Analyze the requirements and fine-tune the stored procedures to improve performance.
• Created views to facilitate easy user interface implementation, and triggers on them to assist consistent data entry into the database.
• Created PL/SQL scripts to extract the data from the Oracle database to feed reports using linked server.
• Performed T-SQL Tuning operations at various levels by embedding code into a Stored Procedure, making proper use of Indexes and Partitions as well as using SQL Profiler and Data Base Engine Tuning Advisor.
• Designed, developed, deployed and delivered various business specific reports in MS SQL Server environment using reporting services.
• Developed complex reports with multiple datasets and heterogeneous sources viz. Oracle and SSAS cubes and created the automation process of report generation and distribution.
• Involved in creating various banking reports like bank deposits, Un-deposited Funds report, Reconciliation Reports, Cash Flow analysis reports, recurring transaction reports, etc.
• Created several business specific Stored Procedures for generating various kinds of daily and monthly reports for different Business Requirements. These reports were utilized by Business Analyst to keep track of Referrals for the Customers.
• Created ad-hoc reports, and enterprise reports (parameterized, drill down, drill through and cascading) using SQL Server Reporting Services and Report Manager.
• Generated reports from Cubes using Report Server Project by creating a Report Model.
• Configured the data sources to store the credential to so that snapshot can be created of the report.
• Designed several scorecards and dashboards using Power Pivot to display information needs by other departments and upper management.
• Using Power Pivot, and created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the company at a glance, also interact with data as necessary and deployed those to SharePoint Server.
• Exported data from a report to several file formats likes PDF, Image and Excel according to the needs of management.
• Optimized reports at Server, Report and Item levels using various Roles Assignments on Report Manager.
• Deployed reports to the Report server in Native Mode and SharePoint integrated mode and implemented Report delivery using Standard and Data driven Subscription in SSRS.
• Effectively handled data errors during the modification of existing reports and creation of new reports.
• Configured report server to stored report server activity information in the trace file to see the report server performance.

Environment: Microsoft SQL Server 2008R2, BIDS, SSRS, SSAS, MS Access, Oracle, Flat Files, ER-Win, Excel Power Pivot, SharePoint, Visual Studio, TFS

Confidential . Bank, Los Angeles, CA

BI/SSRS Developer

Responsibilities:

• Optimized the performance of various T-SQL scripts, stored procedures and triggers by using embedded UDFs, Recursive CTEs and System stored procedures.
• Designed SSIS packages to migrate the data from SQL Server to the Staging Area.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Production Environment from Development Environment.
• Participated in designing Logical data models for the Data Warehouse and implemented the logical design to the physical design by creating tables.
• Enforced the Business Rules by creating constraints in both the production and relational data warehouse databases.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code or by replacing them with UDFs to optimized performance of front end applications.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Created cubes using the SQL Server Analysis Services in support of front end applications, reports using Bottom up design.
• Designed new Aggregations by creating Hierarchies and then pre calculating the Aggregations using Aggregation Wizard in SSAS
• Implemented new and complex Calculated Members that will be permanently stored in cubes to boost query performance of reports.
• Created KPIs that will track the response and behavior of customers based on the project Requirement Documents.
• Used different layout such as Matrix, tabular, chart, Tablix to display data in a grid format, with layout possibilities ranging from simple tables to advanced matrices.
• Created many complex PL/SQL stored procedures to pull data from Oracle and used them in Reporting Services directly to generate reports on the fly.
• Designed different types of reports such as Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services (SSRS) as well as managed the subscription and authentication of these reports.
• Created report models from cubes as well as relational data warehouse to create ad-hoc reports and chart reports. Ad hoc reports were used to validate the information inserted to the warehouse.
• Using Power Pivot, and created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the company at a glance, also interact with data as necessary and deployed to SharePoint Server.
• Created interactive dashboards using SSRS Chart Data region and deployed on SharePoint server.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.
• Involved in creating report snapshots and cache for better performance as well as deploying and scheduling reports.
• Scheduled the delivery of reports in different formats such as PDF and excel using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Environment: Microsoft SQL Server 2008R2, Windows Server, SSAS, SSRS, Erwin, T-SQL, BIDS, SharePoint, TFS, Power Pivot, Oracle

Confidential, Chula Los Angeles, CA

ETL/ SSRS Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and Online System Specification.
• Modified existing database by adding tables and relationships to support online system.
• Created views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation.
• Created Triggers that Audit the data that is being inserted/updated/deleted from heterogeneous sources.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Optimized the performance of queries with modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Processed the cubes by using Process Default and Process Increment options through SSIS Packages.
• Created alerts and mail confirmation of all packages and cube processes in SQL server Agent to get event messages such as success/failure of package, procedure.
• Created score cards with executive summary dashboards using MS Office Performance Point Server 2010 Dashboard Designer and Power BI that display performance monitoring measures viz. Average waiting time for patients, Patient stay time, doctors performance, etc.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Used report server configuration manager to perform some administrative actions like taking the back of encryption keys.
• Documented the user instructions, demo SSRS solution to business users as well as provide production support and troubleshooting of the SSRS/Power BI reports.

Environment: SQL Server 2008, SSIS, SSAS, SSRS, Query Analyzer, T-SQL, Excel, Visio, BIDS, DTA, SharePoint.

Confidential

SQL Developer

Responsibilities:

• Involved in interacting with the Business Users and the Business Analysts to understand the requirements for development.
• Involved in Normalization and De-Normalization of existing tables wherever needed, for faster query processing.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the query execution time.
• Created different SSIS packages to extract data from Excel and SQL Server connection source to create dimensional model for reporting purposes.
• Designed several SSIS packages for implementation of ETL loads for the data warehouse and included proper error handling, optimization and configuration techniques.
• Implemented Change Tracking tasks in SSIS to capture the changes of Providers demographic details.
• Used Cache Transform task to look up with the data coming from flat file to load the data in the Fact Table for a measure.
• Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.
• Managed Package configurations for SSIS Packages in both XML files and SQL Server Tables.
• Schedule various reports to be generated on predetermined time using SQL server Agent then deliver it to user base on subscriptions.
• Performed report testing and Verification as per internal reporting system requirements.
• Generated daily, weekly and monthly reports regarding assigned projects to designated managers and clients
• Created various data driven subscriptions on a monthly and a quarterly basis for different reports based on requirements.
• Authoring customize dashboard and scorecard base on the requirement provide by business user.
• Reports were deployed to dashboards report center producing different summary results based on user view and role membership.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.

Environment: SQL Server 2008, SSIS, SSRS, BIDS, SSMS, T-SQL, Excel, Erwin, Windows Server, Profiler