SUMMARY:

• To seek a good position where I can efficiently contribute my skills and abilities for the growth of the organization and build my professional career.

PROFESSIONAL EXPERIENCE:

Power BI/SQL SSIS SSAS Developer

Confidential, Columbia MD.

• Created Daily, Monthly and Yearly Report s for North America and South America sales and Implemented Dynamic Row level security for Revenue Reports.
• Merged and appended data in to the Power BI reports by creating relationship between the tables. Wrote complex DAX functions to create Calculated Measures and Columns in Power BI Desktop.
• Developed human resources reports and dashboard using power Bi Desktop.
• Developed Monthly, Quarterly and yearly New Hire Summary reports and Audit reports for North America and South America region.
• Created Complex reports such as legal case matter, billing hours, payroll, employee details, Performance management and case proceedings along with slicers and dicers enabling end - user to make filters.
• Utilized Power BI gateway to keep HR dashboards and reports up to-date with on premise data sources.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Worked on book marks and toggle button to create sub reports.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Integrated Custom Visuals like Drill Down Donut chart, Drill down clustered column chart, Dial Gauge, Aster Plot 1.4.0, KPI indicators based on business requirements using Power BI desktop.
• Used Custom Slicers like attribute slicer, Chiclet slicers and Time line slicers to filtered out the reports.
• Used to connect different data source SQL DB (SQL Query) to Power BI and generate reports with different visualizations.
• Created bottom count, top count, cross join, non-ascendants DAX queries for creating Calculations and KPI’s on reports.
• Removed Duplicate records from the source using complex query, analytical functions and ad-hoc scripts.
• Created Development workspace in Power BI and published the reports into workspaces and developed the dashboards.
• Validated reports to ensure quality of data and Interacted with business analysts to review reports and Obtain continuous feedback.
• Created a timetable using Dax to show monthly, weekly, yearly reports of the company, marketers, and agents.
• Developed Power BI data visualization utilizing Matrix Reports, cross tabs, maps, pie, bar and density maps.
• Used ETL standards to load into staging tables and then to Dimensions and Facts for North America and South America sales Cubes.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the MS Access data base and SAP and merged data in to SQL Server.
• Responsible for performing T-SQL tuning and optimizing queries for reports which were taking longer time in execution.

SQL Developer/Power BI Developer

Confidential, Columbus Ohio.

• Wrote complex T-SQL queries and stored procedures for the reports.
• Created various Daily and Monthly reports showing detailed and summary information.
• Created reports based on the requirements using SSRS 2016.
• Working on Power BI Reports using SSAS Cubes to build Medicare monthly reports.
• Worked on QNXT backend databases to generate claims, providers and members reports.
• Developed SQL Queries from different tables in databases using Inner/Outer joins, correlated subqueries, accommodating complex filters, created views and temp table to fetch complex data.
• Worked on separating massive SSAS Cubes into individual cubes to aid in shorter cube refresh schedules.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented sales security using roles in SSAS cube for employee access which was defined in an excel file by the business users.
• Deploying SSIS packages using Octopus Deploy and configure SSIS DB projects and environments.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Developed complex Stored Procedures to process prospective PHI information and balanced the processing load between front end and back end.
• Wrote complex T-SQL queries and stored procedures for the reports.
• Created various Daily and Monthly reports showing detailed and summary information.
• Created reports based on the requirements using SSRS 2008 R2.
• Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Exported the ad-hoc ready universes for making semantic layer available to the users.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Coordinated with DBA and Business objects designer group in solving various technical
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.

SQL Developer (SSIS, SSRS),

Confidential, Columbus Ohio.

• Gathered user requirements from various end users and documented the Central Business Required Document (BRD) for the Team.
• Data conversion from Ohio's Attorney General Office's legacy recovery and collections system to FICO's Debt Manager 9.x.
• Develop and maintain stored procedures for deploying sets of table schema, views, user-defined functions, and stored procedures across development, test, and production environments.
• Use TFS for managing code, validation scripts, and defect tracking for advanced accounting programming issues pertaining to debt placement, transaction codes, payments, and financial bucket balances.
• Design and implement SSIS packages and T-SQL scripts for transforming data from staging tables to full cycle layout text files required by FICO ETLs for adding new debts, debtors, creditors, and transactions
• Involved in full life cycle of the project from requirements gathering, analyzing, designing UI/database and transition using Iterative AGILE Methodology.
• Active Involvement in many Client based discussions in gathering, analyzing and creating the Design Specific Document and Lower level Design Document.
• Extensively Implemented Test cases for the development using MS Excel.
• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports using SQL Server Reporting Services (SSRS).
• Wrote complex T-SQL queries and stored procedures for the reports.

SQL Developer (SSIS, SSRS),

Confidential, Desmoines Iowa

• Working in Home Equity department as a service data analyst, to design and develop reports for end users in Foreclosure, Bankruptcy, Loss Process and Specialty areas
• Worked with Home Mortgage Business Intelligence management team, co- workers and Collections management team to identify refine or review data or report needs.
• Performed Requirement Gathering, Analysis and implementation of SSRS reports.
• Developed and maintained tables, queries, stored procedures and views to support business needs and reporting requirements.
• Created SSIS packages to extract data from various source systems like Oracle and DB2.
• Provided support to maintain the existing reports, software issue investigation, defect analysis and provided timely corrective actions.
• Created complex stored procedures using dynamic SQL and CTE.
• Created Ad-hoc reports and provided the result sets in excel sheets for user convenience.
• Generated daily, weekly and monthly based reports to designated managers and clients.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Gathered user requirements from various end users and documented the Central Business Required Document (BRD) for the Team.

SQL Developer (SSIS,SSRS,SSAS)

Confidential, Detroit, MI.

• Created complex Stored Procedures for data retrieval.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc to import data into the data warehouse.
• Involved in requirements gathering, analysis, design, development, and deployment.
• Highly proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS 2008.
• Participate and adhere to quality processes such as design reviews, code reviews and documentation.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XL to SQL reporting.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, trouble shooting process issues and errors.
• Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.

SQL Developer (SSIS,SSRS,SSAS),

Confidential, Miramar, FL.

• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports using SQL Server Reporting Services (SSRS).
• Created SSRS reports using Bar charts, Line charts, Pie charts.
• Created gauges and used gauges as Key Performance Indicators
• Created complex stored procedures and Tabular valued Functions for Reporting services
• Defined the report layout in SSRS.
• Analyzed Reports and Fixed Bugs in stored procedures.
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Created SSIS Packages to import data from FTP Server to Feed Tables.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Created SSIS Packages for Transferring data from Oracle and Teradata to Feed Tables.
• Developed several database structures, complex SQL queries, stored procedures, views,

SQL Developer (SSIS,SSRS,SSAS),

Confidential, Dearborn, MI.

• Created complex Stored Procedures for Quality Checking.
• Created SSIS packages, Stored Procedures, auto schedule the SQL profiling
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc to import data into the data warehouse.
• Development, Stored Procedures, Views, Triggers, Index and SQL Scripts.
• Created SSIS Package to transfer data from various locations using the FTP task.
• Created SSIS and used the task to import and export files.
• Created, modify, schedule, test and or trouble shoot SQL Server Integration Services

Graduate Assistant

Confidential

• Developed a web application using SQL and C# for professor to retrieve required student profiles for professor.
• Worked on shell scripting for automating command input and query.
• Created SSIS Packages to import data daily from OLTP Applications to data warehouse.
• Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services)
• Managed Query Optimization and Performance Tuning of Stored Procedures, Functions etc
• Managed the complete migration of SQL Server 2000 databases to SQL Server 2005/2008
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created SSIS Packages to import data daily from OLTP Applications to data warehouse.

SQL Developer

Confidential

• Implemented the database for production and marketing purpose.
• Designed databases for OLTP applications
• Created tables, indexes and constraints.
• Created Triggers, Stored procedures for implementing the business logic.
• Managed Database files, transaction log and estimated space requirements.
• Configured and monitored database application.
• Designed and implemented several complex reports
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Created stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Managed ongoing activities like importing and exporting, backup and recovery.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.

TECHNICAL SKILLS

Programming: Core JAVA, C# Visual Studio.

Web technologies: HTML, XML

Relational databases: SQL, DB2, Oracle DB, PL/SQL.

Software: Macromedia Flash, VMware tools, Adobe Photoshop/Illustrator, After Effects, Microsoft FrontPage and Office.

Development Environment: Eclipse IDE, Visual Studio Code.

Platforms: All Windows OS, Mac OS 9.

Hardware: Set-up and maintenance of desktop hardware, OS.