Sql Server Bi Developer (ssis/ssas/ssrs) Resume
Charlotte, NC
SUMMARY
- Over 8 years of MS SQL Server/MSBI Suite design and development experience in various domains like MS SQL Server 2014/ 2012/2008 R2/2005 and Microsoft’s BI suite of products like SSIS, SSAS and SSRS.
- Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
- Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
- Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, userprofiles, Relational Database models, Data integrity, query writing and SQL joins.
- Extensive experience in Data Massaging, Data Cleansing, and Data Scrubbing using different SSIS Transformations e.g. Fuzzy Lookup, Lookup, Derived Columns, Conditional Splits, and Execute SQL Task.
- Experience in SSIS debugging and Error Handling, Precedence Constraints, Break Points, Check Points and Logging.
- Experience as a power Bi Developer in Data Visualization and modeling.
- Having Experience on Microsoft Power BI (Desktop, Service, Mobile)
- Published reports and dashboards to the Power BI service through the Office 365 integration.
- Shared the dashboards among multiple users in the group.
- Extensive knowledge on SSAS Tabular model and DAX studio.
- Adept at defining referenced relationships and calculated members in SSAS and used MDX/DMX and DAX queries.
- Experience in integrating the SSRS reports into web applications using Report viewer control.
- Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SSRS.
- Expertise in developing Ad-Hoc,Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
- Expert in uploading SQL Server Reports on to the report manager and organize them in folders and worked with delivering the reports using ‘pulled' and ‘pushed’ methodologies.
- Expertise in ERD modeling Normalization and demoralization concepts.
- Good knowledge about data modeling and worked in dimensional modeling of Data warehouse design concept.
- Working experience with Oracle … SQL Server …
- Upgraded Framework Models, Packages and Reports to Cognos10.1.
- Complex Report Building Experience by using Filter, Calculation, Customized Prompts.
- Usage of Query Studio and Report Studio to build advanced reports (multi-page, multi-query report.
- Worked on existing reports in Report Studio and testing Report Performance.
TECHNICAL SKILLS
Databases: MS-SQL Server 2016/2014/2012/2008 R 2/2008/2005/000 , Oracle 11g/10g/9i, DB2, MS Access 2013/2010/2007 , My SQL.
Database Technologies: SQL Server Enterprise Manager,Data Transformation Services (DTS), DTA, SQL Server Activity Monitor, SQL Server Logs, SQL Server Agent - Jobs, Alerts DB Mail and SQL Mail, SQL Server Management Studio, SSIS, SSAS, SSRS, DBCC, BCP, BIDS - SQL Server Data Tools. SQL Query Analyzer, SQL Profiler, PL/SQL, T-SQL, MDX, DAX, Oracle Warehouse Builder, Power BI, Excel, MS Power BI Desktop.
Reporting Tool: SQL Server Reporting Services (SSRS), Tableau. Crystal Reports.
Languages: Java, C, C++, C#, HTML, XML/XSLT, .Net, VB
Other Tools: Erwin, Microsoft Visio 2003/2000 Microsoft Project/Office 2013/2, ER Studio, Perl, MS Dynamics, Share Point, web services.
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
SQL Server BI Developer (SSIS/SSAS/SSRS)
Responsibilities:
- Involved in Planning, Defining and Designing database on business requirement and provided documentation.
- Worked on development to deploy the production issues regarding accounting and operations.
- Created / updated / contributed to the living and breathing Solution Design Document (SDD) for Global Cost Rate application.
- Developed complex T-SQL 2012 code such as Stored Procedures, functions, triggers, Indexes and views for the application.
- Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
- Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
- Worked on Agile Scrum Methodology and attended Sprint planning and estimation meetings
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse, Data Mart Databases and generate XML Files.
- Created 21 different SSIS package of medium to high complexities for ETL by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension tasks in Data Flow Transformations
- Developed Unit Test Plans for SSIS packages for checking the functionality of each component
- Modified the existing SSIS packages to meet the changes specified by the users
- Scheduled Jobs for executing the stored SSIS packages developed to update the database on Daily basis using Control-M Workload Automation Tool
- Designed, Developed and Deployed reports in MS SQL Server 2012 environment using SSRS.
- Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.
- Created reports to retrieve data using Stored Procedures that accept parameters.
- Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
- Responsible for Monitoring and Tuning Report performance.
- Configured the report viewing security for various users at various levels using Report Manager
- Created query prompts, calculations, conditions and Filters.
- Developed SQL scripts in order to test data conversion.
- Developed Dash Board reports ( PDR - Portfolio Details Report ) from cube data source in report studio using MDX functions
- Worked on Team foundation server source control (TFS) to manage code.
Environment: Microsoft SQL Server 2012/2008 R2 Enterprise edition, Teradata R12/R13,T-SQL,SSAS, SSIS, SSRS, BIDS, Microsoft Visual studio, Windows server, Internet Information Server (IIS), MS Excel 2007, PowerPivot, Power BI,Team Foundation server (TFS) 2010
Confidential, Charlotte, NC
SQL Server BI Developer (SSIS/SSAS/SSRS)
Responsibilities:
- Handled SQL- Injection by validating input parameters.
- Improved the performance of .NET based insurance management system with very large SQL Server database by 300%.
- Provided database subject matter expertise and query consultation for the system.
- Skilled at writing and maintaining technical and procedural documentation.
- Creating the modules to convert .NET code into SQL codein a pretty short period and ability of error handling.
- The data migration consisted of transformations, translations and straight mapping.
- Wrote technical specification document for each validation.
- Coded the SSIS package to validate the chosen translation or transformation
- Create an SSIS package for each translation validation and each transformation validation based on the technical document
- Deployed the packages to the SSIS catalog in the appropriate environment
- Executed the packages manually or via scheduling process
- Generated a report on the results of the package execution.
- Logged Pass or Fail status from each package to an Excel document using excels file destination transformation.
- Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined Functions.
- Wrote T-SQL queries for the retrieval of the data.
- Worked with various tasks such as Control Flow (Execute SQL task, for each loop container, Data Flow task, File System, Script Task etc.) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, multicast, conditional split, derived column etc.
- Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined Functions
- Monitored, tuned and analyzed database performance and allocated server resources to achieve optimum database performance.
- Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.
- Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.
- Normalization and De-Normalization of tables.
- Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
- Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.
- Having Experience on Microsoft Power BI (Desktop, Service, Mobile).
- Created and rebuilt multi-dimensional cubes using SSAS to support business reporting and forecasting process.
- Written and reviewed functional specifications, performed unit and system tests, troubleshoot and implement logged bug fixes.
- Designed and Developed Technical specifications for the packages created, for future reference as per the client’s request.
- Used SCRUM agile methodologies, test driven development and automated & slip-stream builds.
- Involved in troubleshooting at database levels, error handling and performance tuning of queries and procedures.
Environment: Microsoft SQL Server 2012/2008 R2 Enterprise edition, Teradata R12/R13,T-SQL,SSAS, SSIS, SSRS, BIDS, Tableau, Microsoft Visual studio, Windows server 2003, Internet Information Server (IIS), MS Excel 2007, PowerPivot, Power BI,Team Foundation server (TFS) 2010
Confidential, New Jersey
SQL Server BI Developer (SSIS/SSAS/SSRS)
Responsibilities:
- Created different SSIS packages and designing data warehouse.
- Created SSIS Packages to import and export data from Excel, Xml and Text files.
- Identified various transformations in SSIS and their use at various situations in the project and prepared documents and packages.
- Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
- Worked with various tasks such as Control Flow (Execute SQL task, for each loop container, Data Flow task, FileSystem etc.) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, multicast, conditional split, derived column etc.
- Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
- Built Multi-Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
- Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
- Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
- Developed Framework Manager Models against Oracle Database.
- Developed List, cross tab, drill through, chart and complex reports which involved Multiple Prompts in Report studio.
- Developing models using Framework Manager Techniques.
- Created Packages and published these packages on to Cognos Connection for creating ad-hoc reports
- Using Query Studio and professional reports using Report Studio.
- Created complex reports like Crosstab, Drill throughs, Master detail, Dashboards and Burst Reports using Report Studio.
- Created reports using Conditional formatting, blocks, variables, styles and Layout features in Report Studio. Created queries in report studio using Join and Union.
- Built Multi-Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed
- Packages to the Report Servers.
- Created reports with custom prompt pages in Report Studio.
- Setting up cardinality (minimum, maximum optional), Determinants to avoid double counting, support loop
- Joins, optimize data source, and identify dimensions and facts.
- Developed Report Views to organize reports in Cognos Connection
- Expertise in handling Administration tasks like bursting and scheduling the reports.
Environment: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Cognos 10/8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio Framework Manager),SQL Server 2014, Windows 7, Ms. Office, ER-Diagrams and Excel.
Confidential, New York, NY
SQL Server BI Developer (SSIS/SSAS/SSRS)
Responsibilities:
- Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
- Implemented Complex business logic with User-Defined-Functions,Indexed Viewsand also created User Defined Data type,Clustered & Non-clustered Indexes.
- Created Business-Crucialstored procedures and functions to support efficient data storage and manipulation.
- Experienced in Extracting, Transforming and Loading data from Excel, Flat file, to MS SQL Server by using SSIS.
- Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send MailTask, Package Execution task to achieve business needs.
- Used some data conversion tasks inSSISto load the data SSISto load the data from flat file to SQL server.
- Extensively used SSIS transformations such as Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
- Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS packages.
- Created packages inSSISwith error handling.
- Worked with different methods of logging in.
- Performed database transfers and queries tune-up, integrity verification,data cleansing, analysis and interpretation.
- Developed, monitored and deployed document for Self-Service Deployment and Execution process for SSIS packages.
- Designed modified and maintained dimensions and measures on SSAS cubes, feeds from EDW and extracts to BO reports.
- Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube.
- Developed fact tables, dimensional tables, cubes for OLAP warehouse using Analysis Services.
- Create and edit alerts on Reports as per User request.
- Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
- UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
- CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
- Highly involved in creating, structuring, formatting using Report Designer andReport Builder.
- Provided critical Production support when needed.
- Worked withMDXto query.
- Maintainingjobsfor data messaging from development server to test server for generating daily reports for financial and marketing team.
- Expert in automating process bycreating jobs and error reportingusing Alerts,SQL Mail Agent, FTP and SMTP.
Environment: SQL Server, Management Studio, Integration Services, Reporting Services, SSRS, OLAP, PL/SQL, Oracle, Data Modeling, Analysis Services, T-SQL, Windows, ETL, SQL Server Agent, Data ware Housing.
Confidential
SQL Developer
Responsibilities:
- Performed extensive data extraction from web and other sources and handled data preparation,
- Missing values, formatting, transformations using SSIS.
- Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business
- Rules for various clients.
- Designed T-SQL scripts to identify long running queries and blocking session.
- Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
- Data migration (import & export - BCP) from Text to SQL Server.
- Error handling using Try-Catch Block.
- Normalization and De-Normalization of tables.
- Developed Backup and Restore scripts for SQL Server.
- Used Joins and Sub-Queries to simplify complex queries involving multiple tables and Established relationships between tables using Primary Key&Foreign Key Constraints.
- Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
- Installed and Configured SQL Server 2012 with latest service packs.
- Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined Functions.
- Wrote 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.
- Prepared daily and weekly status reports and collaborated with other team members.
- Created and managed schema objects such as tables, views, constraints, indexes, procedures,
- Triggers and maintained referential integrity.
- Customized the stored procedures and database triggers to meet the changing business rules.
- Implemented indexes for performance tuning.
- Data loaded into the database using SSIS 2012 from flat files.
Environment: MS SQL Server 2014, 2012/2008R2/2005/2000, Oracle9i/10g, T-SQL, Oracle9i, Visual Basic, Excel, R, SPSS.