Sql/ssis/ssrs/power Bi Developer Resume
CA
SUMMARY:
- Over 8 years of Experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), SQL SERVER Reporting Services (SSRS), SQL SERVER Analytical Services (SSAS) and Data Transformation Services (DTS).
- Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2000/2005/2008/2012/2014/2016.
- Extensive experience with SQL SERVER and T - SQL in constructing tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
- Excellent experience in developing complex Stored procedures, Views and Indexed Views.
- Good experience in creating User Defined Functions and Triggers in observing Business Rules.
- Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
- 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.
- Establish, Maintain & enhance security, using profiles and role hierarchy
- Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts, and Sub reports.
- Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
- Strong experience in creating complex reports that use cascaded parameters.
- Very good experience in writing expressions in SSRS.
- Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System, and User-defined Variables for SSIS Packages.
- Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS). Strong Experience in Creating, Configuring, Deploying, and Testing SSIS Packages.
- Experience in implementing different types of Replication models like Snapshot, Merge and Transactional and Diagnosing and Troubleshooting performance issues in SQL Server Databases using DMV’s and DTA.
- Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.
- Expert in fine tuning the reports.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL SERVER Integration Services (SSIS)i Confidential, Confidential .
TECHNICAL SKILLS:
Data Warehousing & BI: SQL SERVER Business Intelligence Studio (SSIS, SSAS, SSRS, DTS)
Reporting Tools: SSRS 2016/2014/2008 R2/2005, Crystal Reports13/11/08/XI, Excel, POWER BI Desktop
Database: MS SQL SERVER 2016/2012/2014/2008 R2, Oracle 12c/11g/10g/9i, MS-Access.
Programming: C, C++, Visual C++ 2010, ASP.Net, VB6.0, C#.Net, VB.Net, PL/SQL.
Database Design Tools: Erwin 9.6, MS Visio 2010/2013, ER Studio Rational Rose(UML), Kimball & Inmon Methodologies
Tools: & Technologies: Performance Point Server 2007(ProClarity), Enterprise Manager, SSMS, EMC Networker, Database Tuning Advisor, DTS, Analysis Manager, BCP, Visual Studio, QTP, Microsoft Office SharePoint Server 2010.
Version control: Visual SourceSafe 2005, Team Foundation Server
Operating System: Windows Vista/NT/XP/ 2010/2008/2007, Windows 2016/2012/2008 Server, UNIX.
Application Servers: Microsoft IIS 10/8.5/8, Apache.
PROFESSIONAL EXPERIENCE:
Confidential, CA
SQL/SSIS/SSRS/POWER BI Developer
Responsibilities:
- Participated in gathering User Requirements and System Specifications.
- Developed Stored procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
- Created and executed SQL SERVER Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
- Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL SERVER.
- Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
- Designed ETL packages dealing with different data sources (SQL SERVER, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL SERVER Integration Services (SSIS).
- Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
- Conducted optimization and tuning of data queries and stores procedures.
- Migrated existing self-service reports and Ad-hoc reports to POWER BI
- Developed custom calculated measures using DAX in POWER BI to satisfy business needs
- Used Team Foundation Server(TFS) for source control and sprint planning
- Built Ad-Hoc reports in Power BI depending on business requirements was one of the major responsibilities
- Aided with modeling and execution of database enhancements and component development.
- Maintained public websites for clients with database development and support services.
- Implemented processes for debugging of defects, errors and troubleshooting problems relating to database objects.
- Supported technical teams in execution of database objects by testing services at unit, system, and integration levels.
- Designed databases and relevant objects through preparation of tables, groups, and indexes.
- Created Dimensions and cubes with star schema using SQL SERVER Analysis Services (SSAS).
- Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
- Design, deployment, and maintenance of various SSRS Reports in SQL SERVER.
- Designed and implemented Parameterized and cascading parameterized reports using SSRS.
- Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL SERVER and non-production database code as well as T-SQL code from developers and QA.
- Developed Star schema using SSAS cubes.
- Created parallel period, filter, ancestors, and cross join MDX queries.
- Modifying the existing the Dynamic T-SQL Stored Procedures to point to the EDW environment and applying the data model changes.
- Monitored all the packages that were scheduled. Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers, and custom loggings.
- Developed Aggregations, partitions, and calculated members for cube as per business requirements.
- Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
- Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
- Backing up, restoring system & other databases as per requirements, and scheduled those backups.
- Used SQL SERVER Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Environment: MS SQL SERVER 2014/2016, SSIS, SSRS, SSAS, T-SQL, Excel, Windows NT
Confidential, Long Beach, CASQL Developer/SSIS/SSRS/SSAS
Responsibilities:
- Managed the entire ETL process involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources to customers.
- Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
- Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
- Worked on the EDI 834 inbound and 834 outbound data movement with our trading partners.
- Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
- Converted data types using Derived column, Data Conversion Transformation.
- Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
- Assisted in designing and implementation of backup and recovery operations for database applications.
- Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
- Developed project and IT solutions for resolution of operational issues of all databases.
- Supported technical teams in database administration and distributed implementation along with proper documents.
- Resolved problems and issues relating to database server, hardware, and software components.
- Conducted debugging and unit testing services of SQL code, specifications, and test conditions.
- Worked extensively on Windows Azure Administration and provided seamless support in areas such as day-to-day administration, web server administration and media server administration.
- Utilized different built in transformations including SCD, Aggregate, Lookups, and Data Conversion to implement complete ETL strategy
- Built Ad-Hoc reports in Power BI depending on business requirements was one of the major responsibilities
- Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, and views.
- Generated 7M Record files using SSIS Script Task and Script component Format the files based on client requested format using.
- Setup the client packages for Accounts, Transactions and Notes based on Templates.
- Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
- Created SSIS Packages for Incremental Loading and slowly changing dimensions.
- Created logging, custom logging and error handling packages.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports, and Charts.
- Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
- Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
- Created Development and Production support documents.
Environment: SQL SERVER 2014/2016, Enterprise Edition, Visual Studio 2012, DB2, AS400, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Windows 2003 R2.
Confidential, ALSQL Developer/ SSIS/SSRS
Responsibilities/ Roles:
- Involved in the support the specific needs of hedge funds, fund-of-funds and private equity funds and registered investment products.
- Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
- Experience in all EDI transactions like 834, 837 P, 835, 27x and conversion of 4010 to 5010.
- Develop test plans to test EDI transaction sets, ICD code (X12N Insurance EDI 834, 835 and 837) for claims, Web Enrollment System and perform UAT for web-based enrollment application.
- Involved in design, development, and implementation of SSIS, SSRS and SSAS.
- Developed SQL SSIS Packages to extract data from various data sources such as Excel and flat files into SQL SERVER 2005 using different transformations like derived column, sort, and aggregate transformations.
- Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire.
- Involved in Requirement gathering, design, documentation, setup and configure R12 Financials
- Created SSIS packages to get the data from source ( FTP Server ) to staging environment using different transformations on daily basis.
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production)
- Created SSIS packages and daily jobs which sends the customer data from production server to other servers (E-com) on daily basis
- Used SSRS to build various kinds of reports based on requirements. Developed Drill-through, Drill-down, Sub reports, and Cascading reports .
- Designed and implemented Parameterized and Cascading Parameterized reports using SSRS .
- Created ETL metadata reports using SSRS reports include like execution times for the SSIS packages, Failure reports with error description
- Worked on T-SQL statements for retrieval of data and involved in Performance Tuning of T-SQL queries and Stored Procedures .
- Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL SERVER agent job scheduler.
- Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitor the size of the transaction log.
- Tuned the performance of SQL queries and Stored procedures using SQL Profiler. Involved in database and log backups & restoration, backup strategies, scheduling.
- Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
- Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, and views.
- Used SQL profiler to view indexes performance to mostly eliminate table scan.
- Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for users.
- Used multiple join statements to retrieve data from multiple tables.
- Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
- Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
- Created various DTS packages for data transfer and migration.
- Developed Star schema using SSAS cubes.
- Created parallel period, filter, ancestors, and cross join MDX queries.
- Developed Aggregations, partitions, and calculated members for cube as per business requirements.
- Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
- Responsible for testing to optimize the procedures and triggers to be used in production. Involved in project planning also schedule for database module with project managers.
Environment: Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), C#, XML, SunGard iWork’s Proceed 8.6, SSMS, MS Excel, Windows 2000.
Confidential, Woodbury, MNSQL BI Developer/SSIS/SSRS
Responsibilities:
- Installing different hot fixes for deadlocks, blocking and indexes.
- Detection and resolving of blocking and deadlocks using Profiler.
- Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
- Created DTS packages to copy tables, schemas, and views and to extract data from Excel and Oracle using SSIS.
- Monitored all the packages that were scheduled. Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers, and custom loggings.
- Implemented Error Handling during ETL load in SSIS packages to identify dimensions and facts that were not properly populated
- Created several reports using SSRS like parameterized report, drill through reports, linked and sub reports
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Establish, Maintain & enhance security, using profiles and role hierarchy.
- Design, document, build, test, and deploy enhancements to Salesforce instance
- Project management: Planned and outlined project requirements, and resources. Maintained budget and deadlines.
- Managed project deployments and rollouts using agile and waterfall methodologies.
- Extensive experience in designing, creating, and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL SERVER.
- Used Erwin tool to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data.
- Experience in migrating some of the DTS packages in to SSIS.
- Used Recompile and with option query hints to avoid parameter sniffing problems.
- Improved query performance by adding covered indexes, adding file groups.
- Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.
- Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
- Developed reports using SSRS and Crystal reports. Used table control, matrix control for cross tab reports.
- Configured Reporting Services in SQL SERVER.
- Created standard Reports and Cross Tab Reports and Drill Through reports.
- Generated Reports using Global Variables, Expressions, and Functions for the reports.
- Responsible for scheduling the subscription reports with the subscription report wizard.
- Troubleshooting performance issues with Fragmentation using Profiler, System Monitor, and DMV’s.
- Configured nodes and virtual server to set up Active/Active Clustering.
- Import Data from MS-Access Database and XML to SQL SERVER Database.
- Performed daily tasks including backup and restore by using SQL SERVER tools like SQL SERVER Management Studio, SQL SERVER Profiler, SQL SERVER Agent, and Database Engine Tuning Advisor
- Involved in Installation, Configuration of Share Point Form in Cluster Environment.
Environment: SQL SERVER 2012, Enterprise Edition, SQL, Enterprise manager, SSRS, SSIS, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform, C#, VB.NET, ASP.NET.
ConfidentialSQL BI Developer/SSIS/SSRS
Responsibilities:
- Installing different hot fixes for deadlocks, blocking and indexes.
- Detection and resolving of blocking and deadlocks using Profiler.
- Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
- Created DTS packages to copy tables, schemas, and views and to extract data from Excel and Oracle using SSIS.
- Experience in mapping multiple related systems.
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Designed the system architecture that is used to structure, plan, and control the process of developing an information system
- Transformed data from various data sources using OLE DB connection by creating various DTS packages.
- Extensive experience in designing, creating, and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL SERVER.
- Experience in migrating some of the DTS packages in to SSIS.
- Used Recompile and with option query hints to avoid parameter sniffing problems.
- Improved query performance by adding covered indexes, adding file groups.
- Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers& maintaining Referential Integrity.
- Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
- Developed reports using SSRS and Crystal reports. Used table control, matrix control for cross tab reports.
- Configured Reporting Services in SQL SERVER.
- Created standard Reports and Cross Tab Reports and Drill Through reports.
- Generated Reports using Global Variables, Expressions, and Functions for the reports.
- Responsible for scheduling the subscription reports with the subscription report wizard.
- Troubleshooting performance issues with Fragmentation using Profiler, System Monitor, and DMV’s.
- Configured nodes and virtual server to set up Active/Active Clustering.
- Import Data from MS-Access Database and XML to SQL SERVER Database.
- Performed daily tasks including backup and restore by using SQL SERVER tools like SQL SERVER Management Studio, SQL SERVER Profiler, SQL SERVER Agent, and Database Engine Tuning Advisor
- Involved in Installation, Configuration of Share Point Form in Cluster Environment
Environment: SQL SERVER 2012 Enterprise Edition, Reporting Services, SQL Enterprise Manager, Informatica 7.1, Windows XP, Oracle, MS Access, MS Excel, Windows 2003, HTML, Visual Source safe, Toad.
ConfidentialSQL SERVER Developer
Roles & Responsibilities:
- Involved in analysis and design of the system specification and gathering requirements and prepared the document for proposed system.
- Involved in the Design of Interactive User Interface and Coding of the application.
- Involved in Designing and creating of Database Tables and Views.
- Participated in creating Stored procedures in Oracle database.
- Created triggers on DML actions for security purpose
- Worked with Scalar and Table Value User Defined Function as per business requirement
- Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables
- Interacted with financial analysts to gather requirements, test plans and DBA's for database schemas.
- Wrote Database triggers for audit and to implement complex business logic.
- Involved in the database design for better understanding the relations, associations, and dependencies within the data base.
- Involved in writing functional and technical documents.
- Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences, and Synonyms .
- Created indexes to improve the performance of database.
- Involved in database Backup and Restore.
- Generated various kinds of Reports using Crystal Reports.
- Created ActiveX components which are being used throughout the application.
- Involved in integrating individual tools and executing them from Visual Basic.
- Involved in Manual Testing and implementation of software at client location.
Environment: .NET Framework, VB and C#, ASP.NET, ADO.NET, Web Services, T-SQL, SQL SERVER 2008, COM/COM+, UML, Visual Studio.NET, Windows 2000 Advance Server.