Senior Msbi Developer Resume
NJ
SUMMARY
- 13+ years of IT experience with strong SQL Server Database development and Administration.
- Experience in logical and physical data modeling including defining database tables and indexes, referential integrity, constraints etc on those.
- Expert in Database Design and data interaction process between Web server and Database server.
- Experience in designing dimensional data modeling using cubes in SSAS.
- Possess SQL Server Developer skills including writing DB scripts, Query writing, stored procedures and views.
- Good experience in Designing and Creating BI (Business Intelligence) projects.
- Hands on Experience in designing, implementing and maintaining data warehouse applications.
- Experience in Object Oriented Analysis concept implementation, design and programming technical skills.
- Experience in handling global development team, multiple tasks and capable of handling responsibilities independently.
- Having experience in working all phases of the Software development life cycle.
- Good amount of experience in utilizing ETL tools; SSIS (SQL Server Integration Services) and DTS (Data Transformation Services).
- Good experience in creating SQL server Analysis Projects (SSAS) using SQL Server 2000/2005/2008.
- Expertise in tabular, matrix, score cards and dash board reports using MS SQL server reporting services (SSRS).
- Experience in Administrator tasks like installation of MS SQL Server 2008/2005/2000 , performance analysis, tuning, capacity planning, implementing backup and recovery strategy for application and database.
- Expertise in using Visual Source safe (VSS) as version control tool.
- Expertise in creating complex reports using Crystal reports Business Objects reporting tools.
- Experienced in handling Web based Intranet/Internet application using ASP, HTML, VB Script and JavaScript in IIS / MS FrontPage / Visual Interdev environment.
TECHNICAL SKILLS
OS: Windows 2000, Windows Server 2003, Windows server 2008
Databases: SQL Server 2008/2005/2000 , PL/SQL, Oracle 11g/8.0i, Microsoft Access 2000/8.0
Languages: C#.Net, VB.Net, XML, ASP.NET, T - SQL
Scripting Languages: HTML, XML, Java Scripting, VB Scripting
Web Tools: C#.Net, ASP.Net,VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script
ETL & Reporting: SSRS 2005/2008, SSIS 2005/2008, Power BI
Hardware: IIS 6.0/5.0/4.0
Version & Defect Control: Microsoft TFS, MS VSS, Synergy, HP Quality Center & Jira
Others: MS Office, Erwin, Crystal Reports XI, Visio, Microsoft Business Intelligence Studio, Service Oriented Architecture (SOA) SQL Server Notification Services, SQL Server 2000/2005 Analysis Services (SSAS), Visual web developer, MS FrontPage, Windows Scripting Host
PROFESSIONAL EXPERIENCE
Confidential, NJ
Senior MSBI Developer
Responsibilities:
- Involved in complete redesign of GRE® score report.
- Designed Power BI interactive dash board reports for the test takers data by regions, tests.
- Designed parameterized BI reports using Power BI.
- Written Data Analysis Expressions for Power BI for the test data analysis by creating calculated columns.
- Added many new logics for the GRE® program including handling of different percentile scores for the subjects and additional sub scores for the subjects like Psychology.
- Designed tables and created reports for the new program, PDQ (Prose, Document and Quantitative literacy).
- Enhanced the business logic for the Workforce reports by adding additional functionality and business rules.
- Adding new SSRS image controls for the GRE® for better display of scores and the min and max ranges.
- Modifying many other K-12 statewide assessment tests for the states like Texas, California and Wyoming etc.;
- Redesigned the K-12 reports for the additional year scores display.
- Working on modifying existing TOEFL® test reports and adding new reports called RPDT (Revised Paper Development Test) and NPBT (New Paper Based Test).
- Designing SSIS package to load the score data received from the upstream to process the data and generate the report per request basis.
Confidential, Berkeley Heights, NJ
Senior SQL Server Analyst
Responsibilities:
- Creating tables, procedures, views and triggers for business needs.
- Modifying tables and .ctl files in accordance with the source file changes.
- Gathering requirements from the sales team then building reports using SSRS.
- Creating score card reports for the drug sales, sales personnel performance.
- Developing sales projection screens for the business using C#.net and ASP.net.
- Designed tabular/charts reports with the sales projection data.
- Managing reports security across the organization with folder level and report level permissions.
- Creating SSRS email subscriptions for the onsite sales team.
- Creating the subscriptions to store the reports to shared folders where the business can access them.
- Designing SSIS packages for the daily and weekly data loads and scheduling them using SQL agent.
- Modifying SSIS packages for business logic enhancements.
- Writing/modifying VB scripts for sales file moments and data loads.
- Writing/modifying batch files to kickoff the SSIS packages from the windows environment.
- Designing .CTL files to load the data into database tables using flat files as the source.
- Creating VB script files to manage the daily and weekly file feeds and their names then move the historic files to archive folder.
- Migrating SSIS packages from visual studio shell.
- Modifying vb script files for enhanced business logic.
Confidential, New York
SQL Server Analyst/BI, SQL Developer
Responsibilities:
- Implementing business logic of Prime Services group by creating stored procedures.
- Creating reports for Funded Assets, ReHypo, and Secured Funding balance using SSRS 2008.
- Designing packages for the business date data loads from across the globe using SSIS 2008.
- Writing VB Script code for managing different business dates in different countries.
- Writing logic to decide the most profitable funds across the multiple regions like Americas, Europe, APAC etc;
- Creating yearly reports so that the switched account performance can be compared.
- Conversion of SSRS reports from .
- Using timely subscriptions for the report delivery to the business.
- Resolving the tickets assigned to MIX support team.
- Creating tables, views, stored procedures and indexes using T-SQL.
- Designing reports to export the data to various data sources like Excel, XML, Acrobat PDF and CSV formats.
- Creating database triggers to maintain the business rules.
Confidential, NY
SQL Server Reporting Analyst/BI, SQL Developer
Responsibilities:
- Writing PL/SQL packages/Procedures for the new business logic.
- Designing SSIS packages for the data extraction and modification for customer service portal data sent from multiple meeting locations across USA.
- Creating sub reports and linked reports for the business.
- Designing YTD matrix reports for the business using SSRS 2008.
- Enhancing existing reports look and feel using the latest version of SSRS.
- Developing web pages for the membership comparison reports in C#.net and ASP.net.
- Developed client validation scripts using Java script.
- Modifying packages to take care of the new membership rules.
- Writing custom VB script to provide the values for the parameters of daily/weekly reports.
- Using SQL server 2005 as well as Oracle 10G as backend for SSRS reports
- Using timely subscriptions for the report delivery to the business.
- Resolving the tickets assigned to engineering services group through service now.
- Checking the reports and database scripts to IBM Rational Synergy (version control tool).
- Writing scripts to create tables, views, stored procedures, indexes etc.
- Designing reports to export the data to various data sources like Excel, XML, Acrobat PDF and CSV formats.
- Writing math functions in VB Script for calculating Gym Commissions and Sales Consultant Commissions.
Confidential, Jersey City, NJ
SQL Server BI Analyst
Responsibilities:
- Designing and coding multiple reconciliations like Arctic/CS, RAM Notional, Genesis Notional Etc;
- Designing reports using SQL Server Reporting Services 2008 for keeping track of recon stats like recon run times, schedules and run times etc;
- Designing SSIS packages for the data extraction and transformation while looking up the data with golden source.
- Writing stored procedures for multiple business requirements across credit risk/market risk sources.
- Designing ETL process to load the data from golden sources using packages designed in SQL server Integration Services 2008.
- Developing distinct business logic for MTMs and Notional across various sources.
- Query tuning for the better performance of the reconciliations.
- Monitoring recon runs and debugging failures if there are any.
- Automation of report generation using data driven as well as regular subscriptions.
- Designing multiple filter and categories to place the breaks/matches in correct buckets
- Resolving the bugs assigned in Jira tool.
- Checking the Table scripts, procedures, views, reports and database scripts to Microsoft TFS (Team Foundation Server), version control tool.
- Designing reports to export the data to various data sources like Excel, XML, Acrobat PDF and CSV formats.
Confidential, NY
SQL Server 2008/2005 SSRS, SSIS, Oracle 10G Developer
Responsibilities:
- Designed more than 300 reports for different divisions of Confidential like BOSS, Call Center, Community, Corporate Solutions Portal, Marketing, National Accounts, Quality Center and Store.
- Designing reports using SQL Server Reporting Services 2008/2005 for different operating countries of Confidential like USA, Canada, France, UK, Australia, China Etc.
- Creating SSIS packages for meeting data extraction and loading to data ware house.
- Writing queries for the SSRS reports based on the business requirements.
- Using SQL server 2005 as well as Oracle 10G as backend for SSRS reports
- Query tuning for the better performance for the reports.
- Using external tables as the source for Oracle tables and then writing the reports on top of those tables.
- Automation of report generation using data driven as well as regular subscriptions.
- Writing custom VB Script for the reports for date range requirements like last Sunday to Saturday, last week, last month, fiscal month, fiscal quarter Etc.
- Resolving the tickets assigned to engineering services group through Quality Center.
- Checking the reports and database scripts to IBM Rational Synergy (version control tool).
- Writing scripts to create tables, views, stored procedures, indexes etc.
- Designing reports to export the data to various data sources like Excel, XML, Acrobat PDF and CSV formats.
- Writing math functions in VB Script for calculating Gym Commissions and Sales Consultant Commissions.
Confidential, Forest Hills, NY
SQL Server 2008/2005 SSRS, SSIS, SSAS Developer
Responsibilities:
- Writing SQL scripts for adding new cities and new routes for JetBlue. Blue Cities added by me are the following: Puntacana (PUJ), Hartford (BDL) and Washington Reagan (DCA).
- Developing AQP (Advanced Qualification Programming) reports for pilot training activities using SQL Server Reporting Services 2008 for FAA analysis.
- Designing packages using SSIS 2008 for importing in flight entertainment data from LIVE TV (Division of JetBlue based in Melbourne, FL) and writing reports on the same data for revenue analysis.
- Involved in migration for CSS cutover when Sabre took over Navitire for passenger data.
- Importing Cashless Cabin data using SSIS 2008 package for analyzing in flight sales data.
- Writing packages to import pilot laptop data for OPS Data drain application using SSIS 2005.
- Resolving the tickets assigned to IT Data Services Group.
- Writing scripts to created tables, views, stored procedures, indexes etc.
- Designed SSIS packages to export and import data from various data sources like OLEDB SQL, Access, Flat files (Comma and Pipe Delimited) and EXCEL files.
- Involved in performance tuning for the report queries.
- Handling periodic Data Migration using various scheduled jobs.
- Used Report Manager to schedule and manage the subscription of reports to various users.
Environment: SQL Server 2005, SQL Server 2000, MS SQL Server Reporting Services 2008, 2005(SSRS), Microsoft Business Intelligent Studio, Business Objects (Crystal Reports XI), MS EXCEL 2003, MS Access 2003, SQL Server Integration Services (SSIS), SQL Server 2000 DTS, MS SQL Query Analyzer, UNIX, C#, ASP.NET, SQL Profiler, Windows 2003 Server, Oracle 11g, Share Point Portal Server, Visual Source Safe and Visual Studio.Net 2005, XML, MS Office 2007, VB Script.
Confidential, Nutley, NJ
SQL Server 2005 SSIS, SSRS, SSAS Developer
Responsibilities:
- Created DB objects like tables, views, stored procedures, indexes etc.
- Gathered requirements from the users to build transactional Data warehouse Database.
- Involved in logical and physical data model design using Erwin.
- Designed and developed ETL specifications and code to design data warehouse for source systems.
- Creating OLAP cubes for sales data under management using analysis services (SSAS) 2005.
- Writing Multi Dimensional Expression (MDX) queries on cubes.
- Executed Business Intelligence solutions including ETL (SSIS), OLAP and Reporting (SSRS) requirements.
- Efficiently used SSIS to build Data warehouse and also load data files.
- Designing SSIS packages to export and import data from various data sources like Access, text and EXCEL files.
- Modifying data types during data loads using SSIS.
- Migrated SQL server 2000 DTS Packages to SQL 2005 SSIS packages.
- Providing support to web application features built in ASP.NET, ADO.NET and Cascading Style sheets (CSS).
- Assisted Web team in developing the Custom Parameter tool in .Net for providing the predefined set of parameters to the Business Objects scheduled on Business.
- Fixing crystal report issues and implementing the same changes in reports designed in SSRS.
- Involved in Query tuning, procedure response time optimization using SQL profiler.
- Handling periodic Data Migration using various scheduled jobs.
- Providing access to multiple database servers.
- Used Report Manager to schedule and manage the subscription of reports to various users.
