SUMMARY:

• 8+ years of experience as Microsoft BI developer, database developer and data analyst with Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP, OLAP (Different environment such as Production, UAT, and development) and Power BI in various domains.
• Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Support.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL
• Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Optimizing long running ETL packages by using different mechanisms.
• Experience in creating visualizations and dashboards in Power BI and publish them.
• Worked in creating different types of reports and data models in Power BI.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Migrated data in various formats like text files, Excel spreadsheets etc. to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience loading 1TB of data from multiple sources converted from text fields to database data types, transferred over the network, and inserted into a single destination server involving multiple partitions.
• Experience working on huge data, millions of records in a table.
• Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services.
• Experience in Providing the cube level security (Data level, Column level)
• Expert in creating several types of complex reports using SSRS (SQL server reporting services) such as Drill-Down, Parameterized, Cascading, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
• Extensive knowledge in Administering, Managing and Troubleshooting Reporting services.
• Efficient in creating Sub-Queries and Joins for complex queries linking multiple tables and Exception Handlers.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS. Created shared dimension tables, measures, hierarchies, levels and aggregations on MS OLAP/ Analysis Server (SSAS).
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Experience in using Team Foundation Server tool.
• Excellent problem solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment.

TECHNICAL SKILLS:

Modeling Tool: MS Visio

Methodologies: SDLC Waterfall, Scrum, Agile methodology.

BI Tool: SSIS, SSAS, SSRS, Report Builder 2.0/3.0, Power BI

Database Tools: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), Team Foundation Server.

GUI /Tools: MS Word, MS Excel, MS PowerPoint.

Database & Query Tools: SQL Server 2014/2012/2008/ R2/2005, Oracle, MS Access.

Operating Systems: Windows 98/95, Windows XP, UNIX, Windows 2007.

PROFESSIONAL EXPERIENCE:

Confidential, Houston,TX

Sr. Power BI Developer / MSBI Developer

Responsibilities:

• Working extensively in Power BI report creating tabular cube, creating data model for Power BI Report, Validating data quality of the report.
• Created different types of visualizations viz., geographical visualizations after slicing and dicing the account operations related data to analyze financial data across different locations of the bank.
• Experienced in working with DAX commands to pull up more calculated data out of the tables.
• Worked with data models with complex relationships in Power BI and connected different data sources to Power BI desktop.
• Published many reports and visualizations created to the Power BI service and thereby develop dashboards.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Review reporting outputs for transparency, consistency, and accuracy.
• Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Developed Stored Procedures for the Datasets to build the reports for the client requirements.
• Created SQL Joins, sub-queries and other SQL code to implement business rules.
• Performance tuning, and optimization of procedures and queries.
• Worked with the use of Data Modeling Standards for all projects requiring a standard means of defining and analyzing data within an organization, to manage data as a resource, for the integration of information systems, for designing Databases/Data Warehouses.
• Designed and developed SSIS Packages (.dtxs files) to import and export data from MS Excel, SQL Server, Oracle and Flat files.
• SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling.
• Created Package Configurations to deploy packages from development to production server.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Experienced in participating meetings with business users to gather the requirements.
• Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
• Worked with development teams in the design of physical databases and in modification.
• Involved in the process of Data Modeling which includes professional data modelers working closely with business stakeholders, as well as potential users of the information system.
• Participating to create Star Schema, Snow Flake Schema using the concept of data modeling with Team.
• Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, Lookup Table.

Environment: MS SQL Server 2012, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, T-SQL, ORACLE, Microsoft Office 2010, OLAP

Confidential, Mellon, NY

Sr. MSBI Developer

Responsibilities:

• Gathered end user’s requirements, Developed Logical Model, and implemented requirements using SQL server 2012/2008 R2.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Worked closely with project stakeholders and staff to understand requirement specifications new applications and redesigning existing applications.
• Prepared project Progress Report and Status Reports and submitted it to Top management on weekly basis.
• Created Data Flow Diagram (DFD) and Flow Charts to display the flow of information in the new system.
• Developed SQL scripts for administration task.
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Imported data from different databases (oracle, MS access etc.), build and scheduled packages, and defined integration flow using SSIS (SQL server Integration Services).
• Created ETL (Extract, Transform, and Load) packages to validate and load data in to data warehouse, database, and data marts.
• Designed and implemented parameterized, drill-through, drill-down and tabular reports using SSRS.
• Developed crossed reports, sub-reports and matrix in SSRS.
• Created complex queries to build the dataset required for developing the SSRS reports.
• Implemented/Developed multi parameterized reports using Report Builder and SSRS allowing users to make selections before executing the reports and making it more users friendly.
• Created different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.
• Designed, developed and implemented database systems and Stored Procedures based on Client requirements.
• Involved in database Schema Design, development and executed stored procedures Using Batch files.
• Built integrated reporting tools (Using Microsoft Power BI) with data from Sales, Marketing, and Finance systems.
• Experienced in developing different types of reports, maps and visualizations using Power BI to analyze the premiums paid and outstanding in the insurance accounts.
• Worked in creating Dashboards also as per the requirement in the project to analyze the performance metrics of different branches.
• Experienced in connecting different data sources to the Power BI desktop to generate reports and geographical visualizations as per the insights provided.
• Implemented the project using Agile/SCRUM methodology.

Environment: s: SQL Server 2014/2012, T-SQL, Windows 7, SSRS, SSAS, SSIS, Jira, Power BI, MS Visio, MS Azure SQL, Team Foundation Server (TFS).

Confidential, Sharon, MA

MS SQL Developer / SSIS/SSAS/SSRS Developer

Responsibilities:

• Worked as a technical developer for Clarityv13 upgrade changes for PMO Data Warehouse BI solution for Reporting.
• Involved in full Development Lifecycle of the PMODW Clarityv13 Upgrade Project.
• Analyzed the Technical Requirements for all the new attributes and changes in financial Plans for Projects from Source System.
• Designed the Dimensional Model for new data sources to be integrated using Erwin.
• Performed Design and Analysis of Data Warehouse and the new attributes need for all the Dimension and Fact tables.
• Experience with developing MDM solutions for multiple domains and building the models in Master Data Services (MDS) and using SSIS to pull the data from various sources into MDS.
• Written Technical Design Document for all the changes required in SSIS packages for the Data Warehouse.
• Developed various SSIS packages for ETL (extract, Transform and Load) operations
• Performance tuned the SSIS packages for speeding up the loads
• Used DQS to create knowledge-base of data and for data cleansing.
• Guiding and Leading the Team members in Everyday Development activities of the Project.
• Setting every day standup calls and Code Reviews for Day-to-day activities on the Project.
• Involved in unit testing and Integrated Testing of the Project.
• Developed Various Financial reports using SSRS and also MS Excel using Excel Pivots/Power Pivots.

Environment: Microsoft SSIS, SSAS, SSRS, T-SQL, SQL Server 2012, Master Data Services 2012, DQS, Oracle 11.2.0.3, Clarity PPM 12.1.1, Microsoft Visio, Power Point

Confidential

SQL Developer

Responsibilities:

• Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
• Worked and maintained SQL Stored Procedures, functions, and triggers for updating customer usage information in the database
• Merge tables and created views to support reporting requests using SQL Server
• Troubleshoot data and functionality issues related to reports, and SSIS packages
• Used several transformations in Data Flow including Derived-Column, Script, Lookup, Data Conversion, and Conditional-Split to categorize data for other departments
• Created complex SSIS packages using proper control and data flow elements with error handling
• Designed Data flows, Workflows and jobs to load data from source to target.
• Performed Documentation for all kinds of reports and SSIS packages.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS)
• Design daily table reports, matrix reports, sub-reports based on business needs using SSRS
• Created Reports using SSRS. Identified the data source and defined them to build the data source views
• Created reports in SSRS with properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Designed and created report templates, bar graphs, and pie charts based on financial data for analyzing performance counters using SSRS
• Created reports using features like drill down, drill through, parameterized reports. Developed yearly, quarterly, monthly sales reports and scheduled the reports to run on daily and weekly basis in report manager and also email them to project manager to review in Excel sheet

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, MS Access, Enterprise Manager, Management Studio, SQL Server, T-SQL, SSRS, SSAS, SSIS Packages, ETL, ODBC, Excel, Data Integrator, OLAP, OLTP

Confidential

SQL Developer/Analyst

Responsibilities:

• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Created Database Objects - Tables, Indexes, Views, User defined functions, CTEs, Cursors, Triggers, Stored Procedure and Constraints.
• Worked on Deploying Packages and providing security while deploying.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Tuned, monitored and maintained SQL Server Jobs.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.

Environment: s: SQL Server 20012, BIDS, T-SQL

Confidential

Credit Teller

Responsibilities:

• Processed credit applications related to many retail, commercial and corporate loans in a Loan Automated Processing System.
• Analyzed financial ratios using Ratio Analysis and derived all the efficiency, liquidity and profitability ratios to evaluate the financial performance of the borrower’s business.
• Reviewed and analyzed borrower’s financial statements to make a better lending decision.
• Experienced in preparing legal documentation as per the type of credit limit sanctioned complying the banking standards, acts and regulations.
• Extracted different reports of accounts with overdue credit limits, irregular payments, dormant accounts and Non-Performing Asset accounts status bi-weekly, monthly, quarterly, half-yearly and yearly to monitor and take regulatory measures to bring such accounts back to the regular status.
• Worked in branch monitoring by regularly checking the dormant accounts, accounts credited/debited with large value transactions, large cash transactions, suspicious transactions and take precautions to ensure safety of bank funds by complying with the Banking regulations like Know Your Customer (KYC) and Anti-Money Laundering (AML).
• Worked in Bank’s monthly and yearly audits by involving in planning and preparing for the audits.