Lead Developer (sql/ssis/ssrs), Power Bi Resume
MD
SUMMARY:
- A results driven software professional with 8+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2014/2012/2008R2 /2008/2005, SSIS, SSRS and SSAS.
- Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
- Expert in designing relation database model and implementation as per the Business requirements.
- Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS, Power BI, Tableau and T-SQL Programming using DDL, DML, DCL commands for various business applications.
- Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.
- Expertise in Power BI, Power BI Pro, Power BI Mobile.
- Expert in creating and developing Power BI Dashboards in to rich look.
- Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
- Extensive knowledge in Tuning SQL queries and improving the query performance.
- Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.
- Expert in using Tools like SQL Profiler, Index tuning, Windows performance for monitoring and tuning MS SQL Server Performance.
- Extensive experience in Extract Transform Load (ETL) using SSIS, Import-Export Data BCP Bulk Insert and BCP.
- Developed Drill through and Drill down Reports using SQL Server reporting 2008R2/2012/2014 Services (SSRS2008R2/2012/2014).
- Expensive in generating reports using SSRS 2008R2/2012/2014, Power BI, Tableau and Excel spreadsheet.
- Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
- Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc.
- Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
- Hands on experience in creating Reports using R-language and R-Packages.
- Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS.
- Worked on creating Azure Data Factory for moving and transforming the data.
- Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations
- Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
TECHNICAL SKILLS:
Operating systems: Windows 98/NT/2000/XP/Vista/Windows7/8
Databases: MS SQL Server 2000/2005/2008, MS Access
Database Tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)
ETL Tools: DTS, SQL Server Integration Services, SQL Server Analysis, BizTalk 2009/2006 R
Reporting Tools: SSRS, R studio, Crystal Reports, Power BI, Tableau.
Development Skills: Transact SQL (T-SQL), PL/SQL
Languages: C, C++, HTML, XML, VB.Net, Asp.Net(C#), Python
Application Packages: Microsoft Office Suite
Financial Applications: OneSumX
PROFESSIONAL EXPERIENCE:
Confidential, MD
Lead Developer (SQL/SSIS/SSRS), Power BI
Roles and Responsibilities:
- Designed and documented the entire Architecture of Power bi Poc.
- Expertise in writing complex DAX functions in Power BI and Power Pivot.
- 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.. .
- Installed and configured Enterprise gateway and Personal gateway in Power bi service.
- Created Workspace and content packs for business users to view the developed reports.
- Created Dax Queries to generated computed columns in Power BI.
- Generated computed tables in Power BI by using Dax.
- 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.
- Used Power BI Gateways to keep the dashboards and reports up to date.
- Weekly presentation to the business users about the reports and their changes as required.
- Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
- Worked on all types of transformations that are available in Power bi query editor
- Created stored procedures and SQL queries to pull data into power pivot model.
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
- Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
- Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
- Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
- Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
- Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
- Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
Confidential, NJ
Lead Developer (SQL/SSIS/SSRS), Power BI
Roles and Responsibilities:
- Generated Custom ETL scripts using SSIS 2008/2012 and unit test SSIS load processes for performance check.
- Data processing (Inbound/Outbound) from SQL to Downstream/Upstream using python scripting language.
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
- Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as deposit interest, loan interest, service fees, and transaction fees along with slicers and dicers enabling end-user to make filters.
- Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
- Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
- Involved in creating Dynamic SQL scripts for the Daily Extracts and Transforms.
- Involved in building logics to process the data for Financial Reporting.
- Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
- Managed offshore and onsite Team for completion of team goals and meet the project deadlines.
Confidential, NYC, NY
Sr.BI Developer (SQL/SSIS/SSRS), Power BI
Roles and Responsibilities:
- Created SSRS Reports with the Data sources SQL and Mongo.
- Generated Custom ETL scripts using SSIS 2008 and unit test SSIS load processes for performance check.
- Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation.
- Created a BI connector for Mongo DB for the Reports and SSIS packages.
- Created Linked server between Mongo and SQL using BI connector 2.2.1 version.
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
- Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
- Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
- Developed Complex calculated measures using Data analysis expression language (DAX).
- Developed custom calculated measures using DAX in power BI to satisfy for business needs.
- Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
- Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
- Created report models for the ad-hoc reporting of the end users using Report Builder
- Deployed SSRS reports in share point for web based access for multiple end users
- Documented all the migration process documents for future reference
- Deployed SSIS packages using Visual studio 2016/2017.
- Used Subversion source control to deploy and store the solutions.
Confidential, New York City, NY
Business Intelligence Developer (SQL/ETL/SSIS/SSRS)
Roles and Responsibilities:
- Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
- Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
- Generated Custom ETL scripts using SSIS 2008 and unit test SSIS load processes for performance check.
- Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
- Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
- Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
- Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
- Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Creates solutions and helps prepare test plans by having solid knowledge of data warehousing concepts, dimensional/cube data modeling techniques, including MDX and DAX scripting
- Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
- Created report models for the ad-hoc reporting of the end users using Report Builder
- Deployed SSRS reports in share point for web based access for multiple end users
- Documented all the migration process documents for future reference
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
- Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
- Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
Confidential, Jersey City, NJ
SQL/ETL/SSIS/SSRS Developer
Roles and Responsibilities:
- Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s.
- Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors.
- Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
- Conversion / Migration of SQL Server 2005 to SQL Server 2008
- Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
- Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
- Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration
- Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
- Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
- Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
- Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
- Implemented free text parser for FTP and web data feed in C# .Net
- Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.
- Designed OLAP cubes with star schema and multiple partitions using SSAS.
- Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
- Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
- Involved in migration and conversion of Reports from SSRS .
- Designed some graphical reports using R studio for the Business Users.
- Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
- Created report models for the ad-hoc reporting of the end users using Report Builder
- Deployed SSRS reports in share point for web based access for multiple end users
- Documented all the migration process documents for future reference
- Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
- Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS),R Studio,OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007.
Confidential, Columbus, OH
SQL/ETL/SSIS/SSRS Developer
Roles and Responsibilities:
- Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
- Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task .etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
- Extracted data from XML to SQL server.
- Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
- Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
- Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
- Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
- Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
- Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
- Created several materialized views and UDF’s to be accessed by the new front end applications.
- Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
- Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Successfully tested all task in staging and stored all versions of data using team foundation server (TFS) in Visual Studio.
- Worked in JIRA (Agile) Workflow.
Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Share Point, MOSS 2007, OLTP, OLAP
Confidential
SQL Server DBA/Developer
Roles and Responsibilities:
- Study and understand the requirements of the information required by company’s Procurement Department about the vendors.
- Designed T-SQL scripts to identify long running queries and blocking sessions
- Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
- Data migration (import & export - BCP) from Text to SQL Server
- Developed Backup and Restore scripts for SQL Server 2005
- Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
- Written T-SQL queries for the retrieval of the data.
- Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
- Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
Environment: SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.