SUMMARY:

• Over 6 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse Design, ETL, SQL SERVER, Power BI.
• Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Experience in designing and developing Star Schema, Snowflakes schemas and database modeling using Erwin tool and experience in OLTP/OLAP environment and Data Warehouse.
• Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS, Tableau, Power BI.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data mining, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi - dimensional expression (MDX), Perspectives and Roles.
• Expert in creating multiple type of reports using tools like Power BI and SSRS.
• Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.
• Worked as MS SQL Server Developer on enterprise and performance critical applications.
• Experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries involving multiple tables inner and outer joins using different database such as MS SQL Server, IBM DBA/DB2, Access, Oracle
• Involved in migration of legacy data by creating various SSIS packages
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS).
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through, Matrix, Tabular and Cascading reports using SSRS.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Experience in Handling Heterogeneous data sources and databases Oracle, flat file, and csv files using SSIS.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
• Strong knowledge and exposure to creating Jobs, Alerts, SQL Agent and scheduled SSIS Packages
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Experience in performance tuning the reports that includes modifying, Testing the required TSQL and queries using DMV's and creating the necessary environment for Deployment.
• Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

TECHNICAL SKILLS:

RDBMS/DBMS: MS SQL Server, Oracle, MS Access

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, SSIS, OLAP. Microsoft Visio

Reporting Tools: Power BI, SQL Server Reporting Services, Tableau, Excel.

Operating Systems: Windows XP, Windows Vista, Windows 7, Windows 8 T SQL, PL/SQL, HTML, Python, R, Windows Scripts

Design Technologies/Tools: MS Visio, Erwin

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, SSAS, Power BI, Tableau, MS Data Tools / Visual Studio Shell

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

SQL Server BI Developer

Responsibilities:

• Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic to Implement internal automation loading processes and ensured data delivery over FTP to alternative investment database on a daily basis.
• Develop solutions to create the weekly reports for the management about the performance and the actual investment activities using Tableau.
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
• Create SSIS packages and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into the development environment.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler and Index Tuning Wizard.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Create dashboard maintaining the statistics of the daily data extracted weekly using SQL Server and create jobs to automate it.
• Debugged, analyzed, and summarized reconciliation system issues and ensured data integrity maintained for all investment positions and portfolio and optimized SQL queries to improve production link performance by twenty percent and reduce total link processing time by forty percent without affecting functionality.
• Liaised with portfolio managers and accountants to troubleshoot and resolve flagged transactions in the reconciliation system, especially on the calculations relating to profit and loss, total gain and loss, and market value measurements.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation check during Staging, before loading the data into the Data warehouse to visualized routine reconciliation reports that generate HTML links in reconciliation system for internal references and distribution purposes on the accuracy and efficiency of new production links to ensure adherence to the trade strategies outlined in requirements.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Coordinating with IT department to source and structure data across diverse sources while managing data dependencies.
• Drove weekly discussions with team leads across departments and senior leadership to understand the firm’s technical systems and process regular/emergency requests on a consistent basis.

Environment: SQL Server, T-SQL, Tableau, SSIS (Integration Services), Flat files, Excel, OLTP, Microsoft Visio, FTP & SFTPserver

Confidential, Yonkers, NY

SQL Server BI Developer

Responsibilities:

• Provides analytical support in ETL activities related to how to best set up and leverage Confidential ’s optimization products.
• Gathers and organizes the data in order to track, report and monitor the effectiveness of controls and the tracking, monitoring and escalation of the risk related issues to management.
• Investigates data attributes within the various operational and reporting databases.
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Builds logics for automated data extraction and validation for ETL testing.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.

Environment: MS SQL Server, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Power BI Desktop, Power BI Service, T SQL, SQL Profiler, MS Excel, Windows.

Confidential, Morristown, NJ

SQL Server BI Developer

Responsibilities:

• Designed and developed Tabular Model Cubes and Dimensions using SQL Server Analysis Services (SSAS 2012).
• Worked on writing DAX queries and manipulating the multidimensional data in Tabular Model cubes.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Developed calculated columns and measures using DAX in Power BI
• Used the tabular model cubes as the source in Power BI to visualize the data.
• Created Power BI dashboard and generated reports.
• Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
• Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
• Published Power BI Desktop to the cloud.
• Created interactive reports customized for the business using Power BI Desktop.
• Installed and configured and maintained Power BI Report Server.
• Experience in combining data from different sources by using of Power Query
• Created some SSIS packages to import and export data from various data sources using SSDT.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on tuning up and changing some of the existing SSRS reports as requested by the user.
• Created few new reports for internal usage using SSRS
• Responsible for deploying the reports, cubes and packages on all environments.
• Scheduled the jobs for SSIS packages under SQL Server Agent.
• Deployed SSIS packages using Integrations Service Catalog.

Environment: MS SQL Server, MS SQL Server Analysis Services (SSAS), EDW, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, MS Excel, Windows, DAX Studio, M Query.

Confidential

SQL Server Developer

Responsibilities:

• Configured development environment.
• Experienced in database design process and data modeling (ERD) process.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Extracted data from various sources like .CSV, Microsoft Excel and Text file from Client servers.
• Used SSRS to generate Ad-hoc reports for personal financial tools; Migrated and integrated data from different departments and different types using SSIS, and implemented and analyzed OLAP cubes to generate pivot table in excel.
• Create various stored procedures like insert new came in data to corresponding table, update all customers’ score every month, and delete expired records, and for report generation.

Environment: MS SQL, SSIS, T-SQL, MS Word, MS Excel,, Microsoft Visio, Team Foundation Server, FTP & SFTP server