Sql/bi Developer Resume
Lansing, MI
SUMMARY:
- Over 8 years of IT experience, which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server, Oracle) in production environments and providing ETL/Business Intelligence solutions using Microsoft components to various clients (SSIS, SSRS).
- Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
- Experience in working with UAT teams and Prepared user documentation with screenshots for UAT (User Acceptance testing).
- Conducted meeting with Business analysts and experts to discuss business requirements.
- Experience in preparing test strategy and test plans for system testing and UAT.
- Prepared testcases for functional testing, system testing and UAT testing.
- Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
- Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
- Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
- Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
- Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
- Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
- GeneratedComplex reports in Cognos 10.1 report studio including Drill Down reportsfromDMR modeled Frame work model.
- Experience in creating Ad - hoc reports, data driven subscription reports by using Report Builder in SSRS.
- Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
- 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.
- Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
- Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
- Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports.
- With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions.
TECHNICAL SKILLS:
Databases: MS SQL Server 2014/2012/2008/2005 , Oracle 11g/10g, DB2, Teradata, MS-Access, Amazon Redshift., Vertica.
SQL Server Tools: Business Intelligence Development Studio, Enterprise Manager, Query Analyzer,Azure, Export & Import (DTS), SQL Profiler, Database Engine Tuning Advisor, DBCC, Monitor Resource Usage.
Operating System: Windows NT, Windows 2000, Windows 2003, Sp3, Windows Server 2008,Windows Server 2010, Windows 7, Mac, Linux and Unix Os
Other Tools: Microsoft Azure, COSMOS, ERWIN, ER Studio, Microsoft Visual Source Safe, Microsoft Office, Microsoft Visio, MS Visual Studio 2003/2005/2008/2010/2012/2013 , VisualStudio Team services(VSTS) Microsoft BIDS, Crystal Reports, Team Foundation Server, HP Quality Center, shell scripting,System testing, functional testing, UAT, Bugzilla, Zephyr, Source Version Control (SVN), SOAP, TOAD for ORACLE SQL, JIRA, Rally, Confluence, Service Now, Trizetto FACETS, TIDAL(Cisco s Enterprise Job Scheduler), NET FrameWork 5.0, 6.0
PROFESSIONAL EXPERIENCE:
SQL/BI Developer
Confidential, Lansing, MI
Responsibilities:
- Designing Data Warehouse with user interface to provide facility for end users to load data into system without having technical knowledge using SQL Server 2012, SSIS, C# and .Net APIs.
- Created Power BI visualization of Dashboards & Scorecards (KPI).
- Designed and implemented multiple dashboards using Power BI - PowerPivot & PowerQuery tools.
- Working closely with Actuarial department on loading and analysis of Claims data on daily basis.
- Designing claims reconciliation, validation and analysis reports for accounting and actuarial departments.
- Involved in writing test plan, test strategy and testcases for UAT.
- Designing complex ETL processes to support feeds from different sources like flat files, excel, csv, OLEDB etc. using SSIS.
- Developing complex SSIS packages using different data transformations like Aggregate Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Changing Dimensions, Scripting with C#, OLEDB Command with SQL etc.
- Developing SSIS packages that uploads multiple flat files using For each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
- Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.
- Designing internal and external surveys using .net technology and providing automated report for analysis of the survey results built in SSRS. Reports provides the functionalities like drill down, dash board, drill through, grouping, aggregation etc.
- Managing small DBA related tasks like database backups, restores, log shipping, setting up database access etc.
- Managing and supporting Mobile App related customer inquires and providing solution to customer service reps or directly to customers.
- Managing and enhancing internal and external website for the company with Umbraco and .net technology.
- PerformedSQLand Cosmos/Scopebig data development to extract and transformmassive datafor analysis.
- Working with Marketing department to improve external and internal website and posting latest updates.
- Designed new contract log management system for the legal and accounting department to help track of all the existing and new contracts. Also system manages preapproval process with different stages of approvals.
- Managing company’s video conference system and arranging video and go to meeting setups for HR department.
- Helping finance and accounting department with crystal report’s enhancement and resolving issue with reports.
- Working with other departments to support different needs and help them resolve day to day issues with software and reports.
- Working on Sales force to help users with account setup, designing email templates, sales force reports, Eblasts etc.
Environment: SQL Server 2012, SSRS 2012, SSIS 2012, 2008 Oracle (PL SQL) .Net Framework 4.5, C#.Net, XML, Entity Framework, Umbraco, Sales force, Power BI.
SQL /BI Developer
Confidential, Eden Prairie, MN
Responsibilities:
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
- Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
- Extensively worked in developing SSIS packages using Derived Column, Conditional split, Script Task, Merge, FTP task and Multicast.
- Reverse engineered the existing Informatica application, to replace the source system to a new system using SSIS and stored procedures.
- Involved in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
- Created Linked reports and Ad-hoc reports based on the requirement. Linked reports were created in the Report Server to reduce the repetition the reports.
- Created multiple ETL packages to extract, validate, transform, load data and generate files for various project specific functionalities.
- Hands on experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports.
- Designed and implemented modular and reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Exception Handling, Surrogate Key Generation & Assignment, Data Lineage Tracking, and ETL Auditing.
- Maintained databases with Data Base Consistency Checks (DBCC) such as Rebuilding Indexes and Integrity Checks.
- Wrote complex stored procedures for the Application Development using T-SQL.
- Worked on Common Table Expression which uses rank function to calculate the ranking of clients based on the policies they insured.
- Having hands on experience in DR Processes including Log shipping and Database Mirroring.
- Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
- Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
- Using Informatica Designer, developed mappings, which populated the data into the target.
- Implementing all high availability techniques like clustering, log shipping, replication.
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
- Created Dashboards using SSRS.
- Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
- Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
- Created list reports & cross tab reports using Cognos 10.1
- Experienced in Cognos 10, 8, ReportNet with Report Studio, Framework Manager, Query Studio.
Environment: Windows2003 Advanced Server, ASP.Net, Oracle (PL SQL) MS SQL Server 2005/20, TSQL, Pl/SQL, QNXT, Cognos, Visual Studio 2008, Oracle 11g, Pentaho BI.4.8, Pentaho kettle, SharePoint 2007/2010, Tableau, QlikView, Power BI, SSRS, SSIS, Jasper Reports 6.1.0 API, Informatica, Erwin, Windows OS management.
SQL/BI Developer
Confidential, Houston, TX
Responsibilities:
- Created databases, tables, stored procedures, DDL/DML triggers, views, functions and cursors using T-SQL.
- Performed Debugging on the Stored procedures for the requirement to handle the errors.
- Development of custom scripts and stored procedures for data import and manipulation.
- Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
- Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
- Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
- Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
- Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
- Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
- Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2008 and MS SSRS.
- Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
- Created report snapshots to improve the performance of SSRS.
- Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
- Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2008 Analysis Services (SSAS).
- Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
- Migrated and resolved conversion errors for Performance Point Server reports to
- 2010 Business Intelligence platform.
- Developed complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
- Created sub reports, bar charts and matrix reports.
- Verified business requirements and functional specifications.
Environment: Windows 2007, SOAP, Advanced SQL Server, ODBC, MS SQL Server 2005/2008/2012 , TSQL, Microsoft Visual Studio 2008, Shell Scripting, VSTS, Oracle, PL SQL, SSRS, SSIS, Erwin.
SQL/BI Developer
Confidential
Responsibilities:
- Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
- Created SSIS Packages to integrate data coming from Text files and Excel files.
- Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
- Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
- Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
- Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
- Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
- Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
- Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
- Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
- Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
- Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
- Created User Defined functions for sharing formulas across multiple reports.
- Modified existing reports according to requirements of the end users.
Environment: MS SQL Server 2008, SQL Integration Server 2008, SQL server Reporting Services 2008, SSAS, Microsoft Visual Studio, VSTS, SQL Server Management Studio, MS Excel, T-SQL, Windows XP, SOAP, Erwin.
SQL DEVELOPER
Confidential
Responsibilities:
- Work closely with Business analyst to analyze and understand the requirements.
- Creating flowcharts, data flow diagrams and support documents with detailed description of each new module.
- Creating star schema data models, performing ETLs and validating results with business analyst.
- Designing Business Objects Universe and creating Webi Reports.
- Managing BO Administration activity like server management, creating user profile and access rights etc.
- Building SSIS packages for loading data from different sources like excel files, flat files, SQL server etc.
- Designing analysis reports using SQL server reporting services.
- Creating Autosys jobs and scheduling process for ETL.
- Maintaining and enhancing Informatica ETL workflows.
- Writing and tuning complex SQL, stored procedures and triggers in SQL Server.
- Created new applications using .Net BO APIs, Mult-Threading, Processes, events and windows services like Server Monitor tool and automated server rebooting process.
- Maintaining and enhancing existing .Net applications by adding new features to help monitoring data loads.
- Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
Environment: SQL Server 2005/2008, SSIS, Informatica, SSRS, Business Objects Universe Design, Webi Reporting, CMS Management, C#.Net, ADO.Net, XML, ASP.Net, Business Objects .Net SDK.