Msbi Developer Resume
0/5 (Submit Your Rating)
Tampa, FloridA
SUMMARY
- Over 7+ years of professional experience in System Analysis, OLTP System Design and development, ETL Design & Development, BI/DW, Data Migration and customer interfacing .
- Worked extensively inSQL Server 2005, 2008 &2012.
- Schemas like Star Schema and Snowflake Schema used inrelational and dimensional modeling.
- Worked extensively inSQL Server 2005, 2008 &2012.
- Worked on tuning areas likeOptimizing the SSIS Packages, Optimizing / tuning the databases design and queries.
- Design and develop store procedures, configuration files, tables, and views; implement best practices to maintain optimal performance.
- Extensive knowledge onData warehousing conceptsandDimensional Modeling.
- Technical Documentation for DW application.
- Agile and Waterfall SDLC Process.
- Proficient in implementing all transformations available on the SSIS toolbox.
- Working with Remote Team.
TECHNICAL SKILLS
Languages: SQL server 2014, 2012, 2008, T - SQL, Microsoft VB, Microsoft C++, metadata repository.
Analysis Tool: SSAS
Reporting tools: SSRS
RDBMS: SQL Server, PostgreSQL, MS-access
ETL tool: SSIS
IDE Tools: BIDS, SSMS,Excel 2010 with Power Pivot, share point, TFS.
PROFESSIONAL EXPERIENCE
Confidential
MSBI developer
Responsibilities:
- Creating packages and maintaining ETL jobs every day.
- Worked on T-SQL concepts like indexes, function, join etc., and also wrote dynamic stored procedure scripts.
- Tuning jobs to minimize the runnable time.
- Also worked on many SSIS transformations.
- Delivering updates and supporting off shore people.
- Ability to code and troubleshoot ETL logic, both TSQL and SSIS.
- DB fundamentals, indexes, create tables, create scripts.
- Ability to validate data, test and confirm code written met specification.
- Understanding of conformed dimensions and facts
Confidential
SSIS developer
Responsibilities:
- Creating tables, running ETL jobs, writing dynamic scripts to generate stored procedure, creating tables etc..,
- Creating packages in the solution explorer (In EXTRACT, TRANSFORM AND LOAD) and writing SQL query in data flow task, creating variable, error handling process and writing functions.
- Creating project parameters for different regions. And maintaining package logs by SQL server in SSISDB database .query in internal packages table in SSISDB to view execution performance, analyze performance and tracking logging message of the execution.
- Describing environments names from which data is coming.
- Deploying the packages in the solution explorer to catalog which is in management studio.
- Testing the table in DW to load data to catch many errors like data type violation, NULL constraint violation, foreign key violation and duplicate data.
- Generating reports to maintain zero percent error’s in all the data warehouse tables.
- Writing quires to dynamically generated stored procedure, creating table and also catching errors.
- Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
- Wrote SSIS Packages to migrate user's logins, stored procedures, and functions.
- Involved in designing the SSIS packages to export data from SQL Server database to flat file source.
- Effectively loaded data into relational database using ETL tool.
- Designed Graphical and Tablix reports using SSRS.
- Tested different types of reports before moving it to the production
- Wrote SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
- Performed SQL Server tools like SQL Performance optimization using SQL Server Profiler and Database Engine Tuning Advisor.
- Worked with Team Foundation Server(TFS), perforce as the source for version control and project/issue management
Confidential
SSIS developer
Responsibilities:
- Developing SSIS package based on Business
- Rules Implemented SQL SERVER and XML SSIS configuration.
- Migrating the packages from DTS to SSIS
- Writing Complex Stored procedures
- Design and developed various types of SSRS Reports
- Involved in SSIS Package maintenance.
- Developed automation tools to improve project productivity. Developed a tool in SSIS and compared two Dimensional database tables or view based on their given column combination and find the duplicate entry in that view or table, also found Null value for the given table and generated an report.
- Developed a tool in SSIS and automated the documentation work as per business rule.
- Worked on Partition Logic for the Detail and Event Segment. This Logic enhanced the performance by decreasing the time taken for processing the data.
- Preparing Dashboard reports based on the performance of servers.
Confidential
SSIS developer
Responsibilities:
- Monitoring the ETL and Reports running in the production environment
- SSRS report related issues hot fix.
- Fixing SSIS packages.
- Improve and optimize the SSRS report.
- Performance by fine tuning the SQL Queries.
- Tracker excels for resource management and production management.
- Involved in SSIS Package maintenance activities.
Confidential, Tampa, Florida
Senior developer
Responsibilities:
- Involved in Claims Processing Extract and loading to Data Warehouse.
- Involved in the design of the Data warehouse in the Stare schema architecture
- Designing the SSIS ETL packages
- Implementing various staging database and the final warehouse
- Creating SSRS reports out of the warehouse
- Scheduling the package to run on daily basis to get data from the source system
- ETL and Reports Deployment
- Using the share point to maintain the records of the data.
- Writing complex stored procedure to perform logical operations.
- Involved in Planet press design for the document management process like enabling to create new documents regarding the transactional details orenhance existing ones, capturing the data and optimizing the data.
Confidential
DW/ Data Architect, Data Mart Developer
Responsibilities:
- Analyze the requirement and design the high-level user interface and database.
- Designed the applications in the data model using normalization process up to 3NF.
- Identified redundant programming functionality and developed reusable ActiveX controls
- Worked on exporting graphical reports to Excel.
- For version control and sharing file utilized MS Visual Source-safe.
- Implemented query optimization techniques to improve the SQL Performance.
- Development of Stored Procedures as per the given Business Rules.
Confidential
Sql developer
Responsibilities:
- Finding solution if any Daily ETL job fails
- Providing permanent fixes for production failures.
- Fixing SSIS packages if any issue found in Production environment
- Involved in various SSRS report generation
- Involved in fixing any problem in existing reports and stored procedures
- Involved in fixing Physician key fuzzy lookup data issue
- Improve and optimize ETL job’s performance and ensure that the job execution time is reduced
- Data analysis and correction
- Improve performance of SSRS reports
- Involved in SSIS Package maintenance and Scheduling through SQL SERVER AGENT.
