Sql/bi Developer Resume
New York City, NY
SUMMARY
- Highly professional and well - versed MS SQL BI Developer wif over all 6+ years’ experience in designing and developingwif strong background in Data warehousing and ETL experience.
- Experience in designing, developing and delivering business intelligence solutions using SQL Server Integration Services (SSIS),Analysis Services (SSAS)and Reporting Services (SSRS).
- MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management domains wif expertise inMSSQL Server2005/2008R 2/2012/2014/2016 and over4+ years ofexperience in Microsoft Business intelligence stack products like SSIS and SSRS and 2+ years of experience in Power BI Service.
- Provided bookmark buttons for customized views and Provided Row Level Security (RLS) wif teh reports to ensure that teh data is secured.
- Highly proficient in teh use ofT-SQLfor developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and SQL joins.
- Strong experience ondevelopingER diagramslikelogical and physical data modelsusing Erwin tool,VisionandPowerBuilder.
- Strong Knowledge onNormalization /De-normalizationdatabase design methodology.
- Highly experienced in whole cycle of DTS/SQL server integration servicesPackages(SSIS) forperforming Data transfers andETL processes across different servers.
- Experience in creatingjobs, Alerts, SQL Mail Agent,Database Mail and scheduleSSIS Packages based on Business or Application needs.
- Integrating and transforming data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSISpackages.
- Highly Proficient in creatingSQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations inSSRS.
- Expertise in generating reports usingSQL Server Reporting Services, Crystal Reports and MSExcel spreadsheets.
- Used2012,2014,2016version ofSSASto develop tabular models and experience in performing tuning oftabular cubes.
- Proficient in designing Enterprise reports usingSQLServer Reporting Services(SSRS)to generate drill down,drill through, parameterized, linked,matrixandchartsreportsin SSRS 2005/2008/2012/2014.
- Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
- Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions inSSAS.
- Experience in Dimensional Modeling, ER Modeling,Star Schema / Snowflake Schemaand Operational Data Store (ODS).
- Managed indexes, statistics andtunedqueriesby usingexecution planfor optimizing teh performance of teh databases.
- Experience in configuring security, organizational content packs, dataGateways, refresh schedules forPowerBIservice.
- Expertise in developing, enhancing and tuning of Oracle database objects and advanced PL/SQLprograms.
- Experience in working inagile scrumdevelopment methodology.
- Excellent interpersonal abilities, communication skills, time management and team skills wif an intention to work hard to attain project deadlines under stressful environments.
- Flexibleandversatileto adapt to new- environment and technologies.
TECHNICAL SKILLS
RDBM/Databases: MSSQL Server 2016/2 R2, Oracle 8i & 9i, MS Access, Microsoft Azure
Programming Languages: T-SQL, PL/SQL, C, MDX, HTML, CSS, Java, Python, C #
Data Modeling: FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques
BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI (Power Pivot, Power View), Power Query, Power Map), SQL Server Analytical Services (SSAS), Visual Studio, Tableau, Power BI.
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), Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS), Tortoise SVN, Redgate, GIT.
Application Packages: MS Office, Microsoft SharePoint Server (MOSS)
Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.
PROFESSIONAL EXPERIENCE
Confidential, New York City, NY
SQL/BI Developer
Responsibilities:
- Excellent noledge & experience in creatingdatabases, tables, stored procedures, DDL/DML Triggers, Views, User defined data types, TEMPeffective functions, cursors and indexes using T-SQL.
- Demonstrable noledgeable experience wifInformatica,Oracle SQL, PL/SQL development.
- Experience working in deployment ofcubes, OLAP & XMLA.
- Developed tools usingpython, shell scripting, XMLto automate tasks.
- Well experienced indata modeling&data migration from Oracle to SQL.
- Experience working inPowerBI.
- UtilizedPowerQuery inPowerBIto Pivot and Un-pivot teh data model for data cleansing and data massaging.
- Implemented several DAX functions for various fact calculations for efficient data visualization inPowerBI.
- UtilizedPowerBIgateway to keep dashboards and reports up to-date wif on premise data sources.
- Has experience in support and maintenance ofBizTalk&AX Microsoft Dynamics wif implementation and involved in working wif self-direct assignmentsusingtableau.
- Involved in projects wifPowerBIenvironment.
- Formatted dashboards, multiple chart types, trends and KPIs wifPowerView to support analyses.
- Create Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions (Range and List partitions).
- Designed and monitored construction of theETL processes and provided theETL mappingsin teh design document.
- Involved in Performance Tuning by creating indexes for better query performance.
- Develop Exception handling process and audit process for each ETL package.
- Developing SQL code such as writing complex queries, stored procedures, user defined function etc.
- Worked wif Stakeholders and business users to gather requirements for mapping document from Source to Destination.
- Monitor and SQL profiler and tuned queries and procedures to boost database performance.
- Creating Packages onSSISby using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task,SCD to load data into Database.
- Involved in creating proxy accounts and Scheduling Jobs to executeSSISpackages.
- Created and managed Interactivity FinancialsPower BIreports (Parameterized, Linked, Drilldown, Drill through reports)
Environment: Informatica,PL/SQL,SQLServer 2016/2014/2012 , SSAS, SSIS,SSRS,Windows Server 2008 R2, Power BI,Visual Studio 2010, C#.Net, Oracle 9i, 11g, Teradata, TFS, Crystal Reports,AngularJS,Microstrategy, MS DynamicsAX, UNIX, LINUX, Azure,Mango DB
Confidential
BI Developer(MSBI)/Power BI
Responsibilities:
- Worked closely wif business and involved in gathering teh user requirements.
- Responsible for writing and modifying stored procedures, functions, packagesfor data conversions to create database objects dynamically.
- Created indexes, tables and sequences as per teh business requirement and views to maintain data privacy.
- Used SQL profiler to identify slow running queries.
- Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud.
- DesignedSSISpackages in order tovalidate, extract, transform and load data into staging and Data Warehouse.
- Analyzed teh requirements and framed teh business logic for teh ETL process.
- Extensively usedSSISImport/Export Wizard, for performing teh ETL operations.
- Performed data migration from Excel, Oracle to MS SQL Server usingSSIS.
- Created package to transfer data between OLTP and OLAP databases.
- Designed Cubes wif star schema usingSSAS. Created hierarchies and partitions for improvingSSAScube performance.
- Designed complex SSAS Multidimensional cubes using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
- Created various complexreports and manage themusingSQLServerReporting Services(SSRS)
- Deployedanduploaded theSSRSreportstoReport Manager and called reports through a URL from .Net API for teh end users and involved in enhancements and modifications.
- Involved in migrating SQL Server databases to SQL Azure database using SQL Azure Migration Wizard
- Created various complexreports and manage themusingSQLServerReporting Services(SSRS)
- Created various kinds of reports usingpowerBIbased on teh client’s needs.
- Used Collections, Bulk Collections for handling large amount of data in PL/SQL.
- Involved in creating visualizations and multiple dashboards inPowerBI.
- Calculated columns, conditional column, custom columns, created measures inPowerBI.
- Responsible for creating SQL datasets forpowerBIand Ad-hoc reports.
- Created Action filters, Parameters and calculated fields for preparing dashboards and worksheets inpowerBI.
- Responsible for scheduled job maintenance and trouble shooting.
- Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve teh customer details, payment history by giving related parameters
- Used AgileDevelopmentMethodology.
- Point of contact for all teh production issues.
Environment: T-SQL, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft Share Point Server, Azure, .NetPower BI
Confidential
SQL Developer
Responsibilities:
- Created business requirements, designed Functional Specifications and Flowcharts.
- Modified existing database to fit new business requirement by adding tables and relationships to support customer information system.
- Written SQL queriesfor back- enddata validation database testing and reports verification.
- Developed SQL Queries to fetchcomplex data from different tables in remote databases usingjoins, databaselinksand formatted teh results into reports and kept logs.
- Working experience writing SQL Scripts using Joins, stored procedures, Views, Indexes, functions, triggers.
- Provided back-end support for functional testing and performance testing.
- Worked on reconciliations of balances from different systems.
- Analyzed requirements wif developers, business analysts and provided my inputs.
- Wrote and executed thetest casesto perform System, Functional and Regression testing.
- Worked onTeam Foundation Server (TFS)for code review to check in and check out teh codes.
- Actively ensuring theproduction implementation of teh new enhancementswif smooth transition of teh project by adding value to teh team in filling teh gap where required as an analyst, programmer and QA tester.
Environment: SQL Server 2008, 2005, SQL Server Management Studio,SSIS,Visual Studio, MS-Office, MS Excel, MS Access.