SUMMARY:

• Over 8+ Years’ experience in Database Design, Development, Architecture and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.IT Experience in Microsoft Business Intelligence Stack SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and adept Knowledge in Data Warehousing.
• Experience in Database Solutions and BI Solutions using Microsoft Technologies.
• Extensive experience in Design, Development, Implementation of Database systems using MSSQL for OLTP systems and Microsoft BI for OLAP systems.
• Experience in database programming in writing T - SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Experience on JAVA/J2EE code, business logic using Spring and OOP concepts, involved in Peer code reviews
• Very good knowledge in designing database objects like Tables, Views, Constraints, Indexes and defaults.
• Experience in designing Database Models using MS Visio and Smart Draw for both Relational and dimensional modeling.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Data refreshes, Security and User management, Performance Tuning.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating custom visualizations and developing Power BI Dashboards in to rich look.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• 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.
• Developed SSIS Packages to populate Data Mart from several types of sources files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
• Worked on Map R Hadoop platform to implement BigData solutions using Hive, Map Reduce, shell scripting, and java technologies
• Created several Staging Databases. Hands on Experience in RDBMS using BTEQ, FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT and SQL utilities
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance
• Expertise in writing complex DAX functions in Power BI and Power Pivot
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in installing, configuring, maintaining and admin various version control system like Subversion (SVN), CVS, GIT, TFS, Clear case on UNIX and windows environment
• Experience in Creating number of cubes, dimensions and critical KPIs using SQL Server Analysis Services representing aggregations in several separate ways - hierarchically and using custom groupings.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012), use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.
• Worked on angular.js forms and controls to validate Input data.
• Expertise in software Configuration.
• Developed, Deployed & Scheduled crystal Reports in Crystal Enterprise
• Developed Reports in SQL Server using SSRS.
• Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Experience in developing Custom Report and several types of Tabular Reports, Matrix Reports, charts, ad- hoc reports and distributed reports in multiple formats using Report Designer and Report Builder in SQL Server Reporting Services (SSRS).
• Experience in migrating on premise to Windows Azure using Azure Site Recovery and Azure backups
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements
• Defined frameworks for Operational data system (ODS), Brokerage data warehouse (BDW), Central file distribution (CFD) and Data Quality (DQ) and created functional data requirement (FDR) and Master Test Strategy documents also EDI.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2008/2012 across various environments.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Set up POCs for dual load, dual ETL, Data mover and perform bench mark testing for each.
• Ability to export reports and query results to MS Excel, PDF, HTML, etc.
• Agile data, ERWIN and Toad data modeling, SA Enterprise Architect Process modeling, Big data design reviews, Oracle tuning and data quality work.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Used all JDE design aids to develop and modify interactive applications, batch programs, and event rule business function
• Automated multiple processes and Batch flows using Autosys and shell scripting
• Compiled Audit reports on UNIX/Linux servers for internal/external audits
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Designed and developed high-efficient Entitlement Replica Sybase databases
• Published reports and dashboards in Power BI utilizing Power BI services and shared it across through Microsoft Office 365.
• Developed custom forms and reports in multiple modules of Dynamics AX
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Extensive experience in using SQL Server Profiler and SQL Server Extended Events to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Develop tasks in ETL/Informatica, DAC & PL/SQL
• Performance tuning of mappings, transformations and sessions to optimize session performance.

TECHNICAL SKILLS:

Operating Systems:: Windows XP/2007/2010/Vista

RDBM/Databases:: MS SQL Server 2008/2012/2014/2016, MS Access 2010, MySQL.

Programming Languages:: T-SQL, Dynamic SQL, DOS Scripting

Data Modeling:: MS Visio, FACT& Dimensions tables, Physical & Logical data modeling, ERWIN, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access.

Data Design Tools: MS Visio, Smart Draw.

BI Tools:: SQL Server Reporting Services (2008/2012), SQL Server Integration Services (SSIS 2008/2012), SQL Server Analytical Services (SSAS 2008), BIDS.

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), Visual Studio Team Foundation Server (TFS)

Application Packages:: MS Office, Microsoft SharePoint Server

PROFESSIONAL EXPERIENCE:

Confidential, HOUSTON, TX

Sr. SQL SERVER/POWER BI DEVELOPER

Responsibilities:

• Gathered the requirements by discussing with the Users and Team members
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Wrote stored procedure and used JAVA APIs to call these procedures.
• Responsible in understanding the complex business requirements and functional specifications of the client module.
• Responsible for functional analysis of specifications, tracking tickets from customers and resolving problems.
• Responsible to identify customer business flow and gap analysis, provide recommendations in key strategic areas involving competitor performance and responsible to identify the process gaps and provide alternatives to the project team.
• Responsibilities include generating proxies and buddy testing and peer code review. customizes various applications/reports and implementation of selected business model. Makes additional setups to implement new business processes, develop integration test scripts to repair business flow. Responsible to participate in client meetings to discuss the requirements and clarifications in all regards. Application Design:
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Responsible to design and develop standpoint for the development team.
• Responsible for interface development and complete design, build, test and deploy phase.
• Modified SSIS packages and made all the variables to dynamic from static to pass the values dynamically and Scheduled SSIS packages to create SQL jobs.
• Good in technical assistance from design and development standpoint. Designs, tracks and coordinates project activities to meet project deliverable
• Prepares design documents, design patterns, prepare component design specification/feature design specification and time estimation Application and database Coding.
• Used SSIS variables to capture start time, end time and failure of a package and execute the package dynamically
• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Involved on migrating SQL Server databases to SQL Azure Database using SQL Azure Migration Wizard. Deployed application to Azure Cloud
• Designed and developed SQL Server Analysis Tabular models on Windows Azure platform
• Created Reports using POWER BI with large amounts of data: facts, figures, and number processing
• Responsible for gathering information from end users and making necessary enhancements to the existing applications - .Net (C#.Net, VB.Net, SQL Server) as per requirements. Have Worked on Microsoft PMP and SSRS Microsoft Visio.
• Responsible for monitoring modification of workflows using SharePoint Designer 2013.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Responsible to do the database changes using SQL Server which includes creation tables, views, stored procedures, user defined functions, jobs, triggers etc also integrates of various data sources like SQL Server, Oracle, flat files, excel components using SSIS.
• Used SQL programming extensively to talk to Oracle database.
• Performed Query optimization & Performance Tuning of SQL queries for maximum efficiency using SQL Profiler and Database engine tuning advisor
• Deployed the packages on staging and production. Monitored jobs and supported Azure Data Lake production environment
• Guided off shore team on DAX, Power BI desktop, Power BI service and Dimensional modeling
• Provided visual/graphic analysis based on data content.
• Involved in Security distribution project which loads securities from upstream process and send notifications to downstream process using Markit EDM objects.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence, visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Tested Power BI reports Of the Database and Verified it with the Source data
• Actively participated to resolve the production and maintenance tickets (Tickets for ETL tasks).
• Front-end web development & branding of Share point sites.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Responsible to prepare the templates for the functional specification review, technical specification, unit test cases, and string test case. Responsible to perform unit testing, system testing, regression testing.
• Created parameters (multi-value, hidden, default etc...) for the required fields using the report designer to see the dropdowns in the end report.
• Tests any cumulative updates. plans the test activities and preparation of test scenarios as per customer requirements. His responsibility also includes the documenting the test case scenario steps followed for various tasks for specific module.
• Completely responsible for UAT, Prod deployment for all CRs and incidents from end to end process.
• Developed various Charts and Graphs like Bar chart (Side by Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of Crystal Reports
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps
• Experienced in writing complex formulas in Crystal Reports SQL queries using crystal Designer, migration of crystal reports in different versions.
• Responsible to maintain the release documents and SMTDs and maintains the enhancement documents for all applications and reviews the same based on the modifications and the scope defined.

Environment: SQL Server 2012/2016, T-SQL, BIDS (Business Intelligence Development Studio), SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Visio, DAC, Share point Products, MS Excel Query Analyzer, Power BI.

Confidential, ST LOUIS, MO

Sr. SQL SERVER/POWER BI DEVELOPER

Responsibilities:

• Responsible for Conceptual, logical and physical design for in-house application development.
• Have Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Created the derived columns from existing columns using Derived Column transformation for the given requirements. Involved in complete SSIS life cycle in creating and re-designing the SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Migrated on premise SQL Server databased to Azure SQL database.
• Built Dashboards that used Windows Azure SQL database
• Managed the ETL processes between various environments through SSIS Configuration
• Used multiple complex transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Excel, Flat file, SharePoint Data to SQL Server databases using SSIS.
• Modified inline SQL queries in SSIS packages and made all the variables to dynamic from static to pass the values dynamically and Scheduled SSIS packages to create SQL jobs.
• Normalized the source data for loading the Data into Dimension and Fact Tables using ETL controls in SSIS.
• Used SSIS variables to capture start time, end time and failure of a package and execute the package dynamically
• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Created Executive dashboards to reflect various retail KPIs based on Region, Countries, allowing management to drill down to individual retail store level.
• Used SQL Server Destination in Data flow to improve an exceptional performance changes in Replications.
• Installed and configured Enterprise gateway and Personal gateway in POWER BI service.
• Created Workspace and content packs for we users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in POWER BI service.
• Wrote calculated columns, Measures query's in POWER BI desktop to show good data analysis techniques. Created Reports using POWER BI.
• Automated POWER Query refresh using POWER shell script and windows task scheduler.
• Used various sources to pull data into POWER BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Applied Angular UI Router to create Single Page Application using multiple views and layout template
• Worked with several types of dataflow transformations like Derived Column, Data Conversion, Lookup and Conditional Split etc.
• Created detailed documentation for HRIS processes to educate the field HR staff to achieve standardization and accuracy.
• Created packages in SSIS with Error Handling as well as created complex SSIS packages using various data transformations like Conditional Split, For Each Loop, Multi Cast, Fuzzy Grouping, Script Components.
• Implemented Event Handlers and Error Handling in SSIS packages
• Performed Query optimization & Performance Tuning of SQL queries for maximum efficiency using SQL Profiler and Database engine tuning advisor
• Guided off shore team on DAX, Power BI desktop, Power BI service and Dimensional modeling
• Actively participated to resolve the production and maintenance tickets (Tickets for ETL tasks).
• Coordinated development progress by maintaining close, constant communication and Release management.
• Designed Cubes and hierarchies in SSAS
• Worked on OLAP Storage modes in dimension tables like ROLAP/ MOLAP.
• Expertise in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL
• Administering Control-M environment and servers perform daily admin tasks and Fail-Over for Control-M server procedure.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data with pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly
• User interface design, front-end web development & branding of Share point sites.
• Worked on web application portals.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created parameters (multi-value, hidden, default etc...) for the required fields using the report designer to see the dropdowns in the end report.
• Strong experience in Manual Testing, writing Test Case, Requirements, logging & tracking Defects, producing graphs & reports from HP Quality Center /ALM
• Responsible for management status reports, cost and gap analysis, budgeting, SOW reviews and project tracking sheets.
• Developed various Charts and Graphs like Bar chart (Side by Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of Crystal Reports
• Experienced in writing complex formulas in Crystal Reports SQL queries using crystal Designer, migration of crystal reports in different versions.
• Used several types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Created Pivot Tables and Pivot Charts in MS Excel.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• End to end support for upcoming major changes in the business logic in Sybase development
• Prepare Technical specifications for customizations required during a Dynamics AX implementation
• Migrating Dynamics AX 2009 to Dynamics AX 2012 R3 application.
• Configured SQL mail agent for sending automatic e-mails to employees for Invoice using SSIS packages.
• Defined Key Performance Indicator metrics to create scorecards.
• Stabilizing the DB2 environments and streamlined the systems
• Key Developer in analyzing the technical feasibility of the functionality which was required to be developed using asp. net and C#.

Environment: SQL Server 2012/2016, T-SQL, BIDS (Business Intelligence Development Studio), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS, DTS (Data Transformation Services), Visio, DAC, Share point Products, MS Excel Query Analyzer, Profiler, Power BI.

Confidential, HOUSTON, TX

SR.SQL SERVER/POWER BI DEVELOPER

Responsibilities:

• Developed ETL Packages using SQL Server 2012 Integration Services to populate data from various sources, for example flat files/SQL/Oracle Server to the Staging Database and then into the Data Warehouse. 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
• Involved in designing in SSRS reports based OLAP and OLTP systems
• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program. Wrote complex SQL queries to populate data from different tables and which can be used for reports. Gathered requirements from business analyst.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Optimized SQL queries for efficiency and the front-end developer with their queries and procedures.
• Created Tables, Indexes and Constraints.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Configured and monitored database application.
• Used ages in T-SQL. VB.Net Script for Data Flow and Error Handling using Script component in SSIS
• Designed and implemented several complex reports and administration modules.
• Defined stored procedures for module integrity and application.
• Configuring Power BI Gateway for SSAS Live connection and Direct Query
• Created SSRS Reports from scratch and worked on creating Reports in VB.Net from scratch.
• Coordinated with .Net developers to show the output of SSRS reports in WinForms.
• Fixed issues with in crystal reports and updated them according to user requirement.
• Performed backup/restore, and managed user security. Created database objects such as tables, procedures, triggers, constraints, indexes, and views.
• Implemented the indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Analyzing control-M configuration and Modification of the existing database objects functionality based on the requirements
• Extensive knowledge with Dimensional Data Modeling, Star schema/snowflakes schema, Fact and Dimension tables.
• Interact with business analysts to develop Modeling techniques
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Converted and migrated IBES, World scope and Fundamental databases from Sybase to Oracle.
• Created/reallocated database objects on appropriate file group to ease maintenance and improve data access performance.
• Wrote Procedures/Stored Procedures/Functions/Triggers in T-SQL for various applications which sits on top of the database.
• Monitoring DAC. Defect fixing on reports.
• Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.
• Performed monitoring and analysis on OBIEE report usage.
• Used SQL Server Profiler to trace the slow running queries and the server activity and with SQL performance tuning too.
• Analyzed and debugged jobs and procedures
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2012.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Responsible for identifying, designing and implementing processes related to predictive / analytical modeling, data mining and complex data sets using statistical and text mining using python scripts.
• Created new Crystal reports and Modified existing Crystal reports to meet user requirement.
• Migrated existing crystal reports to SSRS 2008. Migrated existing DESKI Reports to crystal 2008.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
• Developed Stepped and Block reports using SSRS. Designed and implemented Parameterized and cascading parameterized reports using SSRS
• Provided maintenance and development of bug fixes for the existing and new Power BI Reports.
• Created designs and process flow on how to standardize Power BI Dashboards to meet the requirements of the business.
• Involved in the Unit testing, Quality Assurance testing and User Approval testing of Power BI reports and modifying the code accordingly to match user’s business requirements.
• Used several types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush, Waterfall, Gauges etc.) in Power BI according to the requirements.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Performed Backup operations. Built and published customized interactive dashboards utilizing Excel Power BI.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios. Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Expertise in Customization and Implementation of AX 2012 modules.
• Imported data from Excel to Dynamics AX.
• Built the processing procedures, strategy and approval process for project management and verification necessary to comply with the requirements as requested by clients
• Strong experience with test and defect management tools HP QC /ALM, Jira & Test Complete.

Environment: MS SQL Server 2012, T-SQL, MS Access, MS Excel, Windows XP, SQL, T-SQL, SQL Query Analyzer, Profiler, Data modeling, SSIS, SSAS, MS SQL reporting services, Power BI, HTML, ETL, DTS packages, DAC

Confidential, PLANO, TX

SR.SQL SERVER/POWER BI DEVELOPER.

Responsibilities:

• Involved in designing in SSRS reports based OLAP and OLTP systems.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Used various data flow transformation in packages based on the business need such as Data conversion, condition split, multicast, union all merge, merge join, sort, etc.
• Migrated packages from development server to production server using package configuration.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill through, Sub reports using SSRS.
• Led automation project using VBA/SQL and developed valuation models using expertise in structured OTC derivative Products.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report server to access it through browser.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Created and Maintained various database in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports and making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Created and Maintained various database in MS Access to track activities and progress.
• Worked on several complex drilldowns, parameterized reports and on reports that call sub reports using SSRS.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T- SQL statements using SQL profiler.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.
• Designed and documented the entire Architecture of Power bi.
• Worked on all types of transformations that are available in Power bi query editor.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created package configuration using environment variables.
• Creation and Edit the existing BI Reports.
• Good knowledge of relational database management systems and Data Modeling
• Modified existing stored procedures. Writing complex T- SQL queries.
• Proficiency in SQL including Joins, Alters, Sub queries, Pivots, Loops, Cases, and data transformation functions.
• Strong Performance tuning skills of SSIS packages and SQL queries
• Analysis of root cause for data issues.
• Played a senior role in realizing reports and analytics strategy.
• Responsible for understanding BOFA Banking and knowledge on BFSI (Mortgage, Auto Loans, Deposits etc) and to support automation test scripts.
• Developed and created charts using Power BI like Pie, Column, Bar, Line graph as per Business requirement.
• Synthesize complex data into user friendly visual presentations.
• Performed complex SQL queries, triggers and stored procedures, views and user defined function and update database statistics.
• Configured and create SSIS solutions for ETL and business intelligence process for data integration and migration services
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Involved in Report Design and Coding for Standard type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Created SSIS package to load data from Flat File, CSV File, Data warehouse and Report-Data mart and applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column and Merge Joins in SSIS.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Fuzzy lookup, Data Conversion, Conditional-Split and merge join.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Established effective mechanisms of communication with staff, providers, and the organization's management team to foster an environment of openness, trust and team work
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column
• Ran SSIS package every day by scheduling job in SQL server.
• Extracted, Integrated data from Sybase, Oracle, and DB2 database to SQL Server.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages
• Extensive experience in designing, creating and deploying SSIS packages for transferring data.
• Converted existing DTS packages to SSIS Packages.
• Created SSIS package to load data from XML Files, Excel, CSV file, Ftp Server and SQL Server to SQL Server 2012 by using Derived Columns, Condition Split, Data Conversion, OLE DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data
• Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).
• Excellent report creation skills using Microsoft SQL Server 2005/2008/2012 using Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Environment: SQL Server 2008/2012, T-SQL, BIDS (Business Intelligence Development Studio), SSIS (SQL Server Integration Services), SSAS, SSRS (SQL Server Reporting Services), Power BI, DTS (Data Transformation Services), Visio, Share point Products, MS Excel.

Confidential, WARREN, NJ

SQL BI DEVELOPER

Responsibilities:

• Created and maintain databases after logical and physical database design.
• Maintained the accuracy of the billing System Database and Security Administration for all Billing system's users and Assists with data entry of codes, discount codes, or any parameter changes to the ICOMS Billing System.
• Accurately enter data into Billing System.
• Effectively communicate product and service information billing procedures and equipment usage to each customer
• Used file layouts, functionality, as well as its integration capabilities and protocols with SQL query
• Created database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Set database access privileges for different users and user groups.
• Performed optimization of SQL queries in SQL Server and Sybase system.
• Maintained of clustered and non-clustered indexes.
• Generation of dashboards with calculated fields, Filters, Groups, Parameters and Sets to handle views more efficiently in Tableau
• Created jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Coded Stored Procedures, functions and triggers at expert level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Trouble shoots same SSIS packages by logging method before forwarding to quality analysis (QA) testing.
• Implemented major Event Handlers like On Error, On Progress and On Task Failed for SSIS Packages.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Worked with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Created financial reports on all aspects of the overall revenue cycle operations.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Worked on re-design of the few SSIS Package which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.
• Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from various sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
• Created and mapped the Various Results, Sets and Variables wherever they are needed in SSIS.
• Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
• Worked on the row count transformation or row count expression and Record Set Destination and event handlers control flow to populate the special Log tables with high level SSIS package execution
• Scheduled and Monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Involved in Creating and Testing the SSIS packages developed for security.
• Created Dashboards to present critical company data in a single report.
• Worked with various SSIS tasks including execute SQL task, for each loop container, file system tasks.
• Created DTS Packages.
• Worked with DBA's on Insert Scripts and DDL's
• Performed database consistency checks at regular intervals.
• Monitored SQL Server activity through profiler.
• Developed backup & restore scripts for SQL Server as needed.
• Designed and implementation of database maintenance plan
• Performed optimization and normalization of database
• Job, Scheduling, batch, alert and E-mail notification setting.
• Maintained Disaster recovery strategies for the database and fail-over methods.
• Monitored SQL Server log files.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Developed SSRS report to analyze migrated data (Sales Force) for core objects and child objects.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment: SQL Server 2008, TSQL, Stored Procedures, Triggers, Views, Crystal Reports, SSIS, SSRS, SSAS.

Confidential

SQL DEVELOPER.

Responsibilities:

• Executed complicated analyses and make the results accessible and relevant to a wide variety of business users.
• Designed, implemented and administrated SQL Server 2008 databases.
• Developed various reports to validate the data between source and the target systems.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute Task. Actively SQL involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Created and Modify Stored Procedures, Triggers, Views according to the business.
• Implemented Constraints (Primary Key, Foreign Key, Default, Unique, Check and Not Null/Null) and fine tune Indexes on Tables.
• Performed database consistency checks at regular intervals.
• Involved in database design process and data modeling process using diagrams and Visio.

Environment: SQL Server 2008, SQL Profiler, Data Transformation Services, SSIS and T-SQL.